Content
Migrate from Packaged to Docker
Added by Rob A almost 2 years ago
Hi everyone,
I've been running Openproject for several years now based on a packaged install from version 8 or 9. Aside from a few small issues it's been smooth sailing upgrading all the way to the current version.
EDIT: This is an old database that was migrated from MySQL
I have most of my other self-hosted infrastructure running in a 3-node docker swarm now and I wanted to move Openproject to this cluster.
My steps were:
- Stop current instance of Openproject
- Run a full backup using the backup tool
- pg_restore the database into the PG container
- Copy attachments into correct docker volume.
- Start the stack.
Initially there were some LDAP errors but once I recreated my LDAP config and restarted the containers those went away.
No other errors are present on any of the containers.
The problem is that now all projects created after 2019 are missing. I'm assuming it has something to do with some database changes that occurred during one of the many updates over the years.
Is there a way to migrate to docker from a packaged installation?
Is there a way to fix my database so it imports correctly?
Thanks,
Rob
Replies (3)
Hi Rob
please share
1. Current instance of OpenProject
Make a screenshot where a project with Work packages exist which are generated after 2019, please also share your version of OpenProject Packaged
2. Run a full backup using the backup tool
Please log the terminal and share ALL your terminal output
3. pg_restore the database into the PG container
Please log the terminal and share ALL your terminal output
Assuming the steps 4 and 5 you did during your upgrades and assuming you are on version 12.2.5 with your packaged, correct, then please show a screenshot like request in Point 1.
4. Did you migrate the database from MYSQL to PSQL 10? When? Did it work afterwards? This was maybe done in an Upgrade or manually? do you have terminal logs from that time?
5. Did you migrate the database from PSQL 10 to PSQL 13? When? Did it work afterwards? This was maybe done in an Upgrade or manually? do you have terminal logs from that time?
You see it is a little bit too complex for just sharing plain text, terminal logs are necessary here.
Thank you for following up, when you collected all your output
Adam,
I'm really confused, but everything worked the second time.
My steps were:
Stop current instance of OpenprojectThe pg_dump file was about twice the size this time and it restored all of my data into the postgres container.
Thanks for your help.
Rob
Hi Rob,
I am happy to hear it was one of those unknown errors that we cannot investigate anymore in 2022 :) - ghost in the machine
thank you for your feedback