<div>One other piece of information on this issue.</div>
<div> </div>
<div>The last couple of days I have been trying to set up Redundant High-Availability. Because of this my client phones are not talking to the OpenSIPS service. So there has been absolutely no SIP messages going to the service yet it has still done random coredumps throughout the day and night. Very odd.</div>
<div> </div>
<div><br><br> </div>
<div class="gmail_quote">On Tue, Nov 30, 2010 at 1:20 PM, Bogdan-Andrei Iancu <span dir="ltr"><<a href="mailto:bogdan@voice-system.ro" target="_blank">bogdan@voice-system.ro</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">Hi Duane,<br><br>yes, that is...but fortunately does not provide the information I was hoping for....<br><br>
Is it ok if I will send you a patch that will enable kind of hunting for this bug ?<br><br>Regards,<br>Bogdan<br><br>Duane Larson wrote:<br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">
<div>I believe this is what you wanted<br> (gdb) frame 2<br>#2 0x00007f176faf8f22 in db_mysql_delete (_h=0x812f20, _k=0x7fff61728980, _o=0x7fff61728960, _v=0x7fff61728900, _n=2) at dbase.c:893<br>893 ret = db_mysql_do_prepared_query(_h, &query_holder, _v, _n, NULL, 0);<br>
<br>(gdb) print _h<br>$2 = (const db_con_t *) 0x812f20<br><br>(gdb) print _h->curr_ps<br>$3 = (db_ps_t *) 0x7f176c46d2b0<br><br>(gdb) print (struct prep_stmt*)(*(_h)->curr_ps)<br>$4 = (struct prep_stmt *) 0x813650<br>
<br>(gdb) print ((struct prep_stmt*)(*(_h)->curr_ps))->stmts<br>$5 = (struct my_stmt_ctx *) 0x814d10<br><br>(gdb) print ((struct prep_stmt*)(*(_h)->curr_ps))->stmts->table.s<br>$6 = 0x814d48 "watchersdelete from watchers where inserted_time<? AND status=?.26705.61.7"<br>
<br>(gdb) print ((struct prep_stmt*)(*(_h)->curr_ps))->stmts->query.s<br>$7 = 0x814d50 "delete from watchers where inserted_time<? AND status=?.26705.61.7"<br><br></div>
<div>On Wed, Nov 24, 2010 at 5:29 AM, Bogdan-Andrei Iancu <<a href="mailto:bogdan@voice-system.ro" target="_blank">bogdan@voice-system.ro</a> <mailto:<a href="mailto:bogdan@voice-system.ro" target="_blank">bogdan@voice-system.ro</a>>> wrote:<br>
<br> Hi Duane,<br><br> in frame 2 print the followings:<br> _h<br> _h->curr_ps<br> (struct prep_stmt*)(*(_h)->curr_ps)<br> ((struct prep_stmt*)(*(_h)->curr_ps))->stmts<br> ((struct prep_stmt*)(*(_h)->curr_ps))->stmts->table.s<br>
((struct prep_stmt*)(*(_h)->curr_ps))->stmts->query.s<br><br><br> Thanks and regards,<br> Bogdan<br><br><br><br></div>
<div>
<div></div>
<div> <a href="mailto:duane.larson@gmail.com" target="_blank">duane.larson@gmail.com</a> <mailto:<a href="mailto:duane.larson@gmail.com" target="_blank">duane.larson@gmail.com</a>> wrote:<br><br> I searched the mailing list and couldn't find anything related<br>
to this.<br><br> For the last couple of nights OpenSIPS has died on me. Each<br> time in Syslog I see<br><br> Nov 13 02:54:25 Proxy01 kernel: [1750051.944109]<br> opensips[6645]: segfault at 0 ip 00007f7fd431bafd sp<br>
00007fff67048fc0 error 6 in db_mysql.so[7f7fd4311000+d<br> 000]<br> Nov 13 02:54:25 Proxy01 ./opensips[6654]:<br> CRITICAL:core:receive_fd: EOF on 24<br> Nov 13 02:54:25 Proxy01 ./opensips[6631]:<br>
INFO:core:handle_sigs: child process 6645 exited by a signal 11<br> Nov 13 02:54:25 Proxy01 ./opensips[6631]:<br> INFO:core:handle_sigs: core was generated<br> Nov 13 02:54:25 Proxy01 ./opensips[6631]:<br>
INFO:core:handle_sigs: terminating due to SIGCHLD<br><br><br> The backtrace has the following<br><br> Core was generated by `./opensips -f<br> /usr/local/etc/opensips/opensips.cfg'.<br> Program terminated with signal 11, Segmentation fault.<br>
#0 0x00007f7fd431bafd in db_mysql_val2bind (v=0x7fff67049120,<br> binds=0x7ffd68, i=112) at val.c:274<br> 274 *(binds[i].is_null) = 0;<br> (gdb) backtrace<br> #0 0x00007f7fd431bafd in db_mysql_val2bind (v=0x7fff67049120,<br>
binds=0x7ffd68, i=112) at val.c:274<br> #1 0x00007f7fd431607a in db_mysql_do_prepared_query<br> (conn=0x7ff5f8, query=0x7f7fd452e6d0, v=0x7fff67049100, n=2,<br> uv=0x0, un=0) at dbase.c:443<br> #2 0x00007f7fd4318305 in db_mysql_delete (_h=0x7ff5f8,<br>
_k=0x7fff67049180, _o=0x7fff67049160, _v=0x7fff67049100, _n=2)<br> at dbase.c:893<br> #3 0x00007f7fd0a96b10 in msg_watchers_clean (ticks=<value<br> optimized out>, param=<value optimized out>) at subscribe.c:484<br>
#4 0x000000000049e3da in timer_ticker () at timer.c:325<br> #5 run_timer_process () at timer.c:395<br> #6 start_timer_processes () at timer.c:475<br> #7 0x000000000042be57 in main_loop (argc=<value optimized<br>
out>, argv=0x7fff67049378) at main.c:867<br> #8 main (argc=<value optimized out>, argv=0x7fff67049378) at<br> main.c:1388<br><br><br> If need be I could also look in the MySQL logs and see what<br>
the last execution was. Any ideas?<br> ------------------------------------------------------------------------<br><br><br><br> _______________________________________________<br> Users mailing list<br>
</div></div> <a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a> <mailto:<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a>>
<div><br> <a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br> <br><br><br> -- Bogdan-Andrei Iancu<br> OpenSIPS Bootcamp<br>
15 - 19 November 2010, Edison, New Jersey, USA<br></div> <a href="http://www.voice-system.ro/" target="_blank">www.voice-system.ro</a> <<a href="http://www.voice-system.ro/" target="_blank">http://www.voice-system.ro/</a>><br>
<br><br><br> _______________________________________________<br> Users mailing list<br> <a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a> <mailto:<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a>>
<div><br> <a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br><br><br><br><br>-- <br>--<br>*--*--*--*--*--*<br>Duane<br>*--*--*--*--*--*<br>
--<br>------------------------------------------------------------------------<br><br>_______________________________________________<br>Users mailing list<br><a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br> <br></div></blockquote>
<div>
<div></div>
<div><br><br>-- <br>Bogdan-Andrei Iancu<br>OpenSIPS Bootcamp<br>15 - 19 November 2010, Edison, New Jersey, USA<br><a href="http://www.voice-system.ro/" target="_blank">www.voice-system.ro</a><br><br><br>_______________________________________________<br>
Users mailing list<br><a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a><br><a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br>--<br>*--*--*--*--*--*<br>Duane<br>*--*--*--*--*--*<br>--<br>