db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kathey Marsden (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-4180) SQLTransactionRollbackException in XATransactionTest when testing client/server compatibility
Date Mon, 03 Aug 2009 22:08:15 GMT

    [ https://issues.apache.org/jira/browse/DERBY-4180?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12738636#action_12738636
] 

Kathey Marsden commented on DERBY-4180:
---------------------------------------

Running on the latest on the 10.5 and 10.4 branches:
[/home/kmarsden/testjars/derby.jar] 10.5.2.1 - (800568)
[/home/kmarsden/testjars/derbytools.jar] 10.5.2.1 - (800568)
[/home/kmarsden/testjars/derbynet.jar] 10.5.2.1 - (800568)
[/home/kmarsden/testjars/derbyclient.jar] 10.4.2.1 - (800577)

and 10.4 derbyTesting.jar (800577)

I get the following failures runnng just jdbcapi.XATransactionTest
.
testGlobalXIDinTransactionTable used 221 ms .
testXATransactionTimeout used 35838 ms .
testXAExceptionErrorCodeOnSQLExceptionDerby4141 used 18 ms .
testGlobalXIDinTransactionTable used 210 ms E.
testXATransactionTimeout used 19 ms E.
testXAExceptionErrorCodeOnSQLExceptionDerby4141 used 11 ms Ejava.sql.SQLException: Connection
authentication failure occurred.  Reason: Invalid authentication..
	at org.apache.derby.impl.drda.NetworkServerControlImpl.throwSQLException(NetworkServerControlImpl.java:3238)
	at org.apache.derby.impl.drda.NetworkServerControlImpl.consolePropertyMessageWork(NetworkServerControlImpl.java:3175)
	at org.apache.derby.impl.drda.NetworkServerControlImpl.consolePropertyMessage(NetworkServerControlImpl.java:1848)
	at org.apache.derby.impl.drda.NetworkServerControlImpl.wrapSQLError(NetworkServerControlImpl.java:3743)
	at org.apache.derby.impl.drda.NetworkServerControlImpl.readResult(NetworkServerControlImpl.java:2718)
	at org.apache.derby.impl.drda.NetworkServerControlImpl.shutdown(NetworkServerControlImpl.java:991)
	at org.apache.derby.drda.NetworkServerControl.shutdown(NetworkServerControl.java:384)
	at org.apache.derbyTesting.junit.NetworkServerTestSetup.tearDown(NetworkServerTestSetup.java:372)
	at junit.extensions.TestSetup$1.protect(TestSetup.java:20)
	at junit.framework.TestResult.runProtected(TestResult.java:124)
	at junit.extensions.TestSetup.run(TestSetup.java:23)
	at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
	at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
	at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
	at junit.framework.TestResult.runProtected(TestResult.java:124)
	at junit.extensions.TestSetup.run(TestSetup.java:23)
	at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
	at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
	at junit.framework.TestResult.runProtected(TestResult.java:124)
	at junit.extensions.TestSetup.run(TestSetup.java:23)
	at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
	at junit.framework.TestSuite.runTest(TestSuite.java:208)
	at junit.framework.TestSuite.run(TestSuite.java:203)
	at junit.textui.TestRunner.doRun(TestRunner.java:116)
	at junit.textui.TestRunner.start(TestRunner.java:172)
	at junit.textui.TestRunner.main(TestRunner.java:138)

Time: 46.731
There were 3 errors:
1) testGlobalXIDinTransactionTable(org.apache.derbyTesting.functionTests.tests.jdbcapi.XATransactionTest)java.sql.SQLNonTransientConnectionException:
Connection authentication failure occurred.  Reason: userid or password invalid.
	at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:70)
	at org.apache.derby.client.am.SqlException.getSQLException(SqlException.java:362)
	at org.apache.derby.jdbc.ClientDriver.connect(ClientDriver.java:149)
	at java.sql.DriverManager.getConnection(DriverManager.java:316)
	at java.sql.DriverManager.getConnection(DriverManager.java:297)
	at org.apache.derbyTesting.junit.DriverManagerConnector.getConnectionByAttributes(DriverManagerConnector.java:131)
	at org.apache.derbyTesting.junit.DriverManagerConnector.openConnection(DriverManagerConnector.java:91)
	at org.apache.derbyTesting.junit.DriverManagerConnector.openConnection(DriverManagerConnector.java:43)
	at org.apache.derbyTesting.junit.TestConfiguration.openDefaultConnection(TestConfiguration.java:1312)
	at org.apache.derbyTesting.junit.BaseJDBCTestCase.openDefaultConnection(BaseJDBCTestCase.java:419)
	at org.apache.derbyTesting.junit.BaseJDBCTestCase.getConnection(BaseJDBCTestCase.java:101)
	at org.apache.derbyTesting.functionTests.tests.jdbcapi.XATransactionTest.testGlobalXIDinTransactionTable(XATransactionTest.java:52)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
	at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:102)
	at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
	at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
	at junit.extensions.TestSetup.run(TestSetup.java:23)
	at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
	at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
	at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
	at junit.extensions.TestSetup.run(TestSetup.java:23)
	at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
	at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
	at junit.extensions.TestSetup.run(TestSetup.java:23)
	at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
Caused by: org.apache.derby.client.am.SqlException: Connection authentication failure occurred.
 Reason: userid or password invalid.
	at org.apache.derby.client.net.NetConnection.mapSecchkcd(NetConnection.java:1170)
	at org.apache.derby.client.net.NetConnection.securityCheckComplete(NetConnection.java:985)
	at org.apache.derby.client.net.NetConnectionReply.parseSECCHKRM(NetConnectionReply.java:610)
	at org.apache.derby.client.net.NetConnectionReply.parseSECCHKreply(NetConnectionReply.java:272)
	at org.apache.derby.client.net.NetConnectionReply.readSecurityCheck(NetConnectionReply.java:113)
	at org.apache.derby.client.net.NetConnection.readSecurityCheckAndAccessRdb(NetConnection.java:822)
	at org.apache.derby.client.net.NetConnection.flowSecurityCheckAndAccessRdb(NetConnection.java:747)
	at org.apache.derby.client.net.NetConnection.flowUSRIDPWDconnect(NetConnection.java:568)
	at org.apache.derby.client.net.NetConnection.flowConnect(NetConnection.java:383)
	at org.apache.derby.client.net.NetConnection.<init>(NetConnection.java:218)
	at org.apache.derby.client.net.NetConnection40.<init>(NetConnection40.java:77)
	at org.apache.derby.client.net.ClientJDBCObjectFactoryImpl40.newNetConnection(ClientJDBCObjectFactoryImpl40.java:269)
	at org.apache.derby.jdbc.ClientDriver.connect(ClientDriver.java:140)
	... 41 more
2) testXATransactionTimeout(org.apache.derbyTesting.functionTests.tests.jdbcapi.XATransactionTest)java.sql.SQLNonTransientConnectionException:
Connection authentication failure occurred.  Reason: userid or password invalid.
	at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:70)
	at org.apache.derby.client.am.SqlException.getSQLException(SqlException.java:362)
	at org.apache.derby.jdbc.ClientDriver.connect(ClientDriver.java:149)
	at java.sql.DriverManager.getConnection(DriverManager.java:316)
	at java.sql.DriverManager.getConnection(DriverManager.java:297)
	at org.apache.derbyTesting.junit.DriverManagerConnector.getConnectionByAttributes(DriverManagerConnector.java:131)
	at org.apache.derbyTesting.junit.DriverManagerConnector.openConnection(DriverManagerConnector.java:91)
	at org.apache.derbyTesting.junit.DriverManagerConnector.openConnection(DriverManagerConnector.java:43)
	at org.apache.derbyTesting.junit.TestConfiguration.openDefaultConnection(TestConfiguration.java:1312)
	at org.apache.derbyTesting.junit.BaseJDBCTestCase.openDefaultConnection(BaseJDBCTestCase.java:419)
	at org.apache.derbyTesting.junit.BaseJDBCTestCase.getConnection(BaseJDBCTestCase.java:101)
	at org.apache.derbyTesting.functionTests.tests.jdbcapi.XATransactionTest.testXATransactionTimeout(XATransactionTest.java:179)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
	at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:102)
	at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
	at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
	at junit.extensions.TestSetup.run(TestSetup.java:23)
	at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
	at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
	at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
	at junit.extensions.TestSetup.run(TestSetup.java:23)
	at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
	at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
	at junit.extensions.TestSetup.run(TestSetup.java:23)
	at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
