[JAMES-1608] Spool manager getting deadlocked

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Won't Fix
• Affects Version/s: 2.3.2
• Component/s: James Core, SpoolManager & Processors, UsersStore & UsersRepository
• Labels: performance
• Environment: Windows 2012 Server R2, SQL Server 2014 and Tomcat 7.0
• Flags: Important
• Assignee: Unassigned
• Reporter: manasi
• Created: 03/Sep/15 11:49
• Updated: 09/May/22 02:01
• Resolved: 09/May/22 02:01

Description

I am using the Jdbc Repository for the James mail server and it gets deadlocked. Have noticed that one of the update statement which is executed on a primary key field of "Varchar" locks the key in SQL 2014. When traced the SQL statements executed in SQL Server 2014, noticed that the column's data type is implicitly converted to nvarchar. So the update statement is trying to update the key in nvarchar format, though the data type is varchar.