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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.