Jelte Fennema-Nio
Jelte Fennema-Nio
That sounds really bad. Could you share the steps how you changed the replication factor? Do note that these days a replication factor of greater than 1 is generally not...
Do you have a log containing the "deadlock detected" error too? Afaik that's an error coming from Postgres itself. Which would indicate that it's actually not just a distributed deadlock,...
In general to get to the bottom of these issues its important to know which exact queries deadlock on eachother and why. One way to do that is by disabling...
Hmm, okay the exclusive lock on the advisory lock suggests that this is related to the way we serialize updates to reference tables. @agedemenli can you take a closer look?
@lkral-navmatix Okay we were able to reproduce locally and find a minimal reproducing example (see below, needs PG16 for `load_balance_hosts` in `pgbench`). So no need for access to your cluster....
That seems very strange. Are there any errors in the logs of the machines in your cluster?
ALTER DEFAULT PRIVILEGES is currently not propagated to workers (https://github.com/citusdata/citus/issues/7144). I'm pretty sure that's the cause of the issue you're seeing.
Which Citus version is this? Also how did you remove the node? With `citus_remove_node('10.x.y.z', 5432)`? It would be a good thing if `citus_remove_node` would clean those records up automatically (i.e....
Let's update this and get this merged.
Honestly, as far as I know this should already be supported. Could you share an example of a set of commands that is not working as expected for you. Most...