SAP Knowledge Base Article - Preview

2583153 - Server Crash with "s_bufpool.cxx:717" error , while a DML is rolling back due to an error -- SAP IQ16.0

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

SAP IQ 16.0

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

Search for additional results

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