SAP Knowledge Base Article - Preview

1930404 - sp_iqcheckdb of single dbspace can crash IQ server

Symptom

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
...


Read more...

Environment

SAP Sybase IQ (IQ) 16 and IQ 16 SP01

all platforms

Product

SAP IQ 16.0

Keywords

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 ONE Support launchpad (Login required).

Search for additional results

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