![]() This problem will be more prominent under high load environments when there are more concurrent page creates/edits. Rerun the transaction.Īt .SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:367)Īt .TdsCore.tdsErrorToken(TdsCore.java:2816)Īt .TdsCore.nextToken(TdsCore.java:2254)Īt .TdsCore.getMoreResults(TdsCore.java:631)Īt .JtdsStatement.processResults(JtdsStatement.java:584)Īt .JtdsStatement.executeSQL(JtdsStatement.java:546)Īt .JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:505)Īt 2.(NewProxyPreparedStatement.java:105)Īt net.sf.(NonBatchingBatcher.java:22)Īt net.sf.(EntityPersister.java:581)Īt net.sf.(ScheduledDeletion.java:29)Īt net.sf.(SessionImpl.java:2449)Īt net.sf.(SessionImpl.java:2435)Īt net.sf.(SessionImpl.java:2397)Īt net.sf.(SessionImpl.java:2261)Īt net.sf.(JDBCTransaction.java:61) Rerun the transaction.Ĭaused by: : Transaction (Process ID 55) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. nested exception is : Transaction (Process ID 55) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. : Hibernate operation: could not delete: SQL Transaction (Process ID 55) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. url: /confluence/pages/docreatepage.action | userName: tstcreator3 ![]() ![]() 17:01:21,359 ERROR onThrowable Invoking rollback for transaction on action '/pages/docreatepage.action (CreatePageAction.doAdd())' due to throwable: : Hibernate operation: could not delete: SQL Transaction (Process ID 55) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. 17:01:21,357 ERROR execute Could not synchronize database state with session 17:01:21,355 ERROR logExceptions Transaction (Process ID 55) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. url: /confluence/pages/docreatepage.action | userName: tstcreator3 | action: docreatepage 99% of the time the CPU has no significate CPU load, I can hardly accept that we have to add more an more CPU's just to prevent these very short spikes most of the time a deadlock happens.17:01:21,355 ERROR logExceptions Transaction (Process ID 55) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.Īny ideas? With Veeam support I tried to clean up the DB but it seems there is not much to clean up anymore. 04:04:25 :: Failed to offload backup Error: Transaction (Process ID 106) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. 04:05:33 :: Failed to offload backup Error: Transaction (Process ID 360) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. 04:04:56 :: Failed to offload backup Error: Transaction (Process ID 561) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. 04:08:15 :: Failed to offload backup Error: Transaction (Process ID 599) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. 04:08:45 :: Failed to offload backup Error: Transaction (Process ID 158) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. 05:26:53 :: Failed to offload backup Error: Transaction (Process ID 452) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. 05:27:37 :: Failed to offload backup Error: Transaction (Process ID 281) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. ![]() 05:28:07 :: Failed to offload backup Error: Transaction (Process ID 601) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. 05:28:57 :: Failed to offload backup Error: Transaction (Process ID 80) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. ![]() Code: Select all 05:31:47 :: Failed to offload backup Error: Transaction (Process ID 80) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |