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(a)atlassian.com&gt; > 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(a)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 > >

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(a)warski.org&gt; To: "Strong Liu" <stliu(a)hibernate.org&gt; Cc: "Madhumita Sadhukhan" <msadhukh(a)redhat.com&gt;, &quot;hibernate-dev(a)lists.jboss.org hibernate-dev" <hibernate-dev(a)lists.jboss.org&gt; 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(a)atlassian.com&gt; >> 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(a)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