nagios core + nagiosql
Posted: Tue May 02, 2017 8:40 am
Hello
this is more of a nagiosql problem, but maybe someone can help. There was a problem with nagios server (ubuntu) running out of inodes. And this seems to have corrupted the database in way that if i change-save a specific servicegroup, i get an error: Error while inserting the data into the database :Duplicate entry 'some key nr for key 'PRIMARY'. I found that the key resides in table tbl_lnkServicegroupToService. Changing this servicegroup makes nagiosql makes to generate some error on service that is connected to that servicegroup. Fixing that temporary error resolves the problem. But same thing happends next time i try to change that servicegroup.
Can i delete that entry from database?
Thank you.
Mirgo
this is more of a nagiosql problem, but maybe someone can help. There was a problem with nagios server (ubuntu) running out of inodes. And this seems to have corrupted the database in way that if i change-save a specific servicegroup, i get an error: Error while inserting the data into the database :Duplicate entry 'some key nr for key 'PRIMARY'. I found that the key resides in table tbl_lnkServicegroupToService. Changing this servicegroup makes nagiosql makes to generate some error on service that is connected to that servicegroup. Fixing that temporary error resolves the problem. But same thing happends next time i try to change that servicegroup.
Can i delete that entry from database?
Thank you.
Mirgo