Добрый день!
Столкнулся с проблемой, что zabbix server стал останавливаться сам по себе. Вот, что выдают логи.
23685:20180123:155315.418 slow query: 10.589799 sec, "select distinct itemid from trends_uint where clock>=1516683600 and (itemid between 27046 and 27065 or itemid between 27070 and 27078 or itemid between 27080 and 27089 or itemid between 27596 and 27600 or itemid between 27603 and 27614 or itemid between 27616 and 27623 or itemid between 27628 and 27632 or itemid between 27635 and 27646 or itemid between 27648 and 27655 or itemid in (23726,23727,23728,23965,23966,23967,23968,24026,2 4027,24028,24086,24087,24088,24089,24146,24147,241 48,24328,24386,24387,24388,24446,24447,24448,24686 ,24866,24929,24986,24987,24988,25346,25349,25646,2 5647,25949,26005,26006,26007,26008,26126,26127,261 28,26186,26187,26246,26247,26248,26306,26307,26308 ,26309,26366,26367,26368,26369,27067,27068,27091,2 7092,27093,27094,27324,27325,27326,27327,27593,275 94,27625,27626,27926,27927,27928,28106,28108,28226 ,28346,28347,28348,28526,28527,28528,29126,29127,2 9128,29186,29246,29247,29248,29306,29307,29308,293 09,29786,29787,29788,30147,30206,30207,30208,30209 ,30386,30387,30388,30389,31646,31647,31648,32486,3 2547,33266,33268,33269,33567,33568,34406,34407,344 08,34409,34586,34587,34588,35546,35547,35548,35607 ,35608,36206,36207,36208,36209,36626,36627,36628,3 6629,36808,37166,37167,37168,37169,37346,37347,373 48,37349,37586,37587,37588,37589,37767,37768,37946 ,38066,38067,38068,38246,38247,38248,38546,38547,3 8548,38549,38606,38609,38666,38667,38668,38669,387 86,38788,38847,38848,38849,39146,39147,39148,39149 ,39207,39208,39209,39266,39267,39268,39326,39327,3 9446,39447,39448,39506,39507,39508,39569,39628,396 29,39806,39807,39808,40408,40466,40467,40468,40469 ))"
23682:20180123:155317.871 slow query: 11.230671 sec, "select distinct itemid from trends_uint where clock>=1516683600 and (itemid between 27171 and 27213 or itemid between 27215 and 27219 or itemid in (23975,24035,24036,24155,24395,24456,24520,24523,2 4755,24935,25235,25296,25765,25955,26015,26195,262 55,26315,26316,26375,26498,26501,26675,26970,27274 ,27301,27703,27815,28115,28176,28535,29135,29195,2 9255,29315,29435,29436,29795,30035,30635,31378,316 55,32496,33275,33276,34595,35555,35615,35828,36961 ,37175,37355,37356,37595,38615,38675,38736,38795,3 9155,39275,39276,39335,39395,39455,39515,39575,395 76,39635,39815,39875))"
23691:20180123:155326.033 Got signal [signal:10(SIGBUS),reason:3,refaddr:0x803a1862d]. Crashing ...
23691:20180123:155326.033 ====== Fatal information: ======
23691:20180123:155326.033 program counter not available for this architecture
23691:20180123:155326.033 === Registers: ===
23691:20180123:155326.033 register dump not available for this architecture
23691:20180123:155326.033 === Backtrace: ===
23691:20180123:155326.034 3: 0x4a422b <zbx_log_fatal_info+0x9b> at /usr/local/sbin/zabbix_server
23691:20180123:155326.034 2: 0x4a464b <zbx_set_common_signal_handlers+0x29b> at /usr/local/sbin/zabbix_server
23691:20180123:155326.034 1: 0x804409b37 <pthread_sigmask+0x507> at /lib/libthr.so.3
23691:20180123:155326.034 0: 0x80440922c <pthread_getspecific+0xe1c> at /lib/libthr.so.3
23691:20180123:155326.034 === Memory map: ===
23691:20180123:155326.034 memory map not available for this platform
23691:20180123:155326.034 ================================
23673:20180123:155326.036 One child process died (PID:23691,exitcode/signal:1). Exiting ...
23673:20180123:155328.070 syncing history data...
23673:20180123:155346.591 slow query: 17.809583 sec, "update items set lastlogsize=12161303 where itemid=27792;
"
23673:20180123:155346.881 syncing history data... 99.846743%
23673:20180123:155346.915 syncing history data done
23673:20180123:155346.915 syncing trend data...
23673:20180123:155355.449 slow query: 7.631720 sec, "select distinct itemid from trends where clock>=1516708800 and (itemid between 23255 and 23260 or itemid between 23273 and 23277 or itemid between 23685 and 23689 or itemid between 23713 and 23720 or itemid between 23730 and 23738 or itemid between 24687 and 24691 or itemid between 24725 and 24729 or itemid between 24763 and 24767 or itemid between 28374 and 28379 or itemid between 29767 and 29771 or itemid between 29845 and 29854 or itemid in (23252,23253,23264,23265,23266,23268,23269,23270,2 3328,23620,23625,23628,23635,23681,23682,23683,236 93,23756,23820,23821,23823,23824,23854,23855,23856 ,23857,23860,23861,23862,23883,23884,23885,23886,2 3889,23890,23891,23941,23942,23943,23944,23947,239 48,23949,24020,24021,24090,24091,24169,24267,24268 ,24269,24270,24273,24274,24275,24293,24294,24295,2 4296,24299,24300,24301,24319,24320,24321,24322,243 25,24326,24327,24335,24336,24346,24347,24348,24361 ,24362,24470,24471,24472,24480,24481,24509,24510,2 4512,24513,24515,24516,24518,24519,24521,24522,245 24,24525,24530,24531,24533,24534,24536,24537,24539 ,24540,24542,24543,24545,24546,24548,24549,24551,2 4552,24554,24555,24557,24558,24563,24564,24566,245 67,24569,24570,24572,24573,24575,24576,24578,24579 ,24581,24582,24584,24585,24587,24588,24590,24591,2 4619,24620,24622,24623,24625,24626,24628,24629,246 83,24684,24685,24695,24721,24722,24723,24733,24759 ,24760,24761,24771,24868,24869,24870,24871,24874,2 4875,24876,24894,24895,24896,24897,24900,24901,249 02,24920,24921,24922,24923,24926,24927,24928,24948 ,24949,24953,24954,24955,24961,24969,24970,24974,2 4975,24976,24982,24990,24991,24995,24996,24997,250 03,25267,25309,25347,25501,25502,25503,25504,25507 ,25508,25509,25527,25528,25529,25530,25533,25534,2 5535,25595,25596,25608,25609,25610,25611,25614,256 15,25616,25634,25635,25636,25637,25640,25641,25642 ,25689,25690,25691,25692,25695,25696,25697,25715,2 5716,25717,25718,25721,25722,25723,25741,25742,257 43,25744,25747,25748,25749,25757,25758,25763,25764 ,25766,25767,25772,25773,25775,25776,25778,25779,2 5784,25785,25825,25826,25828,25829,25831,25832,258 94,25895,25897,25898,25900,25901,25903,25904,25906 ,25907,25909,25910,25912,25913,25960,25961,26027,2 6028,26029,26160,26161,26208,26209,26249,26253,262 63,26301,26481,26482,26484,26485,26487,26488,26493 ,26494,26496,26497,26499,26500,26502,26503,26505,2 6506,26511,26512,26514,26515,26517,26518,26520,265 21,26526,26527,26589,26590,26592,26593,26627,26628 ,26630,26631,26633,26634,26636,26637,26639,26640,2 6642,26643,26645,26646,26648,26649,26651,26652,266 54,26655,26657,26658,26660,26661,26663,26664,26666 ,26667,27132,27133,27135,27136,27221,27222,27233,2 7234,27236,27237,27242,27243,27254,27255,27260,272 61,27443,27444,27446,27447,27449,27450,27452,27453 ,27455,27456,27458,27459,27461,27462,27464,27465,2 7467,27468,27470,27471,27476,27477,27479,27480,274 82,27483,27485,27486,27488,27489,27491,27492,27528 ,27531,27551,27560,27563,27583,27592,27595,27615,2 7624,27627,27647,27786,27787,28508,28524,28542,285 43,28940,28941,29069,29070,29077,29078,29079,29080 ,29083,29084,29085,29139,29140,29151,29152,29153,2 9154,29157,29158,29159,29177,29178,29179,29180,291 83,29184,29185,29266,29267,29268,29318,29319,29320 ,29986,29987,29988,29989,29992,29993,29994,30072,3 0073,30126,30127,30128,30129,30132,30133,30134,301 52,30153,30154,30155,30158,30159,30160,30173,30215 ,30624,30627,30628,30889,30890,30892,30893,30895,3 0896,30898,30899,30901,30902,30904,30905,30907,309 08,30911,30914,30915,30917,30918,30920,30921,31273 ,31274,31276,31277,31373,31374,31376,31377,31379,3 1380,31572,31573,31574,31575,31578,31579,31580,316 75,31676,32481,32482,32483,32484,32487,32488,32489 ,32545,32859,32860,32862,32863,33081,33082,33220,3 3221,33222,33223,33226,33227,33228,33248,33249,332 50,33251,33254,33255,33256,33271,33272,33283,33284 ,34367,34368,34369,34370,34373,34374,34375,34415,3 4549,34550,34551,34552,34555,34556,34557,34605,347 67,34768,35201,35436,35437,35525,35526,35527,35528 ,35531,35532,35533,35579,35595,35596,35597,35598,3 5601,35602,35603,35643,35829,35830,35832,35833,361 97,36198,36296,36297,36363,36364,36366,36367,36702 ,36962,36963,37127,37128,37129,37130,37133,37134,3 7135,37143,37322,37323,37324,37325,37330,37331,373 32,37389,37539,37540,37541,37542,37547,37548,37549 ,37596,37977,37978,37979,37980,38069,38070,38303,3 8553,38559,38560,38567,38568,38569,38570,38575,385 76,38577,38595,38596,38597,38598,38603,38604,38605 ,38654,38658,38895,38896,39466,39467,39494,39495,3 9496,39497,39530,39531,39544,39562,39563,39564,395 65,39590,39591,39592,39593,39620,39778,39779,39826 ,39827,39860,39861,39862,39953,39966,39967,39968,3 9969,40115,40122,40123,40124,40125,40388,40389,403 90,40391,40396,40397,40398,40416,40417,40418,40419 ,40424,40425,40426,40477,40523,40570,40571,40572,4 0610,40615))"
23673:20180123:155358.847 syncing trend data done
23673:20180123:155358.847 cannot remove shared memory for self-monitoring collector: [22] Invalid argument
23673:20180123:155358.847 Zabbix Server stopped. Zabbix 3.4.6 (revision 76823).
Нигде не могу найти, как очистить эту память внутренних проверок!
Запуска сервера хватает где-то на 6 часов.
Столкнулся с проблемой, что zabbix server стал останавливаться сам по себе. Вот, что выдают логи.
23685:20180123:155315.418 slow query: 10.589799 sec, "select distinct itemid from trends_uint where clock>=1516683600 and (itemid between 27046 and 27065 or itemid between 27070 and 27078 or itemid between 27080 and 27089 or itemid between 27596 and 27600 or itemid between 27603 and 27614 or itemid between 27616 and 27623 or itemid between 27628 and 27632 or itemid between 27635 and 27646 or itemid between 27648 and 27655 or itemid in (23726,23727,23728,23965,23966,23967,23968,24026,2 4027,24028,24086,24087,24088,24089,24146,24147,241 48,24328,24386,24387,24388,24446,24447,24448,24686 ,24866,24929,24986,24987,24988,25346,25349,25646,2 5647,25949,26005,26006,26007,26008,26126,26127,261 28,26186,26187,26246,26247,26248,26306,26307,26308 ,26309,26366,26367,26368,26369,27067,27068,27091,2 7092,27093,27094,27324,27325,27326,27327,27593,275 94,27625,27626,27926,27927,27928,28106,28108,28226 ,28346,28347,28348,28526,28527,28528,29126,29127,2 9128,29186,29246,29247,29248,29306,29307,29308,293 09,29786,29787,29788,30147,30206,30207,30208,30209 ,30386,30387,30388,30389,31646,31647,31648,32486,3 2547,33266,33268,33269,33567,33568,34406,34407,344 08,34409,34586,34587,34588,35546,35547,35548,35607 ,35608,36206,36207,36208,36209,36626,36627,36628,3 6629,36808,37166,37167,37168,37169,37346,37347,373 48,37349,37586,37587,37588,37589,37767,37768,37946 ,38066,38067,38068,38246,38247,38248,38546,38547,3 8548,38549,38606,38609,38666,38667,38668,38669,387 86,38788,38847,38848,38849,39146,39147,39148,39149 ,39207,39208,39209,39266,39267,39268,39326,39327,3 9446,39447,39448,39506,39507,39508,39569,39628,396 29,39806,39807,39808,40408,40466,40467,40468,40469 ))"
23682:20180123:155317.871 slow query: 11.230671 sec, "select distinct itemid from trends_uint where clock>=1516683600 and (itemid between 27171 and 27213 or itemid between 27215 and 27219 or itemid in (23975,24035,24036,24155,24395,24456,24520,24523,2 4755,24935,25235,25296,25765,25955,26015,26195,262 55,26315,26316,26375,26498,26501,26675,26970,27274 ,27301,27703,27815,28115,28176,28535,29135,29195,2 9255,29315,29435,29436,29795,30035,30635,31378,316 55,32496,33275,33276,34595,35555,35615,35828,36961 ,37175,37355,37356,37595,38615,38675,38736,38795,3 9155,39275,39276,39335,39395,39455,39515,39575,395 76,39635,39815,39875))"
23691:20180123:155326.033 Got signal [signal:10(SIGBUS),reason:3,refaddr:0x803a1862d]. Crashing ...
23691:20180123:155326.033 ====== Fatal information: ======
23691:20180123:155326.033 program counter not available for this architecture
23691:20180123:155326.033 === Registers: ===
23691:20180123:155326.033 register dump not available for this architecture
23691:20180123:155326.033 === Backtrace: ===
23691:20180123:155326.034 3: 0x4a422b <zbx_log_fatal_info+0x9b> at /usr/local/sbin/zabbix_server
23691:20180123:155326.034 2: 0x4a464b <zbx_set_common_signal_handlers+0x29b> at /usr/local/sbin/zabbix_server
23691:20180123:155326.034 1: 0x804409b37 <pthread_sigmask+0x507> at /lib/libthr.so.3
23691:20180123:155326.034 0: 0x80440922c <pthread_getspecific+0xe1c> at /lib/libthr.so.3
23691:20180123:155326.034 === Memory map: ===
23691:20180123:155326.034 memory map not available for this platform
23691:20180123:155326.034 ================================
23673:20180123:155326.036 One child process died (PID:23691,exitcode/signal:1). Exiting ...
23673:20180123:155328.070 syncing history data...
23673:20180123:155346.591 slow query: 17.809583 sec, "update items set lastlogsize=12161303 where itemid=27792;
"
23673:20180123:155346.881 syncing history data... 99.846743%
23673:20180123:155346.915 syncing history data done
23673:20180123:155346.915 syncing trend data...
23673:20180123:155355.449 slow query: 7.631720 sec, "select distinct itemid from trends where clock>=1516708800 and (itemid between 23255 and 23260 or itemid between 23273 and 23277 or itemid between 23685 and 23689 or itemid between 23713 and 23720 or itemid between 23730 and 23738 or itemid between 24687 and 24691 or itemid between 24725 and 24729 or itemid between 24763 and 24767 or itemid between 28374 and 28379 or itemid between 29767 and 29771 or itemid between 29845 and 29854 or itemid in (23252,23253,23264,23265,23266,23268,23269,23270,2 3328,23620,23625,23628,23635,23681,23682,23683,236 93,23756,23820,23821,23823,23824,23854,23855,23856 ,23857,23860,23861,23862,23883,23884,23885,23886,2 3889,23890,23891,23941,23942,23943,23944,23947,239 48,23949,24020,24021,24090,24091,24169,24267,24268 ,24269,24270,24273,24274,24275,24293,24294,24295,2 4296,24299,24300,24301,24319,24320,24321,24322,243 25,24326,24327,24335,24336,24346,24347,24348,24361 ,24362,24470,24471,24472,24480,24481,24509,24510,2 4512,24513,24515,24516,24518,24519,24521,24522,245 24,24525,24530,24531,24533,24534,24536,24537,24539 ,24540,24542,24543,24545,24546,24548,24549,24551,2 4552,24554,24555,24557,24558,24563,24564,24566,245 67,24569,24570,24572,24573,24575,24576,24578,24579 ,24581,24582,24584,24585,24587,24588,24590,24591,2 4619,24620,24622,24623,24625,24626,24628,24629,246 83,24684,24685,24695,24721,24722,24723,24733,24759 ,24760,24761,24771,24868,24869,24870,24871,24874,2 4875,24876,24894,24895,24896,24897,24900,24901,249 02,24920,24921,24922,24923,24926,24927,24928,24948 ,24949,24953,24954,24955,24961,24969,24970,24974,2 4975,24976,24982,24990,24991,24995,24996,24997,250 03,25267,25309,25347,25501,25502,25503,25504,25507 ,25508,25509,25527,25528,25529,25530,25533,25534,2 5535,25595,25596,25608,25609,25610,25611,25614,256 15,25616,25634,25635,25636,25637,25640,25641,25642 ,25689,25690,25691,25692,25695,25696,25697,25715,2 5716,25717,25718,25721,25722,25723,25741,25742,257 43,25744,25747,25748,25749,25757,25758,25763,25764 ,25766,25767,25772,25773,25775,25776,25778,25779,2 5784,25785,25825,25826,25828,25829,25831,25832,258 94,25895,25897,25898,25900,25901,25903,25904,25906 ,25907,25909,25910,25912,25913,25960,25961,26027,2 6028,26029,26160,26161,26208,26209,26249,26253,262 63,26301,26481,26482,26484,26485,26487,26488,26493 ,26494,26496,26497,26499,26500,26502,26503,26505,2 6506,26511,26512,26514,26515,26517,26518,26520,265 21,26526,26527,26589,26590,26592,26593,26627,26628 ,26630,26631,26633,26634,26636,26637,26639,26640,2 6642,26643,26645,26646,26648,26649,26651,26652,266 54,26655,26657,26658,26660,26661,26663,26664,26666 ,26667,27132,27133,27135,27136,27221,27222,27233,2 7234,27236,27237,27242,27243,27254,27255,27260,272 61,27443,27444,27446,27447,27449,27450,27452,27453 ,27455,27456,27458,27459,27461,27462,27464,27465,2 7467,27468,27470,27471,27476,27477,27479,27480,274 82,27483,27485,27486,27488,27489,27491,27492,27528 ,27531,27551,27560,27563,27583,27592,27595,27615,2 7624,27627,27647,27786,27787,28508,28524,28542,285 43,28940,28941,29069,29070,29077,29078,29079,29080 ,29083,29084,29085,29139,29140,29151,29152,29153,2 9154,29157,29158,29159,29177,29178,29179,29180,291 83,29184,29185,29266,29267,29268,29318,29319,29320 ,29986,29987,29988,29989,29992,29993,29994,30072,3 0073,30126,30127,30128,30129,30132,30133,30134,301 52,30153,30154,30155,30158,30159,30160,30173,30215 ,30624,30627,30628,30889,30890,30892,30893,30895,3 0896,30898,30899,30901,30902,30904,30905,30907,309 08,30911,30914,30915,30917,30918,30920,30921,31273 ,31274,31276,31277,31373,31374,31376,31377,31379,3 1380,31572,31573,31574,31575,31578,31579,31580,316 75,31676,32481,32482,32483,32484,32487,32488,32489 ,32545,32859,32860,32862,32863,33081,33082,33220,3 3221,33222,33223,33226,33227,33228,33248,33249,332 50,33251,33254,33255,33256,33271,33272,33283,33284 ,34367,34368,34369,34370,34373,34374,34375,34415,3 4549,34550,34551,34552,34555,34556,34557,34605,347 67,34768,35201,35436,35437,35525,35526,35527,35528 ,35531,35532,35533,35579,35595,35596,35597,35598,3 5601,35602,35603,35643,35829,35830,35832,35833,361 97,36198,36296,36297,36363,36364,36366,36367,36702 ,36962,36963,37127,37128,37129,37130,37133,37134,3 7135,37143,37322,37323,37324,37325,37330,37331,373 32,37389,37539,37540,37541,37542,37547,37548,37549 ,37596,37977,37978,37979,37980,38069,38070,38303,3 8553,38559,38560,38567,38568,38569,38570,38575,385 76,38577,38595,38596,38597,38598,38603,38604,38605 ,38654,38658,38895,38896,39466,39467,39494,39495,3 9496,39497,39530,39531,39544,39562,39563,39564,395 65,39590,39591,39592,39593,39620,39778,39779,39826 ,39827,39860,39861,39862,39953,39966,39967,39968,3 9969,40115,40122,40123,40124,40125,40388,40389,403 90,40391,40396,40397,40398,40416,40417,40418,40419 ,40424,40425,40426,40477,40523,40570,40571,40572,4 0610,40615))"
23673:20180123:155358.847 syncing trend data done
23673:20180123:155358.847 cannot remove shared memory for self-monitoring collector: [22] Invalid argument
23673:20180123:155358.847 Zabbix Server stopped. Zabbix 3.4.6 (revision 76823).
Нигде не могу найти, как очистить эту память внутренних проверок!
Запуска сервера хватает где-то на 6 часов.