On 01/28, Sahina Bose wrote: > > On 01/28/2015 02:58 PM, Sahina Bose wrote: > > > >On 01/28/2015 01:35 PM, Barak Korren wrote: > >>Sandro, > >>I remember vaguely that you have to use the 'postgres' user when > >>connecting. > >>I don't see user information in the URL, maybe it needs to be: > >> > >>"jdbc:postgresql://postgres@localhost/engine_dao_tests" > >> > >>Or maybe: > >> > >>"jdbc:postgresql://localhost/engine_dao_tests;user=postgreas" > >> > >>I'm not 100% sure about that, as my jdbc-foo is not that strong... > > > >ovirt-db-scheduler-test.properties does have a username and password > >property set to "engine" now. Do the *DaoTest use postgres user on Jenkins > >server? > > > Ok, I think I know why this failed. Each job has a different database which > is passed to the maven job as "-D > engine.db.url=jdbc:postgresql://localhost/${DB_NAME}" > > Submitted patch to read db parameters passed to fix this test error - > http://gerrit.ovirt.org/37337
Thanks! Just started looking at the issue and saw it. Just fyi the tests use postgres user (system user) just user to make sure that the database and the engine role exists, from there they use engine user (jenkins system user). > > > > >thanks! > >sahina > > > > > >> > >>Barak. > >> > >>----- Original Message ----- > >>>From: "Sandro Bonazzola" <sbona...@redhat.com> > >>>To: "Sahina Bose" <sab...@redhat.com>, "infra" <in...@ovirt.org>, > >>>devel@ovirt.org, "Barak Korren" > >>><bkor...@redhat.com>, "David Caro" <dcaro...@redhat.com> > >>>Sent: Wednesday, January 28, 2015 9:41:23 AM > >>>Subject: Re: [ovirt-devel] DAO test is failing on master > >>> > >>>Il 28/01/2015 07:59, Sahina Bose ha scritto: > >>>>Sandro, > >>>> > >>>>Could be devel error. This test looks for database settings as per > >>>>backend/manager/modules/scheduler/src/test/resources/ovirt-db-scheduler-test.properties > >>>> > >>>> > >>>>The Data source URL is specified as > >>>>"jdbc:postgresql://localhost/engine_dao_tests". Does this need to be > >>>>changed for Jenkins jobs? > >>>David? Barak? > >>> > >>> > >>>>On 01/27/2015 09:29 PM, Sandro Bonazzola wrote: > >>>>>http://jenkins.ovirt.org/job/ovirt-engine_master_dao-unit-tests_merged/10022/console > >>>>> > >>>>> > >>>>>15:50:12 Failed tests: > >>>>>15:50:12 > >>>>>scheduleARecurringJob(org.ovirt.engine.core.utils.timer.DBSchedulerUtilQuartzImplTest): > >>>>> > >>>>>Unexpected exception occured -Failed to obtain DB > >>>>>connection from data source 'EngineDS': java.sql.SQLException: > >>>>>Connections > >>>>>could not be acquired from the underlying database! > >>>>>15:50:12 > >>>>>scheduleAJob(org.ovirt.engine.core.utils.timer.DBSchedulerUtilQuartzImplTest): > >>>>> > >>>>>Unexpected exception occured -Failed to obtain DB connection > >>>>>from data source 'EngineDS': java.sql.SQLException: Connections > >>>>>could not > >>>>>be acquired from the underlying database! > >>>>> > >>>>>Not sure if it's infra or devel issue. > >>>>> > >>> > >>>-- > >>>Sandro Bonazzola > >>>Better technology. Faster innovation. Powered by community > >>>collaboration. > >>>See how it works at redhat.com > >>> > > > >_______________________________________________ > >Devel mailing list > >Devel@ovirt.org > >http://lists.ovirt.org/mailman/listinfo/devel > > _______________________________________________ > Infra mailing list > in...@ovirt.org > http://lists.ovirt.org/mailman/listinfo/infra -- David Caro Red Hat S.L. Continuous Integration Engineer - EMEA ENG Virtualization R&D Tel.: +420 532 294 605 Email: dc...@redhat.com Web: www.redhat.com RHT Global #: 82-62605
pgp80X1tgoWPk.pgp
Description: PGP signature
_______________________________________________ Devel mailing list Devel@ovirt.org http://lists.ovirt.org/mailman/listinfo/devel