Symptom
IQ multiplex servers got aborted at st_server.cxx:1709 whenever executing a simple query against a specific table.
Multiple crashes, stacktraces are shown as below.
I. 01/30 13:45:53. 0000019020 ********************************************************
I. 01/30 13:45:53. 0000019020 **
I. 01/30 13:45:53. 0000019020 ** Non-Fatal IQ Internal Error Detected
I. 01/30 13:45:53. 0000019020 ** at slib/s_packedRec.cxx:1313 on thread 1920 (TID 1911)
.....
.....
I. 01/30 13:45:53. 0000019020 **************************************************
I. 01/30 13:45:53. 0000019020 *** SAP IQ Abort:
I. 01/30 13:45:53. 0000019020 *** From: stcxtlib/st_server.cxx:1709
I. 01/30 13:45:53. 0000019020 *** PID: 18805
I. 01/30 13:45:53. 0000019020 *** Message: caught signal 11, program abort
I. 01/30 13:45:53. 0000019020 *** Thread: 1855 (TID: 1846)
I. 01/30 13:45:53. 0000019020 **************************************************
I. 01/30 13:37:02. <,3365,PREPARE,select * from "OWNER001"."TAB001" where "COL001" = 11111111 order by 1 asc
I. 01/30 13:37:02. >,3365,PREPARE,65575
I. 01/30 13:37:02. <,3365,EXEC,65575
I. 01/30 13:37:02. W,3365,111,Statement cannot be executed
I. 01/30 13:37:02. >,3365,EXEC
I. 01/30 13:37:02. <,3365,OPEN,65575
I. 01/30 13:37:02. >,3365,OPEN,65576
I. 01/30 13:38:42. ** DisConnection 3365
I. 01/30 13:56:29. 0000027169 Dump all thread stacks at stcxtlib/st_server.cxx:1709 for PID: 17220
I. 01/30 13:56:29. 0000027169 ** While handling one abort, caught signal 11, program abort on thread 2198 (TID 2189)
I. 01/30 13:56:29. 0000027169
I. 01/30 13:56:29. 0000027169 ********************************************************
I. 01/30 13:56:29. 0000027169 **
I. 01/30 13:56:29. 0000027169 ** Non-Fatal IQ Internal Error Detected
I. 01/30 13:56:29. 0000027169 ** at /cm/iqa/include/s_bm.h:336 on thread 1638 (TID 1629)
I. 01/30 13:56:29. 0000027169 ** Bitmap identity damaged or version out-of-range.
I. 01/30 13:56:29. 0000027169 ** this=9ffffffe1d64e7d0,error={num=2,os=0,id=2049,msg=-1009045},bmec=2
// Crashed due to a problematic query.
I. 01/30 14:39:45. 0000000170 **************************************************
I. 01/30 14:39:45. 0000000170 *** SAP IQ Abort:
I. 01/30 14:39:45. 0000000170 *** From: stcxtlib/st_server.cxx:1709
I. 01/30 14:39:45. 0000000170 *** PID: 11311
I. 01/30 14:39:45. 0000000170 *** Message: caught signal 8, program abort
I. 01/30 14:39:45. 0000000170 *** Thread: 2357 (TID: 2348)
I. 01/30 14:39:45. 0000000170 **************************************************
I. 01/30 14:39:45. 0000000170
I. 01/30 14:39:45. 0000000170 Already printing a stacktrace
I. 01/30 14:39:45. 0000000170 ** While handling one abort, caught signal 11, program abort on thread 2313 (TID 2304)
I. 01/30 14:39:45. 0000000170 Destroying Locked Logical Buffer
// Got crashed again.
I. 01/30 15:38:24. 0000000092 **************************************************
I. 01/30 15:38:24. 0000000092 *** SAP IQ Abort:
I. 01/30 15:38:24. 0000000092 *** From: stcxtlib/st_server.cxx:1709
I. 01/30 15:38:24. 0000000092 *** PID: 21112
I. 01/30 15:38:24. 0000000092 *** Message: caught signal 11, program abort
I. 01/30 15:38:24. 0000000092 *** Thread: 2269 (TID: 2260)
I. 01/30 15:38:24. 0000000092 **************************************************
......
I. 01/30 15:38:24. 0000000092 ** While handling one abort, SAP IQ Abort Thrown from /cm/iqa/include/hos_mutex_inline.h:316 on thread 2155 (TID 2146)
......
I. 01/30 15:38:24. 0000000092 IQ Internal Error Detected: Memory Corruption
......
I. 01/30 15:38:24. 0000000092 ** Informational stack trace from out of virtual memory condition
I. 01/30 15:38:24. 0000000092 ** at /cm/iqa/include/s_bm_priv.h:310 on thread 2291 (TID 2282)
I. 01/30 15:38:24. 0000000092 ** Failed allocation request (bytes): 8315056692464
I. 01/30 15:38:24. 0000000092 ** Failed allocation request type: sbm_pageArray::_vector
(2) 0xc00000001a735370 _Z9hos_ABORTPKcjS0_PcS1_ + ..........
(3) 0xc00000001dbee1d0 SigHndlr + 0x90 at stcxtlib/st_server.cxx:1709 ..........
(4) 0xe0000001301cb440 ---- Signal 11 (SIGSEGV) delivered ----
(5) 0xc00000001cf16f40 _ZN17s_dictionaryFetch11FetchNoCopyEPKvRi + ..........
(6) 0xc00000001b8b70a0 _ZN10hs_dpfetch19FetchNoCopyONBitValEPvP9hos_datum + ..........
(7) 0xc00000001b8bab60 _ZN10hs_dpfetch21FetchNoCopyContiguousEyP9hos_datum + ..........
(8) 0xc00000001e175c60 _ZN10s_fetchRow15FetchContiguousEv + 0x1b0 at vplib/vp_FetchRow.cxx:856 ..........
(9) 0xc00000001e16ecf0 _ZN10s_fetchRow5FetchEv + 0x440 at vplib/vp_FetchRow.cxx:774 ..........
(10) 0xc00000001e150520 _ZN9vp_Cursor5FetchEv + ..........
(11) 0xc00000001a0d0090 _ZN22dfo_VerticalLeafCursor9FetchOpusEv + ..........
(12) 0xc00000001a37da70 _ZN17dfo_InsertPrepare9FetchOpusEv + ..........
(13) 0xc000000019fc9830 _ZN25dfo_CheckConstraintFilter9FetchOpusEv + ..........
(14) 0xc00000001a29b8c0 _ZN20dfo_ColumnVectorBase9FetchOpusEv + ..........
(15) 0xc00000001a2a0900 _ZN20dfo_CopyColumnVector9FetchOpusEv + ..........
(16) 0xc000000019fd7660 _ZN9dfo_RowID9FetchOpusEv + ..........
(17) 0xc00000001a344570 _ZN15dfo_IndexInsert9FetchOpusEv + ..........
Read more...
Environment
SAP SYBASE IQ 16.0 SP08.22
Product
Keywords
SAP IQ, IQ, Abort, stcxtlib/st_server, ZN17s_dictionaryFetch11FetchNoCopyEPKvRi, s_dictionaryFetch, FetchNoCopy, hs_dpfetch, Destroying Locked Logical Buffer, Memory Corruption, KBA , BC-SYB-IQ , Sybase IQ , Problem
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