daotest job

[Eli Mesika]

----- Original Message -----
> From: "Ohad Basan" <obasan at redhat.com>
> To: "infra" <infra at ovirt.org>, "Eli Mesika" <emesika at redhat.com>, "Yair Zaslavsky" <yzaslavs at redhat.com>
> Sent: Monday, December 9, 2013 4:03:49 PM
> Subject: daotest job
> 
> Hello
> 
> I have been working on updating the job
> http://jenkins.ovirt.org/job/ovirt_engine_dao_unit_tests/5369/consoleFull
> it used to run createdb.sh with user engine
> Now Eli instructed me to make the following change - create use engine and
> run create schema.
> 
> sudo -u postgres psql -d template1 -c 'create role engine;' || :
> sudo -u postgres psql -d template1 -c 'ALTER ROLE engine WITH login' || :
> sudo -u postgres dropdb engine || :
> sudo -u postgres psql -d template1 -c 'create database engine owner engine;'
> ./create_schema.sh -u engine -d engine
> #./create_db.sh -u postgres -d ${JOB_NAME}_${BUILD_NUMBER}
> 
> that will require changing the sudo permissions of the jenkins user
> http://gerrit.ovirt.org/#/c/22196/1
> 
> despite these changes this job is still failing
> rg.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 org.postgresql.util.PSQLException:
> FATAL: database "ovirt_engine_dao_unit_tests_5369" does not exist
> can anyone plz assist?

Please check the test database you are creating , it looks for ovirt_engine_dao_unit_tests_5369 and you are probably creating a db with other name 


> 
> 
> Thanks,
> 
> Ohad
>