Description:
----------
create table test (id int ,name text)engine=innodb;
insert into test values ( 1, 'test');
----------
Pattern 1
----------
CLIENT A:
begin;
select * from test lock in share mode;
----------
CLIENT B:
begin;
update test set name='bbb' where id=1;
After 50sec,The following messages are output to the client.
ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
----------
MYSQL didn't add error message to error.log.
----------
Pattern 2
----------
CLIENT A:
begin;
update test set name='oooo' where id=1;
----------
CLIENT B:
select * from test order by id, name for update;
After 50sec,The following messages are output to the client.
ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
----------
MYSQL did add error message to error.log.
060808 15:46:09 [ERROR] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Lock wait timeout exceeded; try restarting transaction
060808 15:46:09 [ERROR] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Sort aborted
How to repeat:
----------
create table test (id int ,name text)engine=innodb;
insert into test values ( 1, 'test');
----------
Pattern 1
----------
CLIENT A:
begin;
select * from test lock in share mode;
----------
CLIENT B:
begin;
update test set name='bbb' where id=1;
After 50sec,The following messages are output to the client.
ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
----------
MYSQL didn't add error message to error.log.
----------
Pattern 2
----------
CLIENT A:
begin;
update test set name='oooo' where id=1;
----------
CLIENT B:
select * from test order by id, name for update;
After 50sec,The following messages are output to the client.
ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
----------
MYSQL did add error message to error.log.
060808 15:46:09 [ERROR] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Lock wait timeout exceeded; try restarting transaction
060808 15:46:09 [ERROR] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Sort aborted