SAP Knowledge Base Article - Preview

2277825 - IQ server abort with stacktrace Exception Type: s_nodbspaceexception

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

SAP Sybase IQ 15.4

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.