Thanks to several people for the advice.
It is now 5 hours with no visible change although postgres is certainly busy...
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
14080 postgres 20 0 3232908 2.918g 2.856g R 99.34 24.89 350:24.35 postgres
Files in /var/lib/pgsql/data/pg_stat_tmp/ are constantly changing
I will leave it running overnight. I think it would be helpful for the scripts involved in this process to make some sort of report back to the user on progress from time to time!
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 <jgonzalez@suse.com> 04/03/2021 17:28 >>>
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