Re: DeadLock bug using mysql/Innodb

2002-11-05 Thread Heikki Tuuri
Rafa, - Original Message - From: <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Tuesday, November 05, 2002 11:00 AM Subject: DeadLock bug using mysql/Innodb > Description: > Hi Heikki, > > In your case: > > >CREATE TABLE t (a INT NOT NULL, PRI

DeadLock bug using mysql/Innodb

2002-11-05 Thread rafarife
Description: Hi Heikki, In your case: >CREATE TABLE t (a INT NOT NULL, PRIMARY KEY (a)) TYPE = INNODB; >INSERT INTO t VALUES (90); INSERT INTO t VALUES (110); >User 1: >SELECT * FROM t WHERE a >= 100 FOR UPDATE; >User 2: >SELECT * FROM t WHERE a >= 100 FOR UPDATE; > >Now if user 1 tries to

Re: DeadLock bug using mysql/Innodb

2002-11-04 Thread Heikki Tuuri
Rafa, - Original Message - From: <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Monday, November 04, 2002 6:06 PM Subject: DeadLock bug using mysql/Innodb > Description: > Hello, > > I have a deadlock problem when I try to execute some update sentences

DeadLock bug using mysql/Innodb

2002-11-04 Thread rafarife
Description: Hello, I have a deadlock problem when I try to execute some update sentences using 'Lock For Update'. I need to create a new document which is identified by a unique number, which is stored in the field 'Ped' of the table 'Pedidos'. To obtain a new document number I add 1 to the co