3 Replies Latest reply on May 5, 2014 3:20 PM by larin

    ePO 5.1.0 and SQL Deadlocks

    larin

      All, I upgraded ePO from 4.6.7 to 5.1.0 yesterday. Now I'm seeing deadlocks every 5-6 minutes in my SQL 2008 instance. Here are the processes captured during the deadlock:

       

      Process #1:

      update OrionSchedulerTask set LastRunTime =  @P0  where Id =  @P1   

       

      Process #2:

      IF EXISTS (

            SELECT 1 FROM [dbo].[OrionSchedulerTaskMT] q

              INNER JOIN inserted i

                  ON q.UniqueKey = i.UniqueKey -- nulls will drop out; they don't equal anything

                  GROUP BY q.UniqueKey

                  HAVING COUNT(*) > 1          -- if there is more than one row with given values, uniqueness has been violated

          )    

       

      How do I stop this?