A utility to verify/correct internal zabbix database referential integrity. I think I know how it happened, but I have been unable to correct the problem. I get a series of messages in the log:
If there was a utility that scanned the database to ensure the basic relationships were intact, and then report/correct any that were incomplete, this would help to make the product a little more robust.
For example, making sure that all hosts/items/triggers/templates/alerts were complete, reporting any orphans (shouldn't be any), and fixing or making any recommendation on how to fix would be very helpful. The database schema is not that large or complex that this would be difficult to implement. It would also go a long way to documenting the schema that many have asked about here in the forums.
Code:
23873:20080305:155414 Expression [{30870}=0] cannot be evaluated [Unable to get value for functionid [30870]]
23873:20080305:155414 Expression [({30525}<1)&({30524}<1)] cannot be evaluated [Unable to get value for functionid [30525]]
23873:20080305:155622 Expression [{30862}=0] cannot be evaluated [Unable to get value for functionid [30862]]
23873:20080305:155653 Expression [{30860}=0] cannot be evaluated [Unable to get value for functionid [30860]]
For example, making sure that all hosts/items/triggers/templates/alerts were complete, reporting any orphans (shouldn't be any), and fixing or making any recommendation on how to fix would be very helpful. The database schema is not that large or complex that this would be difficult to implement. It would also go a long way to documenting the schema that many have asked about here in the forums.
Comment