SAP Knowledge Base Article - Preview

2778654 - Delete crash on s_llhtable::hti_lookup_delete on NBit column with memory corruption - SAP IQ

Symptom

Delete statement constantly crash on s_llhtable::hti_lookup_delete on NBit column with memory corruption.

Excerpt from IQMSG

[20917]: Delete of 852507 rows started for table:
slib/s_llhtable.cxx:1978 deleting non-existing key [ O,23214]

********************************************************
**
** Non-Fatal IQ Internal Error Detected
** at slib/s_llhtable.cxx:1411 on thread 139789868160768 (TID 1177)
**

** Command text:

delete from "owner"."table" where "PERIOD" = 201903


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

hos_memexception::hos_memexception
s_llhtable::hti_lookup_delete
s_llhtable::hti_cas_delete
s_llhtable::ht_cas_delete
s_llhtable::deleteToken
s_dictionary::DeleteKeyFromHash
s_dpNBit::SqueezeFixedKeyArray
s_dpNBit::Delete
hs_dp::DeleteNBit
hs_dp::DeleteInternal
hs_dp::Delete
hdb_delete_indices::Unit_of_Work
hdb_delete_indices::hdb_delete_index_iter::ExecWork
workAllocator::DoWork

Exception Thrown from slib/s_llhtable.cxx:1411, Err# 12, tid 221 origtid 1177
O/S Err#: 0, ErrID: 517 (hos_memexception); SQLCode: -1006000, SQLState: 'QBA00', Severity: 23
[20238]: IQ Internal error. Please report this to SAP IQ support.
-- (slib/s_llhtable.cxx 1411)
Rbck
PostRbck


Read more...

Environment

  • SAP IQ 16.0
  • SAP IQ 16.1 SP02 PL16
  • SAP IQ 16.1 SP03 PL04

Product

SAP IQ 16.0 ; SAP IQ 16.1

Keywords

hos_memexception::hos_memexception ; s_llhtable::hti_cas_delete ; s_llhtable::deleteToken ; s_dictionary::DeleteKeyFromHash ;
s_dpNBit::SqueezeFixedKeyArray; s_dpNBit::Delete ; hs_dp::DeleteNBit ; , 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.