We are facing an urgent production issue in James Server 2.3.2 in Windows 
2012R2.
The spool table in MS SQL Server always get database DeadLock issue when the 
email volume is a bit high, peak hour can see several hundreds deadlocks.
Monitoring shows the deadlock happened in the sql statement "(@P0 
varbinary(8000), @P1 nvarchar(4000), @P2 nvarchar(4000) Update spool SET 
message_body=@P0 WHERE message_name=@P1 AND repository_name =@P2)
Our spool definition: message_name varchar(200), repository_name varchar(255)
We are using JDBC to connect. Version of MS SQL Server is 2014

Frank Tian


Reply via email to