[SR-Users] ACCDB insert issues

[Uri Shacked]

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> 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-users at 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/
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20120320/d0c431a0/attachment.htm>