[Flaky test] Skip scan test is flaky

[mkindahl]

Which test is flaky?

skip_scan

Since when has the test been flaky?

May 8, 2024

Link to the failed test run

https://github.com/timescale/timescaledb-private/actions/runs/9004603812/job/24738091551?pr=1120

Log output

diff -u /home/runner/work/timescaledb-private/timescaledb-private/tsl/test/expected/skip_scan.out /home/runner/work/timescaledb-private/timescaledb-private/build/tsl/test/results/skip_scan.out
--- /home/runner/work/timescaledb-private/timescaledb-private/tsl/test/expected/skip_scan.out	2024-05-08 15:41:12.861362901 +0000
+++ /home/runner/work/timescaledb-private/timescaledb-private/build/tsl/test/results/skip_scan.out	2024-05-08 15:49:28.766290757 +0000
@@ -475,6 +475,19658 @@
  (1 row)
  
   dev 
+@@ -20368,10025 +20368,10025 @@
+  dev | time | ?column? 
+ -----+------+----------
+    0 |      | q1_10
+-   1 |    1 | q1_10
+-   1 |    2 | q1_10
+-   1 |    3 | q1_10
+-   1 |    4 | q1_10
+-   1 |    5 | q1_10
+-   1 |    6 | q1_10
    .
    .
    .

Reason for flakiness

No response

[mkindahl]

Here is a different failure: https://github.com/timescale/timescaledb-private/actions/runs/9076173967/job/24938328350?pr=1106. Still one of the skip scan tests through.

diff -u /home/runner/work/timescaledb-private/timescaledb-private/tsl/test/expected/plan_skip_scan-15.out /home/runner/work/timescaledb-private/timescaledb-private/build/tsl/test/results/plan_skip_scan-15.out
--- /home/runner/work/timescaledb-private/timescaledb-private/tsl/test/expected/plan_skip_scan-15.out	2024-05-14 08:27:20.150121414 +0000
+++ /home/runner/work/timescaledb-private/timescaledb-private/build/tsl/test/results/plan_skip_scan-15.out	2024-05-14 08:41:36.375585744 +0000
@@ -3733,19 +3733,19 @@
          ->  Custom Scan (SkipScan) on _hyper_1_1_chunk (actual rows=11 loops=1)
                ->  Index Only Scan using _hyper_1_1_chunk_skip_scan_ht_dev_idx on _hyper_1_1_chunk (actual rows=11 loops=1)
                      Index Cond: (dev > NULL::integer)
-                     Heap Fetches: 11
+                     Heap Fetches: 1
          ->  Custom Scan (SkipScan) on _hyper_1_2_chunk (actual rows=11 loops=1)
                ->  Index Only Scan using _hyper_1_2_chunk_skip_scan_ht_dev_idx on _hyper_1_2_chunk (actual rows=11 loops=1)
                      Index Cond: (dev > NULL::integer)
-                     Heap Fetches: 11
+                     Heap Fetches: 1
          ->  Custom Scan (SkipScan) on _hyper_1_3_chunk (actual rows=11 loops=1)
                ->  Index Only Scan using _hyper_1_3_chunk_skip_scan_ht_dev_idx on _hyper_1_3_chunk (actual rows=11 loops=1)
                      Index Cond: (dev > NULL::integer)
-                     Heap Fetches: 11
+                     Heap Fetches: 1
          ->  Custom Scan (SkipScan) on _hyper_1_4_chunk (actual rows=11 loops=1)
                ->  Index Only Scan using _hyper_1_4_chunk_skip_scan_ht_dev_idx on _hyper_1_4_chunk (actual rows=11 loops=1)
                      Index Cond: (dev > NULL::integer)
-                     Heap Fetches: 11
+                     Heap Fetches: 1
 (19 rows)