Orphaned objects in 1.8.9 database

[Txalamar69]

Hi,

I've found lots of orphaned objects in database:

select events.* FROM events LEFT OUTER JOIN triggers ON events.objectid = triggers.triggerid WHERE triggers.triggerid IS NULL;
select trends.* FROM trends LEFT OUTER JOIN items ON trends.itemid = items.itemid WHERE items.itemid IS NULL;

do you know where do they come from and if it's solved in any fruther version of 1.8?

[heaje]

For events, they come from more than just triggers, so it makes complete sense that not everything joins to the trigger table.

Do you have housekeeper disabled in your configuration? If so, it also makes complete sense why you have trends that don't tie to the item table. Housekeeper is what deletes orphaned data like that.