<div class="gmail_quote"><div>Hi Brett,</div><div>This is a similar error that I had got in my environment too. In my case it used to get sorted out after restarting my MySQL and Opensips. But used to occur again after say 10-15 days.</div>
<div>Unfortunately I did not take the core dump. I had asked Bogdan if prepared statements can be disabled for particular modules and he said he will prepare a patch or make it configurable in the config.h file.</div><div>
<br></div><div>--- Jayesh</div><div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><br>
Message: 2<br>
Date: Wed, 17 Jun 2009 01:55:29 -0500<br>
From: Brett Nemeroff <<a href="mailto:brett@nemeroff.com">brett@nemeroff.com</a>><br>
Subject: [OpenSIPS-Users] opensips crash - mysql<br>
To: <a href="mailto:users@lists.opensips.org">users@lists.opensips.org</a><br>
Message-ID:<br>
<<a href="mailto:4f67656a0906162355p4f6ec50fk5bf51b4979ebcc14@mail.gmail.com">4f67656a0906162355p4f6ec50fk5bf51b4979ebcc14@mail.gmail.com</a>><br>
Content-Type: text/plain; charset="iso-8859-1"<br>
<br>
All,<br>
I ran into an interesting crash in my test env today.<br>
<br>
I took a very large acc table and reindexed it with a complicated index..<br>
while this was going on I placed calls and got the following errors:<br>
Jun 17 01:47:40 voicefox-dev /usr/local/sbin/opensips[25170]:<br>
ERROR:db_mysql:db_mysql_do_prepared_query: mysql_stmt_bind_param() failed:<br>
Using unsupported buffer type: 744972660 (parameter: 14)<br>
Jun 17 01:47:40 voicefox-dev /usr/local/sbin/opensips[25170]:<br>
ERROR:siptrace:trace_sl_onreply_out: error storing trace<br>
<br>
and then opensips segfaulted.<br>
<br>
here's the bt:<br>
Core was generated by `/usr/local/sbin/opensips -P /var/run/opensips.pid -m<br>
2048'.<br>
Program terminated with signal 11, Segmentation fault.<br>
[New process 25156]<br>
#0 0x00000034c1a7b733 in memcpy () from /lib64/libc.so.6<br>
(gdb) bt<br>
#0 0x00000034c1a7b733 in memcpy () from /lib64/libc.so.6<br>
#1 0x0000003c28a25a49 in mysql_stmt_bind_param () from<br>
/usr/lib64/mysql/libmysqlclient.so.15<br>
#2 0x00002b621bb194de in db_mysql_do_prepared_query (conn=0x79a5f8,<br>
query=0x2b621bd31730, v=0x7fff8efa1890, n=10, uv=0x0, un=0) at dbase.c:497<br>
#3 0x00002b621bb1b7c4 in db_mysql_insert (_h=0x79a5f8, _k=0x7fff8efa19d0,<br>
_v=0x7fff8efa1890, _n=10) at dbase.c:929<br>
#4 0x00002b621da6ee96 in sip_trace (msg=0x79d3d0) at siptrace.c:629<br>
#5 0x00002b621da70740 in trace_dialog (msg=0x79d3d0) at siptrace.c:461<br>
#6 0x000000000040dcfc in do_action (a=0x77e3c8, msg=0x79d3d0) at<br>
action.c:962<br>
#7 0x000000000041079e in run_action_list (a=<value optimized out>,<br>
msg=0x79d3d0) at action.c:139<br>
#8 0x000000000040eb40 in do_action (a=0x77e498, msg=0x79d3d0) at<br>
action.c:706<br>
#9 0x000000000041079e in run_action_list (a=<value optimized out>,<br>
msg=0x79d3d0) at action.c:139<br>
#10 0x000000000040eb40 in do_action (a=0x7833e8, msg=0x79d3d0) at<br>
action.c:706<br>
#11 0x000000000041079e in run_action_list (a=<value optimized out>,<br>
msg=0x79d3d0) at action.c:139<br>
#12 0x0000000000410af9 in run_top_route (a=0x770778, msg=0x79d3d0) at<br>
action.c:119<br>
#13 0x000000000044f3df in receive_msg (<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <a href="http://lists.opensips.org/pipermail/users/attachments/20090617/0fdc655c/attachment-0001.htm" target="_blank">http://lists.opensips.org/pipermail/users/attachments/20090617/0fdc655c/attachment-0001.htm</a><br>
<br></blockquote></div>