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: ***, 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.