Why can't output to error log file when INNODB happened ERROR1205? All server error message is output to error log file, isn't it?
---------- 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 -- <[EMAIL PROTECTED]> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]