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 <br...@nemeroff.com <mailto:br...@nemeroff.com>> > Subject: [OpenSIPS-Users] opensips crash - mysql > To: users@lists.opensips.org <mailto:users@lists.opensips.org> > Message-ID: > > <4f67656a0906162355p4f6ec50fk5bf51b4979ebc...@mail.gmail.com > <mailto:4f67656a0906162355p4f6ec50fk5bf51b4979ebc...@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@lists.opensips.org > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > _______________________________________________ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
