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