http://jenkins.ovirt.org/job/ovirt-engine_master_dao-unit-tests_merged/10... 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.

From: "Sandro Bonazzola" <sbonazzo(a)redhat.com&gt; To: "Sahina Bose" <sabose(a)redhat.com&gt;, "infra" <infra(a)ovirt.org&gt;, devel(a)ovirt.org, "Barak Korren" <bkorren(a)redhat.com&gt;, "David Caro" <dcaroest(a)redhat.com&gt; 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/10... >> >> 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

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?

thanks! sahina > > Barak. > > ----- Original Message ----- >> From: "Sandro Bonazzola" <sbonazzo(a)redhat.com&gt; >> To: "Sahina Bose" <sabose(a)redhat.com&gt;, "infra" <infra(a)ovirt.org&gt;, >> devel(a)ovirt.org, "Barak Korren" >> <bkorren(a)redhat.com&gt;, "David Caro" <dcaroest(a)redhat.com&gt; >> 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/10... >>>> >>>> >>>> 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(a)ovirt.org http://lists.ovirt.org/mailman/listinfo/devel

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! > sahina > > >> >> Barak. >> >> ----- Original Message ----- >>> From: "Sandro Bonazzola" <sbonazzo(a)redhat.com&gt; >>> To: "Sahina Bose" <sabose(a)redhat.com&gt;, "infra" <infra(a)ovirt.org&gt;, >>> devel(a)ovirt.org, "Barak Korren" >>> <bkorren(a)redhat.com&gt;, "David Caro" <dcaroest(a)redhat.com&gt; >>> 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/10... >>>>> >>>>> >>>>> 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(a)ovirt.org > http://lists.ovirt.org/mailman/listinfo/devel _______________________________________________ Devel mailing list Devel(a)ovirt.org http://lists.ovirt.org/mailman/listinfo/devel