Symptom
- Periodically, customer's IQ server reports below error and IQ server crashes or hangs requiring a reboot to recover from the error.
I. 11/17 04:13:38. 0001343707 I. 11/17 04:13:38. Exception Thrown from dflib/dfo_ColumnVector.cxx:242, Err# 1058, tid 140552188131072 origtid 140552188131072
I. 11/17 04:13:38. 0001343707 O/S Err#: 0, ErrID: 9216 (df_Exception); SQLCode: -1001047, SQLState: 'QFA43', Severity: 14
I. 11/17 04:13:38. 0001343707 [20556]: Ran out of IQ large memory (-iqlm) .
-- (dflib/dfo_ColumnVector.cxx 242)
...
I. 11/17 04:29:53. 0001345283 ----- LMA::Dump (oslib/hos_mem.cxx:3216)-------
I. 11/17 04:29:53. 0001345283 Flexible Memory Usage ---
I. 11/17 04:29:53. 0001345283 Max Specified Large Memory = 1048576000000
I. 11/17 04:29:53. 0001345283 Percentage of Flexible Memory =50
I. 11/17 04:29:53. 0001345283 Percentage of Inflexible Memory =80
I. 11/17 04:29:53. 0001345283 Percentage of Anti-starvation =50
I. 11/17 04:29:53. 0001345283 Max Available Flexible Memory = 524288000000
I. 11/17 04:29:53. 0001345283 Max Available Inflexible Memory = 943718400000
I. 11/17 04:29:53. 0001345283 Total Granted Flexible Memory=0
I. 11/17 04:29:53. 0001345283 Total Users of Flexible Memory= 0
I. 11/17 04:29:53. 0001345283 Flexible memory still allocated:
I. 11/17 04:29:53. 0001345283 Inflexible Memory Usage ---
I. 11/17 04:29:53. 0001345283 Total Granted Inflexible Memory =134225920
I. 11/17 04:29:53. 0001345283 Total Users of Allocates Inflexible Memory = 4098
I. 11/17 04:29:53. 0001345283 Total Unlocked Inflexible Memory = 1045652992000
I. 11/17 04:29:53. 0001345283 Total Users of Unlocked Inflexible Memory = 920918
I. 11/17 04:29:53. 0001345283 Inflexible memory still allocated:
I. 11/17 04:29:53. 0001345283 MemID= 3 Status=LM_ALLOC Priority=LM_HIGH MemSize= 67109376 Counter=1 MemAddr=0x7f1c868ff000
....
- Current startup parameters of IQ server
-iqpartition 32
-iqmc 640000
-iqtc 440000
-iqlm 540000
- Current OS setting of 'max_map_count'
/proc/sys/vm/max_map_count = 65530
Read more...
Environment
SAP IQ16.1 SP05
Keywords
CR828768, 828768, "iqlm", "Inflexible Memory", "Flexible Memory", "max_map_count" , "sysctl.conf" , , 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