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? [42]

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

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

Done; it returns nothing. Any other tables that could trigger this? select * from topic_users where user_id = 44269

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

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.

Do you have any third party plugins installed?

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

I think I tracked this down to the Follow plugin.

Notifications stuck on non-existing users due to follow plugin

Product Support

sam (Sam Saffron) August 26, 2019, 7:49am 2

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.

Topic		Replies	Views
Recurrent Notifications from User Post due to Follow User plugin Product Support	4	1205	July 4, 2020
Users keep receiving notifications for the same post Product Support	4	687	June 8, 2019
Notifications being regenerated by looking through actions Product Support	4	867	July 5, 2020
Repetitive Notification Issue with follow plugin? Product Support	5	698	August 12, 2021
Notifications are coming again even after reading them [Private Topics plugin] Product Support notifications	19	1784	December 1, 2023

Notifications stuck on non-existing users due to follow plugin

Related topics