Hi, Running V7.6.14 I keep having this error appear in my logs. How do I solve the issue. I am sure how to track down what 2 resources are trying to update the table at the same time… com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 66) was deadlocked on lock resources w…

SQL Server deadlocked

JordanCClark June 16, 2020, 12:11pm 4

SQL deadlocks on accessing sqlth_sce Ignition

We’re expriencing quite some DB errors due to deadlocks in one of our projects (see screenshots below). After executing DBCC TRACEON (1204, -1) on the SQL server, to trace the deadlocks, I was able to get a log from it: deadlock.log (11.5 KB) It appears that a read and a write to the sqlth_sce table are causing the issue. But I don’t get when or why the system will use that table. What can we investigate to find the root cause of these errors? This system is running 7.9.11 [afbeelding] [af…

1 Like

show post in topic

Home
Categories
Guidelines
Terms of Service
Privacy Policy

Powered by Discourse, best viewed with JavaScript enabled