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
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.