SAP Knowledge Base Article - Preview

3292254 - An insert job was rolled back with "Informational stack trace from Duplicate buffer insertion detected" but the job ran fine at the 2nd execution -- SAP IQ

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

SAP IQ 16.1

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.