powa-team / powa

PostgreSQL Workload Analyzer
http://powa.readthedocs.io/
PostgreSQL License
778 stars 57 forks source link

powa packages missing from repos #129

Closed guruguruguru closed 4 years ago

guruguruguru commented 4 years ago

Hi,

it seems the powa packages were removed from the official postgres rpm repo, and they were not moved to the common repo. Do you have any idea if this was by mistake?

Thanks, Dennis

rjuju commented 4 years ago

Hello,

As far as I can tell there's powa-archivist and powa-web packages available on the PGDG repository. For instance for pg12 / RHEL7 / x86-64:

Maybe packages for some specific architecture or pg version are missing, which one are you using?

guruguruguru commented 4 years ago

Hi @rjuju

yes the packages seem to be there but they are missing from the metadata:

PGDG Red Hat Enterprise Linux / CentOS stable common repository for all PostgreSQL versions

[pgdg-common]
name=PostgreSQL common RPMs for RHEL/CentOS $releasever - $basearch
baseurl=https://download.postgresql.org/pub/repos/yum/common/redhat/rhel-$releasever-$basearch
enabled=1
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG
proxy=...:3128

# PGDG Red Hat Enterprise Linux / CentOS stable repositories:

[pgdg12]
name=PostgreSQL 12 for RHEL/CentOS $releasever - $basearch
baseurl=https://download.postgresql.org/pub/repos/yum/12/redhat/rhel-$releasever-$basearch
enabled=1
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG
proxy=http://...:3128

and

yum makecache
Geladene Plugins: fastestmirror, needrestart, versionlock
Loading mirror speeds from cached hostfile
BaseOS                                                                                                                                                                                      | 3.6 kB  00:00:00     
csrpmrepo-intern                                                                                                                                                                            | 2.9 kB  00:00:00     
epel                                                                                                                                                                                        | 2.8 kB  00:00:00     
extras                                                                                                                                                                                      | 2.9 kB  00:00:00     
fasttrack                                                                                                                                                                                   | 2.9 kB  00:00:00     
mam-ampua                                                                                                                                                                                   | 2.9 kB  00:00:00     
pgdg-common                                                                                                                                                                                 | 2.9 kB  00:00:00     
pgdg12                                                                                                                                                                                      | 3.6 kB  00:00:00     
postgres                                                                                                                                                                                    | 3.6 kB  00:00:00     
postgres-common                                                                                                                                                                             | 2.9 kB  00:00:00     
puppetlabs                                                                                                                                                                                  | 2.5 kB  00:00:00     
updates                                                                                                                                                                                     | 2.9 kB  00:00:00     
(1/7): pgdg-common/7/x86_64/primary_db                                                                                                                                                      | 113 kB  00:00:00     
(2/7): pgdg-common/7/x86_64/filelists_db                                                                                                                                                    | 300 kB  00:00:00     
(3/7): pgdg-common/7/x86_64/other_db                                                                                                                                                        |  34 kB  00:00:00     
(4/7): pgdg12/7/x86_64/group_gz                                                                                                                                                             |  245 B  00:00:00     
(5/7): pgdg12/7/x86_64/filelists_db                                                                                                                                                         | 157 kB  00:00:00     
(6/7): pgdg12/7/x86_64/other_db                                                                                                                                                             |  35 kB  00:00:00     
(7/7): pgdg12/7/x86_64/primary_db                                                                                                                                                           | 123 kB  00:00:00     
Metadaten-Zwischenspeicher erstellt

and

yum search powa
Geladene Plugins: fastestmirror, needrestart, versionlock
Loading mirror speeds from cached hostfile
Excluding 4 updates due to versionlock (use "yum versionlock status" to show them)
================================================================================================== Treffer: powa ==================================================================================================
pg_qualstats12.x86_64 : A PostgreSQL extension collecting statistics about predicates
pg_stat_kcache12.x86_64 : A PostgreSQL extension gathering CPU and disk acess statistics
rjuju commented 4 years ago

It's working for me:

