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