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 < mico...@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 > listsr-us...@lists.sip-router.orghttp://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users > > > -- > Daniel-Constantin Mierla > Kamailio Advanced Training, April 23-26, 2012, Berlin, > Germanyhttp://www.asipto.com/index.php/kamailio-advanced-training/ > >
_______________________________________________ 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
