Installing and upgrading help

See what's in mdl_lock_db.

Also in moodledata/locks/ - are owserships/permissions ok?

cron job running how often and by what user?

'SoS', Ken

moodledata/lock ... should be readable and writable by web service user.   If you run your cron job as root user (I do sometimes from command line run php admin/cli/cron.php) and see that some files in moodledata/lock/ are tagged as belonging to root user.  So i have moodledata/lock/ readable/writable by all.

Since you've been having issues in upgrading ... am guessing that there were times when maintenance mode was off ... a task could run ... although may not finish ... so lock created but for some reason could not be changed/removed/unlocked in a cron/task run.

The 'mdl_lock_db' is a table in the database.  My table has no data in it so am thinking that table might be acting as a scheduler of some sort for crons/task to check to see what's locked and what's not. 

mysql> explain mdl_lock_db;
+-------------+--------------+------+-----+---------+----------------+
| Field       | Type         | Null | Key | Default | Extra          |
+-------------+--------------+------+-----+---------+----------------+
| id          | bigint(10)   | NO   | PRI | NULL    | auto_increment |
| resourcekey | varchar(255) | NO   | UNI |         |                |
| expires     | bigint(10)   | YES  | MUL | NULL    |                |
| owner       | varchar(36)  | YES  | MUL | NULL    |                |
+-------------+--------------+------+-----+---------+----------------+

So, what I re-call doing ... site in maintenance mode (and to assure nothing web based could get in un-seen, actually shutdown apache), truncated the data in the table mdl_lock_db, manually removed contents of moodledata/lock/ (rm -fR * in that location)  Restarted apache.  Site out of maintenance mode.

Ran php admin/cli/cron.php several times ... no errors

The also checked the task related to my problem ... yours might be ... \core\task\grade_cron_task and

\core\task\grade_history_cleanup_task

in moodlecode/admin/tool/task/cli/

Good luck!

'SoS', Ken

First, suggest Moderator remove .docx attachment.  Might be exposing too much info.

Tip: many folks won't open M$ anything if shared here in forums.

Screen captures as images paying attention to blacking out sensitive info better.

Best is text only!!!

Ok, your table has the same structure as mine ... and as every 3.6 user in the globe.   It contained no data .. right?

I see that that table does have utf8mb4 character set?  And collation of utf8mb4_general_ci.

The error is failing to read/or write to that table via task.

In your config.php file for DB section ... is there a DB collation line?

That line must match all the tables in the DB ... and all the columns in those tables.

In moodlecode/admin/cli/

run

php mysql_collation.php -l

Summary at the bottom ...

utf8mb4_general_ci: 1494

Also, know the super user creds to the DB for the Moodle?

Could change the config.php file DB user, DB password to super user

Then try one of the failing task.

'SoS', Ken

Superuser Creds for DB root?
Most setups recommend not using root (ssh access) logins/passwords for DB setup.   But who knows ... I can't guess that remotely ...
no vulcan mind meld possible here!

In the Background processing for gradebook \core\task\grade_cron_task
you show in https://moodle.org/mod/forum/discuss.php?d=386884#p1559737 posting.
That has a scheduled date of Jan 6 2019 or is that 1st of May?

in moodlecode/admin/tool/cli/

try running:

php schedule_task.php --execute="\core\task\grade_cron_task"

and

php schedule_task.php --execute="\core\task\grade_history_cleanup_task"

Those same task are part of the overall cron job.

If either of those error, errors will show text .. copy text ... paste to NotePad.   Come back here and post the text.

'SoS', Ken

Well, it's some info ... but since am not a true programmer, what to do with the info???!!!???

Don't understand this:

"had to use the path: moodlecode/admin/tool/task/cli"

I normally do cd /path/to/moodlecode/admin/tool/task/cli/

Then execute like:

php schedule_task.php --execute="\core\task\grade_cron_task"

and

php schedule_task.php --execute="\core\task\grade_history_cleanup_task"

So the first command reported:

"Exception - Class 'grade_grade' not found"

but the second completed ok?

Run the first one again now that the second completed:

Mine shows - yours should be something similar:

php schedule_task.php --execute="\core\task\grade_cron_task"
Execute scheduled task: Background processing for gradebook (core\task\grade_cron_task)
... used 2 dbqueries
... used 0.027482032775879 seconds
Scheduled task complete: Background processing for gradebook (core\task\grade_cron_task)

Tried to find something in tracker for bug reporting concerning the 'Exception - Class 'grade_grade' not found ' but didn't find anything.

We might have to wait for someone with a lot more knowledge about such things than me!   We've made progress, but ....

'SoS', Ken

Well ... migrations require getting ducks in a row and attempting to make sure they go smoothly ... ie, without error.   You had some issues however, and possibly that lead to the first issue of locks ... in and out of maintenance mode ... cron jobs sneaking in between and attempting to do something, etc. etc.   Only a vulcan mind meld historical record might determine, me thinks.

Am concerned that turning off that task might cause issues.

Will send you a PM with an offer you probably shouldn't turn down!

'SoS', Ken

Hello,

we are in the migration phase from Moodle version 3.5.1 to 3.7.1+.

Out system environment is:

• virtual machine (on vmwere)
  
• Debian 9, x64
• MariaDB 15.1
• Apache2 2.4.25
• PHP 7.3 (just upgraded from 7.0.1)

Execute scheduled task: Obdelava v ozadju za predpomnilnike (core\task\cache_cron_task)
... started 12:08:20. Current memory use 14,9MB.
Cleaning up stale session data from cache stores.
... used 0 dbqueries
... used 0,0043849945068359 seconds
Scheduled task complete: Obdelava v ozadju za predpomnilnike (core\task\cache_cron_task)
... used 1 dbqueries
... used 0,0054318904876709 seconds
Scheduled task failed: Obdelava v ozadju za predpomnilnike (core\task\cache_cron_task),Napaka pri pisanju v podatkovno bazo
Debug info:
Column count doesn't match value count at row 1
INSERT INTO mdl_task_log (type,component,classname,userid,timestart,timeend,dbreads,dbwrites,result,output) VALUES(?,?,?,?,?,?,?,?,?,?)
[array (
  0 => 0,
  1 => 'moodle',
  2 => 'core\\task\\cache_cron_task',
  3 => 0,
  4 => 1563530900.1721661,
  5 => 1563530900.1818039,
  6 => 0,
  7 => 0,
  8 => 0,
  9 => 'Execute scheduled task: Obdelava v ozadju za predpomnilnike (core\\task\\cache_cron_task)
... started 12:08:20. Current memory use 14,9MB.

Best regards, Erik Frangež