ovirt-engine ui not showing up/inaccessible

Hi, our office had power outage for more than an hour and continues fluctuations, so i decided to pull the plug after 2nd fluctuation and wait for the power to become stable. After the power became stable, I decided to turn the ovirt-engine up 1st, after booting up. I tried accessing my engine but the webui is not accessible, then i looked at the /var/log/ovirt-engine/engine.log and saw this error: 2016-04-15 06:34:56,265 ERROR [org.ovirt.engine.core.bll.Backend] (MSC service thread 1-28) Error in getting DB connection. The database is inaccessible. Original exception is: DataAccessResourceFailureException: Error retreiving database metadata; nested exception is org.springframework.jdbc.support.MetaDataAccessException: Could not get Connection for extracting meta data; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/ENGINEDataSource Can anyone help me out? I need in that environment up for the final stage of my testing. regards, Gene

On Friday, April 15, 2016 10:12:44 AM Gene Fontanilla wrote:
Hi,
our office had power outage for more than an hour and continues fluctuations, so i decided to pull the plug after 2nd fluctuation and wait for the power to become stable.
After the power became stable, I decided to turn the ovirt-engine up 1st, after booting up. I tried accessing my engine but the webui is not accessible, then i looked at the /var/log/ovirt-engine/engine.log
and saw this error:
2016-04-15 06:34:56,265 ERROR [org.ovirt.engine.core.bll.Backend] (MSC service thread 1-28) Error in getting DB connection. The database is inaccessible. Original exception is: DataAccessResourceFailureException: Error retreiving database metadata; nested exception is org.springframework.jdbc.support.MetaDataAccessException: Could not get Connection for extracting meta data; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/ENGINEDataSource
Can anyone help me out? I need in that environment up for the final stage of my testing.
regards, Gene
Sounds like postgresql isn't starting for some reason. Maybe check the status of that and manually start it if it is not up.

Thanks for the tip! got it! there was a pid file existing and was restraining the postgre to start. thank you! On Sat, Apr 16, 2016 at 3:00 AM, Alexander Wels <awels@redhat.com> wrote:
On Friday, April 15, 2016 10:12:44 AM Gene Fontanilla wrote:
Hi,
our office had power outage for more than an hour and continues fluctuations, so i decided to pull the plug after 2nd fluctuation and wait for the power to become stable.
After the power became stable, I decided to turn the ovirt-engine up 1st, after booting up. I tried accessing my engine but the webui is not accessible, then i looked at the /var/log/ovirt-engine/engine.log
and saw this error:
2016-04-15 06:34:56,265 ERROR [org.ovirt.engine.core.bll.Backend] (MSC service thread 1-28) Error in getting DB connection. The database is inaccessible. Original exception is: DataAccessResourceFailureException: Error retreiving database metadata; nested exception is org.springframework.jdbc.support.MetaDataAccessException: Could not get Connection for extracting meta data; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/ENGINEDataSource
Can anyone help me out? I need in that environment up for the final stage of my testing.
regards, Gene
Sounds like postgresql isn't starting for some reason. Maybe check the status of that and manually start it if it is not up.
participants (2)
-
Alexander Wels
-
Gene Fontanilla