Comments (5)
feikesteenbergen
commented on June 14, 2024
1
That looks good, those connection attempts are pg_isready and are most likely the readinessProbe of kubernetes
from helm-charts.
throrin19
commented on June 14, 2024
After research, If I see patroni logs with service patroni status in pods, I have this error :
[FAIL] Patroni configuration file /etc/patroni/postgres.yml does not exist. ... failed!
It's weird because, the patroni config is mount in /etc/timescaledb/patroni.yaml. This is an error in the chart declaration ?
from helm-charts.
feikesteenbergen
commented on June 14, 2024
What do the logs of the containers say?
kubectl logs pod/timescaledb-single-0 -c timescaledb
kubectl logs pod/timescaledb-single-1 -c timescaledb
kubectl logs pod/timescaledb-single-2 -c timescaledb
service patroni status
That will not work within a pod, Patroni is running as pid 1, there is no notion of services inside the container.
The command you use would be useful on a VM deployment, but not inside a container.
from helm-charts.
throrin19
commented on June 14, 2024
After clean recreate deployment, I can connect to the master server.
Ok, I understand for Patroni part.
This is the log for my pods :
- pod/timescaledb-single-0 :
2020-06-24 07:28:14 UTC [32202]: [5ef3008e.7dca-1] [unknown]@[unknown],app=[unknown] [00000] LOG: connection received: host=[local]
2020-06-24 07:28:14 UTC [32202]: [5ef3008e.7dca-2] postgres@postgres,app=[unknown] [00000] LOG: connection authorized: user=postgres database=postgres
2020-06-24 07:28:14 UTC [32202]: [5ef3008e.7dca-3] postgres@postgres,app=pg_isready [00000] LOG: disconnection: session time: 0:00:00.002 user=postgres database=postgres host=[local]
2020-06-24 07:28:14 UTC [32203]: [5ef3008e.7dcb-1] [unknown]@[unknown],app=[unknown] [00000] LOG: connection received: host=172.31.22.118 port=8051
2020-06-24 07:28:14 UTC [32203]: [5ef3008e.7dcb-2] [unknown]@[unknown],app=[unknown] [08P01] LOG: incomplete startup packet
2020-06-24 07:28:15 UTC [32204]: [5ef3008f.7dcc-1] [unknown]@[unknown],app=[unknown] [00000] LOG: connection received: host=172.31.1.35 port=33543
2020-06-24 07:28:15 UTC [32204]: [5ef3008f.7dcc-2] [unknown]@[unknown],app=[unknown] [08P01] LOG: incomplete startup packet
2020-06-24 07:28:15 UTC [32205]: [5ef3008f.7dcd-1] [unknown]@[unknown],app=[unknown] [00000] LOG: connection received: host=172.31.33.61 port=59116
2020-06-24 07:28:15 UTC [32205]: [5ef3008f.7dcd-2] [unknown]@[unknown],app=[unknown] [08P01] LOG: incomplete startup packet
2020-06-24 07:28:15 UTC [32206]: [5ef3008f.7dce-1] [unknown]@[unknown],app=[unknown] [00000] LOG: connection received: host=172.31.22.118 port=17906
2020-06-24 07:28:15 UTC [32206]: [5ef3008f.7dce-2] [unknown]@[unknown],app=[unknown] [08P01] LOG: incomplete startup packet
2020-06-24 07:28:15 UTC [32207]: [5ef3008f.7dcf-1] [unknown]@[unknown],app=[unknown] [00000] LOG: connection received: host=172.31.40.184 port=27819
2020-06-24 07:28:15 UTC [32207]: [5ef3008f.7dcf-2] [unknown]@[unknown],app=[unknown] [08P01] LOG: incomplete startup packet
2020-06-24 07:28:15 UTC [32208]: [5ef3008f.7dd0-1] [unknown]@[unknown],app=[unknown] [00000] LOG: connection received: host=172.31.1.35 port=32921
2020-06-24 07:28:15 UTC [32208]: [5ef3008f.7dd0-2] [unknown]@[unknown],app=[unknown] [08P01] LOG: incomplete startup packet
2020-06-24 07:28:15 UTC [32209]: [5ef3008f.7dd1-1] [unknown]@[unknown],app=[unknown] [00000] LOG: connection received: host=172.31.33.61 port=49244
2020-06-24 07:28:15 UTC [32209]: [5ef3008f.7dd1-2] [unknown]@[unknown],app=[unknown] [08P01] LOG: incomplete startup packet
- pod/timescaledb-single-1 :
2020-06-24 07:25:45 UTC [16644]: [5ef2fff9.4104-2] postgres@postgres,app=[unknown] [00000] LOG: connection authorized: user=postgres database=postgres
2020-06-24 07:25:45 UTC [16644]: [5ef2fff9.4104-3] postgres@postgres,app=pg_isready [00000] LOG: disconnection: session time: 0:00:00.004 user=postgres database=postgres host=[local]
2020-06-24 07:26:15 UTC [16652]: [5ef30017.410c-1] [unknown]@[unknown],app=[unknown] [00000] LOG: connection received: host=[local]
2020-06-24 07:26:15 UTC [16652]: [5ef30017.410c-2] postgres@postgres,app=[unknown] [00000] LOG: connection authorized: user=postgres database=postgres
2020-06-24 07:26:15 UTC [16652]: [5ef30017.410c-3] postgres@postgres,app=pg_isready [00000] LOG: disconnection: session time: 0:00:00.001 user=postgres database=postgres host=[local]
2020-06-24 07:26:45 UTC [16661]: [5ef30035.4115-1] [unknown]@[unknown],app=[unknown] [00000] LOG: connection received: host=[local]
2020-06-24 07:26:45 UTC [16661]: [5ef30035.4115-2] postgres@postgres,app=[unknown] [00000] LOG: connection authorized: user=postgres database=postgres
2020-06-24 07:26:45 UTC [16661]: [5ef30035.4115-3] postgres@postgres,app=pg_isready [00000] LOG: disconnection: session time: 0:00:00.003 user=postgres database=postgres host=[local]
2020-06-24 07:27:15 UTC [16668]: [5ef30053.411c-1] [unknown]@[unknown],app=[unknown] [00000] LOG: connection received: host=[local]
2020-06-24 07:27:15 UTC [16668]: [5ef30053.411c-2] postgres@postgres,app=[unknown] [00000] LOG: connection authorized: user=postgres database=postgres
2020-06-24 07:27:15 UTC [16668]: [5ef30053.411c-3] postgres@postgres,app=pg_isready [00000] LOG: disconnection: session time: 0:00:00.002 user=postgres database=postgres host=[local]
2020-06-24 07:27:45 UTC [16675]: [5ef30071.4123-1] [unknown]@[unknown],app=[unknown] [00000] LOG: connection received: host=[local]
2020-06-24 07:27:45 UTC [16675]: [5ef30071.4123-2] postgres@postgres,app=[unknown] [00000] LOG: connection authorized: user=postgres database=postgres
2020-06-24 07:27:45 UTC [16675]: [5ef30071.4123-3] postgres@postgres,app=pg_isready [00000] LOG: disconnection: session time: 0:00:00.003 user=postgres database=postgres host=[local]
- pod/timescaledb-single-2 :
2020-06-24 07:28:30 UTC [16815]: [5ef3009e.41af-1] [unknown]@[unknown],app=[unknown] [00000] LOG: connection received: host=[local]
2020-06-24 07:28:30 UTC [16815]: [5ef3009e.41af-2] postgres@postgres,app=[unknown] [00000] LOG: connection authorized: user=postgres database=postgres
2020-06-24 07:28:30 UTC [16815]: [5ef3009e.41af-3] postgres@postgres,app=pg_isready [00000] LOG: disconnection: session time: 0:00:00.002 user=postgres database=postgres host=[local]
2020-06-24 07:29:00 UTC [16822]: [5ef300bc.41b6-1] [unknown]@[unknown],app=[unknown] [00000] LOG: connection received: host=[local]
2020-06-24 07:29:00 UTC [16822]: [5ef300bc.41b6-2] postgres@postgres,app=[unknown] [00000] LOG: connection authorized: user=postgres database=postgres
2020-06-24 07:29:00 UTC [16822]: [5ef300bc.41b6-3] postgres@postgres,app=pg_isready [00000] LOG: disconnection: session time: 0:00:00.005 user=postgres database=postgres host=[local]
2020-06-24 07:29:30 UTC [16829]: [5ef300da.41bd-1] [unknown]@[unknown],app=[unknown] [00000] LOG: connection received: host=[local]
2020-06-24 07:29:30 UTC [16829]: [5ef300da.41bd-2] postgres@postgres,app=[unknown] [00000] LOG: connection authorized: user=postgres database=postgres
2020-06-24 07:29:30 UTC [16829]: [5ef300da.41bd-3] postgres@postgres,app=pg_isready [00000] LOG: disconnection: session time: 0:00:00.003 user=postgres database=postgres host=[local]
2020-06-24 07:30:00 UTC [16836]: [5ef300f8.41c4-1] [unknown]@[unknown],app=[unknown] [00000] LOG: connection received: host=[local]
2020-06-24 07:30:00 UTC [16836]: [5ef300f8.41c4-2] postgres@postgres,app=[unknown] [00000] LOG: connection authorized: user=postgres database=postgres
2020-06-24 07:30:00 UTC [16836]: [5ef300f8.41c4-3] postgres@postgres,app=pg_isready [00000] LOG: disconnection: session time: 0:00:00.005 user=postgres database=postgres host=[local]
from helm-charts.
throrin19
commented on June 14, 2024
Thanks 😄 I continue test this chart.
I close the issue
from helm-charts.
Related Issues (20)
- `job-update-patroni` fails if http://{{ template "clusterName" . }}-config:8008/config is not ready, but it exits with success.
- Operation not permitted on `/var/lib/postgresql/pgdata` while using with Amazon EFS HOT 2
- Error in `restore_or_initdb.sh` while restoring a backup
- logs a full of failed to start a background worker HOT 9
- Add support for additional annotations in the statefulset object to support cert-manager/reloader integration
- Add pgbouncer_exporter to Statefulset HOT 1
- Implement option to specify an existing persistent volume in the PVC template HOT 2
- timescaledb ha : Password does not match for user "standby" HOT 3
- Cluster node restarted unexpectedly HOT 2
- Error: INSTALLATION FAILED: repo charts not found HOT 1
- pgbackrest info missing stanza path when BOOTSTRAP_FROM_BACKUP=1 HOT 1
- postgresql core dump crashes timescale database
- pgbackrest_restore.sh exits despite backup being enabled
- Unrecognized option '--comand=/etc/timescaledb/scripts/restore_or_initdb.sh' HOT 2
- timescaledb-single: How to restore from specific backup HOT 1
- timescaledb-single without persistent storage HOT 1
- Helm Chart support HOT 2
- [Bug]: Error - 128 kB is outside the valid range for parameter "maintenance_work_mem HOT 1
- Add CA to allow custom Certificates HOT 3
- Chart requires all images to be installed form one repo, which does not allow for custom images
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from helm-charts.