SAP Knowledge Base Article - Preview

2985398 - SAP IQ upgrade fails on RLV store recovery - SAP IQ

Symptom

  • Upgrade from SAP IQ 16.0 to 16.1
  • The database fails to start with the SAP 16.1 binaries
  • The database have RLV enabled tables, or RLV tables were enabled in the past and currently disabled
  • The abort stack trace below can be seen

Excerpt of IQMSG

OpenDatabase Completed
....
Database Option for asynchronous I/O is enabled.
.....
Expected block 37663489 but got block 0.This may be normal when establishing the end of the log
Database BIO is asynchronous I/O enabled for RLV.
Log buffer manager using asynchronous I/O for RLV.
RLV Flusher Enabled.
RLV Logging Enabled.
Expected block 37663505 but got block 0.This may be normal when establishing the end of the log
rv_LogStreamBase::LoadIdentity -- Invalid page BlockId-requested: 37663505. ret: 6.9186e-310ot: 0
Last Commit Txn ID from database: 1299674377


**************************************************
*** SAP IQ Abort:
*** From: stcxtlib/st_server.cxx:2332
*** PID: 9520
*** Message: caught signal 11, program abort
*** Thread: 140034053240576 (TID: 2)
**************************************************

__do_global_dtors_aux_fini_array_entry
rv_CommitLogStream::ShouldDoPITR
rv_LogRecoveryMgr::InstallCommitLog
rv_LogRecoveryMgr::Initialize
rv_Mgr::Recover
st_database::RecoverRLVStore
UIQCtl_RecoverRLVStore
st_SAIQInterfaceInfo::callFunction
st_SAIQInterface::RunIQFunc(st_SAIQInterfaceInfo*)
st_SAIQInterface::Execute(int, void*, unsigned int
saint_iqthresholdctl::RecoverRLVStore(IDatabase*)
StartDatabase(a_single_db_config*, RQStartDatabaseParam*, unsigned int, unsigned int)
RQStartDatabase::do_request()


Read more...

Environment

  • SAP IQ 16.0
  • SPA IQ 16.1

Product

SAP IQ 16.0 ; SAP IQ 16.1

Keywords

823198, CR823198,CR#823198, rv_CommitLogStream::ShouldDoPITR,, rv_LogRecoveryMgr::InstallCommitLog,  rv_LogRecoveryMgr::Initialize, rv_Mgr::Recover, st_database::RecoverRLVStore, UIQCtl_RecoverRLVStore , KBA , BC-SYB-IQ , Sybase IQ , Bug Filed

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.