[ovirt-devel] DAO test is failing on master

[Yevgeny Zaspitsky]

On 28/01/15 11:51, 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
>
David,

The mentioned patch build fails on some non-related to the patch issue. 
Seems like the Jenkins environment isn't clean.
Could you look into it?

Thanks,
Yevgeny
>>
>> 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
>
> _______________________________________________
> Devel mailing list
> Devel at ovirt.org
> http://lists.ovirt.org/mailman/listinfo/devel