[OpenSIPS-Devel] [ opensips-Bugs-2903579 ] mysql_stmt_bind_param bind failed: Using unsupported buffer
SourceForge.net
noreply at sourceforge.net
Mon Nov 30 10:32:19 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: 5
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-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