9:03 a.m.
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
9:11 a.m.
----- Original Message -----
From: "Ohad Basan" <obasan(a)redhat.com>
To: "infra" <infra(a)ovirt.org>, "Eli Mesika"
<emesika(a)redhat.com>, "Yair Zaslavsky" <yzaslavs(a)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}
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
9:45 a.m.
----- Original Message -----
From: "Eli Mesika" <emesika(a)redhat.com>
To: "Ohad Basan" <obasan(a)redhat.com>
Cc: "infra" <infra(a)ovirt.org>, "Yair Zaslavsky"
<yzaslavs(a)redhat.com>
Sent: Monday, December 9, 2013 4:11:48 PM
Subject: Re: daotest job
----- Original Message -----
> From: "Ohad Basan" <obasan(a)redhat.com>
> To: "infra" <infra(a)ovirt.org>, "Eli Mesika"
<emesika(a)redhat.com>, "Yair
> Zaslavsky" <yzaslavs(a)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}
>
> 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
>
3:51 p.m.
----- Original Message -----
From: "Ohad Basan" <obasan(a)redhat.com>
To: "Eli Mesika" <emesika(a)redhat.com>
Cc: "infra" <infra(a)ovirt.org>
Sent: Monday, December 9, 2013 4:45:41 PM
Subject: Re: daotest job
----- Original Message -----
> From: "Eli Mesika" <emesika(a)redhat.com>
> To: "Ohad Basan" <obasan(a)redhat.com>
> Cc: "infra" <infra(a)ovirt.org>, "Yair Zaslavsky"
<yzaslavs(a)redhat.com>
> Sent: Monday, December 9, 2013 4:11:48 PM
> Subject: Re: daotest job
>
>
>
> ----- Original Message -----
> > From: "Ohad Basan" <obasan(a)redhat.com>
> > To: "infra" <infra(a)ovirt.org>, "Eli Mesika"
<emesika(a)redhat.com>, "Yair
> > Zaslavsky" <yzaslavs(a)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(a)ovirt.org
http://lists.ovirt.org/mailman/listinfo/infra
4035
days inactive
4035
days old
3 comments
3 participants
participants (3)
-
Eli Mesika -
Eyal Edri -
Ohad Basan