[OpenSIPS-Users] db_mysql core dump

[Duane Larson]

One other piece of information on this issue.

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.




On Tue, Nov 30, 2010 at 1:20 PM, Bogdan-Andrei Iancu <bogdan at voice-system.ro
> 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 <
>> bogdan at voice-system.ro <mailto:bogdan at voice-system.ro>> 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
>>
>>
>>
>>     duane.larson at gmail.com <mailto:duane.larson at gmail.com> 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
>>        Users at lists.opensips.org <mailto:Users at lists.opensips.org>
>>
>>        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
>>    Users at lists.opensips.org <mailto:Users at lists.opensips.org>
>>
>>    http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>
>>
>>
>>
>> --
>> --
>> *--*--*--*--*--*
>> Duane
>> *--*--*--*--*--*
>> --
>> ------------------------------------------------------------------------
>>
>> _______________________________________________
>> Users mailing list
>> Users at lists.opensips.org
>> 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
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>



-- 
--
*--*--*--*--*--*
Duane
*--*--*--*--*--*
--
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20101204/9ff3fda4/attachment.htm>