search

rivenmedia / riven

Handle your Media Library with ease!
https://rivenmedia.github.io/wiki/
GNU General Public License v3.0
323 stars 47 forks source link

Issue upgrading from .11.1 to any newer version #724

Closed menmen01 closed 6 days ago

menmen01 commented 6 days ago

Container crashes with this error 


Generating /riven/data/alembic/2024_09_24_028a2dea708d_auto_upg_20240924012158.py ...  done
24-09-24 01:21:59 | ⚠️  WARNING   | db.run_migrations - Error running migrations: (psycopg2.errors.UndefinedObject) type "states" does not exist
[SQL: ALTER TABLE "MediaItem" ALTER COLUMN last_state TYPE states ]
(Background on this error at: https://sqlalche.me/e/20/f405)
Generating /riven/data/alembic/2024_09_24_061ced26fc2e_auto_upg_20240924012200.py ...  done
24-09-24 01:22:01 | ⚠️  WARNING   | db.run_migrations - Error running migrations: (psycopg2.errors.UndefinedObject) type "states" does not exist
[SQL: ALTER TABLE "MediaItem" ALTER COLUMN last_state TYPE states ]
(Background on this error at: https://sqlalche.me/e/20/f405)
24-09-24 01:22:01 |  CRITICAL  | main.<module> - Server has been stopped

Downgrading allows the container to start

Present on all releases .12 and up

Not the same issue as #722

dreulavelle commented 6 days ago

Thats normal. I mentioned this is an announcement in our Discord that from 0.11.x to 0.12.x needs to have a database reset and their settings file deleted so that Riven can recreate everything. There was a A LOT that changed!

menmen01 commented 6 days ago

Ah ok missed that. Is there a way to migrate the db? What about all the media that is currently being managed?

dreulavelle commented 6 days ago

Don't worry, it will all get reindexed in :)

profucius commented 5 days ago

I mentioned this is an announcement in our Discord

Is there another location that announcements could be made for things like this? Perhaps as a bold header at the top of the github release notes? I struggle with managing all the discords and notifications it brings, but github releases would help me catch things like this quicker.

Edit: I just looked in the Ragnarok discord under the #announcements room and I don't see this announcement. I did find it as a pinned message within #riven, but it did not include @everyone so I wouldn't have been notified.

dreulavelle commented 5 days ago

https://discord.com/channels/1148672013028831352/1199500061151871006/1286779573341520016

But you would of had to of been in the server already when it came out. If I need users to do another reset in the future, I can include it in the release notes though