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?
Thanks,
Ohad