2338521 - Coordinator crash on s_blockmap::ValidLogicalBlockId - SAP IQ 16

• Coordinator (CN) crash on s_blockmap::ValidLogicalBlockId and cannot restart.
• sp_iqcheckdb 'check database' executed on the designated failover server (here a reader) reports no error.
• After executing COMMIT; BEGIN TRANSACTION, the reader fails to start as failover server with iq_mpx_failover 1,
  with the same stack trace as the CN.
• When the CN and the failover server fail to start and this stack trace is generated:

ChkDone [NumTxnCP: 5]
PostChk
CloseDatabase
main Bufman: Incorrect page header read; buffer={btype=14,nlb=16,blk=543494,pbn=543494,npb=16,uid=32247,mn=2,upmn=2,flgs=0x80000000 page={btype=16,nlb=16,npb=16,ctr=131,cta=131,pbn
=543494,txn=0,sp=0,ver=1,pb=2,pus=1}. slib/s_trycatch.cxx:2797
There was an s_buf::Read() error during s_bufman::Find().
 
**************************************************
***   SAP IQ Abort:
***      From:  stcxtlib/st_server.cxx:1918
***      PID: 5552
***      Message: caught signal 11, program abort
***      Thread: 140571959092992  (TID: 3)
**************************************************

**  Command text: 
Statement text unavailable

***************** This is the STACKTRACE ***************
 
s_blockmap::ValidLogicalBlockId
v2s_bmcontext::bmver()
v2s_bmcontext::bmverify()
s_bm::Verify()
s_bm_shared::Verify()
s_iqstoreCPLogHelp::s_iqstoreCPLogHelp
s_iqstore::ReplayCheckpointLog
st_database::RecoveryReplayCheckpoint
st_database::OpenDatabase
db_opendb::Execute()
st_command::DoCmdThroughResourceGate()
st_iqctl::OpenDB
UIQCtl_OpenDB
st_SAIQInterfaceInfo::callFunction()
st_SAIQInterface::RunIQFunc
st_SAIQInterface::Execute
saint_iqthresholdctl::OpenDB
Database::initialize_iq_open_db
Database::initialize
InitProcedure::call()
Worker::spawn(Procedure*)
StartDatabase
RQStartDatabase::do_request()
RQBaseItem::do_work(Worker*)
RequestQueue::worker_body()
request_task(void*)
run_task_body+0x2d
UnixTask::pre_body(void*)

Sometimes the following messge print to iqmsg file when start IQ failed:

********************************************************

There was an s_buf::Read() error during s_bufman::Find().
Warning: s_blockmap is throwing while user locked. bmp:0x7ffd9e80f678 lockRefCount:x created from:slib/s_iqstore.cxx:1793 locked from:slib/s_blockmap.cxx:1333

 Informational stack trace from Diagnostic Stacktrace in s_blockmap::ThrowError for user locked blockmap  at slib/s_blockmap.cxx:13245 on thread xxxx (TID 2)

SAP IQ 16 SP 10 PL 02

800104 ; CR 800104 ; s_blockmap::ValidLogicalBlockId ; s_blockmap ; ValidLogicalBlockId ;
s_iqstoreCPLogHelp::s_iqstoreCPLogHelp ; s_iqstoreCPLogHelp ; s_iqstoreCPLogHelp ;
s_iqstore::ReplayCheckpointLog ; s_iqstore ; ReplayCheckpointLog ;
st_database::RecoveryReplayCheckpoint ; st_database ; RecoveryReplayCheckpoint ;
st_database::OpenDatabase ; st_database ; OpenDatabase ; , KBA , BC-SYB-IQ , Sybase IQ , Problem