What does a healthy queue_items table look like?

smscotten

Is there any information available about the behavior of the queue and specifically the population of the queue_item table?

I have over 5,000 rows in the queue_items table dating back to April of this year; I don't know if queue items are supposed to be removed from the table once they are done with. I assume that the items must get removed at some point since the highest ID is over 30,000 but only 5,000 are in the table.

Also: 3800 of those are of transport "xmppout." I'm giving up on getting XMPP to work on my system and have disabled it. Can I safely just delete those rows from the database or will that mess up the queue daemon?

zcopley

Yes, those should be safe to delete. Probably vestigial items from when you had xmpp enabled at some point. If your queue isn't draining try restarting your queuedaemon. Maybe it got hung.

smscotten

Thanks, deleting all those entries helped. Unfortunately I'm still collecting stragglers (though not with xmpp transport). Three remote posts in the last day didn't make it to my stream although they are in my queue_item table listed as created and claimed.

Each is of transport "pushin" though I suspect that just means what I already knew; that they are remote posts.