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
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.