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