MySQL deadlock

Imam prilojenie deto si vyrvi na MicrosoftSQL i MySQL s MyISAM tablici. Kato obyrna tablicite da sa InnoDB (shtoto mi triabva da poddarjat tranzakcii) i MySQL dava greshka:

java.sql.SQLException: Deadlock found when trying to get lock; try restarting transaction
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1124)
at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:676)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1166)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1082)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1067)

Shte sym mnogo blagodaren ako niakoy ima ideya kade byrkam.

Pozdravi

Zabravih da kaja, 4e ne na vsiaka zayavka mi dava deadlock. Kogato po4vam da vkarvam kup zapisi na vednaj se polu4ava.

Ми ако искаш опитай да пишеш на кирилица. Повече отговори ще получиш.
При InnoDB има няколко вида заключване - трябва четене и опити.

Bеer? Mоre?
Плацебото

[линк]


14.2.10.11. How to Cope with Deadlocks

....

salle.online.bg/sig