SAP Knowledge Base Article - Preview

2613721 - Too small catalog cache size resulted in server crash when it exceeded upper bound(65536K) -- SAP IQ16.1

Symptom

When customer's IQ server started with catalog cache setting as '-cl 1024 -ch 2048' without a unit(k,m,g,p),
server regarded it as minimum 912K and maximum 65536K because '-cl 1024' meant 1024 bytes.
While many operations were executing, the cache size was growing and finally met upper bound 65536K
and got to crash.

  •  *.iqmsg

  I. 03/02 16:14:54. 0000000018 **************************************************
  I. 03/02 16:14:54. 0000000018 ***   SAP IQ Abort:
  I. 03/02 16:14:54. 0000000018 ***      From:  stcxtlib/st_server.cxx:2085
  I. 03/02 16:14:54. 0000000018 ***      PID: 12624
  I. 03/02 16:14:54. 0000000018 ***      Message: caught signal 8, program abort
  I. 03/02 16:14:54. 0000000018 ***      Thread: 139820907603712  (TID: 6)
  I. 03/02 16:14:54. 0000000018 ***************************************************

  • *.srvlog
      
    I. 02/27 11:10:35.253382 908K of memory used for caching
    I. 02/27 11:10:35.253426 Minimum cache size: 912K, maximum cache size: 65536K
    ...
    I. 02/27 11:10:35.319819 Cache size adjusted to 1496K
    ...
    I. 02/27 11:10:36.463182 Cache size adjusted to 2628K
    ...
    I. 03/02 15:57:04.414414 Cache size adjusted to 63760K
    I. 03/02 15:57:04.421871 Cache size adjusted to 63972K
    I. 03/02 15:57:04.424178 Cache size adjusted to 64568K
    I. 03/02 15:57:04.427684 Starting dumping cache info to 'IQ_cache_28930.0.dmp' ... 
    I. 03/02 15:57:04.431517 Completed dumping cache info


Read more...

Environment

SAP IQ 16.1

Product

SAP IQ all versions

Keywords

"Cache size adjusted" ; "Completed dumping cache info" ; "DB_Assert" ; , 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.