Unable to create standby cluster from a upgraded cluster #2383
Closed
manohar-koukuntla
started this conversation in
General
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
I have a postgres cluster which was started in postgres 13 and later upgraded to 14. I am trying to create a standby cluster on the on the upgraded cluster but its giving me error
pg_receivewal: disconnected; waiting 5 seconds to try again
NOTICE: all required WAL segments have been archived
2023-07-28 12:08:48,310 INFO: replica has been created using basebackup_fast_xlog
2023-07-28 12:08:48,311 INFO: bootstrapped clone from remote master postgresql://10.1.128.5:5432
2023-07-28 12:08:48 UTC [2283]: [1-1] 64c3afd0.8eb 0 FATAL: database files are incompatible with server
2023-07-28 12:08:48 UTC [2283]: [2-1] 64c3afd0.8eb 0 DETAIL: The data directory was initialized by PostgreSQL version 13, which is not compatible with this version 14.5 (Ubuntu 14.5-1.pgdg18.04+1).
2023-07-28 12:08:48,583 INFO: postmaster pid=2283
/var/run/postgresql:5432 - no response
2023-07-28 12:08:48,592 INFO: removing initialize key after failed attempt to bootstrap the cluster
2023-07-28 12:08:48,611 INFO: renaming data directory to /home/postgres/pgdata/pgroot/data_2023-07-28-12-08-48
Traceback (most recent call last):
File "/usr/local/bin/patroni", line 11, in
sys.exit(main())
File "/usr/local/lib/python3.6/dist-packages/patroni/main.py", line 143, in main
return patroni_main()
File "/usr/local/lib/python3.6/dist-packages/patroni/main.py", line 135, in patroni_main
abstract_main(Patroni, schema)
File "/usr/local/lib/python3.6/dist-packages/patroni/daemon.py", line 100, in abstract_main
controller.run()
File "/usr/local/lib/python3.6/dist-packages/patroni/main.py", line 105, in run
super(Patroni, self).run()
File "/usr/local/lib/python3.6/dist-packages/patroni/daemon.py", line 59, in run
self._run_cycle()
File "/usr/local/lib/python3.6/dist-packages/patroni/main.py", line 108, in _run_cycle
logger.info(self.ha.run_cycle())
File "/usr/local/lib/python3.6/dist-packages/patroni/ha.py", line 1514, in run_cycle
info = self._run_cycle()
File "/usr/local/lib/python3.6/dist-packages/patroni/ha.py", line 1388, in _run_cycle
return self.post_bootstrap()
File "/usr/local/lib/python3.6/dist-packages/patroni/ha.py", line 1280, in post_bootstrap
self.cancel_initialization()
File "/usr/local/lib/python3.6/dist-packages/patroni/ha.py", line 1273, in cancel_initialization
raise PatroniFatalException('Failed to bootstrap cluster')
patroni.exceptions.PatroniFatalException: 'Failed to bootstrap cluster'
/etc/runit/runsvdir/default/patroni: finished with code=1 signal=0
/etc/runit/runsvdir/default/patroni: exceeded maximum number of restarts 5
stopping /etc/runit/runsvdir/default/patroni
timeout: finish: .: (pid 2295) 17s, want down
Beta Was this translation helpful? Give feedback.
All reactions