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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.