[ovirt-devel] DAO test is failing on master

[Sahina Bose]

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 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