[Users] Unable to get managed connection for java:/ENGINEDataSource

[Juan Hernandez]

On 03/05/2013 05:24 PM, Dennis Böck wrote:
> Dear oVirt-Users,
>
> since I had a typo in my engine-setup I did a engine-cleanup, a reboot and started again.
> Unfortunately now the engine doesn't come up any more. Obviously there are problems accessing the database:
>
> 2013-03-05 17:13:08,078 ERROR [org.ovirt.engine.core.bll.Backend] (MSC service thread 1-32) 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
>
> I already tried:
> yum erase ovirt-engine
> yum earse postresql-server
> and installed it again, but it didn't help.
>
> Does anyone have an idea?
>
> Best regards and thanks in advance
> Dennis

In the /etc/sysconfig/ovirt-engine file you should have the details of 
the connection to the database, in particular you should have something 
like this:

   ENGINE_DB_URL=jdbc:postgresql://localhost:5432/engine

Are you using "localhost" as in this example? If that is the case then 
check that the database is listening in right address and port:

   # netstat --listen --tcp --numeric --program | grep postgres
   tcp        0      0 127.0.0.1:5432          0.0.0.0:* 
LISTEN      10424/postgres

Then also check that connection to the database is working:

   psql --host localhost --port 5432 --user engine --password engine
   Password for user engine:
   psql (9.2.3)
   Type "help" for help.

   engine=>

You may also run a simple query to check that the tables are there:

   engine=> select count(*) from vdc_options;
    count
   -------
      346
   (1 row)

Hopefully, if there is an error, the output of these commands will give 
you a hint.

-- 
Dirección Comercial: C/Jose Bardasano Baos, 9, Edif. Gorbea 3, planta 
3ºD, 28016 Madrid, Spain
Inscrita en el Reg. Mercantil de Madrid – C.I.F. B82657941 - Red Hat S.L.