WARNING The app is listening on the incorrect address and will not be reachable by fly-proxy. You can fix this by configuring your app to listen on the following addresses: - 0.0.0.0:3000

[furukawaeiichi]

@pavel

Do you see anything in the logs when you try to make a request to your app?

Thank you kindly for your help.
The following are displayed.

Caused by:
PG::ConnectionBad: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.

fly logs
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.3/lib/active_record/connection_adapters/abstract/connection_pool.rb:700:in `checkout_new_connection'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.3/lib/active_record/connection_adapters/abstract/connection_pool.rb:679:in `try_to_checkout_new_connection'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.3/lib/active_record/connection_adapters/abstract/connection_pool.rb:640:in `acquire_connection'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.3/lib/active_record/connection_adapters/abstract/connection_pool.rb:341:in `checkout'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.3/lib/active_record/connection_adapters/abstract/connection_pool.rb:181:in `connection'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.3/lib/active_record/connection_adapters/abstract/connection_handler.rb:211:in `retrieve_connection'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.3/lib/active_record/connection_handling.rb:313:in `retrieve_connection'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.3/lib/active_record/connection_handling.rb:280:in `connection'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.3/lib/active_record/tasks/database_tasks.rb:262:in `migrate'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.3/lib/active_record/tasks/database_tasks.rb:196:in `block in prepare_all'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.3/lib/active_record/tasks/database_tasks.rb:557:in `block (2 levels) in each_current_configuration'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.3/lib/active_record/tasks/database_tasks.rb:554:in `each'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.3/lib/active_record/tasks/database_tasks.rb:554:in `block in each_current_configuration'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.3/lib/active_record/tasks/database_tasks.rb:553:in `each'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.3/lib/active_record/tasks/database_tasks.rb:553:in `each_current_configuration'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.3/lib/active_record/tasks/database_tasks.rb:191:in `prepare_all'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.3/lib/active_record/railties/databases.rake:391:in `block (2 levels) in <main>'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/rake-13.0.6/lib/rake/task.rb:281:in `block in execute'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/rake-13.0.6/lib/rake/task.rb:281:in `each'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/rake-13.0.6/lib/rake/task.rb:281:in `execute'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/rake-13.0.6/lib/rake/task.rb:219:in `block in invoke_with_call_chain'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/rake-13.0.6/lib/rake/task.rb:199:in `synchronize'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/rake-13.0.6/lib/rake/task.rb:199:in `invoke_with_call_chain'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/rake-13.0.6/lib/rake/task.rb:188:in `invoke'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/rake-13.0.6/lib/rake/application.rb:160:in `invoke_task'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/rake-13.0.6/lib/rake/application.rb:116:in `block (2 levels) in top_level'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/rake-13.0.6/lib/rake/application.rb:116:in `each'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/rake-13.0.6/lib/rake/application.rb:116:in `block in top_level'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/rake-13.0.6/lib/rake/application.rb:125:in `run_with_threads'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/rake-13.0.6/lib/rake/application.rb:110:in `top_level'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/railties-7.0.4.3/lib/rails/commands/rake/rake_command.rb:24:in `block (2 levels) in perform'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/rake-13.0.6/lib/rake/application.rb:186:in `standard_exception_handling'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/railties-7.0.4.3/lib/rails/commands/rake/rake_command.rb:24:in `block in perform'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/rake-13.0.6/lib/rake/rake_module.rb:59:in `with_application'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/railties-7.0.4.3/lib/rails/commands/rake/rake_command.rb:18:in `perform'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/railties-7.0.4.3/lib/rails/command.rb:51:in `invoke'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/railties-7.0.4.3/lib/rails/commands.rb:18:in `<main>'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/bootsnap-1.16.0/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:32:in `require'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]Caused by:
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]PG::ConnectionBad: server closed the connection unexpectedly
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]	This probably means the server terminated abnormally
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]	before or while processing the request.
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/pg-1.5.3/lib/pg/connection.rb:696:in `async_connect_or_reset'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/pg-1.5.3/lib/pg/connection.rb:824:in `connect_to_hosts'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/pg-1.5.3/lib/pg/connection.rb:759:in `new'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/pg-1.5.3/lib/pg.rb:63:in `connect'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.3/lib/active_record/connection_adapters/postgresql_adapter.rb:78:in `new_client'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.3/lib/active_record/connection_adapters/postgresql_adapter.rb:37:in `postgresql_connection'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.3/lib/active_record/connection_adapters/abstract/connection_pool.rb:656:in `public_send'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.3/lib/active_record/connection_adapters/abstract/connection_pool.rb:656:in `new_connection'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.3/lib/active_record/connection_adapters/abstract/connection_pool.rb:700:in `checkout_new_connection'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.3/lib/active_record/connection_adapters/abstract/connection_pool.rb:679:in `try_to_checkout_new_connection'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.3/lib/active_record/connection_adapters/abstract/connection_pool.rb:640:in `acquire_connection'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.3/lib/active_record/connection_adapters/abstract/connection_pool.rb:341:in `checkout'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.3/lib/active_record/connection_adapters/abstract/connection_pool.rb:181:in `connection'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.3/lib/active_record/connection_adapters/abstract/connection_handler.rb:211:in `retrieve_connection'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.3/lib/active_record/connection_handling.rb:313:in `retrieve_connection'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.3/lib/active_record/connection_handling.rb:280:in `connection'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.3/lib/active_record/tasks/database_tasks.rb:262:in `migrate'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.3/lib/active_record/tasks/database_tasks.rb:196:in `block in prepare_all'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.3/lib/active_record/tasks/database_tasks.rb:557:in `block (2 levels) in each_current_configuration'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.3/lib/active_record/tasks/database_tasks.rb:554:in `each'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.3/lib/active_record/tasks/database_tasks.rb:554:in `block in each_current_configuration'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.3/lib/active_record/tasks/database_tasks.rb:553:in `each'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.3/lib/active_record/tasks/database_tasks.rb:553:in `each_current_configuration'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.3/lib/active_record/tasks/database_tasks.rb:191:in `prepare_all'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.4.3/lib/active_record/railties/databases.rake:391:in `block (2 levels) in <main>'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/rake-13.0.6/lib/rake/task.rb:281:in `block in execute'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/rake-13.0.6/lib/rake/task.rb:281:in `each'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/rake-13.0.6/lib/rake/task.rb:281:in `execute'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/rake-13.0.6/lib/rake/task.rb:219:in `block in invoke_with_call_chain'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/rake-13.0.6/lib/rake/task.rb:199:in `synchronize'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/rake-13.0.6/lib/rake/task.rb:199:in `invoke_with_call_chain'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/rake-13.0.6/lib/rake/task.rb:188:in `invoke'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/rake-13.0.6/lib/rake/application.rb:160:in `invoke_task'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/rake-13.0.6/lib/rake/application.rb:116:in `block (2 levels) in top_level'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/rake-13.0.6/lib/rake/application.rb:116:in `each'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/rake-13.0.6/lib/rake/application.rb:116:in `block in top_level'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/rake-13.0.6/lib/rake/application.rb:125:in `run_with_threads'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/rake-13.0.6/lib/rake/application.rb:110:in `top_level'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/railties-7.0.4.3/lib/rails/commands/rake/rake_command.rb:24:in `block (2 levels) in perform'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/rake-13.0.6/lib/rake/application.rb:186:in `standard_exception_handling'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/railties-7.0.4.3/lib/rails/commands/rake/rake_command.rb:24:in `block in perform'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/rake-13.0.6/lib/rake/rake_module.rb:59:in `with_application'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/railties-7.0.4.3/lib/rails/commands/rake/rake_command.rb:18:in `perform'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/railties-7.0.4.3/lib/rails/command.rb:51:in `invoke'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/railties-7.0.4.3/lib/rails/commands.rb:18:in `<main>'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]/rails/vendor/bundle/ruby/3.2.0/gems/bootsnap-1.16.0/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:32:in `require'
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]Tasks: TOP => db:prepare
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info](See full trace by running task with --trace)
2023-05-24T08:01:43Z app[148ed5d2b73e38] nrt [info]Starting clean up.
2023-05-24T08:01:44Z app[148ed5d2b73e38] nrt [info][   64.187187] reboot: Restarting system
2023-05-24T08:01:44Z runner[148ed5d2b73e38] nrt [info]machine did not have a restart policy, defaulting to restart
2023-05-24T08:01:45Z app[148ed5d2b73e38] nrt [info]Starting init (commit: 15f6405)...
2023-05-24T08:01:45Z app[148ed5d2b73e38] nrt [info]Preparing to run: `/rails/bin/docker-entrypoint ./bin/rails server` as rails
2023-05-24T08:01:45Z app[148ed5d2b73e38] nrt [info]2023/05/24 08:01:45 listening on [fdaa:2:1661:a7b:fc:f86c:48:2]:22 (DNS: [fdaa::3]:53)
2023-05-24T08:02:18Z app[148ed5d2b73e38] nrt [info]Sending signal SIGINT to main child process w/ PID 514
2023-05-24T08:02:23Z app[148ed5d2b73e38] nrt [info]Sending signal SIGTERM to main child process w/ PID 514
2023-05-24T08:02:24Z app[148ed5d2b73e38] nrt [info]Starting clean up.
2023-05-24T08:02:25Z app[148ed5d2b73e38] nrt [info][   40.161296] reboot: Restarting system

I am reading and thinking about this because this is an article on a similar issue.

Getting PG::ConnectionBad: PQconsumeInput() server closed the connection unexpectedly in a Rails Sidekiq job

Hello, I migrated a Rails app from Heroku, and in Sidekiq after a long job that takes more than 1 hour to complete I’m getting this error when the job tries to access the Postgres DB: [Screenshot 2023-02-09 at 14.14.28] I’m not seeing anything suspicious in the logs and metrics. Anyone else had a similar problem?

Sidekiq Background Workers