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
Uh oh!
There was an error while loading. Please reload this page.
-
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