james-server-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Tellier Benoit (JIRA)" <server-...@james.apache.org>
Subject [jira] [Updated] (JAMES-1608) Spool manager getting deadlocked
Date Mon, 03 Apr 2017 08:18:41 GMT

     [ 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: server-dev-unsubscribe@james.apache.org
For additional commands, e-mail: server-dev-help@james.apache.org


Mime
View raw message