[asterisk-users] cdr_addon_mysql 'Failed to insert into database' stops * call processing

[JR Richardson]

Hi All,

I have some Asterisk 1.2 servers using the cdr_mysql addon (1.2.3)
spitting cdr's over to a MySQL database on another server.  All is
working well except for a strange problem I ran into this morning.
During some cdr database maintenance, the cdr table was locked for a
few minutes, during this condition all the Asterisk servers stopped
processing calls and reported this error:

Jan  5 09:57:03 ERROR[938]: cdr_addon_mysql.c:226 mysql_log:
mysql_cdr: Failed to insert into database: (1205) Lock wait timeout
exceeded; try restarting transaction
Jan  5 09:57:54 ERROR[970]: cdr_addon_mysql.c:226 mysql_log:
mysql_cdr: Failed to insert into database: (1205) Lock wait timeout
exceeded; try restarting transaction
Jan  5 09:58:45 ERROR[515]: cdr_addon_mysql.c:226 mysql_log:
mysql_cdr: Failed to insert into database: (1205) Lock wait timeout
exceeded; try restarting transaction

Is there possibly a patch to addons that would relieve this issue?

Thanks.

JR
--
JR Richardson
Engineering for the Masses