Bugs item #2779502, was opened at 2009-04-23 16:27 Message generated for change (Comment added) made by bogdan_iancu You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1086410&aid=2779502&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: 1.5.x >Status: Closed >Resolution: Fixed Priority: 5 Private: No Submitted By: Nobody/Anonymous (nobody) Assigned to: Bogdan-Andrei Iancu (bogdan_iancu) Summary: ERROR in re_init_statement: failed while mysql_stmt_prepare. Initial Comment: When it happens, every registration gets rejected with 500 server internal error. Apr 23 04:04:07 /usr/local/sbin/opensips[9042]: ERROR:db_mysql:re_init_statement: failed while mysql_stmt_prepare: (1243) Unknown prepared statement handler (4) given to mysql_stmt_close Apr 23 04:04:07 /usr/local/sbin/opensips[9042]: ERROR:db_mysql:db_mysql_do_prepared_query: failed to re-init statement! Apr 23 04:04:07 /usr/local/sbin/opensips[9042]: ERROR:usrloc:db_update_ucontact: updating database failed Apr 23 04:04:07 /usr/local/sbin/opensips[9042]: ERROR:usrloc:wb_timer: updating contact in db failed Apr 23 04:04:13 /usr/local/sbin/opensips[9042]: ERROR:db_mysql:get_new_stmt_ctx: failed while mysql_stmt_prepare: (2013) Lost connection to MySQL ser ver during query [...] Apr 23 04:07:08 /usr/local/sbin/opensips[9002]: ERROR:db_mysql:re_init_statement: failed while mysql_stmt_prepare: (1243) Unknown prepared statement handler (1) given to mysql_stmt_close Apr 23 04:07:08 /usr/local/sbin/opensips[9002]: ERROR:db_mysql:db_mysql_do_prepared_query: failed to re-init statement! Apr 23 04:07:08 /usr/local/sbin/opensips[9002]: ERROR:siptrace:sip_trace: error storing trace Apr 23 04:07:09 /usr/local/sbin/opensips[9005]: ERROR:db_mysql:db_mysql_do_prepared_query: mysql_stmt_bind_param() failed: Using unsupported buffer type: 858928432 (parameter: 2) the later ones seems to be mysql errors, but triggered from the first one. Restarting opensips (1.5.1) solves the problem for a few days. Thanks a lot! ---------------------------------------------------------------------- >Comment By: Bogdan-Andrei Iancu (bogdan_iancu) Date: 2009-07-07 12:58 Message: This should be fixed with the latest backport from trunk (indeed there were some issues with the mysql librarym in particular with the way it reports the reconnect events). Regards, Bogdan ---------------------------------------------------------------------- Comment By: Bogdan-Andrei Iancu (bogdan_iancu) Date: 2009-06-30 19:55 Message: In the last weeks there were couple of fixes that should also address this bug. Please use the trunk version of db_mysql module and confirm the fixing. Thanks and regards, Bogdan ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2009-04-23 16:42 Message: sorry for the duplicate, my mistake! ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1086410&aid=2779502&group_id=232389 _______________________________________________ Devel mailing list Devel@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/devel