Uploaded image for project: 'James Server'
  1. James Server
  2. JAMES-1608

Spool manager getting deadlocked

    XMLWordPrintableJSON

    Details

    • Flags:
      Important

      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.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              manasi2011 manasi
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:

                Time Tracking

                Estimated:
                Original Estimate - 120h
                120h
                Remaining:
                Remaining Estimate - 120h
                120h
                Logged:
                Time Spent - Not Specified
                Not Specified