Posts made by Visvanath Ratnaweera

Moodle in English -> Lounge -> Happy New Year and Goodbye -> Happy New Year and Goodbye

by Visvanath Ratnaweera -
Picture of Particularly helpful Moodlers Picture of Translators
Mary, Marcus and all

> she has been a wonderful steady, diplomatic, tactful helpful and kind presence ever since.
 
Right, to the letter!
 
Though never met her "in real life" there was one encounter close to that, when Mary visited us on (cinema size) screen on the closing day of our intensive 3-day workshop for Moodle for Administrators in Sri Lanka three years ago. That was unannounced for the participants, and the spontaneous interview left a lasting impression.
 
I have an anecdote on her "understated insight": Our messaging started in 2010 but was sparse until 2013, when the first Moodle MOOC was launched. I joined it using a pseudo name. The MOOC was so intensive we started a messaging thread on the Academy platform. Somewhere it was time for me to dox myself. To my utter shock, she messaged me back to say that half of my first forum post was enough to recognize the person! 
 
The Moodle of today is not the Moodle I joined - but then, neither are we the same people today that we were yesterday. Everything is impermanent, and understanding that is key to our peace.
 
The best quote to end in a philosophical note.

Average of ratings: Coolest thing ever! (4)

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

by Visvanath Ratnaweera -
Picture of Particularly helpful Moodlers Picture of Translators

There was a second incident today noon. The DBMS committed 116 GB RAM, which it does not have, so swapped heavily. The load average went to 47 in a (physical) machine with 24 CPU threads. Stated just past 11:30 was finished by 12:00. The monitoring graphs look like somebody has restarted the server (haven't restarted even the DB server).

I was ready this time, Show origin of SQL calls was set to Show full stack trace and the slow queries were written to a file. The part between 11:30 and 12:00 is attached.

You'll see that three databases are involved, all are Moodle DBs. The first one, xyzfmoodle, is the suspected one. I have logs of a teacher who was transferring quizzed through the sharing cart. She has been doing it since 11:19 dozens of times. According to Moodle logs none has taken more than 1 second each. So could be a red herring.

More likely are these tasks running now:

and the Ad hoc tasts show:

How can I find out where they come from and why still unfinished although the DB was released? Or, had the DB dropped everything and restarted?

Notice that the xyzfmoodle is the database once crashed with 3 million duplicate questions. After much cleaning it has close to 600'000 question instances now.

Average of ratings: -

Moodle in English -> Lounge -> A renewed flood of spam -> A renewed flood of spam

by Visvanath Ratnaweera -
Picture of Particularly helpful Moodlers Picture of Translators
Here is a hard one:
 
https://moodle.org/mod/forum/discuss.php?d=471419#p1893027
 
Some gold-digging site sandwiched between relevant (AI?) paragraphs. Incidentally the OP solved his problem from information provided. So, too late to delete, but that "gold digging" para must go. I've flagged it yesterday, no reaction yet.
 
In the meantime, more entertainment:
 
Average of ratings: -

Moodle in English -> Installing and upgrading help -> Error: Database Connection Failed though all settings match recommended from instructions -> Error: Database Connection Failed though all settings match recommended from instructions [SOLVED]

by Visvanath Ratnaweera -
Picture of Particularly helpful Moodlers Picture of Translators
BTW the Step-by-step Installation Guide for Ubuntu is not the only installation guide, there's a full Category:Installation. If you are conversant in the Linux CLI, you'll like the Installation_quick_guide for "experts".
Average of ratings: -