Phoenix.Endpoint.SyncCodeReloadPlug issues CREATE TABLE even though repo is read-only about phoenix_ecto HOT 5 CLOSED

I'm not sure on the exact use case here, but if you are using the application with a read-only repository, it means that the Ecto.Repo functions which write to the database are not defined.

There is still an expectation that your applications have the correct tables, otherwise it won't function.

https://hexdocs.pm/ecto/Ecto.Repo.html#module-read-only-repositories

from phoenix_ecto.

I'm experiencing the same issue.
The use case for my application for instance is that I connect to a production DB for analytics purposes where only 1 table is exposed in read only mode.

from phoenix_ecto.

@ValedL can you try removing the plug Phoenix.Ecto.CheckRepoStatus line in your endpoint.ex?

from phoenix_ecto.

@Gazler, removing it resolves the issue, thank you!
I do assume that there's some functionality in the plug that is helpful even if the DB is read only. Hope it will be possible to take the read_only: true into consideration.

from phoenix_ecto.

In this case the best is to remove the plug altogether. All the plug does is to create a database and making sure it has been migrated, and none of those actions are useful to you if you are connecting to an external read-only database.

from phoenix_ecto.