This robot generates gigabytes of CI logs every week. Here is an attempt to
search for "highlights", so it's easier to find actionable information
quickly. New ideas for what patterns to search for are very welcome.
"Current" shows only the most recent results from each submission. The
wider time ranges also show information about historical versions, which
may be useful for flapping tests, and also for hunting for bugs in master.
| 59/6812 |
Fix qual pushdown past grouping with mismatched equivalence |
 |
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/subselect.out /home/postgres/postgres/build/testrun/recovery/...
--- /home/postgres/postgres/src/test/regress/expected/subselect.out 2026-06-01 17:07:29.177649285 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/subselect.out 2026-06-01 17:09:46.097...
@@ -2036,159 +2036,82 @@
--
BEGIN;
CREATE TYPE t_rec AS (x numeric);
+ERROR: type "t_rec" already exists
CREATE TEMP TABLE pdt (id int, a t_rec);
+ERROR: current transaction is aborted, commands ignored until end of transaction block
INSERT INTO pdt VALUES
(1, ROW(1.00)::t_rec),
(2, ROW(1.0)::t_rec),
(3, ROW(2)::t_rec);
+ERROR: current transaction is aborted, commands ignored until end of transaction block
-- DISTINCT ON: conflict, qual stays in outer query
EXPLAIN (COSTS OFF)
SELECT * FROM (SELECT DISTINCT ON (a) id, a FROM pdt ORDER BY a, id) s
WHERE a *= ROW(1.0)::t_rec;
- QUERY PLAN
... |
| tap |
[17:11:06.959](107.434s) not ok 2 - regression tests pass |
| tap |
[17:09:59.191](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2026-06-01 17:07:28.919396115 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/subselect.out 2026-06-01 17:15:29.350395983 +0000
@@ -2036,159 +2036,82 @@
--
BEGIN;
CREATE TYPE t_rec AS (x numeric);
+ERROR: type "t_rec" already exists
CREATE TEMP TABLE pdt (id int, a t_rec);
+ERROR: current transaction is aborted, commands ignored until end of transaction block
INSERT INTO pdt VALUES
(1, ROW(1.00)::t_rec),
(2, ROW(1.0)::t_rec),
(3, ROW(2)::t_rec);
+ERROR: current transaction is aborted, commands ignored until end of transaction block
-- DISTINCT ON: conflict, qual stays in outer query
EXPLAIN (COSTS OFF)
SELECT * FROM (SELECT DISTINCT ON (a) id, a FROM pdt ORDER BY a, id) s
WHERE a *= ROW(1.0)::t_rec;
- QUERY PLAN
... |
| tap |
[17:18:00.191](208.514s) not ok 2 - regression tests pass |
| tap |
[17:20:16.633](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
| 59/6815 |
BUG Segfault triggered by reentrancy in ri_triggers.c |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out /tmp/cirrus-ci-build/build/testrun/regress-r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out 2026-06-01 16:27:47.933623000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress-running/regress/results/select_parallel.out 2026-06-01 16:37:08.513911000...
@@ -593,9 +593,9 @@
-> Gather (actual rows=9800.00 loops=10)
Workers Planned: 4
Workers Launched: 4
- -> Parallel Seq Scan on tenk1 (actual rows=1960.00 loops=50)
+ -> Parallel Seq Scan on tenk1 (actual rows=2882.35 loops=34)
Filter: (hundred > 1)
- Rows Removed by Filter: 40
+ Rows Removed by Filter: 59
(11 rows)
alter table tenk2 reset (parallel_workers); |
| tap |
[16:31:10.253](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
| 59/6216 |
Reduce unnecessary locking of pruned partitions when reusing cached plans |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/plancache.out /home/postgres/postgres/build/testrun/test_plan...
--- /home/postgres/postgres/src/test/regress/expected/plancache.out 2026-06-01 15:37:20.279325703 +0000
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/plancache.out 2026-06-01 15:4...
@@ -451,7 +451,6 @@
-- during this execution, which should force replanning without errors.
update inval_during_pruning_signal set create_idx = true;
explain (verbose, costs off) execute inval_during_pruning_q;
-NOTICE: creating index on partition inval_during_pruning_p1
QUERY PLAN
---------------------------------------------------------------------------
Append |
| tap |
[15:40:54.040](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
| tap |
[15:41:12.912](108.613s) not ok 1 - regression tests pass |
| 59/6479 |
SLOPE - Planner optimizations on monotonic expressions. |
|
CompilerWarnings |
| compiler |
[13:57:08.170] misc.c:1130:27: error: mixing declarations and code is incompatible with standards before C99 [-Werror,-W... |
| compiler |
[13:55:08.711] misc.c:1130:27: error: mixing declarations and code is incompatible with standards before C99 [-Werror,-W... |
| compiler |
[13:52:50.858] misc.c:1130:9: error: ISO C90 forbids mixed declarations and code [-Werror=declaration-after-statement] |
| compiler |
[13:51:00.332] misc.c:1130:9: error: ISO C90 forbids mixed declarations and code [-Werror=declaration-after-statement] |
| compiler |
[14:00:50.203] misc.c:1130:9: error: ISO C90 forbids mixed declarations and code [-Werror=declaration-after-statement] |
| 59/6653 |
SLOPE - Planner optimizations on monotonic expressions. |
|
CompilerWarnings |
| compiler |
[13:54:49.956] misc.c:1130:27: error: mixing declarations and code is incompatible with standards before C99 [-Werror,-W... |
| compiler |
[13:52:47.250] misc.c:1130:27: error: mixing declarations and code is incompatible with standards before C99 [-Werror,-W... |
| compiler |
[13:50:30.161] misc.c:1130:9: error: ISO C90 forbids mixed declarations and code [-Werror=declaration-after-statement] |
| compiler |
[13:48:39.684] misc.c:1130:9: error: ISO C90 forbids mixed declarations and code [-Werror=declaration-after-statement] |
| compiler |
[13:58:28.702] misc.c:1130:9: error: ISO C90 forbids mixed declarations and code [-Werror=declaration-after-statement] |
| 59/6584 |
ECPG: inconsistent behavior with the document in “GET/SET DESCRIPTOR.” |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| tap |
[09:46:33.683](0.035s) not ok 28 - ecpg rejects duplicate GET DESCRIPTOR header items: exit code not 0
[09:46:33.684](0.001s) not ok 29 - ecpg rejects duplicate GET DESCRIPTOR header items: matches
[09:46:33.719](0.034s) not ok 30 - ecpg rejects duplicate SET DESCRIPTOR header items: exit code not 0
[09:46:33.721](0.001s) not ok 31 - ecpg rejects duplicate SET DESCRIPTOR header items: matches |
| tap |
[09:40:42.933](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
|
macOS - Sequoia - Meson |
| core |
[09:49:27.085] * frame #0: 0x000000018c001640 libsystem_kernel.dylib`stat + 8
[09:49:27.085] frame #1: 0x0000000102214cac bash`___lldb_unnamed_symbol671 + 48
[09:49:27.085] frame #2: 0x000000010221548c bash`___lldb_unnamed_symbol683 + 148
[09:49:27.085] frame #3: 0x00000001022150cc bash`___lldb_unnamed_symbol679 + 268
[09:49:27.085] frame #4: 0x0000000102214ec4 bash`___lldb_unnamed_symbol678 + 88
[09:49:27.085] frame #5: 0x000000010220fd90 bash`___lldb_unnamed_symbol626 + 1912
[09:49:27.085] frame #6: 0x000000010220eb14 bash`___lldb_unnamed_symbol619 + 1760
[09:49:27.085] frame #7: 0x00000001022025cc bash`___lldb_unnamed_symbol467 + 1168
[09:49:27.085] frame #8: 0x00000001021f2450 bash`___lldb_unnamed_symbol211 + 176
[09:49:27.085] frame #9: 0x00000001021f1a88 bash`___lldb_unnamed_symbol203 + 4992 |
| core |
[09:48:44.452] * frame #0: 0x000000018bc92c04 dyld`stat + 8
[09:48:44.452] frame #1: 0x000000018bcfdf40 dyld`stat_with_subsystem + 56
[09:48:44.452] frame #2: 0x000000018bce26bc dyld`dyld3::stat(char const*, stat*) + 28
[09:48:44.452] frame #3: 0x000000018bcc078c dyld`dyld4::SyscallDelegate::fileExists(char const*, dyld4::FileID*, int...
[09:48:44.452] frame #4: 0x000000018bcbe310 dyld`invocation function for block in dyld4::PrebuiltLoader::invalidateI...
[09:48:44.452] frame #5: 0x000000018bc9a118 dyld`dyld4::ProcessConfig::PathOverrides::forEachPathVariant(char const*...
[09:48:44.452] frame #6: 0x000000018bcbe0e4 dyld`dyld4::PrebuiltLoader::invalidateInIsolation(dyld4::RuntimeState co...
[09:48:44.452] frame #7: 0x000000018bcbdd20 dyld`dyld4::PrebuiltLoader::isValid(dyld4::RuntimeState const&) const + ...
[09:48:44.452] frame #8: 0x000000018bca8e78 dyld`dyld4::RuntimeState::findPrebuiltLoader(char const*) const + 104
[09:48:44.452] frame #9: 0x000000018bcae928 dyld`dyld4::Loader::makeDyldCacheLoader(Diagnostics&, dyld4::RuntimeStat... |
| tap |
[09:42:44.218](0.025s) not ok 28 - ecpg rejects duplicate GET DESCRIPTOR header items: exit code not 0
[09:42:44.219](0.001s) not ok 29 - ecpg rejects duplicate GET DESCRIPTOR header items: matches
[09:42:44.241](0.022s) not ok 30 - ecpg rejects duplicate SET DESCRIPTOR header items: exit code not 0
[09:42:44.242](0.000s) not ok 31 - ecpg rejects duplicate SET DESCRIPTOR header items: matches |
| tap |
[09:38:59.239](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
|
Linux - Debian Trixie - Meson |
| tap |
[09:37:22.295](0.011s) not ok 28 - ecpg rejects duplicate GET DESCRIPTOR header items: exit code not 0
[09:37:22.299](0.002s) not ok 29 - ecpg rejects duplicate GET DESCRIPTOR header items: matches
[09:37:22.308](0.009s) not ok 30 - ecpg rejects duplicate SET DESCRIPTOR header items: exit code not 0
[09:37:22.309](0.000s) not ok 31 - ecpg rejects duplicate SET DESCRIPTOR header items: matches |
| test |
[09:39:31.628] 256/402 postgresql:ecpg / ecpg/001_ecpg_err_warn_msg ERROR ... |
|
NetBSD - Meson |
| tap |
[09:35:29.885](0.005s) not ok 28 - ecpg rejects duplicate GET DESCRIPTOR header items: exit code not 0
[09:35:29.886](0.000s) not ok 29 - ecpg rejects duplicate GET DESCRIPTOR header items: matches
[09:35:29.890](0.005s) not ok 30 - ecpg rejects duplicate SET DESCRIPTOR header items: exit code not 0
[09:35:29.891](0.000s) not ok 31 - ecpg rejects duplicate SET DESCRIPTOR header items: matches |
| tap |
[09:33:28.813](0.002s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
|
FreeBSD - Meson |
| core |
[09:43:53.990] #0 0x000000082bf735da in _sigprocmask () from /lib/libc.so.7
[09:43:53.990] #1 0x000000082bfb0a3c in _system () from /lib/libc.so.7
[09:43:53.990] #2 0x000000082b0a3953 in ?? () from /lib/libthr.so.3
[09:43:53.990] #3 0x00000000006b3909 in RestoreArchivedFile (path=path@entry=0x82152f1b0 "pg_wal/00000002", '0' <repeat...
[09:43:53.990] #4 0x00000000006999c8 in existsTimeLineHistory (probeTLI=probeTLI@entry=3) at ../src/backend/access/tran...
[09:43:53.990] #5 0x0000000000699a88 in findNewestTimeLine (startTLI=startTLI@entry=2) at ../src/backend/access/transam...
[09:43:53.990] #6 0x00000000006bf2fb in rescanLatestTimeLine (replayTLI=replayTLI@entry=2, replayLSN=replayLSN@entry=10...
[09:43:53.990] #7 0x00000000006bb020 in WaitForWALToBecomeAvailable (RecPtr=105376928, randAccess=false, fetching_ckpt=...
[09:43:53.990] #8 XLogPageRead (xlogreader=0x285791426c78, targetPagePtr=105373696, reqLen=3232, targetRecPtr=105376904...
[09:43:53.990] #9 0x00000000006c2b8c in ReadPageInternal (state=0x285791426c78, pageptr=pageptr@entry=105373696, reqLen... |
| tap |
[09:38:47.476](0.006s) not ok 28 - ecpg rejects duplicate GET DESCRIPTOR header items: exit code not 0
[09:38:47.477](0.000s) not ok 29 - ecpg rejects duplicate GET DESCRIPTOR header items: matches
[09:38:47.483](0.005s) not ok 30 - ecpg rejects duplicate SET DESCRIPTOR header items: exit code not 0
[09:38:47.485](0.001s) not ok 31 - ecpg rejects duplicate SET DESCRIPTOR header items: matches |
| tap |
[09:34:44.814](0.001s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
|
Linux - Debian Trixie - Autoconf |
| tap |
[09:32:24.945](0.021s) not ok 28 - ecpg rejects duplicate GET DESCRIPTOR header items: exit code not 0
[09:32:24.945](0.000s) not ok 29 - ecpg rejects duplicate GET DESCRIPTOR header items: matches
[09:32:24.970](0.024s) not ok 30 - ecpg rejects duplicate SET DESCRIPTOR header items: exit code not 0
[09:32:24.971](0.000s) not ok 31 - ecpg rejects duplicate SET DESCRIPTOR header items: matches |
| tap |
[09:42:51.401](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
| 59/6392 |
ALTER TABLE: notice when actions do not recurse to partitions |
 |
Windows - Server 2022, VS 2019 - Meson & ninja |
| compiler |
[09:31:42.892] ../src/test/modules/test_ddl_deparse/test_ddl_deparse.c(318): warning C4062: enumerator 'AT_SetSchema' in... |
| 59/6728 |
md: measure just FileSync() for pgstat_io without FileClose() |
|
FreeBSD - Meson |
| tap |
[04:15:30.067](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
| 59/6822 |
Update our timezone code to IANA tzcode2026b |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| compiler |
[01:23:28.495] ../src/timezone/zic.c(1654): warning C4146: unary minus operator applied to unsigned type, result still u... |
| 59/6482 |
Add table COMMENTS in CREATE TABLE LIKE |
|
NetBSD - Meson |
| tap |
[20:04:34.991](0.303s) not ok 22 - last inactive time for an active physical slot is NULL |
| tap |
[20:05:08.662](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
| 59/6763 |
Improve pg_stat_statements scalability |
|
Linux - Debian Trixie - Autoconf |
| core |
[18:06:22.913] #0 0x00007f8208e5c2c0 in ?? ()
[18:06:22.913] #1 0x0000000000000004 in ?? ()
[18:06:22.913] #2 0x00007ffe695cad77 in ?? ()
[18:06:22.913] #3 0x00007ffe695cad7a in ?? ()
[18:06:22.913] #4 0x00007ffe695cad7d in ?? ()
[18:06:22.913] #5 0x00007ffe695cad80 in ?? ()
[18:06:22.913] #6 0x0000000000000000 in ?? () |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/select.out /tmp/cirrus-ci-build/contrib/pg_stat_statem...
--- /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/select.out 2026-05-31 17:50:19.975968877 +0000
+++ /tmp/cirrus-ci-build/contrib/pg_stat_statements/results/select.out 2026-05-31 17:58:32.406714251 +0000
@@ -2,14 +2,14 @@
-- SELECT statements
--
CREATE EXTENSION pg_stat_statements;
+ERROR: extension "pg_stat_statements" has no installation script nor update path for version "1.14"
SET pg_stat_statements.track_utility = FALSE;
SET pg_stat_statements.track_planning = TRUE;
SELECT pg_stat_statements_reset() IS NOT NULL AS t;
- t
----
- t
-(1 row)
-
+ERROR: function pg_stat_statements_reset() does not exist
+LINE 1: SELECT pg_stat_statements_reset() IS NOT NULL AS t;
+ ^
+DETAIL: There is no function of that name.
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/test_ddl_deparse/expected/create_extension.out /tmp/cirrus-ci-build/src/t...
--- /tmp/cirrus-ci-build/src/test/modules/test_ddl_deparse/expected/create_extension.out 2026-05-31 17:50:21.627968912 +...
+++ /tmp/cirrus-ci-build/src/test/modules/test_ddl_deparse/results/create_extension.out 2026-05-31 17:58:35.990708071 +0...
@@ -2,4 +2,4 @@
--- CREATE_EXTENSION
---
CREATE EXTENSION pg_stat_statements;
-NOTICE: DDL test: type simple, tag CREATE EXTENSION
+ERROR: extension "pg_stat_statements" has no installation script nor update path for version "1.14" |
| tap |
[18:03:28.210](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
| 59/6749 |
Disallow whole-row index references with virtual generated columns? |
|
NetBSD - Meson |
| tap |
[15:27:25.200](0.001s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
| 59/6390 |
Add ldapservice connection parameter |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/date.out /home/postgres/postgres/build/testrun/test_plan_advi...
--- /home/postgres/postgres/src/test/regress/expected/date.out 2026-05-31 13:32:13.154793184 +0000
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/date.out 2026-05-31 13:33:11....
@@ -1,1536 +1,2 @@
---
--- DATE
---
-CREATE TABLE DATE_TBL (f1 date);
-INSERT INTO DATE_TBL VALUES ('1957-04-09');
-INSERT INTO DATE_TBL VALUES ('1957-06-13');
-INSERT INTO DATE_TBL VALUES ('1996-02-28');
-INSERT INTO DATE_TBL VALUES ('1996-02-29');
-INSERT INTO DATE_TBL VALUES ('1996-03-01');
-INSERT INTO DATE_TBL VALUES ('1996-03-02');
-INSERT INTO DATE_TBL VALUES ('1997-02-28');
-INSERT INTO DATE_TBL VALUES ('1997-02-29');
-ERROR: date/time field value out of range: "1997-02-29"
-LINE 1: INSERT INTO DATE_TBL VALUES ('1997-02-29');
- ^
-INSERT INTO DATE_TBL VALUES ('1997-03-01');
... |
| tap |
[13:34:28.467](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
| tap |
[13:34:46.046](96.204s) not ok 1 - regression tests pass |
| 59/6426 |
Avoid recalculating pgprocno in ProcArrayAdd() |
|
FreeBSD - Meson |
| core |
[11:42:46.315] #0 0x000000082b27a5da in _sigprocmask () from /lib/libc.so.7
[11:42:46.315] #1 0x000000082b2b7a3c in _system () from /lib/libc.so.7
[11:42:46.315] #2 0x000000082bfcd953 in ?? () from /lib/libthr.so.3
[11:42:46.315] #3 0x00000000006b3909 in RestoreArchivedFile (path=path@entry=0x8213021b0 "pg_wal/00000003.history", xlo...
[11:42:46.315] #4 0x00000000006bf510 in XLogFileRead (segno=segno@entry=6, tli=tli@entry=2, source=source@entry=XLOG_FR...
[11:42:46.315] #5 0x00000000006bb2ab in XLogFileReadAnyTLI (segno=6, source=XLOG_FROM_ANY) at ../src/backend/access/tra...
[11:42:46.315] #6 WaitForWALToBecomeAvailable (RecPtr=105376928, randAccess=false, fetching_ckpt=false, tliRecPtr=10537...
[11:42:46.315] #7 XLogPageRead (xlogreader=0x3059c5626c78, targetPagePtr=105373696, reqLen=3232, targetRecPtr=105376904...
[11:42:46.315] #8 0x00000000006c2b8c in ReadPageInternal (state=0x3059c5626c78, pageptr=pageptr@entry=105373696, reqLen...
[11:42:46.315] #9 0x00000000006c1935 in XLogDecodeNextRecord (state=0x3059c5626c78, nonblocking=false) at ../src/backen... |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out /tmp/cirrus-ci-build/build/testrun/postgres...
--- /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out 2026-05-31 11:28:55.110280000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/postgres_fdw-running/regress/results/postgres_fdw.out 2026-05-31 11:39:23.7216590...
@@ -12966,8 +12966,7 @@
FROM postgres_fdw_get_connections(true);
server_name | closed | remote_backend_pid
-------------+--------+--------------------
- loopback | f | t
-(1 row)
+(0 rows)
-- After terminating the remote backend, since the connection is closed,
-- "closed" should be TRUE, or NULL if the connection status check
@@ -12983,8 +12982,7 @@
FROM postgres_fdw_get_connections(true);
server_name | closed | remote_backend_pid
-------------+--------+--------------------
- loopback | t | t
-(1 row)
+(0 rows)
... |
| tap |
[11:33:01.480](0.001s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
| 59/6574 |
Compress prune/freeze records with Delta Frame of Reference algorithm |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| compiler |
[11:29:04.188] ../src/test/dfor/test_dfor_u16.c(469): warning C4305: 'function': truncation from 'double' to 'float' |
| compiler |
[11:29:04.188] ../src/test/dfor/test_dfor_u16.c(529): warning C4305: 'function': truncation from 'double' to 'float' |
| compiler |
[11:29:04.188] ../src/test/dfor/test_dfor_u16.c(501): warning C4305: 'function': truncation from 'double' to 'float' |
| compiler |
[11:29:04.188] ../src/test/dfor/test_dfor_u16.c(487): warning C4305: 'function': truncation from 'double' to 'float' |
| compiler |
[11:29:04.188] ../src/test/dfor/test_dfor_u16.c(428): warning C4305: 'function': truncation from 'double' to 'float' |
| compiler |
[11:29:04.188] ../src/test/dfor/test_dfor_u16.c(441): warning C4305: 'function': truncation from 'double' to 'float' |
| 59/4337 |
Incremental View Maintenance (IVM), take 2 |
|
CompilerWarnings |
| compiler |
[05:24:49.118] matview.c:168:22: error: no previous extern declaration for non-static variable 'IvmShmemCallbacks' [-Wer... |
| compiler |
[05:24:04.932] matview.c:168:22: error: no previous extern declaration for non-static variable 'IvmShmemCallbacks' [-Wer... |
| compiler |
[05:22:59.713] matview.c:168:22: error: no previous declaration for ‘IvmShmemCallbacks’ [-Werror=missing-variable-declar... |
| compiler |
[05:22:23.122] matview.c:168:22: error: no previous declaration for ‘IvmShmemCallbacks’ [-Werror=missing-variable-declar... |
| compiler |
[05:26:15.221] matview.c:168:22: error: no previous declaration for ‘IvmShmemCallbacks’ [-Werror=missing-variable-declar... |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/incremental_matview.out C:/cirrus/build/testrun/pg_upgr...
--- C:/cirrus/src/test/regress/expected/incremental_matview.out 2026-05-31 05:21:16.952357200 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/incremental_matview.out 2026-05-31 05:25:42.313678500...
@@ -544,7 +544,7 @@
ROLLBACK;
BEGIN;
CREATE INCREMENTAL MATERIALIZED VIEW mv_ivm_agg(a,b,c) AS SELECT i, SUM(j) FROM mv_base_a GROUP BY i;
-ERROR: too many column names were specified
+NOTICE: created index "mv_ivm_agg_index" on materialized view "mv_ivm_agg"
ROLLBACK;
-- support self join view and multiple change on the same table
BEGIN; |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/incremental_matview.out C:/cirrus/build/testrun/recover...
--- C:/cirrus/src/test/regress/expected/incremental_matview.out 2026-05-31 05:21:16.952357200 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/incremental_matview.out 2026-05-31 05:29:43.1960107...
@@ -544,7 +544,7 @@
ROLLBACK;
BEGIN;
CREATE INCREMENTAL MATERIALIZED VIEW mv_ivm_agg(a,b,c) AS SELECT i, SUM(j) FROM mv_base_a GROUP BY i;
-ERROR: too many column names were specified
+NOTICE: created index "mv_ivm_agg_index" on materialized view "mv_ivm_agg"
ROLLBACK;
-- support self join view and multiple change on the same table
BEGIN; |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/incremental_matview.out C:/cirrus/build/testrun/regress...
--- C:/cirrus/src/test/regress/expected/incremental_matview.out 2026-05-31 05:21:16.952357200 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/incremental_matview.out 2026-05-31 05:25:36.112985300 +0000
@@ -544,7 +544,7 @@
ROLLBACK;
BEGIN;
CREATE INCREMENTAL MATERIALIZED VIEW mv_ivm_agg(a,b,c) AS SELECT i, SUM(j) FROM mv_base_a GROUP BY i;
-ERROR: too many column names were specified
+NOTICE: created index "mv_ivm_agg_index" on materialized view "mv_ivm_agg"
ROLLBACK;
-- support self join view and multiple change on the same table
BEGIN; |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/incremental_matview.out C:/cirrus/build/testrun/test_pl...
--- C:/cirrus/src/test/regress/expected/incremental_matview.out 2026-05-31 05:21:16.952357200 +0000
+++ C:/cirrus/build/testrun/test_plan_advice/001_replan_regress/data/results/incremental_matview.out 2026-05-31 05:25:41...
@@ -544,7 +544,7 @@
ROLLBACK;
BEGIN;
CREATE INCREMENTAL MATERIALIZED VIEW mv_ivm_agg(a,b,c) AS SELECT i, SUM(j) FROM mv_base_a GROUP BY i;
-ERROR: too many column names were specified
+NOTICE: created index "mv_ivm_agg_index" on materialized view "mv_ivm_agg"
ROLLBACK;
-- support self join view and multiple change on the same table
BEGIN; |
| tap |
[05:27:13.294](193.444s) not ok 5 - regression tests in old instance |
| tap |
[05:31:02.754](172.601s) not ok 2 - regression tests pass |
| tap |
[05:30:28.093](0.001s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
| tap |
[05:27:14.171](203.634s) not ok 1 - regression tests pass |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/incremental_matview.out /Users/admin/pgsql/build/testrun/pg_upgrad...
--- /Users/admin/pgsql/src/test/regress/expected/incremental_matview.out 2026-05-31 05:20:33
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/incremental_matview.out 2026-05-31 05:26:53
@@ -544,7 +544,7 @@
ROLLBACK;
BEGIN;
CREATE INCREMENTAL MATERIALIZED VIEW mv_ivm_agg(a,b,c) AS SELECT i, SUM(j) FROM mv_base_a GROUP BY i;
-ERROR: too many column names were specified
+NOTICE: created index "mv_ivm_agg_index" on materialized view "mv_ivm_agg"
ROLLBACK;
-- support self join view and multiple change on the same table
BEGIN; |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/incremental_matview.out /Users/admin/pgsql/build/testrun/recovery/...
--- /Users/admin/pgsql/src/test/regress/expected/incremental_matview.out 2026-05-31 05:20:33
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/incremental_matview.out 2026-05-31 05:28:4...
@@ -544,7 +544,7 @@
ROLLBACK;
BEGIN;
CREATE INCREMENTAL MATERIALIZED VIEW mv_ivm_agg(a,b,c) AS SELECT i, SUM(j) FROM mv_base_a GROUP BY i;
-ERROR: too many column names were specified
+NOTICE: created index "mv_ivm_agg_index" on materialized view "mv_ivm_agg"
ROLLBACK;
-- support self join view and multiple change on the same table
BEGIN; |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/incremental_matview.out /Users/admin/pgsql/build/testrun/regress/r...
--- /Users/admin/pgsql/src/test/regress/expected/incremental_matview.out 2026-05-31 05:20:33
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/incremental_matview.out 2026-05-31 05:26:49
@@ -544,7 +544,7 @@
ROLLBACK;
BEGIN;
CREATE INCREMENTAL MATERIALIZED VIEW mv_ivm_agg(a,b,c) AS SELECT i, SUM(j) FROM mv_base_a GROUP BY i;
-ERROR: too many column names were specified
+NOTICE: created index "mv_ivm_agg_index" on materialized view "mv_ivm_agg"
ROLLBACK;
-- support self join view and multiple change on the same table
BEGIN; |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/incremental_matview.out /Users/admin/pgsql/build/testrun/test_plan...
--- /Users/admin/pgsql/src/test/regress/expected/incremental_matview.out 2026-05-31 05:20:33
+++ /Users/admin/pgsql/build/testrun/test_plan_advice/001_replan_regress/data/results/incremental_matview.out 2026-05-31...
@@ -544,7 +544,7 @@
ROLLBACK;
BEGIN;
CREATE INCREMENTAL MATERIALIZED VIEW mv_ivm_agg(a,b,c) AS SELECT i, SUM(j) FROM mv_base_a GROUP BY i;
-ERROR: too many column names were specified
+NOTICE: created index "mv_ivm_agg_index" on materialized view "mv_ivm_agg"
ROLLBACK;
-- support self join view and multiple change on the same table
BEGIN; |
| tap |
[05:27:44.895](130.626s) not ok 5 - regression tests in old instance |
| tap |
[05:29:18.741](70.788s) not ok 2 - regression tests pass |
| tap |
[05:28:52.403](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
| tap |
[05:27:49.224](142.315s) not ok 1 - regression tests pass |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/incremental_matview.out /tmp/cirrus-ci-build/build/testrun/pg_up...
--- /tmp/cirrus-ci-build/src/test/regress/expected/incremental_matview.out 2026-05-31 05:21:18.581622911 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/incremental_matview.out 2026-05-31 05:26:3...
@@ -544,7 +544,7 @@
ROLLBACK;
BEGIN;
CREATE INCREMENTAL MATERIALIZED VIEW mv_ivm_agg(a,b,c) AS SELECT i, SUM(j) FROM mv_base_a GROUP BY i;
-ERROR: too many column names were specified
+NOTICE: created index "mv_ivm_agg_index" on materialized view "mv_ivm_agg"
ROLLBACK;
-- support self join view and multiple change on the same table
BEGIN; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/incremental_matview.out /tmp/cirrus-ci-build/build/testrun/recov...
--- /tmp/cirrus-ci-build/src/test/regress/expected/incremental_matview.out 2026-05-31 05:21:18.581622911 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/incremental_matview.out 2026-05-31 05:28...
@@ -544,7 +544,7 @@
ROLLBACK;
BEGIN;
CREATE INCREMENTAL MATERIALIZED VIEW mv_ivm_agg(a,b,c) AS SELECT i, SUM(j) FROM mv_base_a GROUP BY i;
-ERROR: too many column names were specified
+NOTICE: created index "mv_ivm_agg_index" on materialized view "mv_ivm_agg"
ROLLBACK;
-- support self join view and multiple change on the same table
BEGIN; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/incremental_matview.out /tmp/cirrus-ci-build/build/testrun/regre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/incremental_matview.out 2026-05-31 05:21:18.581622911 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/incremental_matview.out 2026-05-31 05:26:29.648393454 +00...
@@ -544,7 +544,7 @@
ROLLBACK;
BEGIN;
CREATE INCREMENTAL MATERIALIZED VIEW mv_ivm_agg(a,b,c) AS SELECT i, SUM(j) FROM mv_base_a GROUP BY i;
-ERROR: too many column names were specified
+NOTICE: created index "mv_ivm_agg_index" on materialized view "mv_ivm_agg"
ROLLBACK;
-- support self join view and multiple change on the same table
BEGIN; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/incremental_matview.out /tmp/cirrus-ci-build/build/testrun/test_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/incremental_matview.out 2026-05-31 05:21:18.581622911 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/incremental_matview.out 2026-05-...
@@ -544,7 +544,7 @@
ROLLBACK;
BEGIN;
CREATE INCREMENTAL MATERIALIZED VIEW mv_ivm_agg(a,b,c) AS SELECT i, SUM(j) FROM mv_base_a GROUP BY i;
-ERROR: too many column names were specified
+NOTICE: created index "mv_ivm_agg_index" on materialized view "mv_ivm_agg"
ROLLBACK;
-- support self join view and multiple change on the same table
BEGIN; |
| tap |
[05:27:14.292](93.500s) not ok 5 - regression tests in old instance |
| tap |
[05:28:53.913](88.311s) not ok 2 - regression tests pass |
| tap |
[05:27:18.145](100.993s) not ok 1 - regression tests pass |
| test |
[05:32:47.891] 11/402 postgresql:regress / regress/regress ERROR ...
[05:32:47.891] 30/402 postgresql:test_plan_advice / test_plan_advice/001_replan_regress ERROR 1...
[05:32:47.891] 44/402 postgresql:isolation / isolation/isolation ERROR ...
[05:32:47.891] 27/402 postgresql:pg_upgrade / pg_upgrade/002_pg_upgrade ERROR 1...
[05:32:47.891] 113/402 postgresql:recovery / recovery/027_stream_regress ERROR 1... |
|
FreeBSD - Meson |
| core |
[05:33:45.732] #0 0x0000000828e825da in _sigprocmask () from /lib/libc.so.7
[05:33:45.732] #1 0x0000000828ebfa3c in _system () from /lib/libc.so.7
[05:33:45.732] #2 0x000000082a38f953 in ?? () from /lib/libthr.so.3
[05:33:45.732] #3 0x00000000006b6999 in RestoreArchivedFile (path=path@entry=0x8211ec1b0 "\006", xlogfname=xlogfname@en...
[05:33:45.732] #4 0x00000000006c25a0 in XLogFileRead (segno=segno@entry=4, tli=tli@entry=2, source=source@entry=XLOG_FR...
[05:33:45.732] #5 0x00000000006be33b in XLogFileReadAnyTLI (segno=4, source=XLOG_FROM_ANY) at ../src/backend/access/tra...
[05:33:45.732] #6 WaitForWALToBecomeAvailable (RecPtr=67202840, randAccess=false, fetching_ckpt=false, tliRecPtr=672028...
[05:33:45.732] #7 XLogPageRead (xlogreader=0x1b2ecfe27068, targetPagePtr=67198976, reqLen=3864, targetRecPtr=67202816, ...
[05:33:45.732] #8 0x00000000006c5c1c in ReadPageInternal (state=0x1b2ecfe27068, pageptr=pageptr@entry=67198976, reqLen=...
[05:33:45.732] #9 0x00000000006c49c5 in XLogDecodeNextRecord (state=0x1b2ecfe27068, nonblocking=false) at ../src/backen... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/incremental_matview.out /tmp/cirrus-ci-build/build/testrun/pg_up...
--- /tmp/cirrus-ci-build/src/test/regress/expected/incremental_matview.out 2026-05-31 05:21:15.700393000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/incremental_matview.out 2026-05-31 05:25:1...
@@ -544,7 +544,7 @@
ROLLBACK;
BEGIN;
CREATE INCREMENTAL MATERIALIZED VIEW mv_ivm_agg(a,b,c) AS SELECT i, SUM(j) FROM mv_base_a GROUP BY i;
-ERROR: too many column names were specified
+NOTICE: created index "mv_ivm_agg_index" on materialized view "mv_ivm_agg"
ROLLBACK;
-- support self join view and multiple change on the same table
BEGIN; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/incremental_matview.out /tmp/cirrus-ci-build/build/testrun/recov...
--- /tmp/cirrus-ci-build/src/test/regress/expected/incremental_matview.out 2026-05-31 05:21:15.700393000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/incremental_matview.out 2026-05-31 05:26...
@@ -544,7 +544,7 @@
ROLLBACK;
BEGIN;
CREATE INCREMENTAL MATERIALIZED VIEW mv_ivm_agg(a,b,c) AS SELECT i, SUM(j) FROM mv_base_a GROUP BY i;
-ERROR: too many column names were specified
+NOTICE: created index "mv_ivm_agg_index" on materialized view "mv_ivm_agg"
ROLLBACK;
-- support self join view and multiple change on the same table
BEGIN; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/incremental_matview.out /tmp/cirrus-ci-build/build/testrun/regre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/incremental_matview.out 2026-05-31 05:21:15.700393000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/incremental_matview.out 2026-05-31 05:25:03.827821000 +00...
@@ -544,7 +544,7 @@
ROLLBACK;
BEGIN;
CREATE INCREMENTAL MATERIALIZED VIEW mv_ivm_agg(a,b,c) AS SELECT i, SUM(j) FROM mv_base_a GROUP BY i;
-ERROR: too many column names were specified
+NOTICE: created index "mv_ivm_agg_index" on materialized view "mv_ivm_agg"
ROLLBACK;
-- support self join view and multiple change on the same table
BEGIN; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/incremental_matview.out /tmp/cirrus-ci-build/build/testrun/test_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/incremental_matview.out 2026-05-31 05:21:15.700393000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/incremental_matview.out 2026-05-...
@@ -544,7 +544,7 @@
ROLLBACK;
BEGIN;
CREATE INCREMENTAL MATERIALIZED VIEW mv_ivm_agg(a,b,c) AS SELECT i, SUM(j) FROM mv_base_a GROUP BY i;
-ERROR: too many column names were specified
+NOTICE: created index "mv_ivm_agg_index" on materialized view "mv_ivm_agg"
ROLLBACK;
-- support self join view and multiple change on the same table
BEGIN; |
| tap |
[05:27:35.624](266.999s) not ok 5 - regression tests in old instance |
| tap |
[05:28:40.700](260.415s) not ok 2 - regression tests pass |
| tap |
[05:25:16.073](0.002s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
| tap |
[05:27:42.493](276.120s) not ok 1 - regression tests pass |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/incremental_matview.out /home/postgres/postgres/build/testrun...
--- /home/postgres/postgres/src/test/regress/expected/incremental_matview.out 2026-05-31 05:21:40.864677627 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/incremental_matview.out 2026-05-31 05:2...
@@ -544,7 +544,7 @@
ROLLBACK;
BEGIN;
CREATE INCREMENTAL MATERIALIZED VIEW mv_ivm_agg(a,b,c) AS SELECT i, SUM(j) FROM mv_base_a GROUP BY i;
-ERROR: too many column names were specified
+NOTICE: created index "mv_ivm_agg_index" on materialized view "mv_ivm_agg"
ROLLBACK;
-- support self join view and multiple change on the same table
BEGIN; |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/incremental_matview.out /home/postgres/postgres/build/testrun...
--- /home/postgres/postgres/src/test/regress/expected/incremental_matview.out 2026-05-31 05:21:40.864677627 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/incremental_matview.out 2026-05-31 05...
@@ -544,7 +544,7 @@
ROLLBACK;
BEGIN;
CREATE INCREMENTAL MATERIALIZED VIEW mv_ivm_agg(a,b,c) AS SELECT i, SUM(j) FROM mv_base_a GROUP BY i;
-ERROR: too many column names were specified
+NOTICE: created index "mv_ivm_agg_index" on materialized view "mv_ivm_agg"
ROLLBACK;
-- support self join view and multiple change on the same table
BEGIN; |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/incremental_matview.out /home/postgres/postgres/build/testrun...
--- /home/postgres/postgres/src/test/regress/expected/incremental_matview.out 2026-05-31 05:21:40.864677627 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/incremental_matview.out 2026-05-31 05:24:55.926112296 ...
@@ -544,7 +544,7 @@
ROLLBACK;
BEGIN;
CREATE INCREMENTAL MATERIALIZED VIEW mv_ivm_agg(a,b,c) AS SELECT i, SUM(j) FROM mv_base_a GROUP BY i;
-ERROR: too many column names were specified
+NOTICE: created index "mv_ivm_agg_index" on materialized view "mv_ivm_agg"
ROLLBACK;
-- support self join view and multiple change on the same table
BEGIN; |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/incremental_matview.out /home/postgres/postgres/build/testrun...
--- /home/postgres/postgres/src/test/regress/expected/incremental_matview.out 2026-05-31 05:21:40.864677627 +0000
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/incremental_matview.out 2026-...
@@ -544,7 +544,7 @@
ROLLBACK;
BEGIN;
CREATE INCREMENTAL MATERIALIZED VIEW mv_ivm_agg(a,b,c) AS SELECT i, SUM(j) FROM mv_base_a GROUP BY i;
-ERROR: too many column names were specified
+NOTICE: created index "mv_ivm_agg_index" on materialized view "mv_ivm_agg"
ROLLBACK;
-- support self join view and multiple change on the same table
BEGIN; |
| tap |
[05:25:44.095](93.474s) not ok 5 - regression tests in old instance |
| tap |
[05:26:32.908](100.205s) not ok 2 - regression tests pass |
| tap |
[05:25:33.121](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
| tap |
[05:25:55.753](107.931s) not ok 1 - regression tests pass |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/incremental_matview.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/incremental_matview.out 2026-05-31 05:21:25.430109571 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/incremental_matview.out 2026-05-31 05:30:20.565769961 +000...
@@ -544,7 +544,7 @@
ROLLBACK;
BEGIN;
CREATE INCREMENTAL MATERIALIZED VIEW mv_ivm_agg(a,b,c) AS SELECT i, SUM(j) FROM mv_base_a GROUP BY i;
-ERROR: too many column names were specified
+NOTICE: created index "mv_ivm_agg_index" on materialized view "mv_ivm_agg"
ROLLBACK;
-- support self join view and multiple change on the same table
BEGIN; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/incremental_matview.out /tmp/cirrus-ci-build/src/test/modules/te...
--- /tmp/cirrus-ci-build/src/test/regress/expected/incremental_matview.out 2026-05-31 05:21:25.430109571 +0000
+++ /tmp/cirrus-ci-build/src/test/modules/test_plan_advice/tmp_check/results/incremental_matview.out 2026-05-31 05:33:36...
@@ -544,7 +544,7 @@
ROLLBACK;
BEGIN;
CREATE INCREMENTAL MATERIALIZED VIEW mv_ivm_agg(a,b,c) AS SELECT i, SUM(j) FROM mv_base_a GROUP BY i;
-ERROR: too many column names were specified
+NOTICE: created index "mv_ivm_agg_index" on materialized view "mv_ivm_agg"
ROLLBACK;
-- support self join view and multiple change on the same table
BEGIN; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/incremental_matview.out /tmp/cirrus-ci-build/src/test/recovery/t...
--- /tmp/cirrus-ci-build/src/test/regress/expected/incremental_matview.out 2026-05-31 05:21:25.430109571 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/incremental_matview.out 2026-05-31 05:32:37.049716856 +0000
@@ -544,7 +544,7 @@
ROLLBACK;
BEGIN;
CREATE INCREMENTAL MATERIALIZED VIEW mv_ivm_agg(a,b,c) AS SELECT i, SUM(j) FROM mv_base_a GROUP BY i;
-ERROR: too many column names were specified
+NOTICE: created index "mv_ivm_agg_index" on materialized view "mv_ivm_agg"
ROLLBACK;
-- support self join view and multiple change on the same table
BEGIN; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/incremental_matview.out /tmp/cirrus-ci-build/src/test/regress/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/incremental_matview.out 2026-05-31 05:21:25.430109571 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/incremental_matview.out 2026-05-31 05:27:47.685846531 +0000
@@ -544,7 +544,7 @@
ROLLBACK;
BEGIN;
CREATE INCREMENTAL MATERIALIZED VIEW mv_ivm_agg(a,b,c) AS SELECT i, SUM(j) FROM mv_base_a GROUP BY i;
-ERROR: too many column names were specified
+NOTICE: created index "mv_ivm_agg_index" on materialized view "mv_ivm_agg"
ROLLBACK;
-- support self join view and multiple change on the same table
BEGIN; |
| tap |
[05:32:10.848](193.017s) not ok 5 - regression tests in old instance |
| tap |
[05:34:35.284](153.548s) not ok 1 - regression tests pass |
| tap |
[05:34:08.849](206.760s) not ok 2 - regression tests pass |
| tap |
[05:36:20.260](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
| 59/6428 |
BUG #19369: Not documented that io_uring on kernel versions between 5.1 and below 5.6 does not work |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| tap |
[04:01:29.032](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
| tap |
[04:15:18.812](382.884s) # poll_query_until timed out executing this query:
[04:15:18.880](0.001s) # die: timed out waiting for catchup at C:/cirrus/src/test/subscription/t/001_rep_changes.pl line...
timed out waiting for catchup at C:/cirrus/src/test/subscription/t/001_rep_changes.pl line 509. |
| 59/6543 |
synchronized_standby_slots behavior inconsistent with quorum-based synchronous replication |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/modules/unsafe_tests/expected/guc_privs.out C:/cirrus/build/testrun/unsa...
--- C:/cirrus/src/test/modules/unsafe_tests/expected/guc_privs.out 2026-05-31 00:43:34.551149400 +0000
+++ C:/cirrus/build/testrun/unsafe_tests/regress/results/guc_privs.out 2026-05-31 00:53:49.964206300 +0000
@@ -590,8 +590,7 @@
-- Cannot set synchronized_standby_slots to an invalid slot name
ALTER SYSTEM SET synchronized_standby_slots='invalid*';
ERROR: invalid value for parameter "synchronized_standby_slots": "invalid*"
-DETAIL: replication slot name "invalid*" contains invalid character
-HINT: Replication slot names may only contain lower case letters, numbers, and the underscore character.
+DETAIL: syntax error at or near "*"
-- Can set synchronized_standby_slots to a non-existent slot name
ALTER SYSTEM SET synchronized_standby_slots='missing';
-- Reset the GUC |
| tap |
[00:51:41.751](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/modules/unsafe_tests/expected/guc_privs.out /Users/admin/pgsql/build/testrun/unsafe...
--- /Users/admin/pgsql/src/test/modules/unsafe_tests/expected/guc_privs.out 2026-05-31 00:43:24
+++ /Users/admin/pgsql/build/testrun/unsafe_tests/regress/results/guc_privs.out 2026-05-31 00:50:21
@@ -590,8 +590,7 @@
-- Cannot set synchronized_standby_slots to an invalid slot name
ALTER SYSTEM SET synchronized_standby_slots='invalid*';
ERROR: invalid value for parameter "synchronized_standby_slots": "invalid*"
-DETAIL: replication slot name "invalid*" contains invalid character
-HINT: Replication slot names may only contain lower case letters, numbers, and the underscore character.
+DETAIL: syntax error at or near "*"
-- Can set synchronized_standby_slots to a non-existent slot name
ALTER SYSTEM SET synchronized_standby_slots='missing';
-- Reset the GUC |
| tap |
[00:49:03.870](0.002s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/unsafe_tests/expected/guc_privs.out /tmp/cirrus-ci-build/build/testrun/un...
--- /tmp/cirrus-ci-build/src/test/modules/unsafe_tests/expected/guc_privs.out 2026-05-31 00:43:30.913913697 +0000
+++ /tmp/cirrus-ci-build/build/testrun/unsafe_tests/regress/results/guc_privs.out 2026-05-31 00:48:45.972040833 +0000
@@ -590,8 +590,7 @@
-- Cannot set synchronized_standby_slots to an invalid slot name
ALTER SYSTEM SET synchronized_standby_slots='invalid*';
ERROR: invalid value for parameter "synchronized_standby_slots": "invalid*"
-DETAIL: replication slot name "invalid*" contains invalid character
-HINT: Replication slot names may only contain lower case letters, numbers, and the underscore character.
+DETAIL: syntax error at or near "*"
-- Can set synchronized_standby_slots to a non-existent slot name
ALTER SYSTEM SET synchronized_standby_slots='missing';
-- Reset the GUC |
| test |
[00:52:04.197] 169/402 postgresql:unsafe_tests / unsafe_tests/regress ERROR ... |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/unsafe_tests/expected/guc_privs.out /tmp/cirrus-ci-build/src/test/modules...
--- /tmp/cirrus-ci-build/src/test/modules/unsafe_tests/expected/guc_privs.out 2026-05-31 00:43:39.906504790 +0000
+++ /tmp/cirrus-ci-build/src/test/modules/unsafe_tests/results/guc_privs.out 2026-05-31 00:51:33.474593210 +0000
@@ -590,8 +590,7 @@
-- Cannot set synchronized_standby_slots to an invalid slot name
ALTER SYSTEM SET synchronized_standby_slots='invalid*';
ERROR: invalid value for parameter "synchronized_standby_slots": "invalid*"
-DETAIL: replication slot name "invalid*" contains invalid character
-HINT: Replication slot names may only contain lower case letters, numbers, and the underscore character.
+DETAIL: syntax error at or near "*"
-- Can set synchronized_standby_slots to a non-existent slot name
ALTER SYSTEM SET synchronized_standby_slots='missing';
-- Reset the GUC |
| tap |
[00:55:35.441](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/modules/unsafe_tests/expected/guc_privs.out /home/postgres/postgres/build/test...
--- /home/postgres/postgres/src/test/modules/unsafe_tests/expected/guc_privs.out 2026-05-31 00:43:49.460238952 +0000
+++ /home/postgres/postgres/build/testrun/unsafe_tests/regress/results/guc_privs.out 2026-05-31 00:46:50.137671686 +0000
@@ -590,8 +590,7 @@
-- Cannot set synchronized_standby_slots to an invalid slot name
ALTER SYSTEM SET synchronized_standby_slots='invalid*';
ERROR: invalid value for parameter "synchronized_standby_slots": "invalid*"
-DETAIL: replication slot name "invalid*" contains invalid character
-HINT: Replication slot names may only contain lower case letters, numbers, and the underscore character.
+DETAIL: syntax error at or near "*"
-- Can set synchronized_standby_slots to a non-existent slot name
ALTER SYSTEM SET synchronized_standby_slots='missing';
-- Reset the GUC |
| tap |
[00:46:11.400](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/unsafe_tests/expected/guc_privs.out /tmp/cirrus-ci-build/build/testrun/un...
--- /tmp/cirrus-ci-build/src/test/modules/unsafe_tests/expected/guc_privs.out 2026-05-31 00:43:29.451504000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/unsafe_tests/regress/results/guc_privs.out 2026-05-31 00:48:13.359436000 +0000
@@ -590,8 +590,7 @@
-- Cannot set synchronized_standby_slots to an invalid slot name
ALTER SYSTEM SET synchronized_standby_slots='invalid*';
ERROR: invalid value for parameter "synchronized_standby_slots": "invalid*"
-DETAIL: replication slot name "invalid*" contains invalid character
-HINT: Replication slot names may only contain lower case letters, numbers, and the underscore character.
+DETAIL: syntax error at or near "*"
-- Can set synchronized_standby_slots to a non-existent slot name
ALTER SYSTEM SET synchronized_standby_slots='missing';
-- Reset the GUC |
| tap |
[00:46:16.924](0.001s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
| 59/6526 |
amcheck: add index-all-keys-match verification for B-Tree |
|
macOS - Sequoia - Meson |
| tap |
[21:53:52.809](0.243s) Bail out! rename failed: No such file or directory |
| tap |
[21:52:00.264](0.044s) not ok 46 - pg_amcheck over schema s2 with corrupt tables excluded reports no corruption status (...
[21:52:00.264](0.000s) not ok 47 - pg_amcheck over schema s2 with corrupt tables excluded reports no corruption stdout /... |
| tap |
[21:51:05.821](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| tap |
[22:02:03.474](0.286s) Bail out! rename failed: No such file or directory |
| tap |
[21:58:37.624](0.075s) not ok 46 - pg_amcheck over schema s2 with corrupt tables excluded reports no corruption status (...
[21:58:37.624](0.000s) not ok 47 - pg_amcheck over schema s2 with corrupt tables excluded reports no corruption stdout /... |
| tap |
[21:55:56.202](0.001s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
|
Linux - Debian Trixie - Meson |
| tap |
[21:54:44.755](0.182s) Bail out! rename failed: No such file or directory |
| tap |
[21:53:29.461](0.055s) not ok 46 - pg_amcheck over schema s2 with corrupt tables excluded reports no corruption status (...
[21:53:29.462](0.000s) not ok 47 - pg_amcheck over schema s2 with corrupt tables excluded reports no corruption stdout /... |
| test |
[21:56:37.262] 182/404 postgresql:pg_amcheck / pg_amcheck/003_check ERROR ...
[21:56:37.262] 270/404 postgresql:amcheck / amcheck/008_verify_nbtree_lost_segments ERROR ... |
|
FreeBSD - Meson |
| core |
[21:58:55.427] #0 0x000056ab1e774348 in ?? () from /libexec/ld-elf.so.1
[21:58:55.427] #1 0x0000000000000000 in ?? () |
| tap |
[21:54:20.566](0.166s) Bail out! rename failed: No such file or directory |
| tap |
[21:52:52.354](0.050s) not ok 46 - pg_amcheck over schema s2 with corrupt tables excluded reports no corruption status (...
[21:52:52.357](0.001s) not ok 47 - pg_amcheck over schema s2 with corrupt tables excluded reports no corruption stdout /... |
| tap |
[21:50:19.800](0.001s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
|
NetBSD - Meson |
| tap |
[21:51:48.636](0.140s) Bail out! rename failed: No such file or directory |
| tap |
[21:50:51.100](0.048s) not ok 46 - pg_amcheck over schema s2 with corrupt tables excluded reports no corruption status (...
[21:50:51.101](0.000s) not ok 47 - pg_amcheck over schema s2 with corrupt tables excluded reports no corruption stdout /... |
| tap |
[21:50:00.287](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
|
Linux - Debian Trixie - Autoconf |
| tap |
[21:50:07.256](0.153s) not ok 46 - pg_amcheck over schema s2 with corrupt tables excluded reports no corruption status (...
[21:50:07.257](0.000s) not ok 47 - pg_amcheck over schema s2 with corrupt tables excluded reports no corruption stdout /... |
| tap |
[21:57:54.167](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
| 60/6148 |
CI: Add task that runs pgindent |
|
FreeBSD - Meson |
| tap |
[12:34:18.558](0.024s) not ok 16 - startup deadlock: stats show conflict on standby |
| tap |
[12:35:04.342](0.001s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
| 59/6610 |
ORDER BY ALL |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/pl/plpgsql/src/expected/plpgsql_misc.out C:/cirrus/build/testrun/plpgsql/regr...
--- C:/cirrus/src/pl/plpgsql/src/expected/plpgsql_misc.out 2026-05-29 04:15:50.119810500 +0000
+++ C:/cirrus/build/testrun/plpgsql/regress/results/plpgsql_misc.out 2026-05-29 04:23:56.552652700 +0000
@@ -194,7 +194,7 @@
end;
$$ language plpgsql;
select * from test_order_by_all_return();
- a | b | c
+ a | b | c
---+-----+-----
1 | bar | 2.5
1 | qux | 1.5
@@ -210,7 +210,7 @@
end;
$$ language plpgsql;
select * from test_order_by_all_desc_return();
- a | b | c
+ a | b | c
---+-----+-----
3 | foo | 1.5
... |
| tap |
[04:23:52.223](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
|
macOS - Sequoia - Meson |
| core |
[04:29:57.278] * frame #0: 0x00000001026207c0 dyld`_dyld_start |
| core |
[04:30:37.170] * frame #0: 0x00000001871caf24 dyld`invocation function for block in dyld4::Loader::findAndRunAllInitia...
[04:30:37.170] frame #1: 0x000000018720789c dyld`invocation function for block in dyld3::MachOAnalyzer::forEachIniti...
[04:30:37.170] frame #2: 0x00000001872275cc dyld`invocation function for block in mach_o::Header::forEachSection(voi...
[04:30:37.170] frame #3: 0x0000000187224358 dyld`mach_o::Header::forEachLoadCommand(void (load_command const*, bool&...
[04:30:37.170] frame #4: 0x0000000187225a98 dyld`mach_o::Header::forEachSection(void (mach_o::Header::SectionInfo co...
[04:30:37.170] frame #5: 0x000000018720736c dyld`dyld3::MachOAnalyzer::forEachInitializer(Diagnostics&, dyld3::MachO...
[04:30:37.170] frame #6: 0x00000001871cacb4 dyld`dyld4::Loader::findAndRunAllInitializers(dyld4::RuntimeState&) cons...
[04:30:37.170] frame #7: 0x00000001871d6530 dyld`dyld4::PrebuiltLoader::runInitializers(dyld4::RuntimeState&) const ...
[04:30:37.170] frame #8: 0x00000001871ec8f0 dyld`dyld4::APIs::runAllInitializersForMain() + 88
[04:30:37.170] frame #9: 0x00000001871afe00 dyld`dyld4::prepare(dyld4::APIs&, mach_o::Header const*) + 3092 |
| regress |
diff -U3 /Users/admin/pgsql/src/pl/plpgsql/src/expected/plpgsql_misc.out /Users/admin/pgsql/build/testrun/plpgsql/regres...
--- /Users/admin/pgsql/src/pl/plpgsql/src/expected/plpgsql_misc.out 2026-05-29 04:15:16
+++ /Users/admin/pgsql/build/testrun/plpgsql/regress/results/plpgsql_misc.out 2026-05-29 04:20:50
@@ -194,7 +194,7 @@
end;
$$ language plpgsql;
select * from test_order_by_all_return();
- a | b | c
+ a | b | c
---+-----+-----
1 | bar | 2.5
1 | qux | 1.5
@@ -210,7 +210,7 @@
end;
$$ language plpgsql;
select * from test_order_by_all_desc_return();
- a | b | c
+ a | b | c
---+-----+-----
3 | foo | 1.5
... |
| tap |
[04:20:33.550](0.011s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/pl/plpgsql/src/expected/plpgsql_misc.out /tmp/cirrus-ci-build/build/testrun/plpgsql/re...
--- /tmp/cirrus-ci-build/src/pl/plpgsql/src/expected/plpgsql_misc.out 2026-05-29 04:16:12.944027376 +0000
+++ /tmp/cirrus-ci-build/build/testrun/plpgsql/regress/results/plpgsql_misc.out 2026-05-29 04:22:47.935802167 +0000
@@ -194,7 +194,7 @@
end;
$$ language plpgsql;
select * from test_order_by_all_return();
- a | b | c
+ a | b | c
---+-----+-----
1 | bar | 2.5
1 | qux | 1.5
@@ -210,7 +210,7 @@
end;
$$ language plpgsql;
select * from test_order_by_all_desc_return();
- a | b | c
+ a | b | c
---+-----+-----
3 | foo | 1.5
... |
| test |
[04:27:10.455] 63/402 postgresql:plpgsql / plpgsql/regress ERROR ... |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/pl/plpgsql/src/expected/plpgsql_misc.out /home/postgres/postgres/build/testrun/plpg...
--- /home/postgres/postgres/src/pl/plpgsql/src/expected/plpgsql_misc.out 2026-05-29 04:16:14.222286765 +0000
+++ /home/postgres/postgres/build/testrun/plpgsql/regress/results/plpgsql_misc.out 2026-05-29 04:20:11.431788728 +0000
@@ -194,7 +194,7 @@
end;
$$ language plpgsql;
select * from test_order_by_all_return();
- a | b | c
+ a | b | c
---+-----+-----
1 | bar | 2.5
1 | qux | 1.5
@@ -210,7 +210,7 @@
end;
$$ language plpgsql;
select * from test_order_by_all_desc_return();
- a | b | c
+ a | b | c
---+-----+-----
3 | foo | 1.5
... |
| tap |
[04:20:10.041](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
| tap |
[04:22:43.183](0.111s) not ok 3 - ensure checksums are set to off on injection_node |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/pl/plpgsql/src/expected/plpgsql_misc.out /tmp/cirrus-ci-build/src/pl/plpgsql/src/resul...
--- /tmp/cirrus-ci-build/src/pl/plpgsql/src/expected/plpgsql_misc.out 2026-05-29 04:15:34.546408934 +0000
+++ /tmp/cirrus-ci-build/src/pl/plpgsql/src/results/plpgsql_misc.out 2026-05-29 04:19:37.441094521 +0000
@@ -194,7 +194,7 @@
end;
$$ language plpgsql;
select * from test_order_by_all_return();
- a | b | c
+ a | b | c
---+-----+-----
1 | bar | 2.5
1 | qux | 1.5
@@ -210,7 +210,7 @@
end;
$$ language plpgsql;
select * from test_order_by_all_desc_return();
- a | b | c
+ a | b | c
---+-----+-----
3 | foo | 1.5
... |
| tap |
[04:30:22.546](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/pl/plpgsql/src/expected/plpgsql_misc.out /tmp/cirrus-ci-build/build/testrun/plpgsql/re...
--- /tmp/cirrus-ci-build/src/pl/plpgsql/src/expected/plpgsql_misc.out 2026-05-29 04:15:53.914402000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/plpgsql/regress/results/plpgsql_misc.out 2026-05-29 04:20:10.074342000 +0000
@@ -194,7 +194,7 @@
end;
$$ language plpgsql;
select * from test_order_by_all_return();
- a | b | c
+ a | b | c
---+-----+-----
1 | bar | 2.5
1 | qux | 1.5
@@ -210,7 +210,7 @@
end;
$$ language plpgsql;
select * from test_order_by_all_desc_return();
- a | b | c
+ a | b | c
---+-----+-----
3 | foo | 1.5
... |
| tap |
[04:20:00.803](0.002s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
| 59/5893 |
Adding pg_dump flag for parallel export to pipes |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| tap |
[20:29:04.543](0.567s) not ok 1909 - defaults_complex_pipe: pg_dump runs
[20:29:04.699](0.151s) not ok 1910 - defaults_complex_pipe: pg_restore runs |
| tap |
[20:28:47.516](0.531s) not ok 5 - parallel dump with pipe
[20:28:47.835](0.317s) not ok 6 - parallel restore with pipe |
| tap |
[20:24:45.910](0.002s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
| 59/6796 |
Reject degenerate SPLIT PARTITION with DEFAULT partition |
|
NetBSD - Meson |
| tap |
[18:16:37.277](0.001s) not ok 2 - run of pg_upgrade where the new cluster has insufficient max_active_replication_origin... |
| tap |
[18:18:15.440](0.001s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
| 59/6805 |
BUG Segfault triggered by reentrancy in ri_triggers.c |
|
Linux - Debian Trixie - Meson |
| assertion |
TRAP: failed Assert("plan->magic == _SPI_PLAN_MAGIC"), File: "../src/backend/executor/spi.c", Line: 1953, PID: 34430 |
| core |
[15:00:42.874] #0 0x00007f61ad6a095c in ?? () from /lib/x86_64-linux-gnu/libc.so.6
[15:00:42.874] #1 0x00007f61ad64bcc2 in raise () from /lib/x86_64-linux-gnu/libc.so.6
[15:00:42.874] #2 0x00007f61ad6344ac in abort () from /lib/x86_64-linux-gnu/libc.so.6
[15:00:42.874] #3 0x0000555aba4b94c9 in ExceptionalCondition (conditionName=conditionName@entry=0x555aba754ee0 "plan->m...
[15:00:42.874] #4 0x0000555ab9e9861e in SPI_plan_is_valid (plan=plan@entry=0x555ad4274360) at ../src/backend/executor/s...
[15:00:42.874] #5 0x0000555aba3c818a in ri_FetchPreparedPlan (key=key@entry=0x7ffcad78ace8) at ../src/backend/utils/adt...
[15:00:42.874] #6 0x0000555aba3cf3b6 in ri_set (trigdata=0x7ffcad78aef0, is_set_null=is_set_null@entry=false, tgkind=tg...
[15:00:42.874] #7 0x0000555aba3d0a5a in RI_FKey_setdefault_del (fcinfo=0x7ffcad78ae60) at ../src/backend/utils/adt/ri_t...
[15:00:42.874] #8 0x0000555ab9d7510c in ExecCallTriggerFunc (trigdata=trigdata@entry=0x7ffcad78aef0, tgindx=tgindx@entr...
[15:00:42.874] #9 0x0000555ab9d75f1f in AfterTriggerExecute (estate=estate@entry=0x555ad4254040, event=event@entry=0x55... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out /tmp/cirrus-ci-build/build/testrun/test_plan_adv...
--- /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out 2026-05-27 14:46:57.030826226 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/foreign_key.out 2026-05-27 14:51...
@@ -262,3453 +262,7 @@
-- Delete another row from PK TABLE
DELETE FROM PKTABLE WHERE ptest1=5 and ptest2=10;
--- Check FKTABLE (should be no change)
-SELECT * FROM FKTABLE;
- ftest1 | ftest2 | ftest3
---------+--------+--------
- 1 | 3 | 5
- 2 | 4 | 8
- 3 | 6 | 12
- | | 0
- -1 | -2 | 4
-(5 rows)
-
--- Update a row from PK TABLE
-UPDATE PKTABLE SET ptest1=1 WHERE ptest1=2;
... |
| tap |
[14:51:52.509](68.226s) not ok 1 - regression tests pass |
| test |
[14:57:40.645] 17/402 postgresql:test_plan_advice / test_plan_advice/001_replan_regress ERROR ... |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| assertion |
TRAP: failed Assert("plan->magic == _SPI_PLAN_MAGIC"), File: "../src/backend/executor/spi.c", Line: 1953, PID: 8896 |
| assertion |
TRAP: failed Assert("plan->magic == _SPI_PLAN_MAGIC"), File: "../src/backend/executor/spi.c", Line: 1953, PID: 8312 |
| core |
00000065`229ffd88 00007ffb`de85d4fe ntdll!NtWaitForSingleObject+0x14
00000065`229ffd90 00007ff7`47bc80ac KERNELBASE!WaitForSingleObjectEx+0x8e
00000065`229ffe30 00007ffb`df1c4cb0 postgres!pg_timer_thread(
00000065`229ffe70 00007ffb`e129edeb KERNEL32!BaseThreadInitThunk+0x10
00000065`229ffea0 00000000`00000000 ntdll!RtlUserThreadStart+0x2b |
| core |
00000065`225ffbb8 00007ffb`e122b77f ntdll!NtWaitForWorkViaWorkerFactory+0x14
00000065`225ffbc0 00007ffb`df1c4cb0 ntdll!TppWorkerThread+0x2df
00000065`225ffeb0 00007ffb`e129edeb KERNEL32!BaseThreadInitThunk+0x10
00000065`225ffee0 00000000`00000000 ntdll!RtlUserThreadStart+0x2b |
| core |
00000065`221ffca8 00007ffb`de8a466a ntdll!NtFsControlFile+0x14
00000065`221ffcb0 00007ff7`47bc666b KERNELBASE!ConnectNamedPipe+0x6a
00000065`221ffd20 00007ffb`df1c4cb0 postgres!pg_signal_thread(
00000065`221ffe20 00007ffb`e129edeb KERNEL32!BaseThreadInitThunk+0x10
00000065`221ffe50 00000000`00000000 ntdll!RtlUserThreadStart+0x2b |
| core |
00000065`219fe700 00007ff7`47f25598 ucrtbased!abort(void)+0x5a [minkernel\crts\ucrt\src\appcrt\startup\abort.cpp @ 7...
00000065`219fe740 00007ff7`47a4933f postgres!ExceptionalCondition(
00000065`219fe780 00007ff7`47e67820 postgres!SPI_plan_is_valid(
00000065`219fe7e0 00007ff7`47e6b559 postgres!ri_FetchPreparedPlan(
00000065`219fe820 00007ff7`47e64fde postgres!RI_FKey_check(
00000065`219feb50 00007ff7`4798399e postgres!RI_FKey_check_ins(
00000065`219feb80 00007ff7`4798557d postgres!ExecCallTriggerFunc(
00000065`219fed30 00007ff7`479873b7 postgres!AfterTriggerExecute(
00000065`219fee40 00007ff7`47980c2e postgres!afterTriggerInvokeEvents(
00000065`219fef50 00007ff7`479cda0b postgres!AfterTriggerEndQuery( |
| core |
00000065`21dff748 00007ffb`e122b77f ntdll!NtWaitForWorkViaWorkerFactory+0x14
00000065`21dff750 00007ffb`df1c4cb0 ntdll!TppWorkerThread+0x2df
00000065`21dffa40 00007ffb`e129edeb KERNEL32!BaseThreadInitThunk+0x10
00000065`21dffa70 00000000`00000000 ntdll!RtlUserThreadStart+0x2b |
| core |
0000001e`5b5ffa58 00007ffb`e122b77f ntdll!NtWaitForWorkViaWorkerFactory+0x14
0000001e`5b5ffa60 00007ffb`df1c4cb0 ntdll!TppWorkerThread+0x2df
0000001e`5b5ffd50 00007ffb`e129edeb KERNEL32!BaseThreadInitThunk+0x10
0000001e`5b5ffd80 00000000`00000000 ntdll!RtlUserThreadStart+0x2b |
| core |
0000001e`5b1fe5b0 00007ff7`47f25598 ucrtbased!abort(void)+0x5a [minkernel\crts\ucrt\src\appcrt\startup\abort.cpp @ 7...
0000001e`5b1fe5f0 00007ff7`47a4933f postgres!ExceptionalCondition(
0000001e`5b1fe630 00007ff7`47e67820 postgres!SPI_plan_is_valid(
0000001e`5b1fe690 00007ff7`47e660af postgres!ri_FetchPreparedPlan(
0000001e`5b1fe6d0 00007ff7`47e65aa0 postgres!ri_restrict(
0000001e`5b1febe0 00007ff7`4798399e postgres!RI_FKey_noaction_upd(
0000001e`5b1fec10 00007ff7`4798557d postgres!ExecCallTriggerFunc(
0000001e`5b1fedc0 00007ff7`479873b7 postgres!AfterTriggerExecute(
0000001e`5b1feed0 00007ff7`47980c2e postgres!afterTriggerInvokeEvents(
0000001e`5b1fefe0 00007ff7`479cda0b postgres!AfterTriggerEndQuery( |
| core |
0000001e`5b9ffd58 00007ffb`de8a466a ntdll!NtFsControlFile+0x14
0000001e`5b9ffd60 00007ff7`47bc666b KERNELBASE!ConnectNamedPipe+0x6a
0000001e`5b9ffdd0 00007ffb`df1c4cb0 postgres!pg_signal_thread(
0000001e`5b9ffed0 00007ffb`e129edeb KERNEL32!BaseThreadInitThunk+0x10
0000001e`5b9fff00 00000000`00000000 ntdll!RtlUserThreadStart+0x2b |
| core |
0000001e`5bdff738 00007ffb`de85d4fe ntdll!NtWaitForSingleObject+0x14
0000001e`5bdff740 00007ff7`47bc80ac KERNELBASE!WaitForSingleObjectEx+0x8e
0000001e`5bdff7e0 00007ffb`df1c4cb0 postgres!pg_timer_thread(
0000001e`5bdff820 00007ffb`e129edeb KERNEL32!BaseThreadInitThunk+0x10
0000001e`5bdff850 00000000`00000000 ntdll!RtlUserThreadStart+0x2b |
| core |
0000001e`5c1ff738 00007ffb`e122b77f ntdll!NtWaitForWorkViaWorkerFactory+0x14
0000001e`5c1ff740 00007ffb`df1c4cb0 ntdll!TppWorkerThread+0x2df
0000001e`5c1ffa30 00007ffb`e129edeb KERNEL32!BaseThreadInitThunk+0x10
0000001e`5c1ffa60 00000000`00000000 ntdll!RtlUserThreadStart+0x2b |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/foreign_key.out C:/cirrus/build/testrun/pg_upgrade/002_...
--- C:/cirrus/src/test/regress/expected/foreign_key.out 2026-05-27 14:47:38.829100200 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/foreign_key.out 2026-05-27 14:52:55.150134200 +0000
@@ -1612,2103 +1612,7 @@
update pp set f1=f1+1;
insert into cc values(13);
update pp set f1=f1+1;
-update pp set f1=f1+1; -- fail
-ERROR: update or delete on table "pp" violates foreign key constraint "cc_f1_fkey" on table "cc"
-DETAIL: Key (f1)=(13) is still referenced from table "cc".
-delete from pp where f1 = 13; -- fail
-ERROR: update or delete on table "pp" violates foreign key constraint "cc_f1_fkey" on table "cc"
-DETAIL: Key (f1)=(13) is still referenced from table "cc".
-drop table pp, cc;
-create temp table pp (f1 int primary key);
-create temp table cc (f1 int references pp on update restrict on delete restrict);
-insert into pp values(12);
-insert into pp values(11);
-update pp set f1=f1+1;
-insert into cc values(13);
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/graph_table.out C:/cirrus/build/testrun/regress/regress...
--- C:/cirrus/src/test/regress/expected/graph_table.out 2026-05-27 14:47:38.839785400 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/graph_table.out 2026-05-27 14:52:53.775135400 +0000
@@ -890,158 +890,7 @@
CREATE TABLE ptne1 PARTITION OF ptne FOR VALUES IN (1, 2);
CREATE TABLE ptne2 PARTITION OF ptne FOR VALUES IN (3);
INSERT INTO ptne VALUES (1, 1, 2, 100), (2, 2, 3, 200), (3, 3, 1, 300);
-CREATE PROPERTY GRAPH g4
- VERTEX TABLES (ptnv)
- EDGE TABLES (
- ptne
- SOURCE KEY (src) REFERENCES ptnv(id)
- DESTINATION KEY (dest) REFERENCES ptnv(id)
- );
-SELECT * FROM GRAPH_TABLE (g4 MATCH (s IS ptnv)-[e IS ptne]->(d IS ptnv) COLUMNS (s.val, e.val, d.val)) ORDER BY 1, 2, ...
- val | val | val
------+-----+-----
- 10 | 100 | 20
- 20 | 200 | 30
- 30 | 300 | 10
... |
| tap |
[14:53:45.596](198.067s) not ok 5 - regression tests in old instance
[14:53:45.598](0.000s) # not ok 219 + partition_merge 632 ms
# not ok 220 + partition_split 600 ms
# not ok 221 + partition_join 586 ms
# not ok 222 + partition_prune 660 ms
# not ok 223 + reloptions 657 ms
# not ok 224 + hash_part 575 ms
# not ok 225 + indexing 650 ms
# not ok 226 + partition_aggregate 647 ms
# not ok 227 + partition_info 582 ms
# not ok 228 + tuplesort 640 ms
# not ok 229 + explain 637 ms
# not ok 230 + memoize 632 ms
# not ok 231 + stats 627 ms
# not ok 232 + predicate 622 ms
# not ok 233 + numa 638 ms
# not ok 234 + eager_aggregate 629 ms
# not ok 235 + graph_table_rls 667 ms
# not ok 236 + planner_est 629 ms
# not ok 237 + compression 183 ms
# not ok 238 + compression_lz4 175 ms
# not ok 239 + compression_pglz 237 ms
# not ok 240 + cluster 177 ms
# not ok 241 + oidjoins 72 ms
# not ok 242 + event_trigger 72 ms
# not ok 243 - event_trigger_login 79 ms
# not ok 244 - fast_default 73 ms
# not ok 245 - tablespace 134 ms
[14:54:28.501](15.501s) not ok 16 - run of pg_upgrade for new instance
[14:54:28.505](0.001s) not ok 17 - pg_upgrade_output.d/ removed after pg_upgrade success
[14:54:30.724](0.108s) not ok 20 - old and new dumps match after pg_upgrade |
| tap |
[14:56:53.978](0.001s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
| 59/5007 |
relfilenode statistics |
|
CompilerWarnings |
| compiler |
[04:58:06.011] autovacuum.c:2044:32: error: variable ‘locator’ set but not used [-Werror=unused-but-set-variable] |
| compiler |
[04:58:06.011] autovacuum.c:2153:32: error: variable ‘locator’ set but not used [-Werror=unused-but-set-variable] |
| compiler |
[04:57:20.695] autovacuum.c:2153:32: error: variable ‘locator’ set but not used [-Werror=unused-but-set-variable] |
| compiler |
[04:57:20.695] autovacuum.c:2044:32: error: variable ‘locator’ set but not used [-Werror=unused-but-set-variable] |
| compiler |
[05:04:13.933] autovacuum.c:2153:32: error: variable ‘locator’ set but not used [-Werror=unused-but-set-variable] |
| compiler |
[05:04:13.933] autovacuum.c:2044:32: error: variable ‘locator’ set but not used [-Werror=unused-but-set-variable] |
| 59/6606 |
log_checkpoints: count WAL segment creations from all processes |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/rules.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgra...
--- /Users/admin/pgsql/src/test/regress/expected/rules.out 2026-05-25 19:25:24
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/rules.out 2026-05-25 19:32:01
@@ -1889,6 +1889,9 @@
pg_stat_get_checkpointer_sync_time() AS sync_time,
pg_stat_get_checkpointer_buffers_written() AS buffers_written,
pg_stat_get_checkpointer_slru_written() AS slru_written,
+ pg_stat_get_checkpointer_segs_added() AS segs_added,
+ pg_stat_get_checkpointer_segs_removed() AS segs_removed,
+ pg_stat_get_checkpointer_segs_recycled() AS segs_recycled,
pg_stat_get_checkpointer_stat_reset_time() AS stats_reset;
pg_stat_database| SELECT oid AS datid,
datname, |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/rules.out /Users/admin/pgsql/build/testrun/recovery/027_stream_reg...
--- /Users/admin/pgsql/src/test/regress/expected/rules.out 2026-05-25 19:25:24
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/rules.out 2026-05-25 19:33:47
@@ -1889,6 +1889,9 @@
pg_stat_get_checkpointer_sync_time() AS sync_time,
pg_stat_get_checkpointer_buffers_written() AS buffers_written,
pg_stat_get_checkpointer_slru_written() AS slru_written,
+ pg_stat_get_checkpointer_segs_added() AS segs_added,
+ pg_stat_get_checkpointer_segs_removed() AS segs_removed,
+ pg_stat_get_checkpointer_segs_recycled() AS segs_recycled,
pg_stat_get_checkpointer_stat_reset_time() AS stats_reset;
pg_stat_database| SELECT oid AS datid,
datname, |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/rules.out /Users/admin/pgsql/build/testrun/regress/regress/results...
--- /Users/admin/pgsql/src/test/regress/expected/rules.out 2026-05-25 19:25:24
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/rules.out 2026-05-25 19:31:58
@@ -1889,6 +1889,9 @@
pg_stat_get_checkpointer_sync_time() AS sync_time,
pg_stat_get_checkpointer_buffers_written() AS buffers_written,
pg_stat_get_checkpointer_slru_written() AS slru_written,
+ pg_stat_get_checkpointer_segs_added() AS segs_added,
+ pg_stat_get_checkpointer_segs_removed() AS segs_removed,
+ pg_stat_get_checkpointer_segs_recycled() AS segs_recycled,
pg_stat_get_checkpointer_stat_reset_time() AS stats_reset;
pg_stat_database| SELECT oid AS datid,
datname, |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/rules.out /Users/admin/pgsql/build/testrun/test_plan_advice/001_re...
--- /Users/admin/pgsql/src/test/regress/expected/rules.out 2026-05-25 19:25:24
+++ /Users/admin/pgsql/build/testrun/test_plan_advice/001_replan_regress/data/results/rules.out 2026-05-25 19:32:01
@@ -1889,6 +1889,9 @@
pg_stat_get_checkpointer_sync_time() AS sync_time,
pg_stat_get_checkpointer_buffers_written() AS buffers_written,
pg_stat_get_checkpointer_slru_written() AS slru_written,
+ pg_stat_get_checkpointer_segs_added() AS segs_added,
+ pg_stat_get_checkpointer_segs_removed() AS segs_removed,
+ pg_stat_get_checkpointer_segs_recycled() AS segs_recycled,
pg_stat_get_checkpointer_stat_reset_time() AS stats_reset;
pg_stat_database| SELECT oid AS datid,
datname, |
| tap |
[19:32:47.572](124.045s) not ok 5 - regression tests in old instance |
| tap |
[19:34:20.054](66.236s) not ok 2 - regression tests pass |
| tap |
[19:33:57.067](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
| tap |
[19:32:51.788](136.397s) not ok 1 - regression tests pass |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/rules.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upg...
--- C:/cirrus/src/test/regress/expected/rules.out 2026-05-25 19:26:22.567120700 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/rules.out 2026-05-25 19:30:19.587412100 +0000
@@ -1889,6 +1889,9 @@
pg_stat_get_checkpointer_sync_time() AS sync_time,
pg_stat_get_checkpointer_buffers_written() AS buffers_written,
pg_stat_get_checkpointer_slru_written() AS slru_written,
+ pg_stat_get_checkpointer_segs_added() AS segs_added,
+ pg_stat_get_checkpointer_segs_removed() AS segs_removed,
+ pg_stat_get_checkpointer_segs_recycled() AS segs_recycled,
pg_stat_get_checkpointer_stat_reset_time() AS stats_reset;
pg_stat_database| SELECT oid AS datid,
datname, |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/rules.out C:/cirrus/build/testrun/recovery/027_stream_r...
--- C:/cirrus/src/test/regress/expected/rules.out 2026-05-25 19:26:22.567120700 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/rules.out 2026-05-25 19:33:48.821293900 +0000
@@ -1889,6 +1889,9 @@
pg_stat_get_checkpointer_sync_time() AS sync_time,
pg_stat_get_checkpointer_buffers_written() AS buffers_written,
pg_stat_get_checkpointer_slru_written() AS slru_written,
+ pg_stat_get_checkpointer_segs_added() AS segs_added,
+ pg_stat_get_checkpointer_segs_removed() AS segs_removed,
+ pg_stat_get_checkpointer_segs_recycled() AS segs_recycled,
pg_stat_get_checkpointer_stat_reset_time() AS stats_reset;
pg_stat_database| SELECT oid AS datid,
datname, |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/rules.out C:/cirrus/build/testrun/regress/regress/resul...
--- C:/cirrus/src/test/regress/expected/rules.out 2026-05-25 19:26:22.567120700 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/rules.out 2026-05-25 19:30:08.469247300 +0000
@@ -1889,6 +1889,9 @@
pg_stat_get_checkpointer_sync_time() AS sync_time,
pg_stat_get_checkpointer_buffers_written() AS buffers_written,
pg_stat_get_checkpointer_slru_written() AS slru_written,
+ pg_stat_get_checkpointer_segs_added() AS segs_added,
+ pg_stat_get_checkpointer_segs_removed() AS segs_removed,
+ pg_stat_get_checkpointer_segs_recycled() AS segs_recycled,
pg_stat_get_checkpointer_stat_reset_time() AS stats_reset;
pg_stat_database| SELECT oid AS datid,
datname, |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/rules.out C:/cirrus/build/testrun/test_plan_advice/001_...
--- C:/cirrus/src/test/regress/expected/rules.out 2026-05-25 19:26:22.567120700 +0000
+++ C:/cirrus/build/testrun/test_plan_advice/001_replan_regress/data/results/rules.out 2026-05-25 19:30:13.404303200 +00...
@@ -1889,6 +1889,9 @@
pg_stat_get_checkpointer_sync_time() AS sync_time,
pg_stat_get_checkpointer_buffers_written() AS buffers_written,
pg_stat_get_checkpointer_slru_written() AS slru_written,
+ pg_stat_get_checkpointer_segs_added() AS segs_added,
+ pg_stat_get_checkpointer_segs_removed() AS segs_removed,
+ pg_stat_get_checkpointer_segs_recycled() AS segs_recycled,
pg_stat_get_checkpointer_stat_reset_time() AS stats_reset;
pg_stat_database| SELECT oid AS datid,
datname, |
| tap |
[19:31:34.391](168.253s) not ok 5 - regression tests in old instance |
| tap |
[19:34:54.494](150.895s) not ok 2 - regression tests pass |
| tap |
[19:34:14.995](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
| tap |
[19:31:30.995](171.737s) not ok 1 - regression tests pass |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/rules.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_u...
--- /tmp/cirrus-ci-build/src/test/regress/expected/rules.out 2026-05-25 19:25:12.260263912 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/rules.out 2026-05-25 19:30:16.857921530 +0...
@@ -1889,6 +1889,9 @@
pg_stat_get_checkpointer_sync_time() AS sync_time,
pg_stat_get_checkpointer_buffers_written() AS buffers_written,
pg_stat_get_checkpointer_slru_written() AS slru_written,
+ pg_stat_get_checkpointer_segs_added() AS segs_added,
+ pg_stat_get_checkpointer_segs_removed() AS segs_removed,
+ pg_stat_get_checkpointer_segs_recycled() AS segs_recycled,
pg_stat_get_checkpointer_stat_reset_time() AS stats_reset;
pg_stat_database| SELECT oid AS datid,
datname, |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/rules.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream...
--- /tmp/cirrus-ci-build/src/test/regress/expected/rules.out 2026-05-25 19:25:12.260263912 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/rules.out 2026-05-25 19:31:49.478009585 ...
@@ -1889,6 +1889,9 @@
pg_stat_get_checkpointer_sync_time() AS sync_time,
pg_stat_get_checkpointer_buffers_written() AS buffers_written,
pg_stat_get_checkpointer_slru_written() AS slru_written,
+ pg_stat_get_checkpointer_segs_added() AS segs_added,
+ pg_stat_get_checkpointer_segs_removed() AS segs_removed,
+ pg_stat_get_checkpointer_segs_recycled() AS segs_recycled,
pg_stat_get_checkpointer_stat_reset_time() AS stats_reset;
pg_stat_database| SELECT oid AS datid,
datname, |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/rules.out /tmp/cirrus-ci-build/build/testrun/regress/regress/res...
--- /tmp/cirrus-ci-build/src/test/regress/expected/rules.out 2026-05-25 19:25:12.260263912 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/rules.out 2026-05-25 19:30:17.593922505 +0000
@@ -1889,6 +1889,9 @@
pg_stat_get_checkpointer_sync_time() AS sync_time,
pg_stat_get_checkpointer_buffers_written() AS buffers_written,
pg_stat_get_checkpointer_slru_written() AS slru_written,
+ pg_stat_get_checkpointer_segs_added() AS segs_added,
+ pg_stat_get_checkpointer_segs_removed() AS segs_removed,
+ pg_stat_get_checkpointer_segs_recycled() AS segs_recycled,
pg_stat_get_checkpointer_stat_reset_time() AS stats_reset;
pg_stat_database| SELECT oid AS datid,
datname, |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/rules.out /tmp/cirrus-ci-build/build/testrun/test_plan_advice/00...
--- /tmp/cirrus-ci-build/src/test/regress/expected/rules.out 2026-05-25 19:25:12.260263912 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/rules.out 2026-05-25 19:30:19.55...
@@ -1889,6 +1889,9 @@
pg_stat_get_checkpointer_sync_time() AS sync_time,
pg_stat_get_checkpointer_buffers_written() AS buffers_written,
pg_stat_get_checkpointer_slru_written() AS slru_written,
+ pg_stat_get_checkpointer_segs_added() AS segs_added,
+ pg_stat_get_checkpointer_segs_removed() AS segs_removed,
+ pg_stat_get_checkpointer_segs_recycled() AS segs_recycled,
pg_stat_get_checkpointer_stat_reset_time() AS stats_reset;
pg_stat_database| SELECT oid AS datid,
datname, |
| tap |
[19:30:56.281](85.603s) not ok 5 - regression tests in old instance |
| tap |
[19:32:30.430](82.540s) not ok 2 - regression tests pass |
| tap |
[19:30:58.288](90.597s) not ok 1 - regression tests pass |
| test |
[19:36:10.283] 13/401 postgresql:regress / regress/regress ERROR ...
[19:36:10.283] 28/401 postgresql:test_plan_advice / test_plan_advice/001_replan_regress ERROR ...
[19:36:10.283] 26/401 postgresql:pg_upgrade / pg_upgrade/002_pg_upgrade ERROR 1...
[19:36:10.283] 112/401 postgresql:recovery / recovery/027_stream_regress ERROR 1... |
|
FreeBSD - Meson |
| core |
[19:37:38.144] #0 0x000000082b8cc5da in _sigprocmask () from /lib/libc.so.7
[19:37:38.144] #1 0x000000082b909a3c in _system () from /lib/libc.so.7
[19:37:38.144] #2 0x000000082acb0953 in ?? () from /lib/libthr.so.3
[19:37:38.144] #3 0x00000000006b3929 in RestoreArchivedFile (path=path@entry=0x8211851b0 "pg_wal/00000003.history", xlo...
[19:37:38.144] #4 0x00000000006bf530 in XLogFileRead (segno=segno@entry=6, tli=tli@entry=2, source=source@entry=XLOG_FR...
[19:37:38.144] #5 0x00000000006bb2cb in XLogFileReadAnyTLI (segno=6, source=XLOG_FROM_ANY) at ../src/backend/access/tra...
[19:37:38.144] #6 WaitForWALToBecomeAvailable (RecPtr=105378904, randAccess=false, fetching_ckpt=false, tliRecPtr=10537...
[19:37:38.144] #7 XLogPageRead (xlogreader=0x30f0d9626c78, targetPagePtr=105373696, reqLen=5208, targetRecPtr=105378880...
[19:37:38.144] #8 0x00000000006c2bac in ReadPageInternal (state=0x30f0d9626c78, pageptr=pageptr@entry=105373696, reqLen...
[19:37:38.144] #9 0x00000000006c1955 in XLogDecodeNextRecord (state=0x30f0d9626c78, nonblocking=false) at ../src/backen... |
| core |
[19:37:38.243] #0 0x0000220c6b6f2f30 in ?? ()
[19:37:38.243] #1 0x0000000000000003 in ?? ()
[19:37:38.243] #2 0x00001001c8cac110 in ?? ()
[19:37:38.243] #3 0x00001001c8cac113 in ?? ()
[19:37:38.243] #4 0x00001001c8cac116 in ?? ()
[19:37:38.243] #5 0x0000000000000000 in ?? () |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/rules.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_u...
--- /tmp/cirrus-ci-build/src/test/regress/expected/rules.out 2026-05-25 19:25:10.250268000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/rules.out 2026-05-25 19:29:10.030700000 +0...
@@ -1889,6 +1889,9 @@
pg_stat_get_checkpointer_sync_time() AS sync_time,
pg_stat_get_checkpointer_buffers_written() AS buffers_written,
pg_stat_get_checkpointer_slru_written() AS slru_written,
+ pg_stat_get_checkpointer_segs_added() AS segs_added,
+ pg_stat_get_checkpointer_segs_removed() AS segs_removed,
+ pg_stat_get_checkpointer_segs_recycled() AS segs_recycled,
pg_stat_get_checkpointer_stat_reset_time() AS stats_reset;
pg_stat_database| SELECT oid AS datid,
datname, |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/rules.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream...
--- /tmp/cirrus-ci-build/src/test/regress/expected/rules.out 2026-05-25 19:25:10.250268000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/rules.out 2026-05-25 19:30:43.078920000 ...
@@ -1889,6 +1889,9 @@
pg_stat_get_checkpointer_sync_time() AS sync_time,
pg_stat_get_checkpointer_buffers_written() AS buffers_written,
pg_stat_get_checkpointer_slru_written() AS slru_written,
+ pg_stat_get_checkpointer_segs_added() AS segs_added,
+ pg_stat_get_checkpointer_segs_removed() AS segs_removed,
+ pg_stat_get_checkpointer_segs_recycled() AS segs_recycled,
pg_stat_get_checkpointer_stat_reset_time() AS stats_reset;
pg_stat_database| SELECT oid AS datid,
datname, |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/rules.out /tmp/cirrus-ci-build/build/testrun/regress/regress/res...
--- /tmp/cirrus-ci-build/src/test/regress/expected/rules.out 2026-05-25 19:25:10.250268000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/rules.out 2026-05-25 19:29:09.928914000 +0000
@@ -1889,6 +1889,9 @@
pg_stat_get_checkpointer_sync_time() AS sync_time,
pg_stat_get_checkpointer_buffers_written() AS buffers_written,
pg_stat_get_checkpointer_slru_written() AS slru_written,
+ pg_stat_get_checkpointer_segs_added() AS segs_added,
+ pg_stat_get_checkpointer_segs_removed() AS segs_removed,
+ pg_stat_get_checkpointer_segs_recycled() AS segs_recycled,
pg_stat_get_checkpointer_stat_reset_time() AS stats_reset;
pg_stat_database| SELECT oid AS datid,
datname, |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/rules.out /tmp/cirrus-ci-build/build/testrun/test_plan_advice/00...
--- /tmp/cirrus-ci-build/src/test/regress/expected/rules.out 2026-05-25 19:25:10.250268000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/rules.out 2026-05-25 19:29:09.87...
@@ -1889,6 +1889,9 @@
pg_stat_get_checkpointer_sync_time() AS sync_time,
pg_stat_get_checkpointer_buffers_written() AS buffers_written,
pg_stat_get_checkpointer_slru_written() AS slru_written,
+ pg_stat_get_checkpointer_segs_added() AS segs_added,
+ pg_stat_get_checkpointer_segs_removed() AS segs_removed,
+ pg_stat_get_checkpointer_segs_recycled() AS segs_recycled,
pg_stat_get_checkpointer_stat_reset_time() AS stats_reset;
pg_stat_database| SELECT oid AS datid,
datname, |
| tap |
[19:31:30.201](263.304s) not ok 5 - regression tests in old instance |
| tap |
[19:32:42.371](264.803s) not ok 2 - regression tests pass |
| tap |
[19:29:12.203](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
| tap |
[19:31:40.175](275.611s) not ok 1 - regression tests pass |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/rules.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/resu...
--- /tmp/cirrus-ci-build/src/test/regress/expected/rules.out 2026-05-25 19:25:13.920292372 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/rules.out 2026-05-25 19:33:30.446858193 +0000
@@ -1889,6 +1889,9 @@
pg_stat_get_checkpointer_sync_time() AS sync_time,
pg_stat_get_checkpointer_buffers_written() AS buffers_written,
pg_stat_get_checkpointer_slru_written() AS slru_written,
+ pg_stat_get_checkpointer_segs_added() AS segs_added,
+ pg_stat_get_checkpointer_segs_removed() AS segs_removed,
+ pg_stat_get_checkpointer_segs_recycled() AS segs_recycled,
pg_stat_get_checkpointer_stat_reset_time() AS stats_reset;
pg_stat_database| SELECT oid AS datid,
datname, |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/rules.out /tmp/cirrus-ci-build/src/test/modules/test_plan_advice...
--- /tmp/cirrus-ci-build/src/test/regress/expected/rules.out 2026-05-25 19:25:13.920292372 +0000
+++ /tmp/cirrus-ci-build/src/test/modules/test_plan_advice/tmp_check/results/rules.out 2026-05-25 19:35:36.799282777 +00...
@@ -1889,6 +1889,9 @@
pg_stat_get_checkpointer_sync_time() AS sync_time,
pg_stat_get_checkpointer_buffers_written() AS buffers_written,
pg_stat_get_checkpointer_slru_written() AS slru_written,
+ pg_stat_get_checkpointer_segs_added() AS segs_added,
+ pg_stat_get_checkpointer_segs_removed() AS segs_removed,
+ pg_stat_get_checkpointer_segs_recycled() AS segs_recycled,
pg_stat_get_checkpointer_stat_reset_time() AS stats_reset;
pg_stat_database| SELECT oid AS datid,
datname, |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/rules.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/resul...
--- /tmp/cirrus-ci-build/src/test/regress/expected/rules.out 2026-05-25 19:25:13.920292372 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/rules.out 2026-05-25 19:35:34.723276952 +0000
@@ -1889,6 +1889,9 @@
pg_stat_get_checkpointer_sync_time() AS sync_time,
pg_stat_get_checkpointer_buffers_written() AS buffers_written,
pg_stat_get_checkpointer_slru_written() AS slru_written,
+ pg_stat_get_checkpointer_segs_added() AS segs_added,
+ pg_stat_get_checkpointer_segs_removed() AS segs_removed,
+ pg_stat_get_checkpointer_segs_recycled() AS segs_recycled,
pg_stat_get_checkpointer_stat_reset_time() AS stats_reset;
pg_stat_database| SELECT oid AS datid,
datname, |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/rules.out /tmp/cirrus-ci-build/src/test/regress/results/rules.ou...
--- /tmp/cirrus-ci-build/src/test/regress/expected/rules.out 2026-05-25 19:25:13.920292372 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/rules.out 2026-05-25 19:31:27.542170594 +0000
@@ -1889,6 +1889,9 @@
pg_stat_get_checkpointer_sync_time() AS sync_time,
pg_stat_get_checkpointer_buffers_written() AS buffers_written,
pg_stat_get_checkpointer_slru_written() AS slru_written,
+ pg_stat_get_checkpointer_segs_added() AS segs_added,
+ pg_stat_get_checkpointer_segs_removed() AS segs_removed,
+ pg_stat_get_checkpointer_segs_recycled() AS segs_recycled,
pg_stat_get_checkpointer_stat_reset_time() AS stats_reset;
pg_stat_database| SELECT oid AS datid,
datname, |
| tap |
[19:34:43.029](136.303s) not ok 5 - regression tests in old instance |
| tap |
[19:36:27.594](133.912s) not ok 1 - regression tests pass |
| tap |
[19:36:29.528](139.225s) not ok 2 - regression tests pass |
| tap |
[19:38:15.486](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/rules.out /home/postgres/postgres/build/testrun/pg_upgrade/00...
--- /home/postgres/postgres/src/test/regress/expected/rules.out 2026-05-25 19:25:59.945520780 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/rules.out 2026-05-25 19:29:16.327871888...
@@ -1889,6 +1889,9 @@
pg_stat_get_checkpointer_sync_time() AS sync_time,
pg_stat_get_checkpointer_buffers_written() AS buffers_written,
pg_stat_get_checkpointer_slru_written() AS slru_written,
+ pg_stat_get_checkpointer_segs_added() AS segs_added,
+ pg_stat_get_checkpointer_segs_removed() AS segs_removed,
+ pg_stat_get_checkpointer_segs_recycled() AS segs_recycled,
pg_stat_get_checkpointer_stat_reset_time() AS stats_reset;
pg_stat_database| SELECT oid AS datid,
datname, |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/rules.out /home/postgres/postgres/build/testrun/recovery/027_...
--- /home/postgres/postgres/src/test/regress/expected/rules.out 2026-05-25 19:25:59.945520780 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/rules.out 2026-05-25 19:30:07.8442491...
@@ -1889,6 +1889,9 @@
pg_stat_get_checkpointer_sync_time() AS sync_time,
pg_stat_get_checkpointer_buffers_written() AS buffers_written,
pg_stat_get_checkpointer_slru_written() AS slru_written,
+ pg_stat_get_checkpointer_segs_added() AS segs_added,
+ pg_stat_get_checkpointer_segs_removed() AS segs_removed,
+ pg_stat_get_checkpointer_segs_recycled() AS segs_recycled,
pg_stat_get_checkpointer_stat_reset_time() AS stats_reset;
pg_stat_database| SELECT oid AS datid,
datname, |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/rules.out /home/postgres/postgres/build/testrun/regress/regre...
--- /home/postgres/postgres/src/test/regress/expected/rules.out 2026-05-25 19:25:59.945520780 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/rules.out 2026-05-25 19:29:15.862858321 +0000
@@ -1889,6 +1889,9 @@
pg_stat_get_checkpointer_sync_time() AS sync_time,
pg_stat_get_checkpointer_buffers_written() AS buffers_written,
pg_stat_get_checkpointer_slru_written() AS slru_written,
+ pg_stat_get_checkpointer_segs_added() AS segs_added,
+ pg_stat_get_checkpointer_segs_removed() AS segs_removed,
+ pg_stat_get_checkpointer_segs_recycled() AS segs_recycled,
pg_stat_get_checkpointer_stat_reset_time() AS stats_reset;
pg_stat_database| SELECT oid AS datid,
datname, |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/rules.out /home/postgres/postgres/build/testrun/test_plan_adv...
--- /home/postgres/postgres/src/test/regress/expected/rules.out 2026-05-25 19:25:59.945520780 +0000
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/rules.out 2026-05-25 19:29:20...
@@ -1889,6 +1889,9 @@
pg_stat_get_checkpointer_sync_time() AS sync_time,
pg_stat_get_checkpointer_buffers_written() AS buffers_written,
pg_stat_get_checkpointer_slru_written() AS slru_written,
+ pg_stat_get_checkpointer_segs_added() AS segs_added,
+ pg_stat_get_checkpointer_segs_removed() AS segs_removed,
+ pg_stat_get_checkpointer_segs_recycled() AS segs_recycled,
pg_stat_get_checkpointer_stat_reset_time() AS stats_reset;
pg_stat_database| SELECT oid AS datid,
datname, |
| tap |
[19:30:04.135](92.998s) not ok 5 - regression tests in old instance |
| tap |
[19:30:59.475](105.764s) not ok 2 - regression tests pass |
| tap |
[19:29:54.700](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
| tap |
[19:30:08.823](100.389s) not ok 1 - regression tests pass |