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.
SAP Knowledge Base Article - Preview