Error after Big For-Loop
Hi everybody!
I have a flow with a For-Loop that works great if the loop gets 50-100 items.
But if I let it run with 2000 iterations that takes more than a half an hour to complete, I get the following error when exiting the loop :
Canceled: Job canceled: Flow 01987a41-3a20-f043-8a10-f54cf4f071d9 was cancelled because it was hanging in between 2 steps.
If I dig deeper, I find the following error:
ERROR src/monitor.rs:619: Error inserting log file: Database(PgDatabaseError { severity: Error, code: "23505", message: "duplicate key value violates unique constraint "log_file_pkey"", detail: Some("Key (hostname, log_ts)=(1bf8a802fb14, 2025-08-05 14:06:00) already exists."), hint: None, position: None, where: None, schema: Some("public"), table: Some("log_file"), column: None, data_type: None, constraint: Some("log_file_pkey"), file: Some("nbtinsert.c"), line: Some(666), routine: Some("_bt_check_unique") })
I ran it multiple times while using the parallel and non-parallel option.
I have no idea where to look next.
Thanks for the help!
Lukas
docker-compose Setup; v1.483.1
I have a flow with a For-Loop that works great if the loop gets 50-100 items.
But if I let it run with 2000 iterations that takes more than a half an hour to complete, I get the following error when exiting the loop :
Canceled: Job canceled: Flow 01987a41-3a20-f043-8a10-f54cf4f071d9 was cancelled because it was hanging in between 2 steps.
If I dig deeper, I find the following error:
ERROR src/monitor.rs:619: Error inserting log file: Database(PgDatabaseError { severity: Error, code: "23505", message: "duplicate key value violates unique constraint "log_file_pkey"", detail: Some("Key (hostname, log_ts)=(1bf8a802fb14, 2025-08-05 14:06:00) already exists."), hint: None, position: None, where: None, schema: Some("public"), table: Some("log_file"), column: None, data_type: None, constraint: Some("log_file_pkey"), file: Some("nbtinsert.c"), line: Some(666), routine: Some("_bt_check_unique") })
I ran it multiple times while using the parallel and non-parallel option.
I have no idea where to look next.
Thanks for the help!
Lukas
docker-compose Setup; v1.483.1
