Upgrade never completes - Mysql CPU usage stays at 90-95%

[simon]

Hello

I was trying to upgrade OJS from version 2.0.1 to 2.0.2. I ran the command line tool for upgrade. However the upgrade process never seems to complete. Here is the output:

-----------------------------
# php tools/upgrade.php upgrade
Content-type: text/html
X-Powered-By: PHP/4.3.9

[load: upgrade.xml]
[version: 2.0.2.1]
[data: upgrade/2.0.2_preupdate.xml]
[schema: ojs_schema.xml]
[data: upgrade/2.0.2_update.xml]
[code: Installer Installer::rebuildSearchIndex]

----------------------------------------
The updater appears to be hung at this point. I waited for about half an hour and nothings changed. I also tried updating from the web interface and got the same reult (i.e. never completed). In the mean time, while the upgarde was supposed to be taking place the CPU usage of mysql server went to 90-95%% and stayed there. I have hosted only one journal and it does not even have many articles, only about 30-40 articles. Can someone suggest what might be causing this? Thanks.

[asmecher]

Hello Simon,

In my experience the indexing process can take quite a while, although half an hour certainly sounds excessive.

To finish your partially-completed upgrade, you'll have to do two things:

• Update the versions table
• Complete the indexing

To update the versions table, run this in MySQL (assuming you're now using 2.0.2-1):

Code: Select all

update versions set current=0;
insert into versions(major,minor,revision,build,date_installed,current) values(2,0,2,1,now(),1);


You can complete indexing using the tools/rebuildSearchIndex.php script from the command line; my suggestion is that you turn on MySQL logging and check the log file to see if anything meaningful is going on or if there is, in fact, some sort of loop.

Regards,
Alec

[simon]

Hmmm.... Ok, so it looks like the indexing does in fact take very long. I tried it again today. It took about 40 minutes for the indexing, but finally it did complete. I wonder what happens if there are many journals and thousands of articles.

[asmecher]

Hi Simon,

Glad to hear your installation is back up and running. So far the indexing process hasn't been an issue, but I'll look into its performance.

Incidentally, one of the changes we're looking at making for the next major release is pluggable indexing and searching.

Regards,
Alec Smecher

[asmecher]

Note: Indexing performance issues have been addressed via creation of an index. See related bugzilla entry:

http://pkp.sfu.ca/bugzilla/show_bug.cgi?id=1892

This fix will be released with the next 2.0.x build.

Regards,
Alec