Symptom
- IQ 15.4 Crash - Abort from st_server.cxx:1430 , when trying to insert a duplicate value into a unique HG index.
- Relevant messages in .iqmsg log:
Exception Thrown from s_ohcins.cxx:722, Err# 0, tid 300 origtid 300
O/S Err#: 0, ErrID: 6145 (hgex_dataexception); SQLCode: -1002003, SQLState: 'QGA03', Severity: 14
[20505]: Tried to insert a duplicate value into a unique index <Owner>.<Table_Name>.ASIQ_IDX_T9174_I38_HG on row 1187.
-- (s_ohcins.cxx 722)
Exception Thrown from s_wordIdx.cxx:4096, Err# 0, tid 326 origtid 326
O/S Err#: 0, ErrID: 519 (hos_attnexception); SQLCode: -299, SQLState: '57014', Severity: 16
...
O/S Err#: 0, ErrID: 6145 (hgex_dataexception); SQLCode: -1002003, SQLState: 'QGA03', Severity: 14
[20505]: Tried to insert a duplicate value into a unique index <Owner>.<Table_Name>.ASIQ_IDX_T9174_I38_HG on row 1187.
-- (s_ohcins.cxx 722)
[20917]: Delete of 1 rows started for table:
**************************************************
*** Sybase IQ Abort:
*** From: st_server.cxx:1430
*** PID: 25606
*** Message: caught signal 11, program abort
*** Thread: 1369237824 (TID: 288)
**************************************************
...
** Command text:
insert into ....
- Stacktrace elements:
DumpAllThreads
hos_ABORT
SigHndlr
s_btParallelCursor::SetDeleteNotifier
s_ohcDeleteIter::s_ohcDeleteIter
hs_word::LargeDelete
hs_word::Delete
hdb_delete_indices::Unit_of_Work
hdb_delete_indices::hdb_delete_index_iter::ExecWork
workAllocator::DoWork
hos_thread::Main
hos_lwtask::Start
IQWorkerStarter
Read more...
Environment
SAP Sybase IQ 15.4
Product
SAP Sybase IQ 15.4
Keywords
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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.