Details
-
Type:
Improvement
-
Status: Closed
-
Priority:
Minor
-
Resolution: Fixed
-
Affects Version/s: 3.5.3, 3.6, 3.7.4, 3.8.1, 3.9
-
Fix Version/s: 3.9
-
Component/s: Database SQL/XMLDB, Messages, Performance
-
Testing Instructions:
- Run vendor/bin/phpunit message_popup_messaging_cleanup_testcase
- Confirm testcase passes
-
Affected Branches:MOODLE_35_STABLE, MOODLE_36_STABLE, MOODLE_37_STABLE, MOODLE_38_STABLE, MOODLE_39_STABLE
-
Fixed Branches:MOODLE_39_STABLE
-
Epic Link:
-
Pull from Repository:
-
Pull Master Branch:
-
Pull Master Diff URL:
Description
messaging_cleanup_task removes 'old' read and unread message notifications based on $CFG->messagingdeletereadnotificationsdelay and $CFG->messagingdeleteallnotificationsdelay settings. But doesn't remove any record from message_popup_notifications. So there are some orphaned records in message_popup_notifications table remaining with no related message_notifications record.
There should be a cleanup task to remove all orphaned records in message_popup_notifications table.
Attachments
Issue Links
- caused a regression
-
MDL-69848 Improve mdl_notifications 3.7->3.9 upgrade script performance
-
- Closed
-
- Discovered while testing
-
MDL-64400 Bloated notifications table full with no way to reduce it down via the UI
-
- Closed
-
- has been marked as being related by
-
MDL-70050 Queries for deleting messages are not optimal on mariadb/mysql
-
- Open
-