Heikki,
Thanks very muich for the explanation. That's an interesting question
for the connection modules in Apache/PHP/DBI etc. Perhaps this is a
problem with the way the connections are opened by those programs. I
hadn't thought of that, so it would definitely be a good thing to test
before
Hi!
It is a bug if the sleeping connection is in the auto-commit mode. But we
need more information of the problem. If you encounter it, please send the
exact sequence of SQL commands which leads to the problem.
You may also test
SET AUTOCOMMIT=1
explicitly in your program.
Note that LOCK TAB
ss, of course, autocommit is on.
--Walt Weaver
Bozeman, Montana
-Original Message-
From: John Kemp [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 09, 2002 1:40 PM
To: Heikki Tuuri
Cc: [EMAIL PROTECTED]
Subject: Re: InnoDB : Lock wait timeout exceeded; Try restarting
transaction
:38 PM
Subject: Re: InnoDB : Lock wait timeout exceeded; Try restarting transaction
>Heikki,
>
>Hmm. That's interesting. So if you do a single command, say
>
>INSERT INTO Table1 (X, Y, Z) VALUES ( A, B, C) ;
>
>You actually need to write (I'm not sure of the exact transa
Heikki,
Hmm. That's interesting. So if you do a single command, say
INSERT INTO Table1 (X, Y, Z) VALUES ( A, B, C) ;
You actually need to write (I'm not sure of the exact transactional
syntax for Mysql) -
BEGIN ; --begin a transaction
INSERT INTO Table1 (X, Y, Z) VALUES ( A, B, C) ;
COMMIT ;
Hi!
Looks like your are not committing your transactions. Every UPDATE and
INSERT automatically sets row level locks, which are only removed when you
do a COMMIT or ROLLBACK.
Or you have set innodb_lock_wait_timeout too small in my.cnf.
InnoDB does not set table level locks. Only LOCK TABLES se
Hi SAm,
I actually had a similar problem myself, but was unable to prove it was
the persistent connection itself causing this. I'm wondering if this
means that INNODB thinks that a connection that is now 'sleeping' (ie.
where a connection was created, used, but is now unused but still open)
m
I recently switched to InnoDB & persistent connections from PHP.
Lately I've been getting these errors "Lock wait timeout exceeded; Try
restarting transaction" on an UPDATE on table. The system is in
development so there is at most one other user ( a back end Perl script).
When I switched PHP