[ovirt-devel] DAO test is failing on master

[David Caro]

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" <sbonazzo at redhat.com>
> >>>To: "Sahina Bose" <sabose at redhat.com>, "infra" <infra at ovirt.org>,
> >>>devel at ovirt.org, "Barak Korren"
> >>><bkorren at redhat.com>, "David Caro" <dcaroest at 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 at ovirt.org
> >http://lists.ovirt.org/mailman/listinfo/devel
> 
> _______________________________________________
> Infra mailing list
> Infra at 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: dcaro at redhat.com
Web: www.redhat.com
RHT Global #: 82-62605
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 473 bytes
Desc: not available
URL: <http://lists.ovirt.org/pipermail/devel/attachments/20150128/8a2382ab/attachment-0001.sig>