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

[Tilghman Lesher]

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