Hi,
Thanks.
when i changed to myisam engine (after reading a little) the error stoped
even on a very high number of CAPS.
i will try to use the db_insert_mode = 1 to increase the speed of the
transaction.
BR,
Uri
Hi
I've also seen this error
"ERROR: acc [acc.c:405]: failed to insert into databas
records so I didn't chase it further. But would be
nice if we could stop/handle the duplicated entries some how.
Not a fix at at all, just some clues that might help.
Yufei
Message: 5
Date: Wed, 21 Mar 2012 20:28:33 +0200
From: Uri Shacked
Subject: Re: [SR-Users] ACCDB insert issues
To: &
Well, after some experiments...
Two things made the difference:
1. Use only the id as Pkey and remove all other indexes (helped a little).
2. Set myisam engine to the table (i knew that but tried innodb for its
reliability)
Now we are back in order to deal with many, many CAPS.
Thanks,
If s
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...
O
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
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:
[db_query.c:186]: error while submitting query
Mar 18 20:03:38 net-ivr-KamIN-J1 /usr/local/sbin/kamailio[2671]: ERROR: acc
[
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 er
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.
Except
