Moodle Database Migration to Unicode Hangs

Moodle Database Migration to Unicode Hangs

Bởi A.J. Colianni -
Số lượng các câu trả lời: 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.
Trung bình điểm đánh giá: -
Để phản hồi tới A.J. Colianni

Re: Moodle Database Migration to Unicode Hangs

Bởi Howard Miller -
Hình của Core developers Hình của Documentation writers Hình của Particularly helpful Moodlers Hình của Peer reviewers Hình của 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.
Trung bình điểm đánh giá: -
Để phản hồi tới Howard Miller

Re: Moodle Database Migration to Unicode Hangs

Bởi 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.

Trung bình điểm đánh giá: -
Để phản hồi tới A.J. Colianni

Re: Moodle Database Migration to Unicode Hangs

Bởi 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
Trung bình điểm đánh giá: -
Để phản hồi tới Michael Goldblatt

Re: Moodle Database Migration to Unicode Hangs

Bởi 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??
Trung bình điểm đánh giá: -
Để phản hồi tới A.J. Colianni

Re: Moodle Database Migration to Unicode Hangs

Bởi Matt Bostdorff -
Did you ever get this to finish??
Trung bình điểm đánh giá: -
Để phản hồi tới Matt Bostdorff

Re: Moodle Database Migration to Unicode Hangs

Bởi 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

Trung bình điểm đánh giá: -