[OpenSIPS-Devel] [ opensips-Bugs-2903579 ] mysql_stmt_bind_param bind failed: Using unsupported buffer

SourceForge.net noreply at sourceforge.net
Fri Dec 11 12:52:48 CET 2009


Bugs item #2903579, was opened at 2009-11-25 08:34
Message generated for change (Comment added) made by bogdan_iancu
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1086410&aid=2903579&group_id=232389

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: modules
Group: trunk
Status: Open
Resolution: Accepted
>Priority: 7
Private: No
Submitted By: Alexander Gong (bestiring)
Assigned to: Bogdan-Andrei Iancu (bogdan_iancu)
Summary: mysql_stmt_bind_param bind failed: Using unsupported buffer 

Initial Comment:
Environment:  Red Hat E4U5, 
Packages:  
    opensips-1.6.0-tls_src.tar.gz,   get from trunk 
Mysql:  
     mysql-4.1.22-2.el4.i386.rpm  mysql-devel-4.1.22-2.el4.i386.rpm  mysql-server-4.1.22-2.el4.i386.rpm 

Error info in Log:
 Nov 25 12:21:43 localhost /usr/local/sbin/opensips[25063]: ERROR:db_mysql:db_mysql_do_prepared_query: mysql_stmt_bind_param() failed: Using unsupported buffer type: 0  (parameter: 10) 
Nov 25 12:21:43 localhost /usr/local/sbin/opensips[25063]: ERROR:db_mysql:db_mysql_do_prepared_query: param 0 was found as type 254 
Nov 25 12:21:43 localhost /usr/local/sbin/opensips[25063]: ERROR:db_mysql:db_mysql_do_prepared_query: param 1 was found as type 254 
Nov 25 12:21:43 localhost /usr/local/sbin/opensips[25063]: ERROR:db_mysql:db_mysql_do_prepared_query: param 2 was found as type 12 
Nov 25 12:21:43 localhost /usr/local/sbin/opensips[25063]: ERROR:db_mysql:db_mysql_do_prepared_query: param 3 was found as type 5 
Nov 25 12:21:43 localhost /usr/local/sbin/opensips[25063]: ERROR:db_mysql:db_mysql_do_prepared_query: param 4 was found as type 254 
Nov 25 12:21:43 localhost /usr/local/sbin/opensips[25063]: ERROR:db_mysql:db_mysql_do_prepared_query: param 5 was found as type 3 
Nov 25 12:21:43 localhost /usr/local/sbin/opensips[25063]: ERROR:db_mysql:db_mysql_do_prepared_query: param 6 was found as type 3 
Nov 25 12:21:43 localhost /usr/local/sbin/opensips[25063]: ERROR:db_mysql:db_mysql_do_prepared_query: param 7 was found as type 3 
Nov 25 12:21:43 localhost /usr/local/sbin/opensips[25063]: ERROR:db_mysql:db_mysql_do_prepared_query: param 8 was found as type 254 
Nov 25 12:21:43 localhost /usr/local/sbin/opensips[25063]: ERROR:db_mysql:db_mysql_do_prepared_query: param 9 was found as type 0 
Nov 25 12:21:43 localhost /usr/local/sbin/opensips[25063]: ERROR:db_mysql:db_mysql_do_prepared_query: param 10 was found as type 0 
Nov 25 12:21:43 localhost /usr/local/sbin/opensips[25063]: ERROR:db_mysql:db_mysql_do_prepared_query: param 11 was found as type 254 
Nov 25 12:21:43 localhost /usr/local/sbin/opensips[25063]: ERROR:db_mysql:db_mysql_do_prepared_query: param 12 was found as type 3 
Nov 25 12:21:43 localhost /usr/local/sbin/opensips[25063]: ERROR:db_mysql:db_mysql_do_prepared_query: param 13 was found as type 12 
Nov 25 12:21:43 localhost /usr/local/sbin/opensips[25063]: ERROR:usrloc:db_insert_ucontact: inserting contact in db failed 
Nov 25 12:21:43 localhost /usr/local/sbin/opensips[25063]: ERROR:usrloc:wb_timer: inserting contact into database failed 

************************************************************************
i compared the source code of db_mysql in packages with SVN current branch or trunk
there are no code changes, ex : 
dbase.c  , etc. 

Could you help me do the check? what's the problem
thanks 
 

----------------------------------------------------------------------

>Comment By: Bogdan-Andrei Iancu (bogdan_iancu)
Date: 2009-12-11 13:52

Message:
Hi Alexander,

Have you had the chance to make a run with the patch I sent you ?

Regards,
Bogdan

----------------------------------------------------------------------

Comment By: Bogdan-Andrei Iancu (bogdan_iancu)
Date: 2009-11-30 11:32

Message:
Hi Alexander,

It is a bit strange, but to be 100% I found the source of the error, could
you apply the attached patch and make on more run -> post the ERROR logs
again.
I said it is strange as the columns 9 and 10 (mysql complains about) have
NULL values and no type set...It looks some drivers do not like it...so I
want first to check if they are indeed null (with the patch).
If my guessing is right, I will generate a fix asap.

Thanks and regards,
Bogdan

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1086410&aid=2903579&group_id=232389



More information about the Devel mailing list