search

CrunchyData / postgres-operator

Production PostgreSQL for Kubernetes, from high availability Postgres clusters to full-scale database-as-a-service.
https://access.crunchydata.com/documentation/postgres-operator/v5/
Apache License 2.0
3.96k stars 594 forks source link

Can't scale replicas to 3 #4014

Closed meraladine213 closed 2 weeks ago

meraladine213 commented 1 month ago

Problem

Hi, i need to scale my replica from 2 to 3 pods. but, the 3rd read replica wont running. and it always stuck on 1/2 Running state

image

If i check the log inside, it expose error message like this:

/tmp/postgres:5432 - rejecting connections
2024-10-17 06:20:27,027 INFO: Lock owner: hippo-s3-00-wg6f-0; I am hippo-s3-00-7wd7-0
2024-10-17 06:20:27,027 INFO: Still starting up as a standby.
2024-10-17 06:20:27,028 INFO: Lock owner: hippo-s3-00-wg6f-0; I am hippo-s3-00-7wd7-0
2024-10-17 06:20:27,028 INFO: establishing a new patroni connection to the postgres cluster
2024-10-17 06:20:27,794 INFO: establishing a new patroni connection to the postgres cluster
2024-10-17 06:20:27,797 WARNING: Retry got exception: connection problems
2024-10-17 06:20:27,798 WARNING: Failed to determine PostgreSQL state from the connection, falling back to cached role
2024-10-17 06:20:27,799 INFO: no action. I am (hippo-s3-00-7wd7-0), a secondary, and following a leader (hippo-s3-00-wg6f-0)

I need to know how to solve this issue ? is it a bug ? or do i miss some configurations ?

jmckulk commented 2 weeks ago

Hey @meraladine213, I see that you and Andrew are talking about this in the discord. You are welcome to continue this conversation over there, but I'm going to close this issue.