You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Myrna van Lunteren (JIRA)" <ji...@apache.org> on 2011/01/19 07:17:44 UTC
[jira] Commented: (DERBY-4952) Failure in
testTriggerBasic(org.apache.derbyTesting.functionTests.tests.upgradeTests.Bas
icSetup)java.sql.SQLException: A SAVEPOINT with the passed name already
exists i n the current transaction.
[ https://issues.apache.org/jira/browse/DERBY-4952?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12983548#action_12983548 ]
Myrna van Lunteren commented on DERBY-4952:
-------------------------------------------
I saw this in the nightly tests with ibm 1.6 sr9, on Suse Linux, trunk (10.8.0.0 alpha, build 1060165). I don't think last night's changes (r1059888, for DERBY-4964: Client driver fails to convert string to boolean with setObject(col, str, Types.BIT)) were related.
> Failure in testTriggerBasic(org.apache.derbyTesting.functionTests.tests.upgradeTests.Bas icSetup)java.sql.SQLException: A SAVEPOINT with the passed name already exists i n the current transaction.
> -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-4952
> URL: https://issues.apache.org/jira/browse/DERBY-4952
> Project: Derby
> Issue Type: Bug
> Components: Store
> Affects Versions: 10.6.2.3
> Environment: ava version "1.6.0"
> ava(TM) SE Runtime Environment (build pwi3260sr8-20100409_01(SR8))
> BM J9 VM (build 2.4, JRE 1.6.0 IBM J9 2.4 Windows XP x86-32 jvmwi3260sr8-201004
> 1_55940 (JIT enabled, AOT enabled)
> 9VM - 20100401_055940
> IT - r9_20100401_15339
> C - 20100308_AA)
> CL - 20100408_01
> 10.6.2.3 - (1053946M)
> Reporter: Kathey Marsden
> Attachments: BasicSetupFailDir.zip
>
>
> Testing my patch for DERBY-4913 on the 10.6 branch, I hit this failure:
> 1) testTriggerBasic(org.apache.derbyTesting.functionTests.tests.upgradeTests.Bas
> icSetup)java.sql.SQLException: A SAVEPOINT with the passed name already exists i
> n the current transaction.
> at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unkn
> own 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(Un
> known Source)
> at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown So
> urce)
> at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown So
> urce)
> at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown So
> urce)
> at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedStatement.executeUpdate(Unknown Sourc
> e)
> at org.apache.derbyTesting.functionTests.tests.upgradeTests.BasicSetup.t
> estTriggerBasic(BasicSetup.java:74)
> at sun.reflect.GeneratedMethodAccessor5673.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
> sorImpl.java:25)
> at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:
> 109)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> at junit.extensions.TestSetup.run(TestSetup.java:16)
> 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:51
> )
> 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:51
> )
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> at junit.extensions.TestSetup.run(TestSetup.java:16)
> 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:51
> )
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> at junit.extensions.TestSetup.run(TestSetup.java:16)
> 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:51
> )
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> at junit.extensions.TestSetup.run(TestSetup.java:16)
> 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:51
> )
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> at junit.extensions.TestSetup.run(TestSetup.java:16)
> 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:51
> )
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> at junit.extensions.TestSetup.run(TestSetup.java:16)
> 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:51
> )
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> at junit.extensions.TestSetup.run(TestSetup.java:16)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> at junit.extensions.TestSetup.run(TestSetup.java:16)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> at junit.extensions.TestSetup.run(TestSetup.java:16)
> Caused by: java.sql.SQLException: A SAVEPOINT with the passed name already exist
> s in the current transaction.
> at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknow
> n Source)
> at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransport
> AcrossDRDA(Unknown Source)
> ... 108 more
> Caused by: ERROR 3B501: A SAVEPOINT with the passed name already exists in the c
> urrent transaction.
> at org.apache.derby.iapi.error.StandardException.newException(Unknown So
> urce)
> at org.apache.derby.impl.store.raw.xact.Xact.setSavePoint(Unknown Source
> )
> at org.apache.derby.impl.store.access.RAMTransaction.setSavePoint(Unknow
> n Source)
> at org.apache.derby.impl.sql.conn.GenericStatementContext.setSavePoint(U
> nknown Source)
> at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown So
> urce)
> at org.apache.derby.impl.sql.execute.GenericTriggerExecutor.executeSPS(U
> nknown Source)
> at org.apache.derby.impl.sql.execute.RowTriggerExecutor.fireTrigger(Unkn
> own Source)
> at org.apache.derby.impl.sql.execute.TriggerEventActivator.notifyEvent(U
> nknown Source)
> at org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(Un
> known Source)
> at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source
> )
> at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown So
> urce)
> ... 102 more
> FAILURES!!!
> Tests run: 12589, Failures: 0, Errors: 1
> I don't think it is related to my change, It occured in the CREATE phase of 10.3.1.4
> Test upgrade from: 10.3.1.4, phase: CREATE
> .
> testTriggerBasic used 3453 ms E.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.