[ovirt-devel] Re: Ovirt Manager - FATAL: the database system is in recovery mode

On Thu, Aug 8, 2019 at 12:54 PM Sameer Sardar <sameersardar2410(a)gmail.com&gt; wrote: > PACKAGE_NAME="ovirt-engine" > PACKAGE_VERSION="3.6.2.6" > PACKAGE_DISPLAY_VERSION="3.6.2.6-1.el6" > OPERATING SYSTEM="Centos 6.7" > > Its been running error-free for over 3 years now. Over the past few > weeks, The Ovirt manager application has been frequently losing connection > with its own database residing on the same server. It is throwing up errors > saying: “Caused by org.postgresql.util.PSQLException: FATAL: the database > system is in recovery mode”. The only means we have found to recover from > this is to hard reboot the server, after which it works fine for a couple > of days before throwing up these errors again. > Here are some logs : > > Caused by: org.postgresql.util.PSQLException: FATAL: the database system > is in recovery mode > This error means that engine cannot connect to PostgreSQL database and for all connections database returns "the database system is in recovery mode" error message. So please take a look at /var/lib/pgsql, there should be pg_log directory with more detailed logs ... at > org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:293) > at > org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:108) > at > org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66) > at > org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:125) > at > org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30) > at > org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:22) > at > org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:32) > at > org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24) > at org.postgresql.Driver.makeConnection(Driver.java:393) > at org.postgresql.Driver.connect(Driver.java:267) > at > org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createLocalManagedConnection(LocalManagedConnectionFactory.java:322) > _______________________________________________ > Devel mailing list -- devel(a)ovirt.org > To unsubscribe send an email to devel-leave(a)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/devel@ovirt.org/message/CZZGTO25LKD... > -- Martin Perina Manager, Software Engineering Red Hat Czech s.r.o.