Hello community, I am new in centreon so quickly get stack at version upgrade from 20.04 to 21.10My error is: Database updates not active, pollers not running, last update in yellow:Somehow I found as well in the logs that the connection to SQL is failed:2022-05-02 11:49:13|0|0|0|[local] [127.0.0.1] Authentication failed for 'admin' I have a little idea about forcing the connection to sql but the centreon user is “centreon” normally for database.Please help as my research was unsuccessfully. Regards,Eugene

Database updates not active, pollers not running, get stack

Hello @Jenellu,

You can try to follow these step :

Don't hesitate to come back to this thread if these steps didn't work.

Regards.

Hello itoussies,

Thank you for fast reply,

I sow it already didn’t help.

Regards,

Do you have any recent errors in /var/log/centreon-broker/central-broker-master.log ?

Yes, please:

>2022-05-02T14:46:29.233+02:00] sql] error] mysql_connection: could not store logs correctly: Table 'centreon_storage.logs' doesn't exist
/2022-05-02T14:46:29.239+02:00] ]sql] ]error] conflict_manager: error in the main loop: could not store logs correctly: Table 'centreon_storage.logs' doesn't exist
2022-05-02T14:46:29.264+02:00] 0sql] lerror] mysql_connection: could not store logs correctly: Table 'centreon_storage.logs' doesn't exist
r2022-05-02T14:46:29.264+02:00] 0sql] qerror] conflict_manager: error while checking deleted indexes: could not query index table to get index to delete: could not store logs correctly: Table 'centreon_storage.logs' doesn't exist
b2022-05-02T14:46:29.264+02:00] :core] oerror] failover: global error: conflict_manager: events loop interrupted
b2022-05-02T14:46:29.264+02:00] :core] oinfo] storage stream stopped with 0 acknowledged events
b2022-05-02T14:46:30.026+02:00] :core] oerror] failover: global error: conflict_manager: events loop interrupted
b2022-05-02T14:46:30.030+02:00] :core] oinfo] sql stream stopped with 0 ackowledged events
b2022-05-02T14:47:29.270+02:00] :sql] serror] storage stream instanciation failed
b2022-05-02T14:47:29.271+02:00] :core] oerror] failover: global error: storage: Unable to initialize the storage connection to the database

Weird

Let’s see what table are currently present :

mysql -u centreon -p centreon -e "SHOW TABLES"
mysql -u centreon -p centreon_storage -e "SHOW TABLES"

If you are using a Remote DBMS :

mysql -u centreon -p centreon -h < IP of your Remote DBMS > -e "SHOW TABLES"
...

Please here:

and

First time I’ve heard of the deletion of centreon_storage.logs (and I’ve done a lot of upgrade to the 21.10 version)

Well, let’s recreate that table :

CREATE TABLE centreon_storage.`logs` (
  `log_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `ctime` int(11) DEFAULT NULL,
  `host_id` int(11) DEFAULT NULL,
  `host_name` varchar(255) DEFAULT NULL,
  `instance_name` varchar(255) NOT NULL,
  `issue_id` int(11) DEFAULT NULL,
  `msg_type` tinyint(4) DEFAULT NULL,
  `notification_cmd` varchar(255) DEFAULT NULL,
  `notification_contact` varchar(255) DEFAULT NULL,
  `output` text DEFAULT NULL,
  `retry` int(11) DEFAULT NULL,
  `service_description` varchar(255) DEFAULT NULL,
  `service_id` int(11) DEFAULT NULL,
  `status` tinyint(4) DEFAULT NULL,
  `type` smallint(6) DEFAULT NULL,
  KEY `log_id` (`log_id`),
  KEY `host_name` (`host_name`(64)),
  KEY `service_description` (`service_description`(64)),
  KEY `status` (`status`),
  KEY `instance_name` (`instance_name`),
  KEY `ctime` (`ctime`),
  KEY `rq1` (`host_id`,`service_id`,`msg_type`,`status`,`ctime`),
  KEY `rq2` (`host_id`,`msg_type`,`status`,`ctime`)
) ENGINE=InnoDB AUTO_INCREMENT=57759 DEFAULT CHARSET=utf8

Then, let’s manually execute the database partioning :

/usr/bin/php /usr/share/centreon/cron/centreon-partitioning.php -m logs

Finally, restart the cbd service.

Before everything, can you execute the follwowing command :

df -h
ll /var/lib/mysql/centreon_storage/data_bin*
ll /var/lib/mysql/centreon_storage/logs*
ll /var/lib/mysql/centreon_storage/log_archive*

Let’s see by tomorrow. Finished my day.

thanks

Hello Community,

I have the same error (see capture below) and the topic didn’t help.

Here are the errors I have in /var/log/centreon-broker/central-broker-master.log

s2022-07-11T10:12:41.463+02:00] 0perfdata] terror] storage: invalid perfdata format in service (47:3372): no numeric value after equal sign 'valeur'=;'

r2022-07-11T10:12:41.493+02:00] 0sql] qerror] mysql_connection: could not insert data in data_bin:  Table 'centreon_storage.data_bin' doesn't exist

It seems that the table centreon_storage.data_bin does not exist.

Could you guide me to resolve the error and restore normal operation to centreon?

Thanks in advance.

Hello @itoussies

I have the same problem as @Intence-Tech , could you help us please ?

Thanks in advance

Hello,

If the table does not exist, you can create it with the following statement

CREATE TABLE `data_bin` (
  `id_metric` int(11) DEFAULT NULL,
  `ctime` int(11) DEFAULT NULL,
  `value` float DEFAULT NULL,
  `status` enum('0','1','2','3','4') DEFAULT NULL,
  KEY `index_metric` (`id_metric`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;

Hello,

If the table does not exist, you can create it with the following statement

CREATE TABLE `data_bin` (
  `id_metric` int(11) DEFAULT NULL,
  `ctime` int(11) DEFAULT NULL,
  `value` float DEFAULT NULL,
  `status` enum('0','1','2','3','4') DEFAULT NULL,
  KEY `index_metric` (`id_metric`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;

thanks , i had this issue yesterday.

it seems this part must also be done :https://docs.centreon.com/fr/docs/administration/database-partitioning/#migration-des-tables-non-partitionn%C3%A9es so that the partitioning script can do his job by cron every day

Reply

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded