Symptom
- On Target IQ/Linux database, executed insert location to copy BLOB data from IQ on AIX.
- Running "select * from "owner"."table_name" directly on source IQ database, works normally
- In the middle of the data copy via insert/location using same select statement, the source IQ server crashes with error and stacktrace:
*** SAP IQ Abort:
*** From: /home/iqabuild/views/links/r16.1.0_sp05_nbld_aix_64/gitsrc/cm/iqa/include/hos_RecursRwLock_inline.h:76
*** Rethrown from: oslib/hos_throw.cxx:316
*** PID: ****
*** Exception Location: ***
*** Error ID: 529, Exception Type: hos_lockexception
*** Thread: *** (TID: ***, Original TID: **)
*** Error #: 0, O/S Error #: 45
*** Argument:
-- (/IQhome/r16.1.0_sp05_nbld_aix_64/gitsrc/cm/iqa/include/hos_RecursRwLock_inline.h 76)
*** Argument: 45
**************************************************
Stacktrace requested from /IQhome/r16.1.0_sp05_nbld_aix_64/gitsrc/cm/iqa/include/hos_RecursRwLock_inline.h:76 on thread *** (TID 264) start stacktrace
** Error from IQ connection: SA connHandle: ** SA connID: ** IQ connID: *** User:***
** IQ Version: SAP IQ/16.1.050/12790/P/SP05.08
** OS info: IQ built on: RS6000MP/AIX 7.1, Executed on: AIX/dssapsrvu027/2/7/00C2C62E4C00
** Command status when error occurred: NO COMMAND OR CURSOR ACTIVE
I. 09/12 16:57:59. 0000005756 ** Parser command text:
select * from "owner"."table_name"
** Dump all thread stacks at /IQhome/r16.1.0_sp05_nbld_aix_64/gitsrc/cm/iqa/include/hos_RecursRwLock_inline.h:76 for PID: *****
***************** This is the STACKTRACE ***************
.pcstkwalk
.ucstkgentrace
.DumpAllThreads
.hos_ABORT
.ThrowAbort
.Throw
.s_blockmap::GetBlockmapEntryInfo
.s_blockmap::Find
.s_LOBCursor::AssignBlocktoPBuf
.s_LOBCursor::Next
.s_LOBCursor::GetData
.st_cursorIQtoSA::RetrieveLOBBuffer
.st_iqdml::RetrieveLOBBuffer
.UIQDML_RetrieveLOBBuffer
.st_SAIQInterfaceInfo::callFunction
.st_SAIQInterface::RunIQFunc
.st_SAIQInterface::Execute
.st_cursorIQtoSA::getColumn
.saint_iqthresholddml::FetchPiece
.FetchValueInCursor .df_OmniRowScan::FillRowBuffer
.df_OmniRowScan::Fetch
.dfo_Scan::fetchOne
.dfo_Scan::DoFetch
.dfo_Base::Fetch
Read more...
Environment
SAP IQ 16.1
- Source Platform/OS: AIX
- Target Platform/OS: Linux
Product
SAP IQ 16.1
Keywords
CR828426, CR#828426, 828426, sybase , KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , Product Enhancement
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