[asterisk-users] Realtime via ODBC breaks for Voicemail

[Mosiuoa Tsietsi]

Hi all,

We have an asterisk installation here that uses realtime for voicemails
through ODBC.  It works very well except that every now and then (ie
four or five days or so) it breaks.  I have included a log from the CLI
of the most recent break, it looks like this:

---------------- Start of output
-- Executing Dial("SIP/sip.ict.ru.ac.za-b7721690",
"SIP/1017506 at myserver&Zap/10|20|rtT") in new stack

-- Called 1017506 at myserver

-- Requested transfer capability: 0x00 - SPEECH

-- Called 10

-- SIP/myserver-0a145e90 is ringing

-- Zap/10-1 is proceeding passing it to SIP/myserver-b7721690

-- Channel 0/1, span 4 got hangup request

-- Channel 0/1, span 4 received AOC-E charging 0 units

-- Hungup 'Zap/10-1'

-- Nobody picked up in 20000 ms

-- Executing VoiceMail("SIP/myserver-b7721690", "u7506") in new stack

Feb 14 16:00:26 WARNING[7565]: res_odbc.c:171 odbc_smart_execute: SQL
Execute returned an error -1: HYT00: [MySQL][ODBC 3.51
Driver][mysqld-5.0.27]MySQL server has gone away (66)

Feb 14 16:00:26 WARNING[7565]: res_odbc.c:171 odbc_smart_execute: SQL
Execute returned an error -1: 00000: [MySQL][ODBC 3.51
Driver][mysqld-5.0.27]MySQL server has gone away (66)

Feb 14 16:00:26 WARNING[7565]: res_config_odbc.c:124 realtime_odbc: SQL
Execute error!

[SELECT * FROM users WHERE mailbox = ?]


Feb 14 16:00:26 WARNING[7565]: app_voicemail.c:2412 leave_voicemail: No
entry in voicemail config file for '7506'

-- Executing VoiceMail("SIP/myserver-b7721690", "b7506") in new stack

Feb 14 16:00:26 WARNING[7565]: res_odbc.c:171 odbc_smart_execute: SQL
Execute returned an error -1: HYT00: [MySQL][ODBC 3.51
Driver][mysqld-5.0.27]MySQL server has gone away (66)

Feb 14 16:00:26 WARNING[7565]: res_odbc.c:171 odbc_smart_execute: SQL
Execute returned an error -1: 00000: [MySQL][ODBC 3.51
Driver][mysqld-5.0.27]MySQL server has gone away (66)

Feb 14 16:00:26 WARNING[7565]: res_config_odbc.c:124 realtime_odbc: SQL
Execute error!

[SELECT * FROM users WHERE mailbox = ?]


Feb 14 16:00:26 WARNING[7565]: app_voicemail.c:2412 leave_voicemail: No
entry in voicemail config file for '7506'

-- Executing Hangup("SIP/myserver-b7721690", "") in new stack

---------------- End of output

After I saw this in the CLI, I tried to do an ODBC show to see the
status of the connection, and asterisk broke:

------------- Start of odbc show

frog*CLI> odbc show

frog*CLI>

Disconnected from Asterisk server

Executing last minute cleanups

-------------- End of odbc show

Any ideas why asterisk is so volatile or why the ODBC stuff breaks?

Thanks,
Mos