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

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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.