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 "Kathey Marsden (JIRA)" <ji...@apache.org> on 2010/12/30 22:15:48 UTC

[jira] Created: (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.

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


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.


[jira] Updated: (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.

Posted by "Mike Matrigali (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-4952?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Mike Matrigali updated DERBY-4952:
----------------------------------

               Urgency: Low
    Bug behavior facts: [Regression Test Failure]
                Labels: derby_triage10_8  (was: )

triage for 10.8 release.

setting urgency to low as only seen once in a one off run.  If anyone can reproduce then suggest urgency be raised.  Do report info if anyone else see's this.

> 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
>              Labels: derby_triage10_8
>         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.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[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.

Posted by "Myrna van Lunteren (JIRA)" <ji...@apache.org>.
    [ 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.


[jira] Updated: (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.

Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-4952?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kathey Marsden updated DERBY-4952:
----------------------------------

    Attachment: BasicSetupFailDir.zip

this is the fail directory after the failure.


> 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.