search

superseriousbusiness / gotosocial

Fast, fun, small ActivityPub server.
https://docs.gotosocial.org
GNU Affero General Public License v3.0
3.7k stars 316 forks source link

[bug] SQL migrations not running #3340

Open turtlegarden opened 4 days ago

turtlegarden commented 4 days ago

Describe the bug with a clear and concise description of what the bug is.

The SQL migrations do not seem to have run for one or another reason upon upgrading to 0.17.0 — all new columns and tables are missing and all old “dropped” columns are still existing.

What's your GoToSocial Version?

v0.17.0-rc1

GoToSocial Arch

x86_64 Binary

What happened?

The new columns and tables were not correctly set up under the migrations. The server, upon starting after the migrations, bumped into errors and shut down.

What you expected to happen?

The new SQL columns and tables would be correctly setup

How to reproduce it?

Make a server on a 0.16.x version, post a few statuses, then upgrade to 0.17.0 rc.

Anything else we need to know?

If it's not too much of a pain, could you please list the added/removed tables & columns & data types & defaults? I want to make sure my server works fully again :>

tsmethurst commented 4 days ago

Could you share the error messages you bumped into? It's really not trivial to update all the tables manually since there's a lot of migrations, it's a safer bet to just restore a backup from before the update and try the migrations again, if you're able to do that.

turtlegarden commented 3 days ago

I can try, but it might take a while.