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 <stira...@redhat.com> написал(а): > > On Wed, Jun 5, 2019 at 11:44 AM Mail SET Inc. Group <m...@set-pro.net > <mailto:m...@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 <stira...@redhat.com> написал(а): >> >> Hi >> Can you please share the whole log file? >> >> On Sun, Jun 2, 2019 at 8:43 PM <m...@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-le...@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 >> >> stira...@redhat.com >> @redhatjobs redhatjobs @redhatjobs >> >> > > > -- > > Simone Tiraboschi > > He / Him / His > > Principal Software Engineer > > Red Hat > > stira...@redhat.com <mailto:stira...@redhat.com> > > @redhatjobs redhatjobs @redhatjobs
_______________________________________________ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-le...@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/3T2TWVQWSHFRM64RRNCX2XPZAQU43O36/
