[OpenSIPS-Devel] [ opensips-Bugs-2779524 ] ERROR in re_init_statement: failed while mysql_stmt_prepare.

[SourceForge.net]

Bugs item #2779524, was opened at 2009-04-23 16:41
Message generated for change (Settings changed) made by bogdan_iancu
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1086410&aid=2779524&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: Deleted
>Resolution: Duplicate
Priority: 5
Private: No
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Nobody/Anonymous (nobody)
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!

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

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