[OpenSIPS-Users] Opensips 1.5 and MySQL error

[Bogdan-Andrei Iancu]

Hi Jayesh,

Sorry for the delay - now I'm ready for troubleshooting this problem.

First of all, are you using any extra or per-leg accounting ? because I 
see the error comes on param 15, while the acc module uses by default 
only 6 values.

Also find attached a patch will produce some more logs to help me in 
finding the error - do not get scared - the patch is printing more stuff 
as error (but they are not). So, when you get the error again, please 
send me the logs.

Thanks and regards,
Bogdan

Jayesh Nambiar wrote:
> Yes Bogdan, Sure will test it.
>
> --- 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
>          
>
>
>

-------------- next part --------------
A non-text attachment was scrubbed...
Name: db_mysql.patch
Type: text/x-diff
Size: 2184 bytes
Desc: not available
Url : http://lists.opensips.org/pipermail/users/attachments/20090610/04f6faba/attachment.patch