2511818 - DELETE hit non-fatal stack trace on hs_subohc::SmallDelete then abort with memory corruption - SAP IQ

• DELETE cause a non-fatal crash on hs_subohc::SmallDelete followed by an abort on memory corruption.
• This could result in FP indexes corruption
• The stack traces look similar to the ones referenced by CR 776295 in KBA 2116058, but have different cause.

Excerpt of IQMSG

********************************************************
**
** Non-Fatal IQ Internal Error Detected
** at slib/s_ohcidx.cxx:3213 on thread 684 (TID 675)
**
** Please report this to SAP IQ support
** with the following diagnostic information,
** and, if possible, with the user's command.
**
** Error from IQ connection: SA connHandle: 1558 SA connID: 6 IQ connID: 0000002055 User: user
** Time of error: 2017-07-07 02:44:21
** IQ Version: SAP IQ/16.0.110/10448/P/sp11.07
** OS info: IQ built on: Sun_x64/OS 5.10, Executed on: SunOS/ar3ens1/5.10/Generic_150401-38/i86pc
** Command status when error occured: CURSOR ACTIVE
** Command text:
delete from tableName where columnName = 'CELL_CP1';
delete from tableName where columnName = 'CELL_CP3';
delete from tableName where columnName = 'CELL_PP0';
delete from tableName where columnName = 'CELL_PP2';
delete from tableName where columnName = 'CELL_PP4';
delete from tableName where columnName = 'CELL_CP0';
delete from tableName where columnName = 'CELL_CP2';
delete from tableName where columnName = 'CELL_CP4';
delete from tableName where columnName = 'CELL_PP1';
delete from tableName where columnName = 'CELL_PP3';

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

hs_subohc::SmallDelete
hs_subohc::Delete
hs_ohc::Delete
hs_ohc::Delete
hdb_delete_indices::Unit_of_Work
hdb_delete_indices::hdb_delete_index_iter::ExecWork
workAllocator::DoWork
hos_thread::Main
hos_lwtask::Start
IQWorkerStarter
UnixTask::pre_body

******************* End of STACKTRACE ******************
**
** End of stack trace from Non-Fatal IQ Internal Error slib/s_ohcidx.cxx:3213
**
********************************************************

Exception Thrown from slib/s_ohcidx.cxx:3213, Err# 16, tid 675 origtid 675
O/S Err#: 0, ErrID: 2068 (hs_idxexception); SQLCode: -1006003, SQLState: 'QBA03', Severity: 23
IQ Internal error. Please report this to SAP IQ support. user.tableName.columnName_HG 15 ???
-- (slib/s_ohcidx.cxx 3213)

IQ Internal Error Detected: Memory Corruption
Idx: 0 Addr: 19a33ea340 Size: 80 File: slib/s_ohcidx.cxx Line: 2991 Thread: 675 IsArray: 0
Usage: hs_subohc::_conditionBuf

Next Element In List:
Idx: 0 Addr: 19a33f1ea0 Size: 512 File: slib/s_bmCur.cxx Line: 73 Thread: 675 IsArray: 0
Usage: hos_recid[] s_bmRWCursorBase::_cache

Previous Element In List:
Idx: 0 Addr: 19a20380c0 Size: 32 File: GLOBAL NEW Line: 0 Thread: 13 IsArray: 0
Usage: Global Mem?

Failure(s): _end bad data: 0x2

**************************************************
*** SAP IQ Abort:
*** From: oslib/hos_mem.cxx:270
*** Rethrown from: oslib/hos_throw.cxx:313
*** PID: 10602
*** Exception Location: 0xfffffd7ff2eb8cd0
*** Error ID: 517, Exception Type: hos_memexception
*** Thread: 104 (TID: 13, Original TID: 13)
*** Error #: 0, O/S Error #: 0
*** Argument:
-- (oslib/hos_mem.cxx 270)
**************************************************

** Error from IQ connection: SA connHandle: 1558 SA connID: 6 IQ connID: 0000002055 User: dc
** Time of error: 2017-07-07 02:44:21
** IQ Version: SAP IQ/16.0.110/10448/P/sp11.07
** OS info: IQ built on: Sun_x64/OS 5.10, Executed on: SunOS/ar3ens1/5.10/Generic_150401-38/i86pc
** Command status when error occured: CURSOR ACTIVE
** Command text:
delete from tableName where columnName = 'CELL_CP1';
delete from tableName where columnName = 'CELL_CP3';
delete from tableName where columnName = 'CELL_PP0';
delete from tableName where columnName = 'CELL_PP2';
delete from tableName where columnName = 'CELL_PP4';
delete from tableName where columnName = 'CELL_CP0';
delete from tableName where columnName = 'CELL_CP2';
delete from tableName where columnName = 'CELL_CP4';
delete from tableName where columnName = 'CELL_PP1';
delete from tableName where columnName = 'CELL_PP3';

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

hos_memmgr::FreeHosMem
hs_subohc::~hs_subohc()
__SLIP.DELETER__NB
hs_ohc::~hs_ohc
__SLIP.DELETER__PC
db_IndexDef::CloseSIndex
hdb_delete_indices::hdb_delete_indicesTerminator
hos_ObjectStack::Throw
Throw(const hos_exception&)
hos_team::StartWork
hos_team::Exec
hdb_hdelete::Delete
dfo_DeleteRoot::Complete
st_cursorIQtoSA::Complete
df_Delete::Complete
st_command::DoCmdThroughResourceGate

....

SAP IQ 16

CR# 809818 ; 809818  , KBA , BC-SYB-IQ , Sybase IQ , Bug Filed