we are running 7.4.7 with MySQL DB, looking for steps to upgrade from 7.4.7 to 12.0.0, also, we have mysql database. can we use the same db with latest version of OpenProject, if not then how to migrate from MySQL to PgSQL.

Dear Virendra

please take a look at the Documentation:

https://www.openproject.org/docs/installation-and-operations/misc/upgrading-older-openproject-versions/

Thank you

Dear Adam, thanks for the suggestion, however, we were unable to do it by these steps.

Please read also here, there was a user with OP 5 and they made it.

https://community.openproject.org/topics/15387?r=15388#message-15388

Kindly see the attachment for the error I am getting.

to migrate the DB from MySQL to PSQL I had installed opeproject in Virtual Machine and inserted table vise data from from MYSQL to PSQL. Some of the errors I have resolved. Some are still pending.

Getting another issue while creating child into the migrated User Story/EPIC. Please see attachment.

Hi again, 

First of all you would need to share all steps that you did according to this documentation including terminal log and not on a a screenshot but in an attachment of a log file :)

https://www.openproject.org/docs/installation-and-operations/misc/upgrading-older-openproject-versions/

There we might see which command turns to an error.

Thank you

Hi, I have followed the migration steps, and did it 3-4 times, getting message 'migration unsuccessful. Please check the migration.log'. Please see the screen shot.

2022-09-21T05:10:15+0000: [Worker(host:37bc831a6b46 pid:143)] Job Projects::ReorderHierarchyJob [7f231b9e-fe5b-4151-9152-083939d0e096] from DelayedJob(default) with arguments: [] (id=1479) (queue=default) FAILED (2 prior attempts) with NameError: uninitialized constant Projects::ReorderHierarchyJob
[Worker(host:37bc831a6b46 pid:143)] Job Projects::ReorderHierarchyJob [7f231b9e-fe5b-4151-9152-083939d0e096] from DelayedJob(default) with arguments: [] (id=1479) (queue=default) FAILED permanently because of 3 consecutive failures

2022-09-21T05:10:15+0000: [Worker(host:37bc831a6b46 pid:143)] Job Projects::ReorderHierarchyJob [7f231b9e-fe5b-4151-9152-083939d0e096] from DelayedJob(default) with arguments: [] (id=1479) (queue=default) FAILED permanently because of 3 consecutive failures
[Worker(host:37bc831a6b46 pid:143)] Job Announcements::SchedulerJob [6de9b5d7-86be-45d4-84c2-875d654f4a2f] from DelayedJob(default) with arguments: [{"subject"=>{"_aj_serialized"=>"ActiveJob::Serializers::SymbolSerializer", "value"=>"notifications.update_info_mail.subject"}, "body"=>{"_aj_serialized"=>"ActiveJob::Serializers::SymbolSerializer", "value"=>"notifications.update_info_mail.body"}, "body_header"=>{"_aj_serialized"=>"ActiveJob::Serializers::SymbolSerializer", "value"=>"notifications.update_info_mail.body_header"}, "body_subheader"=>{"_aj_serialized"=>"ActiveJob::Serializers::SymbolSerializer", "value"=>"notifications.update_info_mail.body_subheader"}, "_aj_ruby2_keywords"=>["subject", "body", "body_header", "body_subheader"]}] (id=1478) (queue=default) RUNNING
2022-09-21T05:10:21+0000: [Worker(host:37bc831a6b46 pid:143)] Job Announcements::SchedulerJob [6de9b5d7-86be-45d4-84c2-875d654f4a2f] from DelayedJob(default) with arguments: [{"subject"=>{"_aj_serialized"=>"ActiveJob::Serializers::SymbolSerializer", "value"=>"notifications.update_info_mail.subject"}, "body"=>{"_aj_serialized"=>"ActiveJob::Serializers::SymbolSerializer", "value"=>"notifications.update_info_mail.body"}, "body_header"=>{"_aj_serialized"=>"ActiveJob::Serializers::SymbolSerializer", "value"=>"notifications.update_info_mail.body_header"}, "body_subheader"=>{"_aj_serialized"=>"ActiveJob::Serializers::SymbolSerializer", "value"=>"notifications.update_info_mail.body_subheader"}, "_aj_ruby2_keywords"=>["subject", "body", "body_header", "body_subheader"]}] (id=1478) (queue=default) RUNNING
[Worker(host:37bc831a6b46 pid:143)] Job Announcements::SchedulerJob [6de9b5d7-86be-45d4-84c2-875d654f4a2f] from DelayedJob(default) with arguments: [{"subject"=>{"_aj_serialized"=>"ActiveJob::Serializers::SymbolSerializer", "value"=>"notifications.update_info_mail.subject"}, "body"=>{"_aj_serialized"=>"ActiveJob::Serializers::SymbolSerializer", "value"=>"notifications.update_info_mail.body"}, "body_header"=>{"_aj_serialized"=>"ActiveJob::Serializers::SymbolSerializer", "value"=>"notifications.update_info_mail.body_header"}, "body_subheader"=>{"_aj_serialized"=>"ActiveJob::Serializers::SymbolSerializer", "value"=>"notifications.update_info_mail.body_subheader"}, "_aj_ruby2_keywords"=>["subject", "body", "body_header", "body_subheader"]}] (id=1478) (queue=default) FAILED (2 prior attempts) with NameError: uninitialized constant Announcements

