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

SAP Knowledge Base Article - Preview

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

Symptom

  • 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

....


Read more...

Environment

SAP IQ 16

Product

SAP IQ 16.0

Keywords

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

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.