n

    Nicholas Kan

    3 months ago
    Hi Everyone, trying to set up prefect on my local machine for the first time, I keep getting this error when the postgres docker container is building. I am just using the docker-compose from docker hub. Has anyone encountered this before or knows how to workaround? Error message in the replies
    Kevin Kho

    Kevin Kho

    3 months ago
    Hi Nicholas, could you move the traceback to the tread to keep the main channel cleaner when you get a chance?
    How did you spin this up?
    prefect server start
    ?
    n

    Nicholas Kan

    3 months ago
    docker-compose-server-postgres-1  | The files belonging to this database system will be owned by user "postgres".
    docker-compose-server-postgres-1  | This user must also own the server process.
    docker-compose-server-postgres-1  |
    docker-compose-server-postgres-1  | The database cluster will be initialized with locale "en_US.utf8".
    docker-compose-server-postgres-1  | The default database encoding has accordingly been set to "UTF8".
    docker-compose-server-postgres-1  | The default text search configuration will be set to "english".
    docker-compose-server-postgres-1  |
    docker-compose-server-postgres-1  | Data page checksums are disabled.
    docker-compose-server-postgres-1  |
    docker-compose-server-postgres-1  | fixing permissions on existing directory /var/lib/postgresql/data ... ok
    docker-compose-server-postgres-1  | creating subdirectories ... ok
    docker-compose-server-postgres-1  | selecting default max_connections ... 100
    docker-compose-server-postgres-1  | selecting default shared_buffers ... 128MB
    docker-compose-server-postgres-1  | selecting default timezone ... Etc/UTC
    docker-compose-server-postgres-1  | selecting dynamic shared memory implementation ... posix
    docker-compose-server-postgres-1  | creating configuration files ... ok
    docker-compose-server-postgres-1  | running bootstrap script ... ok
    docker-compose-server-postgres-1  | performing post-bootstrap initialization ... ok
    docker-compose-server-postgres-1  | syncing data to disk ...
    docker-compose-server-postgres-1  | WARNING: enabling "trust" authentication for local connections
    docker-compose-server-postgres-1  | You can change this by editing pg_hba.conf or using the option -A, or
    docker-compose-server-postgres-1  | --auth-local and --auth-host, the next time you run initdb.
    docker-compose-server-postgres-1  | ok
    docker-compose-server-postgres-1  |
    docker-compose-server-postgres-1  | Success. You can now start the database server using:
    docker-compose-server-postgres-1  |
    docker-compose-server-postgres-1  |     pg_ctl -D /var/lib/postgresql/data -l logfile start
    docker-compose-server-postgres-1  |
    docker-compose-server-postgres-1  | waiting for server to start....2022-06-23 16:59:12.769 UTC [48] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
    docker-compose-server-postgres-1  | 2022-06-23 16:59:12.801 UTC [49] LOG:  database system was shut down at 2022-06-23 16:59:12 UTC
    docker-compose-server-postgres-1  | 2022-06-23 16:59:12.821 UTC [48] LOG:  database system is ready to accept connections
    docker-compose-server-postgres-1  |  done
    docker-compose-server-postgres-1  | server started
    docker-compose-server-postgres-1  | CREATE DATABASE
    docker-compose-server-postgres-1  |
    docker-compose-server-postgres-1  |
    docker-compose-server-postgres-1  | /usr/local/bin/docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/*
    docker-compose-server-postgres-1  |
    docker-compose-server-postgres-1  | waiting for server to shut down...2022-06-23 16:59:13.292 UTC [48] LOG:  received fast shutdown request
    docker-compose-server-postgres-1  | .2022-06-23 16:59:13.296 UTC [48] LOG:  aborting any active transactions
    docker-compose-server-postgres-1  | 2022-06-23 16:59:13.299 UTC [48] LOG:  background worker "logical replication launcher" (PID 55) exited with exit code 1
    docker-compose-server-postgres-1  | 2022-06-23 16:59:13.299 UTC [50] LOG:  shutting down
    docker-compose-server-postgres-1  | 2022-06-23 16:59:13.332 UTC [48] LOG:  database system is shut down
    docker-compose-server-postgres-1  |  done
    docker-compose-server-postgres-1  | server stopped
    docker-compose-server-postgres-1  |
    docker-compose-server-postgres-1  | PostgreSQL init process complete; ready for start up.
    docker-compose-server-postgres-1  |
    docker-compose-server-postgres-1  | 2022-06-23 16:59:13.412 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432docker-compose-server-postgres-1  | 2022-06-23 16:59:13.412 UTC [1] LOG:  listening on IPv6 address "::", port 5432
    docker-compose-server-postgres-1  | 2022-06-23 16:59:13.420 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
    docker-compose-server-postgres-1  | 2022-06-23 16:59:13.440 UTC [76] LOG:  database system was shut down at 2022-06-23 16:59:13 UTC
    docker-compose-server-postgres-1  | 2022-06-23 16:59:13.448 UTC [1] LOG:  database system is ready to accept connections
    @Kevin Kho used docker compose up with the following yaml
    Kevin Kho

    Kevin Kho

    3 months ago
    Is this just the output of
    prefect server config
    or did you make changes?
    n

    Nicholas Kan

    3 months ago
    it's just the output
    Kevin Kho

    Kevin Kho

    3 months ago
    Is it the same behavior when you do
    prefect server start
    ?
    Is it actually failing though? The logs can just be noisy sometimes but it can work
    n

    Nicholas Kan

    3 months ago
    Everything else is working fine, the graphql and UI, but I am unable to add a project, I assume because the db is shutting down and not accepting connection
    also tried to connect separately to db using pgadmin to verify and it is not accepting
    able to see the schema but can't query
    Kevin Kho

    Kevin Kho

    3 months ago
    I personally haven’t seen this before and can’t immediately see a reason why it’s failing. Are you open to trying Cloud by chance? The free tier gives 10k free task runs a month, which is more than enough to get started with
    n

    Nicholas Kan

    3 months ago
    Just finished building with prefect server start and it is working now, thank you for your assistance!
    Kevin Kho

    Kevin Kho

    3 months ago
    I don’t know why that would be different 🤷‍♂️