pHp goes Out Of Memory in rendering "Latest Data" page

[[email protected]]

The context of our zabbix system is as follows...

We are running a 1 Server, 1 PostgreSQL instance Zabbix Setup.

The server's have the following reading on the Dashboard...

Zabbix server is running Yes localhost:10051
Number of hosts (enabled/disabled/templates) 337 273 / 1 / 63
Number of items (enabled/disabled/not supported) 19589 15680 / 190 / 3719
Number of triggers (enabled/disabled [problem/ok]) 4509 1718 / 2791 [373 / 1345]
Number of users (online) 12 3
Required server performance, new values per second 283.09 -

Our servers's have the following parameters in zabbix_server.conf

LogFile=/tmp/zabbix_server.log
LogFileSize=512
DebugLevel=3
PidFile=/tmp/zabbix_server.pid
DBHost=localhost
DBName=zabbix
DBUser=zbxtmpdbusr1
DBPassword=…

StartPollers=20
StartPollersUnreachable=20
StartTrappers=4
StartPingers=4
StartDiscoverers=4
StartHTTPPollers=4
StartTimers=4
JavaGateway=localhost
JavaGatewayPort=10052
StartJavaPollers=10

CacheSize=256M
CacheUpdateFrequency=1800
HistoryCacheSize=64M
TrendCacheSize=64M
HistoryTextCacheSize=64M
ValueCacheSize=64M
Timeout=10

AlertScriptsPath=/disk1/zabbix-install-tmp/share/zabbix/alertscripts
ExternalScripts=/disk1/zabbix-install-tmp/share/zabbix/externalscripts

while running pHp with its default settings and running the PostgreSQL DB, Java_Gateway and Zabbix Server all on same box

Error we get on Zabbix UI when I tried to render the “Latest Data” page is…

Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 262144 bytes) in /var/www/html/zabbix/include/db.inc.php on line 861


When I cleaned up data from PostgreSQL as below…

zabbix=# delete from autoreg_host;
DELETE 141
zabbix=# delete from trends_uint where clock < 1447113600;
DELETE 6122798
zabbix=# delete from trends where clock < 1447113600;
DELETE 3503483
zabbix=# delete from history_text where clock < 1447113600;
DELETE 277602
zabbix=# delete from history_str where clock < 1447113600;
DELETE 3029
zabbix=# delete from history_uint where clock < 1447113600;
DELETE 139229007
zabbix=# delete from history where clock < 1447113600;
DELETE 44924016

I was expecting a quick response to the page “Latest Data” BUT it continued with the same error.
Then I increased the pHp memory to 1Gb and it was again same…

I added a few Debug prints from db.inc.php and it just blew my mind away as to the kind of queries Zabbix Server
was generating to render the “Latest Data” page…

I’ll just paste a couple :-)

