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-10 10:53 Message: Looks like it's working well, I get entries in the location table. Thanks Bogdan. Feb 10 12:50:38 hostname /usr/local/sbin/opensips[11145]: DBG:db_mysql:has_stmt_ctx: ctx found for location Feb 10 12:50:38 hostname /usr/local/sbin/opensips[11145]: DBG:db_mysql:db_mysql_do_prepared_query: conn=0x690528 (tail=6879712) MC=0x690570 Feb 10 12:50:38 hostname /usr/local/sbin/opensips[11145]: DBG:db_mysql:db_mysql_do_prepared_query: set values for the statement run Feb 10 12:50:38 hostname /usr/local/sbin/opensips[11145]: DBG:db_mysql:db_mysql_val2bind: added val (0): len=4; type=254; is_null=0 Feb 10 12:50:38 hostname /usr/local/sbin/opensips[11145]: DBG:db_mysql:db_mysql_val2bind: added val (1): len=54; type=254; is_null=0 Feb 10 12:50:38 hostname /usr/local/sbin/opensips[11145]: DBG:db_mysql:db_mysql_val2bind: added val (2): len=40; type=12; is_null=0 Feb 10 12:50:38 hostname /usr/local/sbin/opensips[11145]: DBG:db_mysql:db_mysql_val2bind: added val (3): len=8; type=5; is_null=0 Feb 10 12:50:38 hostname /usr/local/sbin/opensips[11145]: DBG:db_mysql:db_mysql_val2bind: added val (4): len=44; type=254; is_null=0 Feb 10 12:50:38 hostname /usr/local/sbin/opensips[11145]: DBG:db_mysql:db_mysql_val2bind: added val (5): len=4; type=3; is_null=0 Feb 10 12:50:38 hostname /usr/local/sbin/opensips[11145]: DBG:db_mysql:db_mysql_val2bind: added val (6): len=4; type=3; is_null=0 Feb 10 12:50:38 hostname /usr/local/sbin/opensips[11145]: DBG:db_mysql:db_mysql_val2bind: added val (7): len=4; type=3; is_null=0 Feb 10 12:50:38 hostname /usr/local/sbin/opensips[11145]: DBG:db_mysql:db_mysql_val2bind: added val (8): len=32; type=254; is_null=0 Feb 10 12:50:38 hostname /usr/local/sbin/opensips[11145]: DBG:db_mysql:db_mysql_val2bind: added val (11): len=22; type=254; is_null=0 Feb 10 12:50:38 hostname /usr/local/sbin/opensips[11145]: DBG:db_mysql:db_mysql_val2bind: added val (12): len=4; type=3; is_null=0 Feb 10 12:50:38 hostname /usr/local/sbin/opensips[11145]: DBG:db_mysql:db_mysql_val2bind: added val (13): len=40; type=12; is_null=0 Feb 10 12:50:38 hostname /usr/local/sbin/opensips[11145]: DBG:db_mysql:db_mysql_do_prepared_query: doing BIND_PARAM in... ---------------------------------------------------------------------- Comment By: Bogdan-Andrei Iancu (bogdan_iancu) Date: 2010-02-10 06:26 Message: OK, I uploaded the patch, let me know if it solves the problem. Thanks and regards, Bogdan ---------------------------------------------------------------------- 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 _______________________________________________ Devel mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/devel
