PostgreSQL Patch Tester

Current commitfest | Next commitfest | FAQ | Statistics | Highlights

Highlight type: all assertion compiler core linker panic regress sanitizer tap test

Time range: current 7-day 30-day 90-day

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/6584 ECPG: inconsistent behavior with the document in “GET/SET DESCRIPTOR.”
NetBSD - Meson
tap
[22:23:41.606](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback
59/6606 log_checkpoints: count WAL segment creations from all processes
Windows - Server 2022, VS 2019 - Meson & ninja
tap
[19:08:43.677](174.751s) not ok 5 - regression tests in old instance
tap
[19:12:18.747](157.914s) not ok 2 - regression tests pass
tap
[19:11:27.940](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback
tap
[19:08:41.471](180.488s) not ok 1 - regression tests pass
macOS - Sequoia - Meson
tap
[19:10:42.530](143.420s) not ok 5 - regression tests in old instance
tap
[19:14:07.854](171.444s) not ok 2 - regression tests pass
tap
[19:13:06.947](0.001s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback
tap
[19:10:46.888](156.369s) not ok 1 - regression tests pass
Linux - Debian Trixie - Meson
tap
[19:08:46.114](82.011s) not ok 5 - regression tests in old instance
tap
[19:10:20.636](82.783s) not ok 2 - regression tests pass
tap
[19:08:49.865](88.938s) not ok 1 - regression tests pass
FreeBSD - Meson
tap
[19:09:00.733](234.403s) not ok 5 - regression tests in old instance
tap
[19:10:11.451](237.711s) not ok 2 - regression tests pass
tap
[19:07:04.852](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback
tap
[19:09:01.133](237.958s) not ok 1 - regression tests pass
NetBSD - Meson
tap
[19:07:22.568](89.307s) not ok 5 - regression tests in old instance
tap
[19:08:15.677](104.070s) not ok 2 - regression tests pass
tap
[19:07:14.119](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback
tap
[19:07:21.974](91.931s) not ok 1 - regression tests pass
OpenBSD - Meson
tap
[19:08:45.983](117.533s) not ok 5 - regression tests in old instance
tap
[19:11:39.975](188.378s) not ok 2 - regression tests pass
tap
[19:08:54.996](131.739s) not ok 1 - regression tests pass
Linux - Debian Trixie - Autoconf
tap
[19:12:44.865](135.894s) not ok 5 - regression tests in old instance
tap
[19:15:15.837](130.564s) not ok 1 - regression tests pass
tap
[19:15:00.303](165.693s) not ok 2 - regression tests pass
tap
[19:16:57.401](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback
59/5478 SQL/JSON json_table PLAN clause
FreeBSD - Meson
tap
[16:51:18.997](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback
tap
[16:58:36.220](0.000s) not ok 50 - hit injection point check-exclusion-or-unique-constraint-no-conflict
[17:00:23.032](0.000s) not ok 51 - hit injection point exec-insert-before-insert-speculative
59/6543 synchronized_standby_slots behavior inconsistent with quorum-based synchronous replication
Windows - Server 2022, VS 2019 - Meson & ninja
tap
[14:30:32.817](0.001s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback
macOS - Sequoia - Meson
tap
[14:32:02.967](0.001s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback
NetBSD - Meson
tap
[14:24:51.954](0.001s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback
Linux - Debian Trixie - Autoconf
tap
[14:32:31.006](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback
FreeBSD - Meson
tap
[14:25:33.504](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback
59/6558 Pgbench: remove synchronous prepare
Windows - Server 2022, VS 2019 - Meson & ninja
tap
[11:42:20.251](451.246s) # poll_query_until timed out executing this query:
tap
[11:32:13.408](0.001s) 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
[10:16:49.021](0.707s) not ok 1909 - defaults_complex_pipe: pg_dump runs
[10:16:49.497](0.474s) not ok 1910 - defaults_complex_pipe: pg_restore runs
tap
[10:16:30.803](0.442s) not ok 5 - parallel dump with pipe
[10:16:30.956](0.152s) not ok 6 - parallel restore with pipe
tap
[10:12:32.334](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback
59/6749 Disallow whole-row index references with virtual generated columns?
FreeBSD - Meson
tap
[08:10:38.139](0.001s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback
59/6679 Take a long time to reach consistent after pg_rewind
FreeBSD - Meson
tap
[08:08:32.739](0.001s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback
59/6787 Fix LISTEN startup race with direct advancement
FreeBSD - Meson
tap
[05:14:13.462](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback
NetBSD - Meson
tap
[05:14:04.237](0.001s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback
59/6118 Preserve index stats during ALTER TABLE ... TYPE ...
NetBSD - Meson
tap
[01:48:07.732](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback
tap
[01:50:46.532](0.105s) not ok 3 - ensure checksums are set to off on injection_node
59/6400 Add pg_get_publication_ddl function
Windows - Server 2022, VS 2019 - Meson & ninja
tap
[01:08:49.318](462.937s) # poll_query_until timed out executing this query:
tap
[00:58:35.236](0.002s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback
59/6024 Improve read_local_xlog_page_guts by replacing polling with latch-based waiting
NetBSD - Meson
tap
[19:46:33.929](1.134s) not ok 22 - last inactive time for an active physical slot is NULL
tap
[19:47:09.834](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback
59/6771 [SQL/PGQ] Early pruning for GRAPH_TABLE path generation
FreeBSD - Meson
tap
[18:55:38.711](0.001s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback
59/6341 Cleaning up PREPARE query strings?
FreeBSD - Meson
tap
[16:15:18.139](235.172s) not ok 2 - regression tests pass
[16:15:18.141](0.000s) # not ok 219   + partition_merge                             5 ms
# not ok 220   + partition_split                             7 ms
# not ok 221   + partition_join                             46 ms
# not ok 222   + partition_prune                            46 ms
# not ok 223   + reloptions                                 46 ms
# not ok 224   + hash_part                                  46 ms
# not ok 225   + indexing                                   46 ms
# not ok 226   + partition_aggregate                        46 ms
# not ok 227   + partition_info                             45 ms
# not ok 228   + tuplesort                                  45 ms
# not ok 229   + explain                                    45 ms
# not ok 230   + memoize                                    45 ms
# not ok 231   + stats                                      45 ms
# not ok 232   + predicate                                  45 ms
# not ok 233   + numa                                       44 ms
# not ok 234   + eager_aggregate                            44 ms
# not ok 235   + graph_table_rls                            44 ms
# not ok 236   + planner_est                                44 ms
# not ok 237   + compression                                10 ms
# not ok 238   + compression_lz4                             6 ms
# not ok 239   + compression_pglz                           10 ms
# not ok 240   + cluster                                     8 ms
# not ok 241   + oidjoins                                   40 ms
# not ok 242   + event_trigger                              40 ms
# not ok 243   - event_trigger_login                         4 ms
# not ok 244   - fast_default                                5 ms
# not ok 245   - tablespace                                 41 ms
[16:15:18.215](0.073s) not ok 3 - primary alive after regression test run
tap
[16:12:20.659](0.013s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback
59/6356 Hash-based MCV matching for large IN-lists
FreeBSD - Meson
tap
[11:30:31.309](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback
59/6792 to_date()/to_timestamp() silently accept month=0 and day=0
NetBSD - Meson
tap
[11:04:38.605](0.468s) not ok 22 - last inactive time for an active physical slot is NULL
tap
[11:05:18.081](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback
59/6736 COPY ON_CONFLICT TABLE; save duplicated record to another table.
FreeBSD - Meson
tap
[09:28:49.699](27.843s) not ok 5 - regression tests in old instance
[09:28:49.701](0.000s) # not ok 219   + partition_merge                             7 ms
# not ok 220   + partition_split                            20 ms
# not ok 221   + partition_join                             20 ms
# not ok 222   + partition_prune                            20 ms
# not ok 223   + reloptions                                 20 ms
# not ok 224   + hash_part                                  20 ms
# not ok 225   + indexing                                   20 ms
# not ok 226   + partition_aggregate                        19 ms
# not ok 227   + partition_info                             19 ms
# not ok 228   + tuplesort                                  10 ms
# not ok 229   + explain                                    19 ms
# not ok 230   + memoize                                    19 ms
# not ok 231   + stats                                      19 ms
# not ok 232   + predicate                                  19 ms
# not ok 233   + numa                                       18 ms
# not ok 234   + eager_aggregate                            18 ms
# not ok 235   + graph_table_rls                            18 ms
# not ok 236   + planner_est                                18 ms
# not ok 237   + compression                                25 ms
# not ok 238   + compression_lz4                             7 ms
# not ok 239   + compression_pglz                           10 ms
# not ok 240   + cluster                                     6 ms
# not ok 241   + oidjoins                                    8 ms
# not ok 242   + event_trigger                               7 ms
# not ok 243   - event_trigger_login                         4 ms
# not ok 244   - fast_default                                7 ms
# not ok 245   - tablespace                                  4 ms
[09:29:05.117](7.300s) not ok 16 - run of pg_upgrade for new instance
[09:29:05.136](0.000s) not ok 17 - pg_upgrade_output.d/ removed after pg_upgrade success
[09:29:06.614](0.010s) not ok 20 - old and new dumps match after pg_upgrade
tap
[09:29:45.335](29.425s) not ok 2 - regression tests pass
[09:29:45.336](0.000s) # not ok 219   + partition_merge                            25 ms
# not ok 220   + partition_split                            25 ms
# not ok 221   + partition_join                             25 ms
# not ok 222   + partition_prune                            25 ms
# not ok 223   + reloptions                                 25 ms
# not ok 224   + hash_part                                  25 ms
# not ok 225   + indexing                                   24 ms
# not ok 226   + partition_aggregate                         8 ms
# not ok 227   + partition_info                             24 ms
# not ok 228   + tuplesort                                  23 ms
# not ok 229   + explain                                    23 ms
# not ok 230   + memoize                                    23 ms
# not ok 231   + stats                                      23 ms
# not ok 232   + predicate                                  16 ms
# not ok 233   + numa                                       16 ms
# not ok 234   + eager_aggregate                            16 ms
# not ok 235   + graph_table_rls                            10 ms
# not ok 236   + planner_est                                22 ms
# not ok 237   + compression                                 7 ms
# not ok 238   + compression_lz4                             7 ms
# not ok 239   + compression_pglz                            7 ms
# not ok 240   + cluster                                     7 ms
# not ok 241   + oidjoins                                    4 ms
# not ok 242   + event_trigger                               9 ms
# not ok 243   - event_trigger_login                         4 ms
# not ok 244   - fast_default                                4 ms
# not ok 245   - tablespace                                  4 ms
[09:29:45.361](0.024s) not ok 3 - primary alive after regression test run
tap
[09:29:51.097](0.007s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback
tap
[09:28:51.387](32.512s) not ok 1 - regression tests pass
59/6332 json_table function PLAN clause
NetBSD - Meson
tap
[15:12:55.114](1.033s) not ok 2 - check the catching-up state
[15:12:55.191](0.075s) not ok 3 - check that it is safe if WAL fits in max_wal_size
[15:12:55.337](0.145s) not ok 4 - check that slot is working
tap
[15:13:52.306](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback
59/6397 extended statistic (examine_variable) ignored CollateExpr
Linux - Debian Trixie - Meson
tap
[22:17:03.504](89.749s) not ok 5 - regression tests in old instance
tap
[22:18:42.442](88.238s) not ok 2 - regression tests pass
tap
[22:17:06.647](95.869s) not ok 1 - regression tests pass
macOS - Sequoia - Meson
tap
[22:18:47.229](136.298s) not ok 5 - regression tests in old instance
tap
[22:21:56.819](149.457s) not ok 2 - regression tests pass
tap
[22:21:06.001](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback
tap
[22:18:52.273](146.562s) not ok 1 - regression tests pass
NetBSD - Meson
tap
[22:17:17.260](121.175s) not ok 5 - regression tests in old instance
tap
[22:16:56.937](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback
FreeBSD - Meson
tap
[22:18:54.323](261.971s) not ok 5 - regression tests in old instance
tap
[22:20:14.505](270.645s) not ok 2 - regression tests pass
tap
[22:16:40.204](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback
tap
[22:18:59.193](270.143s) not ok 1 - regression tests pass
Linux - Debian Trixie - Autoconf
tap
[22:22:26.486](172.124s) not ok 5 - regression tests in old instance
tap
[22:24:14.374](131.142s) not ok 1 - regression tests pass
tap
[22:23:42.982](188.071s) not ok 2 - regression tests pass
tap
[22:25:48.562](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback