Skip to Content
avatar image
Former Member

Blocking on tempdb*..sysobjects

We found this issue 3 years ago where tempdb..sysobjects are blocked during an insert-into.

If it helps - its now been confirmed as a bug

CR 789748

and have been fixed in
SAP ASE 16.0 SP02 PL05 HF1 or SAP ASE 16.0 SP03

There's a comment about "...during ZDO SAP upgrade" so not sure if this is completely correct.

Hope this helps.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Aug 31, 2017 at 08:28 AM

    Hi Mike

    The mention of "ZDO SAP upgrade" in the CR description is not helpful at all, as it is completely irrelevant to the underlying ASE issue.

    The CR was opened as the pattern of activity of a 'SAP ZDO upgrade' showed this issue. This issue is in no way specific to this so-called ZDO upgrade. What is happening in ASE is that when creating temp tables, there is a window where ASE takes 'internal' locks on sysobjects, which can cause these deadlocks. This pattern of activity can be reproduced outside of ZDO upgrade and it is a 'normal' ASE codepath in creating temp tables.

    Kind regards

    Bart van Kuijk

    Add comment
    10|10000 characters needed characters exceeded