21 Mar
2012
21 Mar
'12
7:28 p.m.
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 someone has another idea, and uses innodb for the ACC. please advise...
BR,
Uri
On Tue, Mar 20, 2012 at 12:22 PM, Uri Shacked <ushacked(a)gmail.com> wrote:
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(a)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(a)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@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/