getting same… any ideas anyone ?

@kmaguey,

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!

It worked! There is a bit of an error within the answer but overall the answer is correct! Thank you very much indeed @digitronicguru for your help!

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;