Issue Details (XML | Word | Printable)

Key: MDL-15623
Type: Bug Bug
Status: Resolved Resolved
Resolution: Not a bug
Priority: Blocker Blocker
Assignee: Petr Skoda
Reporter: Andrea Bicciolo
Votes: 0
Watchers: 1
Operations

Add/Edit UI Mockup to this issue
If you were logged in you would be able to see more operations.
Moodle

Upgrade to moodle 1.9.x from 1.8 stalls

Created: 12/Jul/08 01:21 AM   Updated: 23/Jan/09 06:51 AM
Return to search
Component/s: Quiz
Affects Version/s: 1.9.2
Fix Version/s: 1.9.1

File Attachments: 1. Text File 0001-Notify-before-processing-quiz-grades.patch (0.8 kB)
2. Text File 0002-Prevent-browser-timeouts-when-upgrading-grades.patch (1 kB)

Issue Links:
Cloners
 

Participants: Andrea Bicciolo, Chris Bandy, Petr Skoda and Tim Hunt
Security Level: None
Resolved date: 13/Jul/08
Affected Branches: MOODLE_19_STABLE
Fixed Branches: MOODLE_19_STABLE


 Description  « Hide
When trying to update a Moodle 1.8 (latest build) containing course with more than 2500 quiz attempts, the upgrade procedure stops silently after several minutes.

Tried to increase the memory limit without success.

If needed, I can provide credentials for a test site.

 All   Comments   Change History   Version Control      Sort Order: Ascending order - Click to sort in descending order
Tim Hunt added a comment - 12/Jul/08 04:17 PM
If it fails silently, how do you know it is the quiz that is causing the problem? There must be some indication how far the upgrade got? What was the previous SQL statement that succeeded, and hence which is the one that failed? (moodledata/upgradelogs)

Andrea Bicciolo added a comment - 13/Jul/08 02:09 AM
Hi Tim, thank you for letting me reflect and make further investigation. Tried again to update the 1.8 Database (either Moodel version are at teh latest weekly build).

The last ouput in the web interface are::
quiz module needs upgrading
(mysql): SELECT id FROM mdl_question_numerical_units WHERE id > (SELECT MIN(iqnu.id) FROM mdl_question_numerical_units iqnu WHERE iqnu.question = mdl_question_numerical_units.question AND iqnu.unit = mdl_question_numerical_units.unit) (mysql): SHOW TABLES (mysql): SHOW INDEX FROM mdl_question_numerical_units (mysql): CREATE UNIQUE INDEX mdl_quesnumeunit_queuni_uix ON mdl_question_numerical_units (question, unit)
Operazione eseguita con successo
(mysql): ALTER TABLE mdl_quiz MODIFY COLUMN timelimit BIGINT(10) unsigned NOT NULL DEFAULT 0 after timemodified
Operazione eseguita con successo

and this from the upgradelogs:
resource module needs upgrading
resource tabelle sono state impostate correttamente
scorm module needs upgrading
scorm tabelle sono state impostate correttamente
survey module needs upgrading
survey tabelle sono state impostate correttamente
wiki module needs upgrading
wiki tabelle sono state impostate correttamente
workshop module needs upgrading
workshop tabelle sono state impostate correttamente

Looks like the problem is eleswhere.


Tim Hunt added a comment - 13/Jul/08 06:32 AM
Resolving, as per last comment.

Andrea Bicciolo added a comment - 14/Jul/08 03:40 PM - edited
Reopening, even if it is not a Quiz Bug, I think there are some issue to be further investigated. The stall problem persists.

Andrea Bicciolo added a comment - 14/Jul/08 03:40 PM
Assigning to Petr

Chris Bandy added a comment - 30/Aug/08 07:43 AM
We experienced this during our upgrade and discovered it is simply a browser/server timeout. These patches (1.) provide a notice before the time consuming process of converting quiz grades and (2.) prevent the browser timeout.