InnoDB table which would not unlock

2007-12-12 Thread Ben Clewett
Dear MySql, Using 5.0.41 I had a single innodb table which would not unlock. I wonder if this might be a bug, or an issue that is known to be fixed in later versions? Any DML like this example: UPDATE ws_queue SET stage = 'committed' WHERE stage = 'running' Would result in: ERROR 1205

Re: InnoDB table which would not unlock

2007-12-12 Thread Baron Schwartz
Hi Ben, On Dec 12, 2007 8:14 AM, Ben Clewett [EMAIL PROTECTED] wrote: Dear MySql, Using 5.0.41 I had a single innodb table which would not unlock. I wonder if this might be a bug, or an issue that is known to be fixed in later versions? Any DML like this example: UPDATE ws_queue SET