http://jenkins.ovirt.org/job/ovirt-engine_master_dao-unit-tests_merged/10022... 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
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? On 01/27/2015 09:29 PM, Sandro Bonazzola wrote:
http://jenkins.ovirt.org/job/ovirt-engine_master_dao-unit-tests_merged/10022...
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.
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...
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
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... Barak. ----- Original Message -----
From: "Sandro Bonazzola" <sbonazzo@redhat.com> To: "Sahina Bose" <sabose@redhat.com>, "infra" <infra@ovirt.org>, devel@ovirt.org, "Barak Korren" <bkorren@redhat.com>, "David Caro" <dcaroest@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...
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@redhat.com> To: "Sahina Bose" <sabose@redhat.com>, "infra" <infra@ovirt.org>, devel@ovirt.org, "Barak Korren" <bkorren@redhat.com>, "David Caro" <dcaroest@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...
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 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@redhat.com> To: "Sahina Bose" <sabose@redhat.com>, "infra" <infra@ovirt.org>, devel@ovirt.org, "Barak Korren" <bkorren@redhat.com>, "David Caro" <dcaroest@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...
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
--Uwl7UQhJk99r8jnw Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On 01/28, Sahina Bose wrote:
=20 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=3Dpostgreas"
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 Jenki=
ns
server? =20 =20 Ok, I think I know why this failed. Each job has a different database whi= ch is passed to the maven job as "-D engine.db.url=3Djdbc:postgresql://localhost/${DB_NAME}" =20 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 t= hat the database and the engine role exists, from there they use engine user (jenkins system user).
=20
thanks! sahina
Barak.
----- Original Message -----
From: "Sandro Bonazzola" <sbonazzo@redhat.com> To: "Sahina Bose" <sabose@redhat.com>, "infra" <infra@ovirt.org>, devel@ovirt.org, "Barak Korren" <bkorren@redhat.com>, "David Caro" <dcaroest@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-schedul=
er-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_merg= ed/10022/console
15:50:12 Failed tests: 15:50:12 scheduleARecurringJob(org.ovirt.engine.core.utils.timer.DBSchedulerU= tilQuartzImplTest):
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.DBSchedulerUtilQuartz= ImplTest):
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.
--=20 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 =20
Infra mailing list Infra@ovirt.org http://lists.ovirt.org/mailman/listinfo/infra
--=20 David Caro Red Hat S.L. Continuous Integration Engineer - EMEA ENG Virtualization R&D Tel.: +420 532 294 605 Email: dcaro@redhat.com Web: www.redhat.com RHT Global #: 82-62605 --Uwl7UQhJk99r8jnw Content-Type: application/pgp-signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQEcBAEBAgAGBQJUyLTuAAoJEEBxx+HSYmnDYkkIAIRdnO+VATyJv4umomYCYcMW zB2OjzFcs6A3w1CQe3hYdMVaBn4TGwgMdwl/wMulziNjpdgc7Tw7SFYeNVPyfVSh GnxANjAXKXEqORdHhEgXxHIUJxedyF84l8ZarjDTTkZAXbBWGAZId3yJbX7APZ1S gZ5VeoX0+1CtiWnWNvWbY62EF4c1l9qSE9h6VEy/IL4Nh/JbeaMqaNZ7revoA50H V3h4bQ/96qpjbO6tp9cqMglQNgxXgCI3UhtQaIhf+j1+slPSauDnWN/CboUuaLZl GHRvtFsNXVJwFibDrNsfAc5zx/xlc2jpPcJ05P5EM4pb6DC7v4EaByY4eGY5lU0= =h9Vr -----END PGP SIGNATURE----- --Uwl7UQhJk99r8jnw--
participants (4)
-
Barak Korren -
David Caro -
Sahina Bose -
Sandro Bonazzola