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.
SAP Knowledge Base Article - Preview