Can not upgrade Ghost nor export content

[hamza_m]

Fill out the following bug report template with as much detail as possible!

Are you sure this is a bug? If you just need help, post in the developer help category. If it’s a feature request, head to the ideas category.

---

Issue Summary

• Explain roughly what’s wrong
• What did you expect to happen?

First i could not backup my content, everytime I try to export the content, the Ghost crashes and restarts,

Also, I could not upgrade Ghost for about a month of so now, always with the following error:

A GhostError occurred.

Message: Ghost was able to start, but errored during boot with: Migration lock was never released or currently a migration is running.
Help: If you are sure no migration is running, check your data and if your database is in a broken state, you could run `yarn knex-migrator rollback`.
Suggestion: journalctl -u ghost_104-248-84-14 -n 50

Steps to Reproduce

1. This is the first step…
2. This is the second step, etc.
   I created another droplet on DigitalOcean, created a fresh Ghost install, then restored the SQL dump, to the “ghost_production” database, everything went smooth, however, trying to upgrade it was the same issue.

Upgrade to: “5.98.0”

Stucked Ghost versions on two servers (unable to backup or upgrade):

5.88.2 and 5.89.6.

I tried the same on even a local machine and got the same error.

I ran the log several times and there is nothing list the real issue, as always that i have to run “yarn knex-migrator rollback”.

---

Setup information

Ghost Version
Share which version of Ghost you’re using.

Node.js Version
If self-hosting - share which version of Node.js you’re using.

How did you install Ghost?
Provide some details about your install of Ghost if you are self-hosting.

Provide details of your host & operating system
Include further details about your hosting and OS.

Database type
MySQL 5.7 / MySQL 8 / SQLite 3 / Other

MySQL 8

Browser & OS version
Include if reporting frontend bugs.

Relevant log / error output
Copy and paste any relevant log output. Use backticks to format this into code.

[hamza_m]

After many attempts, It seems I am stuck at version 5.88.2, as I am always getting strange errors especially when using newer versions using the same old Database , as Themes always ignore the ‘slug’ and replace it with the UUID resulting in 404 error.

On the server, i could not export the JSON file, but managed to do so on the local test server, as the remote server always crashes.

The export file is > 150mb, which i could not import it on server as well.

i will try to import it on the local server for latest Ghost version.