ERROR: db_mysql [km_dbase.c:122]: driver error on query: Lost connection to MySQL server during query
Mar 18 20:03:38 net-ivr-KamIN-J1 /usr/local/sbin/kamailio[2671]: ERROR: <core> [db_query.c:186]: error while submitting query
Mar 18 20:03:38 net-ivr-KamIN-J1 /usr/local/sbin/kamailio[2671]: ERROR: acc [acc.c:405]: failed to insert into database

Whe apears, from time to time, for some of them. it can rest for 2-10 hours, then have a "glitch" of 160 sql driver errors, and rest again....

On Tue, Mar 20, 2012 at 11:51 AM, Daniel-Constantin Mierla <miconda@gmail.com> wrote:

Hello,

On 3/20/12 10:11 AM, Uri Shacked wrote:

Hi,

I am using the ACCDB with extra data. I collect the data to AVP's and set it on the db_extra. It gets to be 37 columns…. Pretty long…

The problem I experience is that after a while (2-3 hours) with about 15 CAPS the MySQL ACC insert error appears.

And, I am loosing accounting data.
what are the errors? Once they appear, is it for all records or just from time to time, to some of them?

Cheers,
Daniel
Except of narrowing the amount of columns and setting the fields (INT,CHAR etc.), does anyone has any ideas?

The db_insert_mode set to 1 does not work (my ACC table is INNODB because I don’t want to lose info).

BR,

Uri
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
-- Daniel-Constantin Mierla Kamailio Advanced Training, April 23-26, 2012, Berlin, Germany http://www.asipto.com/index.php/kamailio-advanced-training/