Zabbix 6.2: After upgrade from 6.0 Database history tables upgraded NO

[andreagx]

Hello,

After upgrade from 6.0 to 6.2, system information returns: "Database history tables upgraded" set to "NO"

How can I solve this issue?

Thanks

[LenR]

https://www.zabbix.com/documentation/current/en/manual/appendix/install/db_primary_keys

[andreagx]

Hello LenR,
Thank you for your reply.


I already made steps in the doc you posted, but the issue occurs again



mysql> SET @@max_execution_time=0;
Query OK, 0 rows affected (0.00 sec)

mysql> SELECT * INTO OUTFILE '/var/lib/mysql-files/history_uint.csv' FIELDS TERMINATED BY ',' ESCAPED BY '"' LINES TERMINATED BY '\n' FROM history_uint_old;
ERROR 1086 (HY000): File '/var/lib/mysql-files/history_uint.csv' already exists
mysql> LOAD DATA INFILE '/var/lib/mysql-files/history_uint.csv' IGNORE INTO TABLE history_uint FIELDS TERMINATED BY ',' ESCAPED BY '"' LINES TERMINATED BY '\n';
Query OK, 184255 rows affected, 65535 warnings (10 min 29.35 sec)
Records: 29520447 Deleted: 0 Skipped: 29336192 Warnings: 29336192

mysql> SELECT * INTO OUTFILE '/var/lib/mysql-files/history_str.csv' FIELDS TERMINATED BY ',' ESCAPED BY '"' LINES TERMINATED BY '\n' FROM history_str_old;
ERROR 1086 (HY000): File '/var/lib/mysql-files/history_str.csv' already exists
mysql> LOAD DATA INFILE '/var/lib/mysql-files/history_str.csv' IGNORE INTO TABLE history_str FIELDS TERMINATED BY ',' ESCAPED BY '"' LINES TERMINATED BY '\n';
Query OK, 573 rows affected, 10626 warnings (0.49 sec)
Records: 11199 Deleted: 0 Skipped: 10626 Warnings: 10626

mysql> SELECT * INTO OUTFILE '/var/lib/mysql-files/history_log.csv' FIELDS TERMINATED BY ',' ESCAPED BY '"' LINES TERMINATED BY '\n' FROM history_log_old;
ERROR 1086 (HY000): File '/var/lib/mysql-files/history_log.csv' already exists
mysql> LOAD DATA INFILE '/var/lib/mysql-files/history_log.csv' IGNORE INTO TABLE history_log FIELDS TERMINATED BY ',' ESCAPED BY '"' LINES TERMINATED BY '\n';
Query OK, 0 rows affected (0.00 sec)
Records: 0 Deleted: 0 Skipped: 0 Warnings: 0

mysql> SELECT * INTO OUTFILE '/var/lib/mysql-files/history_text.csv' FIELDS TERMINATED BY ',' ESCAPED BY '"' LINES TERMINATED BY '\n' FROM history_text_old;
ERROR 1086 (HY000): File '/var/lib/mysql-files/history_text.csv' already exists
mysql> LOAD DATA INFILE '/var/lib/mysql-files/history_text.csv' IGNORE INTO TABLE history_text FIELDS TERMINATED BY ',' ESCAPED BY '"' LINES TERMINATED BY '\n';
Query OK, 1 row affected, 65535 warnings (2.91 sec)
Records: 103111 Deleted: 0 Skipped: 103110 Warnings: 103110

(see the attach)

Andrew