[ZBX-7930] slow maintenance page and weird queries Created: 2014 Mar 11  Updated: 2017 May 30  Resolved: 2014 Mar 19

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: 1.8.20
Fix Version/s: 1.8.21rc1, 2.0.12rc1, 2.2.3rc1, 2.3.0

Type: Incident report Priority: Major
Reporter: richlv Assignee: Ivo Kurzemnieks
Resolution: Fixed Votes: 0
Labels: maintenance, performance
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified


 Description   

if there are a lot of maintenances, just opening the configuration page can take a very long time (or it may not open at all). on top of that, some parts of the query look really strange.



 Comments   
Comment by richlv [ 2014 Mar 11 ]

query being slow is a problem, of course, but also notice the maintenance ids being repeated multiple times here

Time:22.433038 LONG SQL: SELECT * FROM (SELECT m.* FROM maintenances m WHERE ((m.maintenanceid BETWEEN 000000000000000 AND 099999999999999)) AND (m.maintenanceid IN (153,154,155,156,2896,6,7,8,24,25,34,34,38,38,39,39,40,40,206,206,206,237,237,237,238,238,238,238,289,289,289,289,290,290,290,290,291,291,291,291,291,291,405,406,684,684,684,684,685,685,685,685,686,686,686,686,687,687,687,687,688,688,688,688,689,689,689,689,690,690,690,690,691,691,691,691,692,692,692,692,693,693,693,1134,1134,1134,1135,1135,1135,1362,1362,1362,1362,1362,1362,1362,1362,1374,1374,1374,1374,1374,1374,1382,1395,1395,1395,1395,1395,1395,1395,1395,1396,1396,1396,1396,1396,1396,1401,1401,1401,1401,1401,1401,1401,1401,1401,1401,1401,1401,1401,1403,1403,1403,1403,1403,1403,1412,1412,1414,1415,1415,1415,1415,1415,1415,1416,1416,1416,1416,1416,1416,1416,1416,1418,1418,1418,1418,1418,1418,1423,1423,1423,1423,1423,1423,1428,1428,1428,1428,1428,1428,1428,1428,1428,1428,1428,1428,1430,1430,1430,1430,1430,1430,1430,1430,1430,1430,1430,1430,1431,1433,1433,1433,1433,1433,1433,1433,1434,1435,1435,1435,1435,1435,1435,1435,1435,1437,1437,1437,1437,1459,1459,1459,1459,1459,1459,1459,1459,1459,1459,1459,1459,1459,1460,1461,1461,1461,1461,1461,1474,1474,1474,1474,1474,1474,1474,1474,1476,1476,1477,1478,1481,1481,1481,1481,1481,1481,1481,1481,1487,1487,1487,1487,1487,1487,1487,1487,1488,1488,1488,1488,1488,1488,1489,1489,1489,1489,1489,1489,1490,1490,1490,1490,1490,1490,1491,1491,1491,1491,1491,1491,1492,1492,1492,1492,1492,1492,1492,1492,1492,1492,1492,1492,1493,1498,1498,1498,1498,1498,1498,1498,1498,1499,1499,1499,1499,1499,1499,1499,1499,1499,1499,1499,1499,1499,1499,1499,1499,1499,1499,1506,1506,1506,1506,1506,1506,1506,1506,1530,1530,1530,1530,1530,1530,1537,1537,1538,1539,1545,1545,1545,1545,1545,1545,1546,1546,1546,1546,1546,1546,1547,1547,1547,1547,1547,1547,1550,1550,1550,1550,1550,1550,1560,1562,1563,1564,1565,1565,1565,1565,1565,1565,1571,1572,1573,1574,1575,1575,1575,1575,1575,1587,1587,1587,1587,1587,1587,1587,1587,1587,1587,1587,1587,1587,1587,1587,1587,1587,1587,1601,1602,1603,1603,1603,1603,1603,1603,1603,1603,1603,1603,1603,1603,1604,1604,1604,1604,1604,1604,1604,1604,1605,1605,1606,1607,1610,1610,1611,1611,1611,1611,1612,1612,1613,1613,1614,1615,1641,1641,1641,1641,1641,1641,1642,1642,1642,1642,1642,1642,1646,1648,1648,1652,1652,1653,1654,1658,1658,1658,1658,1658,1658,1658,1658,1658,1658,1658,1658,1658,1658,1658,1658,1658,1658,1666,1666,1666,1666,1666,1666,1666,1666,1667,1667,1667,1667,1669,1669,1669,1669,1669,1669,1669,1669,1669,1669,1669,1669,1669,1669,1669,1669,1669,1669,1672,1672,1672,1672,1672,1672,1672,1672,1673,1673,1673,1673,1675,1675,1675,1675,1676,1676,1677,1678,1679,1679,1679,1679,1679,1679,1680,1680,1680,1680,1680,1680,1680,1680,1680,1680,1680,1680,1680,1680,1680,1680,1680,1680,1681,1681,1681,1681,1681,1681,1683,1683,1683,1683,1683,1683,1684,1684,1684,1684,1694,1695,1696,1696,1697,1698,1698,1698,1698,1698,1698,1702,1702,1702,1702,1702,1702,1702,1702,1703,1703,1703,1703,1703,1703,1703,1703,1710,1710,1710,1710,1710,1710,1711,1711,1711,1711,1717,1718,1718,1719,1719,1721,1721,1722,1722,1723,1723,1724,1724,1725,1725,1725,1725,1725,1725,1725,1725,1725,1725,1725,1725,1725,1725,1726,1727,1727,1727,1728,1729,1729,1730,1730,1730,1730,1731,1731,1731,1731,1732,1732,1732,1733,1742,1742,1743,1743,1743,1743,1743,1743,1743,1743,1746,1746,1746,1746,1747,1747,1747,1748,1748,1748,1749,1749,1749,1749,1750,1750,1750,1750,1751,1751,1751,1751,1752,1752,1752,1752,1753,1753,1753,1754,1754,1754,1757,1758,1760,1760,1760,1760,1760,1760,1760,1760,1760,1762,1762,1764,1764,1764,1764,1764,1764,1764,1764,1764,1765,1765,1765,1766,1766,1766,1768,1768,1768,1768,1768,1768,1768,1768,1768,1768,1768,1768,1768,1768,1770,1770,1770,1770,1770,1770,1770,1770,1770,1773,1773,1774,1774,1775,1776,1777,1778,1781,1781,1781,1781,1783,1783,1783,1783,1783,1783,1783,1783,1783,1784,1784,1785,1785,1787,1787,1788,1788,1791,1791,1792,1793,1795,1796,1796,1796,1805,1809,1809,1809,1809,1809,1809,1809,1809,1809,1812,1814,1816,1817,1818,1823,1823,1836,1837,1837,1837,1837,1837,1837,1840,1840,1840,1840,1840,1840,1840,1840,1840,1840,1852,1852,1853,1854,1855,1857,1857,1857,1857,1857,1857,1861,1861,1861,1861,1861,1861,1861,1862,1865,1865,1865,1865,1865,1865,1868,1870,1870,1870,1873,1873,1874,1875,1877,1877,1879,1882,1882,1882,1882,1882,1882,1884,1884,1890,1890,1890,1890,1890,1890,1890,1890,1891,1891,1892,1892,1893,1893,1894,1895,1896,1897,1897,1899,1899,1899,1899,1899,1899,1900,1900,1900,1900,1900,1900,1901,1901,1902,1902,1903,1904,1904,1904,1904,1904,1904,1905,1905,1905,1905,1905,1905,1906,1906,1908,1908,1908,1908,1908,1908,1908,1908,1908,1917,1921,1924,1925,1925,1926,1926,1927,1927,1927,1927,1929,1932,1932,1932,1932,1933,1933,1935,1935,1936,1936,1937,1940,1940,1940,1940,1940,1940,1940,1940,1940,1940,1940,1940) OR m.maintenanceid IN (1940,1940,1941,1952,1952,1952,1952,1952,1952,1952,1952,1953,1953,1953,1953,1953,1953,1955,1955,1955,1955,1955,1955,1955,1955,1955,1956,1956,1956,1956,1956,1956,1956,1956,1956,1956,1956,1956,1956,1956,1956,1956,1956,1956,1956,1956,1956,1956,1960,1960,1960,1960,1960,1960,1966,1966,1966,1966,1966,1966,1966,1966,1966,1968,1968,1968,1969,1969,1969,1970,1970,1970,1970,1970,1970,1970,1970,1970,1970,1970,1970,1970,1970,2004,2004,2004,2004,2004,2004,2004,2004,2004,2010,2014,2014,2014,2014,2014,2014,2015,2015,2016,2016,2016,2016,2017,2017,2024,2024,2024,2024,2024,2024,2024,2024,2024,2024,2024,2024,2024,2024,2030,2031,2036,2036,2036,2036,2036,2036,2036,2036,2036,2036,2036,2036,2036,2036,2036,2036,2036,2036,2057,2057,2057,2057,2057,2057,2057,2057,2057,2062,2063,2069,2070,2072,2072,2072,2072,2078,2078,2078,2078,2078,2078,2078,2078,2078,2078,2078,2078,2078,2078,2079,2080,2080,2080,2080,2080,2080,2080,2080,2080,2080,2080,2080,2080,2080,2080,2080,2080,2080,2080,2080,2080,2080,2087,2087,2087,2088,2088,2088,2097,2097,2097,2100,2100,2100,2100,2100,2100,2100,2100,2100,2100,2100,2100,2100,2100,2101,2101,2102,2102,2102,2102,2102,2102,2109,2109,2109,2109,2109,2109,2109,2109,2109,2111,2113,2113,2113,2113,2113,2113,2113,2113,2113,2114,2114,2115,2115,2115,2115,2115,2115,2115,2115,2115,2116,2116,2125,2125,2125,2125,2125,2125,2125,2125,2125,2125,2125,2125,2125,2125,2127,2127,2127,2127,2127,2127,2130,2130,2130,2132,2132,2132,2132,2132,2132,2132,2132,2132,2133,2133,2133,2133,2133,2133,2133,2133,2133,2133,2133,2133,2133,2133,2133,2134,2135,2135,2135,2142,2142,2142,2142,2142,2142,2142,2142,2142,2142,2142,2142,2142,2142,2144,2144,2144,2144,2144,2144,2144,2144,2144,2147,2147,2147,2150,2150,2150,2151,2151,2151,2159,2159,2159,2159,2159,2159,2159,2159,2159,2164,2164,2170,2171,2172,2172,2172,2172,2172,2172,2172,2172,2172,2199,2200,2208,2208,2209,2209,2210,2210,2221,2221,2221,2221,2221,2221,2221,2221,2221,2221,2221,2221,2221,2221,2221,2221,2221,2221,2224,2224,2224,2224,2224,2224,2224,2224,2224,2233,2233,2234,2234,2236,2236,2240,2240,2240,2240,2240,2240,2241,2241,2241,2241,2241,2241,2248,2253,2254,2255,2255,2256,2256,2257,2267,2267,2267,2267,2267,2267,2267,2267,2267,2270,2270,2271,2271,2271,2271,2271,2271,2272,2272,2272,2272,2272,2272,2275,2275,2275,2275,2275,2275,2275,2281,2282,2282,2282,2282,2282,2282,2282,2282,2282,2283,2284,2288,2288,2288,2288,2288,2288,2288,2289,2289,2289,2289,2289,2289,2289,2291,2291,2291,2291,2291,2291,2291,2291,2291,2291,2291,2291,2291,2291,2291,2292,2292,2293,2293,2293,2293,2293,2293,2293,2293,2293,2293,2293,2293,2293,2293,2293,2294,2295,2295,2295,2295,2295,2295,2297,2297,2297,2297,2297,2297,2297,2297,2297,2297,2297,2297,2297,2297,2297,2298,2298,2298,2298,2298,2298,2298,2298,2298,2298,2298,2298,2298,2298,2298,2301,2301,2301,2301,2301,2301,2301,2301,2301,2301,2301,2301,2301,2301,2301,2302,2302,2302,2302,2302,2302,2304,2304,2304,2304,2304,2304,2304,2305,2305,2305,2305,2305,2305,2305,2305,2305,2305,2305,2305,2305,2305,2305,2305,2312,2312,2312,2312,2312,2312,2312,2312,2312,2312,2312,2312,2312,2312,2312,2314,2314,2315,2315,2315,2315,2316,2316,2316,2317,2317,2318,2318,2318,2318,2319,2319,2319,2328,2328,2329,2329,2329,2329,2329,2333,2333,2333,2333,2333,2333,2337,2337,2337,2337,2337,2337,2339,2339,2341,2341,2341,2341,2341,2341,2342,2342,2342,2343,2343,2343,2344,2344,2344,2344,2344,2344,2346,2347,2348,2348,2348,2348,2348,2348,2349,2349,2349,2349,2349,2349,2354,2355,2355,2356,2357,2358,2358,2358,2369,2369,2370,2370,2370,2370,2396,2396,2397,2398,2407,2407,2407,2407,2407,2407,2412,2412,2412,2412,2413,2413,2413,2413,2413,2413,2414,2414,2414,2414,2414,2414,2416,2416,2416,2416,2416,2416,2418,2418,2418,2418,2418,2418,2419,2419,2419,2419,2419,2419,2421,2421,2421,2421,2421,2421,2421,2435,2442,2442,2442,2442,2442,2442,2444,2444,2444,2444,2444,2444,2445,2445,2445,2445,2445,2445,2445,2445,2445,2445,2445,2445,2445,2445,2445,2453,2453,2453,2453,2456,2456,2456,2456,2456,2457,2457,2457,2457,2458,2458,2458,2459,2459,2459,2459,2459,2460,2460,2460,2460,2460,2460,2460,2460,2460,2460,2460,2460,2460,2460,2460,2460,2460,2460,2466,2466,2466,2466,2485,2485,2485,2485,2485,2485,2485,2486,2486,2486,2486,2486,2486,2486,2486,2486,2486,2486,2486,2486,2486,2486,2486,2486,2486,2486,2486,2486,2486,2486,2486,2486,2486,2492,2492,2492,2492,2492,2492,2492,2510,2511,2521,2522,2523,2523,2523,2523,2523,2523,2525,2525,2525,2525,2525,2525,2533,2533,2533,2533,2533,2538,2538,2538,2538,2540,2540,2540,2540,2541,2541,2541,2543,2546,2547,2548,2548,2548,2548,2548,2548,2548,2548,2548,2548,2548,2548,2548,2548,2548,2550,2550,2550,2550,2551,2551,2551,2551,2552,2552,2552,2552,2554,2554,2554,2554,2564,2564,2564,2564,2571,2571,2571,2571,2571,2571,2571,2573,2573,2573,2574,2574,2574,2574,2575,2575,2575,2575,2575,2575,2575,2578,2578,2578,2578) OR m.maintenanceid IN (2578,2578,2578,2579,2579,2579,2579,2579,2579,2579,2581,2581,2581,2581,2581,2581,2581,2583,2583,2583,2583,2583,2583,2583,2584,2584,2584,2584,2584,2584,2584,2585,2585,2585,2585,2585,2585,2585,2586,2586,2586,2586,2586,2586,2586,2588,2588,2588,2588,2588,2588,2588,2589,2590,2590,2590,2590,2590,2590,2590,2591,2591,2591,2591,2591,2591,2591,2592,2592,2592,2592,2592,2592,2592,2592,2592,2592,2592,2592,2592,2592,2592,2592,2592,2592,2593,2593,2593,2593,2593,2593,2593,2594,2594,2594,2594,2594,2594,2594,2595,2595,2595,2595,2595,2595,2595,2596,2596,2596,2596,2596,2596,2596,2598,2598,2598,2598,2598,2598,2598,2601,2601,2601,2601,2601,2601,2601,2602,2602,2602,2602,2602,2602,2602,2603,2603,2603,2603,2603,2603,2603,2605,2605,2605,2605,2609,2609,2610,2610,2611,2611,2611,2611,2611,2611,2611,2611,2612,2612,2617,2617,2617,2617,2617,2617,2617,2617,2617,2617,2617,2617,2622,2622,2622,2622,2622,2622,2623,2623,2623,2623,2623,2623,2624,2624,2624,2624,2624,2624,2625,2625,2625,2625,2625,2625,2628,2628,2628,2628,2629,2629,2629,2629,2629,2629,2629,2629,2629,2629,2629,2629,2629,2629,2629,2629,2629,2629,2631,2631,2631,2631,2632,2632,2632,2632,2633,2633,2633,2633,2637,2637,2637,2637,2637,2637,2637,2637,2637,2646,2646,2646,2647,2647,2647,2647,2647,2647,2649,2649,2649,2649,2650,2650,2650,2650,2650,2650,2650,2650,2650,2650,2650,2650,2650,2650,2650,2653,2653,2653,2653,2657,2657,2657,2657,2657,2657,2657,2657,2657,2657,2657,2657,2657,2657,2657,2658,2658,2658,2658,2659,2664,2664,2664,2664,2664,2664,2664,2664,2664,2664,2664,2664,2664,2664,2665,2674,2674,2674,2674,2678,2678,2678,2683,2683,2683,2683,2683,2683,2683,2683,2683,2683,2683,2683,2683,2683,2683,2683,2683,2683,2684,2684,2684,2684,2684,2684,2684,2684,2684,2684,2684,2684,2684,2684,2684,2684,2684,2684,2696,2697,2698,2701,2703,2703,2703,2703,2713,2713,2713,2713,2714,2714,2715,2716,2719,2719,2719,2719,2719,2719,2719,2719,2719,2719,2719,2719,2719,2719,2719,2719,2719,2719,2719,2719,2719,2719,2720,2720,2720,2720,2720,2720,2720,2720,2720,2720,2720,2720,2720,2720,2720,2720,2720,2720,2720,2720,2720,2720,2722,2722,2723,2723,2723,2723,2723,2723,2723,2723,2723,2723,2723,2723,2723,2723,2723,2723,2723,2723,2725,2725,2725,2726,2726,2726,2726,2726,2726,2732,2733,2733,2733,2737,2737,2737,2737,2737,2738,2738,2738,2738,2739,2739,2739,2740,2740,2740,2740,2740,2741,2741,2741,2741,2744,2746,2746,2746,2746,2746,2746,2746,2748,2748,2748,2748,2748,2748,2748,2751,2751,2751,2751,2758,2758,2758,2759,2759,2759,2760,2760,2760,2760,2760,2760,2767,2767,2767,2768,2768,2768,2768,2773,2773,2773,2773,2775,2775,2775,2775,2775,2775,2775,2776,2776,2776,2778,2778,2778,2779,2779,2779,2779,2782,2782,2782,2782,2782,2782,2782,2782,2784,2784,2784,2784,2784,2784,2784,2784,2784,2784,2784,2784,2784,2784,2787,2788,2788,2788,2788,2788,2788,2788,2788,2788,2788,2788,2788,2788,2788,2789,2789,2789,2789,2789,2789,2789,2789,2789,2789,2789,2789,2789,2789,2794,2794,2794,2794,2794,2794,2794,2794,2794,2794,2794,2794,2794,2794,2794,2794,2794,2794,2795,2795,2795,2795,2795,2795,2795,2797,2797,2797,2797,2797,2797,2797,2797,2797,2797,2797,2797,2797,2797,2797,2802,2802,2802,2802,2803,2803,2803,2803,2806,2806,2806,2806,2806,2806,2806,2806,2806,2806,2806,2806,2806,2806,2806,2808,2808,2808,2808,2808,2808,2808,2808,2808,2808,2808,2808,2808,2808,2808,2808,2808,2808,2810,2810,2810,2810,2811,2811,2811,2811,2818,2823,2823,2823,2823,2823,2823,2823,2823,2823,2823,2823,2823,2823,2823,2823,2824,2824,2824,2824,2824,2824,2825,2825,2825,2825,2825,2825,2830,2835,2836,2841,2841,2841,2841,2843,2843,2843,2851,2851,2851,2852,2852,2852,2852,2855,2855,2855,2860,2860,2860,2860,2861,2861,2861,2861,2869,2869,2869,2870,2870,2916,2916,2916,2916,2916,2916,2916,2916,2916,2916,2916,2916,2916,2916,2916,2916,2916,2916,2919,2919,2919,2919,2924,2924,2924,2924,2924,2924,2924,2924,2924,2924,2924,2924,2924,2924,2924,2924,2924,2924,2925,2925,2925,2925,2925,2925,2925,2925,2925,2925,2925,2925,2925,2925,2925,2925,2925,2925,2925,2925,2925,2925,2925,2936,2936,2936,2936,2936,2936,2936,2936,2936,2937,2937,2937,2937,2943,2957,2957,2957,2957,2958,2958,2958,2958,2958,2958,2958,2958,2958,2958,2958,2958,2958,2958,2962,2966,2966,2966,2966,2966,2966,2966,2966,2970,2970,2970,2970,2970,2970,2970,2970,2982,2982,2982,2985,2985,2985,2986,2986,2986,2992,2993,2993,2995,2996,2997,3002,3004,3005,3006,3008,3008,3008,3014,3014,3014,3014,3014,3014,3020,3020,3020,3024,3024,2898,2898,2898,2898,2898,2898,2898,2898,2901,2901,2901,2901,2901,2901,2901,2901,2901,2901,2901,2901,2904,2905,2905,2905,2905,2905,2905,2905,2905,2905,2905,2905,2905,2905,2905,2905,2905,2905,2905,2905,2905,2905,2905,2905,2906,2906,2906,2906,2906,2906,2906,2906,2906,2906,2906,2906,2906,2906,2906,2906,2906,2906,2906,2906,2906,2906,2906,2906,2906,2906,2906,2906,2906,2906,2906,2906,2906,2906,2906,2906,2906,2916,2916) OR m.maintenanceid IN (2916,2916,2916,2870,2870,2877,2877,2877,2878,2878,2878,2878,2878,2878,2878,2878,2878,2878,2878,2878,2878,2878,2878,2878,2878,2878,2884,2884,2884,2884,2887,2887,2887,2887,2887,2887,2888,2888,2888,2893,2893,2893,2893,2893,2893,2893,2893,2893,2893,2893,2893,2893,2893,2895,2895,2895,2895,2895,2895,2898,2898,2898,2898,2898,2898,3118,3118,3118,3118,3118,3118,3118,3118,3118,3118,3118,3118,3118,3118,3118,3118,3118,3118,3126,3126,3126,3126,3126,3126,3126,3126,3126,3126,3126,3126,3126,3126,3126,3126,3126,3130,3130,3130,3130,3133,3134,3144,3144,3144,3144,3144,3145,3145,3145,3145,3145,3145,3145,3145,3145,3145,3145,3145,3145,3145,3145,3145,3145,3145,3145,3145,3145,3145,3149,3164,3165,3166,3168,3168,3168,3168,3168,3168,3184,3184,3184,3184,3184,3197,3197,3197,3199,3199,3199,3199,3199,3199,3201,3202,3206,3207,3207,3207,3207,3207,3208,3209,3212,3214,3216,3217,3223,3223,3223,3223,3223,3224,3224,3224,3224,3225,3225,3225,3226,3226,3226,3226,3226,3227,3227,3227,3227,3230,3231,3232,3233,3234,3235,3236,3240,3241,3246,3248,3251,3252,3253,3254,3255,3258,3258,3259,3261,3261,3262,3262,3287,3288,3289,3290,3292,3292,3293,3293,3296,3296,3296,3297,3297,3297,3297,3297,3302,3302,3302,3302,3302,3303,3303,3303,3303,3303,3306,3307,3307,3307,3307,3307,3307,3310,3310,3310,3312,3312,3319,3320,3321,3322,3322,3322,3322,3322,3323,3323,3323,3323,3323,3323,3323,3323,3323,3323,3323,3323,3323,3323,3323,3323,3323,3323,3323,3323,3323,3323,3323,3324,3327,3327,3327,3329,3329,3329,3329,3329,3330,3330,3330,3330,3330,3335,3337,3337,3337,3337,3337,3340,3340,3340,3340,3340,3341,3341,3341,3341,3341,3341,3341,3341,3341,3341,3341,3341,3341,3341,3341,3341,3341,3341,3341,3341,3341,3341,3342,3342,3342,3342,3342,3344,3344,3344,3344,3344,3345,3345,3345,3345,3345,3349,3349,3349,3349,3349,3352,3352,3352,3352,3352,3356,3357,3357,3357,3357,3357,3361,3361,3361,3361,3361,3362,3362,3362,3363,3363,3363,3363,3363,3369,3369,3369,3369,3369,3379,3379,3379,3380,3380,3380,3380,3380,3381,3381,3381,3381,3381,3382,3382,3382,3382,3382,3383,3384,3385,3264,3264,3264,3265,3265,3265,3267,3273,3279,3279,3283,3283,3283,3285,3285,3285,3285,3285,3285,3285,3285,3285,3285,3285,3285,3285,3285,3285,3285,3285,3285,3285,3285,3285,3285,3286,3286,3286,3286,3286,3286,3286,3286,3286,3286,3286,3286,3286,3286,3286,3286,3286,3286,3286,3286,3286,3286,3043,3043,3045,3045,3047,3047,3047,3047,3047,3047,3047,3047,3047,3048,3048,3048,3048,3048,3048,3048,3048,3048,3048,3048,3048,3048,3048,3048,3048,3048,3048,3048,3048,3048,3048,3049,3049,3049,3049,3049,3049,3049,3049,3049,3049,3049,3049,3049,3049,3050,3050,3050,3050,3050,3050,3051,3051,3051,3051,3052,3052,3052,3052,3052,3052,3052,3052,3052,3052,3052,3052,3052,3052,3052,3052,3052,3052,3053,3053,3053,3053,3053,3053,3053,3053,3054,3055,3056,3061,3061,3061,3061,3061,3061,3061,3061,3061,3061,3061,3061,3061,3061,3061,3061,3061,3061,3061,3061,3061,3061,3072,3073,3073,3073,3087,3088,3088,3088,3088,3088,3088,3090,3090,3090,3090,3091,3092,3093,3093,3093,3093,3094,3095,3096,3097,3102,3106,3106,3106,3106,3106,3106,3106,3106,3110,3110,3110,3585,3585,3585,3585,3585,3585,3585,3585,3585,3586,3586,3586,3587,3587,3587,3587,3587,3587,3587,3587,3587,3597,3597,3597,3597,3608,3608,3608,3608,3706,3706,3706,3713,3713,3713,3713,3713,3713,3713,3713,3714,3714,3714,3714,3714,3714,3714,3714,3714,3714,3714,3714,3714,3714,3714,3714,3714,3714,3714,3714,3714,3714,3714,3718,3718,3718,3718,3729,3729,3729,3729,3730,3730,3730,3736,3736,3736,3736,3736,3737,3737,3737,3737,3737,3748,3748,3753,3753,3753,3753,3753,3753,3756,3756,3756,3756,3756,3757,3757,3757,3757,3758,3758,3758,3759,3759,3759,3759,3759,3759,3760,3760,3760,3760,3767,3767,3767,3767,3767,3767,3767,3767,3767,3767,3767,3767,3767,3767,3767,3767,3768,3768,3768,3768,3768,3768,3768,3768,3768,3768,3768,3768,3768,3768,3768,3768,3769,3769,3769,3769,3769,3769,3769,3769,3769,3769,3769,3769,3769,3769,3769,3769,3769,3769,3769,3769,3769,3769,3773,3779,3779,3779,3779,3779,3780,3780,3781,3781,3789,3789,3795,3795,3795,3795,3795,3795,3795,3795,3795,3795,3795,3795,3795,3795,3795,3795,3795,3795,3795,3795,3795,3795,3795,3805,3805,3805,3805,3806,3806,3806,3806,3806,3806,3528,3529,3529,3529,3529,3529,3530,3532,3532,3532,3532,3532,3535,3536,3537,3537,3537,3537,3537,3537,3537,3537,3537,3539,3539,3539,3539,3539,3546,3546,3546,3546,3546,3558,3560,3560,3560,3560,3560,3560,3560,3560,3560,3561,3561,3561,3561,3562,3562,3562,3563,3563,3563,3563,3563,3564,3564,3564,3564,3565,3565,3566,3567,3568,3568,3569,3579,3579,3579,3579,3580,3580,3580,3580,3580,3477,3477,3477,3477,3477,3478,3478,3478,3478,3478,3479,3479,3479,3479,3479,3480,3480,3480,3480,3480,3481,3481,3481,3482,3482,3482,3483,3483,3483,3483,3483,3484,3484,3484,3484,3484,3485,3491,3491,3491,3491,3491,3493,3495,3495,3495,3496,3496,3496,3498,3499,3500,3500,3502,3502,3502,3502) OR m.maintenanceid IN (3502,3503,3503,3503,3503,3503,3510,3510,3511,3511,3519,3519,3519,3388,3388,3388,3388,3388,3389,3389,3389,3389,3389,3390,3391,3392,3396,3396,3396,3396,3396,3396,3396,3396,3396,3399,3399,3399,3399,3399,3401,3403,3403,3403,3403,3403,3404,3404,3404,3404,3404,3405,3405,3405,3405,3406,3406,3406,3406,3406,3406,3406,3406,3406,3406,3406,3406,3406,3406,3406,3406,3406,3406,3406,3406,3406,3406,3406,3406,3406,3406,3406,3406,3406,3406,3406,3406,3406,3406,3406,3406,3406,3406,3406,3407,3407,3407,3407,3407,3407,3408,3408,3408,3408,3408,3408,3408,3408,3408,3408,3408,3408,3408,3408,3408,3408,3408,3408,3408,3408,3408,3408,3409,3409,3409,3409,3409,3409,3409,3409,3409,3409,3409,3409,3409,3409,3409,3409,3409,3409,3409,3409,3409,3409,3410,3410,3410,3410,3410,3410,3410,3410,3410,3410,3410,3410,3410,3410,3410,3410,3410,3410,3410,3410,3410,3410,3420,3420,3421,3421,3425,3425,3425,3426,3426,3426,3427,3427,3427,3427,3427,3427,3428,3428,3428,3429,3429,3429,3430,3430,3430,3431,3431,3431,3433,3433,3433,3435,3435,3435,3436,3436,3436,3437,3437,3437,3438,3438,3438,3453,3454,3454,3454,3454,3454,3459,3459,3459,3459,3459,3468,3468,3468,3468,3468,3470,3470,3470,3471,3471,3471,3471,3471,3672,3676,3676,3676,3680,3680,3680,3680,3680,3682,3683,3693,3693,3693,3694,3698,3699,3700,3934,3934,3934,3935,3935,3935,3935,3940,3940,3940,3940,3940,3941,3941,3941,3941,3941,3942,3942,3942,3942,3942,3942,3942,3942,3942,3942,3942,3942,3942,3942,3944,3944,3944,3944,3944,3944,3944,3944,3944,3944,3944,3944,3944,3944,3950,3950,3950,3950,3950,3951,3951,3951,3951,3951,3959,3959,3959,3959,3959,3964,3964,3964,3964,3964,3967,3968,3971,3972,3992,3895,3897,3897,3897,3898,3898,3898,3899,3899,3899,3899,3899,3899,3899,3899,3899,3899,3899,3899,3899,3899,3902,3904,3909,3909,3909,3910,3910,3910,3916,3916,3916,3916,3916,3916,3916,3916,3916,3916,3916,3916,3916,3916,3917,3917,3917,3917,3917,3917,3917,3918,3918,3918,3918,3918,3918,3918,3922,3922,3923,3923,3923,3923,3923,3931,3931,3931,3931,3931,3932,3932,3932,3932,3933,3933,3933,3934,3934,4380,4380,4380,4380,4380,4380,4380,4380,4380,4380,4380,4380,4380,4380,4381,4381,4381,4387,4387,4387,4387,4387,4387,4387,4387,4387,4387,4387,4387,4387,4387,4387,4387,4387,4387,4387,4387,4387,4387,4387,4388,4388,4388,4388,4388,4389,4389,4389,4405,4405,4417,4417,4417,4417,4417,4417,4418,4418,4418,4424,4424,4424,4425,4425,4425,4426,4426,4426,4426,4426,4426,4449,4460,4464,4464,4464,4464,4464,4464,4465,4468,4468,4468,4468,4468,4468,4468,4468,4474,4474,4474,4474,4474,4475,4476,4477,4479,4483,4484,4484,4484,4484,4484,4484,4484,4486,4487,4487,4487,4487,4487,4487,4487,4487,4487,4487,4487,4487,4487,4487,3806,3806,3807,3807,3807,3807,3807,3807,3807,3807,3807,3807,3807,3807,3807,3807,3813,3813,3813,3813,3813,3813,3813,3813,3813,3813,3813,3813,3813,3813,3813,3813,3813,3813,3813,3813,3813,3813,3814,3814,3814,3814,3814,3814,3814,3814,3816,3817,3821,3822,3827,3827,3827,3827,3827,3827,3827,3841,3841,3841,3841,3841,3841,3841,3841,3841,3841,3841,3841,3841,3841,3841,3841,3862,3862,3862,3862,3862,3862,3863,3863,3863,3863,3863,3863,3878,3878,3878,3878,3878,3878,3878,3878,3878,3878,3878,3878,3878,3878,4136,4136,4136,4136,4136,4137,4137,4137,4137,4137,4146,4146,4150,4150,4172,4172,4172,4172,4172,4172,4172,4172,4172,4173,4173,4173,4175,4175,4175,4175,4175,4177,4177,4177,4177,4179,4179,4179,4179,4179,4179,4180,4180,4180,4180,4180,4183,4183,4183,4183,4183,4184,4270,4270,4270,4270,4270,4271,4271,4271,4271,4272,4272,4272,4272,4274,4274,4274,4274,4274,4274,4274,4274,4274,4274,4274,4274,4274,4274,4274,4274,4279,4279,4279,4279,4279,4280,4280,4280,4280,4280,4282,4282,4282,4282,4282,4284,4284,4284,4284,4284,4284,4284,4284,4284,4284,4284,4284,4284,4284,4296,4296,4296,4296,4297,4297,4297,4297,4299,4299,4299,4299,4300,4300,4300,4300,4301,4302,4303,4304,4305,4305,4305,4305,4306,4306,4306,4306,4309,4309,4309,4309,4309,4309,4015,4015,4015,4015,4015,4025,4025,4025,4025,4025,4030,4030,4030,4030,4030,4034,4034,4034,4034,4034,4036,4036,4037,4037,4037,4037,4037,4037,4037,4037,4037,4043,4043,4044,4044,4047,4047,4047,4047,4047,4048,4057,4057,4057,4057,4058,4058,4058,4058,4058,4059,4060,4061,4061,4061,4061,4061,4061,4067,4067,4067,4067,4067,4067,4067,4070,4070,4070,4070,4070,4226,4226,4227,4227,4227,4227,4227,4230,4230,4230,4230,4230,4231,4231,4231,4231,4231,4232,4232,4232,4232,4232,4233,4233,4233,4233,4233,4235,4235,4235,4235,4235,4237,4237,4237,4237,4237,4254,4254,4254,4254,4254,4261,4261,4267,4267,4267,4267,4267,4267,4267,4268,4268,4268,4268,4268,4268,4268,4268,4268,4268,4268,4268,4268,4268,4191,4191,4191,4191,4191,4195,4195,4196,4196,4198,4198,4198,4198,4198,4198,4199,4199,4199,4199,4199,4203,4203,4203,4203,4203,4204,4204,4204,4204,4204,4206,4207,4208,4209,4210,4211,4215,4215,4215,4215,4216,4216,4216,4216,4216,4218,4218,4218,4218,4218,4219,4219,4219) OR m.maintenanceid IN (4219,4219,4221,4221,4221,4221,4221,4222,4222,4222,4222,4223,4223,4223,4224,4224,4224,4224,4224,4225,4225,4225,4225,4225,4226,4226,4309,4309,4309,4309,4309,4309,4309,4309,4309,4309,4311,4311,4311,4311,4311,4311,4311,4312,4312,4312,4312,4312,4312,4312,4313,4313,4313,4313,4313,4313,4313,4313,4313,4313,4313,4313,4313,4313,4313,4313,4313,4313,4313,4313,4313,4313,4313,4314,4314,4314,4314,4314,4327,4328,4328,4328,4328,4328,4329,4329,4329,4329,4329,4329,4330,4330,4330,4330,4330,4333,4333,4333,4333,4333,4333,4333,4333,4333,4333,4333,4333,4333,4333,4333,4333,4335,4335,4335,4335,4335,4335,4335,4335,4335,4335,4335,4335,4335,4335,4335,4335,4118,4118,4119,4119,4119,4119,4119,4120,4120,4120,4120,4120,4120,4075,4075,4075,4075,4075,4077,4077,4078,4078,4081,4081,4089,4089,4089,4089,4089,4093,4093,4093,4093,4093,4094,4094,4094,4094,4094,4576,4576,4576,4576,4576,4576,4577,4577,4577,4577,4577,4577,4578,4578,4578,4578,4578,4336,4336,4336,4336,4336,4336,4336,4336,4336,4336,4336,4336,4336,4336,4336,4336,4336,4336,4336,4336,4336,4336,4336,4339,4339,4339,4340,4354,4355,4356,4356,4356,4360,4363,4370,4370,4370,4370,4370,4371,4371,4371,4371,4371,4371,4371,4371,4371,4371,4371,4371,4371,4371,4371,4371,4371,4371,4371,4371,4371,4371,4372,4372,4372,4372,4372,4375,4376,4376,4376,4376,4376,4377,4377,4377,4377,4377,4378,4378,4378,4378,4378,4379,4379,4379,4379,4379,4379,4379,4379,4379,4379,4379,4379,4379,4379,4580,4580,4580,4580,4580,4580,4580,4581,4581,4581,4581,4581,4581,4581,4583,4583,4583,4584,4584,4584,4585,4585,4585,4586,4586,4586,4587,4587,4587,4587,4587,4533,4533,4533,4547,4547,4547,4547,4548,4548,4548,4548,4548,4548,4548,4548,4548,4548,4548,4548,4548,4548,4548,4548,4548,4548,4548,4548,4548,4548,4548,4548,4548,4548,4548,4548,4548,4548,4548,4548,4548,4548,4548,4548,4548,4548,4548,4548,4548,4548,4548,4548,4548,4548,4548,4548,4548,4548,4548,4548,4548,4548,4548,4548,4548,4548,4548,4548,4548,4548,4548,4548,4552,4552,4552,4552,4509,4509,4509,4517,4517,4517,4517,4517,4519,4519,4526,4526,4529,4529,4529,4529,4529,4529,4529,4529,4529,4529,4529,4529,4529,4529,4529,4529,4530,4530,4531,4531,4531,4532,4532,4532,4489,4489,4489,4489,4489,4489,4489,4490,4490,4490,4490,4490,4490,4490,4496,4496,4496,4496,4496,4505,4505,4505,4505,4505,4556,4556,4556,4556,4556,4556,4556,4556,4556,4556,4556,4556,4556,4556,4556,4556,4556,4556,4556,4556,4556,4556,4556,4556,4556,4556,4556,4560,4560,4560,4560,4560,4560,4563,4563,4563,4563,4563,4568,4568,4568,4568,4568,4572,4572,4572,4572,4572,4572,4572,4573,4573,4573,4573,4573,4660,4660,4660,4660,4660,4660,4660,4660,4660,4660,4660,4660,4660,4660,4660,4660,4660,4660,4660,4660,4660,4660,4660,4660,4660,4660,4660,4661,4661,4661,4661,4661,4661,4661,4661,4661,4661,4661,4661,4661,4661,4661,4661,4661,4661,4661,4661,4661,4661,4661,4661,4661,4661,4661,4662,4662,4662,4662,4662,4662,4662,4662,4662,4662,4662,4662,4662,4662,4662,4662,4662,4662,4662,4662,4662,4662,4662,4662,4662,4662,4662,4663,4663,4663,4663,4663,4663,4663,4663,4663,4663,4663,4663,4663,4663,4663,4663,4663,4663,4663,4663,4663,4663,4663,4663,4663,4663,4663,4664,4664,4664,4664,4664,4664,4664,4664,4664,4664,4664,4664,4664,4664,4664,4664,4664,4664,4664,4664,4664,4664,4664,4664,4664,4590,4590,4590,4590,4590,4590,4590,4591,4591,4591,4591,4591,4591,4591,4591,4591,4591,4591,4591,4591,4591,4591,4591,4591,4591,4591,4591,4591,4591,4591,4591,4591,4591,4591,4594,4594,4594,4594,4594,4594,4594,4595,4595,4595,4595,4595,4595,4595,4600,4600,4600,4600,4600,4600,4600,4600,4600,4600,4600,4600,4600,4600,4683,4683,4683,4683,4683,4683,4683,4683,4683,4683,4683,4684,4684,4684,4684,4684,4684,4685,4685,4685,4685,4685,4685,4685,4685,4685,4685,4685,4685,4685,4685,4685,4685,4687,4687,4687,4687,4687,4687,4687,4687,4687,4687,4687,4687,4687,4687,4687,4687,4687,4687,4687,4687,4687,4687,4687,4687,4687,4687,4687,4690,4690,4690,4690,4690,4690,4692,4692,4692,4692,4692,4692,4692,4692,4692,4692,4692,4692,4692,4692,4692,4692,4692,4692,4692,4692,4692,4692,4692,4692,4692,4692,4692,4696,4696,4696,4696,4696,4696,4696,4696,4696,4696,4696,4696,4696,4696,4696,4696,4696,4696,4696,4696,4696,4696,4696,4696,4696,4696,4696,4696,4696,4696,4696,4696,4696,4696,4696,4696,4696,4696,4696,4696,4696,4696,4696,4696,4696,4696,4696,4696,4696,4696,4696,4696,4696,4696,4696,4696,4696,4696,4696,4696,4696,4696,4696,4696,4696,4696,4696,4698,4698,4698,4698,4698,4698,4698,4698,4698,4698,4698,4698,4698,4698,4698,4698,4698,4698,4698,4698,4698,4698,4698,4698,4698,4698,4698,4698,4698,4698,4698,4698,4698,4698,4698,4698,4698,4698,4698,4698,4698,4698,4698,4698,4698,4698,4698,4698,4698,4698,4698,4698,4698,4698,4698,4698,4698,4698,4698,4698,4698,4698,4698,4698,4698,4698,4698,4701,4701,4701,4701,4701,4701,4701,4701,4701,4701,4701,4701,4701,4701,4701,4701,4701,4703,4703,4703,4705,4705,4705,4707,4707,4707,4709,4709) OR m.maintenanceid IN (4709,4709,4709,4709,4709,4709,4709,4709,4710,4710,4710,4710,4710,4710,4710,4710,4710,4710,4711,4711,4711,4712,4712,4712,4712,4717,4717,4717,4717,4717,4717,4718,4718,4723,4723,4723,4726,4726,4726,4726,4726,4726,4727,4727,4727,4727,4727,4727,4728,4728,4728,4728,4728,4728,4729,4729,4729,4729,4729,4729,4730,4730,4730,4730,4730,4730,4730,4730,4730,4730,4730,4730,4733,4733,4735,4735,4735,4736,4737,4737,4737,4737,4737,4737,4738,4739,4739,4739,4739,4739,4739,4740,4742,4742,4742,4742,4742,4742,4742,4742,4742,4742,4742,4742,4742,4742,4742,4742,4742,4742,4742,4742,4742,4742,4742,4742,4742,4742,4742,4742,4742,4742,4742,4742,4742,4742,4742,4742,4742,4742,4742,4742,4742,4742,4742,4742,4742,4742,4742,4742,4742,4742,4742,4742,4742,4742,4742,4742,4742,4742,4742,4742,4742,4742,4742,4742,4742,4742,4742,4745,4745,4745,4745,4745,4745,4745,4745,4745,4633,4633,4633,4633,4635,4635,4635,4635,4635,4635,4635,4635,4635,4635,4635,4635,4635,4635,4635,4635,4637,4637,4637,4637,4637,4637,4637,4639,4639,4639,4640,4640,4640,4641,4641,4641,4642,4642,4642,4642,4642,4642,4642,4643,4643,4643,4643,4643,4643,4643,4644,4644,4644,4644,4644,4647,4647,4647,4647,4647,4647,4647,4652,4653,4654,4655,4656,4656,4656,4656,4656,4656,4656,4657,4657,4658,4658,4658,4658,4658,4658,4658,4658,4658,4658,4658,4658,4658,4658,4658,4658,4658,4658,4658,4658,4658,4658,4658,4658,4658,4658,4658,4659,4659,4659,4659,4659,4659,4659,4659,4659,4659,4659,4659,4659,4659,4659,4659,4659,4659,4659,4659,4659,4659,4659,4659,4659,4659,4659,4604,4604,4604,4604,4604,4604,4604,4604,4604,4604,4604,4604,4604,4604,4613,4613,4613,4613,4613,4614,4614,4614,4614,4614,4614,4614,4615,4615,4615,4615,4615,4615,4615,4616,4616,4617,4617,4617,4617,4617,4617,4617,4617,4617,4617,4617,4617,4617,4617,4618,4618,4620,4620,4620,4621,4621,4621,4621,4621,4621,4621,4622,4622,4623,4623,4623,4623,4623,4623,4623,4624,4624,4624,4625,4625,4625,4625,4625,4626,4626,4626,4626,4626,4626,4626,4626,4626,4626,4626,4626,4626,4626,4627,4627,4627,4627,4627,4627,4627,4627,4627,4627,4627,4627,4627,4627,4629,4629,4629,4629,4629,4629,4629,4633,4633,4633,4664,4664,4665,4665,4665,4665,4665,4665,4665,4665,4665,4665,4666,4666,4666,4668,4668,4668,4669,4669,4669,4669,4669,4670,4670,4670,4670,4670,4671,4671,4671,4671,4671,4673,4673,4673,4681,4681,4682,4682,4682,4682,4682,4682,4682,4682,4682,4682,4682,4682,4682,4682,4682,4682,4682,4682,4682,4682,4682,4682,4682,4682,4682,4682,4682,4682,4682,4683,4683,4683,4683,4683,4683,4683,4683,4683,4683,4683,4683,4683,4683,4683,4683,4683,4683,4745,4745,4745,4745,4745,4745,4745,4745,4745,4745,4745,4745,4745,4745,4745,4745,4745,4745,4745,4745,4745,4745,4745,4745,4745,4745,4745,4745,4745,4745,4745,4745,4745,4745,4745,4745,4745,4745,4745,4745,4745,4745,4745,4745,4745,4745,4745,4745,4745,4745,4745,4745,4745,4745,4745,4745,4745,4745,4746,4746,4746,4746,4746,4746,4746,4746,4746,4746,4746,4746,4746,4746,4746,4746,4746,4746,4746,4746,4746,4746,4746,4746,4746,4746,4746,4746,4746,4746,4746,4746,4746,4746,4746,4746,4746,4746,4746,4746,4746,4746,4746,4746,4746,4746,4746,4746,4746,4746,4746,4746,4746,4746,4746,4746,4746,4746,4746,4775,4775,4775,4775,4775,4776,4776,4776,4776,4777,4777,4777,4779,4779,4779,4779,4780,4780,4780,4780,4781,4781,4781,4781,4782,4782,4782,4782,4782,4782,4783,4784,4786,4786,4786,4786,4787,4789,4789,4789,4789,4789,4789,4789,4789,4789,4789,4789,4789,4789,4789,4789,4789,4789,4789,4789,4789,4789,4789,4789,4789,4789,4789,4789,4789,4789,4789,4789,4789,4789,4789,4789,4789,4789,4789,4789,4789,4789,4789,4789,4789,4789,4789,4789,4789,4789,4789,4789,4789,4789,4789,4789,4789,4789,4789,4789,4789,4789,4789,4789,4789,4789,4789,4789,4791,4791,4792,4792,4792,4792,4792,4792,4792,4792,4792,4792,4792,4792,4792,4792,4792,4792,4792,4792,4792,4792,4792,4792,4792,4792,4792,4792,4792,4792,4792,4792,4792,4792,4792,4792,4792,4792,4792,4792,4792,4792,4792,4792,4792,4792,4792,4792,4792,4792,4792,4792,4792,4792,4792,4792,4792,4792,4792,4792,4792,4792,4792,4792,4792,4792,4746,4746,4746,4746,4746,4746,4746,4746,4748,4748,4748,4748,4751,4751,4751,4751,4751,4751,4751,4751,4751,4751,4751,4751,4751,4751,4751,4751,4751,4751,4751,4751,4751,4751,4751,4751,4751,4751,4751,4751,4751,4752,4752,4752,4752,4752,4752,4752,4752,4752,4752,4752,4752,4753,4754,4755,4756,4758,4758,4758,4758,4758,4758,4758,4758,4758,4758,4759,4759,4759,4759,4759,4759,4759,4759,4759,4759,4759,4759,4759,4759,4759,4759,4759,4764,4764,4764,4764,4764,4764,4764,4764,4764,4764,4764,4764,4764,4764,4764,4764,4764,4766,4766,4766,4769,4769,4769,4770,4770,4770,4770,4770,4771,4771,4771,4771,4771,4772,4772,4772,4772,4772,4773,4773,4773,4773,4774,4774,4774,4856,4856,4856,4858,4858,4858,4858,4859,4859,4861,4861,4866,4866,4866,4868,4868,4868,4869,4869,4869,4870,4871,4872,4872,4872,4872,4872,4872,4872,4872,4872,4872,4872,4872,4872,4872) OR m.maintenanceid IN (4872,4872,4872,4872,4872,4872,4872,4872,4872,4872,4872,4872,4872,4874,4874,4874,4875,4875,4875,4876,4876,4877,4877,4877,4877,4877,4877,4792,4792,4792,4794,4794,4794,4796,4797,4797,4797,4798,4798,4798,4801,4801,4801,4802,4802,4802,4802,4802,4802,4804,4804,4804,4804,4804,4804,4806,4806,4806,4806,4806,4806,4806,4806,4806,4806,4806,4806,4806,4806,4806,4806,4806,4806,4806,4806,4806,4806,4806,4806,4806,4806,4806,4806,4806,4806,4806,4806,4806,4806,4806,4806,4806,4806,4806,4806,4806,4806,4806,4806,4806,4806,4806,4806,4806,4806,4806,4806,4806,4806,4806,4806,4806,4806,4806,4806,4806,4806,4806,4806,4806,4806,4806,4808,4808,4808,4808,4808,4808,4808,4808,4808,4808,4808,4808,4808,4808,4808,4808,4808,4808,4808,4808,4808,4808,4808,4808,4808,4808,4808,4811,4811,4811,4811,4812,4812,4812,4812,4812,4812,4813,4813,4813,4813,4813,4813,4813,4813,4813,4813,4813,4813,4813,4813,4813,4813,4813,4813,4813,4813,4813,4813,4813,4813,4813,4813,4813,4815,4815,4816,4816,4816,4816,4818,4818,4818,4819,4819,4819,4822,4822,4822,4822,4822,4822,4823,4824,4825,4825,4828,4828,4828,4828,4828,4828,4828,4828,4828,4828,4828,4828,4828,4828,4828,4828,4828,4831,4832,4833,4834,4835,4836,4837,4837,4837,4837,4838,4838,4838,4838,4839,4840,4841,4842,4845,4845,4845,4846,4846,4846,4847,4847,4847,4847,4848,4848,4849,4849,4849,4850,4850,4850,4851,4851,4851,4851,4852,4852,4852,4853,4853,4853,4853,4854,4854,4854,4854,4854,4855,4855,4855,4855,4855,4855,4855,4855,4855,4855,4855,4855,4855,4855,4855,4855,4856,4856,4856)) ORDER BY m.name ASC) WHERE rownum BETWEEN 0 AND 1001
Comment by Ivo Kurzemnieks [ 2014 Mar 19 ]

