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(a)sipbr.kom1.com.br-as60f02d8a-34' for
key 'uk_cft'
On Sat, May 29, 2010 at 12:19 PM, Anders <vaerge(a)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