Re: LOCK TABLES error , on a select without any update ?

2003-02-22 Thread Steff
their is something in it which will catch your eye. Thanks Steff On 22 Feb 2003 at 10:52, Heikki Tuuri wrote: From: "Heikki Tuuri" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]> Copies to:

Re: LOCK TABLES error , on a select without any update ?

2003-02-21 Thread Steff
kind of error? Can we test for the state from within our code ? Thanks again for your patience and assistance. I really want to be able to make MySql work for this application. Thanks Steff Steff, > We have our connection set to Autocommitt=1, and No table locks > are ever explicitly bein

LOCK TABLES error , on a select without any update ?

2003-02-20 Thread Steff
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

Re: Transaction problems using InnoDB, "not locked with LOCKTABLES"

2003-02-13 Thread Steff
bulb will go on and show me some stupid thing I am doing without realizing it. :) By the way, thanks for the code snippet on the counter. We have already modified ourbase class to incorporate this. The code is undergoing test today and tomorrow. Thanks Steff On 13 Feb 2003 at 1

Re: Transaction problems using InnoDB, "not locked with LOCKTABLES"

2003-02-13 Thread Steff
transaction has been cancelled due to some SQL exception. Is there a way to ask a conception if there is an open transaction ? Thanks Steff On 13 Feb 2003 at 21:59, Heikki Tuuri wrote: From: "Heikki Tuuri" <[EMAIL PROTECTED]> To:

Re: Transaction problems using InnoDB, "not locked with LOCKTABLES"

2003-02-13 Thread Steff
how to narrow the focus of our research would be greatly appreciated. Thanks Steff On 13 Feb 2003 at 20:03, Heikki Tuuri wrote: From: "Heikki Tuuri" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Copies to: <[EMAIL PROTECTE

Re: Transaction problems using InnoDB, "not locked with LOCKTABLES"

2003-02-13 Thread Steff
a table lock on one connection would affect a transaction tacking place on another connection, provided none of the SQL statements within the transaction touch the table being locked ? Thanks in advance for your guidance. Steff On 13 Feb 2003 at 16:48, Heikki Tuuri wrote: From

Re: Transaction problems using InnoDB, "not locked with LOCKTABLES"

2003-02-11 Thread Steff
ms we have lurking in our code. Thanks again for taking the time to reply. This problem has been haunting us for two months now and yours is the first contact we have had with someone who works with MySql in a production environment. Thanks Steff On 11 Feb 2003 at 19:09, Mark Matt

Transaction problems using InnoDB, "not locked with LOCKTABLES"

2003-02-11 Thread Steff
e to determine what other activities taking place on the server/tables are causing the conflict. Other applications are running against this database which are doing allot of Selects and a few updates, all without any explicit transaction control (autocommit=1). Will someone please provide us