Skip to main content

I have upgraded/Migrated from 21.10.x to 23.10.13 and followed the steps in https://docs.centreon.com/docs/migrate/migrate-from-el-to-el/. But after completing all the steps the Poller is not running and showing database issue. 

I have verified the password in /etc/centreon-broker/central-broker.json is correct.

 

# cat /var/log/centreon-broker/central-broker-master.log  | grep 'error'
<2023-12-11T09:06:13.259-05:00] 5tcp] [error] Error while reading on socket from 127.0.0.1: Operation canceled
<2023-12-11T09:06:15.876-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.876-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.877-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.877-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.878-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.878-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.878-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.879-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.879-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.880-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.880-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.881-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.882-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.882-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.883-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.883-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.883-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.883-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.884-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.884-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.885-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.885-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.885-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.887-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.887-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.888-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.888-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.889-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.889-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.890-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.890-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.891-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.892-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.892-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.893-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.893-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.894-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.894-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.895-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.895-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.895-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.895-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.896-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.897-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.897-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.898-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.899-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.899-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.899-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.900-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.900-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.900-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.901-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.901-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.902-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.903-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.903-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.903-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.904-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.904-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.904-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.905-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.905-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.906-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.906-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.907-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.907-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.908-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.908-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.908-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.909-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.909-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.909-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.910-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.910-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.911-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.911-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.911-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.912-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.912-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.913-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.913-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.913-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.914-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.914-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.914-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.915-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.915-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.916-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.916-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.916-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.916-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.916-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.917-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.917-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.918-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.918-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.919-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.919-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.919-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.919-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.920-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.920-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.921-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.921-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.922-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.922-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.922-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.922-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.923-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.923-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.924-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.924-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.925-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.925-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.925-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.925-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.926-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.926-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.927-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.927-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.927-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.928-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.928-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.928-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.929-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.929-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.929-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.930-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.930-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.930-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.931-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.931-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.932-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.932-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.932-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.932-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.933-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.933-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.934-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.934-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.934-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.935-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.935-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.935-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.936-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.936-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.937-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.937-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.938-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.938-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.939-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.939-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.939-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.940-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.940-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.940-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.941-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.941-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.941-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.942-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.942-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.943-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.943-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.943-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.943-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.944-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.944-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.944-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.945-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.945-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.945-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.946-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.946-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.946-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.947-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.947-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.948-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.948-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:15.949-05:00] 5sql] [error] unified_sql: the 'metrics' table contains rows with metric_id <= 0 ; you should remove them.
<2023-12-11T09:06:16.486-05:00] 5sql] [error] SQL: service group 2 does not exist - insertion before insertion of members
<2023-12-11T09:06:16.486-05:00] 5sql] [error] SQL: service group 1 does not exist - insertion before insertion of members
<2023-12-11T09:08:51.699-05:00] 5tcp] [error] TCP: Connection refused to localhost:5670
<2023-12-11T09:08:51.699-05:00] 5core] cerror] failover: global error: failover: 'centreon-broker-master-rrd' cannot connect endpoint.
<2023-12-11T09:08:56.330-05:00] 5core] cinfo] pool: the latency check encountered an error: Operation canceled
<2023-12-11T09:08:57.332-05:00] 5tcp] [error] TCP: Connection refused to localhost:5670
<2023-12-11T09:08:57.332-05:00] 5core] cerror] failover: global error: failover: 'centreon-broker-master-rrd' cannot connect endpoint.
<2023-12-11T09:08:57.332-05:00] 5tcp] [error] TCP: Connection refused to localhost:5670
<2023-12-11T09:08:57.332-05:00] 5core] cerror] failover: global error: failover: 'centreon-broker-master-rrd' cannot connect endpoint.
<2023-12-11T09:11:37.617-05:00] 5core] cinfo] pool: the latency check encountered an error: Operation canceled
<2023-12-11T09:42:35.429-05:00] 5core] cinfo] pool: the latency check encountered an error: Operation canceled
<2023-12-11T14:20:55.055-05:00] 5core] cinfo] pool: the latency check encountered an error: Operation canceled
<2023-12-11T14:20:58.558-05:00] 5tcp] [error] TCP: Connection refused to localhost:5670
<2023-12-11T14:20:58.558-05:00] 5core] cerror] failover: global error: failover: 'centreon-broker-master-rrd' cannot connect endpoint.
<2023-12-11T14:20:58.558-05:00] 5tcp] [error] TCP: Connection refused to localhost:5670
<2023-12-11T14:20:58.558-05:00] 5core] cerror] failover: global error: failover: 'centreon-broker-master-rrd' cannot connect endpoint.
<2023-12-11T14:21:30.679-05:00] 5tcp] [error] TCP: Connection refused to localhost:5670
<2023-12-11T14:21:30.679-05:00] 5core] cerror] failover: global error: failover: 'centreon-broker-master-rrd' cannot connect endpoint.
<2023-12-11T14:21:33.812-05:00] 5core] cinfo] pool: the latency check encountered an error: Operation canceled
 

Hi @muhammed.suhile did you upgrade to Centreon Web 23.10.3 with MariaDB 10.5?

Do you have a backup of your platform before the upgrade?

It's strange to have negative metric_id, o you have errors in /var/log/centreon/sql-error.log or /var/log/centreon/update.log?


Reply