Cannot start netbox-docker, error with PostgreSQL

[tungnt22]

I attempted to start a netbox-docker and got this issue

Please advise how to get over this?

netbox-docker$ sudo docker-compose up
[+] Running 4/0
 ✔ Container netbox-docker-redis-cache-1  Running                                                                                    0.0s
 ✔ Container netbox-docker-postgres-1     Created                                                                                    0.0s
 ✔ Container netbox-docker-redis-1        Running                                                                                    0.0s
 ✔ Container netbox-docker-netbox-1       Created                                                                                    0.0s
Attaching to netbox-docker-netbox-1, netbox-docker-netbox-housekeeping-1, netbox-docker-netbox-worker-1, netbox-docker-postgres-1, netbox-docker-redis-1, netbox-docker-redis-cache-1
netbox-docker-postgres-1             |
netbox-docker-postgres-1             | PostgreSQL Database directory appears to contain a database; Skipping initialization
netbox-docker-postgres-1             |
netbox-docker-postgres-1             |
netbox-docker-postgres-1             | 2023-09-14 03:27:06.808 UTC [1] FATAL:  database files are incompatible with server
netbox-docker-postgres-1             | 2023-09-14 03:27:06.808 UTC [1] DETAIL:  The data directory was initialized by PostgreSQL version 12, which is not compatible with this version 15.4.
netbox-docker-postgres-1 exited with code 1
netbox-docker-netbox-1               | django.db.utils.OperationalError: connection is bad: Name or service not known
netbox-docker-netbox-1               | [ Use DB_WAIT_DEBUG=1 in netbox.env to print full traceback for errors here ]
netbox-docker-netbox-1               | ⏳ Waiting on DB... (0s / 30s)
netbox-docker-netbox-1               | django.db.utils.OperationalError: connection is bad: Name or service not known
netbox-docker-netbox-1               | [ Use DB_WAIT_DEBUG=1 in netbox.env to print full traceback for errors here ]
netbox-docker-netbox-1               | ⏳ Waiting on DB... (3s / 30s)
netbox-docker-netbox-1               | django.db.utils.OperationalError: connection is bad: Name or service not known

[tobiasge]

When upgrading Postgres you need to dump and reload your data:
https://github.com/netbox-community/netbox-docker/wiki/Updating#postgresql-update

[tungnt22]

Many thanks for your response, that helps and I can see that problem gone, but I have another issue which also prevents me from starting docker as below

I have no clue where the problem comes from, can you also advise how to debug, thanks!

netbox-docker-netbox-1               |  OK
netbox-docker-netbox-1               |   Applying circuits.0001_squashed...
netbox-docker-netbox-1               |  OK
netbox-docker-netbox-1               |   Applying circuits.0002_squashed_0029...
dependency failed to start: container netbox-docker-netbox-1 is unhealthy

[tungnt22]

What I could see from the logs are this

