Results 45 comments of Bin Wang

Got it, thanks! It's hard to query all nodes to confirm there is no multiple primaries at the same time since there is gap between queries. Is there any other...

I fixed the command to get primary from endpoint. It passed the test. So I think this issue can be closed. I'll do some tests for transactions and see how...

@CyberDem0n I tried to run some tests and it actually passed serializable tests. But that may because my test is not thoroughly enough to trigger the failures. I want to...

Yeah I'm using the following command to find the primary node: ``` kubectl get endpoints patronidemo -o jsonpath="{.subsets[*].addresses[*].nodeName}" ``` > Client commits a transaction and sends a cancellation request. By...

Another question about primary label: how to define the k8s service to access the primary if the label is not reliable? I current use the config like [this](https://github.com/wb14123/jepsen-postgres-ha/blob/ea163b23ab5251b99f64221c175b6e9de7a2effe/cluster/patroni/k8s.yaml#L156) to define...

Does this mean Patroni can theoretically has no data loss since cancellation is something client **can** control (unlike client being killed, which client cannot control)?

Yeah understood. But as someone using Patroni, as long as I don't send cancellation command, which I can control in my program, Patroni can guarantee no data loss. Is that...

Yeah that's kind of my goal... But I cannot produce any scenario that Patroni lose data. That can mean Patroni is solid, but can also mean my test is not...

Yes. The test workloads are mostly copied from https://github.com/jepsen-io/jepsen/tree/main/stolon, which [caught a Postgres bug in version 12](https://jepsen.io/analyses/postgresql-12.3). In [my test](https://github.com/wb14123/jepsen-postgres-ha), I imported different failures like nodes being killed, network slowdown...

I'm sure the author of Jepsen @aphyr can find more things than I can. I communicated with him through Email. He is busy with other things so encourage me to...