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.