Yurii
What could be the problem ?
[error] Postgrex.Protocol (pid<0.3054.0>) disconnected: ** (Postgrex.Error) FATAL 57P01 (admin_shutdown) terminating connection due to administrator command
Thanks! ![]()
Trending in Questions
I’m working on a project that simulates the bumbl example in the programming phoenix book. It acts almost like an email client. We have a...
New
Hello!
Could someone please give me a help/sample code, how to delete a file from s3 using waffle/waffle_ecto from Phoenix app.
I creat...
New
I’m seeing that a list inside a Kino.DataTable will be interpreted as a charlist, even if the Kino.configure() is set to charlists: :as_l...
New
So my question is quite simple and i have found no conclusive answer on forum, google or AI.
Should we use :erlang.float for Integer to ...
New
Hi, I’ve just set up an application with ash_authentication. There is only magic link strategy for now, so there is no confirmation add o...
New
If a change or preparation module uses Ash.Changeset.get_argument/2 or Ash.Query.get_argument/2 (or any of the other get_argument functio...
New
I’m trying to set up Emacs with elixir-ls via lsp-mode and credo via Flycheck. This should mostly be preconfigured as Flycheck picks up c...
New
Other Trending Topics
I am happy to introduce the very α version of the new programming language compiled to BEAM.
Welcome Cure.
It has literally three kille...
New
Hobbes is a low-level distributed database for the Elixir programming language.
Hobbes provides a simple, safe, and scalable storage lay...
New
Hi there! We created Gust: A task orchestrator inspired by Airflow.
For those who have never heard about Aiflow, it’s a Python-based wor...
New
Beam Bots (or just BB for short) is a framework for building fault-tolerant robotics applications in Elixir using familiar OTP patterns. ...
New
Xamal is a deployment tool for Elixir apps that deploys native releases to bare metal servers over SSH. It’s a port of GitHub - basecamp/...
New
Hello everyone. After busy few months I am happy to announce v0.1.0 of Emerge & Solve.
They are GUI (Emerge) and State management (S...
New
Categories:
Sub Categories:
Forums
Popular Tags
- #ecto
- #liveview
- #troubleshooting
- #learning-elixir
- #library
- #deployment
- #erlang
- #testing
- #genserver
- #mix
- #absinthe
- #remote-other
- #otp
- #plug
- #how-to-question
- #macros
- #postgres
- #elixirconf
- #channels
- #exunit
- #discussion
- #code-sync
- #podcasts
- #javascript
- #onsite
- #dialyzer
- #docker
- #authentication
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #ecto-query
- #blog-post
- #elixirconf-us
- #elixir-ls
- #ai
- #phoenix_html
- #iex
- #graphql
- #genstage
- #websockets
- #supervisor
- #advent-of-code
- #distillery
- #processes
- #api
- #forms
- #hex
- #security
- #metaprogramming










Showing Posts 1 to 10- Show Best Posts
- Show All (oldest first)
- Show All (newest first)
joaoevangelista
I would guess someone or something with higher priority send a signal to terminate the postgres server, is it running local or on some cloud ?
stefanchrobot
If this is a Postgres instance in the cloud, this might be an automatic Postgres upgrade.
Yurii
This happens locally and in the cloud.
Yurii
This happens locally and in the cloud
csadewa
Could you connect to your local/cloud postgres instance via pgAdmin? Is it throwing error like that?
If it’s still throwing error like that when you use pgAdmin, then most likely there were problem on the database it self (this is out of my expertise though).
If it’s not throwing error when you use pgAdmin, then most likely your application is doing something which cause the database to shutdown when it’s starting up (i presume?), try looking around your start up code which connect to DB and try to isolate the cause.
csadewa
Googling around for Postgrex FATAL 57P01, it seems like an issue that happen when there were somekind of error (like connection pool exceeded, memory usage over limit), and thus postgres supervisor terminate postgres process.
There were old issue in Oban library which record this Oban seems to be bringing down my application · Issue #72 · oban-bg/oban · GitHub . But the issue has since fixed.
Yurii
This happens even when there is no query in the database
joaoevangelista
OP says it happens in cloud and locally, so installation might not be the problem, maybe the connection configuration, since the application is common between envs?
@Yurii could you paste your Repo configuration? parameters, pool size etc?
Yurii
config :my_app, MyApp.Repo,
adapter: Ecto.Adapters.Postgres,
database: System.get_env(“MYAPP_DB_NAME”),
username: System.get_env(“MYAPP_DB_USERNAME”),
password: System.get_env(“MYAPP_DB_PASSWORD”),
hostname: System.get_env(“MYAPP_DB_HOST”),
types: MyApp.PostgresTypes,
pool: Ecto.Adapters.SQL.Sandbox,
size: 20
joaoevangelista
Are you using this pool in development? Are these configs in the
dev.exsor intest.exs? If you are using these atdev.exsremove the pool configuration and try again, this pool is for test only.