upgrade memo 23.2 > 24.2 MYSQL error : Can't drop column tags.

[activ8xpgithub]

Describe the bug

ERROR failed to migrate error="Error 1091 (42000): Can't DROP COLUMN tags; check that it exists\nfailed to execute statement\ngithub.com/usememos/memos/store.(*Store).execute\n\t/backend-build/store/

Steps to reproduce

upgrade docker from 23.2 to latest

The version of Memos you're using

23.2

Screenshots or additional context

No response

[shagr4th]

duplicate of #4365 , which is the error at the first container start. This error is showing at the second restart and is a consequence of the first failure

[johnnyjoygh]

which is the error at the first container start. This error is showing at the second restart and is a consequence of the first failure

All migration scripts(in a same version) of memos will be executed within a transaction, and it will only commit after everything is completed. So it shouldn’t be related to the count of server starts.

https://github.com/usememos/memos/blob/main/store/migrator.go#L94

[shagr4th]

All migration scripts(in a same version) of memos will be executed within a transaction, and it will only commit after everything is completed. So it shouldn’t be related to the count of server starts.

Most DDL queries are auto-commited by defaut, you can't encapsulate several of them in a single transaction

[johnnyjoygh]

@shagr4th Thanks, TIL.

[activ8xpgithub]

So, I am not sure how to fix, going back to 23.1 it's fine, but every time I pull down stable or latest I still get the same
error of can't drop column tags.