[
https://issues.apache.org/jira/browse/JAMES-1608?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Tellier Benoit updated JAMES-1608:
----------------------------------
Labels: performance (was: easyfix performance)
> Spool manager getting deadlocked
> --------------------------------
>
> Key: JAMES-1608
> URL: https://issues.apache.org/jira/browse/JAMES-1608
> Project: James Server
> Issue Type: Bug
> Components: James Core, SpoolManager & Processors, UsersStore &
> UsersRepository
> Affects Versions: 2.3.2
> Environment: Windows 2012 Server R2, SQL Server 2014 and Tomcat 7.0
> Reporter: manasi
> Labels: performance
> Original Estimate: 120h
> Remaining Estimate: 120h
>
> 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.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]