[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
released.
-kevin
-------------- 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