Re: identifying the cause of old active transactions with locks

2012-09-03 Thread Raphael Bauduin
On Mon, Sep 3, 2012 at 11:32 AM, Raphael Bauduin wrote: > Hi, > > In the output of > SHOW ENGINE INNODB STATUS \G > > I have several old active transactions, each having locked some rows. > All or from the same process id, but with different thread ids. This > is the oldest one, which is 2.5 day

identifying the cause of old active transactions with locks

2012-09-03 Thread Raphael Bauduin
Hi, In the output of SHOW ENGINE INNODB STATUS \G I have several old active transactions, each having locked some rows. All or from the same process id, but with different thread ids. This is the oldest one, which is 2.5 days old: ---TRANSACTION 0 1532609805, ACTIVE 227995 sec, process no 2951