[Spce-user] Asterisk crashed, voicemail issues.

[Jonathan Scott]

I will not know if the issue that customer is happening can be 
reproduced or not until tomorrow or so, as I give 24 hour notice for 
maintenance and I will reboot sometime late tonight.

As far as the database schema issue, it still persists after running 
those statements.
I've tried for a few days to pinpoint where the problem is, but I do not 
see a problem with the foreign key constraint in any way. I'm not an sql 
guru but I can't see anything wrong in the DB.

Nov 22 14:08:56 sip asterisk[4755]: WARNING[1009]: 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 22 14:08:56 sip asterisk[4755]: WARNING[1009]: res_odbc.c:113 in 
ast_odbc_prepare_and_execute: SQL Execute error -1! Attempting a 
reconnect...
Nov 22 14:09:01 sip asterisk[4755]: NOTICE[1009]: res_odbc.c:537 in 
odbc_obj_connect: Connecting asterisk
Nov 22 14:09:01 sip asterisk[4755]: NOTICE[1009]: res_odbc.c:565 in 
odbc_obj_connect: res_odbc: Connected to asterisk [asterisk]
Nov 22 14:09:01 sip asterisk[4755]: WARNING[1009]: 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 22 14:09:01 sip asterisk[4755]: WARNING[1009]: res_odbc.c:113 in 
ast_odbc_prepare_and_execute: SQL Execute error -1! Attempting a 
reconnect...
Nov 22 14:09:06 sip asterisk[4755]: NOTICE[1009]: res_odbc.c:537 in 
odbc_obj_connect: Connecting asterisk
Nov 22 14:09:06 sip asterisk[4755]: NOTICE[1009]: res_odbc.c:565 in 
odbc_obj_connect: res_odbc: Connected to asterisk [asterisk]
Nov 22 14:09:06 sip asterisk[4755]: WARNING[1009]: 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


On 11/21/2011 06:20 PM, Jon Bonilla wrote:
> El Mon, 21 Nov 2011 13:51:51 -0500
> Jonathan Scott<jonathan at xpressamerica.net>  escribió:
>
>>
>> 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 this reproductable after the restart?
>
>> Is there anything other than Asterisk that needs to be restarted when
>> something like this happens?
>>
> mmm. No. restarting asterisk should be enough.
>
>> Also still dealing with this error floating around in VM's log, this
>> happens when user tries to save a message:
>>
> This error was reported as a database schema bug and it will be dolved in
> verion 2.4 (to be released soon). Menawhile you could fix it in version 2.2 by
> executing the following statements in mysql:
>
> ALTER TABLE kamailio.voicemail_spool CHANGE COLUMN origtime origtime
> VARCHAR(16) DEFAULT '';
>
> ALTER TABLE kamailio.voicemail_spool CHANGE COLUMN
> duration duration VARCHAR(16) DEFAULT '';
>
>
>
>
>
> _______________________________________________
> Spce-user mailing list
> Spce-user at lists.sipwise.com
> http://lists.sipwise.com/listinfo/spce-user


-- 
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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20111122/53124351/attachment-0001.html>