Wed 3 Jun 2020 6:52PM
loomio-worker | could not connect to server: Connection refused
Deleted account
Public
Seen by 52
Hello!
I've successfully installed loomio-deploy following github loomio-deploy instructions.
The server is an Ubuntu 18.04.
The app worked yesterday before setting the crontab. I saw the main loomio page.
Today the app and workers are failing to start due to pg connection refused.
I need some help with that issue. Thanks.
Here are some logs:
loomio-letsencrypt | 2020/06/03 18:27:44 Received event start for container 4073159beb5e
loomio-nginx | dockergen.1 | 2020/06/03 18:27:44 Received event start for container 4073159beb5e
loomio-nginx | dockergen.1 | 2020/06/03 18:27:44 Contents of /etc/nginx/conf.d/default.conf did not change. Skipping notification 'nginx -s reload'
loomio-nginx | dockergen.1 | 2020/06/03 18:27:44 Contents of /etc/nginx/conf.d/default.conf did not change. Skipping notification 'nginx -s reload'
loomio-worker | 2020-06-03T18:27:49.626Z pid=7 tid=goribzl9n INFO: Booting Sidekiq 6.0.7 with redis options {:url=>"redis://redis:6379"}
loomio-worker | could not connect to server: Connection refused
loomio-worker | Is the server running on host "db" (172.17.0.3) and accepting
loomio-worker | TCP/IP connections on port 5432?
loomio-worker | /usr/local/bundle/gems/pg-1.2.3/lib/pg.rb:58:in `initialize'
loomio-worker | /usr/local/bundle/gems/pg-1.2.3/lib/pg.rb:58:in `new'
loomio-worker | /usr/local/bundle/gems/pg-1.2.3/lib/pg.rb:58:in `connect'
loomio-worker | /usr/local/bundle/gems/activerecord-5.2.4.2/lib/active_record/connection_adapters/postgresql_adapter.rb:692:in `connect'
loomio-worker | /usr/local/bundle/gems/activerecord-5.2.4.2/lib/active_record/connection_adapters/postgresql_adapter.rb:223:in `initialize'
loomio-worker | /usr/local/bundle/gems/activerecord-5.2.4.2/lib/active_record/connection_adapters/postgresql_adapter.rb:48:in `new'
loomio-worker | /usr/local/bundle/gems/activerecord-5.2.4.2/lib/active_record/connection_adapters/postgresql_adapter.rb:48:in `postgresql_connection'
loomio-worker | /usr/local/bundle/gems/activerecord-5.2.4.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:830:in `new_connection'
loomio-worker | /usr/local/bundle/gems/activerecord-5.2.4.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:874:in `checkout_new_connection'
loomio-worker | /usr/local/bundle/gems/activerecord-5.2.4.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:853:in `try_to_checkout_new_connection'
loomio-worker | /usr/local/bundle/gems/activerecord-5.2.4.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:814:in `acquire_connection'
loomio-worker | /usr/local/bundle/gems/activerecord-5.2.4.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:538:in `checkout'
loomio-worker | /usr/local/bundle/gems/activerecord-5.2.4.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:382:in `connection'
loomio-worker | /usr/local/bundle/gems/activerecord-5.2.4.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:1033:in `retrieve_connection'
I know I can connect to the pg server:
~/loomio-deploy# /snap/bin/docker exec -it loomio-db psql -h 172.17.0.3 -U postgres
psql (12.2 (Debian 12.2-2.pgdg100+1))
Type "help" for help.
postgres=# exit
Robert Guthrie · Fri 3 Jul 2020 5:04AM
Hi, sorry for the slow reply!
This has been fixed recently. Please update your loomio-deploy repo. We've moved to a new docker-compse format which seems to help with this.