Symptom
- stack traces in the iqmsg file and requested an investigation to ensure there is no table corruption in their production system.
- sp_iqcheckdb does not report errors
- The error messages indicate a page header mismatch and internal inconsistency in SAP IQ.
Messages and Stacktrace:
BARRAY: save partition *** slib/s_barray.cxx:13891
BARRAY: save partition *** slib/s_barray.cxx:13891
...
BARRAY: save partition *** slib/s_barray.cxx:13891
..
t*** slib/s_barray.cxx:11889 - (***) != (***)
** Non-Fatal IQ Internal Error Detected
** at slib/s_barray.cxx:11898
**
** Please report this to SAP IQ support
** Error from IQ connection:
** Time of error: xxxx
** Command text:
Statement text unavailable
***************** This is the STACKTRACE ***************
===== Thread Number xxx (IQ connID: xxx) =====
StackTraceForThisThread
s_mergeFINALWriter::LoadPageForMerge
s_mergeFINALWriter::DoInsert
hs_dpInsert::Insert
dfiio_FP::FinalFetchOpus
dfo_IndexInsert::FinalFetchOpus
df_CombinerFinalFetchHelper::DoFinalFetch
df_CombinerFinalFetchHelper::ExecWork
workAllocator::DoWork
hos_team::StartWork
hos_team::Exec
df_CombinerFinalFetchHelper::Run
dfo_Combiner::FetchOpus
dfo_Sequencer::FetchOpus
dfo_Root::FetchOpus
db_dmlcommand::ExecuteDFOTree
db_LoadTable::Execute
st_command::DoCmdThroughResourceGate
st_iqdml::Load
UIQDML_Load
st_SAIQInterfaceInfo::callFunction
st_SAIQInterface::RunIQFunc
st_SAIQInterface::Execute
saint_iqthresholddml::Load
dbi_load_table
DoExecuteBodyLocal
DoExecuteStmt
exec_procedure_stmt
run_procedure
call_procedure
DB_Exec_event_handler
EventHandler::do_request
Worker::spawn
RQInternalBaseItem::do_work
RequestQueue::worker_body
request_task(void*)+89
run_task_body+1e
UnixTask::pre_body
INFO [hos_InMemMsgLog::BroadcastDumpInMemMsgLog] from slib/s_barray.cxx:11913 local/remote server ids:1/2
Exception Thrown from slib/s_barray.cxx:11918, Err# 7
O/S Err#: 0, ErrID: 2065 (hs_BArrayexception); SQLCode: -1009149, SQLState: 'QSB45', Severity: 14
BArray page header mismatch Internal Inconsistency:
-- (slib/s_barray.cxx 11918) (7,N/A,N/A)
Exception Thrown from slib/s_barray.cxx:11918, Err# 7
O/S Err#: 0, ErrID: 2065 (hs_BArrayexception); SQLCode: -1009149, SQLState: 'QSB45', Severity: 14
[xxx]: BArray page header mismatch Internal Inconsistency:
Exception Thrown from slib/s_barray.cxx:11918,
O/S Err#: 0, ErrID: 2065 (hs_BArrayexception); SQLCode: -1009149, SQLState: 'QSB45', Severity: 14
BArray page header mismatch Internal Inconsistency:
-- (slib/s_barray.cxx 11918)
Cleaning pending errors from slib/s_bmCur.cxx:948
Read more...
Environment
SAP IQ 16.1 SP05 PL12
Product
Keywords
830864, CR830864, CR#830864, "s_mergeFINALWriter::LoadPageForMerge", "s_mergeFINALWriter::DoInsert", "hs_dpInsert::Insert " , 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.
SAP Knowledge Base Article - Preview