# rpm -ivh https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
Retrieving https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
warning: /var/tmp/rpm-tmp.M5m69b: Header V4 DSA/SHA1 Signature, key ID 442df0f8: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...
   1:pgdg-redhat-repo-42.0-11         ################################# [100%]

# yum search powa
Loaded plugins: fastestmirror, ovl
Loading mirror speeds from cached hostfile
 * base: centos.mirror.ate.info
 * extras: mirror.hostup.org
 * updates: centos.mirror.ate.info
================================================================== N/S matched: powa ===================================================================
powa_10-web.x86_64 : The user interface of powa
powa_11-web.x86_64 : The user interface of powa
powa_12-web.x86_64 : The user interface of powa
powa_95-web.x86_64 : The user interface of powa
powa_96-web.x86_64 : The user interface of powa
powa_10.x86_64 : PostgreSQL Workload Analyzer
powa_11.x86_64 : PostgreSQL Workload Analyzer
powa_12.x86_64 : PostgreSQL Workload Analyzer
powa_95.x86_64 : PostgreSQL Workload Analyzer
powa_96.x86_64 : PostgreSQL Workload Analyzer

# yum install powa_12
Loaded plugins: fastestmirror, ovl
Loading mirror speeds from cached hostfile
 * base: centos.mirror.ate.info
 * extras: mirror.hostup.org
 * updates: centos.mirror.ate.info
Resolving Dependencies
[...]
Dependencies Resolved

=====================================================================================================================================================================================================================================================================================================================
 Package                                                                             Arch                                                                Version                                                                          Repository                                                            Size
=====================================================================================================================================================================================================================================================================================================================
Installing:
 powa_12                                                                             x86_64                                                              4.0.1-1.rhel7                                                                    pgdg12                                                                52 k
Installing for dependencies:
 groff-base                                                                          x86_64                                                              1.22.2-8.el7                                                                     base                                                                 942 k
 hypopg_12                                                                           x86_64                                                              1.1.3-1.rhel7                                                                    pgdg12                                                                60 k
 libicu                                                                              x86_64                                                              50.2-4.el7_7                                                                     updates                                                              6.9 M
 libxslt                                                                             x86_64                                                              1.1.28-5.el7                                                                     base                                                                 242 k
 perl                                                                                x86_64                                                              4:5.16.3-295.el7                                                                 base                                                                 8.0 M
 perl-Carp                                                                           noarch                                                              1.26-244.el7                                                                     base                                                                  19 k
 perl-Encode                                                                         x86_64                                                              2.51-7.el7                                                                       base                                                                 1.5 M
 perl-Exporter                                                                       noarch                                                              5.68-3.el7                                                                       base                                                                  28 k
 perl-File-Path                                                                      noarch                                                              2.09-2.el7                                                                       base                                                                  26 k
 perl-File-Temp                                                                      noarch                                                              0.23.01-3.el7                                                                    base                                                                  56 k
 perl-Filter                                                                         x86_64                                                              1.49-3.el7                                                                       base                                                                  76 k
 perl-Getopt-Long                                                                    noarch                                                              2.40-3.el7                                                                       base                                                                  56 k
 perl-HTTP-Tiny                                                                      noarch                                                              0.033-3.el7                                                                      base                                                                  38 k
 perl-PathTools                                                                      x86_64                                                              3.40-5.el7                                                                       base                                                                  82 k
 perl-Pod-Escapes                                                                    noarch                                                              1:1.04-295.el7                                                                   base                                                                  51 k
 perl-Pod-Perldoc                                                                    noarch                                                              3.20-4.el7                                                                       base                                                                  87 k
 perl-Pod-Simple                                                                     noarch                                                              1:3.28-4.el7                                                                     base                                                                 216 k
 perl-Pod-Usage                                                                      noarch                                                              1.63-3.el7                                                                       base                                                                  27 k
 perl-Scalar-List-Utils                                                              x86_64                                                              1.27-248.el7                                                                     base                                                                  36 k
 perl-Socket                                                                         x86_64                                                              2.010-5.el7                                                                      base                                                                  49 k
 perl-Storable                                                                       x86_64                                                              2.45-3.el7                                                                       base                                                                  77 k
 perl-Text-ParseWords                                                                noarch                                                              3.29-4.el7                                                                       base                                                                  14 k
 perl-Time-HiRes                                                                     x86_64                                                              4:1.9725-3.el7                                                                   base                                                                  45 k
 perl-Time-Local                                                                     noarch                                                              1.2300-2.el7                                                                     base                                                                  24 k
 perl-constant                                                                       noarch                                                              1.27-2.el7                                                                       base                                                                  19 k
 perl-libs                                                                           x86_64                                                              4:5.16.3-295.el7                                                                 base                                                                 689 k
 perl-macros                                                                         x86_64                                                              4:5.16.3-295.el7                                                                 base                                                                  44 k
 perl-parent                                                                         noarch                                                              1:0.225-244.el7                                                                  base                                                                  12 k
 perl-podlators                                                                      noarch                                                              2.5.1-3.el7                                                                      base                                                                 112 k
 perl-threads                                                                        x86_64                                                              1.87-4.el7                                                                       base                                                                  49 k
 perl-threads-shared                                                                 x86_64                                                              1.43-6.el7                                                                       base                                                                  39 k
 pg_qualstats12                                                                      x86_64                                                              2.0.1-1.rhel7                                                                    pgdg12                                                                60 k
 pg_stat_kcache12                                                                    x86_64                                                              2.1.1-1.rhel7.2                                                                  pgdg12                                                                32 k
 postgresql12                                                                        x86_64                                                              12.3-1PGDG.rhel7                                                                 pgdg12                                                               1.6 M
 postgresql12-contrib                                                                x86_64                                                              12.3-1PGDG.rhel7                                                                 pgdg12                                                               608 k
 postgresql12-libs                                                                   x86_64                                                              12.3-1PGDG.rhel7                                                                 pgdg12                                                               368 k
 postgresql12-server                                                                 x86_64                                                              12.3-1PGDG.rhel7                                                                 pgdg12                                                               5.0 M
 systemd-sysv                                                                        x86_64                                                              219-73.el7_8.6                                                                   updates                                                               94 k

