OJS OCS OMP OHS

You are viewing the PKP Support Forum | PKP Home Wiki

PKP Support

Support forums for the Public Knowledge Project

Skip to content


Software Hosting and Development Services available at PKP Publishing Services

As the developers of Open Journal Systems, Open Conference Systems, Open Harvester Systems, and Open Monograph Press, the PKP team are experts in helping journal managers and conference organizers make the most of their online publishing projects. PKP Publishing Services offers support for:

As a customer of PKP Publishing Services, you will not only receive direct, personalized support from the PKP Development Team, but will be contributing to the ongoing development of the PKP applications. All funds raised by PKP Publishing Services go directly toward enhancing our free, open source software. For more information, please contact us.

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, michael, jheckman, barbarah, btbell, bdgregg, asmecher

Forum rules
What to do if you have a technical problem with OJS:

1. Search the forum. You can do this from the Advanced Search Page or from our Google Custom Search, which will search the entire PKP site. If you are encountering an error, we especially recommend searching the forum for said error.

2. Check the FAQ to see if your question or error has already been resolved.

3. Post a question, but please, only after trying the above two solutions. If it's a workflow or usability question you should probably post to the OJS Editorial Support and Discussion subforum; if you have a development question, try the OJS Development subforum.
Post a reply

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
Top

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
Top

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
Top
Post a reply

Return to OJS Technical Support

Who is online

Users browsing this forum: Google [Bot] and 4 guests

Powered by phpBB® Forum Software © phpBB Group