Realtime report carrier stats stop incrementing

[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.



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,

[mflorell]

Could be corrupted database tables.

[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.

[mflorell]

Is the vicidial_carrier_log table getting new entries as you dial?

[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?

[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.