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

Madhumita Sadhukhan msadhukh at redhat.com
Thu Mar 22 11:15:15 EDT 2012


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