Which pages are Quiddity's notifications associate with?

SELECT event_page_id, COUNT(*) FROM echo_event JOIN echo_notification ON event_id=notification_event WHERE notification_user = 1255 GROUP BY event_page_id;

Which of those pages still exist?

SELECT page_id, page_title, page_namespace FROM page WHERE page_id IN (1, 13955, 14048, 69747, 116853, 127334, 131861);

Over 60k notifications, mostly associated with page 13955 (maybe Talk:Flow_QA ?) that doesn't exist anymore, cannot be rendered.

Patch https://gerrit.wikimedia.org/r/#/c/301382/ would help but you would still see weirdness for a while before all old events are taking care of. (It would take 1200 refreshes of the notifications page to force moderation of those 60k notifications.) A maintenance script would be more appropriate. I'll create it.

Change 302480 had a related patch set uploaded (by Sbisson):
Maintenance: moderate notifications linked to missing pages

https://gerrit.wikimedia.org/r/302480

I'm currently stuck with a combination of this and T140836: [betalabs-Regression] cross-wiki bundle displays only wiki names - no notifications at MediaWikiwiki.

Re-check after the fix for T93673: Remove Notifications about posts/topics that have been Moderated is merged.

Curious that re-running the above queries, I do not see the event_page_id 13955, 116853, 131861 in archive table. When I checked the same scenario for another user (Flow board was deleted) - the event_page_id is still recorded in archive table.

SELECT ar_page_id, ar_title FROM archive WHERE ar_page_id IN (13955, 116853, 131861);
Empty set (0.01 sec)

My problem at beta cluster is fixed. Thanks! (I won't resolve this, as I'm not sure if more work is needed.)

Re-checked in betalabs - no issues found.

Change 302480 abandoned by Sbisson:
Maintenance: moderate notifications linked to missing pages

https://gerrit.wikimedia.org/r/302480