netbox-docker-postgres-1             | server started
netbox-docker-postgres-1             | CREATE DATABASE
netbox-docker-postgres-1             |
netbox-docker-postgres-1             |
netbox-docker-postgres-1             |
netbox-docker-postgres-1             |
netbox-docker-postgres-1             | /usr/local/bin/docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/*
netbox-docker-postgres-1             |
netbox-docker-postgres-1             |
netbox-docker-postgres-1             | 2023-09-14 06:19:07.389 UTC [35] LOG:  received fast shutdown request
netbox-docker-postgres-1             | waiting for server to shut down...
netbox-docker-postgres-1             | .
netbox-docker-postgres-1             | 2023-09-14 06:19:07.393 UTC [35] LOG:  aborting any active transactions
netbox-docker-postgres-1             | 2023-09-14 06:19:07.398 UTC [35] LOG:  background worker "logical replication launcher" (PID 41) exited with exi t code 1
netbox-docker-postgres-1             | 2023-09-14 06:19:07.399 UTC [36] LOG:  shutting down
netbox-docker-postgres-1             | 2023-09-14 06:19:07.401 UTC [36] LOG:  checkpoint starting: shutdown immediate
netbox-docker-postgres-1             | 2023-09-14 06:19:07.458 UTC [36] LOG:  checkpoint complete: wrote 918 buffers (5.6%); 0 WAL file(s) added, 0 rem oved, 0 recycled; write=0.041 s, sync=0.005 s, total=0.060 s; sync files=301, longest=0.003 s, average=0.001 s; distance=4223 kB, estimate=4223 kB
netbox-docker-postgres-1             | 2023-09-14 06:19:07.465 UTC [35] LOG:  database system is shut down
netbox-docker-postgres-1             |  done
netbox-docker-postgres-1             | server stopped
netbox-docker-postgres-1             |
netbox-docker-postgres-1             | PostgreSQL init process complete; ready for start up.
netbox-docker-postgres-1             |
netbox-docker-postgres-1             |
netbox-docker-postgres-1             | 2023-09-14 06:19:07.534 UTC [1] LOG:  starting PostgreSQL 15.4 on x86_64-pc-linux-musl, compiled by gcc (Alpine  12.2.1_git20220924-r10) 12.2.1 20220924, 64-bit
netbox-docker-postgres-1             | 2023-09-14 06:19:07.538 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
netbox-docker-postgres-1             | 2023-09-14 06:19:07.538 UTC [1] LOG:  listening on IPv6 address "::", port 5432
netbox-docker-postgres-1             | 2023-09-14 06:19:07.543 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
netbox-docker-postgres-1             | 2023-09-14 06:19:07.551 UTC [51] LOG:  database system was shut down at 2023-09-14 06:19:07 UTC
netbox-docker-postgres-1             | 2023-09-14 06:19:07.557 UTC [1] LOG:  database system is ready to accept connections
netbox-docker-postgres-1             | 2023-09-14 06:19:16.351 UTC [55] ERROR:  relation "django_content_type" does not exist at character 106
netbox-docker-postgres-1             | 2023-09-14 06:19:16.351 UTC [55] STATEMENT:  SELECT "django_content_type"."id", "django_content_type"."ap

[stampeder]

I have a similar problem (see below). But mine seems to be due to a key issue. My whole system was already working and not it is not:

netbox-docker-netbox-1 | ⏳ Waiting on DB... (24s / 30s)
netbox-docker-netbox-1 | python /opt/netbox/netbox/generate_secret_key.py
netbox-docker-netbox-1 | [ Use DB_WAIT_DEBUG=1 in netbox.env to print full traceback for errors here ]
netbox-docker-netbox-1 | ⏳ Waiting on DB... (27s / 30s)
netbox-docker-netbox-1 | ❌ Waited 30s or more for the DB to become ready.
dependency failed to start: container netbox-docker-netbox-1 exited (1)

thanks.

[ji-podhead]

$ sudo podman logs netbox-docker_postgres_1

PostgreSQL Database directory appears to contain a database; Skipping initialization

2024-08-22 16:33:22.235 UTC [1] FATAL:  database files are incompatible with server
2024-08-22 16:33:22.235 UTC [1] DETAIL:  The data directory was initialized by PostgreSQL version 14, which is not compatible with this version 16.4.

PostgreSQL Database directory appears to contain a database; Skipping initialization

this is the reason:

            # postgres
            postgres:
              image: docker.io/postgres:16-alpine

[ji-podhead]

$ sudo podman logs netbox-docker_postgres_1

PostgreSQL Database directory appears to contain a database; Skipping initialization

2024-08-22 16:33:22.235 UTC [1] FATAL:  database files are incompatible with server
2024-08-22 16:33:22.235 UTC [1] DETAIL:  The data directory was initialized by PostgreSQL version 14, which is not compatible with this version 16.4.

PostgreSQL Database directory appears to contain a database; Skipping initialization

this is the reason:

            # postgres
            postgres:
              image: docker.io/postgres:16-alpine

no i was just stupid, see #1288
i had to pull the dependencies again with docker compose pull