8Knot no longer starts

[sgoggins]

Describe the bug docker compose up --build now generates the following error:

postgres-cache-1 exited with code 1
worker-query-1     | [2024-01-17 21:16:22,561: INFO/MainProcess] Connected to redis://:**@redis-cache:6379//
worker-query-1     | [2024-01-17 21:16:22,563: INFO/MainProcess] mingle: searching for neighbors
worker-callback-1  | [2024-01-17 21:16:22,610: INFO/MainProcess] Connected to redis://:**@redis-cache:6379//
worker-callback-1  | [2024-01-17 21:16:22,611: INFO/MainProcess] mingle: searching for neighbors
db-init-1          | CRITICAL:root:password
db-init-1          | CRITICAL:root:POSTGRES ERROR: could not translate host name "postgres-cache" to address: Name or service not known
db-init-1          | 
db-init-1 exited with code 1
worker-query-1     | [2024-01-17 21:16:23,571: INFO/MainProcess] mingle: all alone
worker-query-1     | [2024-01-17 21:16:23,599: INFO/MainProcess] celery@1130986fe77b ready.
worker-callback-1  | [2024-01-17 21:16:23,617: INFO/MainProcess] mingle: all alone
worker-callback-1  | [2024-01-17 21:16:23,632: INFO/MainProcess] celery@8e06be7a1ded ready.
postgres-cache-1   | Error: Database is uninitialized and superuser password is not specified.
postgres-cache-1   |        You must specify POSTGRES_PASSWORD to a non-empty value for the
postgres-cache-1   |        superuser. For example, "-e POSTGRES_PASSWORD=password" on "docker run".
postgres-cache-1   | 
postgres-cache-1   |        You may also use "POSTGRES_HOST_AUTH_METHOD=trust" to allow all
postgres-cache-1   |        connections without a password. This is *not* recommended.
postgres-cache-1   | 
postgres-cache-1   |        See PostgreSQL documentation about "trust":
postgres-cache-1   |        https://www.postgresql.org/docs/current/auth-trust.html
postgres-cache-1 exited with code 1
db-init-1          | CRITICAL:root:password
db-init-1          | CRITICAL:root:POSTGRES ERROR: could not translate host name "postgres-cache" to address: Name or service not known
db-init-1          | 
db-init-1 exited with code 1
postgres-cache-1   | Error: Database is uninitialized and superuser password is not specified.
postgres-cache-1   |        You must specify POSTGRES_PASSWORD to a non-empty value for the
postgres-cache-1   |        superuser. For example, "-e POSTGRES_PASSWORD=password" on "docker run".
postgres-cache-1   | 
postgres-cache-1   |        You may also use "POSTGRES_HOST_AUTH_METHOD=trust" to allow all
postgres-cache-1   |        connections without a password. This is *not* recommended.
postgres-cache-1   | 
postgres-cache-1   |        See PostgreSQL documentation about "trust":
postgres-cache-1   |        https://www.postgresql.org/docs/current/auth-trust.html
postgres-cache-1 exited with code 1
db-init-1          | CRITICAL:root:password
db-init-1          | CRITICAL:root:POSTGRES ERROR: could not translate host name "postgres-cache" to address: Name or service not known
db-init-1          | 
db-init-1 exited with code 1
^CGracefully stopping... (press Ctrl+C again to force)

To Reproduce Start like normal

Expected behavior 8Knot starts

Additional context Trying to get a dev setup using method that worked previously, and no longer works. There is no update to documentation.

[sgoggins]

I believe this is related to the new PostgreSQL queueing :

postgres-cache-1 exited with code 0
postgres-cache-1   | Error: Database is uninitialized and superuser password is not specified.
postgres-cache-1   |        You must specify POSTGRES_PASSWORD to a non-empty value for the
postgres-cache-1   |        superuser. For example, "-e POSTGRES_PASSWORD=password" on "docker run".
postgres-cache-1   | 
postgres-cache-1   |        You may also use "POSTGRES_HOST_AUTH_METHOD=trust" to allow all
postgres-cache-1   |        connections without a password. This is *not* recommended.
postgres-cache-1   | 
postgres-cache-1   |        See PostgreSQL documentation about "trust":
postgres-cache-1   |        https://www.postgresql.org/docs/current/auth-trust.html

[JamesKunstle]

Add any postgres password in env.list

POSTGRES_PASSWORD=password123 for example

[JamesKunstle]

This will be documented clearly in a future docs addition.

[cdolfi]

@sgoggins @JamesKunstle Is this good to close or is there more that needs to be done for this?