[asterisk-dev] Realtime crash

Tue Sep 5 05:05:15 MST 2006

Hmm, seems like a different problem, I am using voicemail storage in
ODBC but it's clearly crashing when doing a realtime lookup directly
with MySQL, not using ODBC at all. Also the server was up continuously
during the period when it was crashing.

Thanks,

Peter.

On Tue, 2006-09-05 at 13:05 +0200, Morten Isaksen wrote:
> Hi!
>  
> I have the same problem. Check http://bugs.digium.com/view.php?id=7743
>  
> Here this only happens when the database server has been down. What
> version af mysql-libraries and myodbc do you use?
>  
> Regards
> Morten Isaksen
> 
> 
>  
> On 9/5/06, Peter Spikings <peter.spikings at power.net.uk> wrote: 
>         Hi all,
>         
>         Last night I experienced 3 crashes, seemingly of Realtime,
>         while trying
>         to install a new Asterisk based phone system at work, most of
>         the time 
>         the calls went through fine. The last lines of debug output
>         were:
>         
>         Sep  4 18:59:13 DEBUG[31937] res_config_mysql.c: MySQL
>         RealTime: Retrieve SQL: SELECT * FROM AsteriskExtensions WHERE
>         exten = 'h' AND context = 'powerqueue' AND priority = '1' 
>         Sep  4 18:59:13 VERBOSE[31935] logger.c:   == End MixMonitor
>         Recording SIP/device-0960d260
>         Sep  4 18:59:13 DEBUG[31937] res_config_mysql.c: MySQL
>         RealTime: Everything is fine.
>         
>         The next line was from the restart. Backtrace of the
>         corresponding core 
>         file in gdb gives:
>         
>         Core was generated by `asterisk'.
>         Program terminated with signal 11, Segmentation fault.
>         ...
>         (gdb) bt
>         #0  0x00857c7b in malloc_usable_size ()
>         from /lib/tls/libc.so.6
>         #1  0x00858dd3 in free () from /lib/tls/libc.so.6 
>         #2  0x0085aba1 in malloc () from /lib/tls/libc.so.6
>         #3  0x0061fab7 in my_malloc ()
>         from /usr/lib/mysql/libmysqlclient.so.14
>         #4  0x00622acb in alloc_root ()
>         from /usr/lib/mysql/libmysqlclient.so.14
>         #5  0x0063e5d6 in cli_read_rows ()
>         from /usr/lib/mysql/libmysqlclient.so.14 
>         #6  0x0063f060 in mysql_close ()
>         from /usr/lib/mysql/libmysqlclient.so.14
>         #7  0x0063f223 in mysql_real_query ()
>         from /usr/lib/mysql/libmysqlclient.so.14
>         #8  0x0021356f in realtime_mysql (database=0xb7734c20 "db",
>         table=0xb7734b20 "AsteriskExtensions", ap=0xb7734d60 "�s3(�)
>         at res_config_mysql.c:131 
>         #9  0x0805fa61 in ast_load_realtime (family=0xe12819
>         "extensions") at config.c:994
>         #10 0x00e11e24 in realtime_switch_common (table=0xe12819
>         "extensions", context=0x9618968 "powerqueue", exten=0x80fcf7c
>         "h", priority=1, mode=0) at pbx_realtime.c:132 
>         #11 0x00e12095 in realtime_exists (chan=0x9618818,
>         context=0x9618968 "powerqueue", exten=0x80fcf7c "h",
>         priority=1, callerid=0x960b7f8 "209", data=0x95de8a9 "@") at
>         pbx_realtime.c:164 
>         #12 0x08088e47 in pbx_find_extension (chan=0x9618818,
>         bypass=0x0, context=0x9618968 "powerqueue", exten=0x80fcf7c
>         "h", priority=1, label=0x0, callerid=0x960b7f8 "209",
>         action=0, incstack=0xb773b0b0, stacklen=0xb7734f3c, 
>            status=0xb7734f40, swo=0xb7734f44, data=0xb7734f48,
>         foundcontext=0xb7734f4c) at pbx.c:868
>         #13 0x08090bf5 in pbx_extension_helper (c=0x9618818, con=0x0,
>         context=0x9618968 "powerqueue", exten=0x80fcf7c "h",
>         priority=1, label=0x0, callerid=0x960b7f8 "209", action=0) at
>         pbx.c:1647
>         #14 0x0809248f in __ast_pbx_run (c=0x9618818) at pbx.c:2205
>         #15 0x08093dfc in pbx_thread (data=0x959d613) at pbx.c:2517
>         #16 0x009743ae in __pthread_initialize_minimal ()
>         from /lib/tls/libpthread.so.0
>         #17 0x008bdaee in clone () from /lib/tls/libc.so.6
>         
>         I'm using Asterisk 1.2.10 and addons 1.2.3. There was no h
>         extension in
>         that context.
>         
>         To me this looks like some kind of bug in the mysql library
>         but that 
>         seems unlikely ;)
>         
>         Does anybody have any thoughts on this?
>         
>         Thanks,
>         
>         Peter.
>         This message has been comprehensively scanned for viruses,
>         please visit http://www.avg.power.net.uk/ for details.
>         _______________________________________________
>         --Bandwidth and Colocation provided by Easynews.com --
>         
>         asterisk-dev mailing list
>         To UNSUBSCRIBE or update options visit: 
>           http://lists.digium.com/mailman/listinfo/asterisk-dev
> 
> 
> 
> -- 
> Morten Isaksen
> http://www.misak.dk/blog/ 
> ______________________________________________________________________
> 
> This message has been comprehensively scanned for viruses, please
> visit http://www.avg.power.net.uk/ for details.
> 
> _______________________________________________
> --Bandwidth and Colocation provided by Easynews.com --
> 
> asterisk-dev mailing list
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-dev
This message has been comprehensively scanned for viruses,
please visit http://www.avg.power.net.uk/ for details.