SAP Knowledge Base Article - Preview

1930404 - sp_iqcheckdb of single dbspace can crash IQ server


Database crash after running sp_iqcheckdb 'check dbspace <dbspacename>' with stacktrace similar to the below:

===== Thread Number 3087550208 (IQ connID: 0000063567) =====
pc: 0x7f200d8d8c06 pcstkwalk(stk_trace*, int, db_log*, hos_fd*)+0x36
pc: 0x7f200d8d8e71 ucstkgentrace(int, int)+0x121
pc: 0x7f200d8da0ae DumpAllThreads(char const*, unsigned int, int)+0x12e
pc: 0x7f200d66c6ae hos_ABORT(char const*, unsigned int, char const*, char*, char*)+0x19e
pc: 0x7f200e3463ef SigHndlr+0x4f
pc: 0x363f40f500
pc: 0x7f200e3d90ca db_IndexDef::GatherStatistics(hs_xstats*)+0x23a
pc: 0x7f200e5169a4 db_Statistics::db_Statistics(hdb_catObj&, hs_xstats*, db_dbccIter*)+0x2da
pc: 0x7f200e517cb8 db_dbccIter::ExecWork(int&, unsigned int)+0x1030
pc: 0x7f200d8ae2ba workAllocator::DoWork(unsigned int)+0xba



SAP Sybase IQ (IQ) 16 and IQ 16 SP01

all platforms


SAP IQ 16.0


sp_iqcheckdb, stacktrace, db_IndexDef::GatherStatistics, IQ 16 , , 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 for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.