Select results after upgrade.

[root@engine ~]# sudo -u postgres scl enable rh-postgresql95 -- psql -d engine -c "SELECT SUM(pg_database_size(datname)) As dbms_size FROM pg_database"
could not change directory to "/root": Access denied
 dbms_size 
-----------
 389454161
(1 row)

[root@engine ~]# sudo -u postgres scl enable rh-postgresql10 -- psql -d engine -c "SELECT SUM(pg_database_size(datname)) As dbms_size FROM pg_database"
could not change directory to "/root»: Access denied
 dbms_size 
-----------
 389454161
(1 row)

[root@engine ~]# 


5 июня 2019 г., в 13:36, Simone Tiraboschi <stirabos@redhat.com> написал(а):

On Wed, Jun 5, 2019 at 11:44 AM Mail SET Inc. Group <mail@set-pro.net> wrote:

There is full log attached

Thanks,
we are trying to execute
 SELECT SUM(pg_database_size(datname)) As dbms_size FROM pg_database

but your postgres instance fails on that query.

Can you please try executing on the engine VM:
 sudo -u postgres scl enable rh-postgresql95 -- psql -d engine -c
"SELECT SUM(pg_database_size(datname)) As dbms_size FROM pg_database"

and if it fail share the output of:
 ls -lZ /var/opt/rh/rh-postgresql95/lib/pgsql/data/base/13699369/1259_fsm
(or the file where it fails on).

3 июня 2019 г., в 10:13, Simone Tiraboschi <stirabos@redhat.com> написал(а):

Hi
Can you please share the whole log file?

On Sun, Jun 2, 2019 at 8:43 PM <mail@set-pro.net> wrote:

Hello! Get problems with upgrade oVirt Hosted-Engine from 4.2.8 to 4.3.3. After installing http://resources.ovirt.org/pub/yum-repo/ovirt-release43.rpm on Engine VM i run yum update, then engine-setup and got this error:

             --== DATABASE CONFIGURATION ==--

[WARNING] This release requires PostgreSQL server 10.6 but the engine database is currently hosted on PostgreSQL server 9.5.14.
[ INFO  ] Verifying PostgreSQL SELinux file context rules
[ ERROR ] Failed to execute stage 'Environment customization': could not stat file "base/13699369/1259_fsm": Permission denied

[ INFO  ] Stage: Clean up
         Log file is located at /var/log/ovirt-engine/setup/ovirt-engine-setup-20190602110956-iqr6bc.log
[ INFO  ] Generating answer file '/var/lib/ovirt-engine/setup/answers/20190602111120-setup.conf'
[ INFO  ] Stage: Pre-termination
[ INFO  ] Stage: Termination
[ ERROR ] Execution of setup failed
But i don't find any solution how resolve this issue. Maybe i doing something wrong?
_______________________________________________
Users mailing list -- users@ovirt.org
To unsubscribe send an email to users-leave@ovirt.org
Privacy Statement: https://www.ovirt.org/site/privacy-policy/
oVirt Code of Conduct: https://www.ovirt.org/community/about/community-guidelines/
List Archives: https://lists.ovirt.org/archives/list/users@ovirt.org/message/QYAI3CP2IJMP45P4HCCX5ES7JFG3SG7U/



--
Simone Tiraboschi

He / Him / His

Principal Software Engineer

Red Hat

stirabos@redhat.com
@redhatjobs   redhatjobs @redhatjobs




-- 

Simone Tiraboschi

He / Him / His

Principal Software Engineer

Red Hat

stirabos@redhat.com

@redhatjobs   redhatjobs @redhatjobs