----- Original Message ----- > From: "Ohad Basan" <oba...@redhat.com> > To: "Eli Mesika" <emes...@redhat.com> > Cc: "infra" <infra@ovirt.org> > Sent: Monday, December 9, 2013 4:45:41 PM > Subject: Re: daotest job > > > > ----- Original Message ----- > > From: "Eli Mesika" <emes...@redhat.com> > > To: "Ohad Basan" <oba...@redhat.com> > > Cc: "infra" <infra@ovirt.org>, "Yair Zaslavsky" <yzasl...@redhat.com> > > Sent: Monday, December 9, 2013 4:11:48 PM > > Subject: Re: daotest job > > > > > > > > ----- Original Message ----- > > > From: "Ohad Basan" <oba...@redhat.com> > > > To: "infra" <infra@ovirt.org>, "Eli Mesika" <emes...@redhat.com>, "Yair > > > Zaslavsky" <yzasl...@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}
you can't just create 'engine' db name, this will fail if more than one job is running in parallel. that's the whole point in using a unique db name from job name and build name. any reason to change that? > > > > > > 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 > > > > can you plz elaborate? > the only thing it does is create the engine db > and runs create_schema.sh which is a part of the ovirt code. > I am not creating ovirt_engine_dao_unit_tests_5369 manually > > > > > > > > > > > > Thanks, > > > > > > Ohad > > > > > > _______________________________________________ > Infra mailing list > Infra@ovirt.org > http://lists.ovirt.org/mailman/listinfo/infra > _______________________________________________ Infra mailing list Infra@ovirt.org http://lists.ovirt.org/mailman/listinfo/infra