[OpenSIPS-Users] db_mysql core dump

[Duane Larson]

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 <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/20101201/20c38522/attachment.htm>