Database history tablesupgraded
- zabbix升级到6之后，配置安装完成会有一个红色输出，但是不影响zabbix使用，出于强迫症，找到了该问题的解决方法。
Database history tables upgraded: No. Support for the old numeric type
is deprecated. Please upgrade to numeric values of extended range
- 停止zabbix-server zabbix-agent nginx php-fpm相关服务，登录MySQL
[root@zabbix conf]# systemctl stop zabbix-server zabbix-agent nginx php-fpm
[root@220-230 ~]# mysql -uroot -p #登录MySQL
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 830
Server version: 8.0.31 MySQL Community Server - GPLCopyright (c) 2000, 2022, Oracle and/or its affiliates.Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql> use zabbix
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -ADatabase changed
mysql> source /root/double.sql #该文件在zabbix-server服务器下的/usr/share/zabbix-sql-scripts/目录下
Query OK, 0 rows affected (0.02 sec)
Records: 0 Duplicates: 0 Warnings: 0Query OK, 0 rows affected (0.01 sec)
Records: 0 Duplicates: 0 Warnings: 0mysql> ALTER TABLE trends-> MODIFY value_min DOUBLE PRECISION DEFAULT '0.0000' NOT NULL,-> MODIFY value_avg DOUBLE PRECISION DEFAULT '0.0000' NOT NULL,-> MODIFY value_max DOUBLE PRECISION DEFAULT '0.0000' NOT NULL;
Query OK, 0 rows affected (0.01 sec)
Records: 0 Duplicates: 0 Warnings: 0mysql> ALTER TABLE history MODIFY value DOUBLE PRECISION DEFAULT '0.0000' NOT NULL;
Query OK, 0 rows affected (0.01 sec)
Records: 0 Duplicates: 0 Warnings: 0mysql> exit
Bye
- zabbix.conf.php添加如下配置
$DB['DOUBLE_IEEE754'] = true;
- 重启zabbix-server
systemctl restart zabbix-server
