3150203 - During PITR restore, utility_db aborts in s_dbmvbio::WriteCheck - SAP IQ

• 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)

 SAP IQ 16.1 SP04 PL09

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