You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
But it seems after the migration to the new script, we are having issues:
[root@node1 ~]# patronictl -c /etc/patroni/cluster1-1.yml list
+ Cluster: stampede (7298832024534509405) ---------+----+-----------+-----------------+
| Member | Host | Role | State | TL | Lag in MB | Pending restart |
+------------+------------+---------+--------------+----+-----------+-----------------+
| cluster1-0 | 172.28.0.2 | Leader | running | 1 | | * |
| cluster1-1 | 172.28.0.3 | Replica | start failed | | unknown | |
+------------+------------+---------+--------------+----+-----------+-----------------+
The errors are due to:
[root@node1 ~]# cat /var/lib/pgsql/13/data/log/postgresql-Tue.log
...
2023-11-07 21:17:27.884 UTC [2848] ERROR: cannot execute CREATE ROLE in a read-only transaction
2023-11-07 21:17:27.884 UTC [2848] STATEMENT: CREATE USER replicator WITH REPLICATION ENCRYPTED PASSWORD 'verysecretpassword1^';
2023-11-07 21:17:28.750 UTC [2045] LOG: received fast shutdown request
2023-11-07 21:17:28.752 UTC [2045] LOG: aborting any active transactions
2023-11-07 21:17:28.752 UTC [2882] FATAL: terminating connection due to administrator command
2023-11-07 21:17:28.752 UTC [2051] FATAL: terminating walreceiver process due to administrator command
2023-11-07 21:17:28.754 UTC [2048] LOG: shutting down
2023-11-07 21:17:28.839 UTC [2045] LOG: database system is shut down
Let me know if I can help with anything.
The text was updated successfully, but these errors were encountered:
We used to be able to have Patroni deployments:
But it seems after the migration to the new script, we are having issues:
The errors are due to:
Let me know if I can help with anything.
The text was updated successfully, but these errors were encountered: