[SR-Users] ACCDB insert issues

[Uri Shacked]

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 <
miconda at 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 <
> 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/
>>
>>
>
> --
> 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/9ae9819d/attachment-0001.htm>