creamy-energy-49433
01/10/2024, 4:03 PMError from server (BadRequest): container "flyte" in pod "flyte-backend-flyte-binary-587f6c94d4-pm5zx" is waiting to start: PodInitializing
proud-answer-87162
01/10/2024, 4:07 PMcreamy-energy-49433
01/10/2024, 4:10 PMkubectl logs
and when I try to kubectl exec
I get :
Defaulted container "flyte" out of: flyte, wait-for-db (init)
error: unable to upgrade connection: container not found ("flyte")
proud-answer-87162
01/10/2024, 4:13 PMkubectl describe pod/flyte-backend-flyte-binary-587f6c94d4-pm5zx
proud-answer-87162
01/10/2024, 4:19 PMPodInitializing
failures are related to flyte being unable to communicate with the db. that can be network/access issues, db down issues, password/secret problems, etcproud-answer-87162
01/10/2024, 4:19 PMkubectl describe pod
output gives a clear indication of what is failing during initcreamy-energy-49433
01/10/2024, 4:21 PMfresh-policeman-21476
01/10/2024, 5:02 PMfresh-policeman-21476
01/10/2024, 5:06 PMcreamy-energy-49433
01/10/2024, 5:27 PMcreamy-energy-49433
01/10/2024, 5:28 PMwait-for-db
init containercreamy-energy-49433
01/10/2024, 5:29 PMwait-for-db:
Container ID: <containerd://6fea6c36f27b44ff163eb44ecb05bb9b6f2b803bdbcb4b6c758237505b53a6c>7
Image: postgres:15-alpine
Image ID: <http://docker.io/library/postgres@sha256:ddaa3615f15a3d0ba9ef5f9af398d093fcce511fea1187049444fcd09626c21a|docker.io/library/postgres@sha256:ddaa3615f15a3d0ba9ef5f9af398d093fcce511fea1187049444fcd09626c21a>
Port: <none>
Host Port: <none>
Command:
sh
-ec
Args:
until pg_isready \
-h <redacted> \
-p 5432 \
-U postgres
do
echo waiting for database
sleep 0.1
done
State: Running
Started: Wed, 10 Jan 2024 10:19:04 -0700
Ready: False
proud-answer-87162
01/10/2024, 5:30 PMproud-answer-87162
01/10/2024, 5:31 PMcreamy-energy-49433
01/10/2024, 5:31 PMcreamy-energy-49433
01/10/2024, 6:20 PM[error] failed to initialize database, got error failed to connect to `host=<redacted> database=<redacted>: server error (FATAL: no pg_hba.conf entry for host "<redacted>", user "postgres", database "<redacted>", no encryption (SQLSTATE 28000))
creamy-energy-49433
01/10/2024, 6:22 PMcreamy-energy-49433
01/10/2024, 6:22 PMproud-answer-87162
01/10/2024, 6:33 PMoptions: sslmode=verify-full
creamy-energy-49433
01/10/2024, 6:41 PMeks-starter.yaml
?proud-answer-87162
01/10/2024, 6:42 PMdatabase:
username: postgres
password: <DB_PASSWORD>
host: <RDS_HOST_DNS>
dbname: flyteadmin
options: sslmode=verify-full
creamy-energy-49433
01/10/2024, 6:46 PMfailed to initialize database, got error failed to connect to `host=<redacted> user=postgres database=<redacted>`: failed to write startup message (x509: certificate signed by unknown authority)
panic: interface conversion: error is x509.UnknownAuthorityError, not *pgconn.PgError
creamy-energy-49433
01/10/2024, 6:48 PMcreamy-energy-49433
01/10/2024, 6:48 PMhostnossl all all 0.0.0.0/0 trust
and this was modified in postgresql.conf
, as shown:
listen_addresses = '*'
creamy-energy-49433
01/10/2024, 6:48 PMproud-answer-87162
01/10/2024, 6:49 PMoptions: sslmode=disable
creamy-energy-49433
01/10/2024, 6:51 PMcreamy-energy-49433
01/10/2024, 6:52 PMproud-answer-87162
01/10/2024, 6:53 PMproud-answer-87162
01/10/2024, 6:54 PMcreamy-energy-49433
01/10/2024, 7:33 PMrds.force_ssl
set to 0
instead of the default 1
creamy-energy-49433
01/10/2024, 7:33 PM