<div>Sure. I am game. I could also send you the full config I am using, but it is pretty much word for word when it comes to the presence install shown on (word for word when it comes to the subscribe, publish, notify handling)</div>
<div><a href="http://openxcap.org/wiki/Configuration">http://openxcap.org/wiki/Configuration</a></div>
<div>Just a thought.</div>
<div> </div>
<div>Send the patch over whenever.<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">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 class="im">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 class="im">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 class="h5"> <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 class="im"><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 class="im"><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 class="h5"><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>