Database 'default' is in an inconsistent state!

555 views
Skip to first unread message

roth.st...@gmail.com

unread,
Jan 11, 2018, 4:22:36 AM1/11/18
to Play Framework
So I deployed my Play App to the Heroku Service. The app needs to be connected the Postgresql Database. 
So when I try to run the App on the Heroku Service, I get the error:

play.api.db.evolutions.DefaultEvolutionsApi - ERROR: relation "fixed_data" already exists [ERROR:0, SQLSTATE:42P07]

Database 'default' is in an inconsistent state!


I think I have to mark it as solved. And when I run the application locally on my computer that just works fine. But how can I mark it as resolved on the heroku service? Is there some kind of -Dplay.automark=true command or something like that? Or would it help if I completely disable the evolutions, and if so how can I do that?


Thanks in Adavance

Stefan

Marcos Pereira

unread,
Jan 15, 2018, 4:17:44 PM1/15/18
to play-fr...@googlegroups.com
Hi,

You have some error in one of your evolutions:

ERROR: relation "fixed_data" already exists [ERROR:0, SQLSTATE:42P07]

That means your evolution is trying to create a relation that already exists. You are not seeing it locally because your local DB is in another state, probably. If you can take a snapshot from your Heroku database and run the application against it locally, maybe you can see better what is happening.

Best.


--
You received this message because you are subscribed to the Google Groups "Play Framework" group.
To unsubscribe from this group and stop receiving emails from it, send an email to play-framework+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/play-framework/3bf4a986-8128-4986-87d9-b21fec46aef3%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.



--
Marcos Pereira
Software Engineer, Lightbend.com

Reply all
Reply to author
Forward
0 new messages