[hibernate-dev] [Hibernate-JIRA] Created: (HHH-7187) envers tests fail on other DBs except the default H2

Strong Liu stliu at hibernate.org
Fri Mar 23 02:48:18 EDT 2012


org.hibernate.envers.test.EnversTestingJtaBootstrap appends that ";AUTOCOMMIT=OFF"

		dataSource.setUrl(configValues.get(Environment.URL).toString() + ";AUTOCOMMIT=OFF");
-------------------------
Best Regards,

Strong Liu <stliu at hibernate.org>
http://about.me/stliu/bio

On Mar 22, 2012, at 11:15 PM, Madhumita Sadhukhan wrote:

> Stacktrace:
> 
> 	... 60 more
> Caused by: java.sql.SQLException: Cannot get connection for URL jdbc:mysql://vmg02.mw.lab.eng.bos.redhat.com:3306/dballo01;AUTOCOMMIT=OFF : Access denied for user 'dballo01'@'%' to database 'dballo01;AUTOCOMMIT=OFF'
> 	at org.enhydra.jdbc.standard.StandardDataSource.getConnection(StandardDataSource.java:216)
> 	at org.hibernate.service.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:141)
> 	at org.hibernate.internal.AbstractSessionImpl$NonContextualJdbcConnectionAccess.obtainConnection(AbstractSessionImpl.java:278)
> 	at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection(LogicalConnectionImpl.java:297)
> 	... 88 more
> 
> 
> These tests fail in mysql51.
> There are several other test failures across other databases as well but due to hudson issues over past two days some of them have aborted abruptly.
> 
> Another common issue I see is:
> 
> Caused by: com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][10165][10036][4.12.55] Invalid database URL syntax: jdbc:db2://vmg06.mw.lab.eng.bos.redhat.com:50000/jbossqa;INIT=CREATE SCHEMA IF NOT EXISTS ENVERS_AUDIT. ERRORCODE=-4461, SQLSTATE=42815
> 	at com.ibm.db2.jcc.am.hd.a(hd.java:676)
> 
> 
> I have started a fresh run on all databases with a patch containing fixes in HHH-7185 after which I could investigate further.
> 
> Thanks and Regards,
> Madhumita Sadhukhan
> JBoss EAP QE Team
> Red Hat Brno
> 
> 
> 
> 
> ----- Original Message -----
> From: "Adam Warski" <adam at warski.org>
> To: "Strong Liu" <stliu at hibernate.org>
> Cc: "Madhumita Sadhukhan" <msadhukh at redhat.com>, "hibernate-dev at lists.jboss.org hibernate-dev" <hibernate-dev at lists.jboss.org>
> Sent: Thursday, March 22, 2012 3:48:01 PM
> Subject: Re: [Hibernate-JIRA] Created: (HHH-7187) envers tests fail on other DBs except the default H2
> 
> Hello,
> 
> I'd say all tests are supposed to work on all DBs, but they were written only with running on H2 in mind.
> But I guess only a fraction of the failing tests actually use EnversTestingJtaBootstrap?
> 
> What are the stacktraces? And what DBs do the tests fail on?
> 
> Adam
> 
> On Mar 19, 2012, at 11:24 AM, Strong Liu wrote:
> 
>> Hi Adam,
>> 
>> any comments?
>> -------------------------
>> Best Regards,
>> 
>> Strong Liu <stliu at hibernate.org>
>> http://about.me/stliu/bio
>> 
>> Begin forwarded message:
>> 
>>> From: "Strong Liu (JIRA)" <noreply at atlassian.com>
>>> Subject: [Hibernate-JIRA] Created: (HHH-7187) envers tests fail on other DBs except the default H2
>>> Date: March 20, 2012 2:23:50 AM GMT+08:00
>>> To: stliu at hibernate.org
>>> 
>>> envers tests fail on other DBs except the default H2
>>> ----------------------------------------------------
>>> 
>>>                Key: HHH-7187
>>>                URL: https://hibernate.onjira.com/browse/HHH-7187
>>>            Project: Hibernate ORM
>>>         Issue Type: Bug
>>>         Components: envers
>>>           Reporter: Strong Liu
>>>            Fix For: 4.1.2
>>> 
>>> 
>>> due to the change of HHH-7185, there are some failing tests:
>>> 
>>> {quote}
>>> All Failed Tests
>>> 
>>> Test Name   
>>> Duration   
>>> Age   
>>>>>> org.hibernate.envers.test.integration.jta.JtaExceptionListener.testTransactionRollback[0] 	0.016	1
>>>>>> org.hibernate.envers.test.integration.jta.JtaExceptionListener.testDataNotPersisted[0] 	0.084	1
>>>>>> org.hibernate.envers.test.integration.jta.JtaExceptionListener.testTransactionRollback[1] 	0.01	1
>>>>>> org.hibernate.envers.test.integration.jta.JtaExceptionListener.testDataNotPersisted[1] 	0.013	1
>>>>>> org.hibernate.envers.test.integration.manytomany.unidirectional.M2MIndexedListNotAuditedTarget.initData[0] 	0.097	1
>>>>>> org.hibernate.envers.test.integration.manytomany.unidirectional.M2MIndexedListNotAuditedTarget.testHistory1[0] 	0.0050	1
>>>>>> org.hibernate.envers.test.integration.manytomany.unidirectional.M2MIndexedListNotAuditedTarget.testHistory2[0] 	0.0010	1
>>>>>> org.hibernate.envers.test.integration.manytomany.unidirectional.M2MIndexedListNotAuditedTarget.testRevisionsCounts[0] 	0.0020	1
>>>>>> org.hibernate.envers.test.integration.manytomany.unidirectional.M2MIndexedListNotAuditedTarget.initData[1] 	0.115	1
>>>>>> org.hibernate.envers.test.integration.manytomany.unidirectional.M2MIndexedListNotAuditedTarget.testHistory1[1] 	0.0010	1
>>>>>> org.hibernate.envers.test.integration.manytomany.unidirectional.M2MIndexedListNotAuditedTarget.testHistory2[1] 	0.0010	1
>>>>>> org.hibernate.envers.test.integration.manytomany.unidirectional.M2MIndexedListNotAuditedTarget.testRevisionsCounts[1] 	0.0	1
>>>>>> org.hibernate.envers.test.integration.naming.BasicNaming.testHistoryOfId1[0] 	0.048	1
>>>>>> org.hibernate.envers.test.integration.naming.BasicNaming.testHistoryOfId2[0] 	0.029	1
>>>>>> org.hibernate.envers.test.integration.naming.BasicNaming.testRevisionsCounts[0] 	0.016	1
>>>>>> org.hibernate.envers.test.integration.naming.BasicNaming.testHistoryOfId1[1] 	0.041	1
>>>>>> org.hibernate.envers.test.integration.naming.BasicNaming.testHistoryOfId2[1] 	0.025	1
>>>>>> org.hibernate.envers.test.integration.naming.BasicNaming.testRevisionsCounts[1] 	0.03	1
>>>>>> org.hibernate.envers.test.integration.naming.EstonianTableAlias.testAuditChildTableAlias[0] 	0.033	1
>>>>>> org.hibernate.envers.test.integration.naming.EstonianTableAlias.testAuditChildTableAlias[1] 	0.044	1
>>>>>> org.hibernate.envers.test.integration.naming.VersionsJoinTableNaming.testHistoryOfUniId1[0] 	0.108	1
>>>>>> org.hibernate.envers.test.integration.naming.VersionsJoinTableNaming.testRevisionsCounts[0] 	0.031	1
>>>>>> org.hibernate.envers.test.integration.readwriteexpression.ReadWriteExpressionChange.shouldRespectWriteExpression[0] 	0.0030	1
>>>>>> org.hibernate.envers.test.integration.readwriteexpression.ReadWriteExpressionChange.shouldRespectWriteExpression[1] 	0.0040	1
>>>>>> org.hibernate.envers.test.integration.reventity.CustomDate.testDatesForRevisions[0] 	0.0090	1
>>>>>> org.hibernate.envers.test.integration.reventity.CustomDate.testFindRevision[0] 	0.0050	1
>>>>>> org.hibernate.envers.test.integration.reventity.CustomDate.testRevisionsForDates[0] 	0.012	1
>>>>>> org.hibernate.envers.test.integration.reventity.CustomDate.testTimestamps[0] 	0.0030	1
>>>>>> org.hibernate.envers.test.integration.reventity.CustomDate.testTimestamps1[0] 	0.0040	1
>>>>>> org.hibernate.envers.test.integration.reventity.CustomDate.testDatesForRevisions[1] 	0.0070	1
>>>>>> org.hibernate.envers.test.integration.reventity.CustomDate.testFindRevision[1] 	0.0040	1
>>>>>> org.hibernate.envers.test.integration.reventity.CustomDate.testRevisionsForDates[1] 	0.027	1
>>>>>> org.hibernate.envers.test.integration.reventity.CustomDate.testTimestamps[1] 	0.014	1
>>>>>> org.hibernate.envers.test.integration.reventity.CustomDate.testTimestamps1[1] 	0.015	1
>>>>>> org.hibernate.envers.test.integration.reventity.DifferentDBSchemaTest.initData[0] 	0.0090	1
>>>>>> org.hibernate.envers.test.integration.reventity.DifferentDBSchemaTest.testHistoryOfId1[0] 	0.0010	1
>>>>>> org.hibernate.envers.test.integration.reventity.DifferentDBSchemaTest.testRevisionsCounts[0] 	0.0	1
>>>>>> org.hibernate.envers.test.integration.reventity.DifferentDBSchemaTest.initData[1] 	0.0060	1
>>>>>> org.hibernate.envers.test.integration.reventity.DifferentDBSchemaTest.testHistoryOfId1[1] 	0.0090	1
>>>>>> org.hibernate.envers.test.integration.reventity.DifferentDBSchemaTest.testRevisionsCounts[1] 	0.0	1
>>>>>> org.hibernate.envers.test.integration.strategy.ValidityAuditStrategyRevEndTsTest.testAllRevEndTimeStamps[0] 	0.145	1
>>>>>> org.hibernate.envers.test.integration.strategy.ValidityAuditStrategyRevEndTsTest.testAllRevEndTimeStamps[1] 	0.173	1
>>> {quote}
>>> 
>>> this is caused by the _org.hibernate.envers.test.EnversTestingJtaBootstrap#updateConfigAndCreateTM_, this class updates the db connection url and appends a `;AUTOCOMMIT=OFF`, but this property is only valid on H2
>>> 
>>> do tests using _org.hibernate.envers.test.EnversTestingJtaBootstrap_ are supposed only running on H2?
>>> if so, we need move those tests into _src/test/main_
>>> 
>>> or we need to fix these tests
>>> 
>>> --
>>> This message is automatically generated by JIRA.
>>> For more information on JIRA, see: http://www.atlassian.com/software/jira
>>> 
>>> 
>> 
> 
> -- 
> Adam Warski
> 
> http://twitter.com/#!/adamwarski
> http://www.softwaremill.com
> http://www.warski.org
> 
> 
> 
> 
> 
> 
> 
> 




More information about the hibernate-dev mailing list