Client Management Suite

 View Only

  • 1.  getting deadlocks when revising software updates

    Posted Oct 03, 2011 08:12 AM

    ns6

    Hi guys,

    initialy, windows 7 patches was excluded from the patching process.

    I add windows 7 as one of the products that need to be patched; then i revised the patches and now my logs are red with dealock errors...

    Has anyone seen this before  

    i've added a screenshot and logs... thanks for the read

    Attachment(s)

    zip
    a.zip   8 KB 1 version


  • 2.  RE: getting deadlocks when revising software updates

    Broadcom Employee
    Posted Oct 03, 2011 08:41 AM

    Hi toca,

     

    There are several Licensing-related error messages in Altiris Logs. Is license OK for Altiris Patch Management?

     

    Regards,

    Sergei



  • 3.  RE: getting deadlocks when revising software updates

    Posted Oct 03, 2011 08:52 AM

    Licenses all upto date



  • 4.  RE: getting deadlocks when revising software updates

    Posted Oct 07, 2011 02:50 PM

    To figure out the cause of the deadlocking you will need to run SQL Profiler and capture the following events only:

    * Deadlock graph
    * Lock: Deadlock
    * Lock: Deadlock Chain
    * RPC:Completed
    * SP:StmtCompleted
    * SQL:BatchCompleted
    * SQL:BatchStarting

    I'm willing to spend some time looking at it, but if you need immediate help with this then it would be best to call in to support. Sometimes the deadlock can be fixed with a new index, other times the T-SQL needs to be slightly changed to prevent deadlocks (using locking hints or changing the isolation level of the transaction). It could also be possible to fix the issue by turning on read_committed_snapshot isolation mode. But I would only recommend that after first investigating the cause of the deadlocks, since turning that option on can cause performance overhead.