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 …

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.

‘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.

Notifications stuck on non-existing users due to follow plugin

Product Support

bartv (Bart ) September 24, 2019, 6:31am 10

I think I tracked this down to the Follow plugin.

Topic		Replies	Views
Recurrent Notifications from User Post due to Follow User plugin Product Support	4	1200	July 4, 2020
Users keep receiving notifications for the same post Product Support	4	682	June 8, 2019
Notifications being regenerated by looking through actions Product Support	4	860	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	1743	December 1, 2023

Notifications stuck on non-existing users due to follow plugin

Related topics