Hi all,
Moodle v3.9. Windows 2019.
I am hoping someone may have have some ideas here. For the last few days we have been experiencing forum notifications\emails failing to send out or sending out 7 to 8 hours after they were posted. Looking in the cron scheduled task\cron logs the following messages appear:
Execute scheduled task: Forum mailings and maintenance jobs (mod_forum\task\cron_task)
... started 11:29:15. Current memory use 24.4MB.
Removing old digest records from 7 days ago.
Removed all old digest records.
Fetching unmailed posts.
Done
Processing post information
Processed 1 posts
Filling caches
Filling course cache
Done
Filling forum cache
Done
Filling discussion cache
Done
Filling user subscription cache
Done
Filling digest cache
Done
All caches filled
Queueing user tasks.
Processing 89 users
Queued 0 digests and 1 messages for 46910
Queued 0 digests and 1 messages for 63989
Queued 0 digests and 1 messages for 74467
Queued 0 digests and 1 messages for 75854
Queued 0 digests and 1 messages for 80871
Queued 0 digests and 1 messages for 80881
Queued 0 digests and 1 messages for 81670
Queued 0 digests and 1 messages for 81847
Queued 0 digests and 1 messages for 85090
Queued 0 digests and 1 messages for 83026
Queued 0 digests and 1 messages for 84625
Queued 0 digests and 1 messages for 88497
Queued 0 digests and 1 messages for 88634
Queued 0 digests and 1 messages for 88669
Queued 0 digests and 1 messages for 88715
Queued 0 digests and 1 messages for 88816
Queued 0 digests and 1 messages for 92049
Queued 0 digests and 1 messages for 88963
Queued 0 digests and 1 messages for 89163
Queued 0 digests and 1 messages for 89235
Queued 0 digests and 1 messages for 89477
Queued 0 digests and 1 messages for 89592
Queued 0 digests and 1 messages for 89642
Queued 0 digests and 1 messages for 89692
Queued 0 digests and 1 messages for 89749
Queued 0 digests and 1 messages for 89764
Queued 0 digests and 1 messages for 89915
Queued 0 digests and 1 messages for 90680
Queued 0 digests and 1 messages for 91821
Queued 0 digests and 1 messages for 92994
Queued 0 digests and 1 messages for 92162
Queued 0 digests and 1 messages for 92167
Queued 0 digests and 1 messages for 92712
Queued 0 digests and 1 messages for 90975
Queued 0 digests and 1 messages for 91364
Queued 0 digests and 1 messages for 98404
Queued 0 digests and 1 messages for 103532
Queued 0 digests and 1 messages for 98285
Queued 0 digests and 1 messages for 98295
Queued 0 digests and 1 messages for 103533
Queued 0 digests and 1 messages for 98734
Queued 0 digests and 1 messages for 107436
Queued 0 digests and 1 messages for 103600
Queued 0 digests and 1 messages for 103603
Queued 0 digests and 1 messages for 103758
Queued 0 digests and 1 messages for 103759
Queued 0 digests and 1 messages for 108762
Queued 0 digests and 1 messages for 108246
Queued 0 digests and 1 messages for 107470
Queued 0 digests and 1 messages for 108777
Queued 0 digests and 1 messages for 109069
Queued 0 digests and 1 messages for 69649
Queued 0 digests and 1 messages for 246
Queued 0 digests and 1 messages for 33149
Queued 0 digests and 1 messages for 417
Queued 0 digests and 1 messages for 29954
Queued 0 digests and 1 messages for 48611
Queued 0 digests and 1 messages for 32524
Queued 0 digests and 1 messages for 40795
Queued 0 digests and 1 messages for 344
Queued 0 digests and 1 messages for 32126
Queued 0 digests and 1 messages for 99117
Queued 0 digests and 1 messages for 67854
Queued 0 digests and 1 messages for 624
Queued 0 digests and 1 messages for 650
Queued 0 digests and 1 messages for 101219
Queued 0 digests and 1 messages for 74897
Queued 0 digests and 1 messages for 93603
Queued 0 digests and 1 messages for 3
Queued 0 digests and 1 messages for 60552
Queued 0 digests and 1 messages for 40647
Queued 0 digests and 1 messages for 1132
Queued 0 digests and 1 messages for 57956
Queued 0 digests and 1 messages for 932
Queued 0 digests and 1 messages for 50994
Queued 0 digests and 1 messages for 59308
Queued 0 digests and 1 messages for 24237
Queued 0 digests and 1 messages for 1535
Queued 0 digests and 1 messages for 1579
Queued 0 digests and 1 messages for 31700
Queued 0 digests and 1 messages for 67595
Queued 0 digests and 1 messages for 24238
Queued 0 digests and 1 messages for 56393
Queued 0 digests and 1 messages for 68742
Queued 0 digests and 1 messages for 24827
Queued 0 digests and 1 messages for 1967
Queued 0 digests and 1 messages for 60308
Queued 0 digests and 1 messages for 2105
Queued 0 digests and 1 messages for 58348
Queued 0 digests, and 89 individual tasks for 89 post mails. Unique users: 89 (0 ignored)
All tasks queued.
... used 373 dbqueries
... used 1.7477250099182 seconds
Scheduled task complete: Forum mailings and maintenance jobs (mod_forum)I believe the above is just queuing the mailings i.e. not actually sent? ( sorry if I am misunderstanding this.) Where I have traced the forum post ID for some of these,
in [dbo].[mdl_forum_posts] it marked as [mailed] = '1' which I always thought was sent? In addition last few days, been receiving this error message regularly :
execute adhoc task: mod_forum\task\send_user_notifications ... started 17:27:04. Current memory use 29MB. Sending messages to XXXXX (42715) !!! Coding error detected, it must be fixed by a programmer: A lock was created but not released at: [dirroot]\lib\cronlib.php on line 154 Code should look like: $factory = \core\lock\lock_config::get_lock_factory('type'); $lock = $factory->get_lock(Resource id #1606); $lock->release(); // Locks must ALWAYS be released like this. !!!
I presume the two are related? Sorry, not a programmer. It set up as outgoing SMTP relay, so not sure where the fault is lying here. Any advice or ideas would be greatly
received. Thanks in advance for your help.