Symptom
IQ server got crashed with "slib/s_bufpool.cxx:717" when inserting data after delete statement. It seemed the crash happened while rolling back inserting DML due to duplication error on a unique HG index.
* Error & Stack =>
.. Exception Thrown from slib/s_ohcins.cxx:964, Err# 0, tid 15 origtid 1006
.. O/S Err#: 0, ErrID: 6145 (hgex_dataexception); SQLCode: -1002003, SQLState: 'QGA03', Severity: 14
.. [20505]: Tried to insert a duplicate value into a unique index xxx.XXXXX.IX_SL0061M_PK on row 1766713.
.. Rbck
.. s_bufpool::Release(this=0x7f88ec003eb8,Slot=0x7f88ec189de8,isInHashTable=1,isForShutdown=0): main Bufman
.....................................
..
.. **************************************************
.. *** SAP IQ Abort:
.. *** From: slib/s_bufpool.cxx:717
.. *** Rethrown from: oslib/hos_throw.cxx:313
..................
===== Thread Number 140218686404352 (IQ connID: 0001144694) =====
.. pcstkwalk(............
.. ucstkgentrace(............
.. DumpAllThreads(............
.. hos_ABORT(............
.. Throw(............
.. hos_assertexception::ThrowException(............
.. s_bufpool::Release(............
.. s_bufpool::Rollback(............
.. s_bufman::Rollback(............
.. st_txncb::Rollback(............
.. st_txnMgr::Rollback(............
.. st_command::DoCmdThroughResourceGate(............
.. st_iqtxn::RollbackTxn(............
.. UIQTxn_RollbackTxn+............
Read more...
Environment
SAP IQ 16.0 SP11.x
Product
Keywords
"s_bufpool.cxx" ; "st_iqtxn::RollbackTxn" ; "RollbackTxn" ; "hos_assertexception::ThrowException" ; "CR 812543" ; , 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.
SAP Knowledge Base Article - Preview