Re: Failure in contrib test _int on loach

On Fri, Apr 5, 2019 at 2:02 AM Thomas Munro <thomas(dot)munro(at)gmail(dot)com> wrote:
>
> Hi,
>
> This is a strange failure:
>
> https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=loach&dt=2019-04-05%2005%3A15%3A00
>
> test _int ... FAILED 649 ms
>
> ================= pgsql.build/contrib/intarray/regression.diffs
> ===================
> diff -U3 /usr/home/pgbf/buildroot/HEAD/pgsql.build/contrib/intarray/expected/_int.out
> /usr/home/pgbf/buildroot/HEAD/pgsql.build/contrib/intarray/results/_int.out
> --- /usr/home/pgbf/buildroot/HEAD/pgsql.build/contrib/intarray/expected/_int.out
> 2019-03-21 12:16:30.514677000 +0100
> +++ /usr/home/pgbf/buildroot/HEAD/pgsql.build/contrib/intarray/results/_int.out
> 2019-04-05 07:23:10.005914000 +0200
> @@ -453,13 +453,13 @@
> SELECT count(*) from test__int WHERE a && '{23,50}';
> count
> -------
> - 403
> + 402
> (1 row)
>
> SELECT count(*) from test__int WHERE a @@ '23|50';
> count
> -------
> - 403
> + 402
> (1 row)
>
> Those two queries are run immediately after:
>
> CREATE INDEX text_idx on test__int using gist ( a gist__int_ops );
>

There are a couple of other recent instances of this failure, on
francolin and whelk.

cheers

andrew

--
Andrew Dunstan https://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services