Hi,
I have 1 SP that does INSERT and UPDATE query to 1-2 tables. It runs ok
for sometime, but i sometime got this error message:
ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
The message would ussually dissapear and the SP runs well for sometime until
the same
: Friday, June 28, 2002 1:29 AM
Subject: InnoDB: Lock wait timeout problem. Please help.
Hi all,
I am using MySQL (version 3.23.51-max-log). I have a problem with locking.
Let's assume that we have 2 connections (Conn1 and Conn2) and table test
, June 28, 2002 10:42 AM
Subject: Re: InnoDB: Lock wait timeout problem. Please help.
Mikhail,
I think MySQL in this case waits for a MySQL table level lock. Note that
CREATE TABLE ... SELECT ... sets shared locks on the rows it reads in the
SELECTed table.
Workaround: use
SELECT
: Friday, June 28, 2002 11:20 AM
Subject: Re: InnoDB: Lock wait timeout problem. Please help.
Heikki,
Thank you very much for response.
But I still don't understand why do I have lock in Conn1.
Let's go through statement again.
Conn1: begin;
Conn1: update test set name = 'rat' where id = 3
Hi all,
I am using MySQL (version 3.23.51-max-log). I have a problem with locking.
Let's assume that we have 2 connections (Conn1 and Conn2) and table test:
CREATE TABLE `test` (
`id` int(3) NOT NULL auto_increment,
`name` char(10)
Hi all!
I am using MySQL (version 3.23.51-max-log). I have a problem with locking.
Let's assume that we have 2 connections (Conn1 and Conn2) and table test:
CREATE TABLE `test` (
`id` int(3) NOT NULL auto_increment,
`name` char(10)
