[rt-users] Call external script in scrip

Kevin Falcone falcone at bestpractical.com
Wed Feb 5 10:41:17 EST 2014

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

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 235 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20140205/b1c26158/attachment.sig>

More information about the rt-users mailing list