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.
SAP Knowledge Base Article - Preview