貼文的作者是 Visvanath Ratnaweera

Moodle in English -> Hardware and performance -> [Sharing Cart] Restore not releasing memory it consumed -> [Sharing Cart] Restore not releasing memory it consumed

由Visvanath Ratnaweera發表於
Particularly helpful Moodlers的相片 Translators的相片

Our teachers are used to duplicate courses by copying course sections one after the other. They contain, among other activities, complete tests (Quizzes). One such action seems to the cause of the original problem. 

The web server logs look like

6 January 2026, 11:14:05 AM [USER] User: [USER] Sharing Cart block_sharing_cart: backup section User with id 68 has backed up a section with id 53637 in course with id 3859

6 January 2026, 11:15:03 AM [USER] Course: [COURSE] Sharing Cart block_sharing_cart: restored section User with id 68 has restored a section with id 63355 in course with id 4581 that takes 0 seconds

6 January 2026, 11:15:03 AM [USER] Deleted forum (id '367508') Sharing Cart block_sharing_cart: restored course module User with id 68 has restored a course module with id 367508 in the course with id 4581 that takes 0 seconds

6 January 2026, 11:16:19 AM [COURSE] Course: [COURSE] Sharing Cart block_sharing_cart: restored section User with id 68 has restored a section with id 63356 in course with id 4581 that takes 1 seconds

6 January 2026, 11:16:19 AM [USER] Forum: [FORUM] Sharing Cart block_sharing_cart: restored course module User with id 68 has restored a course module with id 367509 in the course with id 4581 that takes 1 seconds

(160 such lines in total within about 20 minutes)

 Although they say the transactions were finished, the committed memory jumped by 50 GB(!) during the same period making even the swap got exhausted and the OS started hunting processes, almost all killed processes were mariadb. That left Moodle with the unfinished tasks in the OP https://moodle.org/mod/forum/discuss.php?d=471223#p1893188.

Is this a bug in Sharing Cart?

Moodle 4.5.8+, mysql Ver 15.1 Distrib 10.11.14-MariaDB, PHP 8.1.34 (I know, support ended just 10 days ago. This is a heavy installation that needs a lot of planning before shifting. I have a staging server running PHP 8.3 to compare, if necessary)

Sharing Cart 5.0, release 6 2025092900

extramemorylimit is 512 MB (the default)

Edit: Found something suspicious: https://github.com/donhinkelman/moodle-block_sharing_cart/issues/257. Still would like to hear from the Sharing Cart side and how I could debug further.

評比平均分數： -

Moodle in English -> Hardware and performance -> [Sharing Cart] Restore not releasing memory it consumed -> Hunting slow queries in the quiz sub-system, incident 2

由Visvanath Ratnaweera發表於
Particularly helpful Moodlers的相片 Translators的相片
The promised update: Had a look with a DB "guru" and found killed queries. So the slow queries are not the culprits but victims. PHP started requesting large amount of memory in Apache until the main MariaDB process was restarted. It all points to PHP building huge tables, most probably because the DB produces huge results. Investigating what they are. I could spare memory from the DB and give them to Apache but waiting to provocate more incidents to come closer to those huge data sets.

P.S. I know, the subject line is not fitting. Again waiting for the true cause before renaming and probably moving the discussion to Hardware and performance forum.
評比平均分數： -

Moodle in English -> Lounge -> ‘Put learners first’: Unesco calls for global ban on smartphones in schools -> Australia’s Social Media Ban for Children Takes Effect

由Visvanath Ratnaweera發表於
Particularly helpful Moodlers的相片 Translators的相片

Surprise, surprise!

'I feel free': Australia's social media ban, one month on

For the first time in years, Amy feels free.

One month since Australia's teen social media ban kicked in, she says she is "disconnected from my phone" and her daily routine has changed.

The 14-year-old first felt the pangs of online addiction in the days after the ban started.

"I knew that I was still unable to access Snapchat - however, from instinct, I still reached to open the app in the morning," she wrote on day two of the ban in a diary she kept for the first week afterwards.

By day four of the ban – when ten platforms including Facebook, Instagram and TikTok went dark for thousands of Australian children aged 16 and under – she had started to question the magnetic pull of Snapchat.

BBC, 10 January 2026, https://www.bbc.com/news/articles/c0mpmgn3jv2o

評比平均分數： Very cool (1)

Moodle in English -> Installing and upgrading help -> Moodle 5.0 → 5.1 upgrade shows PHP source code instead of upgrade page (only one instance affected) -> Moodle 5.0 → 5.1 upgrade shows PHP source code instead of upgrade page (only one instance affected)

由Visvanath Ratnaweera發表於
Particularly helpful Moodlers的相片 Translators的相片
Put the popular phpinfo.php file in moodle/public and visit yoursite/phpinfo.php. It should display the familiar PHP Info page. If not repair the corresponding Apache virtual host until you see the PHP Info. If it does but still index.php comes in source, you broke something big scale. Are you familiar with Upgrading? You must know by this time the different moodle/config.php and moodle/public/config.php. 
眨眼
評比平均分數： -

Moodle in English -> Lounge -> Digital Independence Day -> Digital Independence Day

由Visvanath Ratnaweera發表於
Particularly helpful Moodlers的相片 Translators的相片

Some additional information to the previous post:

About the hashtags, I find #DiDay is a more a reasonable one than the #DUT, #DIT #DID, etc. 

It is clear how the CCC could inspire so many DI.DAY events in such short time - thanks to the Regional CCCs!

Either way, the message is to move from the BIG TECH platforms to more "open" ones, for example

https://mastodon.social/@joevan/115855077890766584

And nobody says, it must happen on the first day. It is a process and you take a small step each DiDay. Equally important is that you tell others about it, and when these topics arise with your friends, when people bash Google or more often Microsoft these days, talk about these alternatives - ideally about your first-hand experience.

評比平均分數： Very cool (1)