Re: CTEs and concurrency

2024-03-05 Thread Brecht De Rooms
mptions of how this query should behave are correct and that the problem lies elsewhere. > On Mar 4, 2024, at 22:44, Brecht De Rooms wrote: > > Dear, > > I am currently running a chaos test on a system (essentially starting nodes > that process something and randomly knocki

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