Intermittent failure in InstallCheck-C "stat" test

From: Thomas Munro <thomas(dot)munro(at)gmail(dot)com>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Intermittent failure in InstallCheck-C "stat" test
Date: 2019-04-05 22:04:53
Message-ID: CA+hUKG+bfS47=L6g1hE4GXg06480aD4VUC=pEBVWRyh0H43UKw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2019-04-05 22:19:17 Re: Intermittent failure in InstallCheck-C "stat" test
Previous Message Andres Freund 2019-04-05 21:58:55 Re: Why does ExecComputeStoredGenerated() form a heap tuple