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