Most likely it's not stuck. At the release notes there's a note for the 2021.01 entry about the PostgreSQL upgrade taking up to several hours depending on the environment. On jueves, 4 de marzo de 2021 17:24:08 (CET) Tim Shaw wrote:

Hello

Just upgrading today from 2020.03. Yes - from last March. All seems to be going well but...

The database migration from 10 to 12 has been sitting without any obvious progress for over an hour - is it stuck?

The processes are still running:

13756 ? Ss 0:00 /bin/bash /usr/sbin/spacewalk-startup-helper check-database 13768 ? S 0:08 /usr/bin/perl /usr/bin/spacewalk-schema-upgrade -y 14078 ? S 0:00 psql -U uyuni -d uyuni -h localhost -p 5432 -v ON_ERROR_STOP=ON -f -

And the screen running the upgrade says:

15:03:44 Successfully upgraded database to postgresql 12. 15:03:44 Tune new postgresql configuration... INFO: Database configuration has been changed. INFO: Wrote new general configuration. Backup as /var/lib/pgsql/data/postgresql.2021-03-04-15-03-46.conf INFO: Wrote new client auth configuration. Backup as /var/lib/pgsql/data/pg_hba.2021-03-04-15-03-46.conf INFO: Configuration has been changed, but your database is right now offline. Database is offline System check finished 15:03:46 Successfully tuned new postgresql configuration. 15:03:46 Starting spacewalk services... Starting spacewalk services... Running DB schema upgrade. This may take a while. Call the following command to see progress: journalctl -f -u uyuni-check-database.service

But this hasn't changed for over an hour:

spacewalk:~ # journalctl -f -u uyuni-check-database.service -- Logs begin at Thu 2021-03-04 13:50:15 GMT. -- Mar 04 15:03:58 spacewalk spacewalk-startup-helper[13756]: Schema upgrade: [susemanager-schema-4.1.7-1.1.uyuni] -> [susemanager-schema-4.2.8-1.3.uyuni] Mar 04 15:03:58 spacewalk spacewalk-startup-helper[13756]: Searching for upgrade path to: [susemanager-schema-4.2.8-1] Mar 04 15:03:58 spacewalk spacewalk-startup-helper[13756]: Searching for upgrade path to: [susemanager-schema-4.2.8] Mar 04 15:03:58 spacewalk spacewalk-startup-helper[13756]: Searching for start path: [susemanager-schema-4.1.7-1] Mar 04 15:03:58 spacewalk spacewalk-startup-helper[13756]: Searching for start path: [susemanager-schema-4.1.7] Mar 04 15:03:58 spacewalk spacewalk-startup-helper[13756]: The path: [susemanager-schema-4.1.7] -> [susemanager-schema-4.1.8] -> [susemanager-schema-4.1.9] -> [susemanager-schema-4.1.10] -> [susemanager-schema-4.1.11] -> [susemanager-schema-4.2.0] -> [susemanager-schema-4.2.1] -> [susemanager-schema-4.2.2] -> [susemanager-schema-4.2.3] -> [susemanager-schema-4.2.4] -> [susemanager-schema-4.2.5] -> [susemanager-schema-4.2.6] -> [susemanager-schema-4.2.7] -> [susemanager-schema-4.2.8] Mar 04 15:03:58 spacewalk spacewalk-startup-helper[13756]: Planning to run schema upgrade with dir '/var/log/spacewalk/schema-upgrade/schema-from-20210304-150358' Mar 04 15:03:58 spacewalk spacewalk-startup-helper[13756]: Executing spacewalk-sql, the log is in [/var/log/spacewalk/schema-upgrade/schema-from-20210304-150358-to-susemanag er-schema-4.2.8.log]. Mar 04 15:04:01 spacewalk spacewalk-startup-helper[13756]: [2.0K blob data] Mar 04 15:04:03 spacewalk spacewalk-startup-helper[13756]: [2.0K blob data]

Should I be more patient? Advice welcome!

T

*Please note I am not normally in the office on Mondays or Fridays* ___________________________________________________________ TIM SHAW - Deputy Director - Network Services Medical Sciences Division - University of Oxford email : tim.shaw@medsci.ox.ac.uk tel : +44 (0)1865 289480

-- Julio González Gil Release Engineer, SUSE Manager and Uyuni jgonzalez@suse.com