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 er
AIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: 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 stat
I
appreciate it very much.
Mikhail.
- Original Message -
From: "Heikki Tuuri" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, June 28, 2002 10:42 AM
Subject: Re: InnoDB: Lock wait timeout problem. Please help.
> Mikhail,
>
> I think MySQL i
PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: 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 c
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)
