Symptom
Internal state violation when querying and changing data on a HASH + SUBRANGE partitioned table on a SAP IQ SP11 PL13 database, on a multiplex environment.
In the iqmsgs there is a stack trace with following functions:
======
********************************************************
**
** Non-Fatal IQ Internal Error Detected
** at slib/s_blockmap.cxx:14066 on thread XXX (TID YYY)
** Unknown buffer manager internal error
**
....
....
O/S Err#: 0, ErrID: 2091 (s_internalexception); SQLCode: -1001012, SQLState: 'QFA12', Severity: 18
20521]: Internal state violation, please contact SAP IQ support -- (slib/s_blockmap.cxx 14066)
Exception Thrown from slib/s_blockmap.cxx:14066, Err# 0, tid XXX origtid VVV
_Z23StackTraceForThisThreadPKciS0_S0_S0_
_ZN10s_blockmap10ThrowErrorE18s_bufman_errorInfoPKci
_ZN18s_ROBlockmapCursor4FindEysiP19s_bufmanCallerStats
_ZN14s_bArrayCursor4FindEyjj
_ZN15s_bArrayLocater9LoadBlockERy
_ZN15s_bArrayLocater8LoadPageEy
_ZN15s_bArrayLocater17LocateTokenRecordEy
_ZN10hs_dpfetch21FetchNoCopyContiguousEyP9hos_datum
_ZN10s_fetchRow15FetchContiguousEv
_ZN10s_fetchRow5FetchEv
_ZN9vp_Cursor5FetchEv
_ZN22dfo_VerticalLeafCursor
_ZN3dfo5FetchEv
_ZN15dfjo_HashParaT19FetchOpusEv
_ZN8dfo_Join9FetchOpusEv
_ZN10dfo_Filter9FetchOpusEv
_Z21CombinerFetchCallbackPv
_ZN8hc_dfrun7FillRunERjii
_ZN9hc_dmfrun16InitNextWorkUnitEjij
_ZN9hc_dmfrun8ExecWorkERij
_ZN13workAllocator6DoWorkEj
_ZN13workAllocator7sDoWorkEPS_j
_ZN10hos_thread4MainEv
_ZN10hos_lwtask5StartEPS_
_Z15IQWorkerStarterPv
=======
The stack trace has function names beginning with "_ZN". This occurs on HPIA only. The translation of the functions (valid for all platforms):
======
StackTraceForThisThread
s_blockmap::ThrowError
s_ROBlockmapCursor::Find
s_bArrayCursor::Find
s_bArrayLocater::LoadBlock
s_bArrayLocater::LoadPage
s_bArrayLocater::LocateTokenRecord
hs_dpfetch::FetchNoCopyContiguous
s_fetchRow::FetchContiguous
s_fetchRow::Fetch
vp_Cursor::Fetch
dfo_VerticalLeafCursor::FetchOpus
dfo::Fetch
dfjo_HashParaT1::FetchOpus
dfo_Join::FetchOpus
dfo_Filter::FetchOpus
CombinerFetchCallback
hc_dfrun::FillRun
hc_dmfrun::InitNextWorkUnit
hc_dmfrun::ExecWork
workAllocator::DoWork
workAllocator::sDoWork
hos_thread::Main
hos_lwtask::Start
IQWorkerStarter
=======
Read more...
Environment
- SAP IQ 16.0 SP11 PL13
Product
Keywords
Internal state violation HASH SUBRANGE partitioned table s_ROBlockmapCursor::Find s_bArrayCursor::Find s_bArrayLocater::LoadBlock s_bArrayLocater::LoadPage s_bArrayLocater::LocateTokenRecord hs_dpfetch::FetchNoCopyContiguous s_fetchRow::FetchContiguous SQLCode -1001012 QFA12 819477 , KBA , BC-SYB-IQ , Sybase IQ , Problem
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.