[ steps ]
- stop artifactory
- stop mysql
- Upgrade Ubuntu 14.04 to 16.07
- Upgrade mysql-server to 5.7
- Downloaded 7.75.5.tar.gz file put it into /opt/jfrog/artifactory
- untared 7.77.5.tar.gz
- removed /opt/jfrog/artifactory/app
- cp -r /opt/jfrog/artifactory/7.77.5/app/* /opt/jfrog/artifactory/app
- started up mysql-server
- started artifactory.
Looking at console.log got to this db error:
"Could not initialize database: org.flyawaydb.core.api.FlywayException: Detected failed migration to version 7.44 (Add Access Permission v2 ref"
Any ideas on what I can check on, do from here?
Thanks!
2
Answers
I was able to get this working:
Make sure to use the same version of artifactory
Follow: https://jfrog.com/help/r/artifactory-what-is-the-best-way-to-migrate-a-large-artifactory-instance-with-minimal-downtime/method-1
Ok, we have at least 3 major issues here. There may be more…
Operating Systems – End of Support
As part of JFrog commitment to maintain the security and reliability of the JFrog Platform, Artifactory will officially run with Node.js 20.x on all installation types from Artifactory 7.77.3.
Node.js 20.x provided with Linux Archive/Debian/RPM installations (non-containerized distributions) is not supported on the following operating systems.
Ubuntu 18.04 (has reached End of Standard Support on May 31, 2023).
You are using Ubuntu 16.07 which is not supported…
Currently Ubuntu 20.04, 22.04 are supported. Full list of supported OS here
There is a known issue with 7.77.x and some MYSQL installations during the PermissionsV2DataMigration due to need for super user permissions by default.
This can be resolved by using 7.77.7 release (coming soon) or with a workaround. But note, this is not your current issue!
Your specific error seems to actually be occurring on an earlier DB migration but I am not 100% sure of the root cause without more logs then what you have shared.
But #1 is an insurmountable issue that must be dealt with first.