Всем доброго дня!
проблема возникла после обновления до 7.2 на графиках линия прерывается не могу найти причину и иногда выходит сообщение Zabbix сервер не запущен. Отображаемая информация может быть не актуальной
s@zabbixtnspluskz:/etc/zabbix$ sudo tail -f /var/log/zabbix/zabbix_server.log
[sudo] password for tnsplus:
1244114:20241225:090239.662 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: update or delete on table "items" violates foreign key constraint "c_graphs_3" on table "graphs"
DETAIL: Key (itemid)=(176645) is still referenced from table "graphs".
[delete from items where itemid in (176612,176613,176614,176615,176616,176617,176618, 176619,176620,176639,176640,176641,176642,176643,1 76644,176645,176646,176647);
]
1244113:20241225:090316.974 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: update or delete on table "items" violates foreign key constraint "c_graphs_3" on table "graphs"
DETAIL: Key (itemid)=(175868) is still referenced from table "graphs".
[delete from items where itemid in (76839,76932,77025,77118,77211,77304,77397,77490,7 7583,136875,136876,136877,136882,136884,136889,136 891,136894,136896,136967,137014,137015,137016,1370 21,137023,137028,137030,137033,137035,137106,13715 3,137154,137155,137160,137162,137167,137169,137172 ,137174,137245,137292,137293,137294,137299,137301, 137306,137308,137311,137313,137384,137431,137432,1 37433,137438,137440,137445,137447,137450,137452,13 7523,137570,137571,137572,137577,137579,137584,137 586,137589,137591,137662,137709,137710,137711,1377 16,137718,137723,137725,137728,137730,137801,13784 8,137849,137850,137855,137857,137862,137864,137867 ,137869,137940,137987,137988,137989,137994,137996, 138001,138003,138006,138008,138079,138991,139030,1 39069,139108,139147,139186,139225,139264,139303,14 8589,148590,148591,148592,148593,148594,148595,148 596,148597,175706,175708,175709,175710,175712,1757 13,175714,175716,175717,175718,175720,175721,17572 2,175724,175725,175726,175728,175729,175730,175732 ,175733,175734,175736,175737,175738,175740,175741, 175862,175863,175864,175865,175866,175867,175868,1 75869,175870,183146,183148,183150,183152,183154,18 3156,183158,183160,183162,184308,184309,184310,184 311,184312,184313,184314,184315,184316,211138,2111 39,211140,211141,211142,211143,211144,211145,21114 6,212849,212850,212851,212852,212853,212854,212855 ,212856,212857,212858,212859,212860,212861,212862, 212863,212864,212865,212866,212867,212868,212869,2 12870,212871,212872,212873,212874,212875);
]
MIB search path: $HOME/.snmp/mibs:/usr/share/snmp/mibs:/usr/share/snmp/mibs/iana:/usr/share/snmp/mibs/ietf
Cannot find module (IF-MIB): At line 1 in (none)
проблема возникла после обновления до 7.2 на графиках линия прерывается не могу найти причину и иногда выходит сообщение Zabbix сервер не запущен. Отображаемая информация может быть не актуальной
s@zabbixtnspluskz:/etc/zabbix$ sudo tail -f /var/log/zabbix/zabbix_server.log
[sudo] password for tnsplus:
1244114:20241225:090239.662 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: update or delete on table "items" violates foreign key constraint "c_graphs_3" on table "graphs"
DETAIL: Key (itemid)=(176645) is still referenced from table "graphs".
[delete from items where itemid in (176612,176613,176614,176615,176616,176617,176618, 176619,176620,176639,176640,176641,176642,176643,1 76644,176645,176646,176647);
]
1244113:20241225:090316.974 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: update or delete on table "items" violates foreign key constraint "c_graphs_3" on table "graphs"
DETAIL: Key (itemid)=(175868) is still referenced from table "graphs".
[delete from items where itemid in (76839,76932,77025,77118,77211,77304,77397,77490,7 7583,136875,136876,136877,136882,136884,136889,136 891,136894,136896,136967,137014,137015,137016,1370 21,137023,137028,137030,137033,137035,137106,13715 3,137154,137155,137160,137162,137167,137169,137172 ,137174,137245,137292,137293,137294,137299,137301, 137306,137308,137311,137313,137384,137431,137432,1 37433,137438,137440,137445,137447,137450,137452,13 7523,137570,137571,137572,137577,137579,137584,137 586,137589,137591,137662,137709,137710,137711,1377 16,137718,137723,137725,137728,137730,137801,13784 8,137849,137850,137855,137857,137862,137864,137867 ,137869,137940,137987,137988,137989,137994,137996, 138001,138003,138006,138008,138079,138991,139030,1 39069,139108,139147,139186,139225,139264,139303,14 8589,148590,148591,148592,148593,148594,148595,148 596,148597,175706,175708,175709,175710,175712,1757 13,175714,175716,175717,175718,175720,175721,17572 2,175724,175725,175726,175728,175729,175730,175732 ,175733,175734,175736,175737,175738,175740,175741, 175862,175863,175864,175865,175866,175867,175868,1 75869,175870,183146,183148,183150,183152,183154,18 3156,183158,183160,183162,184308,184309,184310,184 311,184312,184313,184314,184315,184316,211138,2111 39,211140,211141,211142,211143,211144,211145,21114 6,212849,212850,212851,212852,212853,212854,212855 ,212856,212857,212858,212859,212860,212861,212862, 212863,212864,212865,212866,212867,212868,212869,2 12870,212871,212872,212873,212874,212875);
]
MIB search path: $HOME/.snmp/mibs:/usr/share/snmp/mibs:/usr/share/snmp/mibs/iana:/usr/share/snmp/mibs/ietf
Cannot find module (IF-MIB): At line 1 in (none)
Attached Files
Comment