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

Reply via email to