daotest job

[Eyal Edri]

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