[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