SAP Knowledge Base Article - Preview

2127130 - IQ server got crashed from "Destroying Locked Logical Buffer" and "IQ Internal Error Detected: Memory Corruption"

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

SAP IQ 16.0

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.