JR Richardson
2009-Jan-05 17:40 UTC
[asterisk-users] cdr_addon_mysql 'Failed to insert into database' stops * call processing
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
Tilghman Lesher
2009-Jan-05 18:28 UTC
[asterisk-users] cdr_addon_mysql 'Failed to insert into database' stops * call processing
On Monday 05 January 2009 11:40:07 JR Richardson wrote:> 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?Not a patch, per se, but you could turn on batch processing in cdr.conf. -- Tilghman