no log on the msqld for it. there is the CDR server that collects the events every 5 min and deletes old once... i disabled it becoase i believed it was it. but, no.... the error apears again... a BI specialist told me it must have something to do with the number of columns and the data type...
On Tue, Mar 20, 2012 at 12:06 PM, Daniel-Constantin Mierla < mico...@gmail.com> wrote: > 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 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/ >> >> > > -- > 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
