On Mon, Feb 03, 2014 at 12:33:17PM +0100, Anthony BRODARD wrote: > Feb 3 12:09:50 bob RT: [10535] DBD::mysql::st execute failed: Lock wait > timeout exceeded; try > restarting transaction at > /usr/local/share/perl/5.14.2/DBIx/SearchBuilder/Handle.pm line 589. > Feb 3 12:09:50 bob RT: [10535] RT::Handle=HASH(0x71041f8) couldn't execute > the query 'SELECT * > FROM Tickets WHERE id = ? FOR UPDATE' at
It appears that RT is holding a lock for updating your ticket while a second script connects and then times out attempting to update the same ticket. I suggest that your main scrip become a Batch scrip so that it runs after the initial transaction completes and the lock is released. -kevin
pgprVQQ4srdnK.pgp
Description: PGP signature
