Page 1 of 1

nagios core + nagiosql

Posted: Tue May 02, 2017 8:40 am
by mirgo
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

Re: nagios core + nagiosql

Posted: Tue May 02, 2017 9:32 am
by tmcdonald
You'll need to ask this over on the NagiosQL forums, as we did not write and do not maintain or support their software.

Re: nagios core + nagiosql

Posted: Tue May 02, 2017 12:38 pm
by rhassing
You could delete the table and import the data from either a backup or a config files that is working.

Re: nagios core + nagiosql

Posted: Tue May 02, 2017 1:48 pm
by dwhitfield
Thanks @rhassing!

OP, did that resolve your issue?

Re: nagios core + nagiosql

Posted: Wed May 03, 2017 1:35 am
by mirgo
I deleted the key and this did the trick, you can close the thread.