ActiveRecord::ConnectionNotEstablished: could not connect to server: No such file or directory

1 
➜  what-to-do-in git:(main) ✗ flyctl logs
2022-12-10T15:10:25Z runner[873f40c3] mia [info]Starting instance
2022-12-10T15:10:25Z runner[873f40c3] mia [info]Configuring virtual machine
2022-12-10T15:10:25Z runner[873f40c3] mia [info]Pulling container image
2022-12-10T15:10:25Z runner[873f40c3] mia [info]Unpacking image
2022-12-10T15:10:25Z runner[873f40c3] mia [info]Preparing kernel init
2022-12-10T15:10:25Z runner[873f40c3] mia [info]Configuring firecracker
2022-12-10T15:10:25Z runner[873f40c3] mia [info]Starting virtual machine
2022-12-10T15:10:25Z app[873f40c3] mia [info]Starting init (commit: f447594)...
2022-12-10T15:10:25Z app[873f40c3] mia [info]Setting up swapspace version 1, size = 512 MiB (536866816 bytes)
2022-12-10T15:10:25Z app[873f40c3] mia [info]no label, UUID=1a30f22e-7156-4b8e-85de-6880c4649808
2022-12-10T15:10:25Z app[873f40c3] mia [info]Preparing to run: `bundle exec rails db:migrate` as root
2022-12-10T15:10:25Z app[873f40c3] mia [info]2022/12/10 15:10:25 listening on [fdaa:0:fe64:a7b:7a:873f:40c3:2]:22 (DNS: [fdaa::3]:53)
2022-12-10T15:10:27Z app[873f40c3] mia [info]rails aborted!
2022-12-10T15:10:27Z app[873f40c3] mia [info]ActiveRecord::ConnectionNotEstablished: could not connect to server: No such file or directory
2022-12-10T15:10:27Z app[873f40c3] mia [info]	Is the server running locally and accepting
2022-12-10T15:10:27Z app[873f40c3] mia [info]	connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/activerecord-7.0.4/lib/active_record/connection_adapters/postgresql_adapter.rb:87:in `rescue in new_client'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/activerecord-7.0.4/lib/active_record/connection_adapters/postgresql_adapter.rb:77:in `new_client'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/activerecord-7.0.4/lib/active_record/connection_adapters/postgresql_adapter.rb:37:in `postgresql_connection'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/activerecord-7.0.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:656:in `public_send'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/activerecord-7.0.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:656:in `new_connection'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/activerecord-7.0.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:700:in `checkout_new_connection'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/activerecord-7.0.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:679:in `try_to_checkout_new_connection'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/activerecord-7.0.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:640:in `acquire_connection'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/activerecord-7.0.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:341:in `checkout'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/activerecord-7.0.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:181:in `connection'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/activerecord-7.0.4/lib/active_record/connection_adapters/abstract/connection_handler.rb:211:in `retrieve_connection'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/activerecord-7.0.4/lib/active_record/connection_handling.rb:313:in `retrieve_connection'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/activerecord-7.0.4/lib/active_record/connection_handling.rb:280:in `connection'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/activerecord-7.0.4/lib/active_record/tasks/database_tasks.rb:262:in `migrate'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/activerecord-7.0.4/lib/active_record/railties/databases.rake:92:in `block (2 levels) in <main>'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/rake-13.0.6/lib/rake/task.rb:281:in `block in execute'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/rake-13.0.6/lib/rake/task.rb:281:in `each'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/rake-13.0.6/lib/rake/task.rb:281:in `execute'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/rake-13.0.6/lib/rake/task.rb:219:in `block in invoke_with_call_chain'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/rake-13.0.6/lib/rake/task.rb:199:in `synchronize'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/rake-13.0.6/lib/rake/task.rb:199:in `invoke_with_call_chain'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/rake-13.0.6/lib/rake/task.rb:188:in `invoke'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/rake-13.0.6/lib/rake/application.rb:160:in `invoke_task'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/rake-13.0.6/lib/rake/application.rb:116:in `block (2 levels) in top_level'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/rake-13.0.6/lib/rake/application.rb:116:in `each'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/rake-13.0.6/lib/rake/application.rb:116:in `block in top_level'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/rake-13.0.6/lib/rake/application.rb:125:in `run_with_threads'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/rake-13.0.6/lib/rake/application.rb:110:in `top_level'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/railties-7.0.4/lib/rails/commands/rake/rake_command.rb:24:in `block (2 levels) in perform'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/rake-13.0.6/lib/rake/application.rb:186:in `standard_exception_handling'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/railties-7.0.4/lib/rails/commands/rake/rake_command.rb:24:in `block in perform'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/rake-13.0.6/lib/rake/rake_module.rb:59:in `with_application'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/railties-7.0.4/lib/rails/commands/rake/rake_command.rb:18:in `perform'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/railties-7.0.4/lib/rails/command.rb:51:in `invoke'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/railties-7.0.4/lib/rails/commands.rb:18:in `<main>'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/bootsnap-1.13.0/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:32:in `require'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/bootsnap-1.13.0/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:32:in `require'
2022-12-10T15:10:27Z app[873f40c3] mia [info]Caused by:
2022-12-10T15:10:27Z app[873f40c3] mia [info]PG::ConnectionBad: could not connect to server: No such file or directory
2022-12-10T15:10:27Z app[873f40c3] mia [info]	Is the server running locally and accepting
2022-12-10T15:10:27Z app[873f40c3] mia [info]	connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/pg-1.4.4/lib/pg/connection.rb:754:in `connect_start'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/pg-1.4.4/lib/pg/connection.rb:754:in `connect_to_hosts'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/pg-1.4.4/lib/pg/connection.rb:695:in `new'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/pg-1.4.4/lib/pg.rb:69:in `connect'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/activerecord-7.0.4/lib/active_record/connection_adapters/postgresql_adapter.rb:78:in `new_client'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/activerecord-7.0.4/lib/active_record/connection_adapters/postgresql_adapter.rb:37:in `postgresql_connection'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/activerecord-7.0.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:656:in `public_send'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/activerecord-7.0.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:656:in `new_connection'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/activerecord-7.0.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:700:in `checkout_new_connection'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/activerecord-7.0.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:679:in `try_to_checkout_new_connection'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/activerecord-7.0.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:640:in `acquire_connection'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/activerecord-7.0.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:341:in `checkout'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/activerecord-7.0.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:181:in `connection'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/activerecord-7.0.4/lib/active_record/connection_adapters/abstract/connection_handler.rb:211:in `retrieve_connection'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/activerecord-7.0.4/lib/active_record/connection_handling.rb:313:in `retrieve_connection'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/activerecord-7.0.4/lib/active_record/connection_handling.rb:280:in `connection'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/activerecord-7.0.4/lib/active_record/tasks/database_tasks.rb:262:in `migrate'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/activerecord-7.0.4/lib/active_record/railties/databases.rake:92:in `block (2 levels) in <main>'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/rake-13.0.6/lib/rake/task.rb:281:in `block in execute'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/rake-13.0.6/lib/rake/task.rb:281:in `each'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/rake-13.0.6/lib/rake/task.rb:281:in `execute'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/rake-13.0.6/lib/rake/task.rb:219:in `block in invoke_with_call_chain'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/rake-13.0.6/lib/rake/task.rb:199:in `synchronize'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/rake-13.0.6/lib/rake/task.rb:199:in `invoke_with_call_chain'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/rake-13.0.6/lib/rake/task.rb:188:in `invoke'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/rake-13.0.6/lib/rake/application.rb:160:in `invoke_task'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/rake-13.0.6/lib/rake/application.rb:116:in `block (2 levels) in top_level'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/rake-13.0.6/lib/rake/application.rb:116:in `each'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/rake-13.0.6/lib/rake/application.rb:116:in `block in top_level'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/rake-13.0.6/lib/rake/application.rb:125:in `run_with_threads'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/rake-13.0.6/lib/rake/application.rb:110:in `top_level'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/railties-7.0.4/lib/rails/commands/rake/rake_command.rb:24:in `block (2 levels) in perform'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/rake-13.0.6/lib/rake/application.rb:186:in `standard_exception_handling'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/railties-7.0.4/lib/rails/commands/rake/rake_command.rb:24:in `block in perform'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/rake-13.0.6/lib/rake/rake_module.rb:59:in `with_application'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/railties-7.0.4/lib/rails/commands/rake/rake_command.rb:18:in `perform'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/railties-7.0.4/lib/rails/command.rb:51:in `invoke'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/railties-7.0.4/lib/rails/commands.rb:18:in `<main>'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/bootsnap-1.13.0/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:32:in `require'
2022-12-10T15:10:27Z app[873f40c3] mia [info]/app/vendor/bundle/ruby/3.1.0/gems/bootsnap-1.13.0/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:32:in `require'
2022-12-10T15:10:27Z app[873f40c3] mia [info]Tasks: TOP => db:migrate
2022-12-10T15:10:27Z app[873f40c3] mia [info](See full trace by running task with --trace)
2022-12-10T15:10:27Z app[873f40c3] mia [info]Starting clean up.

Hello, can anybody help me with this?, thanks

2

Your app is not not attached to a database.

Use flyctl postgres list · Fly Docs to see if you already have a database.

If you haven’t already created one, use flyctl postgres create · Fly Docs . Once you have one attach it to your application with Attach or Detach a Fly App · Fly Docs .

3 
➜  what-to-do-in git:(main) ✗ flyctl postgres list
NAME               	OWNER   	STATUS  	LATEST DEPLOY 
what-to-do-in-v1-db	personal	deployed
4

I did this

flyctl postgres attach --app your-app-name your-app-database-name

and It looks like I have now my server running but I have “500 Internal Server Error” in my web page, what it could be?

5

I had to add

  release_command = "bundle exec rails db:migrate db:seed"

in [deploy]

now, everything is running well, thanks rubys