search

vitabaks / postgresql_cluster

PostgreSQL High-Availability Cluster (based on Patroni). Automating with Ansible.
https://postgresql-cluster.org
MIT License
1.69k stars 411 forks source link

Do not use a proxy when accessing the Patroni API #521

Closed vitabaks closed 11 months ago

vitabaks commented 11 months ago

Do not use a proxy server when accessing the Patroni REST API.

Fixed:

PLAY [(2/4) UPDATE: Secondary] *************************************************
TASK [Include OS-specific variables] *******************************************
ok: [10.128.67.12]
TASK [Stop read-only traffic] **************************************************
TASK [update : Edit patroni.yml | enable noloadbalance, nosync, nofailover] ****
changed: [10.128.67.12] => (item=noloadbalance: true)
changed: [10.128.67.12] => (item=nosync: true)
changed: [10.128.67.12] => (item=nofailover: true)
TASK [update : Reload patroni service] *****************************************
changed: [10.128.67.12]
FAILED - RETRYING: [10.128.67.12]: Make sure replica endpoint is unavailable (30 retries left).
FAILED - RETRYING: [10.128.67.12]: Make sure replica endpoint is unavailable (29 retries left).
FAILED - RETRYING: [10.128.67.12]: Make sure replica endpoint is unavailable (28 retries left).
FAILED - RETRYING: [10.128.67.12]: Make sure replica endpoint is unavailable (27 retries left).
FAILED - RETRYING: [10.128.67.12]: Make sure replica endpoint is unavailable (26 retries left).
FAILED - RETRYING: [10.128.67.12]: Make sure replica endpoint is unavailable (25 retries left).
FAILED - RETRYING: [10.128.67.12]: Make sure replica endpoint is unavailable (24 retries left).
FAILED - RETRYING: [10.128.67.12]: Make sure replica endpoint is unavailable (23 retries left).
FAILED - RETRYING: [10.128.67.12]: Make sure replica endpoint is unavailable (22 retries left).
FAILED - RETRYING: [10.128.67.12]: Make sure replica endpoint is unavailable (21 retries left).
FAILED - RETRYING: [10.128.67.12]: Make sure replica endpoint is unavailable (20 retries left).
FAILED - RETRYING: [10.128.67.12]: Make sure replica endpoint is unavailable (19 retries left).
FAILED - RETRYING: [10.128.67.12]: Make sure replica endpoint is unavailable (18 retries left).
FAILED - RETRYING: [10.128.67.12]: Make sure replica endpoint is unavailable (17 retries left).
FAILED - RETRYING: [10.128.67.12]: Make sure replica endpoint is unavailable (16 retries left).
FAILED - RETRYING: [10.128.67.12]: Make sure replica endpoint is unavailable (15 retries left).
FAILED - RETRYING: [10.128.67.12]: Make sure replica endpoint is unavailable (14 retries left).
FAILED - RETRYING: [10.128.67.12]: Make sure replica endpoint is unavailable (13 retries left).
FAILED - RETRYING: [10.128.67.12]: Make sure replica endpoint is unavailable (12 retries left).
FAILED - RETRYING: [10.128.67.12]: Make sure replica endpoint is unavailable (11 retries left).
FAILED - RETRYING: [10.128.67.12]: Make sure replica endpoint is unavailable (10 retries left).
FAILED - RETRYING: [10.128.67.12]: Make sure replica endpoint is unavailable (9 retries left).
FAILED - RETRYING: [10.128.67.12]: Make sure replica endpoint is unavailable (8 retries left).
FAILED - RETRYING: [10.128.67.12]: Make sure replica endpoint is unavailable (7 retries left).
FAILED - RETRYING: [10.128.67.12]: Make sure replica endpoint is unavailable (6 retries left).
FAILED - RETRYING: [10.128.67.12]: Make sure replica endpoint is unavailable (5 retries left).
FAILED - RETRYING: [10.128.67.12]: Make sure replica endpoint is unavailable (4 retries left).
FAILED - RETRYING: [10.128.67.12]: Make sure replica endpoint is unavailable (3 retries left).
FAILED - RETRYING: [10.128.67.12]: Make sure replica endpoint is unavailable (2 retries left).
FAILED - RETRYING: [10.128.67.12]: Make sure replica endpoint is unavailable (1 retries left).
TASK [update : Make sure replica endpoint is unavailable] **********************
fatal: [10.128.67.12]: FAILED! => {"attempts": 30, "changed": false, "connection": "close", "content_language": "en", "content_length": "3574", "content_type": "text/html;charset=utf-8", "date": "Mon, 04 Dec 2023 11:38:01 GMT", "elapsed": 0, "mime_version": "1.0", "msg": "Status code was 403 and not [503]: HTTP Error 403: Forbidden", "redirected": false, "server": "squid/5.7", "status": 403, "url": "http://10.128.67.12:8008/replica", "vary": "Accept-Language", "via": "1.1 ftpserver (squid/5.7)", "x_cache": "MISS from ftpserver", "x_cache_lookup": "NONE from ftpserver:3128", "x_squid_error": "ERR_ACCESS_DENIED 0"}
NO MORE HOSTS LEFT *************************************************************
PLAY RECAP *********************************************************************
10.128.67.11               : ok=9    changed=0    unreachable=0    failed=0    skipped=5    rescued=0    ignored=0   
10.128.67.12               : ok=7    changed=2    unreachable=0    failed=1    skipped=8    rescued=0    ignored=0