SAP Knowledge Base Article - Preview

2661398 - SAP IQ server crashed due memory corruption with conversion error - SAP IQ 

Symptom


SAP IQ server crashed due memory corruption with conversion error.

.iqmsg
-------
Exception Thrown from dflib/dfe_Cast.cxx:955, Err# 1047, tid 73 origtid 73
    O/S Err#: 0, ErrID: 9216 (df_Exception); SQLCode: -1009145, SQLState: 'QFA2E', Severity: 14
 [21070]: Data type conversion is not possible. Failure converting from VARCHAR(2) for expression CAST(tableA.col1 AS VARCHAR(2)).
-- (dflib/dfe_Cast.cxx 955)

 IQ Internal Error Detected:  Memory Corruption
     Idx: 0  Addr: 0x7f2ca206e470  Size: 8  File: dflib/dfe_Cast.cxx  Line: 567  Thread: 73  IsArray: 0
     Usage: dfe_Cast::_DataBuffer

 Next Element In List:
     Idx: 0  Addr: 0x7f2ca206e400  Size: 8  File: dflib/dfo.cxx  Line: 1339  Thread: 73  IsArray: 0
     Usage: dfo::_ProductionArray

 Previous Element In List:
     Idx: 0  Addr: 0x7f2ca206e4e0  Size: 112  File: dflib/df_MapRecordToDFEs.cxx  Line: 178  Thread: 73  IsArray: 0
     Usage: df_MapRecordToDFEs::_SRecInputDesc

     Failure(s):   _end bad data: 0x0x3030303030303030


 **************************************************
 ***   SAP IQ Abort:
 ***      From:  oslib/hos_mem.cxx:273
 ***      Rethrown from:  oslib/hos_throw.cxx:313
 ***      PID: 19164
 ***      Exception Location: 0x0x7f2c5786e540
 ***      Error ID: 517,  Exception Type: hos_memexception
 ***      Thread: 139828423796480  (TID: 73, Original TID: 73)
 ***      Error #: 0,  O/S Error #: 0
 ***      Argument:
-- (oslib/hos_mem.cxx 273)
 **************************************************

     **  Error from IQ connection:  SA connHandle: 1  SA connID: 6  IQ connID: 0000000070  User: dba
     **  Time of error:  2018-06-26 08:16:33
     **  IQ Version:  SAP IQ/16.1.020/10528/P/sp02
     **  OS info:  IQ built on: Linux/Linux64 - x86_64 - 2.6.18-194,  Executed on: Linux/server01/3.10.0-514.16.1.el7.x86_64/#1 SMP Fri Mar 10 13:12:32 EST 2017/x86_64
     **  Command status when error occured:  CURSOR ACTIVE
     **  Command text:
select cast("col1" as varchar(2)) from "tableA"
 Dump all thread stacks at oslib/hos_mem.cxx:273 for PID: 19164

    ***************** This is the STACKTRACE ***************

 pcstkwalk
 ucstkgentrace
 DumpAllThreads
 hos_ABORT
 Throw(hos_exception const&)
 hos_memmgr::FreeHosMem(void*)
 dfe_Cast::~dfe_Cast
 hos_vector_noerror::ClearAndDestroy
 df_Heap::ClearAndDestroyAllDFEvals
 df_Heap::~df_Heap
 dfo_Root::Complete
 st_cursorIQtoSA::Complete
 df_dmlcommand::~df_dmlcommand
 hos_ObjectStack::Throw
 Throw(hos_exception const&)
 df_Exception::ThrowException
 dfe_Cast::Evaluate
 dfo_Cursor::FetchOpus
 dfo_Root::FetchOpus
 st_cursorIQtoSA::FetchRows
 st_cursorIQtoSA::Execute
 df_OpenCursor::Execute
 st_command::DoCmdThroughResourceGate
 st_iqdml::OpenCursor
 UIQDML_OpenCursor
 ........
 ........
 RequestQueue::worker_body()


Read more...

Environment

SAP IQ 16.1 SP02

Product

SAP IQ 16.1

Keywords

 CR810941, CR#810941, 810941, convert, cast , stacktrace, stktrc, stack trace, abort, down , KBA , BC-SYB-IQ , Sybase IQ , 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.