[BUGS] BUG #14847: "make check" fails 1 of 178 tests - Mailing list pgsql-bugs

The following bug has been logged on the website:

Bug reference:      14847
Logged by:          Bernhard Rosenkraenzer
Email address:      bero@lindev.ch
PostgreSQL version: 10.0
Operating system:   OpenMandriva Linux (kernel 4.13.5, glibc 2.26)
Description:

Running "make check" after building postgresql 10.0 results in

[...]
test stats                    ... FAILED
============== shutting down postmaster               ==============

========================1 of 178 tests failed. 
========================

The differences that caused some tests to fail can be viewed in the
file
"/home/bero/abf/postgresql/BUILD/postgresql-10.0/src/test/regress/regression.diffs".A copy of the test summary that you
see
above is saved in the file
"/home/bero/abf/postgresql/BUILD/postgresql-10.0/src/test/regress/regression.out".


regression.diffs:
***
/home/bero/abf/postgresql/BUILD/postgresql-10.0/src/test/regress/expected/stats.out2017-10-02
23:09:15.000000000 +0200
---
/home/bero/abf/postgresql/BUILD/postgresql-10.0/src/test/regress/results/stats.out2017-10-07
17:02:03.791369854 +0200
***************
*** 8,14 **** SHOW track_counts;  -- must be on  track_counts  --------------
!  on (1 row)  -- ensure that both seqscan and indexscan plans are allowed
--- 8,14 ---- SHOW track_counts;  -- must be on  track_counts  --------------
!  off (1 row)  -- ensure that both seqscan and indexscan plans are allowed
***************
*** 162,172 ****  WHERE relname like 'trunc_stats_test%' order by relname;       relname      | n_tup_ins | n_tup_upd |
n_tup_del| n_live_tup | 
n_dead_tup
-------------------+-----------+-----------+-----------+------------+------------
!  trunc_stats_test  |         3 |         0 |         0 |          0 |        0
!  trunc_stats_test1 |         4 |         2 |         1 |          1 |        0
!  trunc_stats_test2 |         1 |         0 |         0 |          1 |        0
!  trunc_stats_test3 |         4 |         0 |         0 |          2 |        2
!  trunc_stats_test4 |         2 |         0 |         0 |          0 |        2 (5 rows)  SELECT st.seq_scan >=
pr.seq_scan+ 1,
 
--- 162,172 ----  WHERE relname like 'trunc_stats_test%' order by relname;       relname      | n_tup_ins | n_tup_upd |
n_tup_del| n_live_tup | 
n_dead_tup
-------------------+-----------+-----------+-----------+------------+------------
!  trunc_stats_test  |         0 |         0 |         0 |          0 |        0
!  trunc_stats_test1 |         0 |         0 |         0 |          0 |        0
!  trunc_stats_test2 |         0 |         0 |         0 |          0 |        0
!  trunc_stats_test3 |         0 |         0 |         0 |          0 |        0
!  trunc_stats_test4 |         0 |         0 |         0 |          0 |        0 (5 rows)  SELECT st.seq_scan >=
pr.seq_scan+ 1,
 
***************
*** 177,183 ****  WHERE st.relname='tenk2' AND cl.relname='tenk2';  ?column? | ?column? | ?column? | ?column?
----------+----------+----------+----------
!  t        | t        | t        | t (1 row)  SELECT st.heap_blks_read + st.heap_blks_hit >= pr.heap_blks +
cl.relpages,
--- 177,183 ----  WHERE st.relname='tenk2' AND cl.relname='tenk2';  ?column? | ?column? | ?column? | ?column?
----------+----------+----------+----------
!  f        | f        | f        | f (1 row)  SELECT st.heap_blks_read + st.heap_blks_hit >= pr.heap_blks +
cl.relpages,
***************
*** 186,199 ****  WHERE st.relname='tenk2' AND cl.relname='tenk2';  ?column? | ?column?  ----------+----------
!  t        | t (1 row)  SELECT pr.snap_ts < pg_stat_get_snapshot_timestamp() as snapshot_newer FROM prevstats AS pr;
snapshot_newer ----------------
 
!  t (1 row)  DROP TABLE trunc_stats_test, trunc_stats_test1, trunc_stats_test2,
trunc_stats_test3, trunc_stats_test4;
--- 186,199 ----  WHERE st.relname='tenk2' AND cl.relname='tenk2';  ?column? | ?column?  ----------+----------
!  f        | f (1 row)  SELECT pr.snap_ts < pg_stat_get_snapshot_timestamp() as snapshot_newer FROM prevstats AS pr;
snapshot_newer ----------------
 
!  f (1 row)  DROP TABLE trunc_stats_test, trunc_stats_test1, trunc_stats_test2,
trunc_stats_test3, trunc_stats_test4;

======================================================================



--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs