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) http://openxcap.org/wiki/Configuration Just a thought.
Send the patch over whenever. On Tue, Nov 30, 2010 at 1:20 PM, Bogdan-Andrei Iancu <[email protected] > wrote: > Hi Duane, > > yes, that is...but fortunately does not provide the information I was > hoping for.... > > Is it ok if I will send you a patch that will enable kind of hunting for > this bug ? > > Regards, > Bogdan > > Duane Larson wrote: > >> I believe this is what you wanted >> (gdb) frame 2 >> #2 0x00007f176faf8f22 in db_mysql_delete (_h=0x812f20, _k=0x7fff61728980, >> _o=0x7fff61728960, _v=0x7fff61728900, _n=2) at dbase.c:893 >> 893 ret = db_mysql_do_prepared_query(_h, >> &query_holder, _v, _n, NULL, 0); >> >> (gdb) print _h >> $2 = (const db_con_t *) 0x812f20 >> >> (gdb) print _h->curr_ps >> $3 = (db_ps_t *) 0x7f176c46d2b0 >> >> (gdb) print (struct prep_stmt*)(*(_h)->curr_ps) >> $4 = (struct prep_stmt *) 0x813650 >> >> (gdb) print ((struct prep_stmt*)(*(_h)->curr_ps))->stmts >> $5 = (struct my_stmt_ctx *) 0x814d10 >> >> (gdb) print ((struct prep_stmt*)(*(_h)->curr_ps))->stmts->table.s >> $6 = 0x814d48 "watchersdelete from watchers where inserted_time<? AND >> status=?.26705.61.7" >> >> (gdb) print ((struct prep_stmt*)(*(_h)->curr_ps))->stmts->query.s >> $7 = 0x814d50 "delete from watchers where inserted_time<? AND >> status=?.26705.61.7" >> >> On Wed, Nov 24, 2010 at 5:29 AM, Bogdan-Andrei Iancu < >> [email protected] <mailto:[email protected]>> wrote: >> >> Hi Duane, >> >> in frame 2 print the followings: >> _h >> _h->curr_ps >> (struct prep_stmt*)(*(_h)->curr_ps) >> ((struct prep_stmt*)(*(_h)->curr_ps))->stmts >> ((struct prep_stmt*)(*(_h)->curr_ps))->stmts->table.s >> ((struct prep_stmt*)(*(_h)->curr_ps))->stmts->query.s >> >> >> Thanks and regards, >> Bogdan >> >> >> >> [email protected] <mailto:[email protected]> wrote: >> >> I searched the mailing list and couldn't find anything related >> to this. >> >> For the last couple of nights OpenSIPS has died on me. Each >> time in Syslog I see >> >> Nov 13 02:54:25 Proxy01 kernel: [1750051.944109] >> opensips[6645]: segfault at 0 ip 00007f7fd431bafd sp >> 00007fff67048fc0 error 6 in db_mysql.so[7f7fd4311000+d >> 000] >> Nov 13 02:54:25 Proxy01 ./opensips[6654]: >> CRITICAL:core:receive_fd: EOF on 24 >> Nov 13 02:54:25 Proxy01 ./opensips[6631]: >> INFO:core:handle_sigs: child process 6645 exited by a signal 11 >> Nov 13 02:54:25 Proxy01 ./opensips[6631]: >> INFO:core:handle_sigs: core was generated >> Nov 13 02:54:25 Proxy01 ./opensips[6631]: >> INFO:core:handle_sigs: terminating due to SIGCHLD >> >> >> The backtrace has the following >> >> Core was generated by `./opensips -f >> /usr/local/etc/opensips/opensips.cfg'. >> Program terminated with signal 11, Segmentation fault. >> #0 0x00007f7fd431bafd in db_mysql_val2bind (v=0x7fff67049120, >> binds=0x7ffd68, i=112) at val.c:274 >> 274 *(binds[i].is_null) = 0; >> (gdb) backtrace >> #0 0x00007f7fd431bafd in db_mysql_val2bind (v=0x7fff67049120, >> binds=0x7ffd68, i=112) at val.c:274 >> #1 0x00007f7fd431607a in db_mysql_do_prepared_query >> (conn=0x7ff5f8, query=0x7f7fd452e6d0, v=0x7fff67049100, n=2, >> uv=0x0, un=0) at dbase.c:443 >> #2 0x00007f7fd4318305 in db_mysql_delete (_h=0x7ff5f8, >> _k=0x7fff67049180, _o=0x7fff67049160, _v=0x7fff67049100, _n=2) >> at dbase.c:893 >> #3 0x00007f7fd0a96b10 in msg_watchers_clean (ticks=<value >> optimized out>, param=<value optimized out>) at subscribe.c:484 >> #4 0x000000000049e3da in timer_ticker () at timer.c:325 >> #5 run_timer_process () at timer.c:395 >> #6 start_timer_processes () at timer.c:475 >> #7 0x000000000042be57 in main_loop (argc=<value optimized >> out>, argv=0x7fff67049378) at main.c:867 >> #8 main (argc=<value optimized out>, argv=0x7fff67049378) at >> main.c:1388 >> >> >> If need be I could also look in the MySQL logs and see what >> the last execution was. Any ideas? >> >> ------------------------------------------------------------------------ >> >> >> >> _______________________________________________ >> Users mailing list >> [email protected] <mailto:[email protected]> >> >> http://lists.opensips.org/cgi-bin/mailman/listinfo/users >> >> >> >> -- Bogdan-Andrei Iancu >> OpenSIPS Bootcamp >> 15 - 19 November 2010, Edison, New Jersey, USA >> www.voice-system.ro <http://www.voice-system.ro/> >> >> >> >> _______________________________________________ >> Users mailing list >> [email protected] <mailto:[email protected]> >> >> http://lists.opensips.org/cgi-bin/mailman/listinfo/users >> >> >> >> >> -- >> -- >> *--*--*--*--*--* >> Duane >> *--*--*--*--*--* >> -- >> ------------------------------------------------------------------------ >> >> _______________________________________________ >> Users mailing list >> [email protected] >> http://lists.opensips.org/cgi-bin/mailman/listinfo/users >> >> > > > -- > Bogdan-Andrei Iancu > OpenSIPS Bootcamp > 15 - 19 November 2010, Edison, New Jersey, USA > www.voice-system.ro > > > _______________________________________________ > Users mailing list > [email protected] > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > -- -- *--*--*--*--*--* Duane *--*--*--*--*--* --
_______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
