zabbix6.4 Database history tables upgraded_zabbix 数据库中历史数据表已升级

1.zabbi从3.0升级到6.4之后，配置安装完成会有一个红色输出，但是不影响zabbix使用，出于强迫症，找到了该问题的解决方法。

Database history tables upgraded: No. Support for the old numeric type is deprecated. Please upgrade to numeric values of extended range

2.停止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 - GPL

Copyright (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 -A

Database 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: 0

Query OK, 0 rows affected (0.01 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> 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: 0

mysql> 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: 0

mysql> exit
Bye
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40

3、启动服务
[root@zabbix ~]# systemctl start zabbix-server zabbix-agent nginx php-fpm

4、我重新跑了一遍setup.php红色提示消失

这是官方的原文链接