Liquibase connecting to non primary replica

[Tylorjg]

Community Note

• Please vote on this issue by adding a 👍 reaction
  to the original issue to help the community and maintainers prioritize this request
• Please do not leave "+1" or "me too" comments, they generate extra noise for issue followers and do
  not help prioritize the request
• If you are interested in working on this issue or have submitted a pull request, please leave a comment.

Debug Output

N/A

Panic Output

N/A

Steps to Reproduce

1. Use Liquibase v4.27.0.
2. Have a dataset set to Multi-region EU.
3. Have a dataset replica set up in the US.
4. Do not specify the Location in the URL
5. Run a Liquibase command

Expected Behavior

The expectation is that it would connect to the EU location without needing to specify it in the URL.

Actual Behavior

Liquibase is connecting to the US region even though is it the secondary replica which is read-only.

{
  "code": 400,
  "errors": [
    {
      "domain": "global",
      "message": "The dataset replica of the cross region dataset '<host>:<dataset>' in region 'US' is read-only because it's not the primary replica.",
      "reason": "invalid"
    }
  ],
  "message": "The dataset replica of the cross region dataset '<host>:<dataset>' in region 'US' is read-only because it's not the primary replica.",
  "status": "INVALID_ARGUMENT"
}

References

• #0000