Hi Martin, 
Thanks for your reply. 
I'm aware that there is some connectivity issue between  PostgreSQL and engine.

I've checked pg_logs but couldn't find the root cause of the problem. 
Please look into it, log file attached and suggest what to do.

Thanks & Regards,
Sameer Sardar


On Fri, Aug 9, 2019 at 3:21 PM Martin Perina <mperina@redhat.com> wrote:

On Thu, Aug 8, 2019 at 12:54 PM Sameer Sardar <sameersardar2410@gmail.com> wrote:

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@ovirt.org
To unsubscribe send an email to devel-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/devel@ovirt.org/message/CZZGTO25LKDYXVDDGM5IVQPH2L2PPE3M/

Martin Perina
Manager, Software Engineering
Red Hat Czech s.r.o.