[OpenSIPS-Users] Opensips 1.5 and MySQL error

Jayesh Nambiar jayesh.voip at gmail.com
Fri Jun 5 16:34:37 CEST 2009


Hi Bogdan,Is it somehow possible to disable the support of prepared
statements for acc module in opensips 1.5.1.
I suspect this to be a problem with Mysql also and I wanted to check by
disabling the support for prepared statements.

--- Jayesh

On Tue, May 26, 2009 at 9:28 PM, Bogdan-Andrei Iancu <bogdan at voice-system.ro
> wrote:

> Hi Jayesh,
>
> 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.
>
> Regards,
> Bogdan
>
> Jayesh Nambiar wrote:
>
>>
>>    Hello All,
>>
>>
>> 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:
>> ERROR:db_mysql:db_mysql_do_prepared_query: mysql_stmt_bind_param() failed:
>> Using unsupported buffer type: 22  (parameter: 15)
>> ERROR:acc:acc_db_request: failed to insert into database
>> ERROR:db_mysql:db_mysql_do_prepared_query: mysql_stmt_bind_param() failed:
>> Using unsupported buffer type: 17  (parameter: 15)
>> ERROR:acc:acc_db_request: failed to insert into database
>>
>> 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.
>> Can someone please help to debug this. I have downgraded my Opensips to
>> 1.4.5 because of this being repeated.
>>
>> Thanks in Advance !!
>>
>> --- Jayesh
>> ------------------------------------------------------------------------
>>
>> _______________________________________________
>> Users mailing list
>> Users at lists.opensips.org
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.opensips.org/pipermail/users/attachments/20090605/6c328a3a/attachment.htm 


More information about the Users mailing list