Caused by: org.apache.derby.client.am.SqlException: Connection authentication failure occurred.
 Reason: userid or password invalid.
	at org.apache.derby.client.net.NetConnection.mapSecchkcd(NetConnection.java:1170)
	at org.apache.derby.client.net.NetConnection.securityCheckComplete(NetConnection.java:985)
	at org.apache.derby.client.net.NetConnectionReply.parseSECCHKRM(NetConnectionReply.java:610)
	at org.apache.derby.client.net.NetConnectionReply.parseSECCHKreply(NetConnectionReply.java:272)
	at org.apache.derby.client.net.NetConnectionReply.readSecurityCheck(NetConnectionReply.java:113)
	at org.apache.derby.client.net.NetConnection.readSecurityCheckAndAccessRdb(NetConnection.java:822)
	at org.apache.derby.client.net.NetConnection.flowSecurityCheckAndAccessRdb(NetConnection.java:747)
	at org.apache.derby.client.net.NetConnection.flowUSRIDPWDconnect(NetConnection.java:568)
	at org.apache.derby.client.net.NetConnection.flowConnect(NetConnection.java:383)
	at org.apache.derby.client.net.NetConnection.<init>(NetConnection.java:218)
	at org.apache.derby.client.net.NetConnection40.<init>(NetConnection40.java:77)
	at org.apache.derby.client.net.ClientJDBCObjectFactoryImpl40.newNetConnection(ClientJDBCObjectFactoryImpl40.java:269)
	at org.apache.derby.jdbc.ClientDriver.connect(ClientDriver.java:140)
	... 41 more
3) testXAExceptionErrorCodeOnSQLExceptionDerby4141(org.apache.derbyTesting.functionTests.tests.jdbcapi.XATransactionTest)java.sql.SQLNonTransientConnectionException:
The connection was refused because the database wombat was not found.
	at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:70)
	at org.apache.derby.client.am.SqlException.getSQLException(SqlException.java:362)
	at org.apache.derby.client.ClientPooledConnection.<init>(ClientPooledConnection.java:167)
	at org.apache.derby.client.ClientXAConnection.<init>(ClientXAConnection.java:48)
	at org.apache.derby.client.ClientXAConnection40.<init>(ClientXAConnection40.java:56)
	at org.apache.derby.client.net.ClientJDBCObjectFactoryImpl40.newClientXAConnection(ClientJDBCObjectFactoryImpl40.java:98)
	at org.apache.derby.jdbc.ClientXADataSource.getXAConnectionX(ClientXADataSource.java:88)
	at org.apache.derby.jdbc.ClientXADataSource.getXAConnection(ClientXADataSource.java:72)
	at org.apache.derby.jdbc.ClientXADataSource.getXAConnection(ClientXADataSource.java:65)
	at org.apache.derbyTesting.functionTests.tests.jdbcapi.XATransactionTest.testXAExceptionErrorCodeOnSQLExceptionDerby4141(XATransactionTest.java:285)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
	at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:102)
	at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
	at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
	at junit.extensions.TestSetup.run(TestSetup.java:23)
	at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
	at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
	at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
	at junit.extensions.TestSetup.run(TestSetup.java:23)
	at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
	at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
	at junit.extensions.TestSetup.run(TestSetup.java:23)
	at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
Caused by: org.apache.derby.client.am.DisconnectException: The connection was refused because
the database wombat was not found.
	at org.apache.derby.client.net.NetConnectionReply.parseRDBNFNRM(NetConnectionReply.java:1010)
	at org.apache.derby.client.net.NetConnectionReply.parseAccessRdbError(NetConnectionReply.java:436)
	at org.apache.derby.client.net.NetConnectionReply.parseACCRDBreply(NetConnectionReply.java:294)
	at org.apache.derby.client.net.NetConnectionReply.readAccessDatabase(NetConnectionReply.java:121)
	at org.apache.derby.client.net.NetConnection.readSecurityCheckAndAccessRdb(NetConnection.java:823)
	at org.apache.derby.client.net.NetConnection.flowSecurityCheckAndAccessRdb(NetConnection.java:747)
	at org.apache.derby.client.net.NetConnection.flowUSRIDPWDconnect(NetConnection.java:568)
	at org.apache.derby.client.net.NetConnection.flowConnect(NetConnection.java:383)
	at org.apache.derby.client.net.NetConnection.initialize(NetConnection.java:301)
	at org.apache.derby.client.net.NetConnection.<init>(NetConnection.java:285)
	at org.apache.derby.client.net.NetConnection40.<init>(NetConnection40.java:125)
	at org.apache.derby.client.net.ClientJDBCObjectFactoryImpl40.newNetConnection(ClientJDBCObjectFactoryImpl40.java:320)
	at org.apache.derby.client.net.NetXAConnection.createNetConnection(NetXAConnection.java:269)
	at org.apache.derby.client.net.NetXAConnection.<init>(NetXAConnection.java:73)
	at org.apache.derby.client.ClientPooledConnection.getNetXAConnection(ClientPooledConnection.java:472)
	at org.apache.derby.client.ClientPooledConnection.<init>(ClientPooledConnection.java:161)
	... 39 more

