powa-team/powa

powa packages missing from repos

guruguruguru opened this issue · 25 comments

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

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?

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

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.

Would you please do a

yum info powa_12

Maybe I am just missing a repo

rjuju commented

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
[...]

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

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

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

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

Thanks for confirming @r4tt4 !

Hi,

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

rjuju commented

Thanks a lot!

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

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

vjt commented

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,

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

stelb commented

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

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

r4tt4 commented

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!

I see the issue now. Will fix.

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

@devrimgunduz thanks a lot, works now!

vjt commented

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

yw, and sorry for the delay.

rjuju commented

Thanks a lot everyone!