We are experiencing delays in server from yesterday and today.It is unresponsive when we try to add contents to our upcoming module in <course> which may start tomorrow.
Logged in to the site OK. As I have mentioned before, please add content in small enough chunks to avoid timeouts.
The site was up after some time. But with no heavy activity still we find it not responsive. Particularly that involves heavy database calls like the quizzes. This happened yesterday and even today.e.g., https://ourdomain.org/mod/quiz/view.php?id=5032 which has the quiz section, is not loading at all.Can you check if the database server is healthy for <course>?
1. The link which you have sent does not load due to an invalid course module id - "Invalid course module ID: 5013 ... More information about this error"
2. Copy-pasting from an email I had sent to the team via SG on 11 Jan 2023 -
Some suggestions to make the course(s) load faster:
1. Currently, if you click on one of the courses, a huge page, with many images, for all weeks, loads in the browser. We can make it load a bit faster using Cloudflare, but such a large page is bound to cause problems with older computers / machines with less RAM / on slower networks / etc. It would be better to show a collapsed view, with each week opening up only on clicking. (the collapse all link on the top right). Or on separate pages.
2. As I mentioned, please use jpg quality = 70 to 75 instead of png.
3. I'll make the cloudflare changes to turn proxying on.
4. Clicking on question bank also loads up 1000 questions at once. This would cause problems as the number of questions / size of each question increase. It would be desirable to load up fewer questions - maybe 100 at a time as with the link at the bottom, "Show 100 at a time"
<the link> This was working on Friday night. This is a valid link for the quiz section of module 8.Discovered that quiz sections are not opening for previous modules also - which the participants successfully faced for the last 7 modules. All quizzes and question bank resources were working fine till last Friday. So there is something suspicious in the database server.We need all the previous module results and also the new quizzes that are to be opened tomorrow.Can you please check the health of the app and database server?
Moodle is installed and the database is running, which is how we are able to log on, see course pages, etc. - so the "health of the app and database server" are fine.
Digging deeper, in the plugins page, https://ourdomain.org/admin/plugins.php
I have seen some plugins "missing from disk" errors. These would have been "missing" since the Moodle upgrade of Mar 18.
Just to be safe, I have now copied these "missing from disk" plugins to the moodle plugins directory. It may be that these plugins are no longer supported, hence Moodle removed them - other plugins prompt for upgrades, which have been applied.
I have also turned off cloudflare caching, so that you will get more time before server timeout. But this may make pages slower to load for those taking the courses, so once you are done with admin tasks requiring longer db queries, please let me know, and I will again turn on cloudflare caching for faster response for the users of the course.
The link which you sent still gives the same error.
I'm not sure what else I can help you with. If you want raw database backups from the weekly backups, I can send you.
Do you have the list for missing plugins and updated ones? That can give some ideas.
local/welcome
local/mailtest
report/customsql
blocks/accessibility
lib/editor/atto
mod/questionnaire
Or can we revert to the last working version of Moodle? The troubleshoot time is less and we need to get the module ready for tomorrow morning at 4am.Note: Also in general, the site is too slow when compared to a couple of weeks before.
As far as I know, Moodle is working fine. So, as far as I'm concerned, "last working version of Moodle" is the current live site.
I can put the site back to last week's or the week before's - but then, any responses from the people taking from the course or any other changes made on the site after last week or 2 weeks back would be wiped out. Do you really want to do that? I don't think that's a good idea.
Yes, the site would be slower now that I have removed cloudflare caching as mentioned in the previous email.
Thanks for the list. `mod/questionnaire` seems to be related. But we can wait and see if we can create another set of quiz sections.On software upgrade -> yes if things dont work, we need to revert to the last working version. Not yet decided. Shall keep you updated as we are trying to create a new section.
(and 20 minutes later,)
Surprisingly things are working again.. Not sure how but it looks fine now. Also the site seems to be a bit faster than before. Not sure how?No changes were done from our side.
Moodle does some scheduled tasks - which are listed under Site Administration > Server > Tasks > Scheduled tasks
My guess would be that after I restored the missing plugin files, some automated task ran at some point of time to either clear database cached replies, or to fix broken links or something like that.
Anyway, all's well that ends well. But please don't put too much content on a single page - that would cause the site to load slowly. Please see Course Format > Course Layout > Show all sections on one page and change it to "Show one section per page" on each of the courses you're working on. That will make pages load much faster.
5 days later, at 9 pm,
again the site is too slow from this afternoon 12PM. Even a single module in the course page is taking minutes to load. Can you please check if there are any background jobs running?This is affecting our schedule as we wanted to open a new module tomorrow and we are stuck for long time today and unable to make it up.After a long time I am getting this (Error writing to database popup) - when trying to create a quiz (just a duplicate of an existing one)
Yes, Moodle runs lots of background jobs all the time. You can check these by going to
https://ourdomain.org/admin/tasklogs.php
Right now, the server loads are very low, but I did get a db server load high alert (85%, as against a healthy load of up to 80%) at 10:15 am yesterday.
Additionally, if many of your users are logged in, that can also slow down your response times. One possible mitigation in such cases would be for you to lock out other users by going to Maintenance Mode
https://ourdomain.org/admin/settings.php?section=maintenancemode
choose "Enable" and save - this will prevent other users from using the server - do your maintenance tasks, then go to the same page, and "Disable" - after which other users can continue to work.
And as I have mentioned earlier, running large db (database) queries will slow down the server and or make it time out. If that happens, please break down the action you wish to take into smaller chunks. "Just making a duplicate of a quiz" can be very db intensive if the quiz has a lot of content, multimedia content, a lot of users, a lot of responses, multimedia responses, and so on.
Attempted to create a blank quiz and it fails like below. (Screen showing "recalculating grades" and error writing to database at the end.) This does not have any questions. So seriously something is wrong with the backend.
Doing a search,
Found
So, this is possibly a bug. But I cannot fix Moodle bugs for you.
Not sure how I can help you with this. I can turn off cloudflare caching so that you will get a bit longer before timeout. (Found that this is already done.)
Then you can try putting the site in maintenance mode and then try creating the quiz. But if that also fails, I have no further ideas.
Thanks for the info bro. The site was noticeably faster a couple of weeks ago.Managed to create the sections for this module. Hopefully things get faster to load for users tomorrow.
No comments:
Post a Comment