[SR-Users] ACCDB insert issues

[Daniel-Constantin Mierla]

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 
> <miconda at gmail.com <mailto:miconda at 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 at lists.sip-router.org  <mailto:sr-users at 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/

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20120320/8cf7d60b/attachment.htm>