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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview