dial tcp, connection refused error

[Mi97ch]

Hi,
I tried multiple times the installation with docker, following the indication on the ReadMe file, but always got problems after the "docker-compose up -d" command.
As suggested, I inspected the log file and this is the copy:

**{"log":"Importing PGP files from keydump...\n","stream":"stdout","time":"2021-10-15T15:37:27.704130753Z"}
{"log":"dial tcp 172.18.0.3:5432: connect: connection refused\n","stream":"stderr","time":"2021-10-15T15:37:28.040857591Z"}
{"log":"hockeypuck/pghkp.(*storage).createTables\n","stream":"stderr","time":"2021-10-15T15:37:28.053884821Z"}
{"log":"\u0009/hockeypuck/src/hockeypuck/pghkp/storage.go:324\n","stream":"stderr","time":"2021-10-15T15:37:28.054077622Z"}
{"log":"hockeypuck/pghkp.New\n","stream":"stderr","time":"2021-10-15T15:37:28.054095091Z"}
{"log":"\u0009/hockeypuck/src/hockeypuck/pghkp/storage.go:309\n","stream":"stderr","time":"2021-10-15T15:37:28.054107406Z"}
{"log":"hockeypuck/pghkp.Dial\n","stream":"stderr","time":"2021-10-15T15:37:28.054498407Z"}
{"log":"\u0009/hockeypuck/src/hockeypuck/pghkp/storage.go:300\n","stream":"stderr","time":"2021-10-15T15:37:28.054764938Z"}
{"log":"hockeypuck/server.DialStorage\n","stream":"stderr","time":"2021-10-15T15:37:28.054784101Z"}
{"log":"\u0009/hockeypuck/src/hockeypuck/server/server.go:182\n","stream":"stderr","time":"2021-10-15T15:37:28.05491436Z"}
{"log":"main.load\n","stream":"stderr","time":"2021-10-15T15:37:28.054933726Z"}
{"log":"\u0009/hockeypuck/src/hockeypuck/server/cmd/hockeypuck-load/main.go:75\n","stream":"stderr","time":"2021-10-15T15:37:28.054946956Z"}
{"log":"main.main\n","stream":"stderr","time":"2021-10-15T15:37:28.054962179Z"}
{"log":"\u0009/hockeypuck/src/hockeypuck/server/cmd/hockeypuck-load/main.go:70\n","stream":"stderr","time":"2021-10-15T15:37:28.054974414Z"}
{"log":"runtime.main\n","stream":"stderr","time":"2021-10-15T15:37:28.055126473Z"}
{"log":"\u0009/usr/local/go/src/runtime/proc.go:255\n","stream":"stderr","time":"2021-10-15T15:37:28.05527742Z"}
{"log":"runtime.goexit\n","stream":"stderr","time":"2021-10-15T15:37:28.055286629Z"}
{"log":"\u0009/usr/local/go/src/runtime/asm_amd64.s:1581\n","stream":"stderr","time":"2021-10-15T15:37:28.05529296Z"}
{"log":"failed to create tables\n","stream":"stderr","time":"2021-10-15T15:37:28.055299311Z"}
{"log":"hockeypuck/pghkp.New\n","stream":"stderr","time":"2021-10-15T15:37:28.055305459Z"}
{"log":"\u0009/hockeypuck/src/hockeypuck/pghkp/storage.go:311\n","stream":"stderr","time":"2021-10-15T15:37:28.055311749Z"}
{"log":"hockeypuck/pghkp.Dial\n","stream":"stderr","time":"2021-10-15T15:37:28.055317964Z"}
{"log":"\u0009/hockeypuck/src/hockeypuck/pghkp/storage.go:300\n","stream":"stderr","time":"2021-10-15T15:37:28.055324052Z"}
{"log":"hockeypuck/server.DialStorage\n","stream":"stderr","time":"2021-10-15T15:37:28.055330215Z"}
{"log":"\u0009/hockeypuck/src/hockeypuck/server/server.go:182\n","stream":"stderr","time":"2021-10-15T15:37:28.055336344Z"}
{"log":"main.load\n","stream":"stderr","time":"2021-10-15T15:37:28.05534255Z"}
{"log":"\u0009/hockeypuck/src/hockeypuck/server/cmd/hockeypuck-load/main.go:75\n","stream":"stderr","time":"2021-10-15T15:37:28.055348623Z"}
{"log":"main.main\n","stream":"stderr","time":"2021-10-15T15:37:28.055354866Z"}
{"log":"\u0009/hockeypuck/src/hockeypuck/server/cmd/hockeypuck-load/main.go:70\n","stream":"stderr","time":"2021-10-15T15:37:28.0553609Z"}
{"log":"runtime.main\n","stream":"stderr","time":"2021-10-15T15:37:28.055367252Z"}
{"log":"\u0009/usr/local/go/src/runtime/proc.go:255\n","stream":"stderr","time":"2021-10-15T15:37:28.055373309Z"}
{"log":"runtime.goexit\n","stream":"stderr","time":"2021-10-15T15:37:28.055379404Z"}
{"log":"\u0009/usr/local/go/src/runtime/asm_amd64.s:1581\n","stream":"stderr","time":"2021-10-15T15:37:28.055385419Z"}
{"log":"main.load\n","stream":"stderr","time":"2021-10-15T15:37:28.055391568Z"}
{"log":"\u0009/hockeypuck/src/hockeypuck/server/cmd/hockeypuck-load/main.go:77\n","stream":"stderr","time":"2021-10-15T15:37:28.05539762Z"}
{"log":"main.main\n","stream":"stderr","time":"2021-10-15T15:37:28.055403903Z"}
{"log":"\u0009/hockeypuck/src/hockeypuck/server/cmd/hockeypuck-load/main.go:70\n","stream":"stderr","time":"2021-10-15T15:37:28.055409903Z"}
{"log":"runtime.main\n","stream":"stderr","time":"2021-10-15T15:37:28.055416168Z"}
{"log":"\u0009/usr/local/go/src/runtime/proc.go:255\n","stream":"stderr","time":"2021-10-15T15:37:28.055422272Z"}
{"log":"runtime.goexit\n","stream":"stderr","time":"2021-10-15T15:37:28.055442474Z"}
{"log":"\u0009/usr/local/go/src/runtime/asm_amd64.s:1581","stream":"stderr","time":"2021-10-15T15:37:28.205903308Z"}
{"log":"Importing PGP files from keydump...\n","stream":"stdout","time":"2021-10-15T15:37:31.996015649Z"}
{"log":"dial tcp 172.18.0.3:5432: connect: connection refused\n","stream":"stderr","time":"2021-10-15T15:37:32.035280706Z"}
{"log":"hockeypuck/pghkp.(*storage).createTables\n","stream":"stderr","time":"2021-10-15T15:37:32.035321647Z"}
{"log":"\u0009/hockeypuck/src/hockeypuck/pghkp/storage.go:324\n","stream":"stderr","time":"2021-10-15T15:37:32.035332894Z"}
{"log":"hockeypuck/pghkp.New\n","stream":"stderr","time":"2021-10-15T15:37:32.03533956Z"}
{"log":"\u0009/hockeypuck/src/hockeypuck/pghkp/storage.go:309\n","stream":"stderr","time":"2021-10-15T15:37:32.035345598Z"}
{"log":"hockeypuck/pghkp.Dial\n","stream":"stderr","time":"2021-10-15T15:37:32.035351501Z"}
{"log":"\u0009/hockeypuck/src/hockeypuck/pghkp/storage.go:300\n","stream":"stderr","time":"2021-10-15T15:37:32.035357203Z"}
{"log":"hockeypuck/server.DialStorage\n","stream":"stderr","time":"2021-10-15T15:37:32.035363077Z"}
{"log":"\u0009/hockeypuck/src/hockeypuck/server/server.go:182\n","stream":"stderr","time":"2021-10-15T15:37:32.035368784Z"}
{"log":"main.load\n","stream":"stderr","time":"2021-10-15T15:37:32.035374542Z"}
{"log":"\u0009/hockeypuck/src/hockeypuck/server/cmd/hockeypuck-load/main.go:75\n","stream":"stderr","time":"2021-10-15T15:37:32.035380302Z"}
{"log":"main.main\n","stream":"stderr","time":"2021-10-15T15:37:32.035390269Z"}
{"log":"\u0009/hockeypuck/src/hockeypuck/server/cmd/hockeypuck-load/main.go:70\n","stream":"stderr","time":"2021-10-15T15:37:32.035396103Z"}
{"log":"runtime.main\n","stream":"stderr","time":"2021-10-15T15:37:32.035401912Z"}
{"log":"\u0009/usr/local/go/src/runtime/proc.go:255\n","stream":"stderr","time":"2021-10-15T15:37:32.035407564Z"}
{"log":"runtime.goexit\n","stream":"stderr","time":"2021-10-15T15:37:32.03546536Z"}
{"log":"\u0009/usr/local/go/src/runtime/asm_amd64.s:1581\n","stream":"stderr","time":"2021-10-15T15:37:32.035522635Z"}
{"log":"failed to create tables\n","stream":"stderr","time":"2021-10-15T15:37:32.035539333Z"}
{"log":"hockeypuck/pghkp.New\n","stream":"stderr","time":"2021-10-15T15:37:32.035546309Z"}
{"log":"\u0009/hockeypuck/src/hockeypuck/pghkp/storage.go:311\n","stream":"stderr","time":"2021-10-15T15:37:32.035645116Z"}
{"log":"hockeypuck/pghkp.Dial\n","stream":"stderr","time":"2021-10-15T15:37:32.03565679Z"}
{"log":"\u0009/hockeypuck/src/hockeypuck/pghkp/storage.go:300\n","stream":"stderr","time":"2021-10-15T15:37:32.03566346Z"}
{"log":"hockeypuck/server.DialStorage\n","stream":"stderr","time":"2021-10-15T15:37:32.035669369Z"}
{"log":"\u0009/hockeypuck/src/hockeypuck/server/server.go:182\n","stream":"stderr","time":"2021-10-15T15:37:32.035675168Z"}
{"log":"main.load\n","stream":"stderr","time":"2021-10-15T15:37:32.035680975Z"}
{"log":"\u0009/hockeypuck/src/hockeypuck/server/cmd/hockeypuck-load/main.go:75\n","stream":"stderr","time":"2021-10-15T15:37:32.035686684Z"}
{"log":"main.main\n","stream":"stderr","time":"2021-10-15T15:37:32.035692562Z"}
{"log":"\u0009/hockeypuck/src/hockeypuck/server/cmd/hockeypuck-load/main.go:70\n","stream":"stderr","time":"2021-10-15T15:37:32.035698196Z"}
{"log":"runtime.main\n","stream":"stderr","time":"2021-10-15T15:37:32.035704075Z"}
{"log":"\u0009/usr/local/go/src/runtime/proc.go:255\n","stream":"stderr","time":"2021-10-15T15:37:32.035709822Z"}
{"log":"runtime.goexit\n","stream":"stderr","time":"2021-10-15T15:37:32.035715587Z"}
{"log":"\u0009/usr/local/go/src/runtime/asm_amd64.s:1581\n","stream":"stderr","time":"2021-10-15T15:37:32.035721236Z"}
{"log":"main.load\n","stream":"stderr","time":"2021-10-15T15:37:32.035727041Z"}
{"log":"\u0009/hockeypuck/src/hockeypuck/server/cmd/hockeypuck-load/main.go:77\n","stream":"stderr","time":"2021-10-15T15:37:32.035733335Z"}
{"log":"main.main\n","stream":"stderr","time":"2021-10-15T15:37:32.035739229Z"}
{"log":"\u0009/hockeypuck/src/hockeypuck/server/cmd/hockeypuck-load/main.go:70\n","stream":"stderr","time":"2021-10-15T15:37:32.035757948Z"}
{"log":"runtime.main\n","stream":"stderr","time":"2021-10-15T15:37:32.035764284Z"}
{"log":"\u0009/usr/local/go/src/runtime/proc.go:255\n","stream":"stderr","time":"2021-10-15T15:37:32.035769614Z"}
{"log":"runtime.goexit\n","stream":"stderr","time":"2021-10-15T15:37:32.035774971Z"}
{"log":"\u0009/usr/local/go/src/runtime/asm_amd64.s:1581","stream":"stderr","time":"2021-10-15T15:37:32.181990055Z"}
{"log":"Importing PGP files from keydump...\n","stream":"stdout","time":"2021-10-15T15:37:35.488025148Z"}
{"log":"pq: index "pg_shdepend_reference_index" contains unexpected zero page at block 1\n","stream":"stderr","time":"2021-10-15T15:37:35.541577525Z"}
{"log":"hockeypuck/pghkp.(*storage).createTables\n","stream":"stderr","time":"2021-10-15T15:37:35.541615526Z"}
{"log":"\u0009/hockeypuck/src/hockeypuck/pghkp/storage.go:324\n","stream":"stderr","time":"2021-10-15T15:37:35.54162371Z"}
{"log":"hockeypuck/pghkp.New\n","stream":"stderr","time":"2021-10-15T15:37:35.541631111Z"}
{"log":"\u0009/hockeypuck/src/hockeypuck/pghkp/storage.go:309\n","stream":"stderr","time":"2021-10-15T15:37:35.541637683Z"}
{"log":"hockeypuck/pghkp.Dial\n","stream":"stderr","time":"2021-10-15T15:37:35.541644502Z"}
{"log":"\u0009/hockeypuck/src/hockeypuck/pghkp/storage.go:300\n","stream":"stderr","time":"2021-10-15T15:37:35.541651113Z"}
{"log":"hockeypuck/server.DialStorage\n","stream":"stderr","time":"2021-10-15T15:37:35.541657554Z"}
{"log":"\u0009/hockeypuck/src/hockeypuck/server/server.go:182\n","stream":"stderr","time":"2021-10-15T15:37:35.541663902Z"}
{"log":"main.load\n","stream":"stderr","time":"2021-10-15T15:37:35.541670313Z"}
{"log":"\u0009/hockeypuck/src/hockeypuck/server/cmd/hockeypuck-load/main.go:75\n","stream":"stderr","time":"2021-10-15T15:37:35.54168673Z"}
{"log":"main.main\n","stream":"stderr","time":"2021-10-15T15:37:35.541693119Z"}
{"log":"\u0009/hockeypuck/src/hockeypuck/server/cmd/hockeypuck-load/main.go:70\n","stream":"stderr","time":"2021-10-15T15:37:35.541699064Z"}
{"log":"runtime.main\n","stream":"stderr","time":"2021-10-15T15:37:35.541705264Z"}
{"log":"\u0009/usr/local/go/src/runtime/proc.go:255\n","stream":"stderr","time":"2021-10-15T15:37:35.541711303Z"}
{"log":"runtime.goexit\n","stream":"stderr","time":"2021-10-15T15:37:35.541717336Z"}
{"log":"\u0009/usr/local/go/src/runtime/asm_amd64.s:1581\n","stream":"stderr","time":"2021-10-15T15:37:35.541723425Z"}
{"log":"failed to create tables\n","stream":"stderr","time":"2021-10-15T15:37:35.541729535Z"}
{"log":"hockeypuck/pghkp.New\n","stream":"stderr","time":"2021-10-15T15:37:35.5417355Z"}
{"log":"\u0009/hockeypuck/src/hockeypuck/pghkp/storage.go:311\n","stream":"stderr","time":"2021-10-15T15:37:35.541741548Z"}
{"log":"hockeypuck/pghkp.Dial\n","stream":"stderr","time":"2021-10-15T15:37:35.541747601Z"}
{"log":"\u0009/hockeypuck/src/hockeypuck/pghkp/storage.go:300\n","stream":"stderr","time":"2021-10-15T15:37:35.541753544Z"}
{"log":"hockeypuck/server.DialStorage\n","stream":"stderr","time":"2021-10-15T15:37:35.54175959Z"}
{"log":"\u0009/hockeypuck/src/hockeypuck/server/server.go:182\n","stream":"stderr","time":"2021-10-15T15:37:35.54176561Z"}
{"log":"main.load\n","stream":"stderr","time":"2021-10-15T15:37:35.54177168Z"}
{"log":"\u0009/hockeypuck/src/hockeypuck/server/cmd/hockeypuck-load/main.go:75\n","stream":"stderr","time":"2021-10-15T15:37:35.541777592Z"}
{"log":"main.main\n","stream":"stderr","time":"2021-10-15T15:37:35.541783721Z"}
{"log":"\u0009/hockeypuck/src/hockeypuck/server/cmd/hockeypuck-load/main.go:70\n","stream":"stderr","time":"2021-10-15T15:37:35.541789617Z"}
{"log":"runtime.main\n","stream":"stderr","time":"2021-10-15T15:37:35.54179571Z"}
{"log":"\u0009/usr/local/go/src/runtime/proc.go:255\n","stream":"stderr","time":"2021-10-15T15:37:35.541801642Z"}
{"log":"runtime.goexit\n","stream":"stderr","time":"2021-10-15T15:37:35.541807672Z"}
{"log":"\u0009/usr/local/go/src/runtime/asm_amd64.s:1581\n","stream":"stderr","time":"2021-10-15T15:37:35.541813599Z"}
{"log":"main.load\n","stream":"stderr","time":"2021-10-15T15:37:35.5418335Z"}
{"log":"\u0009/hockeypuck/src/hockeypuck/server/cmd/hockeypuck-load/main.go:77\n","stream":"stderr","time":"2021-10-15T15:37:35.54184014Z"}
{"log":"main.main\n","stream":"stderr","time":"2021-10-15T15:37:35.541846003Z"}
{"log":"\u0009/hockeypuck/src/hockeypuck/server/cmd/hockeypuck-load/main.go:70\n","stream":"stderr","time":"2021-10-15T15:37:35.541851571Z"}
{"log":"runtime.main\n","stream":"stderr","time":"2021-10-15T15:37:35.541857363Z"}
{"log":"\u0009/usr/local/go/src/runtime/proc.go:255\n","stream":"stderr","time":"2021-10-15T15:37:35.54186295Z"}
{"log":"runtime.goexit\n","stream":"stderr","time":"2021-10-15T15:37:35.541868621Z"}
{"log":"\u0009/usr/local/go/src/runtime/asm_amd64.s:1581","stream":"stderr","time":"2021-10-15T15:37:35.629740013Z"}
**

