SAP Knowledge Base Article - Preview

2518024 - Out of temporary space caused server abort - SAP IQ

Symptom

IQ Server aborted with errors below

Exception Thrown from slib/s_blockmap.cxx:6523, Err# 0, tid 57 origtid 1495
O/S Err#: 0, ErrID: 2096 (s_nodbspaceexception); SQLCode: -1009170, SQLState: 'QSB66', Severity: 14
[20223]: You have run out of space in IQ_SYSTEM_TEMP DBSpace. Current DBSpace size is ****MB.
**************************************************
***   SAP IQ Abort:
***      From:  slib/s_blockmap.cxx:6523
***      Rethrown from:  oslib/hos_throw.cxx:278
***      PID: 51966
***      Exception Location: 0x0xc2ef28
***      Error ID: 2096,  Exception Type: s_nodbspaceexception
***      Thread: 139871473346304  (TID: 57, Original TID: 1495)
***      Error #: 0,  O/S Error #: 0
***      Argument: 
***      Argument:  IQ_SYSTEM_TEMP
***      Argument:  1351680
     **  Error from IQ connection:  SA connHandle: 7507  SA connID: 118  IQ connID ***:   User: ***
     **  Time of error:  2017-08-10 18:01:27
     **  IQ Version:  SAP IQ/16.0.110/10487/P/sp11.09
     **  OS info:  IQ built on: Enterprise Linux64 - x86_64 - 2.6.18-194.el5,  Executed on: Linux/***/2.6.32-504.30.3.el6.x86_64/#1 SMP Thu Jul 9 15:20:47 EDT 2015/x86_64
Dump all thread stacks at slib/s_blockmap.cxx:6523 for PID: 51966
Allocation successful. Dbspace IQ_SYSTEM_TEMP
hos_ABORT
Allocation failed. Dbspace IQ_SYSTEM_TEMP is  OUT OF SPACE
Throw
s_blockmap::ThrowError
s_blockmap::ThrowIfOutOfSpace
s_blockmap::FindAndMakeDirtiable
s_pageListCursor::PositionPage
Allocation successful. Dbspace IQ_SYSTEM_TEMP
v2s_bmcontext::LoadPage
v2s_bmcontext::bmlev1sgblkselfget
v2s_bmcontext::bmselfunion(s_bm*, unsigned long long const*, int, int)+0x177a
s_bm::SetBits(unsigned long long const*, unsigned int, unsigned int, int)+0xb1
hs_ohcUpdate::~hs_ohcUpdate()+0x2a
db_IndexDef::CloseSIdxUpdate(s_indexUpdate*, int)+0xa7
db_sqlinsert::UpdateCleanUp(int, int)+0xad
db_sqlinsert::Shutdown(int)+0x1f
db_sqlinsert::~db_sqlinsert()+0x85
hos_ObjectStack::Throw()+0x79


Read more...

Environment

SAP IQ 16.0 SP11.x

Product

SAP IQ 16.0

Keywords

812481, CR812481, CR#812481, ThrowIfOutOfSpace, IQ_SYSTEM_TEMP, FindAndMakeDirtiable, s_blockmap.cxx , 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.