Subject: Re: LOCK TABLES error , on a select without any update ?
Heikki,
Please do NOT do any more research into this problem for the
time being. I was finally able to capture a log when the problem
occurred in production. In studying the log I discovered two things.
1) The new code to do
Steff,
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Saturday, February 22, 2003 1:26 AM
Subject: Re: LOCK TABLES error , on a select without any update ?
Hi Heikki
]
Subject:Re: LOCK TABLES error , on a select
without any update ?
Date sent: Sat, 22 Feb 2003 10:52:08 +0200
Steff,
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: Heikki Tuuri [EMAIL PROTECTED];
[EMAIL PROTECTED]; [EMAIL PROTECTED
? If yes,
can you check from it what was the number of the connection that issued the
query resulting in an error, and did that same connection earlier issue a
LOCK TABLES?
Regards,
Heikki
Innobase Oy
sql query
..
Subject: LOCK TABLES error , on a select without any update ?
From
Hi Heikki,
Thanks for picking up on this again. After the help from
you and Mark last week, we removed ALL instances of the
lock tables from our application. We used the idea Mark
provided for getting our next sequence number without using
any locks. In the past this was the only thing
Hi All,
Once again we have run into a situation where our production
database is throwing an error regarding the use of table locks for
no apparent reason.
We are running MySql on windows with InnoDb. We have a section
of code which is working fine most of the time but occasionally will