How can I solve this issue?

[cmars]

Looks like your postgres database isn't starting for some reason. Closing as this does not seem to be a bug in hockeypuck.

Could be an incorrectly initialized postgres volume? You might try destroying all volumes and containers and rebuilding from scratch?

[Mi97ch]

Maybe what you say is correct, but as I told before, I followed all the installation steps in the readme file of docker-compose and Postgres itself has been installed and configured by all the listed configuration file that are in the standalone folder.
That means that if something is wrong with my Postgres server, something is also wrong in your scripts.
I will also add that in my last try I used a brand new virtual machine with new Ubuntu version installed.
So there was no other versions of Postgres installed and the installation process was done only by the scripts mentioned above.

[cmars]

Without a clear description of how to reproduce the issue, I can't really determine where the problem is. I can't support all possible configurations, and while I'll accept contributions to improve installation scripts, etc. externalities like Postgres, Docker, etc are not really bugs in this project per se. You can always compile from source and connect to your own PostgreSQL database.

We probably need a standard bug reporting template. For starters, let's gather:

• Version of Docker
• Version of Docker Compose
• OS

If you continue to run into issues, please attach all relevant logs.

FWIW this is what version of Docker I'm running:

$ docker version
Client:
 Version:           20.10.7
 API version:       1.41
 Go version:        go1.16.8
 Git commit:        v20.10.7
 Built:             Thu Jan  1 00:00:00 1970
 OS/Arch:           linux/amd64
 Context:           default
 Experimental:      true

