[GPRD][PostgreSQL][Patroni] Python dependency problem with Patroni
On some Patroni nodes we observe Python warnings when executing Patroni. If Patroni fails, this will be catastrophic and needs to be prevented.
There is a discussion on Slack (internal) on how to manually fix this.
However these nodes are managed by Chef and we should make sure that we fix the problem permanently, on all hosts.
root@patroni-ci-2004-102-db-gprd.c.gitlab-production.internal:~# gitlab-patronictl list
2023-07-07 17:54:54,230 - WARNING - /opt/patroni/lib/python3.8/site-packages/requests/__init__.py:109: RequestsDependencyWarning: urllib3 (2.0.0) or chardet (None)/charset_normalizer (3.1.0) doesn't match a supported version!
warnings.warn(
+----------------------------------------------------------+---------------+---------+---------+----+-----------+-----------------+---------------------+
| Member | Host | Role | State | TL | Lag in MB | Pending restart | Tags |
+ Cluster: gprd-patroni-ci-pg12-2004 (6959847276950353765) +---------------+---------+---------+----+-----------+-----------------+---------------------+
| patroni-ci-2004-101-db-gprd.c.gitlab-production.internal | 10.220.24.201 | Leader | running | 13 | | * | |
+----------------------------------------------------------+---------------+---------+---------+----+-----------+-----------------+---------------------+
| patroni-ci-2004-102-db-gprd.c.gitlab-production.internal | 10.220.24.202 | Replica | running | 13 | 24 | * | nofailover: true |
| | | | | | | | noloadbalance: true |
+----------------------------------------------------------+---------------+---------+---------+----+-----------+-----------------+---------------------+
| patroni-ci-2004-103-db-gprd.c.gitlab-production.internal | 10.220.24.203 | Replica | running | 13 | 0 | * | |
+----------------------------------------------------------+---------------+---------+---------+----+-----------+-----------------+---------------------+
| patroni-ci-2004-104-db-gprd.c.gitlab-production.internal | 10.220.24.204 | Replica | running | 13 | 0 | * | |
+----------------------------------------------------------+---------------+---------+---------+----+-----------+-----------------+---------------------+Details
- Point of contact for this request: @alexander-sosna, @bshah11
- If a call is needed, what is the proposed date and time of the call: Date and Time
- Additional call details (format, type of call): additional details
SRE Support Needed Support Request Details