Re: daotest job

From: "Eli Mesika" <emesika(a)redhat.com&gt; To: "Ohad Basan" <obasan(a)redhat.com&gt; Cc: "infra" <infra(a)ovirt.org&gt;, "Yair Zaslavsky" <yzaslavs(a)redhat.com&gt; Sent: Monday, December 9, 2013 4:11:48 PM Subject: Re: daotest job ----- Original Message ----- > 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? 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 >