<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#ffffff">
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.<br>
<br>
As far as the database schema issue, it still persists after running
those statements.<br>
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.<br>
<br>
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)<br>
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...<br>
Nov 22 14:09:01 sip asterisk[4755]: NOTICE[1009]: res_odbc.c:537 in
odbc_obj_connect: Connecting asterisk<br>
Nov 22 14:09:01 sip asterisk[4755]: NOTICE[1009]: res_odbc.c:565 in
odbc_obj_connect: res_odbc: Connected to asterisk [asterisk]<br>
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)<br>
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...<br>
Nov 22 14:09:06 sip asterisk[4755]: NOTICE[1009]: res_odbc.c:537 in
odbc_obj_connect: Connecting asterisk<br>
Nov 22 14:09:06 sip asterisk[4755]: NOTICE[1009]: res_odbc.c:565 in
odbc_obj_connect: res_odbc: Connected to asterisk [asterisk]<br>
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<br>
<br>
<br>
On 11/21/2011 06:20 PM, Jon Bonilla wrote:
<blockquote cite="mid:20111122002025.67fab61d@quenya" type="cite">
<pre wrap="">El Mon, 21 Nov 2011 13:51:51 -0500
Jonathan Scott <a class="moz-txt-link-rfc2396E" href="mailto:jonathan@xpressamerica.net"><jonathan@xpressamerica.net></a> escribió:
</pre>
<blockquote type="cite">
<pre wrap="">
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.
</pre>
</blockquote>
<pre wrap="">
Is this reproductable after the restart?
</pre>
<blockquote type="cite">
<pre wrap="">Is there anything other than Asterisk that needs to be restarted when
something like this happens?
</pre>
</blockquote>
<pre wrap="">
mmm. No. restarting asterisk should be enough.
</pre>
<blockquote type="cite">
<pre wrap="">Also still dealing with this error floating around in VM's log, this
happens when user tries to save a message:
</pre>
</blockquote>
<pre wrap="">
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 '';
</pre>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
Spce-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Spce-user@lists.sipwise.com">Spce-user@lists.sipwise.com</a>
<a class="moz-txt-link-freetext" href="http://lists.sipwise.com/listinfo/spce-user">http://lists.sipwise.com/listinfo/spce-user</a>
</pre>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">--
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</pre>
</body>
</html>