[OpenSIPS-Users] opensips crash - mysql

[Jayesh Nambiar]

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>
> Subject: [OpenSIPS-Users] opensips crash - mysql
> To: users at lists.opensips.org
> Message-ID:
>        <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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.opensips.org/pipermail/users/attachments/20090617/ca1863af/attachment.htm