Re: daotest job

From: "Ohad Basan" <obasan(a)redhat.com&gt; To: "infra" <infra(a)ovirt.org&gt;, "Eli Mesika" <emesika(a)redhat.com&gt;, "Yair Zaslavsky" <yzaslavs(a)redhat.com&gt; 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?

Thanks, Ohad