Zabbix with MariaDB partitioning problem

[nikira]

Hi, i have problem with partitioning existing mariadb database. I use debian 10 and zabbix 5.0.10 with mariadb 10.3.29. When i execute partitioning command i receive this error:

MariaDB [zabbix]> ALTER TABLE history_uint PARTITION BY RANGE ( clock) (PARTITION p2020_07_05 VALUES LESS THAN (UNIX_TIMESTAMP("2020-07-06 00:00:00")) ENGINE = InnoDB);
ERROR 1526 (HY000): Table has no partition for value 1593982819

can someone help me with this?

Best Regards

[Markku]

Hi, as far as I understand it, you need to have all time slots covered by your ALTER TABLE statement, and in your command you are missing all the timeslots after 2020-07-05. See https://blog.zabbix.com/partitioning...cedures/13531/ and add all the partitions in the same long command.

Markku