2017553 - SAP IQ will crash by the insert of duplicate data | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2017553 - SAP IQ will crash by the insert of duplicate data

Symptom

  • When you insert a duplicate data in a table with an B-tree based index(HG,WD,TEXT), SAP IQ server crashes rarely.
  • [demo]$ dbisql -c 'uid=dba;pwd=sql' -host hostname -port 2638 -nogui repro.sql
    Error! The connection to the database was closed by the server.
      Connection was terminated
      SQLCODE=-308, ODBC 3 State="HY000"
      File: "repro.sql" on line 1, column 1
      INSERT REPRO_TABLE (col1, col2) VALUES (99, 'tantai,kakunin,1')
      You can continue executing or stop.
    1. Stop
    2. Continue
    Select an option:
  • The stack trace logged in IQ log contains the following functions:   

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
run_task_body


Read more...

Environment

SAP IQ 15.4 ESD 2 and earlier

Product

SAP IQ 16.0 ; SAP Sybase IQ 15.4

Keywords

CR726924, -308, SIGSEGV, 726924 , 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.