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
through an error complaining that a table is not locked.
Based on the Java stack dump, the SQL statement which caused
this error to appear was
Select TransactionTypeID From transactionheader Where
TransactionHeaderID ="1234"
The error reported was :
java.sql.SQLException: General error: Table 'transactionheader'
was not locked with LOCK TABLES
We have our connection set to Autocommitt=1, and No table locks
are ever explicitly being done on this table anyplace in any of our
code modules.
Will someone please help me understand why a select statement
without an update would ever cause a tables not Locked error ?
Thanks
Steff
--
Steff McGonagle
Envisage Information Systems, Inc.
Phone (315) 497-9202 x16
www.EnvisageSystems.com
www.Enveritus.com
---------------------------------------------------------------------
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
