Hi,
We are trying the last version in SVN but we have some erros whith queries (+ 1k itens):
SQL error [ORA-01795: maximum number of expressions in a list is 1000 ] in [SELECT DISTINCT g.graphid FROM graphs g, graphs_items gi, items i WHERE g.graphid=gi.graphid AND i.itemid=gi.itemid AND i.hostid NOT IN (11085,11102,11199,11243,11177,11190,11231,11283,1 1088,11236,11112,11082,0374,10376,10378,10380,1038 1,10382,10383,10385,10386,10387,10388,10390,10670, 10391,10392,10393,10394,10681,10395,10396,10398,10 715,10399,10400,...,10290,10289,10298,10285,10294, 10284,10287,10291,10280,10283,10286,10288,10292,10 696,10699,10693,10704,10766,10767,10768,10769,1077 0,11071,11072,10713,10705,10706,10707,10716,10708, 10709,10643,10644,10647,10648,10645,10646,10026,10 771,10772,10773,10774,10775,10776,10777,10778,1077 9)]
SQL error [ORA-01795: maximum number of expressions in a list is 1000 ] in [SELECT i.itemid,i.nextcheck,i.description,i.key_,i.type,h .host,h.hostid FROM items i,hosts h WHERE i.status=0 AND i.type in (0,7,1,4,6,3,5,8,10) AND ((h.status=0 AND h.available != 2) or (h.status=0 AND h.available=2 AND h.disable_until<=1216725202)) AND i.hostid=h.hostid AND i.nextcheck<1216725202 AND i.key_ not in ('status','icmpping','icmppingsec','zabbix[log]') AND i.value_type not in (2) AND h.hostid in (11085,11102,11199,11243,11177,11190,11231,11283,1 1088,11236,11112,...10716,10708,10709,10643,10644, 10647,10648,10645,10646,10026,10771,10772,10773,10 774,10775,10776,10777,10778,10779) AND round(h.hostid/100000000000000) in (0) order by i.nextcheck,h.host,i.description,i.key_]
SQL error [ORA-01795: maximum number of expressions in a list is 1000 ] in [SELECT DISTINCT h.hostid,h.host FROM hosts h WHERE h.hostid IN (11085,11102,11199,11243,11177,11190,11231,11283,1 1088,11236,11112,11082,11101,11133,11213,11225,111 34,11149,11247,11287,11164,11172,11278,11201,11096 ,11215,11086,11241,11099,11084,11098,11131,11136,1 1165,11203,...,10647,10648,10645,10646,10026,10771 ,10772,10773,10774,10775,10776,10777,10778,10779) AND round(h.hostid/100000000000000) in (0) ORDER BY h.host
[]s,
Luciano
We are trying the last version in SVN but we have some erros whith queries (+ 1k itens):
SQL error [ORA-01795: maximum number of expressions in a list is 1000 ] in [SELECT DISTINCT g.graphid FROM graphs g, graphs_items gi, items i WHERE g.graphid=gi.graphid AND i.itemid=gi.itemid AND i.hostid NOT IN (11085,11102,11199,11243,11177,11190,11231,11283,1 1088,11236,11112,11082,0374,10376,10378,10380,1038 1,10382,10383,10385,10386,10387,10388,10390,10670, 10391,10392,10393,10394,10681,10395,10396,10398,10 715,10399,10400,...,10290,10289,10298,10285,10294, 10284,10287,10291,10280,10283,10286,10288,10292,10 696,10699,10693,10704,10766,10767,10768,10769,1077 0,11071,11072,10713,10705,10706,10707,10716,10708, 10709,10643,10644,10647,10648,10645,10646,10026,10 771,10772,10773,10774,10775,10776,10777,10778,1077 9)]
SQL error [ORA-01795: maximum number of expressions in a list is 1000 ] in [SELECT i.itemid,i.nextcheck,i.description,i.key_,i.type,h .host,h.hostid FROM items i,hosts h WHERE i.status=0 AND i.type in (0,7,1,4,6,3,5,8,10) AND ((h.status=0 AND h.available != 2) or (h.status=0 AND h.available=2 AND h.disable_until<=1216725202)) AND i.hostid=h.hostid AND i.nextcheck<1216725202 AND i.key_ not in ('status','icmpping','icmppingsec','zabbix[log]') AND i.value_type not in (2) AND h.hostid in (11085,11102,11199,11243,11177,11190,11231,11283,1 1088,11236,11112,...10716,10708,10709,10643,10644, 10647,10648,10645,10646,10026,10771,10772,10773,10 774,10775,10776,10777,10778,10779) AND round(h.hostid/100000000000000) in (0) order by i.nextcheck,h.host,i.description,i.key_]
SQL error [ORA-01795: maximum number of expressions in a list is 1000 ] in [SELECT DISTINCT h.hostid,h.host FROM hosts h WHERE h.hostid IN (11085,11102,11199,11243,11177,11190,11231,11283,1 1088,11236,11112,11082,11101,11133,11213,11225,111 34,11149,11247,11287,11164,11172,11278,11201,11096 ,11215,11086,11241,11099,11084,11098,11131,11136,1 1165,11203,...,10647,10648,10645,10646,10026,10771 ,10772,10773,10774,10775,10776,10777,10778,10779) AND round(h.hostid/100000000000000) in (0) ORDER BY h.host
[]s,
Luciano
Comment