Hi,
This might not be directly Siremis-related, but in any case it is a consequence of using Siremis:
The stored procedure for calculating and populating the 'cdrs' table has started to act out all of a sudden - it won't do anything. In my syslog it looks like this:
May 29 09:24:01 vae /USR/SBIN/CRON[25555]: (root) CMD (echo "call kamailio_cdrs();"|/usr/bin/mysql -u root -pxxx kamailio >/dev/null) May 29 09:24:23 vae /USR/SBIN/CRON[25548]: (CRON) error (grandchild #25549 failed with exit status 1) May 29 09:24:23 vae /USR/SBIN/CRON[25548]: (CRON) info (No MTA installed, discarding output)
..and that's every time the cron job runs, the only thing that changes is the "grandchild" number. I have no clue what "grandchild" means in this context - ...anyone?
Thanks!!
//Anders
Adding to the below issue, if I run it directly at the prompt I get this:
vaerge:/# echo "call kamailio_cdrs();" | /usr/bin/mysql -u root -pxxx kamailio > /dev/null ERROR 1062 (23000) at line 1: Duplicate entry '170ed88952687b2a52ad0d0c1213913f@sipbr.kom1.com.br-as60f02d8a-34' for key 'uk_cft'
On Sat, May 29, 2010 at 12:19 PM, Anders vaerge@gmail.com wrote:
Hi,
This might not be directly Siremis-related, but in any case it is a consequence of using Siremis:
The stored procedure for calculating and populating the 'cdrs' table has started to act out all of a sudden - it won't do anything. In my syslog it looks like this:
May 29 09:24:01 vae /USR/SBIN/CRON[25555]: (root) CMD (echo "call kamailio_cdrs();"|/usr/bin/mysql -u root -pxxx kamailio >/dev/null) May 29 09:24:23 vae /USR/SBIN/CRON[25548]: (CRON) error (grandchild #25549 failed with exit status 1) May 29 09:24:23 vae /USR/SBIN/CRON[25548]: (CRON) info (No MTA installed, discarding output)
..and that's every time the cron job runs, the only thing that changes is the "grandchild" number. I have no clue what "grandchild" means in this context - ...anyone?
Thanks!!
//Anders
-
Anders