[Spce-user] Asterisk crashed, voicemail issues.

[Jonathan Scott]

Asterisk crashed the other day, forced a restart. Then experienced a lot 
of voicemail issues with folders being locked, essentially deleted the 
lock files to "fix" the problem. Still some minor issues, a particular 
customer unable to listen to multiple voicemails without redialing into 
the VMS to hear each one. Essentially dialing 6 to change to next 
message, is told there are no more messages.

Is there anything other than Asterisk that needs to be restarted when 
something like this happens?

Also still dealing with this error floating around in VM's log, this 
happens when user tries to save a message:

Nov 21 13:04:12 sip asterisk[22463]: WARNING[29099]: res_odbc.c:105 in 
ast_odbc_prepare_and_execute: SQL Execute returned an error -1: HY000: 
[MySQL][ODBC 5.1 Driver][mysqld-5.1.57-rel12.8-log]Cannot add or update 
a child row: a foreign key constraint fails 
(`kamailio`.`voicemail_spool`, CONSTRAINT `v_s_mailboxuser_ref` FOREIGN 
KEY (`mailboxuser`) REFERENCES `voicemail_users` (`customer_id`) ON (289)
Nov 21 13:04:12 sip asterisk[22463]: WARNING[29099]: res_odbc.c:113 in 
ast_odbc_prepare_and_execute: SQL Execute error -1! Attempting a 
reconnect...
Nov 21 13:04:17 sip asterisk[22463]: NOTICE[29099]: res_odbc.c:537 in 
odbc_obj_connect: Connecting asterisk
Nov 21 13:04:17 sip asterisk[22463]: NOTICE[29099]: res_odbc.c:565 in 
odbc_obj_connect: res_odbc: Connected to asterisk [asterisk]
Nov 21 13:04:17 sip asterisk[22463]: WARNING[29099]: res_odbc.c:105 in 
ast_odbc_prepare_and_execute: SQL Execute returned an error -1: HY000: 
[MySQL][ODBC 5.1 Driver][mysqld-5.1.57-rel12.8-log]Cannot add or update 
a child row: a foreign key constraint fails 
(`kamailio`.`voicemail_spool`, CONSTRAINT `v_s_mailboxuser_ref` FOREIGN 
KEY (`mailboxuser`) REFERENCES `voicemail_users` (`customer_id`) ON (289)
Nov 21 13:04:17 sip asterisk[22463]: WARNING[29099]: res_odbc.c:113 in 
ast_odbc_prepare_and_execute: SQL Execute error -1! Attempting a 
reconnect...
Nov 21 13:04:22 sip asterisk[22463]: NOTICE[29099]: res_odbc.c:537 in 
odbc_obj_connect: Connecting asterisk
Nov 21 13:04:22 sip asterisk[22463]: NOTICE[29099]: res_odbc.c:565 in 
odbc_obj_connect: res_odbc: Connected to asterisk [asterisk]
Nov 21 13:04:22 sip asterisk[22463]: WARNING[29099]: 
app_voicemail.c:2540 in copy_file: SQL Execute error!#012[INSERT INTO 
voicemail_spool (dir, msgnum, context, macrocontext, callerid, origtime, 
duration, recording, mailboxuser, mailboxcontext) SELECT 
?,?,context,macrocontext,callerid,origtime,duration,recording,?,? FROM 
voicemail_spool WHERE dir=? AND msgnum=?] (You probably don't have MySQL 
4.1 or later installed)#012
Nov 21 13:15:31 sip asterisk[22463]: WARNING[1537]: app_voicemail.c:3549 
in invent_message: failed to stream/wait '12073911122'

-- 
Jonathan Scott Knox
Systems Administrator
XATel Communications
7 Green Street, Biddeford ME. 04005
207.391.1000
Mon - Thur, 9AM to 6PM, Fri - 9AM to 5PM EST