Page 1 of 1

Realtime report carrier stats stop incrementing

PostPosted: Fri Jan 22, 2016 5:45 pm
by ccabrera
A system I just got my hands on suddenly stopped incrementing the carrier stats. As you can see in the picture, 24 hours ago the stats where getting counted. Now they aren´t.

Image

Server is a stock Vicibox 6.0.3, running Asterisk 1.8.32 and Vicidial 2.12-514a BUILD: 150928-1817. Database and dialer are on 2 different servers.

Dialer server was rebooted today, so all the vicidial scripts should be back and running.

I´m also experiencing lots and lots of LRERR in this server, so maybe if I find what´s causing the carrier stats problem, it can give me some light on the LRERR.

Regards,

Re: Realtime report carrier stats stop incrementing

PostPosted: Fri Jan 22, 2016 7:52 pm
by mflorell
Could be corrupted database tables.

Re: Realtime report carrier stats stop incrementing

PostPosted: Fri Jan 22, 2016 8:03 pm
by ccabrera
I checked that. Running a "select * from asterisk.vicidial_carrier_log limit 10;" gives me data, not an error. I also ran a mysqlcheck --auto-repair today at 0:00, so if anything was broken, should be repaired now.

Re: Realtime report carrier stats stop incrementing

PostPosted: Fri Jan 22, 2016 9:11 pm
by mflorell
Is the vicidial_carrier_log table getting new entries as you dial?

Re: Realtime report carrier stats stop incrementing

PostPosted: Fri Jan 22, 2016 10:04 pm
by ccabrera
Just a few. The ones that are inserted match the ones the report shows, so the problem is that the entries are not getting into the table. What process is the one that populates the table?

Re: Realtime report carrier stats stop incrementing

PostPosted: Fri Jan 22, 2016 11:33 pm
by mflorell
There are several processes that insert into that table. Do you have the carrier logging enabled in system settings? You might also want to check that your dialplan entries have the proper call_log agi and 'h' hangup agi entries.