2025-02-24 21:59:11.962 UTC postmaster[25726] LOG: starting PostgreSQL 18devel on aarch64-darwin, compiled by clang-16.0.0, 64-bit 2025-02-24 21:59:11.962 UTC postmaster[25726] LOG: listening on Unix socket "/var/folders/xf/_tm0f94d66n8kr12tqwrylrr0000gn/T/pg_regress-MlZ49G/.s.PGSQL.40041" 2025-02-24 21:59:11.969 UTC startup[25729] LOG: database system was shut down at 2025-02-24 21:57:35 UTC 2025-02-24 21:59:11.970 UTC postmaster[25726] LOG: database system is ready to accept connections 2025-02-24 21:59:12.151 UTC client backend[25755] pg_regress/postgres_fdw ERROR: parameter "extensions" must be a list of extension names 2025-02-24 21:59:12.151 UTC client backend[25755] pg_regress/postgres_fdw STATEMENT: ALTER SERVER testserver1 OPTIONS (ADD extensions 'foo; bar'); 2025-02-24 21:59:12.151 UTC client backend[25755] pg_regress/postgres_fdw WARNING: extension "foo" is not installed 2025-02-24 21:59:12.151 UTC client backend[25755] pg_regress/postgres_fdw WARNING: extension "bar" is not installed 2025-02-24 21:59:12.151 UTC client backend[25755] pg_regress/postgres_fdw ERROR: invalid option "sslmode" 2025-02-24 21:59:12.151 UTC client backend[25755] pg_regress/postgres_fdw STATEMENT: ALTER USER MAPPING FOR public SERVER testserver1 OPTIONS (ADD sslmode 'require'); 2025-02-24 21:59:12.165 UTC client backend[25759] [unknown] FATAL: database "no such database" does not exist 2025-02-24 21:59:12.166 UTC client backend[25755] pg_regress/postgres_fdw ERROR: could not connect to server "loopback" 2025-02-24 21:59:12.166 UTC client backend[25755] pg_regress/postgres_fdw DETAIL: connection to server on socket "/var/folders/xf/_tm0f94d66n8kr12tqwrylrr0000gn/T//pg_regress-MlZ49G/.s.PGSQL.40041" failed: FATAL: database "no such database" does not exist 2025-02-24 21:59:12.166 UTC client backend[25755] pg_regress/postgres_fdw STATEMENT: SELECT c3, c4 FROM ft1 ORDER BY c3, c1 LIMIT 1; 2025-02-24 21:59:12.175 UTC client backend[25761] [unknown] FATAL: role "no such user" does not exist 2025-02-24 21:59:12.176 UTC client backend[25755] pg_regress/postgres_fdw ERROR: could not connect to server "loopback" 2025-02-24 21:59:12.176 UTC client backend[25755] pg_regress/postgres_fdw DETAIL: connection to server on socket "/var/folders/xf/_tm0f94d66n8kr12tqwrylrr0000gn/T//pg_regress-MlZ49G/.s.PGSQL.40041" failed: FATAL: role "no such user" does not exist 2025-02-24 21:59:12.176 UTC client backend[25755] pg_regress/postgres_fdw STATEMENT: SELECT c3, c4 FROM ft1 ORDER BY c3, c1 LIMIT 1; 2025-02-24 21:59:12.192 UTC client backend[25755] pg_regress/postgres_fdw ERROR: cannot add relation "ft1" to publication 2025-02-24 21:59:12.192 UTC client backend[25755] pg_regress/postgres_fdw DETAIL: This operation is not supported for foreign tables. 2025-02-24 21:59:12.192 UTC client backend[25755] pg_regress/postgres_fdw STATEMENT: CREATE PUBLICATION testpub_ftbl FOR TABLE ft1; 2025-02-24 21:59:12.235 UTC client backend[25755] pg_regress/postgres_fdw ERROR: access to non-system foreign table is restricted 2025-02-24 21:59:12.235 UTC client backend[25755] pg_regress/postgres_fdw STATEMENT: SELECT * from ft1 where c1 < 1; 2025-02-24 21:59:12.235 UTC client backend[25755] pg_regress/postgres_fdw ERROR: access to non-system foreign table is restricted 2025-02-24 21:59:12.235 UTC client backend[25755] pg_regress/postgres_fdw STATEMENT: INSERT INTO ft1 (c1) VALUES (1); 2025-02-24 21:59:12.235 UTC client backend[25755] pg_regress/postgres_fdw ERROR: access to non-system foreign table is restricted 2025-02-24 21:59:12.235 UTC client backend[25755] pg_regress/postgres_fdw STATEMENT: DELETE FROM ft1 WHERE c1 = 1; 2025-02-24 21:59:12.235 UTC client backend[25755] pg_regress/postgres_fdw ERROR: access to non-system foreign table is restricted 2025-02-24 21:59:12.235 UTC client backend[25755] pg_regress/postgres_fdw STATEMENT: TRUNCATE ft1; TRAP: failed Assert("plan->workmem == 0"), File: "../src/backend/executor/execWorkmem.c", Line: 188, PID: 25774 0 postgres 0x0000000100745f9c ExceptionalCondition + 108 1 postgres 0x00000001004774e4 prepare_sql_fn_parse_info + 0 2 postgres 0x0000000100477368 assign_workmem_plan + 736 3 postgres 0x0000000100477368 assign_workmem_plan + 736 4 postgres 0x0000000100477374 assign_workmem_plan + 748 5 postgres 0x0000000100477368 assign_workmem_plan + 736 6 postgres 0x0000000100466bd4 standard_ExecutorStart + 1004 7 postgres 0x00000001003f9b24 ExplainOnePlan + 508 8 postgres 0x00000001003f98f4 standard_ExplainOneQuery + 396 9 postgres 0x00000001003f92ec ExplainQuery + 1444 10 postgres 0x0000000100614400 standard_ProcessUtility + 1572 11 postgres 0x0000000100613974 PortalRunUtility + 136 12 postgres 0x0000000100612d6c FillPortalStore + 256 13 postgres 0x0000000100612a78 PortalRun + 416 14 postgres 0x0000000100611a04 exec_simple_query + 1208 15 postgres 0x000000010060f688 PostgresMain + 3640 16 postgres 0x000000010060aba0 BackendInitialize + 0 17 postgres 0x00000001005701f4 PgArchShmemSize + 0 18 postgres 0x0000000100574280 ServerLoop + 4608 19 postgres 0x0000000100572818 InitProcessGlobals + 0 20 postgres 0x00000001004c08ec help + 0 21 dyld 0x00000001860df154 start + 2476 2025-02-24 21:59:32.193 UTC client backend[25785] pg_regress LOG: unexpected EOF on client connection with an open transaction 2025-02-24 21:59:32.193 UTC postmaster[25726] LOG: client backend (PID 25774) was terminated by signal 6: Abort trap: 6 2025-02-24 21:59:32.193 UTC postmaster[25726] 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-24 21:59:32.198 UTC postmaster[25726] LOG: terminating any other active server processes 2025-02-24 21:59:32.204 UTC postmaster[25726] LOG: all server processes terminated; reinitializing 2025-02-24 21:59:32.230 UTC startup[27170] LOG: database system was interrupted; last known up at 2025-02-24 21:59:11 UTC 2025-02-24 21:59:32.231 UTC startup[27170] LOG: database system was not properly shut down; automatic recovery in progress 2025-02-24 21:59:32.241 UTC startup[27170] LOG: redo starts at 0/176E5F8 2025-02-24 21:59:32.276 UTC startup[27170] LOG: invalid record length at 0/1C4DE90: expected at least 24, got 0 2025-02-24 21:59:32.276 UTC startup[27170] LOG: redo done at 0/1C4DE68 system usage: CPU: user: 0.00 s, system: 0.01 s, elapsed: 0.03 s 2025-02-24 21:59:32.286 UTC checkpointer[27171] LOG: checkpoint starting: end-of-recovery immediate wait 2025-02-24 21:59:32.369 UTC client backend[27191] [unknown] FATAL: the database system is not yet accepting connections 2025-02-24 21:59:32.369 UTC client backend[27191] [unknown] DETAIL: Consistent recovery state has not been yet reached. 2025-02-24 21:59:32.423 UTC postmaster[25726] LOG: received fast shutdown request 2025-02-24 21:59:32.423 UTC checkpointer[27171] LOG: checkpoint complete: wrote 1026 buffers (6.3%), wrote 3 SLRU buffers; 0 WAL file(s) added, 0 removed, 0 recycled; write=0.135 s, sync=0.001 s, total=0.138 s; sync files=0, longest=0.000 s, average=0.000 s; distance=4990 kB, estimate=4990 kB; lsn=0/1C4DE90, redo lsn=0/1C4DE90 2025-02-24 21:59:32.439 UTC checkpointer[27171] LOG: shutting down 2025-02-24 21:59:32.440 UTC checkpointer[27171] LOG: checkpoint starting: shutdown immediate 2025-02-24 21:59:32.440 UTC checkpointer[27171] LOG: checkpoint complete: wrote 0 buffers (0.0%), wrote 0 SLRU buffers; 0 WAL file(s) added, 0 removed, 0 recycled; write=0.001 s, sync=0.001 s, total=0.001 s; sync files=0, longest=0.000 s, average=0.000 s; distance=0 kB, estimate=4491 kB; lsn=0/1C4DF08, redo lsn=0/1C4DF08 2025-02-24 21:59:32.442 UTC postmaster[25726] LOG: database system is shut down