Hello everyone! I have recently came across a weird issue with the CDR module, where it just stopped recording calls.
When I logged on to the VM's shell, I saw I have new mail, in it was this:
From root@VOIP.localdomain Sat Jan 11 22:14:01 2025
Return-Path: <root@VOIP.localdomain>
X-Original-To: root
Delivered-To: root@VOIP.localdomain
Received: by VOIP.localdomain (Postfix, from userid 0)
id DAF0D3C6D81; Sat, 11 Jan 2025 22:14:01 +0200 (IST)
From: root@VOIP.localdomain (Cron Daemon)
To: root@VOIP.localdomain
Subject: Cron <root@VOIP> /usr/bin/php /var/www/fusionpbx/app/xml_cdr/xml_cdr_import.php 300
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 8bit
X-Cron-Env: <SHELL=/bin/sh>
X-Cron-Env: <HOME=/root>
X-Cron-Env: <PATH=/usr/bin:/bin>
X-Cron-Env: <LOGNAME=root>
Message-Id: <20250111201401.DAF0D3C6D81@VOIP.localdomain>
Date: Sat, 11 Jan 2025 22:14:01 +0200 (IST)
SELECT xml_cdr_json_uuid, xml_cdr_uuid, domain_uuid, json FROM v_xml_cdr_json WHERE xml_cdr_json_uuid = '9038f713-952d-4415-909e-b2a1c9ef647e'; <br />
Caught exception: SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: current transaction is aborted, commands ignored until end of transaction block<br /><br />
SELECT xml_cdr_json_uuid, xml_cdr_uuid, domain_uuid, json FROM v_xml_cdr_json WHERE xml_cdr_json_uuid = '9038f713-952d-4415-909e-b2a1c9ef647e'; <br /><br />
From what I can tell, there is some sort of problem with postgres.
There is no other problem in the system and everything else works.
I'll be glad for help if anyone has experience with this problem
Specs:
OS: Debian 12
Proxmox VM
6GB RAM
128GB VDisk
Thanks!!
When I logged on to the VM's shell, I saw I have new mail, in it was this:
From root@VOIP.localdomain Sat Jan 11 22:14:01 2025
Return-Path: <root@VOIP.localdomain>
X-Original-To: root
Delivered-To: root@VOIP.localdomain
Received: by VOIP.localdomain (Postfix, from userid 0)
id DAF0D3C6D81; Sat, 11 Jan 2025 22:14:01 +0200 (IST)
From: root@VOIP.localdomain (Cron Daemon)
To: root@VOIP.localdomain
Subject: Cron <root@VOIP> /usr/bin/php /var/www/fusionpbx/app/xml_cdr/xml_cdr_import.php 300
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 8bit
X-Cron-Env: <SHELL=/bin/sh>
X-Cron-Env: <HOME=/root>
X-Cron-Env: <PATH=/usr/bin:/bin>
X-Cron-Env: <LOGNAME=root>
Message-Id: <20250111201401.DAF0D3C6D81@VOIP.localdomain>
Date: Sat, 11 Jan 2025 22:14:01 +0200 (IST)
SELECT xml_cdr_json_uuid, xml_cdr_uuid, domain_uuid, json FROM v_xml_cdr_json WHERE xml_cdr_json_uuid = '9038f713-952d-4415-909e-b2a1c9ef647e'; <br />
Caught exception: SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: current transaction is aborted, commands ignored until end of transaction block<br /><br />
SELECT xml_cdr_json_uuid, xml_cdr_uuid, domain_uuid, json FROM v_xml_cdr_json WHERE xml_cdr_json_uuid = '9038f713-952d-4415-909e-b2a1c9ef647e'; <br /><br />
From what I can tell, there is some sort of problem with postgres.
There is no other problem in the system and everything else works.
I'll be glad for help if anyone has experience with this problem
Specs:
OS: Debian 12
Proxmox VM
6GB RAM
128GB VDisk
Thanks!!