SELECT t.itemdiscoveryid,t.ts_delete,t.itemid FROM item_discovery t WHERE (t.itemid BETWEEN '23694' AND '23698' OR t.itemid BETWEEN '23711' AND '23716' OR t.itemid BETWEEN '23729' AND '23820' OR t.itemid BETWEEN '23865' AND '23988' OR t.itemid BETWEEN '23994' AND '23998' OR t.itemid BETWEEN '24091' AND '24101' OR t.itemid BETWEEN '24113' AND '24134' OR t.itemid BETWEEN '24148' AND '24183' OR t.itemid BETWEEN '24281' AND '24285' OR t.itemid BETWEEN '24460' AND '24568' OR t.itemid BETWEEN '24572' AND '24596' OR t.itemid BETWEEN '25059' AND '25084' OR t.itemid BETWEEN '25156' AND '25178' OR t.itemid BETWEEN '25246' AND '25257' OR t.itemid BETWEEN '25274' AND '25281' OR t.itemid BETWEEN '25562' AND '25568' OR t.itemid BETWEEN '25573' AND '25580' OR t.itemid BETWEEN '25607' AND '25612' OR t.itemid BETWEEN '25625' AND '25632' OR t.itemid BETWEEN '25873' AND '25881' OR t.itemid BETWEEN '25904' AND '25918' OR t.itemid BETWEEN '25923' AND '25940' OR t.itemid BETWEEN '25945' AND '25962' OR t.itemid BETWEEN '25967' AND '25975' OR t.itemid BETWEEN '26630' AND '26779' OR t.itemid BETWEEN '26792' AND '26798' OR t.itemid BETWEEN '26870' AND '26894' OR t.itemid BETWEEN '26966' AND '26990' OR t.itemid BETWEEN '27062' AND '27086' OR t.itemid BETWEEN '27158' AND '27507' OR t.itemid BETWEEN '27527' AND '27854' OR t.itemid BETWEEN '27856' AND '27878' OR t.itemid BETWEEN '27891' AND '27922' OR t.itemid BETWEEN '27932' AND '27963' OR t.itemid BETWEEN '27973' AND '28004' OR t.itemid BETWEEN '28014' AND '28045' OR t.itemid BETWEEN '28055' AND '28086' OR t.itemid BETWEEN '28096' AND '28127' OR t.itemid BETWEEN '28137' AND '28168' OR t.itemid BETWEEN '28178' AND '28209' OR t.itemid BETWEEN '28219' AND '28250' OR t.itemid BETWEEN '28260' AND '28291' OR t.itemid BETWEEN '28301' AND '28332' OR t.itemid BETWEEN '28342' AND '28373' OR t.itemid BETWEEN '28383' AND '28414' OR t.itemid BETWEEN '28424' AND '28455' OR t.itemid BETWEEN '28465' AND '28496' OR t.itemid BETWEEN '28506' AND '28819' OR t.itemid BETWEEN '28824' AND '28841' OR t.itemid BETWEEN '28846' AND '28863' OR t.itemid BETWEEN '28868' AND '28885' OR t.itemid BETWEEN '28890' AND '28975' OR t.itemid BETWEEN '28980' AND '28991' OR t.itemid BETWEEN '28996' AND '29007' OR t.itemid BETWEEN '29012' AND '29023' OR t.itemid BETWEEN '29288' AND '29296' OR t.itemid BETWEEN '29301' AND '29312' OR t.itemid BETWEEN '29317' AND '29328' OR t.itemid BETWEEN '29333' AND '29344' OR t.itemid BETWEEN '29349' AND '29360' OR t.itemid BETWEEN '29365' AND '29376' OR t.itemid BETWEEN '29381' AND '29392' OR t.itemid BETWEEN '29397' AND '29408' OR t.itemid BETWEEN '29418' AND '29476' OR t.itemid BETWEEN '29481' AND '29499' OR t.itemid BETWEEN '29504' AND '29564' OR t.itemid BETWEEN '29615' AND '29719' OR t.itemid BETWEEN '29728' AND '29732' OR t.itemid BETWEEN '29742' AND '29747' OR t.itemid BETWEEN '29751' AND '29762' OR t.itemid BETWEEN '29769' AND '29828' OR t.itemid BETWEEN '29967' AND '30029' OR t.itemid BETWEEN '30031' AND '30036' OR t.itemid BETWEEN '30043' AND '30048' OR t.itemid BETWEEN '30050' AND '30063' OR t.itemid BETWEEN '30083' AND '30097' OR t.itemid BETWEEN '30107' AND '30164' OR t.itemid BETWEEN '30174' AND '30231' OR t.itemid BETWEEN '30241' AND '30298' OR t.itemid BETWEEN '30308' AND '30427' OR t.itemid BETWEEN '30499' AND '30520' OR t.itemid BETWEEN '30620' AND '30672' OR t.itemid BETWEEN '30730' AND '30761' OR t.itemid BETWEEN '30771' AND '30802' OR t.itemid BETWEEN '30812' AND '30843' OR t.itemid BETWEEN '30853' AND '30884' OR t.itemid BETWEEN '30894' AND '30925' OR t.itemid BETWEEN '30935' AND '31038' OR t.itemid BETWEEN '31048' AND '31079' OR t.itemid BETWEEN '31089' AND '31248' OR t.itemid BETWEEN '31250' AND '31257' OR t.itemid BETWEEN '31295' AND '31302' OR t.itemid BETWEEN '31313' AND '31320' OR t.itemid BETWEEN '31322' AND '31329' OR t.itemid BETWEEN '31444' AND '31463' OR t.itemid BETWEEN '31466' AND '33115' OR t.itemid BETWEEN '33117' AND '33125' OR t.itemid BETWEEN '33127' AND '33131' OR t.itemid BETWEEN '33133' AND '33146' OR t.itemid BETWEEN '33148' AND '33157' OR t.itemid BETWEEN '33159' AND '33168' OR t.itemid BETWEEN '33170' AND '33178' OR t.itemid BETWEEN '33188' AND '33245' OR t.itemid BETWEEN '33255' AND '33341' OR t.itemid BETWEEN '33343' AND '33352' OR t.itemid BETWEEN '33354' AND '33382' OR t.itemid BETWEEN '33384' AND '33393' OR t.itemid BETWEEN '33395' AND '33423' OR t.itemid BETWEEN '33425' AND '33434' OR t.itemid BETWEEN '33436' AND '33464' OR t.itemid BETWEEN '33466' AND '33475' OR t.itemid BETWEEN '33477' AND '33501' OR t.itemid BETWEEN '33507' AND '33516' OR t.itemid BETWEEN '33518' AND '33522' OR t.itemid BETWEEN '33547' AND '33556' OR t.itemid BETWEEN '33558' AND '33565' OR t.itemid BETWEEN '33567' AND '33576' OR t.itemid BETWEEN '33578' AND '33585' OR t.itemid BETWEEN '33587' AND '33596' OR t.itemid BETWEEN '33598' AND '33605' OR t.itemid BETWEEN '33607' AND '33616' OR t.itemid BETWEEN '33618' AND '33625' OR t.itemid BETWEEN '33627' AND '33636' OR t.itemid BETWEEN '33638' AND '33823' OR t.itemid BETWEEN '33844' AND '33853' OR t.itemid BETWEEN '33855' AND '33859' OR t.itemid BETWEEN '33880' AND '33885' OR t.itemid BETWEEN '33887' AND '33896' OR t.itemid BETWEEN '33898' AND '33908' OR t.itemid BETWEEN '33910' AND '33919' OR t.itemid BETWEEN '33921' AND '33931' OR t.itemid BETWEEN '33933' AND '33942' OR t.itemid BETWEEN '33944' AND '33954' OR t.itemid BETWEEN '33956' AND '33965' OR t.itemid BETWEEN '33967' AND '33977' OR t.itemid BETWEEN '33979' AND '33988' OR t.itemid BETWEEN '33990' AND '34000' OR t.itemid BETWEEN '34002' AND '34011' OR t.itemid BETWEEN '34013' AND '34023' OR t.itemid BETWEEN '34025' AND '34034' OR t.itemid BETWEEN '34036' AND '34046' OR t.itemid BETWEEN '34048' AND '34057' OR t.itemid BETWEEN '34059' AND '34069' OR t.itemid BETWEEN '34071' AND '34080' OR t.itemid BETWEEN '34082' AND '34092' OR t.itemid BETWEEN '34094' AND '34103' OR t.itemid BETWEEN '34105' AND '34115' OR t.itemid BETWEEN '34117' AND '34126' OR t.itemid BETWEEN '34128' AND '34138' OR t.itemid BETWEEN '34140' AND '34149' OR t.itemid BETWEEN '34151' AND '34161' OR t.itemid BETWEEN '34163' AND '34172' OR t.itemid BETWEEN '34174' AND '34184' OR t.itemid BETWEEN '34186' AND '34195' OR t.itemid BETWEEN '34197' AND '34207' OR t.itemid BETWEEN '34209' AND '34218' OR t.itemid BETWEEN '34220' AND '34230' OR t.itemid BETWEEN '34232' AND '34241' OR t.itemid BETWEEN '34243' AND '34253' OR t.itemid BETWEEN '34255' AND '34264' OR t.itemid BETWEEN '34266' AND '34276' OR t.itemid BETWEEN '34278' AND '34287' OR t.itemid BETWEEN '34289' AND '34296' OR t.itemid BETWEEN '34298' AND '34307' OR t.itemid BETWEEN '34309' AND '34316' OR t.itemid BETWEEN '34318' AND '34327' OR t.itemid BETWEEN '34329' AND '34336' OR t.itemid BETWEEN '34338' AND '34347' OR t.itemid BETWEEN '34349' AND '34356' OR t.itemid BETWEEN '34358' AND '34367' OR t.itemid BETWEEN '34369' AND '34376' OR t.itemid BETWEEN '34378' AND '34387' OR t.itemid BETWEEN '34389' AND '34396' OR t.itemid BETWEEN '34398' AND '34407' OR t.itemid BETWEEN '34409' AND '34416' OR t.itemid BETWEEN '34418' AND '34427' OR t.itemid BETWEEN '34429' AND '34433' OR t.itemid BETWEEN '34490' AND '34495' OR t.itemid BETWEEN '34497' AND '34517' OR t.itemid BETWEEN '34519' AND '34525' OR t.itemid BETWEEN '34527' AND '34533' OR t.itemid BETWEEN '34535' AND '34539' OR t.itemid BETWEEN '34545' AND '34550' OR t.itemid BETWEEN '34552' AND '34572' OR t.itemid BETWEEN '34574' AND '34580' OR t.itemid BETWEEN '34582' AND '34588' OR t.itemid BETWEEN '34590' AND '34594' OR t.itemid BETWEEN '34614' AND '34620' OR t.itemid BETWEEN '34733' AND '34738' OR t.itemid BETWEEN '34740' AND '34760' OR t.itemid BETWEEN '34762' AND '34768' OR t.itemid BETWEEN '34770' AND '34776' OR t.itemid BETWEEN '34778' AND '34782' OR t.itemid BETWEEN '34788' AND '34795' OR t.itemid BETWEEN '35001' AND '35030' OR t.itemid BETWEEN '35032' AND '35068' OR t.itemid BETWEEN '35070' AND '35106' OR t.itemid BETWEEN '35108' AND '35144' OR t.itemid BETWEEN '35146' AND '35182' OR t.itemid BETWEEN '35184' AND '35190' OR t.itemid BETWEEN '35200' AND '35231' OR t.itemid BETWEEN '35241' AND '35272' OR t.itemid BETWEEN '35282' AND '35313' OR t.itemid BETWEEN '35323' AND '35354' OR t.itemid BETWEEN '35364' AND '35443' OR t.itemid BETWEEN '35453' AND '35481' OR t.itemid BETWEEN '35491' AND '35519' OR t.itemid BETWEEN '35529' AND '35557' OR t.itemid BETWEEN '35567' AND '35595' OR t.itemid BETWEEN '35605' AND '35633' OR t.itemid BETWEEN '35643' AND '35671' OR t.itemid BETWEEN '35681' AND '35709' OR t.itemid BETWEEN '35719' AND '35747' OR t.itemid BETWEEN '35757' AND '35785' OR t.itemid BETWEEN '35795' AND '35823' OR t.itemid BETWEEN '35833' AND '35861' OR t.itemid BETWEEN '35871' AND '35899' OR t.itemid BETWEEN '35909' AND '35937' OR t.itemid BETWEEN '35947' AND '35975' OR t.itemid BETWEEN '35985' AND '36013' OR t.itemid BETWEEN '36023' AND '36051' OR t.itemid BETWEEN '36061' AND '36089' OR t.itemid BETWEEN '36099' AND '36127' OR t.itemid BETWEEN '36137' AND '36165' OR t.itemid BETWEEN '36175' AND '36203' OR t.itemid BETWEEN '36213' AND '36241' OR t.itemid BETWEEN '36251' AND '36279' OR t.itemid BETWEEN '36289' AND '36317' OR t.itemid BETWEEN '36327' AND '36367' OR t.itemid BETWEEN '36377' AND '36405' OR t.itemid BETWEEN '36415' AND '36443' OR t.itemid BETWEEN '36453' AND '36481' OR t.itemid BETWEEN '36491' AND '36519' OR t.itemid BETWEEN '36529' AND '36557' OR t.itemid BETWEEN '36567' AND '36595' OR t.itemid BETWEEN '36605' AND '36633' OR t.itemid BETWEEN '36643' AND '36671' OR t.itemid BETWEEN '36681' AND '36709' OR t.itemid BETWEEN '36719' AND '36747' OR t.itemid BETWEEN '36757' AND '36785' OR t.itemid BETWEEN '36795' AND '36823' OR t.itemid BETWEEN '36833' AND '36861' OR t.itemid BETWEEN '36871' AND '36899' OR t.itemid BETWEEN '36909' AND '36937' OR t.itemid BETWEEN '36947' AND '36975' OR t.itemid BETWEEN '36985' AND '37013' OR t.itemid BETWEEN '37023' AND '37051' OR t.itemid BETWEEN '37061' AND '37089' OR t.itemid BETWEEN '37099' AND '37127' OR t.itemid BETWEEN '37137' AND '37165' OR t.itemid BETWEEN '37175' AND '37203' OR t.itemid BETWEEN '37213' AND '37241' OR t.itemid BETWEEN '37251' AND '37291' OR t.itemid BETWEEN '37301' AND '37931' OR t.itemid BETWEEN '37933' AND '37939' OR t.itemid BETWEEN '37949' AND '38010' OR t.itemid BETWEEN '38012' AND '38018' OR t.itemid BETWEEN '38028' AND '38089' OR t.itemid BETWEEN '38091' AND '38097' OR t.itemid BETWEEN '38107' AND '38168' OR t.itemid BETWEEN '38170' AND '38176' OR t.itemid BETWEEN '38186' AND '38247' OR t.itemid BETWEEN '38249' AND '38255' OR t.itemid BETWEEN '38265' AND '38359' OR t.itemid BETWEEN '38361' AND '38370' OR t.itemid BETWEEN '38372' AND '38382' OR t.itemid BETWEEN '38384' AND '38393' OR t.itemid BETWEEN '38395' AND '38405' OR t.itemid BETWEEN '38407' AND '38416' OR t.itemid BETWEEN '38418' AND '38425' OR t.itemid BETWEEN '38435' AND '38466' OR t.itemid BETWEEN '38476' AND '38507' OR t.itemid BETWEEN '38517' AND '38548' OR t.itemid BETWEEN '38558' AND '38589' OR t.itemid BETWEEN '38599' AND '38630' OR t.itemid BETWEEN '38640' AND '38671' OR t.itemid BETWEEN '38681' AND '38712' OR t.itemid BETWEEN '38722' AND '38753' OR t.itemid BETWEEN '38763' AND '38794' OR t.itemid BETWEEN '38804' AND '38865' OR t.itemid BETWEEN '38867' AND '38903' OR t.itemid BETWEEN '38905' AND '38941' OR t.itemid BETWEEN '38943' AND '38979' OR t.itemid BETWEEN '38981' AND '39017' OR t.itemid BETWEEN '39019' AND '39055' OR t.itemid BETWEEN '39057' AND '39093' OR t.itemid BETWEEN '39095' AND '39131' OR t.itemid BETWEEN '39133' AND '39169' OR t.itemid BETWEEN '39171' AND '39207' OR t.itemid BETWEEN '39209' AND '39338' OR t.itemid BETWEEN '39410' AND '39434' OR t.itemid BETWEEN '39506' AND '39527' OR t.itemid BETWEEN '39578' AND '39610' OR t.itemid BETWEEN '39612' AND '39647' OR t.itemid BETWEEN '39657' AND '39689' OR t.itemid BETWEEN '39691' AND '39726' OR t.itemid BETWEEN '39736' AND '39768' OR t.itemid BETWEEN '39770' AND '39805' OR t.itemid BETWEEN '39815' AND '39847' OR t.itemid BETWEEN '39849' AND '39884' OR t.itemid BETWEEN '39894' AND '39926' OR t.itemid BETWEEN '39928' AND '39963' OR t.itemid BETWEEN '39973' AND '40005' OR t.itemid BETWEEN '40007' AND '40042' OR t.itemid BETWEEN '40052' AND '40084' OR t.itemid BETWEEN '40086' AND '40121' OR t.itemid BETWEEN '40131' AND '40163' OR t.itemid BETWEEN '40165' AND '40200' OR t.itemid BETWEEN '40210' AND '40242' OR t.itemid BETWEEN '40244' AND '40279' OR t.itemid BETWEEN '40289' AND '40321' OR t.itemid BETWEEN '40323' AND '40358' OR t.itemid BETWEEN '40368' AND '40400' OR t.itemid BETWEEN '40402' AND '40437' OR t.itemid BETWEEN '40447' AND '40479' OR t.itemid BETWEEN '40481' AND '40516' OR t.itemid BETWEEN '40526' AND '40558' OR t.itemid BETWEEN '40560' AND '40595' OR t.itemid BETWEEN '40605' AND '40637' OR t.itemid BETWEEN '40639' AND '40674' OR t.itemid BETWEEN '40684' AND '40716' OR t.itemid BETWEEN '40718' AND '40753' OR t.itemid BETWEEN '40763' AND '40795' OR t.itemid BETWEEN '40797' AND '40832' OR t.itemid BETWEEN '40842' AND '40874' OR t.itemid BETWEEN '40876' AND '40911' OR t.itemid BETWEEN '40921' AND '40953' OR t.itemid BETWEEN '40955' AND '40990' OR t.itemid BETWEEN '41000' AND '41032' OR t.itemid BETWEEN '41034' AND '41069' OR t.itemid BETWEEN '41079' AND '41111' OR t.itemid BETWEEN '41113' AND '41148' OR t.itemid BETWEEN '41158' AND '41190' OR t.itemid BETWEEN '41192' AND '41227' OR t.itemid BETWEEN '41237' AND '41269' OR t.itemid BETWEEN '41271' AND '41306' OR t.itemid BETWEEN '41316' AND '41348' OR t.itemid BETWEEN '41350' AND '41385' OR t.itemid BETWEEN '41395' AND '41427' OR t.itemid BETWEEN '41429' AND '41634' OR t.itemid BETWEEN '41637' AND '41754' OR t.itemid BETWEEN '41756' AND '41848' OR t.itemid BETWEEN '41858' AND '41890' OR t.itemid BETWEEN '41892' AND '41928' OR t.itemid BETWEEN '41938' AND '41970' OR t.itemid BETWEEN '41972' AND '42008' OR t.itemid BETWEEN '42018' AND '42050' OR t.itemid BETWEEN '42052' AND '42088' OR t.itemid BETWEEN '42098' AND '42130' OR t.itemid BETWEEN '42132' AND '42168' OR t.itemid BETWEEN '42178' AND '42210' OR t.itemid BETWEEN '42212' AND '42249' OR t.itemid BETWEEN '42258' AND '42313' OR t.itemid BETWEEN '42323' AND '42355' OR t.itemid BETWEEN '42357' AND '42393' OR t.itemid BETWEEN '42403' AND '42435' OR t.itemid BETWEEN '42437' AND '42473' OR t.itemid BETWEEN '42483' AND '42515' OR t.itemid BETWEEN '42517' AND '42553' OR t.itemid BETWEEN '42563' AND '42595' OR t.itemid BETWEEN '42597' AND '42633' OR t.itemid BETWEEN '42643' AND '42675' OR t.itemid BETWEEN '42677' AND '42713' OR t.itemid BETWEEN '42723' AND '42755' OR t.itemid BETWEEN '42757' AND '42793' OR t.itemid BETWEEN '42803' AND '42835' OR t.itemid BETWEEN '42837' AND '42873' OR t.itemid BETWEEN '42883' AND '42915' OR t.itemid BETWEEN '42917' AND '42953' OR t.itemid BETWEEN '42963' AND '42995' OR t.itemid BETWEEN '42997' AND '43033' OR t.itemid BETWEEN '43043' AND '43075' OR t.itemid BETWEEN '43077' AND '43113' OR t.itemid BETWEEN '43123' AND '43155' OR t.itemid BETWEEN '43157' AND '43193' OR t.itemid BETWEEN '43203' AND '43235' OR t.itemid BETWEEN '43237' AND '43273' OR t.itemid BETWEEN '43283' AND '43315' OR t.itemid BETWEEN '43317' AND '43353' OR t.itemid BETWEEN '43363' AND '43395' OR t.itemid BETWEEN '43397' AND '43433' OR t.itemid BETWEEN '43443' AND '43475' OR t.itemid BETWEEN '43477' AND '43513' OR t.itemid BETWEEN '43523' AND '43555' OR t.itemid BETWEEN '43557' AND '43593' OR t.itemid BETWEEN '43603' AND '43635' OR t.itemid BETWEEN '43637' AND '43673' OR t.itemid BETWEEN '43683' AND '43715' OR t.itemid BETWEEN '43717' AND '43753' OR t.itemid BETWEEN '43763' AND '43795' OR t.itemid BETWEEN '43797' AND '43942' OR t.itemid BETWEEN '43951' AND '43984' OR t.itemid BETWEEN '43987' AND '44022' OR t.itemid BETWEEN '44025' AND '44059' OR t.itemid BETWEEN '44068' AND '44134' OR t.itemid BETWEEN '44144' AND '44234' OR t.itemid BETWEEN '44244' AND '44334' OR t.itemid BETWEEN '44344' AND '44459' OR t.itemid BETWEEN '44461' AND '44465' OR t.itemid BETWEEN '44467' AND '45282' OR t.itemid BETWEEN '45284' AND '45448' OR t.itemid BETWEEN '45450' AND '45614' OR t.itemid BETWEEN '45616' AND '45780' OR t.itemid BETWEEN '45782' AND '45946' OR t.itemid BETWEEN '45948' AND '46112' OR t.itemid BETWEEN '46114' AND '46278' OR t.itemid BETWEEN '46280' AND '46444' OR t.itemid BETWEEN '46446' AND '46683' OR t.itemid BETWEEN '46693' AND '46797' OR t.itemid BETWEEN '46807' AND '46959' OR t.itemid BETWEEN '46969' AND '47097' OR t.itemid BETWEEN '47107' AND '47211' OR t.itemid BETWEEN '47221' AND '47325' OR t.itemid BETWEEN '47335' AND '47484' OR t.itemid BETWEEN '47486' AND '47502' OR t.itemid BETWEEN '47574' AND '47595' OR t.itemid BETWEEN '47598' AND '47623' OR t.itemid BETWEEN '47633' AND '47698' OR t.itemid BETWEEN '47708' AND '47773' OR t.itemid BETWEEN '47783' AND '47848' OR t.itemid BETWEEN '47858' AND '47974' OR t.itemid BETWEEN '47976' AND '48150' OR t.itemid BETWEEN '48152' AND '48326' OR t.itemid BETWEEN '48328' AND '48502' OR t.itemid BETWEEN '48504' AND '48678' OR t.itemid BETWEEN '48680' AND '48854' OR t.itemid BETWEEN '48856' AND '49030' OR t.itemid BETWEEN '49032' AND '49048' OR t.itemid BETWEEN '49050' AND '49066' OR t.itemid BETWEEN '49068' AND '49084' OR t.itemid BETWEEN '49114' AND '49132' OR t.itemid IN ('23662','23666','23670','23674','23678','23679',' 23680','23681','24001','24008','24010','24012','24 017','24019','24020','24058','24059','24060','2408 0','24185','24186','24187','24189','24190','24191' ,'24193','24194','24195','24197','24198','24199',' 24201','24202','24203','24205','24206','24207','24 209','24210','24211','24268','24271','24272','2427 3','24274','24276','24277','24278','24279','24294' ,'24295','24631','24985','24986','24987','25185',' 25186','25209','25210','25235','25236','25237','25 238','25240','25241','25242','25243','25379','2538 0','25570','25571','25582','25583','25584','25585' ,'25588','25589','25590','25591','25635','25637',' 25639','25641','25643','25645','25647','25649','25 651','25653','25655','25657','25659','25661','2566 3','25665','25667','25669','25671','25673','25675' ,'25677','25679','25681','25683','25685','25687',' 25689','25691','25693','25695','25697','25699','25 883','25884','25886','25887','25888','25920','2592 1','25942','25943','25964','25965','26231','26235' ,'26239','26243','26247','26251','26255','26259',' 26263','26267','26271','26275','26279','26283','26 287','26291','27881','28821','28822','28843','2884 4','28865','28866','28887','28888','28977','28978' ,'28993','28994','29009','29010','29025','29026',' 29028','29029','29030','29298','29299','29314','29 315','29330','29331','29346','29347','29362','2936 3','29378','29379','29394','29395','29410','29411' ,'29413','29414','29415','29478','29479','29501',' 29502','29749','30038','30039','30040','30041','30 065','30066','30068','30069','30070','33503','3350 4','33505','33543','33544','33545','33840','33841' ,'33842','34541','34542','34543','34596','34597',' 34598','34603','34604','34606','34607','34608','34 609','34611','34612','34784','34785','34786','4225 2','42253','42255','43945','43946','43948','44062' ,'44063','44065'))
One more...
SELECT a.* FROM applications a WHERE (a.hostid BETWEEN '10105' AND '10110' OR a.hostid BETWEEN '10112' AND '10120' OR a.hostid BETWEEN '10125' AND '10134' OR a.hostid BETWEEN '10184' AND '10205' OR a.hostid BETWEEN '10207' AND '10222' OR a.hostid BETWEEN '10225' AND '10232' OR a.hostid BETWEEN '10249' AND '10335' OR a.hostid BETWEEN '10338' AND '10408' OR a.hostid BETWEEN '10411' AND '10422' OR a.hostid IN ('10136','10137','10138','10140','10143','10145',' 10146','10150','10151','10152','10156','10160','10 161','10166','10167','10172','10174','10177','1017 8','10179','10180','10234','10235','10238','10239' ,'10240','10241','10243','10244','10245','10246'))


