Ghost: Crashing

[will]

I've had a few instances of ghost go down recently, logs show this error repeating.
MigrationsAreLockedError: Migrations are running at the moment. Please wait that the lock get`s released.
I've never had issues with Ghost like this before. This site happens to be empty, so I'm not losing any data. This is the second site to die recently due to this issue. Anyone else seeing this?

[murgero]

@will How long have you waited though for it to come up, the error message almost makes it sound like ghosts it updating or something?

Edit: See the following link for a fix: https://github.com/TryGhost/Ghost/issues/9404#issuecomment-358664633

[girish]

@will I think there is some "race" in the Cloudron package. We haven't been able to nail down why this happens (it happens when we push Ghost updates to some sites...). The fix is simple.

• Put the app in repair mode. Repair -> Enable Recovery Mode.
• Open Web terminal and click the MySQL button and press enter. Paste command below.
  • UPDATE migrations_lock set locked=0 where lock_key='km01';
• Repair -> Disable repair mode

[girish]

This issue is same as https://git.cloudron.io/cloudron/ghost-app/-/issues/2 which I thought I had fixed but looks like it's come back...

[will]

@girish Thanks for the quick turn around on a fix!

[tshirt-chihuahu]

One note for others: I had this problem and followed the above instructions from Girish, and it didn't work the first 2 times for some reason. And on the third it did. I'm not sure why. App now restarts fine.

[tshirt-chihuahu]

@girish Should we expect this to happen every time a ghost update is pushed? Or after running this fix will it prevent future occurrences of this?

I'd rather freeze updates than have this randomly knock out my content site.

[girish]

@tshirt-chihuahu It should rarely happen (but it happens). I will put the workaround in the package itself. It seems that workaround works quite reliably for a couple of years now.