1. 问题:
zabbix_server日志出现大量如下错误:
query failed: [1526] Table has no partition for value 1507509984
2. 解决
查看zabbix的数据库,看看有没有如下几个存储过程:
partition_create
partition_drop
partition_maintenance
partition_maintenance_all
partition_verify
可能会没有partition_maintenance_all,可以按照官方文档给出的sql语句创建:
DELIMITER $$CREATE PROCEDURE `partition_maintenance_all`(SCHEMA_NAME VARCHAR(32))BEGINCALL partition_maintenance(SCHEMA_NAME,'history', 28, 24, 14);
CALL partition_maintenance(SCHEMA_NAME,'history_log', 28, 24, 14);
CALL partition_maintenance(SCHEMA_NAME,'history_str', 28, 24, 14);
CALL partition_maintenance(SCHEMA_NAME,'history_text', 28, 24, 14);
CALL partition_maintenance(SCHEMA_NAME,'history_uint', 28, 24, 14);
CALL partition_maintenance(SCHEMA