Moodle Database Migration to Unicode Hangs

Moodle Database Migration to Unicode Hangs

napisao/la A.J. Colianni -
Number of replies: 6
Hello,

We have just updated to 1.6 from 1.5.3. It appears to have gone smoothly until this point. We would like to run the database migration tool as is recommended, however, after running it, it "hangs" or pauses with no apparent activity in top. This is the message that we see:

1 done.
Resuming migration from: assignment_submissions / .data1, Record: 20

And it will sit here for a long time, without any progress or CPU usage.

Any thoughts?

-A.J.
Prosjek ocjena: -
In reply to A.J. Colianni

Re: Moodle Database Migration to Unicode Hangs

napisao/la Howard Miller -
Slika Core developers Slika Documentation writers Slika Particularly helpful Moodlers Slika Peer reviewers Slika Plugin developers
does the whole web server hang up (can you access pages in another browser window?), or is it just the Moodle upgrade operation? Are you sure it hasn't just stopped? Try turning debugging on in case you get more messages and check the error logs for anything interesting.
Prosjek ocjena: -
In reply to Howard Miller

Re: Moodle Database Migration to Unicode Hangs

napisao/la A.J. Colianni -
I should've posted in the first post:
MySQL - 4.1.16
PHP - 5.1.2

We are still able to access other pages on the site without problem as the admin. Of course, it has gone into maintenance mode at this point so normal users can't get past the front page.

After turning debug info on, and running the migration script again, I see this info:

Processsing db table assignment_submissions...


-->processing db field data1
--->method PLAIN_SQL_UPDATE
(mysql): ALTER TABLE mdl_assignment_submissions CHANGE data1 data1 LONGBLOB  
Success


Total number of records is ..2293
Counter is 16
(mysql): SELECT ass.userid FROM mdl_assignment_submissions ass WHERE ass.id=20 LIMIT 100  
(mysql): SELECT a.course FROM mdl_assignment a, mdl_assignment_submissions ass WHERE a.id = ass.assignment AND ass.id = 20 LIMIT 100  
(mysql): SELECT * FROM mdl_course WHERE id = '14' LIMIT 100  
(mysql): SELECT * FROM mdl_user WHERE id = '33' LIMIT 100 

But it has stopped here for a while without any new progress.

Prosjek ocjena: -
In reply to A.J. Colianni

Re: Moodle Database Migration to Unicode Hangs

napisao/la Michael Goldblatt -
AJ -

Have you found a solution for this? I am having the same problem where I have to re-run the migration tool and each time it picks up where it left off. As near as I can tell, the migration tool runs for 5 minutes (just about exactly) each time and converts a bunch of rows from the database. Initially, it looked like it was converting around 15000 rows each time it ran, but that number has slowly been dwindling to around 5000 rows now. With some tables having 450,000 rows or more, this is starting to get a little annoying.

At any rate, if there is some solution to getting it to migrate a lot more rows at once, I would be open to any suggestions.
For what it's worth, I'm running:
Moodle 1.6.1
MySQL 5.0.27
PHP 5.2.1.2
on IIS 6

Thanks,
Michael
Prosjek ocjena: -
In reply to Michael Goldblatt

Re: Moodle Database Migration to Unicode Hangs

napisao/la Matt Bostdorff -

Guys I'm having the same problem during a conversion from 1.5 to 1.7 and it is behaving the same way.  I get:

Processing: message_read/message (241/134)
Resuming migration from: message_read / .message, Record: 14804
Then no more progress.  Server CPU usage is at 1%.  I try it again, it seems to pick up at a later point, run for a short while - then repeats.  What can we do here??
Prosjek ocjena: -
In reply to A.J. Colianni

Re: Moodle Database Migration to Unicode Hangs

napisao/la Matt Bostdorff -
Did you ever get this to finish??
Prosjek ocjena: -
In reply to Matt Bostdorff

Re: Moodle Database Migration to Unicode Hangs

napisao/la Thomas Tappan -

I am in the process of upgrading a Moodle 1.5 installation to 1.7.1.

Everything appeared to be going very well until I got to the Database Migration section.

The section loaded and the following message was displayed:

Processing: assignment_submissions/data1 (1/163) Ending: 8 hours 8 mins

This message has not changed in over an hour and a half since the process began.

How can I safely restart the process/and or recover safely to a restart point that will continue the process? 

The site is displaying, but of course the system is in maintenance mode and displays the following message:

The site is undergoing maintenance and is currently not available

Prosjek ocjena: -