Querying maintenances in 1.8 took sometimes more than a minute. Now due to removal of repeating IDs, managed to improve performace from 60 seconds to 0,06 seconds.

In addition changed frontend to query all IDs first and after that query additional data like type, description, etc. This should also slightly improve performance at least by 0,10 seconds when opening page.

In 2.0 and higher, IDs did not repeat. So only slight improvement can be seen there.

RESOLVED for 1.8 in svn://svn.zabbix.com/branches/dev/ZBX-7930-18
RESOLVED for 2.0 in svn://svn.zabbix.com/branches/dev/ZBX-7930-20

Comment by Pavels Jelisejevs (Inactive) [ 2014 Mar 20 ]

TESTED.

Comment by Ivo Kurzemnieks [ 2014 Mar 20 ]

In 1.8 removed duplicating IDs improving SQL query performance and improved page execution time, by changing frontend to first query all IDs and then query additional data.
For 2.0 and all versions above improved only page execution time.

Fixed in: pre-1.8.21rc1 r43594, pre-2.0.12rc1 r43595, pre-2.2.3rc1 r43596, pre-2.3.0 (trunk) r43597

Comment by Ivo Kurzemnieks [ 2014 Mar 20 ]

(1) Added documentation for 1.8 https://www.zabbix.com/documentation/1.8/manual/about/what_s_new_in_zabbix_1.8.21
Please review.

martins-v Reviewed, one small change made. If it's ok, this can be closed.

iivs Thanks! CLOSED.

Generated at Tue Apr 23 11:27:53 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.