search

rpeden / prefect-docker-compose

A repository that makes it easy to get up and running with Prefect 2 using Docker Compose.
115 stars 23 forks source link

Issues with postresql 15 #2

Closed tintamarre closed 1 year ago

tintamarre commented 1 year ago

Just to mention that I had some issues with your configuration. Specifically, after running the default docker-compose.yml with --profile [orion, agent, client] for a few hours, I received DB errors. My problem seems to be linked with this one: https://github.com/PrefectHQ/prefect/issues/7333#issuecomment-1315891885

I fixed it by returning to SQLite. I don't know if downgrading to postgresql:13 will also solve the issue.

rpeden commented 1 year ago

Thanks for reporting this, @tintamarre! I have yet to run into this when using the latest Postgres, but I will do another round of testing to see if I can reproduce it. Do you remember which specific errors you saw?

tintamarre commented 1 year ago

Unfortunately, I did not inspect any logs. What occurred was that the front-end was no longer able to retrieve data from the DB. It was quite random.

rpeden commented 1 year ago

@tintamarre I'm closing this for now since I haven't been able to reproduce the error with the latest version of Prefect. I will keep testing, though - and I appreciate you taking the time to report the issue.