[Flaky test] job_errors_permissions

[jnidzwetzki]

Which test is flaky?

job_errors_permissions

Since when has the test been flaky?

08.03.2024

Link to the failed test run

https://github.com/timescale/timescaledb/actions/runs/8196660597/job/22417341187

Log output

diff -u /mnt/d/a/timescaledb/timescaledb/tsl/test/expected/job_errors_permissions.out /mnt/d/a/timescaledb/timescaledb/build_wsl/tsl/test/results/job_errors_permissions.out
--- /mnt/d/a/timescaledb/timescaledb/tsl/test/expected/job_errors_permissions.out	2024-03-08 00:21:07.368910000 +0000
+++ /mnt/d/a/timescaledb/timescaledb/build_wsl/tsl/test/results/job_errors_permissions.out	2024-03-08 00:31:36.882799000 +0000
@@ -90,21 +90,19 @@
 SET ROLE :ROLE_DEFAULT_PERM_USER_2;
 SELECT job_id, proc_schema, proc_name, sqlerrcode, err_message
 FROM timescaledb_information.job_errors WHERE job_id >= 1000;
- job_id | proc_schema |  proc_name   | sqlerrcode |                     err_message                     
---------+-------------+--------------+------------+-----------------------------------------------------
-   1002 | public      | custom_proc2 | 40001      | could not serialize access due to concurrent update
-(1 row)
+ job_id | proc_schema | proc_name | sqlerrcode | err_message 
+--------+-------------+-----------+------------+-------------
+(0 rows)
 
 SET ROLE :ROLE_SUPERUSER;
 SELECT job_id, proc_schema, proc_name, sqlerrcode, err_message
 FROM timescaledb_information.job_errors WHERE job_id >= 1000;
- job_id | proc_schema |  proc_name   | sqlerrcode |                     err_message                     
---------+-------------+--------------+------------+-----------------------------------------------------
-   1000 | public      | job_fail     | P0001      | raising an exception
-   1002 | public      | custom_proc2 | 40001      | could not serialize access due to concurrent update
-  11111 |             |              |            | not an error
-  22222 |             |              |            | job crash detected, see server logs
-(4 rows)
+ job_id | proc_schema | proc_name | sqlerrcode |             err_message             
+--------+-------------+-----------+------------+-------------------------------------
+   1000 | public      | job_fail  | P0001      | raising an exception
+  11111 |             |           |            | not an error
+  22222 |             |           |            | job crash detected, see server logs
+(3 rows)

Reason for flakiness

No response