2518024 - Out of temporary space caused server abort - SAP IQ | SAP Knowledge Base Article

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

Search for additional results

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