Symptom
IQ server may crash with stacktrace below, lots of " You have run out of space in IQ_SYSTEM_MAIN DBSpace" messages will be seen in iqmsg.
Stacktrace:
I. 02/09 15:51:21. 0000132645 **************************************************
I. 02/09 15:51:21. 0000132645 *** SAP IQ Abort:
I. 02/09 15:51:21. 0000132645 *** From: slib/s_blockmap.cxx:8253
I. 02/09 15:51:21. 0000132645 *** PID: 55235
I. 02/09 15:51:21. 0000132645 *** Exception Location: 0x0x7f77e1e39820
I. 02/09 15:51:21. 0000132645 *** Error ID: 2096, Exception Type: s_nodbspaceexception
I. 02/09 15:51:21. 0000132645 *** Thread: 140152867645184 (TID: 20, Original TID: 20)
I. 02/09 15:51:21. 0000132645 *** Error #: 0, O/S Error #: 0
I. 02/09 15:51:21. 0000132645 **************************************************
I. 02/09 15:51:21. 0000132645
I. 02/09 15:51:21. 0000132645 ** Error from IQ connection: SA connHandle: 13912 SA connID: 35 IQ connID: 0000132645 User: dwread
I. 02/09 15:51:21. 0000132645 ** Time of error: 2016-02-09 15:51:21
I. 02/09 15:51:21. 0000132645 ** IQ Version: SAP IQ/16.0.0/150327/P/sp08.30
I. 02/09 15:51:21. 0000132645 ** OS info: IQ built on: Enterprise Linux64 - x86_64 - 2.6.18-194.el5, Executed on: Linux/hdcicgdwhld01c/2.6.32-573.3.1.el6.x86_64/#1 SMP Mon Aug 10 09:44:54 EDT 2015/x86_64
I. 02/09 15:51:21. 0000132645 ** Command status when error occured: COMMAND ACTIVE
I. 02/09 15:51:21. 0000132645 ** Command text:
I. 02/09 15:51:21. 0000132645 Dump all thread stacks at oslib/hos_throw.cxx:313 for PID: 55235
I. 02/09 15:51:21. 0000132645
I. 02/09 15:51:21. 0000132645
I. 02/09 15:51:21. 0000132645 pc: 0x7f77dcbd24c2 pcstkwalk(stk_trace*, int, db_log*, hos_fd*)+0x32
I. 02/09 15:51:21. 0000132645 pc: 0x7f77dcbd2b31 ucstkgentrace(int, int)+0x121
I. 02/09 15:51:21. 0000132645 pc: 0x7f77dcbd3d7e DumpAllThreads(char const*, unsigned int, int)+0x12e
I. 02/09 15:51:21. 0000132645 pc: 0x7f77dc960bf0 hos_ABORT(char const*, unsigned int, hos_exception const&, char*, char*)+0x2a0
I. 02/09 15:51:21. 0000132645 pc: 0x7f77dcbb55c1 Throw(hos_exception const&)+0x3e1
I. 02/09 15:51:21. 0000132645 pc: 0x7f77dcc5b961 s_blockmap::ThrowError(s_bufman_errorInfo, char const*, int)+0x171
I. 02/09 15:51:21. 0000132645 pc: 0x7f77dcc7bd98 s_blockmap::Flush()+0xd68
I. 02/09 15:51:21. 0000132645 pc: 0x7f77dea25a07 st_txncb_rfrbInfo::Flush()+0x17
I. 02/09 15:51:21. 0000132645 pc: 0x7f77dea2f679 st_txncb::Combine(st_txncb*, s_bm*, s_bm*)+0x279
I. 02/09 15:51:21. 0000132645 pc: 0x7f77dea41a3e st_txnMgr::CombineTransactions(st_txncb*, st_txncb*)+0x3e
I. 02/09 15:51:21. 0000132645 pc: 0x7f77dea4a037 st_txnMgr::DropVersions(st_txncb*&, hos_mutex_lock&, st_DVStatus, int*)+0xa07
I. 02/09 15:51:21. 0000132645 pc: 0x7f77dea55b69 st_txnMgr::PostCommitTransaction(st_database*)+0x459
I. 02/09 15:51:21. 0000132645 pc: 0x7f77dd85a583 db_PostCommitTransaction::Execute()+0x43
I. 02/09 15:51:21. 0000132645 pc: 0x7f77dd660022 st_command::DoCmdThroughResourceGate()+0x82
I. 02/09 15:51:21. 0000132645 pc: 0x7f77dd6adbd3 st_iqtxn::PostCommitTxn(UIConnection*)+0x23
I. 02/09 15:51:21. 0000132645 pc: 0x7f77dc494fa5 UIQTxn_PostCommitTxn+0x15
Iqmsg:
I. 02/09 15:51:13. 0000132631 Allocation failed. Dbspace IQ_SYSTEM_MAIN is OUT OF SPACE
I. 02/09 15:51:13. 0000132631 [20223]: You have run out of space in IQ_SYSTEM_MAIN DBSpace.
I. 02/09 15:51:13. 0000132631 Allocation successful. Dbspace IQ_SYSTEM_MAIN
I. 02/09 15:51:14. 0000132634 Allocation failed. Dbspace IQ_SYSTEM_MAIN is OUT OF SPACE
I. 02/09 15:51:14. 0000132634 [20223]: You have run out of space in IQ_SYSTEM_MAIN DBSpace.
I. 02/09 15:51:14. 0000132634 [20223]: You have run out of space in IQ_SYSTEM_MAIN DBSpace.
I. 02/09 15:51:14. 0000132634 [20223]: You have run out of space in IQ_SYSTEM_MAIN DBSpace.
I. 02/09 15:51:14. 0000132634 [20223]: You have run out of space in IQ_SYSTEM_MAIN DBSpace.
I. 02/09 15:51:14. 0000132635 Allocation successful. Dbspace IQ_SYSTEM_MAIN
I. 02/09 15:51:19. 0000132641 Allocation failed. Dbspace IQ_SYSTEM_MAIN is OUT OF SPACE
I. 02/09 15:51:19. 0000132641 [20223]: You have run out of space in IQ_SYSTEM_MAIN DBSpace.
Read more...
Environment
- Linux ADM64
- AIX 64
- SAP IQ 16 SP08.30
Product
Keywords
IQ crash, IQ abort, s_nodbspaceexception, slib/s_blockmap, s_blockmap::ThrowError, s_blockmap::Flush(), st_txncb::Combine , 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.