合肥市建设网官方网站,网站的设计技术策划,东莞网络建设推广,阿里云专有网络做网站zabbix升级到6之后#xff0c;配置安装完成会有一个红色输出#xff0c;但是不影响zabbix使用#xff0c;出于强迫症#xff0c;找到了该问题的解决方法。 Database history tables upgraded: No. Support for the old numeric type is deprecated. Please upgrade to nume…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
[rootzabbix conf]# systemctl stop zabbix-server zabbix-agent nginx php-fpm
[root220-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
Byezabbix.conf.php添加如下配置
$DB[DOUBLE_IEEE754] true;重启zabbix-server
systemctl restart zabbix-server
