Resolving Database Dirty State Error in Phoenix App on Ubuntu

Ruchika B. · 2024-07-11T09:16:58.425Z

Hi, Getting the below error while pointing to DB The database may be in a dirty state. To resolve this, the Alembic CLI can be used from the src/phoenix/db directory inside the Phoenix project root. From here, revert any partial migrations and run alembic stamp to reset the migration state, then try starting Phoenix again. i am unable to find src/phoenix/db on my local machine i am running my app on a ubuntu server Can someone help

Dustin N.
·
This issue usually only happens if you've installed an experimental release and have encountered conflicting migrations. Is this the first time starting phoenix on this machine? Or have you been using this database for a while?
Dustin N.
·
One way to resolve this is to simply delete your database and start over, even though you'll lose all your data. Manually resolving broken migrations depends on exactly what is going wrong
Ruchika B.
·
I have been using this database for a while but I can’t afford to delete the data bcoz it has data other than Phoenix as well
Dustin N.
·
Unfortunately it probably means you've run a database operation or installed an experimental version of phoenix prior to being finalized. You'll need to carefully step through the migration that's failing and manually fix any conflicts that are preventing the migration from taking place
Ruchika B.
·
Experimental version as in ?
Ruchika B.
·
Do I need to install other Phoenix version but I have the latest only
Ruchika B.
·
What steps I m just getting an error as no running event on loop
Dustin N.
·
Is it possible you can get me more information? Just the error message is not enough for me to help diagnose what's going on
Dustin N.
·
Experimental versions are any build of phoenix that isn't properly tagged as a release
Dustin N.
·
sometimes we were publish docker images off of experimental builds
Dustin N.
·
but if they aren't a release build then any migrations in them are experimental and might be changed by the time we release it
Ruchika B.
·
So you just tell me which version should I install so that this error don’t come
Ruchika B.
·
For the details I am trying to connect to the azure Postgres DB and the error is this only which I am getting
Dustin N.
·
Sorry, what I mean is that if you previously installed an unsupported version you may have migrated the database into a state that can no longer be migrated. It's not a matter of installing the right version but instead undoing the incompatible changes to the database, which may inevitably be destructive, depending on what happened
Ruchika B.
·
But this is the first time I have installed Phoenix there

26 comments