Uyuni Question - Uyuni 2021.04

[ghost]

Question

Do we need to run analyze table statements at the postgres db?

We can see that some tables were never analyzed: Table: rhnregtoken, Time since last analyse: 315 d, 307 tables were never analyzed: rhncontentsourcetype/rhnchannelpermission/rhnchanneltrust/rhnchildchannelarchcompat/rhnchannelpermissionrole (first 5 shown), Unhandled tables for: 29 h (warn/crit at 0.00 s/1000 y)WARN

Is this expected from your site?

Regards

[Shirocco88]

@mrstigmata Please have a look at PR https://github.com/uyuni-project/uyuni/pull/4056

Command to enter: spacewalk-sql --select-mode - <<EOF VACUUM ANALYZE; EOF

Please poste results;

[Shirocco88]

@mrstigmata : we need more information to qualify this issue; uyuni version ? postgreSQL version ?

[ghost]

@Shirocco88 thx a lot and sorry because of the missing informations...

Database: Repository : Main Update Repository Name : postgresql-server Version : 13-lp152.3.6.1

Uyuni: Repository : Uyuni Server Stable Name : Uyuni-Server-release Version : 2021.05-123.2.uyuni

The command run without a error:

spacewalk-sql --select-mode - <<EOF

VACUUM ANALYZE; EOF VACUUM

do we need to activate autovaccum or is fine now? our monitoring says greeen after the vaccum analyze command: Table: dual, Time since last vacuum: 11 m, No never checked tables

Regards

[Shirocco88]

thanks for your reply; could you please update to OpenSuSE 15.3 and 2021.06; this should update also postgresql version; it would help us to support and troubleshoot;

Best regards Shirocco88

[ghost]

Hi Shirocco88, I will do the update within the next weeks and come back with informations.

thx a lot!

Best regards

[ghost]

thanks for your reply; could you please update to OpenSuSE 15.3 and 2021.06; this should update also postgresql version; it would help us to support and troubleshoot;

Best regards Shirocco88

Hello Shirocco88,

uyuni and the db is upgraded to the latest version. What can we do to analyze this?

---

Repository : Uyuni Server Stable Name : patterns-uyuni_server Version : 2021.08-1.2.uyuni1 Arch : x86_64 Vendor : obs://build.opensuse.org/systemsmanagement:Uyuni Support Level : Level 2 Installed Size : 58 B Installed : Yes Status : up-to-date Source package : patterns-uyuni-2021.08-1.2.uyuni1.src Summary : Uyuni Server

epository : Update repository wiht updates from SUSE Linux Enterprise 15 Name : postgresql13 Version : 13.3-5.13.1 Arch : x86_64 Vendor : SUSE LLC https://www.suse.com/ Installed Size : 6.4 MiB Installed : Yes (automatically) Status : up-to-date Source package : postgresql13-13.3-5.13.1.src Summary : Basic Clients and Utilities for PostgreSQL

OS: NAME="openSUSE Leap" VERSION="15.3" ID="opensuse-leap" ID_LIKE="suse opensuse" VERSION_ID="15.3" PRETTY_NAME="openSUSE Leap 15.3"

Best regards