From: Justin Pryzby <pryzby(at)telsasoft(dot)com> To: Andres Freund <andres(at)anarazel(dot)de> Cc: pgsql-hackers(at)postgresql(dot)org, Thomas Munro <thomas(dot)munro(at)gmail(dot)com>, Andrew Dunstan <andrew(at)dunslane(dot)net>, Melanie Plageman <melanieplageman(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com>, Daniel Gustafsson <daniel(at)yesql(dot)se> Subject: Re: Adding CI to our tree Date: 2022-01-10 22:07:48 Message-ID: 20220110220748.GS14051@telsasoft.com Views: Whole Thread |Raw Message |Download mbox |Resend email Thread: 2021-10-01 22:27:52 from Andres Freund <andres(at)anarazel(dot)de>📎 2021-10-01 23:04:03 from Peter Geoghegan <pg(at)bowt(dot)ie> 2021-10-02 00:10:53 from Andres Freund <andres(at)anarazel(dot)de> 2021-10-02 02:41:13 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com> 2021-10-02 15:05:20 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 2021-10-02 19:59:09 from Andres Freund <andres(at)anarazel(dot)de> 2022-01-10 00:59:11 from Andres Freund <andres(at)anarazel(dot)de> 2021-10-02 20:41:30 from Andrew Dunstan <andrew(at)dunslane(dot)net> 2021-10-02 20:44:44 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 2021-10-02 21:10:09 from Andres Freund <andres(at)anarazel(dot)de> 2021-10-02 21:55:27 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 2021-10-21 15:55:32 from Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com> 2021-10-21 16:04:22 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 2021-10-21 16:35:08 from Andreas Karlsson <andreas(at)proxel(dot)se> 2021-10-22 09:46:38 from Vladimir Sitnikov <sitnikov(dot)vladimir(at)gmail(dot)com> 2021-10-02 18:42:00 from Daniel Gustafsson <daniel(at)yesql(dot)se> 2021-10-02 19:41:07 from Andres Freund <andres(at)anarazel(dot)de> 2021-10-02 19:45:14 from Andres Freund <andres(at)anarazel(dot)de> 2021-10-02 19:48:16 from Daniel Gustafsson <daniel(at)yesql(dot)se> 2021-10-02 19:49:30 from Daniel Gustafsson <daniel(at)yesql(dot)se> 2021-10-02 20:01:51 from Andres Freund <andres(at)anarazel(dot)de> 2021-10-02 20:18:38 from Daniel Gustafsson <daniel(at)yesql(dot)se> 2021-10-03 04:05:17 from Andres Freund <andres(at)anarazel(dot)de> 2021-10-03 17:18:31 from Andres Freund <andres(at)anarazel(dot)de> 2021-10-03 17:30:38 from Andres Freund <andres(at)anarazel(dot)de>📎 2021-10-04 15:07:07 from Andrew Dunstan <andrew(at)dunslane(dot)net> 2021-10-04 20:49:45 from Andres Freund <andres(at)anarazel(dot)de> 2021-10-03 20:37:58 from Daniel Gustafsson <daniel(at)yesql(dot)se> 2021-10-06 04:01:53 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com> 2021-10-06 04:54:37 from Andres Freund <andres(at)anarazel(dot)de> 2022-09-06 20:15:17 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com> 2021-10-10 19:48:09 from Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com> 2021-10-10 20:22:45 from Andres Freund <andres(at)anarazel(dot)de> 2021-11-01 05:57:20 from Andres Freund <andres(at)anarazel(dot)de>📎 2021-11-19 22:17:44 from Melanie Plageman <melanieplageman(at)gmail(dot)com>📎 2021-11-19 22:23:01 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com> 2021-11-19 23:02:04 from Andres Freund <andres(at)anarazel(dot)de> 2021-12-13 21:12:23 from Andres Freund <andres(at)anarazel(dot)de>📎 2021-12-13 22:02:50 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 2021-12-13 22:47:20 from Andres Freund <andres(at)anarazel(dot)de> 2021-12-13 23:14:52 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 2021-12-13 23:45:23 from Andres Freund <andres(at)anarazel(dot)de> 2021-12-15 14:42:45 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 2021-12-15 15:21:24 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 2021-12-15 15:45:52 from Daniel Gustafsson <daniel(at)yesql(dot)se> 2021-12-14 03:51:58 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com> 2021-12-14 04:11:54 from Andres Freund <andres(at)anarazel(dot)de> 2021-12-14 09:15:54 from Daniel Gustafsson <daniel(at)yesql(dot)se> 2021-12-17 11:34:36 from Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com> 2021-12-17 19:31:59 from Andres Freund <andres(at)anarazel(dot)de> 2021-12-17 20:42:19 from Daniel Gustafsson <daniel(at)yesql(dot)se> 2021-12-17 21:24:05 from Andres Freund <andres(at)anarazel(dot)de> 2021-12-17 14:08:53 from Andrew Dunstan <andrew(at)dunslane(dot)net> 2021-12-17 14:36:05 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 2021-12-17 19:34:36 from Andres Freund <andres(at)anarazel(dot)de> 2021-12-18 13:29:01 from Andrew Dunstan <andrew(at)dunslane(dot)net> 2021-12-20 19:21:05 from Andres Freund <andres(at)anarazel(dot)de>📎 2021-12-29 20:17:37 from Andres Freund <andres(at)anarazel(dot)de> 2021-12-29 22:14:09 from Daniel Gustafsson <daniel(at)yesql(dot)se> 2021-12-31 01:46:52 from Andres Freund <andres(at)anarazel(dot)de>📎 2021-12-31 02:28:46 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 2021-12-31 03:03:51 from Andres Freund <andres(at)anarazel(dot)de> 2021-12-31 03:17:33 from Andres Freund <andres(at)anarazel(dot)de> 2021-12-31 14:14:34 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 2022-01-09 19:16:50 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 2022-01-09 19:57:44 from Andres Freund <andres(at)anarazel(dot)de> 2022-01-10 22:07:48 from Justin Pryzby <pryzby(at)telsasoft(dot)com>📎 2022-01-13 18:55:27 from Andres Freund <andres(at)anarazel(dot)de> 2022-01-13 19:06:42 from Justin Pryzby <pryzby(at)telsasoft(dot)com>📎 2022-01-13 19:32:38 from Andres Freund <andres(at)anarazel(dot)de> 2022-01-13 20:27:40 from Andrew Dunstan <andrew(at)dunslane(dot)net> 2022-01-14 23:34:11 from Andres Freund <andres(at)anarazel(dot)de> 2022-01-14 23:54:57 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 2022-01-17 15:25:12 from Andrew Dunstan <andrew(at)dunslane(dot)net> 2022-01-17 18:19:46 from Andres Freund <andres(at)anarazel(dot)de> 2022-01-17 18:50:04 from Robert Haas <robertmhaas(at)gmail(dot)com> 2022-01-17 19:18:09 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 2022-01-17 19:25:10 from Andres Freund <andres(at)anarazel(dot)de> 2022-01-17 19:30:53 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 2022-01-17 20:16:19 from Andres Freund <andres(at)anarazel(dot)de> 2022-01-18 21:08:47 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 2022-01-19 01:16:26 from Andres Freund <andres(at)anarazel(dot)de> 2022-01-19 02:50:07 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 2022-01-19 04:16:46 from Andres Freund <andres(at)anarazel(dot)de> 2022-01-19 04:39:20 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 2022-01-19 04:54:12 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 2022-01-19 20:05:44 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>📎 2022-01-19 20:29:26 from Andres Freund <andres(at)anarazel(dot)de> 2022-01-19 20:43:10 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 2022-01-21 20:00:57 from Andres Freund <andres(at)anarazel(dot)de>📎 2022-01-23 22:11:16 from Andres Freund <andres(at)anarazel(dot)de> 2022-02-03 03:58:28 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 2022-02-03 19:57:18 from Andres Freund <andres(at)anarazel(dot)de> 2022-02-04 05:04:04 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 2022-02-04 07:36:51 from Andres Freund <andres(at)anarazel(dot)de> 2022-02-06 03:23:39 from Andres Freund <andres(at)anarazel(dot)de> 2022-02-12 22:06:40 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 2022-02-12 22:26:25 from Andres Freund <andres(at)anarazel(dot)de> 2022-02-13 21:42:13 from Justin Pryzby <pryzby(at)telsasoft(dot)com>📎 2022-02-13 22:07:09 from Andres Freund <andres(at)anarazel(dot)de> 2022-02-26 02:51:16 from Justin Pryzby <pryzby(at)telsasoft(dot)com>📎 2022-02-27 01:09:08 from Andres Freund <andres(at)anarazel(dot)de> 2022-02-27 01:11:31 from Andres Freund <andres(at)anarazel(dot)de> 2022-02-27 02:43:52 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 2022-02-27 02:50:00 from Andres Freund <andres(at)anarazel(dot)de> 2022-02-27 03:10:57 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 2022-02-27 04:08:38 from Andres Freund <andres(at)anarazel(dot)de> 2022-02-28 20:58:02 from Justin Pryzby <pryzby(at)telsasoft(dot)com>📎 2022-03-02 20:50:58 from Justin Pryzby <pryzby(at)telsasoft(dot)com>📎 2022-03-09 17:47:23 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 2022-03-09 18:12:54 from Andres Freund <andres(at)anarazel(dot)de> 2022-03-09 20:37:31 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 2022-03-10 02:43:16 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com> 2022-03-10 03:33:47 from Andres Freund <andres(at)anarazel(dot)de> 2022-03-10 03:54:13 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com> 2022-03-23 20:52:39 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com> 2022-03-23 21:01:47 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 2022-03-10 20:50:15 from Andres Freund <andres(at)anarazel(dot)de> 2022-03-10 21:00:10 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 2022-03-10 22:06:12 from Justin Pryzby <pryzby(at)telsasoft(dot)com>📎 2022-03-18 22:45:03 from Andres Freund <andres(at)anarazel(dot)de> 2022-03-23 04:14:23 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 2022-03-23 15:54:38 from Andres Freund <andres(at)anarazel(dot)de> 2022-02-13 01:20:08 from Andres Freund <andres(at)anarazel(dot)de> 2022-02-13 05:19:38 from Justin Pryzby <pryzby(at)telsasoft(dot)com>📎 2022-02-13 08:30:06 from Andres Freund <andres(at)anarazel(dot)de> 2022-02-13 16:39:33 from Robert Haas <robertmhaas(at)gmail(dot)com> 2022-02-13 17:13:17 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 2022-02-13 19:14:56 from Andres Freund <andres(at)anarazel(dot)de> 2022-02-13 20:09:20 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 2022-02-13 20:24:03 from Andres Freund <andres(at)anarazel(dot)de> 2022-02-16 12:00:24 from Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com> 2022-02-13 00:24:20 from Andres Freund <andres(at)anarazel(dot)de> 2022-02-13 02:47:04 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 2022-02-13 03:43:37 from Andres Freund <andres(at)anarazel(dot)de> 2022-02-13 21:02:50 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 2022-02-13 21:23:16 from Andres Freund <andres(at)anarazel(dot)de> 2022-02-13 21:31:20 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 2022-02-13 21:53:19 from Andres Freund <andres(at)anarazel(dot)de> 2022-02-16 06:12:36 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 2022-02-16 06:42:09 from Andres Freund <andres(at)anarazel(dot)de> 2022-02-20 19:36:55 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 2022-02-20 20:47:31 from Andres Freund <andres(at)anarazel(dot)de> 2022-02-20 20:57:33 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 2022-03-04 04:56:15 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 2022-03-05 01:30:03 from Andres Freund <andres(at)anarazel(dot)de> 2022-03-06 16:16:54 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 2022-03-07 19:10:54 from Andres Freund <andres(at)anarazel(dot)de> 2022-03-08 06:34:47 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 2022-01-17 21:13:28 from Andrew Dunstan <andrew(at)dunslane(dot)net> 2022-01-18 13:06:18 from Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com> 2022-01-18 16:20:08 from Andrew Dunstan <andrew(at)dunslane(dot)net> 2022-01-18 17:44:13 from Andres Freund <andres(at)anarazel(dot)de> 2022-01-18 18:58:34 from Andrew Dunstan <andrew(at)dunslane(dot)net> 2022-01-13 17:55:54 from Andres Freund <andres(at)anarazel(dot)de> 2022-03-30 15:50:17 from Andres Freund <andres(at)anarazel(dot)de>📎 Lists: pgsql-hackers
On Sun, Jan 09, 2022 at 11:57:44AM -0800, Andres Freund wrote: > On 2022-01-09 13:16:50 -0600, Justin Pryzby wrote: > > diff --git a/contrib/test_decoding/Makefile b/contrib/test_decoding/Makefile > > index 9a31e0b8795..14fd847ba7f 100644 > > --- a/contrib/test_decoding/Makefile > > +++ b/contrib/test_decoding/Makefile > > @@ -10,7 +10,7 @@ ISOLATION = mxact delayed_startup ondisk_startup concurrent_ddl_dml \ > > oldest_xmin snapshot_transfer subxact_without_top concurrent_stream \ > > twophase_snapshot > > > > -REGRESS_OPTS = --temp-config $(top_srcdir)/contrib/test_decoding/logical.conf > > +REGRESS_OPTS = --temp-config=$(top_srcdir)/contrib/test_decoding/logical.conf > > ISOLATION_OPTS = --temp-config $(top_srcdir)/contrib/test_decoding/logical.conf > > Not sure why these are part of the diff?
Because otherwise vcregress runs pg_regress --temp-config test1 test2 [...] ..which means test1 gets eaten as the argument to --temp-config
> > diff --git a/src/tools/ci/pg_ci_base.conf b/src/tools/ci/pg_ci_base.conf > > index d8faa9c26c1..52cdb697a57 100644 > > --- a/src/tools/ci/pg_ci_base.conf > > +++ b/src/tools/ci/pg_ci_base.conf > > @@ -12,3 +12,24 @@ log_connections = true > > log_disconnections = true > > log_line_prefix = '%m [%p][%b] %q[%a][%v:%x] ' > > log_lock_waits = true > > + > > +# test_decoding > > +wal_level = logical > > +max_replication_slots = 4 > > +logical_decoding_work_mem = 64kB > > [ more ] > > This doesn't really seem like a scalable path forward - duplicating > configuration in more places doesn't seem sane. It seems it'd make more sense > to teach vcregress.pl to run NO_INSTALLCHECK targets properly? ISTM that > changing the options passed to pg_regress based on fetchTests() return value > wouldn't be too hard?
It needs to run the tests with separate instance. Maybe you're suggesting to use --temp-instance.
It needs to avoid running on the buildfarm, right ?
-- Justin