!Hubzilla Support Forum
Some days ago our hubzilla instance was pretty much dead. Thats because of 200+ db processes going forever. I have extremely busy at my dayjob so couldnt really look into it. I noticed just few minutes ago my hub went down, and there was again 100+ db workers.
I quickly checked
and noticed that the query below was launched pretty much 90 times, which is essentially the cause of the issue. after inspecting the item in question, it was actualyl my reply to mastodons DM
select * from item where mid like 'XXXXXXXXXXXXXXXXXXXXXXXXXX@hub.disroot.org%' and item.item_hidden = 0 and item.item_type = 0 and item.item_unpublished = 0
(not sure if its safe/needed to provide the
part so I replaced it with X'es).
Any idea what might be going on?