2025-02-26 21:41:28.800 UTC [37615][postmaster] LOG:  starting PostgreSQL 18devel on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
2025-02-26 21:41:28.800 UTC [37615][postmaster] LOG:  listening on Unix socket "/tmp/pg_regress-tJiyNH/.s.PGSQL.65312"
2025-02-26 21:41:28.829 UTC [37641][startup] LOG:  database system was shut down at 2025-02-26 21:38:59 UTC
2025-02-26 21:41:28.839 UTC [37615][postmaster] LOG:  database system is ready to accept connections
2025-02-26 21:41:28.839 UTC [37642][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-02-26 21:41:28.839 UTC [37642][client backend] [[unknown]][:0] FATAL:  the database system is starting up
2025-02-26 21:41:28.904 UTC [37662][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-02-26 21:41:28.905 UTC [37662][client backend] [[unknown]][0/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/contrib/postgres_fdw/tmp_check/data/pg_hba.conf:117)
2025-02-26 21:41:28.905 UTC [37662][client backend] [[unknown]][0/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=pg_regress
2025-02-26 21:41:28.946 UTC [37662][client backend] [pg_regress][:0] LOG:  disconnection: session time: 0:00:00.050 user=postgres database=postgres host=[local]
2025-02-26 21:41:28.976 UTC [37682][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-02-26 21:41:28.977 UTC [37682][client backend] [[unknown]][1/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/contrib/postgres_fdw/tmp_check/data/pg_hba.conf:117)
2025-02-26 21:41:28.977 UTC [37682][client backend] [[unknown]][1/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=pg_regress
2025-02-26 21:41:29.152 UTC [37682][client backend] [pg_regress][:0] LOG:  disconnection: session time: 0:00:00.177 user=postgres database=postgres host=[local]
2025-02-26 21:41:29.229 UTC [37727][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-02-26 21:41:29.231 UTC [37727][client backend] [[unknown]][2/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/contrib/postgres_fdw/tmp_check/data/pg_hba.conf:117)
2025-02-26 21:41:29.231 UTC [37727][client backend] [[unknown]][2/1:0] LOG:  connection authorized: user=postgres database=contrib_regression application_name=pg_regress/postgres_fdw
2025-02-26 21:41:29.465 UTC [37727][client backend] [pg_regress/postgres_fdw][2/38:0] ERROR:  parameter "extensions" must be a list of extension names
2025-02-26 21:41:29.465 UTC [37727][client backend] [pg_regress/postgres_fdw][2/38:0] STATEMENT:  ALTER SERVER testserver1 OPTIONS (ADD extensions 'foo; bar');
2025-02-26 21:41:29.465 UTC [37727][client backend] [pg_regress/postgres_fdw][2/39:0] WARNING:  extension "foo" is not installed
2025-02-26 21:41:29.467 UTC [37727][client backend] [pg_regress/postgres_fdw][2/39:0] WARNING:  extension "bar" is not installed
2025-02-26 21:41:29.468 UTC [37727][client backend] [pg_regress/postgres_fdw][2/42:0] ERROR:  invalid option "sslmode"
2025-02-26 21:41:29.468 UTC [37727][client backend] [pg_regress/postgres_fdw][2/42:0] STATEMENT:  ALTER USER MAPPING FOR public SERVER testserver1
		OPTIONS (ADD sslmode 'require');
2025-02-26 21:41:29.532 UTC [37769][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-02-26 21:41:29.533 UTC [37769][client backend] [[unknown]][3/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/contrib/postgres_fdw/tmp_check/data/pg_hba.conf:117)
2025-02-26 21:41:29.533 UTC [37769][client backend] [[unknown]][3/1:0] LOG:  connection authorized: user=postgres database=contrib_regression application_name=pg_regress
2025-02-26 21:41:29.564 UTC [37769][client backend] [pg_regress][:0] LOG:  disconnection: session time: 0:00:00.036 user=postgres database=contrib_regression host=[local]
2025-02-26 21:41:29.580 UTC [37775][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-02-26 21:41:29.586 UTC [37775][client backend] [[unknown]][4/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/contrib/postgres_fdw/tmp_check/data/pg_hba.conf:117)
2025-02-26 21:41:29.586 UTC [37775][client backend] [[unknown]][4/1:0] LOG:  connection authorized: user=postgres database=no such database application_name=pg_regress
2025-02-26 21:41:29.586 UTC [37775][client backend] [[unknown]][4/1:0] FATAL:  database "no such database" does not exist
2025-02-26 21:41:29.586 UTC [37727][client backend] [pg_regress/postgres_fdw][2/52:0] ERROR:  could not connect to server "loopback"
2025-02-26 21:41:29.586 UTC [37727][client backend] [pg_regress/postgres_fdw][2/52:0] DETAIL:  connection to server on socket "/tmp/pg_regress-tJiyNH/.s.PGSQL.65312" failed: FATAL:  database "no such database" does not exist
2025-02-26 21:41:29.586 UTC [37727][client backend] [pg_regress/postgres_fdw][2/52:0] STATEMENT:  SELECT c3, c4 FROM ft1 ORDER BY c3, c1 LIMIT 1;
2025-02-26 21:41:29.598 UTC [37784][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-02-26 21:41:29.599 UTC [37784][client backend] [[unknown]][5/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/contrib/postgres_fdw/tmp_check/data/pg_hba.conf:117)
2025-02-26 21:41:29.599 UTC [37784][client backend] [[unknown]][5/1:0] LOG:  connection authorized: user=postgres database=contrib_regression application_name=pg_regress
2025-02-26 21:41:29.631 UTC [37784][client backend] [pg_regress][:0] LOG:  disconnection: session time: 0:00:00.032 user=postgres database=contrib_regression host=[local]
2025-02-26 21:41:29.636 UTC [37789][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-02-26 21:41:29.637 UTC [37789][client backend] [[unknown]][6/1:0] LOG:  connection authenticated: user="no such user" method=trust (/tmp/cirrus-ci-build/contrib/postgres_fdw/tmp_check/data/pg_hba.conf:117)
2025-02-26 21:41:29.637 UTC [37789][client backend] [[unknown]][6/1:0] LOG:  connection authorized: user=no such user database=contrib_regression application_name=pg_regress
2025-02-26 21:41:29.637 UTC [37789][client backend] [[unknown]][6/1:0] FATAL:  role "no such user" does not exist
2025-02-26 21:41:29.637 UTC [37727][client backend] [pg_regress/postgres_fdw][2/56:0] ERROR:  could not connect to server "loopback"
2025-02-26 21:41:29.637 UTC [37727][client backend] [pg_regress/postgres_fdw][2/56:0] DETAIL:  connection to server on socket "/tmp/pg_regress-tJiyNH/.s.PGSQL.65312" failed: FATAL:  role "no such user" does not exist
2025-02-26 21:41:29.637 UTC [37727][client backend] [pg_regress/postgres_fdw][2/56:0] STATEMENT:  SELECT c3, c4 FROM ft1 ORDER BY c3, c1 LIMIT 1;
2025-02-26 21:41:29.663 UTC [37790][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-02-26 21:41:29.664 UTC [37790][client backend] [[unknown]][7/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/contrib/postgres_fdw/tmp_check/data/pg_hba.conf:117)
2025-02-26 21:41:29.664 UTC [37790][client backend] [[unknown]][7/1:0] LOG:  connection authorized: user=postgres database=contrib_regression application_name=pg_regress
2025-02-26 21:41:29.730 UTC [37727][client backend] [pg_regress/postgres_fdw][2/61:800] ERROR:  cannot add relation "ft1" to publication
2025-02-26 21:41:29.730 UTC [37727][client backend] [pg_regress/postgres_fdw][2/61:800] DETAIL:  This operation is not supported for foreign tables.
2025-02-26 21:41:29.730 UTC [37727][client backend] [pg_regress/postgres_fdw][2/61:800] STATEMENT:  CREATE PUBLICATION testpub_ftbl FOR TABLE ft1;
2025-02-26 21:41:29.940 UTC [37727][client backend] [pg_regress/postgres_fdw][2/101:0] ERROR:  access to non-system foreign table is restricted
2025-02-26 21:41:29.940 UTC [37727][client backend] [pg_regress/postgres_fdw][2/101:0] STATEMENT:  SELECT * from ft1 where c1 < 1;
2025-02-26 21:41:29.940 UTC [37727][client backend] [pg_regress/postgres_fdw][2/102:0] ERROR:  access to non-system foreign table is restricted
2025-02-26 21:41:29.940 UTC [37727][client backend] [pg_regress/postgres_fdw][2/102:0] STATEMENT:  INSERT INTO ft1 (c1) VALUES (1);
2025-02-26 21:41:29.940 UTC [37727][client backend] [pg_regress/postgres_fdw][2/103:0] ERROR:  access to non-system foreign table is restricted
2025-02-26 21:41:29.940 UTC [37727][client backend] [pg_regress/postgres_fdw][2/103:0] STATEMENT:  DELETE FROM ft1 WHERE c1 = 1;
2025-02-26 21:41:29.940 UTC [37727][client backend] [pg_regress/postgres_fdw][2/104:0] ERROR:  access to non-system foreign table is restricted
2025-02-26 21:41:29.940 UTC [37727][client backend] [pg_regress/postgres_fdw][2/104:0] STATEMENT:  TRUNCATE ft1;
2025-02-26 21:41:30.215 UTC [37790][client backend] [pg_regress][:0] LOG:  disconnection: session time: 0:00:00.555 user=postgres database=contrib_regression host=[local]
2025-02-26 21:41:30.228 UTC [37832][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-02-26 21:41:30.230 UTC [37832][client backend] [[unknown]][8/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/contrib/postgres_fdw/tmp_check/data/pg_hba.conf:117)
2025-02-26 21:41:30.230 UTC [37832][client backend] [[unknown]][8/1:0] LOG:  connection authorized: user=postgres database=contrib_regression application_name=pg_regress
2025-02-26 21:41:30.324 UTC [37840][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-02-26 21:41:30.325 UTC [37840][client backend] [[unknown]][9/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/contrib/postgres_fdw/tmp_check/data/pg_hba.conf:117)
2025-02-26 21:41:30.325 UTC [37840][client backend] [[unknown]][9/1:0] LOG:  connection authorized: user=postgres database=contrib_regression application_name=pg_regress/postgres_fdw
2025-02-26 21:41:30.328 UTC [37727][client backend] [pg_regress/postgres_fdw][:0] LOG:  disconnection: session time: 0:00:01.106 user=postgres database=contrib_regression host=[local]
2025-02-26 21:41:30.355 UTC [37845][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-02-26 21:41:30.357 UTC [37845][client backend] [[unknown]][10/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/contrib/postgres_fdw/tmp_check/data/pg_hba.conf:117)
2025-02-26 21:41:30.357 UTC [37845][client backend] [[unknown]][10/1:0] LOG:  connection authorized: user=postgres database=contrib_regression application_name=pg_regress
2025-02-26 21:41:30.365 UTC [37832][client backend] [pg_regress][:0] LOG:  disconnection: session time: 0:00:00.137 user=postgres database=contrib_regression host=[local]
2025-02-26 21:41:30.765 UTC [37845][client backend] [pg_regress][:0] LOG:  disconnection: session time: 0:00:00.409 user=postgres database=contrib_regression host=[local]
2025-02-26 21:41:30.772 UTC [37881][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-02-26 21:41:30.773 UTC [37881][client backend] [[unknown]][11/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/contrib/postgres_fdw/tmp_check/data/pg_hba.conf:117)
2025-02-26 21:41:30.773 UTC [37881][client backend] [[unknown]][11/1:0] LOG:  connection authorized: user=postgres database=contrib_regression application_name=pg_regress
2025-02-26 21:41:30.796 UTC [37881][client backend] [pg_regress][:0] LOG:  disconnection: session time: 0:00:00.025 user=postgres database=contrib_regression host=[local]
2025-02-26 21:41:30.812 UTC [37884][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-02-26 21:41:30.822 UTC [37884][client backend] [[unknown]][12/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/contrib/postgres_fdw/tmp_check/data/pg_hba.conf:117)
2025-02-26 21:41:30.822 UTC [37884][client backend] [[unknown]][12/1:0] LOG:  connection authorized: user=postgres database=contrib_regression application_name=pg_regress
2025-02-26 21:41:31.128 UTC [37921][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-02-26 21:41:31.129 UTC [37921][client backend] [[unknown]][13/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/contrib/postgres_fdw/tmp_check/data/pg_hba.conf:117)
2025-02-26 21:41:31.129 UTC [37921][client backend] [[unknown]][13/1:0] LOG:  connection authorized: user=postgres database=contrib_regression application_name=pg_regress
TRAP: failed Assert("plan->workmem == 0"), File: "execWorkmem.c", Line: 184, PID: 37840
/lib/x86_64-linux-gnu/libasan.so.8(+0x51f31)[0x7f1502251f31]
postgres: postgres contrib_regression [local] EXPLAIN(ExceptionalCondition+0xe6)[0x55abe1a8d0dd]
postgres: postgres contrib_regression [local] EXPLAIN(+0x968acb)[0x55abe127aacb]
postgres: postgres contrib_regression [local] EXPLAIN(+0x968918)[0x55abe127a918]
postgres: postgres contrib_regression [local] EXPLAIN(+0x968918)[0x55abe127a918]
postgres: postgres contrib_regression [local] EXPLAIN(+0x96893e)[0x55abe127a93e]
postgres: postgres contrib_regression [local] EXPLAIN(+0x968918)[0x55abe127a918]
postgres: postgres contrib_regression [local] EXPLAIN(standard_ExecAssignWorkMem+0x10b)[0x55abe127b08d]
postgres: postgres contrib_regression [local] EXPLAIN(ExecAssignWorkMem+0x4b)[0x55abe127b0e8]
postgres: postgres contrib_regression [local] EXPLAIN(+0x93b90e)[0x55abe124d90e]
postgres: postgres contrib_regression [local] EXPLAIN(standard_ExecutorStart+0x442)[0x55abe124e148]
postgres: postgres contrib_regression [local] EXPLAIN(ExecutorStart+0x73)[0x55abe124e520]
postgres: postgres contrib_regression [local] EXPLAIN(ExplainOnePlan+0x910)[0x55abe110ddee]
postgres: postgres contrib_regression [local] EXPLAIN(standard_ExplainOneQuery+0x3a2)[0x55abe110e4af]
postgres: postgres contrib_regression [local] EXPLAIN(+0x7fc7ca)[0x55abe110e7ca]
postgres: postgres contrib_regression [local] EXPLAIN(ExplainQuery+0x103c)[0x55abe110f81f]
postgres: postgres contrib_regression [local] EXPLAIN(standard_ProcessUtility+0xcae)[0x55abe177b391]
postgres: postgres contrib_regression [local] EXPLAIN(ProcessUtility+0x15b)[0x55abe177baed]
postgres: postgres contrib_regression [local] EXPLAIN(+0xe648db)[0x55abe17768db]
postgres: postgres contrib_regression [local] EXPLAIN(+0xe653dd)[0x55abe17773dd]
postgres: postgres contrib_regression [local] EXPLAIN(PortalRun+0x7d3)[0x55abe1777d37]
postgres: postgres contrib_regression [local] EXPLAIN(+0xe5cd03)[0x55abe176ed03]
postgres: postgres contrib_regression [local] EXPLAIN(PostgresMain+0xe3d)[0x55abe1772b19]
postgres: postgres contrib_regression [local] EXPLAIN(BackendMain+0x123)[0x55abe1764ff3]
postgres: postgres contrib_regression [local] EXPLAIN(postmaster_child_launch+0x1f1)[0x55abe15bf398]
postgres: postgres contrib_regression [local] EXPLAIN(+0xcb31f9)[0x55abe15c51f9]
postgres: postgres contrib_regression [local] EXPLAIN(+0xcb5e85)[0x55abe15c7e85]
postgres: postgres contrib_regression [local] EXPLAIN(PostmasterMain+0x1c3c)[0x55abe15c9fca]
postgres: postgres contrib_regression [local] EXPLAIN(main+0x2a2)[0x55abe135ae47]
/lib/x86_64-linux-gnu/libc.so.6(+0x2724a)[0x7f150117824a]
/lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0x85)[0x7f1501178305]
postgres: postgres contrib_regression [local] EXPLAIN(_start+0x21)[0x55abe0d353a1]
2025-02-26 21:41:33.451 UTC [37921][client backend] [pg_regress][:0] LOG:  disconnection: session time: 0:00:02.323 user=postgres database=contrib_regression host=[local]
2025-02-26 21:41:33.452 UTC [37884][client backend] [pg_regress][12/44:0] LOG:  unexpected EOF on client connection with an open transaction
2025-02-26 21:41:33.452 UTC [37884][client backend] [pg_regress][:0] LOG:  disconnection: session time: 0:00:02.640 user=postgres database=contrib_regression host=[local]
2025-02-26 21:41:33.596 UTC [38258][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-02-26 21:41:33.597 UTC [38258][client backend] [[unknown]][14/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/contrib/postgres_fdw/tmp_check/data/pg_hba.conf:117)
2025-02-26 21:41:33.597 UTC [38258][client backend] [[unknown]][14/1:0] LOG:  connection authorized: user=postgres database=contrib_regression application_name=pg_regress/query_cancel
2025-02-26 21:41:33.625 UTC [38261][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-02-26 21:41:33.626 UTC [38261][client backend] [[unknown]][15/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/contrib/postgres_fdw/tmp_check/data/pg_hba.conf:117)
2025-02-26 21:41:33.626 UTC [38261][client backend] [[unknown]][15/1:0] LOG:  connection authorized: user=postgres database=contrib_regression application_name=pg_regress
2025-02-26 21:41:33.644 UTC [38258][client backend] [pg_regress/query_cancel][14/4:0] ERROR:  canceling statement due to statement timeout
2025-02-26 21:41:33.644 UTC [38258][client backend] [pg_regress/query_cancel][14/4:0] STATEMENT:  SELECT count(*) FROM ft1 a CROSS JOIN ft1 b CROSS JOIN ft1 c CROSS JOIN ft1 d;
2025-02-26 21:41:33.653 UTC [38266][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-02-26 21:41:33.680 UTC [38258][client backend] [pg_regress/query_cancel][:0] LOG:  disconnection: session time: 0:00:00.087 user=postgres database=contrib_regression host=[local]
2025-02-26 21:41:33.688 UTC [38261][client backend] [pg_regress][:0] LOG:  disconnection: session time: 0:00:00.067 user=postgres database=contrib_regression host=[local]
2025-02-26 21:41:33.821 UTC [37615][postmaster] LOG:  received fast shutdown request
2025-02-26 21:41:33.821 UTC [37615][postmaster] LOG:  aborting any active transactions
2025-02-26 21:41:33.828 UTC [37615][postmaster] LOG:  background worker "logical replication launcher" (PID 37650) exited with exit code 1
2025-02-26 21:41:34.235 UTC [37615][postmaster] LOG:  client backend (PID 37840) was terminated by signal 6: Aborted
2025-02-26 21:41:34.235 UTC [37615][postmaster] DETAIL:  Failed process was running: EXPLAIN (VERBOSE, COSTS OFF)
	SELECT * FROM local_tbl LEFT JOIN (SELECT ft1.*, COALESCE(ft1.c3 || ft2.c3, 'foobar') FROM ft1 INNER JOIN ft2 ON (ft1.c1 = ft2.c1 AND ft1.c1 < 100)) ss ON (local_tbl.c1 = ss.c1) ORDER BY local_tbl.c1 FOR UPDATE OF local_tbl;
2025-02-26 21:41:34.235 UTC [37615][postmaster] LOG:  terminating any other active server processes
2025-02-26 21:41:34.239 UTC [37615][postmaster] LOG:  abnormal database system shutdown
2025-02-26 21:41:34.293 UTC [37615][postmaster] LOG:  database system is shut down