OJS OCS OMP OHS

You are viewing the PKP Support Forum | PKP Home Wiki



upgrading issues

Are you responsible for making OJS work -- installing, upgrading, migrating or troubleshooting? Do you think you've found a bug? Post in this forum.

Moderators: jmacgreg, btbell, michael, bdgregg, barbarah, asmecher

Forum rules
The Public Knowledge Project Support Forum is moving to http://forum.pkp.sfu.ca

This forum will be maintained permanently as an archived historical resource, but all new questions should be added to the new forum. Questions will no longer be monitored on this old forum after March 30, 2015.

upgrading issues

Postby tkalfaoglu » Wed Mar 13, 2013 11:35 pm

Hello. I'm upgrading another OJS site from 2.3.7.0 to 2.4.2..

I downloaded the latest stable, moved the old code elsewhere, except for the "files", "public" and the configuration file.. so it's a clean install, except the database needs to be migrated of course.

The upgrade script has been running for over an hour on a very fast server; like 8 CPU's, RAID drives, etc. The database is not that big; sql dump is 91MB..
The funny thing is, the "top" command does not show anything related to my migrate as using lots of anything. It seems to be waiting for something to happen. It is queued, but not running like crazy -- nor MySQL for that matter.
Is that normal?

Here is what I have so far:
(I have a more liberal php.ini at the current location, hence the -c . command):

# php -c . tools/upgrade.php upgrade
[pre-install]
[load: upgrade.xml]
[version: 2.4.2.0]
[schema: lib/pkp/xml/schema/signoff.xml]
[data: dbscripts/xml/upgrade/2.4.0_preupdate_article_files.xml]
[data: dbscripts/xml/upgrade/2.4.0_preupdate_emaillog.xml]
[data: dbscripts/xml/upgrade/2.4.0_preupdate_reviewrounds.xml]
[data: dbscripts/xml/upgrade/2.4.0_idupgrade_issues.xml]
[data: dbscripts/xml/upgrade/2.4.0_idupgrade_articles.xml]
[data: dbscripts/xml/upgrade/2.4.0_idupgrade_published_articles.xml]
[data: dbscripts/xml/upgrade/2.4.0_idupgrade_issue_galleys.xml (skipped)]
[data: dbscripts/xml/upgrade/2.4.0_idupgrade_article_galleys.xml]
[data: dbscripts/xml/upgrade/2.4.0_idupgrade_supp_files.xml]
[data: dbscripts/xml/upgrade/2.4.0_notifications.xml]
[schema: lib/pkp/xml/schema/common.xml]
[schema: lib/pkp/xml/schema/groups.xml]
[schema: lib/pkp/xml/schema/log.xml]
[schema: lib/pkp/xml/schema/announcements.xml]
[schema: lib/pkp/xml/schema/scheduledTasks.xml]
[schema: lib/pkp/xml/schema/temporaryFiles.xml]
[schema: lib/pkp/xml/schema/metadata.xml]
[schema: lib/pkp/xml/schema/reviews.xml]
[schema: lib/pkp/xml/schema/reviewForms.xml]
[schema: lib/pkp/xml/schema/controlledVocab.xml]
[schema: lib/pkp/xml/schema/submissions.xml]
[schema: lib/pkp/xml/schema/comments.xml]
[schema: lib/pkp/xml/schema/notes.xml]
[schema: lib/pkp/xml/schema/gifts.xml]
[schema: lib/pkp/xml/schema/mutex.xml]
[schema: lib/pkp/xml/schema/tombstone.xml]
[schema: dbscripts/xml/ojs_schema.xml]
[data: dbscripts/xml/indexes.xml]
[code: Installer Installer::installEmailTemplate]
[code: Installer Installer::installEmailTemplate]
[code: Installer Installer::installEmailTemplate]
[code: Installer Installer::installEmailTemplate]
[code: Installer Installer::installEmailTemplate]
[code: Installer Installer::installEmailTemplate]
[code: Installer Installer::installEmailTemplate]
[data: dbscripts/xml/upgrade/2.4.0_idupgrade_issues2.xml]
[data: dbscripts/xml/upgrade/2.4.0_idupgrade_articles2.xml]
[data: dbscripts/xml/upgrade/2.4.0_idupgrade_published_articles2.xml]
[data: dbscripts/xml/upgrade/2.4.0_idupgrade_issue_galleys2.xml (skipped)]
[data: dbscripts/xml/upgrade/2.4.0_idupgrade_article_galleys2.xml]
[data: dbscripts/xml/upgrade/2.4.0_idupgrade_supp_files2.xml]
[data: lib/pkp/xml/mutexData.xml]
[data: dbscripts/xml/upgrade/2.4.0_update.xml]
[note: docs/release-notes/README-2.4.0]
[code: Installer Installer::migrateNotifications]

(stuck here for an hour now.. what shall I do?)
tkalfaoglu
 
Posts: 12
Joined: Wed Feb 27, 2013 10:54 am

Re: upgrading issues

Postby tkalfaoglu » Thu Mar 14, 2013 4:03 am

It's been over 3 hours now, the upgrade is still stuck at the same position..

(...)
[data: dbscripts/xml/indexes.xml]
[code: Installer Installer::installEmailTemplate]
[code: Installer Installer::installEmailTemplate]
[code: Installer Installer::installEmailTemplate]
[code: Installer Installer::installEmailTemplate]
[code: Installer Installer::installEmailTemplate]
[code: Installer Installer::installEmailTemplate]
[code: Installer Installer::installEmailTemplate]
[data: dbscripts/xml/upgrade/2.4.0_idupgrade_issues2.xml]
[data: dbscripts/xml/upgrade/2.4.0_idupgrade_articles2.xml]
[data: dbscripts/xml/upgrade/2.4.0_idupgrade_published_articles2.xml]
[data: dbscripts/xml/upgrade/2.4.0_idupgrade_issue_galleys2.xml (skipped)]
[data: dbscripts/xml/upgrade/2.4.0_idupgrade_article_galleys2.xml]
[data: dbscripts/xml/upgrade/2.4.0_idupgrade_supp_files2.xml]
[data: lib/pkp/xml/mutexData.xml]
[data: dbscripts/xml/upgrade/2.4.0_update.xml]
[note: docs/release-notes/README-2.4.0]
[code: Installer Installer::migrateNotifications]
tkalfaoglu
 
Posts: 12
Joined: Wed Feb 27, 2013 10:54 am

Re: upgrading issues

Postby tkalfaoglu » Thu Mar 14, 2013 4:12 am

I found that the notifications_old table had 500,000 rows.
I interrupted the migration, restored the database, deleted all notifications, and now running the migration again..

Update: It just completed successfully.
tkalfaoglu
 
Posts: 12
Joined: Wed Feb 27, 2013 10:54 am


Return to OJS Technical Support

Who is online

Users browsing this forum: Google [Bot] and 1 guest