Trend and History Data not Viewable - Query Failed Table has no partition - in logs

[greentaco]

This started happening randomly out of the blue, I get TONS of these messages:

query failed: [1526] Table has no partition for value

Over and over. I do not have MySQL Partitioning. It appears that my housekeeper was disabled at some point in the past (though Audit log shows not clues as to when). I have since started housekeeper to no avail.

How can I correct this situation?

DB is Aurora RDS (Mysql 5.7) and Zabbix Version is 4.

[LenR]

Do the various trend and history tables exist? Do they have rows? Go back in the logs to see when it first started.

[greentaco]

They do exist - I was able to figure this out. I wasn't aware that partitioning was setup on my DB.....it wasn't setup by me (this instance has been running for years...) and it appears the last partition had 'expired' so Zabbix wasn't able to write to the partition that didn't exist...once I created the new partitions, Zabbix was happy again.