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.

55/5987 Add OID descriptions to dumped parse/query/plan trees
SanityCheck
tap
[17:32:29.688](0.390s) not ok 11 - pg_ctl initdb
55/5671 Produce LLVM bitcode files on meson builds
macOS - Sonoma - Meson
tap
[15:33:58.319](0.000s) not ok 377 - pgbench script error: setshell no such command stderr /(?^:could not read result )/
55/5962 Prevent vacuumdb --analyze-only from issuing VACUUM (ONLY_DATABASE_STATS)
Windows - Server 2019, VS 2019 - Meson & ninja
tap
[14:26:17.119](0.000s) not ok 10 - no such database stderr /(?^:FATAL:  database "no-such-database" does not exist)/
55/5967 Identifying function-lookup failures due to argument name mismatches
macOS - Sonoma - Meson
tap
[07:36:01.639](0.000s) not ok 107 - server parameter logging stderr /(?^:ERROR:  invalid input syntax for type json)/
[07:36:01.639](0.000s) not ok 108 - server parameter logging stderr /(?^m:CONTEXT:  JSON data, line 1: \{ invalid\.\.\.[...
55/5323 Support enabling checksums online
macOS - Sonoma - Meson
tap
[03:59:52.207](34.681s) not ok 5 - regression tests pass
tap
[04:00:44.008](48.131s) not ok 2 - regression tests pass
Windows - Server 2019, VS 2019 - Meson & ninja
tap
[04:02:56.895](138.008s) not ok 5 - regression tests pass
tap
[04:05:54.387](153.632s) not ok 2 - regression tests pass
Linux - Debian Bookworm - Meson
tap
[04:04:43.496](85.656s) not ok 5 - regression tests pass
tap
[04:06:05.660](85.644s) not ok 2 - regression tests pass
FreeBSD - Meson
tap
[04:03:28.120](209.315s) not ok 5 - regression tests pass
tap
[04:04:43.024](237.934s) not ok 2 - regression tests pass
55/5940 Improve LWLock tranche name visibility across backends
Linux - Debian Bookworm - Meson
tap
timed out waiting for match: (?^: ERROR:  LWLock tranche is not registered) at /tmp/cirrus-ci-build/src/test/modules/tes...
FreeBSD - Meson
tap
timed out waiting for match: (?^: ERROR:  LWLock tranche is not registered) at /tmp/cirrus-ci-build/src/test/modules/tes...
55/5832 Change the names generated for index partitions
macOS - Sonoma - Meson
tap
[23:46:53.415](0.000s) not ok 420 - pgbench script error: gset non SELECT stderr /(?^:expected one row, got 0)/
55/5944 Fixing the btree_gist inet mess
Windows - Server 2019, VS 2019 - Meson & ninja
tap
[23:30:06.049](0.000s) not ok 4 - connecting to an invalid database: matches
55/5942 Adding locks statistics
macOS - Sonoma - Meson
tap
[20:03:45.319](0.000s) not ok 92 - checking otherwise existent objects in the wrong databases stderr /(?^:pg_amcheck: wa...
[20:03:45.319](0.000s) not ok 93 - checking otherwise existent objects in the wrong databases stderr /(?^:pg_amcheck: wa...
[20:03:45.320](0.000s) not ok 94 - checking otherwise existent objects in the wrong databases stderr /(?^:pg_amcheck: wa...
[20:03:45.320](0.000s) not ok 96 - checking otherwise existent objects in the wrong databases stderr /(?^:pg_amcheck: wa...
[20:03:45.320](0.000s) not ok 97 - checking otherwise existent objects in the wrong databases stderr /(?^:pg_amcheck: wa...
[20:03:45.320](0.000s) not ok 99 - checking otherwise existent objects in the wrong databases stderr /(?^:pg_amcheck: er...
55/5985 CREATE SCHEMA ... CREATE DOMAIN support
Windows - Server 2019, VS 2019 - Meson & ninja
tap
[17:41:21.453](113.888s) not ok 5 - regression tests pass
tap
[17:44:03.638](128.317s) not ok 2 - regression tests pass
Linux - Debian Bookworm - Meson
tap
[17:50:05.004](83.421s) not ok 2 - regression tests pass
55/5923 Let plan_cache_mode to be a little less strict
Windows - Server 2019, VS 2019 - Meson & ninja
tap
[17:12:45.476](122.757s) not ok 5 - regression tests pass
tap
[17:15:35.158](134.677s) not ok 2 - regression tests pass
macOS - Sonoma - Meson
tap
[17:09:33.726](40.415s) not ok 5 - regression tests pass
tap
[17:10:30.980](52.538s) not ok 2 - regression tests pass
Linux - Debian Bookworm - Meson
tap
[17:10:53.973](81.661s) not ok 5 - regression tests pass
tap
[17:12:14.075](81.877s) not ok 2 - regression tests pass
Linux - Debian Bookworm - Autoconf
tap
[17:14:23.895](130.084s) not ok 5 - regression tests pass
tap
[17:16:20.181](71.911s) not ok 2 - regression tests pass
FreeBSD - Meson
tap
[17:12:14.120](201.817s) not ok 5 - regression tests pass
tap
[17:13:16.217](219.102s) not ok 2 - regression tests pass
55/5199 Fix standby may crash when switching-over in certain special cases
macOS - Sonoma - Meson
tap
[16:57:52.799](0.000s) not ok 166 - pgbench expressions stderr /(?^:command=65.: int 65\b)/
[16:57:52.800](0.000s) not ok 167 - pgbench expressions stderr /(?^:command=74.: int 74\b)/
[16:57:52.800](0.000s) not ok 168 - pgbench expressions stderr /(?^:command=83.: int 83\b)/
[16:57:52.800](0.000s) not ok 169 - pgbench expressions stderr /(?^:command=86.: int 86\b)/
[16:57:52.800](0.000s) not ok 170 - pgbench expressions stderr /(?^:command=93.: int 93\b)/
[16:57:52.800](0.000s) not ok 171 - pgbench expressions stderr /(?^:command=95.: int 0\b)/
[16:57:52.801](0.000s) not ok 172 - pgbench expressions stderr /(?^:command=96.: int 1\b)/
[16:57:52.801](0.000s) not ok 173 - pgbench expressions stderr /(?^:command=97.: int 0\b)/
[16:57:52.801](0.000s) not ok 174 - pgbench expressions stderr /(?^:command=98.: int 5432\b)/
[16:57:52.801](0.000s) not ok 175 - pgbench expressions stderr /(?^:command=99.: int -9223372036854775808\b)/
[16:57:52.801](0.000s) not ok 176 - pgbench expressions stderr /(?^:command=100.: int 9223372036854775807\b)/
[16:57:52.801](0.000s) not ok 177 - pgbench expressions stderr /(?^:command=101.: boolean true\b)/
[16:57:52.802](0.000s) not ok 178 - pgbench expressions stderr /(?^:command=102.: boolean true\b)/
[16:57:52.802](0.000s) not ok 179 - pgbench expressions stderr /(?^:command=103.: boolean true\b)/
[16:57:52.802](0.000s) not ok 180 - pgbench expressions stderr /(?^:command=104.: boolean true\b)/
[16:57:52.802](0.000s) not ok 181 - pgbench expressions stderr /(?^:command=105.: boolean true\b)/
[16:57:52.802](0.000s) not ok 182 - pgbench expressions stderr /(?^:command=109.: boolean true\b)/
[16:57:52.802](0.000s) not ok 183 - pgbench expressions stderr /(?^:command=110.: boolean true\b)/
[16:57:52.802](0.000s) not ok 184 - pgbench expressions stderr /(?^:command=111.: boolean true\b)/
[16:57:52.803](0.000s) not ok 185 - pgbench expressions stderr /(?^:command=113.: boolean true\b)/
55/5379 Fix bug with accessing to temporary tables of other sessions
macOS - Sonoma - Meson
tap
[15:37:54.440](0.000s) not ok 4513 - defaults_dir_format: data content is gzip-compressed by default: matches
55/5487 Exists pull-up application with JoinExpr
Windows - Server 2019, VS 2019 - Meson & ninja
tap
[07:52:17.500](116.549s) not ok 5 - regression tests pass
[07:52:51.983](13.329s) not ok 16 - run of pg_upgrade for new instance
[07:52:51.984](0.001s) not ok 17 - pg_upgrade_output.d/ removed after pg_upgrade success
[07:52:54.213](0.220s) not ok 20 - old and new dumps match after pg_upgrade
tap
[07:54:55.058](124.996s) not ok 2 - regression tests pass
[07:54:55.059](0.000s) not ok 3 - primary alive after regression test run
macOS - Sonoma - Meson
tap
[07:49:54.372](52.465s) not ok 5 - regression tests pass
[07:50:11.661](5.860s) not ok 16 - run of pg_upgrade for new instance
[07:50:11.661](0.000s) not ok 17 - pg_upgrade_output.d/ removed after pg_upgrade success
[07:50:12.146](0.041s) not ok 20 - old and new dumps match after pg_upgrade
tap
[07:50:56.191](65.389s) not ok 2 - regression tests pass
[07:50:56.192](0.000s) not ok 3 - primary alive after regression test run
Linux - Debian Bookworm - Meson
tap
[07:53:59.366](79.169s) not ok 5 - regression tests pass
[07:54:24.432](10.697s) not ok 16 - run of pg_upgrade for new instance
[07:54:24.434](0.000s) not ok 17 - pg_upgrade_output.d/ removed after pg_upgrade success
[07:54:26.025](0.143s) not ok 20 - old and new dumps match after pg_upgrade
tap
[07:55:20.695](78.692s) not ok 2 - regression tests pass
[07:55:20.696](0.000s) not ok 3 - primary alive after regression test run
FreeBSD - Meson
tap
[07:52:23.814](190.116s) not ok 5 - regression tests pass
[07:52:58.702](17.652s) not ok 16 - run of pg_upgrade for new instance
[07:52:58.702](0.000s) not ok 17 - pg_upgrade_output.d/ removed after pg_upgrade success
[07:53:00.307](0.031s) not ok 20 - old and new dumps match after pg_upgrade
tap
[07:53:31.114](213.716s) not ok 2 - regression tests pass
[07:53:31.114](0.000s) not ok 3 - primary alive after regression test run
Linux - Debian Bookworm - Autoconf
tap
[07:55:34.341](112.542s) not ok 5 - regression tests pass
[07:55:49.453](6.062s) not ok 16 - run of pg_upgrade for new instance
[07:55:49.454](0.000s) not ok 17 - pg_upgrade_output.d/ removed after pg_upgrade success
[07:55:50.208](0.038s) not ok 20 - old and new dumps match after pg_upgrade
tap
[07:57:19.446](56.955s) not ok 2 - regression tests pass
[07:57:19.446](0.000s) not ok 3 - primary alive after regression test run
55/5755 Parallel processing of indexes in autovacuum
Linux - Debian Bookworm - Meson
tap
[05:09:35.302](53.368s) not ok 5 - regression tests pass
[05:09:53.174](6.889s) not ok 16 - run of pg_upgrade for new instance
[05:09:53.175](0.000s) not ok 17 - pg_upgrade_output.d/ removed after pg_upgrade success
[05:09:54.349](0.095s) not ok 20 - old and new dumps match after pg_upgrade
tap
[05:10:33.884](51.484s) not ok 2 - regression tests pass
[05:10:33.885](0.000s) not ok 3 - primary alive after regression test run
macOS - Sonoma - Meson
tap
[05:06:14.897](58.455s) not ok 5 - regression tests pass
[05:06:41.764](11.048s) not ok 16 - run of pg_upgrade for new instance
[05:06:41.766](0.000s) not ok 17 - pg_upgrade_output.d/ removed after pg_upgrade success
[05:06:43.043](0.110s) not ok 20 - old and new dumps match after pg_upgrade
tap
[05:07:37.351](93.888s) not ok 2 - regression tests pass
[05:07:37.354](0.000s) not ok 3 - primary alive after regression test run
Windows - Server 2019, VS 2019 - Meson & ninja
tap
[05:08:06.511](96.081s) not ok 5 - regression tests pass
[05:08:33.101](9.273s) not ok 16 - run of pg_upgrade for new instance
[05:08:33.102](0.001s) not ok 17 - pg_upgrade_output.d/ removed after pg_upgrade success
[05:08:34.704](0.116s) not ok 20 - old and new dumps match after pg_upgrade
tap
[05:10:11.104](92.035s) not ok 2 - regression tests pass
[05:10:11.105](0.001s) not ok 3 - primary alive after regression test run
FreeBSD - Meson
tap
[05:08:05.684](131.038s) not ok 5 - regression tests pass
[05:08:34.208](12.198s) not ok 16 - run of pg_upgrade for new instance
[05:08:34.209](0.000s) not ok 17 - pg_upgrade_output.d/ removed after pg_upgrade success
[05:08:35.413](0.027s) not ok 20 - old and new dumps match after pg_upgrade
tap
[05:09:03.703](143.812s) not ok 2 - regression tests pass
[05:09:03.705](0.000s) not ok 3 - primary alive after regression test run
Linux - Debian Bookworm - Autoconf
tap
[05:11:42.167](96.656s) not ok 5 - regression tests pass
[05:12:10.764](9.396s) not ok 16 - run of pg_upgrade for new instance
[05:12:10.765](0.000s) not ok 17 - pg_upgrade_output.d/ removed after pg_upgrade success
[05:12:11.560](0.035s) not ok 20 - old and new dumps match after pg_upgrade
55/5644 Add arbitrary xid and mxid to pg_resetwal
FreeBSD - Meson
tap
[04:56:38.966](18.428s) not ok 16 - run of pg_upgrade for new instance
[04:56:38.966](0.000s) not ok 17 - pg_upgrade_output.d/ removed after pg_upgrade success
[04:56:40.862](0.031s) not ok 20 - old and new dumps match after pg_upgrade
Linux - Debian Bookworm - Autoconf
tap
[04:57:07.894](10.866s) Bail out!  command "pg_resetwal -D /tmp/cirrus-ci-build/src/bin/pg_resetwal/tmp_check/t_003_adva...
Linux - Debian Bookworm - Meson
tap
[04:55:44.019](9.046s) not ok 16 - run of pg_upgrade for new instance
[04:55:44.019](0.000s) not ok 17 - pg_upgrade_output.d/ removed after pg_upgrade success
[04:55:45.400](0.145s) not ok 20 - old and new dumps match after pg_upgrade
macOS - Sonoma - Meson
tap
[04:55:54.153](8.225s) not ok 16 - run of pg_upgrade for new instance
[04:55:54.154](0.000s) not ok 17 - pg_upgrade_output.d/ removed after pg_upgrade success
[04:55:55.245](0.077s) not ok 20 - old and new dumps match after pg_upgrade
Windows - Server 2019, VS 2019 - Meson & ninja
tap
[04:57:05.367](14.841s) not ok 16 - run of pg_upgrade for new instance
[04:57:05.395](0.027s) not ok 17 - pg_upgrade_output.d/ removed after pg_upgrade success
[04:57:07.247](0.251s) not ok 20 - old and new dumps match after pg_upgrade
55/5955 pg_waldump: support decoding of WAL inside tarfile
Linux - Debian Bookworm - Autoconf
tap
[23:44:54.449](0.319s) not ok 5 - verify backup backup1
[23:44:54.758](0.308s) not ok 6 - verify backup backup2
[23:44:55.078](0.320s) not ok 7 - verify backup backup3
tap
[23:44:57.254](0.135s) not ok 2 - verify original backup
[23:44:57.877](0.129s) not ok 7 - verify backup csum_none
[23:44:58.720](0.336s) not ok 9 - verify backup csum_sha224
macOS - Sonoma - Meson
tap
[23:44:25.183](21.509s) not ok 6 - verify backup, compression gzip
tap
[23:44:25.165](21.655s) not ok 103 - pg_waldump : runs ok
[23:44:33.233](5.924s) not ok 144 - runs with path option and start and end locations: exit code 0
55/5588 Improvement of var_eq_non_const()
macOS - Sonoma - Meson
tap
[22:26:29.336](74.183s) not ok 5 - regression tests pass
tap
[22:28:16.452](101.810s) not ok 2 - regression tests pass
Windows - Server 2019, VS 2019 - Meson & ninja
tap
[22:28:43.866](125.905s) not ok 5 - regression tests pass
tap
[22:31:27.204](134.309s) not ok 2 - regression tests pass
Linux - Debian Bookworm - Meson
tap
[22:26:55.245](81.761s) not ok 5 - regression tests pass
tap
[22:28:13.845](80.833s) not ok 2 - regression tests pass
FreeBSD - Meson
tap
[22:28:21.510](208.615s) not ok 5 - regression tests pass
tap
[22:29:47.243](248.666s) not ok 2 - regression tests pass
Linux - Debian Bookworm - Autoconf
tap
[22:29:38.384](118.641s) not ok 5 - regression tests pass
55/5553 starjoin join order planning
Windows - Server 2019, VS 2019 - Meson & ninja
tap
[22:14:36.878](130.702s) not ok 5 - regression tests pass
tap
[22:17:45.298](148.539s) not ok 2 - regression tests pass
tap
[22:23:59.808](2.785s) not ok 1 - no parameters missing from postgresql.conf.sample
macOS - Sonoma - Meson
tap
[22:13:17.582](70.951s) not ok 5 - regression tests pass
tap
[22:15:04.855](99.872s) not ok 2 - regression tests pass
tap
[22:17:58.721](1.205s) not ok 1 - no parameters missing from postgresql.conf.sample
Linux - Debian Bookworm - Meson
tap
[22:15:57.337](85.341s) not ok 5 - regression tests pass
tap
[22:17:23.032](86.342s) not ok 2 - regression tests pass
tap
[22:20:27.531](2.069s) not ok 1 - no parameters missing from postgresql.conf.sample
Linux - Debian Bookworm - Autoconf
tap
[22:19:56.514](151.498s) not ok 5 - regression tests pass
tap
[22:16:38.748](0.735s) not ok 1 - no parameters missing from postgresql.conf.sample
tap
[22:20:49.994](109.934s) not ok 2 - regression tests pass
FreeBSD - Meson
tap
[22:14:54.505](216.494s) not ok 5 - regression tests pass
tap
[22:15:56.396](232.735s) not ok 2 - regression tests pass
tap
[22:17:05.574](1.600s) not ok 1 - no parameters missing from postgresql.conf.sample
55/5901 Proposal to allow DELETE/UPDATE on partitioned tables with unsupported foreign partitions
Windows - Server 2019, VS 2019 - Meson & ninja
tap
[22:13:40.299](130.836s) not ok 5 - regression tests pass
tap
[22:16:17.078](130.465s) not ok 2 - regression tests pass
macOS - Sonoma - Meson
tap
[22:12:03.533](63.171s) not ok 5 - regression tests pass
tap
[22:13:48.752](103.187s) not ok 2 - regression tests pass
Linux - Debian Bookworm - Meson
tap
[22:14:37.493](74.996s) not ok 5 - regression tests pass
tap
[22:15:55.715](77.863s) not ok 2 - regression tests pass
FreeBSD - Meson
tap
[22:14:05.174](219.538s) not ok 5 - regression tests pass
tap
[22:15:31.251](257.613s) not ok 2 - regression tests pass
Linux - Debian Bookworm - Autoconf
tap
[22:17:23.624](132.321s) not ok 5 - regression tests pass
55/5892 parallel safety of correlated subquery (was: parallel_safe)
macOS - Sonoma - Meson
tap
[21:59:43.795](0.000s) not ok 278 - pgbench script error: shell undefined variable stderr /(?^:undefined variable ":nosu...
Linux - Debian Bookworm - Meson
tap
[22:01:06.304](10.138s) not ok 5 - regression tests pass
[22:01:25.043](11.544s) not ok 14 - run of pg_upgrade --check for new instance
[22:01:25.044](0.000s) not ok 15 - pg_upgrade_output.d/ removed after pg_upgrade --check success
[22:01:25.271](0.227s) not ok 16 - run of pg_upgrade for new instance
[22:01:25.271](0.000s) not ok 17 - pg_upgrade_output.d/ removed after pg_upgrade success
[22:01:25.432](0.026s) not ok 18 - check that locales in new cluster match original cluster
[22:01:25.944](0.038s) not ok 20 - old and new dumps match after pg_upgrade
tap
[22:00:59.045](0.000s) not ok 2 - run of pg_upgrade where the new cluster has insufficient "max_replication_slots" stdou...
[22:01:03.787](0.000s) not ok 6 - run of pg_upgrade of old cluster with slots having unconsumed WAL records stdout /(?^:...
tap
[22:01:06.987](0.000s) not ok 2 - run of pg_upgrade where the new cluster has insufficient max_active_replication_origin...
tap
[22:01:07.512](8.298s) not ok 13 - run of pg_upgrade
[22:01:07.518](0.000s) not ok 16 - the default char signedness is updated during pg_upgrade: matches
tap
[22:01:07.154](13.000s) not ok 1 - pg_upgrade with transfer mode --clone: stdout matches
[22:01:25.153](14.761s) not ok 3 - pg_upgrade with transfer mode --copy: stdout matches
[22:01:31.331](4.257s) not ok 5 - pg_upgrade with transfer mode --copy-file-range: stdout matches
[22:01:38.361](4.714s) not ok 7 - pg_upgrade with transfer mode --link: stdout matches
[22:01:47.141](6.493s) not ok 9 - pg_upgrade with transfer mode --swap: stdout matches
tap
[22:01:52.992](10.842s) not ok 2 - regression tests pass
[22:01:52.993](0.001s) not ok 3 - primary alive after regression test run
55/5948 Add CHECK_FOR_INTERRUPTS in pg_buffercache_pages while scanning the buffers
Windows - Server 2019, VS 2019 - Meson & ninja
tap
[09:48:50.184](0.000s) not ok 18 - checking with a non-existent user stderr /(?^:role "no_such_user" does not exist)/
53/4817 on_error table, saving error info to a table
macOS - Sonoma - Meson
tap
[14:41:09.561](0.000s) not ok 66 - all output lines are FPW
53/5719 MergeAppend could consider sorting cheapest child path
Windows - Server 2019, VS 2019 - Meson & ninja
tap
[18:54:32.167](111.821s) not ok 5 - regression tests pass
tap
[18:57:24.087](130.337s) not ok 2 - regression tests pass
macOS - Sonoma - Meson
tap
[18:51:09.338](37.756s) not ok 5 - regression tests pass
tap
[18:52:03.554](50.800s) not ok 2 - regression tests pass
Linux - Debian Bookworm - Meson
tap
[18:53:26.747](71.456s) not ok 5 - regression tests pass
tap
[18:54:43.325](75.097s) not ok 2 - regression tests pass
FreeBSD - Meson
tap
[18:54:24.054](197.290s) not ok 5 - regression tests pass
tap
[18:55:29.408](215.905s) not ok 2 - regression tests pass
Linux - Debian Bookworm - Autoconf
tap
[18:56:20.508](148.133s) not ok 5 - regression tests pass
53/5726 Proposal for enabling auto-vectorization for checksum calculations
Windows - Server 2019, VS 2019 - Meson & ninja
tap
[03:34:30.246](0.001s) not ok 5 - vacuumdb cannot target invalid database: matches
53/5634 track generic and custom plan calls in pg_stat_statements
macOS - Sonoma - Meson
tap
[19:49:54.504](0.000s) not ok 362 - pgbench script error: set bigint sub overflow stderr /(?^:int sub out)/
53/5751 Disable parallel query by default
Windows - Server 2019, VS 2019 - Meson & ninja
tap
[10:46:36.652](123.200s) not ok 5 - regression tests pass
tap
[10:49:20.884](133.157s) not ok 2 - regression tests pass
macOS - Sonoma - Meson
tap
[10:43:08.617](39.890s) not ok 5 - regression tests pass
tap
[10:44:14.030](61.662s) not ok 2 - regression tests pass
Linux - Debian Bookworm - Meson
tap
[10:47:32.510](81.166s) not ok 5 - regression tests pass
tap
[10:48:53.266](83.784s) not ok 2 - regression tests pass
Linux - Debian Bookworm - Autoconf
tap
[10:49:50.604](115.319s) not ok 5 - regression tests pass
tap
[10:51:40.190](72.564s) not ok 2 - regression tests pass
FreeBSD - Meson
tap
[10:44:31.154](72.026s) not ok 5 - regression tests pass
tap
[10:45:48.203](101.544s) not ok 2 - regression tests pass