All Questions
5 questions
1
vote
1
answer
2k
views
mysql deadlock when update some items whose id are selected from another table
I'm sorry, I just can speak a little English.
I have two machines(10.10.102.101, 10.10.102.104) which connect to the same mysql datebase.
This is a table and deadlock happened on it.
mysql> ...
- 11
0
votes
1
answer
1k
views
How to determine if the error was a deadlock?
The following transaction has been selected as a victim of a deadlock:
public void side2() throws SQLException, InterruptedException {
TestConnectionPool connectionPool = new TestConnectionPool();...
- 309
1
vote
3
answers
1k
views
Deadlock on inserts to a single table with a single key. (Mysql)
I have a simple game server.
One of the requirement i received was to handle a single request for a single player at a time. so in order to achieve that i decided to create a lock table:
CREATE TABLE ...
- 365
0
votes
2
answers
3k
views
ORA-00060 | DEADLOCK DETECTED
We faced Oracle deadlock (ORA-00060) problem on live for our Java/J2EE based web application. The trace file is pasted below:
The following deadlock is not an ORACLE error. It is a
deadlock due to ...
- 25
3
votes
2
answers
844
views
Getting a Deadlock,
I have this code :
public void saveItems(List<Pair<Item, MapleInventoryType>> items, int id) throws SQLException {
PreparedStatement ps = null;
PreparedStatement pse = null;
...
- 31