<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Do you have error messages in mysql server logs? Is there another
application that may block the acc table?<br>
<br>
The error refers to unavailability of the mysql server...<br>
<br>
Cheers,<br>
Daniel<br>
<br>
On 3/20/12 11:03 AM, Uri Shacked wrote:
<blockquote
cite="mid:CAMMbDhQsust8xezqXDkeuyfH+f-21hg_bgctqH9_W1gG=rtCcg@mail.gmail.com"
type="cite">
<div dir="ltr">
<div>ERROR: db_mysql [km_dbase.c:122]: driver error on query:
Lost connection to MySQL server during query<br>
Mar 18 20:03:38 net-ivr-KamIN-J1
/usr/local/sbin/kamailio[2671]: ERROR: <core>
[db_query.c:186]: error while submitting query<br>
Mar 18 20:03:38 net-ivr-KamIN-J1
/usr/local/sbin/kamailio[2671]: ERROR: acc [acc.c:405]: failed
to insert into database</div>
<div> </div>
<div>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....</div>
<div> </div>
<div><br>
</div>
<div class="gmail_quote">On Tue, Mar 20, 2012 at 11:51 AM,
Daniel-Constantin Mierla <span dir="ltr"><<a
moz-do-not-send="true" href="mailto:miconda@gmail.com">miconda@gmail.com</a>></span>
wrote:<br>
<blockquote style="BORDER-LEFT:#ccc 1px solid;MARGIN:0px 0px
0px 0.8ex;PADDING-LEFT:1ex" class="gmail_quote">
<div text="#000000" bgcolor="#FFFFFF">Hello,
<div class="im"><br>
<br>
On 3/20/12 10:11 AM, Uri Shacked wrote:
<blockquote type="cite">
<div dir="ltr">
<p style="LINE-HEIGHT:normal;MARGIN:0cm 0cm 0pt"
class="MsoNormal"><span>Hi,</span></p>
<p style="LINE-HEIGHT:normal;MARGIN:0cm 0cm 0pt"
class="MsoNormal"><span> </span></p>
<p style="LINE-HEIGHT:normal;MARGIN:0cm 0cm 6pt"
class="MsoNormal"><span>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…</span></p>
<div style="LINE-HEIGHT:normal;MARGIN:0cm 0cm 6pt"
class="MsoNormal"><span>The problem I experience
is that after a while (2-3 hours) with about 15
CAPS the MySQL ACC insert error appears. </span></div>
<div style="LINE-HEIGHT:normal;MARGIN:0cm 0cm 6pt"
class="MsoNormal"><span>And, I am loosing
accounting data.</span></div>
</div>
</blockquote>
</div>
what are the errors? Once they appear, is it for all
records or just from time to time, to some of them?<br>
<br>
Cheers,<br>
Daniel<br>
<br>
<blockquote type="cite">
<div class="im">
<div dir="ltr">
<div style="LINE-HEIGHT:normal;MARGIN:0cm 0cm 6pt"
class="MsoNormal"><span> </span></div>
<p style="LINE-HEIGHT:normal;MARGIN:0cm 0cm 6pt"
class="MsoNormal"><span>Except of narrowing the
amount of columns and setting the fields
(INT,CHAR etc.), does anyone has any ideas?</span></p>
<p style="LINE-HEIGHT:normal;MARGIN:0cm 0cm 6pt"
class="MsoNormal"><span> </span></p>
<p style="LINE-HEIGHT:normal;MARGIN:0cm 0cm 6pt"
class="MsoNormal"><span>The db_insert_mode set to
1 does not work (my ACC table is INNODB because
I don’t want to lose info).</span></p>
<p style="LINE-HEIGHT:normal;MARGIN:0cm 0cm 6pt"
class="MsoNormal"><span> </span></p>
<p style="LINE-HEIGHT:normal;MARGIN:0cm 0cm 6pt"
class="MsoNormal"><span>BR,</span></p>
<p style="LINE-HEIGHT:normal;MARGIN:0cm 0cm 6pt"
class="MsoNormal"><span>Uri</span></p>
</div>
<br>
<fieldset></fieldset>
<br>
</div>
<pre>_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a moz-do-not-send="true" href="mailto:sr-users@lists.sip-router.org" target="_blank">sr-users@lists.sip-router.org</a>
<a moz-do-not-send="true" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users" target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><span class="HOEnZb"><font color="#888888">
</font></span></pre>
<span class="HOEnZb"></span></blockquote>
<span class="HOEnZb"><font color="#888888"><br>
<pre cols="72">--
Daniel-Constantin Mierla
Kamailio Advanced Training, April 23-26, 2012, Berlin, Germany
<a moz-do-not-send="true" href="http://www.asipto.com/index.php/kamailio-advanced-training/" target="_blank">http://www.asipto.com/index.php/kamailio-advanced-training/</a></pre>
</font></span></div>
</blockquote>
</div>
<br>
</div>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Daniel-Constantin Mierla
Kamailio Advanced Training, April 23-26, 2012, Berlin, Germany
<a class="moz-txt-link-freetext" href="http://www.asipto.com/index.php/kamailio-advanced-training/">http://www.asipto.com/index.php/kamailio-advanced-training/</a></pre>
</body>
</html>