Granted the title of this posting may not be very accurate, so here are the details ... as I understand the issue.
First, entity is using load balancing (LB) that goes to 4 nodes (02,03,04,05) and those are running CentOS 7 with Moodle 3.4.x (not highest) ... MySQL on a dedicated SQL server, PHP cli shows 7.2.8 and each server setup to use php-fpm. Hope that's a good enough description ...
The problem ... many of the SCORMS (1.2 versions) are lengthy and take time to complete - example of one ... 96 slides (all have some .mp3 audio), 3 slides have videos with approx 4min, 4min, and 7min playing time. At the end there is a quiz and user must make 80% to pass.
What's happening ... users get to the very end and when they click the 'final button', it spins forever, or times out.
In watching realtime logs for scorm activity one could see when user moved to a different slide ... no issues with navigating ... it's only the very end ... where one sees
a POST to /mod/scorm/datamodel.php that I think dumps the data the SCORM has been collecting to the Moodle and that's when it times out ... that 'spinning forever'. Pretty frustrating for users that have spent what might be 1 hour in a SCORM and to get to the very end ... fail. :\
Have found a setting that was not turned on for 'auto-commit' ... which, in it's description, says it will, from to time, dump to Moodle. In looking at logs that setting does appear to be executing.
When looking at the DB mdl_scorms table, there is an autocommit column for all SCORMS that appears to be set for '0' still.
So does changing that setting in config of SCORM's set a global? Is that not reflected in the settings of each SCORM? Do I need to go back to each individual SCORM and set that? If so, there doesn't seem to be a setting for that in each SCORM setup via admin/set up of a SCORM module.
Am hoping that when/if a user reaches the end of a SCORM and they loose connectiviity (for some reason yet to be discovered), most of the data for participation has been saved to the DB.
Granted ... can't control their connectivity ... the netcheck for sessions is running frequently enough I think but can't not find a way to increase the frequency of checking ... or if that's a good idea or not.
Any advice?
A 'bonus question' ... observation ... running the task for scorm individually doesn't appear to be doing anything ... run from either cli or the 'Run Now' button in the Moodle Admin UI. What is it supposed to do?
Thanks in advance,
Ken