Hello!
I am upgrading Moodle from 2.8 to 3.0.2+ release and the process appears Ok
(both with web and cli method). At the end, the final users can log Ok in the platform
but the Moodle admin users no. The load for every page for admins is very slow. Unusable.
We have nearly 30000 communities. The trace for the apache is below and this repeat for every community (only for platform admins!).
sendto(21, "P\0\0\0c\0SELECT ctx.*\n "..., 173,
MSG_NOSIGNAL, NULL, 0) = 173
poll([{fd=21, events=POLLIN|POLLERR}], 1, 4294967295) = 1 ([{fd=21,
revents=POLLIN}])
recvfrom(21,
"1\0\0\0\0042\0\0\0\4T\0\0\0\206\0\5id\0\1O$\0\0\1\0\0\0\24\0\10"...,
65536, 0, NULL, NULL) = 874
sendto(21, "P\0\0\0M\0SELECT * FROM mdl_context "..., 130, MSG_NOSIGNAL,
NULL, 0) = 130
poll([{fd=21, events=POLLIN|POLLERR}], 1, 4294967295) = 1 ([{fd=21,
revents=POLLIN}])
recvfrom(21,
"1\0\0\0\0042\0\0\0\4T\0\0\0\206\0\5id\0\1O$\0\0\1\0\0\0\24\0\10"...,
65536, 0, NULL, NULL) = 236
sendto(21, "P\0\0\2\6\0SELECT active.filter, fc.n"..., 556,
MSG_NOSIGNAL, NULL, 0) = 556
poll([{fd=21, events=POLLIN|POLLERR}], 1, 4294967295) = 1 ([{fd=21,
revents=POLLIN}])
recvfrom(21, "1\0\0\0\0042\0\0\0\4T\0\0\0N\0\3filter\0\1O&!\0\2\0\0"...,
65536, 0, NULL, NULL) = 258
access("/var/moodle/WEB/www/filter/activitynames/filter.php", R_OK) = 0
access("/var/moodle/WEB/www/filter/mathjaxloader/filter.php", R_OK) = 0
access("/var/moodle/WEB/www/filter/mediaplugin/filter.php", R_OK) = 0
access("/var/moodle/WEB/www/filter/multilang/filter.php", R_OK) = 0
access("/var/moodle/WEB/www/filter/glossary/filter.php", R_OK) = 0
sendto(21, "P\0\0\0.\0SELECT * FROM mdl_course W"..., 93, MSG_NOSIGNAL,
NULL, 0) = 93
poll([{fd=21, events=POLLIN|POLLERR}], 1, 4294967295) = 1 ([{fd=21,
revents=POLLIN}])
recvfrom(21,
"1\0\0\0\0042\0\0\0\4T\0\0\3\\\0\36id\0\1O$\f\0\1\0\0\0\24\0\10"...,
65536, 0, NULL, NULL) = 1203
access("/var/moodle/DATA/moodledata/cache/cachestore_file/default_application/core_coursemodinfo/270-cache/27094-1b71c76ffd18f0bd1ebd8ff086d8f22c.cache",
F_OK) = 0
lstat("/var/moodle/DATA/moodledata/cache/cachestore_file/default_application/core_coursemodinfo/270-cache/27094-1b71c76ffd18f0bd1ebd8ff086d8f22c.cache",
{st_mode=S_IFREG|0666, st_size=1622, ...}) = 0
lstat("/var/moodle/DATA/moodledata/cache/cachestore_file/default_application/core_coursemodinfo/270-cache",
{st_mode=S_IFDIR|0777, st_size=2240, ...}) = 0
open("/DISCO_RAM/core_coursemodinfo/270-cache/27094-1b71c76ffd18f0bd1ebd8ff086d8f22c.cache",
O_RDONLY) = 22
fstat(22, {st_mode=S_IFREG|0666, st_size=1622, ...}) = 0
lseek(22, 0, SEEK_CUR) = 0
flock(22, LOCK_SH) = 0
read(22, "O:8:\"stdClass\":9:{s:7:\"modinfo\";"..., 8192) = 1622
read(22, "", 8192) = 0
flock(22, LOCK_UN) = 0
close(22) = 0
Any help will be welcomed.
Regards,
Agustin