Hello,
So I am migrating from an old Ubuntu 14.04 server to an 18.04 server. Since doing a distribution upgrade seems to always fail, I left Zabbix 3.4 on the old Ubuntu box and put 4.0.17 on the 18.04 box. I installed Zabbix on 18.04, copied the config files over and imported the database.
To export the database, I used:
mysqldump -u zabbix -p --single-transaction --routines --triggers zabbix > /mnt/dbbackup/zabbix_backupdb.sql
To create the database on the new server, I ran:
create database zabbix character set utf8 collate utf8_bin;
Then I just imported the .sql file into mysql:
mysql -u zabbix -p zabbix < zabbix_backupdb.sql.
When I start zabbix up for the first time, it upgrades the database etc.. I can log in and everything looks okay.
However, I start getting tons of these errors, and I don't see any new data being written to the database.
Any help would be greatly appreciated!
So I am migrating from an old Ubuntu 14.04 server to an 18.04 server. Since doing a distribution upgrade seems to always fail, I left Zabbix 3.4 on the old Ubuntu box and put 4.0.17 on the 18.04 box. I installed Zabbix on 18.04, copied the config files over and imported the database.
To export the database, I used:
mysqldump -u zabbix -p --single-transaction --routines --triggers zabbix > /mnt/dbbackup/zabbix_backupdb.sql
To create the database on the new server, I ran:
create database zabbix character set utf8 collate utf8_bin;
Then I just imported the .sql file into mysql:
mysql -u zabbix -p zabbix < zabbix_backupdb.sql.
When I start zabbix up for the first time, it upgrades the database etc.. I can log in and everything looks okay.
However, I start getting tons of these errors, and I don't see any new data being written to the database.
Code:
4382:20200223:062505.520 [Z3005] query failed: [1526] Table has no partition for value 1582457104 [insert into history (itemid,clock,ns,value) values (295724,1582457104,529706356,1.000000),(335444,1582457104,530715842,1.000000); ] 4385:20200223:062506.520 [Z3005] query failed: [1526] Table has no partition for value 1582457105 [insert into history (itemid,clock,ns,value) values (271705,1582457105,612646589,1.000000),(203800,1582457105,712151771,0.000000); ] 4383:20200223:062507.521 [Z3005] query failed: [1526] Table has no partition for value 1582457106 [insert into history (itemid,clock,ns,value) values (200486,1582457106,614529196,1.000000),(332106,1582457106,615210560,1.000000),(203862,1582457107,335515207,0.000000); ] 4385:20200223:062508.522 [Z3005] query failed: [1526] Table has no partition for value 1582457108 [insert into history (itemid,clock,ns,value) values (204028,1582457108,337268129,1.000000),(174148,1582457108,340441640,1.000000),(321948,1582457108,341721254,1.000000),(203168,1582457108,428199306,1.000000),(322488,1582457108,428664477,1.000000);
Any help would be greatly appreciated!
Comment