SQL migration error on update #5628
Description
Pre-submission Checklist
- I have searched the existing issues and this bug has not been reported yet
- I have tested this issue on the demo site or the latest version
Where did you encounter this bug?
Latest stable version (self-hosted)
Memos Version
v0.26.1
Bug Description
After updating the memos container with docker-compose, I can't connect to the memos server. Docker Logs show the following error messages:
2026/02/13 13:31:30 INFO start migration currentSchemaVersion=0.25.1 targetSchemaVersion=0.26.5 2026/02/13 13:31:30 INFO applying migration file=migration/sqlite/0.26/00__rename_resource_to_attachment.sql version=0.26.1 2026/02/13 13:31:30 ERROR failed to migrate error="SQL logic error: no such table: resource (1)\nfailed to execute statement\ngithub.com/usememos/memos/store.(*Store).execute\n\tgithub.com/usememos/memos/store/migrator.go:343\ngithub.com/usememos/memos/store.(*Store).applyMigrations\n\tgithub.com/usememos/memos/store/migrator.go:193\ngithub.com/usememos/memos/store.
Here's my docker-compose.yml:
services: memos: image: neosmemo/memos:stable <-- also tried with 0.26.1 instead container_name: memos volumes: - ~/.memos/:/var/opt/memos ports: - 5230:5230 restart: always
EDIT: Downgrading to 0.25.3 allows me to access memos. Tags are displayed correctly, existing memos are not. Error message:
server error method=/memos.api.v1.MemoService/ListMemos error="rpc error: code = Internal desc = failed to list attachments"
Steps to Reproduce
- Update version memo:stable (or v0.26.1) using docker-compose.yml
- Can no longer connect to server
Expected Behavior
A connection to the memo server is established. Memos can access database.
Screenshots & Additional Context
- Browser: Firefox 147.0.3 and Brave 1.86.148
- OS: Ubuntu 24.04.4 LTS
- Database: SQLite