FAILURES!!!
Tests run: 6,  Failures: 0,  Errors: 3

No mention of authentication failure in the derby.log.  I  didn't see Suran or Mamta mention
this problem but it sounds vaguely familiar.  I don't see any authentication set up in XATransactionTest.


> SQLTransactionRollbackException in XATransactionTest when testing client/server compatibility
> ---------------------------------------------------------------------------------------------
>
>                 Key: DERBY-4180
>                 URL: https://issues.apache.org/jira/browse/DERBY-4180
>             Project: Derby
>          Issue Type: Bug
>          Components: Test
>    Affects Versions: 10.5.1.1
>         Environment: Windows Vista 64, AMD Phenom II 940, Sun JDK 1.6.0_10, JUnit 3.8.2
>            Reporter: Suran Jayathilaka
>         Attachments: hangInfo061109.txt, javacore.20090611.094630.6388.0001.txt
>
>
> When running suites.All on a 10.4 client to 10.5 server configuration, the failure was
observed.
> 10.5 Jars - From the db-derby-10.5.1.1-bin.zip  (RC2 - sane)
> ==============================================
> derby.jar
> derbytools.jar
> derbyLocale*.jar
> derbyrun.jar
> derbynet.jar
> 10.4 jars - (Built from the 10.4 branch - sane)
> ===================================
> derbyTesting.jar 
> derbyClient.jar 
> Stack Trace
> =========
> 5) testXATransactionTimeout(org.apache.derbyTesting.functionTests.tests.jdbcapi.XATransactionTest)java.sql.SQLTransactionRollbackException:
A lock could not be obtained within the time requested
> 	at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
> 	at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
> 	at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
> 	at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
> 	at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
> 	at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
> 	at org.apache.derby.impl.jdbc.EmbedResultSet.closeOnTransactionError(Unknown Source)
> 	at org.apache.derby.impl.jdbc.EmbedResultSet.movePosition(Unknown Source)
> 	at org.apache.derby.impl.jdbc.EmbedResultSet.next(Unknown Source)
> 	at org.apache.derbyTesting.functionTests.tests.jdbcapi.XATransactionTest.testXATransactionTimeout(XATransactionTest.java:234)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> 	at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:102)
> 	at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> 	at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> 	at junit.extensions.TestSetup.run(TestSetup.java:25)
> 	at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
> Caused by: java.sql.SQLException: A lock could not be obtained within the time requested
> 	at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
> 	at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
Source)
> 	... 39 more
> Caused by: ERROR 40XL1: A lock could not be obtained within the time requested
> 	at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
> 	at org.apache.derby.impl.services.locks.ConcurrentLockSet.lockObject(Unknown Source)
> 	at org.apache.derby.impl.services.locks.ConcurrentLockSet.zeroDurationLockObject(Unknown
Source)
> 	at org.apache.derby.impl.services.locks.AbstractPool.zeroDurationlockObject(Unknown
Source)
> 	at org.apache.derby.impl.services.locks.ConcurrentPool.zeroDurationlockObject(Unknown
Source)
> 	at org.apache.derby.impl.store.raw.xact.RowLocking2nohold.lockRecordForRead(Unknown
Source)
> 	at org.apache.derby.impl.store.access.conglomerate.OpenConglomerate.lockPositionForRead(Unknown
Source)
> 	at org.apache.derby.impl.store.access.conglomerate.GenericScanController.fetchRows(Unknown
Source)
> 	at org.apache.derby.impl.store.access.heap.HeapScan.fetchNextGroup(Unknown Source)
> 	at org.apache.derby.impl.sql.execute.BulkTableScanResultSet.reloadArray(Unknown Source)
> 	at org.apache.derby.impl.sql.execute.BulkTableScanResultSet.getNextRowCore(Unknown Source)
> 	at org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.getNextRowCore(Unknown
Source)
> 	at org.apache.derby.impl.sql.execute.ScalarAggregateResultSet.getRowFromResultSet(Unknown
Source)
> 	at org.apache.derby.impl.sql.execute.ScalarAggregateResultSet.getNextRowCore(Unknown
Source)
> 	at org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.getNextRowCore(Unknown
Source)
> 	at org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.getNextRow(Unknown Source)
> 	... 32 more

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message