SAP Knowledge Base Article - Preview

2563769 - sp_iqcheckdb with verify mode got unresponsive even when no user connections.

Symptom

  • Symptom 1:
    sp_iqcheckdb with verify mode got unresponsive even when no user connections.
  • Symptom 2:
    checkpoint process as part of backup could trigger deadlock situation resulting in server hang state
    ValidateBackup              
    IQ Checkpoint position: 0   
    Chk                         
    ChkDone [NumTxnCP: 11]      
    IQ Checkpoint block: 6710946
    PrepareForBackup 
  • Thread in stacktrace during the hang:
             __lll_lock_wait
             _L_lock_812
             pthread_mutex_lock
             hos_dualmutex::LockAndPromote
             s_blockmap::RegisterPhysicalBlockId
             s_blockmap::AllocOrReallocPhysicalBlocks
             s_buf::Write

Read more...

Environment

SAP IQ 16.1

Product

SAP IQ 16.1

Keywords

KBA , BC-SYB-IQ , Sybase IQ , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.