Steff, I am carbon copying this to [EMAIL PROTECTED] so that people see the problem was probably found.
----- Original Message ----- From: <[EMAIL PROTECTED]> To: "Heikki Tuuri" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, February 23, 2003 5:33 AM 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 away with locks has not made it into > production. I mistakenly thought it was part of a release this past > Thursday, it turns out it is scheduled to go into production this > coming Thursday. > > 2) The log clearly shows where we are doing a lock/unlock on the > same connection which we had reserved for exclusive use by the > transaction. We need to do some more digging, but my initial guess > is that under heavy load our connection manager was occasionally > handing out a connection to more then one "user". ... > Once again much thanks. > > Bye > Steff Best regards, Heikki Innobase Oy sql query --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php