May I know

0> How come all off a sudden such queries get formed before rendering the “Latest Data” page ?
1> Has such thing happened to you before and How did you resolve it ?
2> What are the suggested settings for pHp from Zabbix.
3> What are the suggested settings for PostgreSQL from Zabbix

Please Advice, I am in need of HELP immediately.
This issue has been bugging us since a few days now.

[Colttt]

Hello..

at first please use code-blocks! it is quiet easier to read this!
if you need help immediately it is a good way to ask in the zabbix-irc!

can you please post you postgresql.conf and some hardwarespecs? also you php.ini (ehm did you restart you hhtp-server after editing this file)?

[kloczek]

If you have big SQL query output you need to have enough memory to process it using php.

[[email protected]]

pHp goes Out Of Memory in rendering &quot;Latest Data&quot; page

My postgresql.conf

max_connections = 300
shared_buffers = 2048MB
temp_buffers = 512MB

dynamic_shared_memory_type = posix

checkpoint_segments = 16
checkpoint_timeout = 15min
checkpoint_completion_target = 0.8

log_destination = 'stderr'
logging_collector = on
log_directory = 'pg_log'
log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log'
log_file_mode = 0600
log_truncate_on_rotation = on
log_rotation_age = 1d
log_rotation_size = 512MB

log_min_duration_statement = 30000
debug_pretty_print = on
log_duration = on
log_error_verbosity = verbose
log_hostname = on
log_line_prefix = '%a %u %r %h --- SQL (%i) --- SQL State (%e)'
log_lock_waits = on
log_statement = 'all'


