Hi Bogdan,<div>Is it somehow possible to disable the support of prepared statements for acc module in opensips 1.5.1.</div><div>I suspect this to be a problem with Mysql also and I wanted to check by disabling the support for prepared statements.</div>
<div><br></div><div>--- Jayesh<br><br><div class="gmail_quote">On Tue, May 26, 2009 at 9:28 PM, Bogdan-Andrei Iancu <span dir="ltr"><<a href="mailto:bogdan@voice-system.ro">bogdan@voice-system.ro</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">Hi Jayesh,<br>
<br>
If I prepared some patch to give more info on this error, are you willing to test it ?I was not able to reproduce it.<br>
<br>
Regards,<br>
Bogdan<br>
<br>
Jayesh Nambiar wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div></div><div class="h5">
<br>
Hello All,<br>
<br>
<br>
I came across this problem of entries not getting entered into the ACC properly twice or thrice in last two months since I upgraded to Opensips 1.5. It so happens that inserts are done but many inserts are missed out. The error observed in the logs are as follows:<br>
ERROR:db_mysql:db_mysql_do_prepared_query: mysql_stmt_bind_param() failed: Using unsupported buffer type: 22 (parameter: 15)<br>
ERROR:acc:acc_db_request: failed to insert into database<br>
ERROR:db_mysql:db_mysql_do_prepared_query: mysql_stmt_bind_param() failed: Using unsupported buffer type: 17 (parameter: 15)<br>
ERROR:acc:acc_db_request: failed to insert into database<br>
<br>
The error stops after I restart my Mysql server and then my Opensips. After I restart it works well for a period of 8-10 days and after that I again observe the same errors.<br>
Can someone please help to debug this. I have downgraded my Opensips to 1.4.5 because of this being repeated.<br>
<br>
Thanks in Advance !!<br>
<br>
--- Jayesh<br></div></div>
------------------------------------------------------------------------<br>
<br>
_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
<br>
</blockquote>
<br>
</blockquote></div><br></div>