Hi!
My team is trying to understand some of the difficulties we've experienced and have been trying to prevent spurious emails (escalations) from coming and inundating us when something has gone wrong with Zabbix or our database. We don't understand how the schema really works.
For example, if we knew what values can be assigned in the STATUS field in the ALERTS table, could we prevent email from spamming us?
For the same reason, if we knew what values can be assigned in the STATUS field in the ESCALATIONS table, could we immediately mark a bunch of escalations as completed or something and would that prevent email from spamming us, or would it just be easier to truncate that table?
What happens when you truncate the ESCALATIONS table if there is data in it? Will it repopulate the table when the server is restarted?
I have looked, and perhaps I am just looking in all the wrong places, but I can't find any explanations or descriptions anywhere that help me to understand these things. I'm not able to peruse the code and find out what all of these things mean, so it would be really helpful if we could get explanations of these things so we could quickly change them at the database level to stop a deluge of email.
It would potentially be useful to know all of these things—even more so if we could know the tables we should not alter or mess with, or which are safe to do with Zabbix server running or which should be done with it offline.
My team is trying to understand some of the difficulties we've experienced and have been trying to prevent spurious emails (escalations) from coming and inundating us when something has gone wrong with Zabbix or our database. We don't understand how the schema really works.
For example, if we knew what values can be assigned in the STATUS field in the ALERTS table, could we prevent email from spamming us?
For the same reason, if we knew what values can be assigned in the STATUS field in the ESCALATIONS table, could we immediately mark a bunch of escalations as completed or something and would that prevent email from spamming us, or would it just be easier to truncate that table?
What happens when you truncate the ESCALATIONS table if there is data in it? Will it repopulate the table when the server is restarted?
I have looked, and perhaps I am just looking in all the wrong places, but I can't find any explanations or descriptions anywhere that help me to understand these things. I'm not able to peruse the code and find out what all of these things mean, so it would be really helpful if we could get explanations of these things so we could quickly change them at the database level to stop a deluge of email.
It would potentially be useful to know all of these things—even more so if we could know the tables we should not alter or mess with, or which are safe to do with Zabbix server running or which should be done with it offline.
Comment