[OpenSIPS-Devel] [ opensips-Bugs-2948054 ] This bug fixed or a work around determined?

SourceForge.net noreply at sourceforge.net
Tue Feb 9 21:18:20 CET 2010


Bugs item #2948054, was opened at 2010-02-08 13:37
Message generated for change (Comment added) made by cbl301
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1086410&aid=2948054&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: None
Status: Open
Resolution: Duplicate
Priority: 7
Private: No
Submitted By: Chuck Brown (cbl301)
Assigned to: Bogdan-Andrei Iancu (bogdan_iancu)
Summary: This bug fixed or a work around determined?

Initial Comment:
I made the mod from the diff, I also upgraded to mysql 5.1.43, no change,  here's the current output:
Feb  8 15:29:24 myhost /usr/local/sbin/opensips[431]: DBG:db_mysql:has_stmt_ctx: ctx found for location 
Feb  8 15:29:24 myhost /usr/local/sbin/opensips[431]: DBG:db_mysql:db_mysql_do_prepared_query: conn=0x68fe08 (tail=6881024) MC=0x690520 
Feb  8 15:29:24 myhost /usr/local/sbin/opensips[431]: DBG:db_mysql:db_mysql_do_prepared_query: set values for the statement run 
Feb  8 15:29:24 myhost /usr/local/sbin/opensips[431]: DBG:db_mysql:db_mysql_val2bind: added val (0): len=4; type=254; is_null=0 
Feb  8 15:29:24 myhost /usr/local/sbin/opensips[431]: DBG:db_mysql:db_mysql_val2bind: added val (1): len=55; type=254; is_null=0 
Feb  8 15:29:24 myhost /usr/local/sbin/opensips[431]: DBG:db_mysql:db_mysql_val2bind: added val (2): len=40; type=12; is_null=0 
Feb  8 15:29:24 myhost /usr/local/sbin/opensips[431]: DBG:db_mysql:db_mysql_val2bind: added val (3): len=8; type=5; is_null=0 
Feb  8 15:29:24 myhost /usr/local/sbin/opensips[431]: DBG:db_mysql:db_mysql_val2bind: added val (4): len=44; type=254; is_null=0 
Feb  8 15:29:24 myhost /usr/local/sbin/opensips[431]: DBG:db_mysql:db_mysql_val2bind: added val (5): len=4; type=3; is_null=0 
Feb  8 15:29:24 myhost /usr/local/sbin/opensips[431]: DBG:db_mysql:db_mysql_val2bind: added val (6): len=4; type=3; is_null=0 
Feb  8 15:29:24 myhost /usr/local/sbin/opensips[431]: DBG:db_mysql:db_mysql_val2bind: added val (7): len=4; type=3; is_null=0 
Feb  8 15:29:24 myhost /usr/local/sbin/opensips[431]: DBG:db_mysql:db_mysql_val2bind: added val (8): len=32; type=254; is_null=0 
Feb  8 15:29:24 myhost /usr/local/sbin/opensips[431]: DBG:db_mysql:db_mysql_val2bind: added val (11): len=22; type=254; is_null=0 
Feb  8 15:29:24 myhost /usr/local/sbin/opensips[431]: DBG:db_mysql:db_mysql_val2bind: added val (12): len=4; type=3; is_null=0 
Feb  8 15:29:24 myhost /usr/local/sbin/opensips[431]: DBG:db_mysql:db_mysql_val2bind: added val (13): len=40; type=12; is_null=0 
Feb  8 15:29:24 myhost /usr/local/sbin/opensips[431]: DBG:db_mysql:db_mysql_do_prepared_query: doing BIND_PARAM in... 
Feb  8 15:29:24 myhost /usr/local/sbin/opensips[431]: ERROR:db_mysql:db_mysql_do_prepared_query: mysql_stmt_bind_param() failed: Using unsupported buffer type: 0  (parameter: 10) 
Feb  8 15:29:24 myhost /usr/local/sbin/opensips[431]: ERROR:db_mysql:db_mysql_do_prepared_query: param 0 was found as type 254 
Feb  8 15:29:24 myhost /usr/local/sbin/opensips[431]: ERROR:db_mysql:db_mysql_do_prepared_query: param 1 was found as type 254 
Feb  8 15:29:24 myhost /usr/local/sbin/opensips[431]: ERROR:db_mysql:db_mysql_do_prepared_query: param 2 was found as type 12 
Feb  8 15:29:24 myhost /usr/local/sbin/opensips[431]: ERROR:db_mysql:db_mysql_do_prepared_query: param 3 was found as type 5 
Feb  8 15:29:24 myhost /usr/local/sbin/opensips[431]: ERROR:db_mysql:db_mysql_do_prepared_query: param 4 was found as type 254 
Feb  8 15:29:24 myhost /usr/local/sbin/opensips[431]: ERROR:db_mysql:db_mysql_do_prepared_query: param 5 was found as type 3 
Feb  8 15:29:24 myhost /usr/local/sbin/opensips[431]: ERROR:db_mysql:db_mysql_do_prepared_query: param 6 was found as type 3 
Feb  8 15:29:24 myhost /usr/local/sbin/opensips[431]: ERROR:db_mysql:db_mysql_do_prepared_query: param 7 was found as type 3 
Feb  8 15:29:24 myhost /usr/local/sbin/opensips[431]: ERROR:db_mysql:db_mysql_do_prepared_query: param 8 was found as type 254 
Feb  8 15:29:24 myhost /usr/local/sbin/opensips[431]: ERROR:db_mysql:db_mysql_do_prepared_query: param 9 was found as type 0 
Feb  8 15:29:24 myhost /usr/local/sbin/opensips[431]: ERROR:db_mysql:db_mysql_do_prepared_query: param 10 was found as type 0 
Feb  8 15:29:24 myhost /usr/local/sbin/opensips[431]: ERROR:db_mysql:db_mysql_do_prepared_query: param 11 was found as type 254 
Feb  8 15:29:24 myhost /usr/local/sbin/opensips[431]: ERROR:db_mysql:db_mysql_do_prepared_query: param 12 was found as type 3 
Feb  8 15:29:24 myhost /usr/local/sbin/opensips[431]: ERROR:db_mysql:db_mysql_do_prepared_query: param 13 was found as type 12 
Feb  8 15:29:24 myhost /usr/local/sbin/opensips[431]: ERROR:usrloc:db_insert_ucontact: inserting contact in db failed 
Feb  8 15:29:24 myhost /usr/local/sbin/opensips[431]: ERROR:usrloc:wb_timer: inserting contact into database failed 
Feb  8 15:29:37 myhost /usr/local/sbin/opensips[428]: DBG:core:udp_rcv_loop: probing packet received len = 4 
Feb  8 15:30:08 myhost /usr/local/sbin/opensips[425]: DBG:core:udp_rcv_loop: probing packet received len = 4 
Feb  8 15:30:24 myhost /usr/local/sbin/opensips[431]: DBG:db_mysql:has_stmt_ctx: ctx found for location 
Feb  8 15:30:24 myhost /usr/local/sbin/opensips[431]: DBG:db_mysql:db_mysql_do_prepared_query: conn=0x68fe08 (tail=6881024) MC=0x690520 
Feb  8 15:30:24 myhost /usr/local/sbin/opensips[431]: DBG:db_mysql:db_mysql_do_prepared_query: set values for the statement run 
Feb  8 15:30:24 myhost /usr/local/sbin/opensips[431]: DBG:db_mysql:db_mysql_val2bind: added val (0): len=4; type=254; is_null=0 
Feb  8 15:30:24 myhost /usr/local/sbin/opensips[431]: DBG:db_mysql:db_mysql_val2bind: added val (1): len=55; type=254; is_null=0 
Feb  8 15:30:24 myhost /usr/local/sbin/opensips[431]: DBG:db_mysql:db_mysql_val2bind: added val (2): len=40; type=12; is_null=0 
Feb  8 15:30:24 myhost /usr/local/sbin/opensips[431]: DBG:db_mysql:db_mysql_val2bind: added val (3): len=8; type=5; is_null=0 
Feb  8 15:30:24 myhost /usr/local/sbin/opensips[431]: DBG:db_mysql:db_mysql_val2bind: added val (4): len=44; type=254; is_null=0 
Feb  8 15:30:24 myhost /usr/local/sbin/opensips[431]: DBG:db_mysql:db_mysql_val2bind: added val (5): len=4; type=3; is_null=0 
Feb  8 15:30:24 myhost /usr/local/sbin/opensips[431]: DBG:db_mysql:db_mysql_val2bind: added val (6): len=4; type=3; is_null=0 
Feb  8 15:30:24 myhost /usr/local/sbin/opensips[431]: DBG:db_mysql:db_mysql_val2bind: added val (7): len=4; type=3; is_null=0 
Feb  8 15:30:24 myhost /usr/local/sbin/opensips[431]: DBG:db_mysql:db_mysql_val2bind: added val (8): len=32; type=254; is_null=0 
Feb  8 15:30:24 myhost /usr/local/sbin/opensips[431]: DBG:db_mysql:db_mysql_val2bind: added val (11): len=22; type=254; is_null=0 
Feb  8 15:30:24 myhost /usr/local/sbin/opensips[431]: DBG:db_mysql:db_mysql_val2bind: added val (12): len=4; type=3; is_null=0 
Feb  8 15:30:24 myhost /usr/local/sbin/opensips[431]: DBG:db_mysql:db_mysql_val2bind: added val (13): len=40; type=12; is_null=0 
Feb  8 15:30:24 myhost /usr/local/sbin/opensips[431]: DBG:db_mysql:db_mysql_do_prepared_query: doing BIND_PARAM in... 
Feb  8 15:30:24 myhost /usr/local/sbin/opensips[431]: ERROR:db_mysql:db_mysql_do_prepared_query: mysql_stmt_bind_param() failed: Using unsupported buffer type: 0  (parameter: 10) 
Feb  8 15:30:24 myhost /usr/local/sbin/opensips[431]: ERROR:db_mysql:db_mysql_do_prepared_query: param 0 was found as type 254 
Feb  8 15:30:24 myhost /usr/local/sbin/opensips[431]: ERROR:db_mysql:db_mysql_do_prepared_query: param 1 was found as type 254 
Feb  8 15:30:24 myhost /usr/local/sbin/opensips[431]: ERROR:db_mysql:db_mysql_do_prepared_query: param 2 was found as type 12 
Feb  8 15:30:24 myhost /usr/local/sbin/opensips[431]: ERROR:db_mysql:db_mysql_do_prepared_query: param 3 was found as type 5 
Feb  8 15:30:24 myhost /usr/local/sbin/opensips[431]: ERROR:db_mysql:db_mysql_do_prepared_query: param 4 was found as type 254 
Feb  8 15:30:24 myhost /usr/local/sbin/opensips[431]: ERROR:db_mysql:db_mysql_do_prepared_query: param 5 was found as type 3 
Feb  8 15:30:24 myhost /usr/local/sbin/opensips[431]: ERROR:db_mysql:db_mysql_do_prepared_query: param 6 was found as type 3 
Feb  8 15:30:24 myhost /usr/local/sbin/opensips[431]: ERROR:db_mysql:db_mysql_do_prepared_query: param 7 was found as type 3 
Feb  8 15:30:24 myhost /usr/local/sbin/opensips[431]: ERROR:db_mysql:db_mysql_do_prepared_query: param 8 was found as type 254 
Feb  8 15:30:24 myhost /usr/local/sbin/opensips[431]: ERROR:db_mysql:db_mysql_do_prepared_query: param 9 was found as type 0 
Feb  8 15:30:24 myhost /usr/local/sbin/opensips[431]: ERROR:db_mysql:db_mysql_do_prepared_query: param 10 was found as type 0 
Feb  8 15:30:24 myhost /usr/local/sbin/opensips[431]: ERROR:db_mysql:db_mysql_do_prepared_query: param 11 was found as type 254 
Feb  8 15:30:24 myhost /usr/local/sbin/opensips[431]: ERROR:db_mysql:db_mysql_do_prepared_query: param 12 was found as type 3 
Feb  8 15:30:24 myhost /usr/local/sbin/opensips[431]: ERROR:db_mysql:db_mysql_do_prepared_query: param 13 was found as type 12 
Feb  8 15:30:24 myhost /usr/local/sbin/opensips[431]: ERROR:usrloc:db_insert_ucontact: inserting contact in db failed 
Feb  8 15:30:24 myhost /usr/local/sbin/opensips[431]: ERROR:usrloc:wb_timer: inserting contact into database failed 
Feb  8 15:30:38 myhost /usr/local/sbin/opensips[427]: DBG:core:udp_rcv_loop: probing packet received len = 4 

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

>Comment By: Chuck Brown (cbl301)
Date: 2010-02-09 13:18

Message:
Thanks Bogdan, 
I'm ready to deploy when you get it done.
Thanks!
Chuck

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

Comment By: Bogdan-Andrei Iancu (bogdan_iancu)
Date: 2010-02-09 11:31

Message:
Hi Chuck,

Your report looks the same with bug 2903579 - as I was not able to
reproduce it (I guess it depends on the version of mysql lib) and the
original reported did not answer, I did not follow up the bug.
Anyhow, I will prepare for you a blind patch - I have some idea about what
might be the cause.

Regards,
Bogdan

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

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



More information about the Devel mailing list