Intermittent failure in InstallCheck-C "stat" test

Поиск
Список
Период
Сортировка
От Thomas Munro
Тема Intermittent failure in InstallCheck-C "stat" test
Дата
Msg-id CA+hUKG+bfS47=L6g1hE4GXg06480aD4VUC=pEBVWRyh0H43UKw@mail.gmail.com
обсуждение исходный текст
Ответы Re: Intermittent failure in InstallCheck-C "stat" test  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: Why does ExecComputeStoredGenerated() form a heap tuple
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Intermittent failure in InstallCheck-C "stat" test