Hi!
I've done zabbix db partitioning using this howto - https://www.zabbix.org/wiki/Docs/howto/mysql_partition and unfortunately I forgot to re-run partinioning procedure before the 14th day and I allow my database to run out of partitions ;( I tried to fix it, I run again the partitioning procedure but it didn't helped. I see a lot of logs like this:
and graphs have got a lot of holes :/
Could anyone help me with this problem? Thanks in advance!
I've done zabbix db partitioning using this howto - https://www.zabbix.org/wiki/Docs/howto/mysql_partition and unfortunately I forgot to re-run partinioning procedure before the 14th day and I allow my database to run out of partitions ;( I tried to fix it, I run again the partitioning procedure but it didn't helped. I see a lot of logs like this:
1849:20160919:090645.744 [Z3005] query failed: [1526] Table has no partition f or value 1474268804 [insert into history_str (itemid,clock,ns,value) values (403 04,1474268804,292976717,'');
Could anyone help me with this problem? Thanks in advance!