Notifications stuck on non-existing users

Hi,

My users are reporting an issue where they will keep getting the same notification for new posts. I’ve tracked it back to a non-existing user, and it seems Sidekiq keeps retrying these notifications which results in the these people getting the notification multiple times.

I have killed these retries in the past, but they’ll resurface after a while. Shouldn’t they just ‘give up’ and not retry?

2 Likes

This is odd for sure. Can you sweep the DB searching for user_id 44269, maybe when we nuke the user record we left it around in some tables and this is triggering the issue.

1 Like

‘Sweep’? Is there a quick way to do that, or do I need to inspect every table separately?

1 Like

You would need a script for it. I would start though by looking at topic_users

1 Like

Done; it returns nothing. Any other tables that could trigger this?

select *
from topic_users
where user_id = 44269
1 Like

Very weird… maybe the user is watching all posts … had mailing list mode enabled and now has orphan records for watching stuff.

1 Like

I looked in the Data Explorer but can’t find anything relevant. Do you have other suggestions where I can look?

I’m traveling this week, but when I’m back I can download a DB dump and do a search for this value too, I suppose.

2 Likes

Do you have any third party plugins installed?

1 Like

Yes, a few. But I’ll dive into the database first before disabling anything on my production box.

1 Like