Symptom
- An insert job was rolled back with "Informational stack trace from Duplicate buffer insertion detected" but the job ran fine at the 2nd execution.
--Informational stack trace during the issue
********************************************************
**
** Informational stack trace from Duplicate buffer insertion detected, exiting buf: 1b834d9d0
** at slib/s_bufhash.cxx:421 on thread 264201 (TID 1027)
**
** Error from IQ connection: SA connHandle: 3628 SA connID: 43 IQ connID: 0000205638 User: user001
** Time of error: 2022-12-27 21:22:36
** IQ Version: SAP IQ/16.1.050/12231/P/SP05.06
** OS info: IQ built on: RS6000MP/AIX 7.1, Executed on: AIX/host001/2/7/00xxxxxxxx00
pcstkwalk
ucstkgentrace
StackTraceForThisThread
s_bufhash::RemoveEntryInsertHelper
s_bufhash::Insert
s_bufpartition::InsertInHT
s_bufpartition::GetCleanPage
s_bufpartition::Find
s_blockmap::Find
s_ROBlockmapCursor::Find
s_ROBlockmapCursor::Find
s_bArrayCursor::Find
s_bArrayLocater::LoadBlock
s_bArrayLocater::LoadPage
s_bArrayLocater::LocateTokenRecord
hs_dpfetch::FetchNoCopyContiguous
s_fetchRow::FetchContiguous
vp_Cursor::Fetch
...
**
** End of informational stack trace from Duplicate buffer insertion detected, exiting buf: 1b834d9d0
**
********************************************************
- No error was reported from DBCC with tables referenced by the problematic job.
Read more...
Environment
- SAP IQ 16.1 SP05.06/AIX 64bit
Product
Keywords
s_bufhash.cxx, RemoveEntryInsertHelper, InsertInHT, GetCleanPage, , KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , 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.