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
17.49k stars 878 forks source link

[Flaky test] Error message mismatch in rowsecurity test #7256

Open mkindahl opened 1 week ago

mkindahl commented 1 week ago

Which test is flaky?

rowsecurity-16

Since when has the test been flaky?

September 8, 2024

Link to the failed test run

https://github.com/timescale/timescaledb/actions/runs/10755544815/job/29827374594

Log output

diff -u /mnt/d/a/timescaledb/timescaledb/test/expected/rowsecurity-16.out /mnt/d/a/timescaledb/timescaledb/build_wsl/test/results/rowsecurity-16.out
--- /mnt/d/a/timescaledb/timescaledb/test/expected/rowsecurity-16.out   2024-09-08 00:27:21.257371500 +0000
+++ /mnt/d/a/timescaledb/timescaledb/build_wsl/test/results/rowsecurity-16.out  2024-09-08 00:35:47.512216600 +0000
@@ -542,8 +542,8 @@
 (6 rows)

 DELETE FROM category WHERE cid = 33;    -- fails with FK violation
-ERROR:  update or delete on table "category" violates foreign key constraint "document_cid_fkey" on table "document"
-DETAIL:  Key is still referenced from table "document".
+ERROR:  update or delete on table "category" violates foreign key constraint "4_7_document_cid_fkey" on table "_hyper_1_4_chunk"
+DETAIL:  Key is still referenced from table "_hyper_1_4_chunk".
 -- can insert FK referencing invisible PK
 SET SESSION AUTHORIZATION regress_rls_carol;
 SELECT * FROM document d FULL OUTER JOIN category c on d.cid = c.cid ORDER BY d.did, c.cid;

Reason for flakiness

No response

mkindahl commented 1 week ago

This one has the same diff https://github.com/timescale/timescaledb/actions/runs/10746971550/job/29808753764