[OpenSIPS-Users] Opensips 1.5 and MySQL error

Bogdan-Andrei Iancu bogdan at voice-system.ro
Wed Jun 10 18:35:13 CEST 2009


Hi Jayesh,

right now there is no way to disable it, but give me a chance to find 
the problem and fix it. If the patch does not provide any clue about 
what is wrong, I can add a compile option to disable the prepared 
statements.

Regards,
Bogdan

Jayesh Nambiar wrote:
> 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 <mailto: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 <mailto:Users at lists.opensips.org>
>         http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>          
>
>
>




More information about the Users mailing list