Hello,
I'm trying to update my pre-production centreon from 23.10 to 24.10. I followed this documentation: https://docs.centreon.com/fr/docs/upgrade/upgrade-from-23-10/
I'm stuck at step: https://docs.centreon.com/fr/docs/upgrade/upgrade-from-23-10/#finalisation-de-la-mise-%C3%A0-jour
On the upgrade web interface at step “24.10.2 to 24.10.3”, I get the error “UPGRADE - 24.10.3: Unable to insert data into table topology”.
in logs sql-error.log I have :
[2025-03-06T15:38:53+01:00] ERROR : [CentreonDb] Error while executing the prepared query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '92' for key 'PRIMARY' | {"context":{"default":{"back_trace":{"file":"/usr/share/centreon/www/class/centreonDB.class.php","line":933,"class":null,"function":null},"request_infos":{"url":"/centreon/install/step_upgrade/process/process_step4.php","http_method":"POST","server":"centreon-preprod.eolas-services.com","referrer":"https://centreon-preprod.eolas-services.com/centreon/install/upgrade.php"}},"exception":{"exception_type":"PDOException","file":"/usr/share/centreon/www/class/centreonDB.class.php","line":260,"code":"23000","message":"SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '92' for key 'PRIMARY'","previous":null},"custom":{"db_name":"centreon","query":"INSERT INTO `topology` (`topology_id`, `topology_name`, `topology_parent`, `topology_page`, `topology_order`, `topology_group`, `topology_url`, `topology_show`, `is_react`)\nVALUES (92,'Agent configurations',609,60905,50,1,'/configuration/pollers/agent-configurations', :show, '1');","pdo_error_infos":["23000",1062,"Duplicate entry '92' for key 'PRIMARY'"],"pdo_error_code":"23000","bind_params":{":show":"1"}}}}There's already an entry with ID 92 in my topology table, I don't know if it's dangerous to delete it? have you ever had this type of error?
Ragards,