Skip to Content

Blocking on tempdb*..sysobjects

Aug 21, 2017 at 12:54 PM


avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Bart Van Kuijk
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

10 |10000 characters needed characters left characters exceeded