Skip to content
This repository has been archived by the owner on Aug 22, 2024. It is now read-only.

problem with autodiscovery patroni #17

Open
glushakov opened this issue Oct 25, 2021 · 0 comments
Open

problem with autodiscovery patroni #17

glushakov opened this issue Oct 25, 2021 · 0 comments

Comments

@glushakov
Copy link

Describe the bug
Running pgscv on host with Patroni, and exporter can not discovery patroni
In debug log:
{"level":"debug","service":"pgscv","time":"2021-10-22T17:50:32+03:00","message":"auto-discovery: looking up for new services..."}
{"level":"debug","service":"pgscv","time":"2021-10-22T17:50:32+03:00","message":"auto-discovery [patroni]: analyzing process with pid 2608"}
{"level":"warn","service":"pgscv","time":"2021-10-22T17:50:32+03:00","message":"auto-discovery [python3]: discovery failed: patroni YAML configuration file not found; skip"}

Steps to reproduce
#check all python process:
[root@postgres1 pgsql]# ps ax | grep python
1263 ? Ssl 0:02 /usr/libexec/platform-python -Es /usr/sbin/tuned -l -P
1267 ? Ssl 0:14 /usr/bin/python3 /usr/bin/goferd --foreground
1353 ? Ssl 0:18 /usr/bin/python3.6 /usr/local/bin/patroni /etc/patroni/postgres1.yml
23194 pts/1 S+ 0:00 grep --color=auto python

[root@postgres1 pgsql]# ./pgscv --config-file=pgscv.yaml --log-level=debug
{"level":"info","service":"pgscv","time":"2021-10-25T10:40:49+03:00","message":"read configuration from pgscv.yaml"}
{"level":"info","service":"pgscv","time":"2021-10-25T10:40:49+03:00","message":"no-track disabled, for details check the documentation about 'no_track_mode' option."}
{"level":"debug","service":"pgscv","time":"2021-10-25T10:40:49+03:00","message":"start application"}
{"level":"info","service":"pgscv","time":"2021-10-25T10:40:49+03:00","message":"listen on http://127.0.0.1:9890"}
{"level":"debug","service":"pgscv","time":"2021-10-25T10:40:49+03:00","message":"starting background auto-discovery loop"}
{"level":"info","service":"pgscv","time":"2021-10-25T10:40:49+03:00","message":"auto-discovery: service added [system:0]"}
{"level":"debug","service":"pgscv","time":"2021-10-25T10:40:49+03:00","message":"auto-discovery: looking up for new services..."}
{"level":"debug","service":"pgscv","time":"2021-10-25T10:40:50+03:00","message":"auto-discovery [patroni]: analyzing process with pid 1267"}
{"level":"warn","service":"pgscv","time":"2021-10-25T10:40:50+03:00","message":"auto-discovery [python3]: discovery failed: patroni YAML configuration file not found; skip"}
{"level":"debug","service":"pgscv","time":"2021-10-25T10:40:50+03:00","message":"auto-discovery [postgres]: analyzing process with pid 2077"}

#try to stop all other python processes

[root@postgres1 pgsql]# systemctl stop goferd
[root@postgres1 pgsql]# kill 1263
[root@postgres1 pgsql]# ps ax | grep python
1353 ? Ssl 0:19 /usr/bin/python3.6 /usr/local/bin/patroni /etc/patroni/postgres1.yml
23291 pts/1 S+ 0:00 grep --color=auto python

[root@postgres1 pgsql]# ./pgscv --config-file=pgscv.yaml --log-level=debug
{"level":"info","service":"pgscv","time":"2021-10-25T10:43:48+03:00","message":"read configuration from pgscv.yaml"}
{"level":"info","service":"pgscv","time":"2021-10-25T10:43:48+03:00","message":"no-track disabled, for details check the documentation about 'no_track_mode' option."}
{"level":"debug","service":"pgscv","time":"2021-10-25T10:43:48+03:00","message":"start application"}
{"level":"info","service":"pgscv","time":"2021-10-25T10:43:48+03:00","message":"listen on http://127.0.0.1:9890"}
{"level":"debug","service":"pgscv","time":"2021-10-25T10:43:48+03:00","message":"starting background auto-discovery loop"}
{"level":"info","service":"pgscv","time":"2021-10-25T10:43:48+03:00","message":"auto-discovery: service added [system:0]"}
{"level":"debug","service":"pgscv","time":"2021-10-25T10:43:48+03:00","message":"auto-discovery: looking up for new services..."}
{"level":"debug","service":"pgscv","time":"2021-10-25T10:43:48+03:00","message":"auto-discovery [postgres]: analyzing process with pid 2077"}
{"level":"debug","service":"pgscv","time":"2021-10-25T10:43:48+03:00","message":"making test connection: application_name=pgscv host=/var/run/postgresql port=5432 user=pgscv dbname=postgres password=test"}
{"level":"debug","service":"pgscv","time":"2021-10-25T10:43:48+03:00","message":"test connection success"}
{"level":"debug","service":"pgscv","time":"2021-10-25T10:43:48+03:00","message":"auto-discovery [postgres]: service has been found, pid 2077, available through application_name=pgscv host=/var/run/postgresql port=5432 user=pgscv dbname=postgres password=test"}
{"level":"info","service":"pgscv","time":"2021-10-25T10:43:48+03:00","message":"auto-discovery [postgres]: service added [postgres:5432]"}

Patroni still not found

Expected behavior
Patroni should be discovered

pgSCV startup options
[root@postgres1 pgsql]# cat pgscv.yaml
defaults:
postgres_username: "pgscv"
postgres_password: "test"

Errors and Logs
Add any useful information from logs if possible or errors if there is any.

Environment (please complete the following information):

  • RHEL 8.4
  • pgSCV 0.7.5
  • PostgreSQL Version 12.7
  • Do PostgreSQL and pgSCV are running on the same host? - yes
  • patroni 2.0.2
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant