Do you have error messages in mysql server logs? Is there another application that may block the acc table?
The error refers to unavailability of the mysql server...
Cheers,
Daniel
On 3/20/12 11:03 AM, Uri Shacked wrote: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 databaseWhe 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,what are the errors? Once they appear, is it for all records or just from time to time, to some of them?
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.
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/
-- Daniel-Constantin Mierla Kamailio Advanced Training, April 23-26, 2012, Berlin, Germany http://www.asipto.com/index.php/kamailio-advanced-training/