Re: locking problems
Posted by:
Mike Beck
Date: February 15, 2005 10:06AM
so from the innodb status we cannot see what actually caused the deadlock, the two queries were not really locking each other, but would be worked on as soon as another, unknown query would no longer lock the auto-inc column?
so there is one query which still has that lock and is not ending but which is not in a deadlock situation? how can i find out what that is?
I assume i should try to find out which query exactly is causing the problems instead of just using INSERT IGNORE on every insert query i use?
Subject
Views
Written By
Posted
3877
February 09, 2005 10:47AM
2583
February 13, 2005 04:21AM
Re: locking problems
2647
February 15, 2005 10:06AM
2470
February 15, 2005 02:09PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.