The PostgreSQL and the Zabbix server run on a Linux box
with CentOS 6.6 on a x86_64 Arch Itel Xeon i7 with 8 Cores.
with a RAM of 188G

My php.ini config

engine = On
short_open_tag = Off
asp_tags = Off
precision = 14
y2k_compliance = On
output_buffering = 4096
zlib.output_compression = Off
implicit_flush = Off
unserialize_callback_func =
serialize_precision = 100
allow_call_time_pass_reference = Off
safe_mode = Off
safe_mode_gid = Off
safe_mode_include_dir =
safe_mode_exec_dir =
safe_mode_allowed_env_vars = PHP_
safe_mode_protected_env_vars = LD_LIBRARY_PATH
disable_functions =
disable_classes =
expose_php = On
max_execution_time = 300
max_input_time = 300
memory_limit = 128M ; I have tried to increase this to 1Gb but still get OOM
error_reporting = E_ALL & ~E_DEPRECATED
display_errors = On
display_startup_errors = On
log_errors = On
log_errors_max_len = 1024
ignore_repeated_errors = Off
ignore_repeated_source = Off
report_memleaks = On
track_errors = Off
html_errors = Off
...
default_socket_timeout = 60
...
[PostgresSQL]
pgsql.allow_persistent = On
pgsql.auto_reset_persistent = Off
pgsql.max_persistent = -1
pgsql.max_links = -1
pgsql.ignore_notice = 0
pgsql.log_notice = 0

I did restart httpd after tweaking the pHp settings

[Colttt]

hello please try

memory_limit = 512M
or 
memory_limit = 536870912

restart you apache and check with phpinfo if the values are correct

[[email protected]]

I did increase the pHp memory to 1Gb and tried, the result is the same.
Please let me know if there are other knobs to turn for a fix.
Thanks

[BDiE8VNy]

The final solution is probably ZBXNEXT-2519 - well, at least it will become the enabler to solve it

[ingus.vilnis]

Hi,

You can try disabling "Debug" mode for your user group because that also chews a lot of PHP memory when enabled.

Best Regards,
Ingus