zabbix-server 3.4.13
mysql
linux

can you please try select from events where objectid=1847976;

The host wasn't active for very long, so I'm not surprised to not see any rows. Also, that query took a long time.

mysql> select * from events where objectid=1847976;
Empty set (38.22 sec)

mysql>

It's fine! Such records are created to remove item based internal events. Also can be created records with tablename="events" and field="lldruleid" or "triggerid".

This wouldn't be considered a bug that you would write entries into this table that are impossible to ever exist?

This is not a bug. The housekeeper table has no direct links to real fields and tables. It contains commands for the housekeeper process to remove unnecessary information from the DB.

I guess I'm trying to understand why it would write information into a table to get deleted items that would never exist.

Didn't that host have some items?

So the way I read what's in the housekeeper table,
housekeeperid, tablename, field, value

So the above record would be DELETE FROM events WHERE itemid = 1847976. And what I'm saying is events table doesn't have a field called itemid, so why would there be a row inserted into housekeeper in the first place.

I guess I'm trying to understand why it would write information into a table to get deleted items that would never exist.

Because the server can still create new entries in the event table after deleting an item due to configuration caching.

No, the SQL statement would be: "DELETE FROM events WHERE source=3 AND object=3 AND objectid=1847976"