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.
SAP Knowledge Base Article - Preview