Uploaded image for project: 'Derby'
  1. Derby
  2. 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.

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 10.6.2.4, 10.11.1.1
    • Fix Version/s: None
    • Component/s: Store
    • Environment:
    • Urgency:
      Low
    • Bug behavior facts:
      Regression Test Failure

      Description

      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.

        Attachments

        1. BasicSetupFailDir.zip
          103 kB
          Katherine Marsden

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              kmarsden Katherine Marsden
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated: