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.81k stars 852 forks source link

[Flaky test] chunk_utils #6772

Open mkindahl opened 3 months ago

mkindahl commented 3 months ago

Which test is flaky?

chunk_utils

Since when has the test been flaky?

March 15, 2024

Link to the failed test run

https://github.com/timescale/timescaledb/actions/runs/8289323863/job/22685543349

Log output

diff -u /__w/timescaledb/timescaledb/test/expected/chunk_utils.out /__w/timescaledb/timescaledb/build/test/results/chunk_utils.out
--- /__w/timescaledb/timescaledb/test/expected/chunk_utils.out  2024-03-15 00:18:55.903196412 +0000
+++ /__w/timescaledb/timescaledb/build/test/results/chunk_utils.out 2024-03-15 00:30:00.311790704 +0000
@@ -959,13 +959,14 @@
     \set ECHO errors
  Different Rows | Total Rows from Query 1 | Total Rows from Query 2 
 ----------------+-------------------------+-------------------------
-              0 |                       2 |                       2
+              0 |                       1 |                       1
 (1 row)

     SELECT * FROM test.show_subtables('drop_chunk_test_ts');
- Child | Tablespace 
--------+------------
-(0 rows)
+                  Child                  | Tablespace 
+-----------------------------------------+------------
+ _timescaledb_internal._hyper_4_19_chunk | 
+(1 row)

 ROLLBACK;
 BEGIN;

Reason for flakiness

No response

mkindahl commented 2 months ago

Another failure: https://github.com/timescale/timescaledb-private/actions/runs/8717126386/job/23911872955?pr=1112

diff -u /home/runner/work/timescaledb-private/timescaledb-private/test/expected/chunk_utils.out /home/runner/work/timescaledb-private/timescaledb-private/build/test/results/chunk_utils.out
--- /home/runner/work/timescaledb-private/timescaledb-private/test/expected/chunk_utils.out 2024-04-17 06:12:03.185235230 +0000
+++ /home/runner/work/timescaledb-private/timescaledb-private/build/test/results/chunk_utils.out    2024-04-17 06:18:00.156596918 +0000
@@ -959,13 +959,14 @@
     \set ECHO errors
  Different Rows | Total Rows from Query 1 | Total Rows from Query 2 
 ----------------+-------------------------+-------------------------
-              0 |                       2 |                       2
+              0 |                       1 |                       1
 (1 row)

     SELECT * FROM test.show_subtables('drop_chunk_test_ts');
- Child | Tablespace 
--------+------------
-(0 rows)
+                  Child                  | Tablespace 
+-----------------------------------------+------------
+ _timescaledb_internal._hyper_4_19_chunk | 
+(1 row)

 ROLLBACK;
 BEGIN;