Server:
 Engine:
  Version:          20.10.7
  API version:      1.41 (minimum version 1.12)
  Go version:       go1.16.8
  Git commit:       v20.10.7
  Built:            Tue Jan  1 00:00:00 1980
  OS/Arch:          linux/amd64
  Experimental:     false
 containerd:
  Version:          v1.5.4
  GitCommit:        v1.5.4
 runc:
  Version:          1.0.0-rc95
  GitCommit:        
 docker-init:
  Version:          0.18.0
  GitCommit:        

and Docker Compose:

$ docker-compose version
docker-compose version 1.28.6, build unknown
docker-py version: 4.4.4
CPython version: 3.8.11
OpenSSL version: OpenSSL 1.1.1l  24 Aug 2021

If you're on Ubuntu, I would recommend NOT installing Docker from snap packages, as these tend to introduce subtle problems and aren't well suited to server software. Installing Docker CE from Docker is probably your best bet.

[Mi97ch]

These are the data requested:
`$ docker version
Client:
Version: 20.10.7
API version: 1.41
Go version: go1.13.8
Git commit: 20.10.7-0ubuntu5
Built: Tue Oct 5 20:06:06 2021
OS/Arch: linux/amd64
Context: default
Experimental: true

Server:
Engine:
Version: 20.10.7
API version: 1.41 (minimum version 1.12)
Go version: go1.13.8
Git commit: 20.10.7-0ubuntu5
Built: Tue Oct 5 19:45:26 2021
OS/Arch: linux/amd64
Experimental: false
containerd:
Version: 1.5.5-0ubuntu3
GitCommit:
runc:
Version: 1.0.1-0ubuntu2
GitCommit:
docker-init:
Version: 0.19.0
GitCommit: `

$ docker-compose version docker-compose version 1.27.4, build unknown docker-py version: 4.4.4 CPython version: 3.9.7 OpenSSL version: OpenSSL 1.1.1l 24 Aug 2021
$ lsb_release -a No LSB modules are available. Distributor ID: Ubuntu Description: Ubuntu 21.10 Release: 21.10 Codename: impish

I would also say that I assume the installation procedure was done with docker, since I used the scripts on the readme file (https://github.com/hockeypuck/hockeypuck/blob/master/contrib/docker-compose/standalone/README.md).
I've done all the steps in that file, starting from a really new ubuntu VM, so I didn't do something more or less apart of them.

[cmars]

Can you try on an Ubuntu LTS base image like 20.04? Non-LTS releases can be unstable.

[cmars]

It'd also be good to debug the postgres container specifically. If postgres can't connect, you'll need to get to the bottom of why that is.