SAP Knowledge Base Article - Preview

1950608 - IQ 15.4 - Abort from st_server.cxx:1430 , when trying to insert a duplicate value into a unique HG index.

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.