[OpenSIPS-Users] opensips crash - mysql

[Bogdan-Andrei Iancu]

Hi Jayesh, Hi Brett,

I sent the patch couple of days ago - see  
http://lists.opensips.org/pipermail/users/2009-June/005986.html

I will be great if you could apply the patch and get some logs around 
the original error.

Thanks and regards,
Bogdan

Jayesh Nambiar wrote:
> Hi Brett,
> 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.
> 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.
>
> --- Jayesh
>  
>
>
>     Message: 2
>     Date: Wed, 17 Jun 2009 01:55:29 -0500
>     From: Brett Nemeroff <brett at nemeroff.com <mailto:brett at nemeroff.com>>
>     Subject: [OpenSIPS-Users] opensips crash - mysql
>     To: users at lists.opensips.org <mailto:users at lists.opensips.org>
>     Message-ID:
>          
>      <4f67656a0906162355p4f6ec50fk5bf51b4979ebcc14 at mail.gmail.com
>     <mailto:4f67656a0906162355p4f6ec50fk5bf51b4979ebcc14 at mail.gmail.com>>
>     Content-Type: text/plain; charset="iso-8859-1"
>
>     All,
>     I ran into an interesting crash in my test env today.
>
>     I took a very large acc table and reindexed it with a complicated
>     index..
>     while this was going on I placed calls and got the following errors:
>     Jun 17 01:47:40 voicefox-dev /usr/local/sbin/opensips[25170]:
>     ERROR:db_mysql:db_mysql_do_prepared_query: mysql_stmt_bind_param()
>     failed:
>     Using unsupported buffer type: 744972660  (parameter: 14)
>     Jun 17 01:47:40 voicefox-dev /usr/local/sbin/opensips[25170]:
>     ERROR:siptrace:trace_sl_onreply_out: error storing trace
>
>     and then opensips segfaulted.
>
>     here's the bt:
>     Core was generated by `/usr/local/sbin/opensips -P
>     /var/run/opensips.pid -m
>     2048'.
>     Program terminated with signal 11, Segmentation fault.
>     [New process 25156]
>     #0  0x00000034c1a7b733 in memcpy () from /lib64/libc.so.6
>     (gdb) bt
>     #0  0x00000034c1a7b733 in memcpy () from /lib64/libc.so.6
>     #1  0x0000003c28a25a49 in mysql_stmt_bind_param () from
>     /usr/lib64/mysql/libmysqlclient.so.15
>     #2  0x00002b621bb194de in db_mysql_do_prepared_query (conn=0x79a5f8,
>     query=0x2b621bd31730, v=0x7fff8efa1890, n=10, uv=0x0, un=0) at
>     dbase.c:497
>     #3  0x00002b621bb1b7c4 in db_mysql_insert (_h=0x79a5f8,
>     _k=0x7fff8efa19d0,
>     _v=0x7fff8efa1890, _n=10) at dbase.c:929
>     #4  0x00002b621da6ee96 in sip_trace (msg=0x79d3d0) at siptrace.c:629
>     #5  0x00002b621da70740 in trace_dialog (msg=0x79d3d0) at
>     siptrace.c:461
>     #6  0x000000000040dcfc in do_action (a=0x77e3c8, msg=0x79d3d0) at
>     action.c:962
>     #7  0x000000000041079e in run_action_list (a=<value optimized out>,
>     msg=0x79d3d0) at action.c:139
>     #8  0x000000000040eb40 in do_action (a=0x77e498, msg=0x79d3d0) at
>     action.c:706
>     #9  0x000000000041079e in run_action_list (a=<value optimized out>,
>     msg=0x79d3d0) at action.c:139
>     #10 0x000000000040eb40 in do_action (a=0x7833e8, msg=0x79d3d0) at
>     action.c:706
>     #11 0x000000000041079e in run_action_list (a=<value optimized out>,
>     msg=0x79d3d0) at action.c:139
>     #12 0x0000000000410af9 in run_top_route (a=0x770778, msg=0x79d3d0) at
>     action.c:119
>     #13 0x000000000044f3df in receive_msg (
>     -------------- next part --------------
>     An HTML attachment was scrubbed...
>     URL:
>     http://lists.opensips.org/pipermail/users/attachments/20090617/0fdc655c/attachment-0001.htm
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>