o-nikolas commented on PR #31001:
URL: https://github.com/apache/airflow/pull/31001#issuecomment-1533915306
I'm seeing some failed INSERT and SELECT statements when the postgres
container is trying to start. I think that's what's making the Docker Compose
start unhealthy and timing out. But I don't see the connection to my changes in
this PR. I've tried rebasing off main already in case I was missing some fix
but it's still failing.
```
postgres_1 | 2023-05-04 00:11:25.558 UTC [1] LOG: starting
PostgreSQL 13.10 (Debian 13.10-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled by
gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit
postgres_1 | 2023-05-04 00:11:25.558 UTC [1] LOG: listening on
IPv4 address "0.0.0.0", port 5432
postgres_1 | 2023-05-04 00:11:25.558 UTC [1] LOG: listening on
IPv6 address "::", port 5432
postgres_1 | 2023-05-04 00:11:25.558 UTC [1] LOG: listening on
Unix socket "/var/run/postgresql/.s.PGSQL.5432"
postgres_1 | 2023-05-04 00:11:25.560 UTC [63] LOG: database
system was shut down at 2023-05-04 00:11:25 UTC
postgres_1 | 2023-05-04 00:11:25.563 UTC [1] LOG: database
system is ready to accept connections
postgres_1 | 2023-05-04 00:11:38.079 UTC [77] ERROR: relation
"log" does not exist at character 13
postgres_1 | 2023-05-04 00:11:38.079 UTC [77] STATEMENT: INSERT
INTO log (dttm, event, owner, extra) VALUES
('2023-05-04T00:11:38.051018+00:00'::timestamptz, 'cli_check', 'root',
'{"host_name": "4b5384b87e09", "full_command":
"[''/home/airflow/.local/bin/airflow'', ''db'', ''check'']"}') RETURNING log.id
postgres_1 | 2023-05-04 00:11:38.719 UTC [78] ERROR: relation
"log" does not exist at character 13
postgres_1 | 2023-05-04 00:11:38.719 UTC [78] STATEMENT: INSERT
INTO log (dttm, event, owner, extra) VALUES
('2023-05-04T00:11:38.710877+00:00'::timestamptz, 'cli_upgradedb', 'root',
'{"host_name": "4b5384b87e09", "full_command":
"[''/home/airflow/.local/bin/airflow'', ''db'', ''upgrade'']"}') RETURNING
log.id
postgres_1 | 2023-05-04 00:11:40.897 UTC [78] ERROR: relation
"connection" does not exist at character 55
postgres_1 | 2023-05-04 00:11:40.897 UTC [78] STATEMENT: SELECT
connection.conn_id AS connection_conn_id
postgres_1 | FROM connection GROUP BY connection.conn_id
postgres_1 | HAVING count(*) > 1
postgres_1 | 2023-05-04 00:11:40.899 UTC [78] ERROR: relation
"connection" does not exist at character 55
postgres_1 | 2023-05-04 00:11:40.899 UTC [78] STATEMENT: SELECT
connection.conn_id AS connection_conn_id
postgres_1 | FROM connection
postgres_1 | WHERE connection.conn_type IS NULL
postgres_1 | 2023-05-04 00:11:40.934 UTC [78] ERROR: relation
"ab_user" does not exist at character 51
postgres_1 | 2023-05-04 00:11:40.934 UTC [78] STATEMENT: SELECT
ab_user.username AS ab_user_username
postgres_1 | FROM ab_user GROUP BY ab_user.username
postgres_1 | HAVING count(*) > 1
postgres_1 | 2023-05-04 00:11:40.936 UTC [78] ERROR: relation
"ab_register_user" does not exist at character 69
postgres_1 | 2023-05-04 00:11:40.936 UTC [78] STATEMENT: SELECT
ab_register_user.username AS ab_register_user_username
postgres_1 | FROM ab_register_user GROUP BY
ab_register_user.username
postgres_1 | HAVING count(*) > 1
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
