SAP Knowledge Base Article - Preview

3378760 - Source IQ/AIX server crashes during BLOB insert into location to target IQ/linux -SAP IQ

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: 264, Original TID: 264)
 ***      Error #: 0,  O/S Error #: 45
 ***      Argument: 
-- (/home/iqabuild/views/links/r16.1.0_sp05_nbld_aix_64/gitsrc/cm/iqa/include/hos_RecursRwLock_inline.h 76)

 ***      Argument:  45

 **************************************************
 Stacktrace requested from /home/iqabuild/views/links/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: 33  SA connID: 28  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 /home/iqabuild/views/links/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.