search

timescale / timescaledb

An open-source time-series SQL database optimized for fast ingest and complex queries. Packaged as a PostgreSQL extension.
https://www.timescale.com/
Other
16.83k stars 852 forks source link

[Flaky test] Skip scan test is flaky #6899

Open mkindahl opened 2 months ago

mkindahl commented 2 months ago

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 commented 1 month ago

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)