2022-09-21T05:10:30+0000: [Worker(host:37bc831a6b46 pid:143)] Job Announcements::SchedulerJob [6de9b5d7-86be-45d4-84c2-875d654f4a2f] from DelayedJob(default) with arguments: [{"subject"=>{"_aj_serialized"=>"ActiveJob::Serializers::SymbolSerializer", "value"=>"notifications.update_info_mail.subject"}, "body"=>{"_aj_serialized"=>"ActiveJob::Serializers::SymbolSerializer", "value"=>"notifications.update_info_mail.body"}, "body_header"=>{"_aj_serialized"=>"ActiveJob::Serializers::SymbolSerializer", "value"=>"notifications.update_info_mail.body_header"}, "body_subheader"=>{"_aj_serialized"=>"ActiveJob::Serializers::SymbolSerializer", "value"=>"notifications.update_info_mail.body_subheader"}, "_aj_ruby2_keywords"=>["subject", "body", "body_header", "body_subheader"]}] (id=1478) (queue=default) FAILED (2 prior attempts) with NameError: uninitialized constant Announcements
[Worker(host:37bc831a6b46 pid:143)] Job Announcements::SchedulerJob [6de9b5d7-86be-45d4-84c2-875d654f4a2f] from DelayedJob(default) with arguments: [{"subject"=>{"_aj_serialized"=>"ActiveJob::Serializers::SymbolSerializer", "value"=>"notifications.update_info_mail.subject"}, "body"=>{"_aj_serialized"=>"ActiveJob::Serializers::SymbolSerializer", "value"=>"notifications.update_info_mail.body"}, "body_header"=>{"_aj_serialized"=>"ActiveJob::Serializers::SymbolSerializer", "value"=>"notifications.update_info_mail.body_header"}, "body_subheader"=>{"_aj_serialized"=>"ActiveJob::Serializers::SymbolSerializer", "value"=>"notifications.update_info_mail.body_subheader"}, "_aj_ruby2_keywords"=>["subject", "body", "body_header", "body_subheader"]}] (id=1478) (queue=default) FAILED permanently because of 3 consecutive failures
2022-09-21T05:10:30+0000: [Worker(host:37bc831a6b46 pid:143)] Job Announcements::SchedulerJob [6de9b5d7-86be-45d4-84c2-875d654f4a2f] from DelayedJob(default) with arguments: [{"subject"=>{"_aj_serialized"=>"ActiveJob::Serializers::SymbolSerializer", "value"=>"notifications.update_info_mail.subject"}, "body"=>{"_aj_serialized"=>"ActiveJob::Serializers::SymbolSerializer", "value"=>"notifications.update_info_mail.body"}, "body_header"=>{"_aj_serialized"=>"ActiveJob::Serializers::SymbolSerializer", "value"=>"notifications.update_info_mail.body_header"}, "body_subheader"=>{"_aj_serialized"=>"ActiveJob::Serializers::SymbolSerializer", "value"=>"notifications.update_info_mail.body_subheader"}, "_aj_ruby2_keywords"=>["subject", "body", "body_header", "body_subheader"]}] (id=1478) (queue=default) FAILED permanently because of 3 consecutive failures
[Worker(host:37bc831a6b46 pid:143)] 2 jobs processed at 0.0208 j/s, 2 failed
2022-09-21T05:10:31+0000: [Worker(host:37bc831a6b46 pid:143)] 2 jobs processed at 0.0208 j/s, 2 failed

Hi,

you are sharing a problem inside the migrated OpenProject.

please share first the steps how you migrated...

First of all you would need to share all steps that you did according to this documentation including terminal log

https://www.openproject.org/docs/installation-and-operations/misc/upgrading-older-openproject-versions/

I have created a VM.

inside Vagrant VM - copied mysql dump and migration script.

installed docker and then used this command to migrate DB-  /tmp/migrate-from-pre-8.sh 172.17.0.1 /tmp/openproject16sept.sql

it worked successfully until migrating to version 10, when its migrating from 10 to current version 12

I am getting the error, I have mentioned.

Please see the attachment.

Please see also see the below error-

 2.7) Making extra sure primary keys are named correctly
127.0.0.1:11211 failed (count: 0) Errno::ECONNREFUSED: Connection refused - send
DalliError: No server available
127.0.0.1:11211 failed (count: 1) Errno::ECONNREFUSED: Connection refused - send
127.0.0.1:11211 is down
DalliError: No server available
[DEPRECATED] Bundler.environment has been removed in favor of Bundler.load (called at /app/lib/open_project/plugins/acts_as_op_engine.rb:178)
hook registered
Migrating to EnsurePostgresIndexNames (20190502102512)
== 20190502102512 EnsurePostgresIndexNames: reverting =========================
== 20190502102512 EnsurePostgresIndexNames: reverted (0.0000s) ================

Did you read this documentation?

10 to 12 is PSQL 10 to PSQL 13

https://www.openproject.org/docs/installation-and-operations/misc/migration-to-postgresql13/