Transaction Summary
=====================================================================================================================================================================================================================================================================================================================
Install  1 Package (+38 Dependent packages)
[...]

I'm not a big RHEL/centos user, so I'm not sure what's wrong with your setup but I'm assuming that the problem is on your side.

guruguruguru commented 4 years ago

Would you please do a

yum info powa_12

Maybe I am just missing a repo

rjuju commented 4 years ago

sure:

# yum info powa_12
Loaded plugins: fastestmirror, ovl
Loading mirror speeds from cached hostfile
 * base: centos.mirror.ate.info
 * extras: mirror.hostup.org
 * updates: centos.mirror.ate.info
Available Packages
Name        : powa_12
Arch        : x86_64
Version     : 4.0.1
Release     : 1.rhel7
Size        : 52 k
Repo        : pgdg12/7/x86_64
[...]
guruguruguru commented 4 years ago

@rjuju Thanks: Okay I just saw we have a versionlock on powa_12 in version 4.* as there are broken dependencies with powa_12-web:

root@qp-dschwan01-a:/etc# yum install powa_12-web
Geladene Plugins: fastestmirror, needrestart, versionlock
Loading mirror speeds from cached hostfile
Excluding 1 update due to versionlock (use "yum versionlock status" to show it)
Abhängigkeiten werden aufgelöst
--> Transaktionsprüfung wird ausgeführt
---> Paket powa_12-web.x86_64 0:4.0.1-1.rhel7 markiert, um installiert zu werden
--> Abhängigkeit python(abi) = 3.6 wird für Paket powa_12-web-4.0.1-1.rhel7.x86_64 verarbeitet
--> Abhängigkeit python3-tornado >= 2.0 wird für Paket powa_12-web-4.0.1-1.rhel7.x86_64 verarbeitet
--> Abhängigkeit python3-sqlalchemy wird für Paket powa_12-web-4.0.1-1.rhel7.x86_64 verarbeitet
--> Abhängigkeit python3-psycopg2 wird für Paket powa_12-web-4.0.1-1.rhel7.x86_64 verarbeitet
--> Abhängigkeit /usr/bin/python3 wird für Paket powa_12-web-4.0.1-1.rhel7.x86_64 verarbeitet
--> Transaktionsprüfung wird ausgeführt
---> Paket powa_12-web.x86_64 0:4.0.1-1.rhel7 markiert, um installiert zu werden
--> Abhängigkeit python3-tornado >= 2.0 wird für Paket powa_12-web-4.0.1-1.rhel7.x86_64 verarbeitet
--> Abhängigkeit python3-sqlalchemy wird für Paket powa_12-web-4.0.1-1.rhel7.x86_64 verarbeitet
---> Paket python3.x86_64 0:3.6.8-13.el7 markiert, um installiert zu werden
--> Abhängigkeit python3-libs(x86-64) = 3.6.8-13.el7 wird für Paket python3-3.6.8-13.el7.x86_64 verarbeitet
--> Abhängigkeit python3-setuptools wird für Paket python3-3.6.8-13.el7.x86_64 verarbeitet
--> Abhängigkeit python3-pip wird für Paket python3-3.6.8-13.el7.x86_64 verarbeitet
--> Abhängigkeit libpython3.6m.so.1.0()(64bit) wird für Paket python3-3.6.8-13.el7.x86_64 verarbeitet
---> Paket python3-psycopg2.x86_64 0:2.8.5-2.rhel7 markiert, um installiert zu werden
--> Transaktionsprüfung wird ausgeführt
---> Paket powa_12-web.x86_64 0:4.0.1-1.rhel7 markiert, um installiert zu werden
--> Abhängigkeit python3-tornado >= 2.0 wird für Paket powa_12-web-4.0.1-1.rhel7.x86_64 verarbeitet
--> Abhängigkeit python3-sqlalchemy wird für Paket powa_12-web-4.0.1-1.rhel7.x86_64 verarbeitet
---> Paket python3-libs.x86_64 0:3.6.8-13.el7 markiert, um installiert zu werden
---> Paket python3-pip.noarch 0:9.0.3-7.el7_7 markiert, um installiert zu werden
---> Paket python3-setuptools.noarch 0:39.2.0-10.el7 markiert, um installiert zu werden
--> Abhängigkeitsauflösung beendet
Fehler: Paket: powa_12-web-4.0.1-1.rhel7.x86_64 (pgdg12)
            Benötigt: python3-tornado >= 2.0
