Hi,
Just now, and also once 5-and-a-bit days ago, flaviventris failed like
this, as did filefish 41 days ago[1] (there may be more, I just
checked a random sample of InstallCheck-C failures accessible via the
web interface):
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
+ 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,
@@ -180,7 +180,7 @@
WHERE st.relname='tenk2' AND cl.relname='tenk2';
?column? | ?column? | ?column? | ?column?
----------+----------+----------+----------
- t | t | t | t
+ f | f | f | f
(1 row)
SELECT st.heap_blks_read + st.heap_blks_hit >= pr.heap_blks + cl.relpages,
@@ -189,7 +189,7 @@
WHERE st.relname='tenk2' AND cl.relname='tenk2';
?column? | ?column?
----------+----------
- t | t
+ t | f
(1 row)
[1]
https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=filefish&dt=2019-02-23%2009%3A53%3A11
--
Thomas Munro
https://enterprisedb.com
