My metabase is not able to start reporting nginx err. I ran the commands to restart nginx and metabase but still doesn't work. I checked the metabase log and appears that 'Database has migration lock; cannot run migrations. You can force-release these locks by running `java -jar metabase.jar migrate release-locks'. I then shutdown metabase services and run the 'java -jar /root/metabase/metabase.jar migrate release-locks' command and 'systemctl start metabase' command, the webpage still can't open and report the same nginx error... Just for context I have update some system services (including kernal) a few days ago and havn't restarted the server yet - Could this be the root cause?
Jan 13 18:54:53 VM-8-11-centos metabase: 2024-01-13 18:54:53,995 INFO driver.impl :: #033[34mRegistered driver :presto-jdbc#033[0m (parents: [:sql-jdbc]) <U+1F69A>
Jan 13 18:54:53 VM-8-11-centos metabase: 2024-01-13 18:54:53,996 INFO metabase.core :: Setting up and migrating Metabase DB. Please sit tight, this may take a minute...
Jan 13 18:54:53 VM-8-11-centos metabase: 2024-01-13 18:54:53,998 INFO db.setup :: #033[36mVerifying mysql Database Connection ...#033[0m
Jan 13 18:54:54 VM-8-11-centos metabase: 2024-01-13 18:54:54,108 INFO db.setup :: Successfully verified MySQL 8.0.29 application database connection. <U+2705>
Jan 13 18:54:54 VM-8-11-centos metabase: 2024-01-13 18:54:54,109 INFO db.setup :: Running Database Migrations...
Jan 13 18:54:54 VM-8-11-centos metabase: 2024-01-13 18:54:54,110 INFO db.setup :: Setting up Liquibase...
Jan 13 18:54:54 VM-8-11-centos metabase: 2024-01-13 18:54:54,315 INFO db.setup :: Liquibase is ready.
Jan 13 18:54:54 VM-8-11-centos metabase: 2024-01-13 18:54:54,315 INFO db.liquibase :: Checking if Database has unrun migrations...
Jan 13 18:54:55 VM-8-11-centos metabase: 2024-01-13 18:54:55,268 INFO db.liquibase :: Database has unrun migrations. Waiting for migration lock to be cleared...
Jan 13 18:54:57 VM-8-11-centos metabase: 2024-01-13 18:54:57,288 WARN util.jvm :: #033[31mauto-retry metabase.db.liquibase$wait_for_migration_lock_to_be_cleared$fn__46145@5d7ae91f: Database has migration lock; cannot run migrations. You can force-release these locks by running java -jar metabase.jar migrate release-locks.#033[0m
Jan 13 18:54:59 VM-8-11-centos metabase: 2024-01-13 18:54:59,303 WARN util.jvm :: #033[31mauto-retry metabase.db.liquibase$wait_for_migration_lock_to_be_cleared$fn__46145@5d7ae91f: Database has migration lock; cannot run migrations. You can force-release these locks by running java -jar metabase.jar migrate release-locks.#033[0m