Hello everyone!
My Centreon upgrade failed during the upgrading process, does anyone have any idea about the issue? Would you please help me to solve it? Thank you in advance.
Best answer by digitronicguru
View original
+3
getting same… any ideas anyone ?
+3
I was getting the EXACT error “impossible to alter metrics table”
I found this in the centreon documentation:
https://docs.centreon.com/docs/resources/known-issues/
what worked for me was this: (i have default centreon install, single node)
ALTER TABLE centreon_storage index_data MODIFY id bigint unsigned AUTO_INCREMENT;
ALTER TABLE centreon_storage metrics MODIFY index_id bigint unsigned;
ALTER TABLE centreon.ods_view_details MODIFY index_id bigint unsigned;
ALTER TABLE centreon.virtual_metrics MODIFY index_id bigint unsigned;
then restarted the server, once server came back up, for whatever reason always have to restart the cbd service manually, i just use this command:
systemctl restart cbd centengine centreontrapd gorgoned
Hope this helps someone!
+1
It worked! There is a bit of an error within the answer but overall the answer is correct! Thank you very much indeed
The corrected answer would be:
ALTER TABLE centreon_storage.index_data MODIFY id bigint unsigned AUTO_INCREMENT;
ALTER TABLE centreon_storage.metrics MODIFY index_id bigint unsigned;ALTER TABLE centreon.ods_view_details MODIFY index_id bigint unsigned;
ALTER TABLE centreon.virtual_metrics MODIFY index_id bigint unsigned;
Reply
Login to the community
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.