Re: CTEs and concurrency

2024-03-05 Thread Brecht De Rooms
My apologies, when I said: "When logging the input values, we can see that there are indeed two times the same value sets (exactly the same)" It seems I was wrong, the UUIDs differed on 1-2 characters which means that the problem lies elsewhere in the system. It does seem that my assumptions of

CTEs and concurrency

2024-03-04 Thread Brecht De Rooms
Dear, I am currently running a chaos test on a system (essentially starting nodes that process something and randomly knockign them out). It appeared to work fine with regular tests but I am seeing occasional duplicate key value violattions of a uniqueness constraint on one of the complexer CTE-ba