Fehler: Paket: powa_12-web-4.0.1-1.rhel7.x86_64 (pgdg12)
            Benötigt: python3-sqlalchemy
 Sie können versuchen, mit --skip-broken das Problem zu umgehen.
 Sie könnten Folgendes versuchen: rpm -Va --nofiles --nodigest

Can you test this as well?

Thanks for your support!

guruguruguru commented 4 years ago

Oh and there is a package python-sqlalchemy.x86_64, so is it possible that just the dep is wrong?

There also is a package python36-tornado.x86_64 and python36-sqlalchemy.x86_64

Seems we are in dependency hell :-(

rjuju commented 4 years ago

I have the same behavior for powa-12_web:

# yum install powa_12-web
Loaded plugins: fastestmirror, ovl
Loading mirror speeds from cached hostfile
 * base: centos.mirror.ate.info
 * epel: mirror.de.leaseweb.net
 * extras: mirror.hostup.org
 * updates: centos.mirror.ate.info
Resolving Dependencies
--> Running transaction check
---> Package powa_12-web.x86_64 0:4.0.1-1.rhel7 will be installed
--> Processing Dependency: python(abi) = 3.6 for package: powa_12-web-4.0.1-1.rhel7.x86_64
--> Processing Dependency: python3-tornado >= 2.0 for package: powa_12-web-4.0.1-1.rhel7.x86_64
--> Processing Dependency: python3-sqlalchemy for package: powa_12-web-4.0.1-1.rhel7.x86_64
--> Processing Dependency: python3-psycopg2 for package: powa_12-web-4.0.1-1.rhel7.x86_64
--> Processing Dependency: /usr/bin/python3 for package: powa_12-web-4.0.1-1.rhel7.x86_64
--> Running transaction check
---> Package powa_12-web.x86_64 0:4.0.1-1.rhel7 will be installed
--> Processing Dependency: python3-tornado >= 2.0 for package: powa_12-web-4.0.1-1.rhel7.x86_64
--> Processing Dependency: python3-sqlalchemy for package: powa_12-web-4.0.1-1.rhel7.x86_64
---> Package python3.x86_64 0:3.6.8-13.el7 will be installed
--> Processing Dependency: python3-libs(x86-64) = 3.6.8-13.el7 for package: python3-3.6.8-13.el7.x86_64
--> Processing Dependency: python3-setuptools for package: python3-3.6.8-13.el7.x86_64
--> Processing Dependency: python3-pip for package: python3-3.6.8-13.el7.x86_64
--> Processing Dependency: libpython3.6m.so.1.0()(64bit) for package: python3-3.6.8-13.el7.x86_64
---> Package python3-psycopg2.x86_64 0:2.8.5-2.rhel7 will be installed
--> Processing Dependency: postgresql-libs for package: python3-psycopg2-2.8.5-2.rhel7.x86_64
--> Processing Dependency: libpq.so.5()(64bit) for package: python3-psycopg2-2.8.5-2.rhel7.x86_64
--> Running transaction check
---> Package postgresql-libs.x86_64 0:9.2.24-4.el7_8 will be installed
---> Package powa_12-web.x86_64 0:4.0.1-1.rhel7 will be installed
--> Processing Dependency: python3-tornado >= 2.0 for package: powa_12-web-4.0.1-1.rhel7.x86_64
--> Processing Dependency: python3-sqlalchemy for package: powa_12-web-4.0.1-1.rhel7.x86_64
---> Package python3-libs.x86_64 0:3.6.8-13.el7 will be installed
--> Processing Dependency: libtirpc.so.1()(64bit) for package: python3-libs-3.6.8-13.el7.x86_64
---> Package python3-pip.noarch 0:9.0.3-7.el7_7 will be installed
---> Package python3-setuptools.noarch 0:39.2.0-10.el7 will be installed
--> Running transaction check
---> Package libtirpc.x86_64 0:0.2.4-0.16.el7 will be installed
---> Package powa_12-web.x86_64 0:4.0.1-1.rhel7 will be installed
--> Processing Dependency: python3-tornado >= 2.0 for package: powa_12-web-4.0.1-1.rhel7.x86_64
--> Processing Dependency: python3-sqlalchemy for package: powa_12-web-4.0.1-1.rhel7.x86_64
--> Finished Dependency Resolution
Error: Package: powa_12-web-4.0.1-1.rhel7.x86_64 (pgdg12)
           Requires: python3-tornado >= 2.0
Error: Package: powa_12-web-4.0.1-1.rhel7.x86_64 (pgdg12)
           Requires: python3-sqlalchemy
 You could try using --skip-broken to work around the problem
 You could try running: rpm -Va --nofiles --nodigest

I also installed epel, but still no luck. I agree, apparently there's no python3- packages, but only python36 and python34 too for sqlalchemy (except the -doc package that exist in python3). I'm not sure why that's happening, as far as I know there should be at least a metapackage for python3- that provides the dependency for a default python3.X version.

As I said, I'm really not familiar with RHEL/centos so I don't know when or why it happened.

@devrimgunduz do you have any clue on this situation?

r4tt4 commented 4 years ago

Yep,

That's only a dependency issue. I corrected the Package powa_12-web-4.0.1-1.rhel7.x86_64.rpm just a few minutes ago --> only local and for me ;). The fix is really simple. Just change the "REUQIRENAME" from python3- to python36- and it's working w/o any problems.

Maybe this issue with wrong dependencies under RHEL7 is in other packages, too. Seems the packager should take a look at this.

Regards R!

rjuju commented 4 years ago

Thanks for confirming @r4tt4 !

devrimgunduz commented 4 years ago

Hi,

Thanks for the report . I'll take a look after releasing v13 beta1 RPMs.

rjuju commented 4 years ago

Thanks a lot!

guruguruguru commented 4 years ago

@devrimgunduz any news here? can we support you in any way?

devrimgunduz commented 4 years ago

So, I cannot reproduce on CentOS 7.6+. Looks like you need to update the OS.

vjt commented 4 years ago

So, I cannot reproduce on CentOS 7.6+. Looks like you need to update the OS.

Hi, I believe there is something else at play here. I am on CentOS 7.7 with EPEL and PGDG and I have this exact issue.

NAME="CentOS Linux"
VERSION="7 (Core)"
ID="centos"
ID_LIKE="rhel fedora"
VERSION_ID="7"
PRETTY_NAME="CentOS Linux 7 (Core)"
ANSI_COLOR="0;31"
CPE_NAME="cpe:/o:centos:centos:7"
HOME_URL="https://www.centos.org/"
BUG_REPORT_URL="https://bugs.centos.org/"

CENTOS_MANTISBT_PROJECT="CentOS-7"
CENTOS_MANTISBT_PROJECT_VERSION="7"
REDHAT_SUPPORT_PRODUCT="centos"
REDHAT_SUPPORT_PRODUCT_VERSION="7"
# yum info powa_12-web
Loaded plugins: fastestmirror, versionlock
Loading mirror speeds from cached hostfile
Available Packages
Name        : powa_12-web
Arch        : x86_64
Version     : 4.0.1
Release     : 1.rhel7
Size        : 608 k
Repo        : pgdg-12/7/x86_64
Summary     : The user interface of powa
URL         : http://dalibo.github.io/powa/
License     : BSD
Description : This is the user interface of POWA.
# yum install powa_12-web
Loaded plugins: fastestmirror, versionlock
Loading mirror speeds from cached hostfile
Excluding 5 updates due to versionlock (use "yum versionlock status" to show them)
Resolving Dependencies
--> Running transaction check
---> Package powa_12-web.x86_64 0:4.0.1-1.rhel7 will be installed
--> Processing Dependency: python(abi) = 3.6 for package: powa_12-web-4.0.1-1.rhel7.x86_64
--> Processing Dependency: python3-tornado >= 2.0 for package: powa_12-web-4.0.1-1.rhel7.x86_64
--> Processing Dependency: python3-sqlalchemy for package: powa_12-web-4.0.1-1.rhel7.x86_64
--> Processing Dependency: python3-psycopg2 for package: powa_12-web-4.0.1-1.rhel7.x86_64
--> Processing Dependency: /usr/bin/python3 for package: powa_12-web-4.0.1-1.rhel7.x86_64
--> Running transaction check
---> Package powa_12-web.x86_64 0:4.0.1-1.rhel7 will be installed
--> Processing Dependency: python3-tornado >= 2.0 for package: powa_12-web-4.0.1-1.rhel7.x86_64
--> Processing Dependency: python3-sqlalchemy for package: powa_12-web-4.0.1-1.rhel7.x86_64
---> Package python3.x86_64 0:3.6.8-13.el7 will be installed
--> Processing Dependency: python3-libs(x86-64) = 3.6.8-13.el7 for package: python3-3.6.8-13.el7.x86_64
--> Processing Dependency: python3-setuptools for package: python3-3.6.8-13.el7.x86_64
--> Processing Dependency: python3-pip for package: python3-3.6.8-13.el7.x86_64
--> Processing Dependency: libpython3.6m.so.1.0()(64bit) for package: python3-3.6.8-13.el7.x86_64
---> Package python3-psycopg2.x86_64 0:2.8.5-2.rhel7 will be installed
--> Running transaction check
---> Package powa_12-web.x86_64 0:4.0.1-1.rhel7 will be installed
--> Processing Dependency: python3-tornado >= 2.0 for package: powa_12-web-4.0.1-1.rhel7.x86_64
--> Processing Dependency: python3-sqlalchemy for package: powa_12-web-4.0.1-1.rhel7.x86_64
---> Package python3-libs.x86_64 0:3.6.8-13.el7 will be installed
---> Package python3-pip.noarch 0:9.0.3-7.el7_7 will be installed
---> Package python3-setuptools.noarch 0:39.2.0-10.el7 will be installed
--> Finished Dependency Resolution
Error: Package: powa_12-web-4.0.1-1.rhel7.x86_64 (pgdg-12)
           Requires: python3-sqlalchemy
Error: Package: powa_12-web-4.0.1-1.rhel7.x86_64 (pgdg-12)
           Requires: python3-tornado >= 2.0
 You could try using --skip-broken to work around the problem
 You could try running: rpm -Va --nofiles --nodigest
# yum deplist powa_12-web
Loaded plugins: fastestmirror, versionlock
Loading mirror speeds from cached hostfile
Excluding 5 updates due to versionlock (use "yum versionlock status" to show them)
package: powa_12-web.x86_64 4.0.1-1.rhel7
  dependency: /usr/bin/python3
   provider: python3.x86_64 3.6.8-13.el7
   provider: python3.i686 3.6.8-13.el7
  dependency: python(abi) = 3.6
   provider: python3.x86_64 3.6.8-13.el7
   provider: python3.i686 3.6.8-13.el7
  dependency: python3-psycopg2
   provider: python3-psycopg2.x86_64 2.8.5-2.rhel7
  dependency: python3-sqlalchemy
   Unsatisfied dependency
  dependency: python3-tornado >= 2.0
   Unsatisfied dependency
# yum info python36-sqlalchemy
Loaded plugins: fastestmirror, versionlock
Loading mirror speeds from cached hostfile
Excluding 5 updates due to versionlock (use "yum versionlock status" to show them)
Available Packages
Name        : python36-sqlalchemy
Arch        : x86_64
Version     : 1.1.3
Release     : 3.el7
Size        : 1.6 M
Repo        : epel/7/x86_64
Summary     : Modular and flexible ORM library for python
URL         : http://www.sqlalchemy.org/
License     : MIT
Description : SQLAlchemy is an Object Relational Mappper (ORM) that provides a flexible,
            : high-level interface to SQL databases.
# yum info python36-tornado
Loaded plugins: fastestmirror, versionlock
Loading mirror speeds from cached hostfile
Excluding 5 updates due to versionlock (use "yum versionlock status" to show them)
Available Packages
Name        : python36-tornado
Arch        : x86_64
Version     : 4.4.2
Release     : 2.el7
Size        : 698 k
Repo        : epel/7/x86_64
Summary     : Scalable, non-blocking web server and tools
URL         : http://www.tornadoweb.org
License     : ASL 2.0
Description : Tornado is an open source version of the scalable, non-blocking web
            : server and tools.

Thank you,

guruguruguru commented 4 years ago

We are on OS: CentOS Linux release 7.8.2003 (Core)

stelb commented 4 years ago

cat /etc/centos-release

CentOS Linux release 7.8.2003 (Core)

repoquery --requires powa_12-web

/usr/bin/python3 python(abi) = 3.6 python3-psycopg2 python3-sqlalchemy python3-tornado >= 2.0

repoquery --provides python3-tornado

# repoquery --provides python36-tornado Failed to set locale, defaulting to C python36-tornado = 4.4.2-2.el7 python36-tornado(x86-64) = 4.4.2-2.el7 # yum repolist base/7/x86_64 CentOS-7 - Base 10070 epel/x86_64 Extra Packages for Enterprise Linux 7 - x86_64 13300 extras/7/x86_64 CentOS-7 - Extras 397 pgdg-common/7/x86_64 PostgreSQL common RPMs for RHEL/CentOS 7 - x86_64 297 pgdg10/7/x86_64 PostgreSQL 10 for RHEL/CentOS 7 - x86_64 638 pgdg11/7/x86_64 PostgreSQL 11 for RHEL/CentOS 7 - x86_64 635 pgdg12/7/x86_64 PostgreSQL 12 for RHEL/CentOS 7 - x86_64 329 pgdg95/7/x86_64 PostgreSQL 9.5 for RHEL/CentOS 7 - x86_64 580 pgdg96/7/x86_64 PostgreSQL 9.6 for RHEL/CentOS 7 - x86_64 615 updates/7/x86_64 CentOS-7 - Updates 671 so there is python3-tornado missing, while for otheres there are 3 and 36 variants # repoquery --provides python3-idle application() application(idle3.desktop) idle3 = 3.6.8-13.el7 mimehandler(text/x-python) **python3-idle = 3.6.8-13.el7** python3-idle(x86-32) = 3.6.8-13.el7 python3-tools = 3.6.8-13.el7 python3-tools(x86-32) = 3.6.8-13.el7 python36-idle = 3.6.8-13.el7 python36-idle(x86-32) = 3.6.8-13.el7 application() application(idle3.desktop) idle3 = 3.6.8-13.el7 mimehandler(text/x-python) python3-idle = 3.6.8-13.el7 python3-idle(x86-64) = 3.6.8-13.el7 python3-tools = 3.6.8-13.el7 python3-tools(x86-64) = 3.6.8-13.el7 **python36-idle = 3.6.8-13.el7** python36-idle(x86-64) = 3.6.8-13.el7
stelb commented 4 years ago

it seems that python3-tornado exists only for epel 8 https://rpmfind.net/linux/rpm2html/search.php?query=python3-tornado

r4tt4 commented 4 years ago

Okay, some more details about my simple patch also described here, and I just diffed the INFO/REQUIRES in the packages for RHEL8 and RHEL7 (again).

RHEL8: powa_12-web-4.0.1-1.rhel8.x86_64.rpm /usr/bin/python3 python(abi) = 3.6 python3-psycopg2 python3-sqlalchemy python3-tornado >= 2.0 rpmlib(CompressedFileNames) <= 3.0.4-1 rpmlib(FileDigests) <= 4.6.0-1 rpmlib(PartialHardlinkSets) <= 4.0.4-1 rpmlib(PayloadFilesHavePrefix) <= 4.0-1 rpmlib(PayloadIsXz) <= 5.2-1

RHEL7: powa_12-web-4.0.1-1.rhel7.x86_64.rpm

/usr/bin/python3 python(abi) = 3.6 python3-psycopg2 python3-sqlalchemy python3-tornado >= 2.0 rpmlib(CompressedFileNames) <= 3.0.4-1 rpmlib(FileDigests) <= 4.6.0-1 rpmlib(PayloadFilesHavePrefix) <= 4.0-1 rpmlib(PayloadIsXz) <= 5.2-1

The requirements for depending packages looks pretty much the same, so I think this file was not correctly edited to work with RHEL7.

My patched version got the following INFO/REQUIRES and then it is working w/o any problems: /usr/bin/python3 python(abi) = 3.6 python3-psycopg2 python36-sqlalchemy python36-tornado >= 2.0 rpmlib(FileDigests) <= 4.6.0-1 rpmlib(PayloadFilesHavePrefix) <= 4.0-1 rpmlib(CompressedFileNames) <= 3.0.4-1 rpmlib(PayloadIsXz) <= 5.2-1

I also looked at the EPEL Reposerver. I don't see the clue why it should work with an older CentOS Build, because the packages are generic use for any 7.x Version and only available as python-36:

python36-sqlalchemy-1.1.3-3.el7.x86_64.rpm python36-tornado-4.4.2-2.el7.x86_64.rpm

Did not found Packages with only python3-sqlalchemy and python3-tornado anywhere for RHEL7.

Regards R!

devrimgunduz commented 4 years ago

I see the issue now. Will fix.

devrimgunduz commented 4 years ago

Pushed 4.0.1-2 to repo. They will sync in an hour.

guruguruguru commented 4 years ago

@devrimgunduz thanks a lot, works now!

vjt commented 4 years ago

I also confirm the issue is solved. Thank you @devrimgunduz! 👏

devrimgunduz commented 4 years ago

yw, and sorry for the delay.

rjuju commented 4 years ago

Thanks a lot everyone!