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 for Me (Login required).

Search for additional results

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