New subject: Upgrade stuck or not...

4 Mar 2021

      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  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

Re: Upgrade stuck or not...

Tim Shaw

Michael Calmer

Tim Shaw

Michael Calmer

tags

participants (3)