Symptom
- During PITR restore, utility_db aborts in s_dbmvbio::WriteCheck.
Excerpt of IQMSG for utility_db
..
.. **************************************************
.. *** SAP IQ Abort:
.. *** From: slib/s_db.cxx:1526
.. *** Rethrown from: oslib/hos_throw.cxx:316
..
===== Thread Number .... ====
..
.. hos_ABORT ..
.. Throw..
.. s_dbmvbio::WriteCheck ..
.. hos_mvbio::Write ..
.. s_pitrMixedStrategyLogIter::WriteRecsToStore ..
.. s_pitrMixedStrategyLogIter::begin ..
.. s_pitrlog_replay::ReplayTxnMeta ..
.. s_pitrlog::ReplayTxnMeta ..
.. s_pitrlog::Replay ..
.. st_database::RecoveryPlayback ..
- On the source database where the backup was taken, the option IQ_LOG_MAX_SIZE was set to a small size (for ex 10 Mb).
This causes hundreds of PITR logs (.iqlog) of 10 Mb be generated.
Example
In the directory where PITR logs are located, for record 0731, there are 224 files named PITRLOG_000_000731_*.iqlog
/mnt/sybase_iqlog_prod/SAPIQDB/PITRLOG_000_000731_0001_20211218_120002477338.iqlog
...
/mnt/sybase_iqlog_prod/SAPIQDB/PITRLOG_000_000731_0224_20211218_120002477338.iqlog
- If trying to start the partially restored database, the error below error is found:
Error: Failed to open PITR log /.../pitrarclog/PITRIBPLOG_000_000731_0219_20211218_120002477338.iqlog for logging.
-- (stcxtlib/st_database.cxx 9758)
Read more...
Environment
SAP IQ 16.1 SP04 PL09
Product
Keywords
826131, CR826131, CR#826131, "Failed to open PITR log",
IQ_LOG_MAX_SIZE, s_dbmvbio::WriteCheck, s_pitrMixedStrategyLogIter::WriteRecsToStore, s_pitrMixedStrategyLogIter::begin, s_pitrlog_replay::ReplayTxnMeta, s_pitrlog::ReplayTxnMeta, s_pitrlog::Replay , 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.