Derby
  1. Derby
  2. DERBY-1457

lang/triggerGeneral.sql fails intermittently

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Minor Minor
    • Resolution: Duplicate
    • Affects Version/s: 10.2.1.6, 10.3.1.4
    • Fix Version/s: None
    • Component/s: Test
    • Labels:
      None
    • Environment:
    • Bug behavior facts:
      Regression Test Failure

      Description

      This failure seems to be intermittent. The diff is:

          • Start: triggerGeneral jdk1.3.1 subset - 2.1 derbyall:derbylang 2006-06-26 09:18:19 ***
            941 del
            < DERBY-388 Test Passed.
            941a941,950
            > ERROR 38000: The exception 'SQL Exception: A SAVEPOINT with the passed name already exists in the current transaction.' was thrown while evaluating an expression.
            > ERROR 3B501: A SAVEPOINT with the passed name already exists in the current transaction.
            > ij> – Derby-85: It turns out that if a table t1 exists in a non-default schema
            > – and the default schema (e.g., "SOMEUSER") doesn't exist yet (because no
            > – objects have been created in that schema), then attempts to create a
            > – trigger on t1 using its qualified name will lead to a null pointer
            > – exception in the Derby engine.
            > connect 'wombat;user=someuser';
            > ij(CONNECTION1)> autocommit off;
            > ij(CONNECTION1)> create table myschema.mytable (i int);
            943,951d951
            < ij> – Derby-85: It turns out that if a table t1 exists in a non-default schema
            < – and the default schema (e.g., "SOMEUSER") doesn't exist yet (because no
            < – objects have been created in that schema), then attempts to create a
            < – trigger on t1 using its qualified name will lead to a null pointer
            < – exception in the Derby engine.
            < connect 'wombat;user=someuser';
            < ij(CONNECTION1)> autocommit off;
            < ij(CONNECTION1)> create table myschema.mytable (i int);
            < 0 rows inserted/updated/deleted
            Test Failed.
          • End: triggerGeneral jdk1.3.1 subset - 2.1 derbyall:derbylang 2006-06-26 09:18:52 ***

      Stack trace of failure is:
      ERROR 3B501: A SAVEPOINT with the passed name already exists in the current transaction.
      at java.lang.Throwable.<init>(Throwable.java)
      at java.lang.Throwable.<init>(Throwable.java)
      at org.apache.derby.iapi.error.StandardException.<init>(StandardException.java:83)
      at org.apache.derby.iapi.error.StandardException.<init>(StandardException.java:72)
      at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:294)
      at org.apache.derby.impl.store.raw.xact.Xact.setSavePoint(Xact.java:1420)
      at org.apache.derby.impl.store.access.RAMTransaction.setSavePoint(RAMTransaction.java:1997)
      at org.apache.derby.impl.sql.conn.GenericStatementContext.setSavePoint(GenericStatementContext.java:257)
      at org.apache.derby.impl.sql.GenericPreparedStatement.execute(GenericPreparedStatement.java)
      at org.apache.derby.impl.sql.execute.GenericTriggerExecutor.executeSPS(GenericTriggerExecutor.java)
      at org.apache.derby.impl.sql.execute.RowTriggerExecutor.fireTrigger(RowTriggerExecutor.java:110)
      at org.apache.derby.impl.sql.execute.TriggerEventActivator.notifyEvent(TriggerEventActivator.java:277)
      at org.apache.derby.impl.sql.execute.UpdateResultSet.fireAfterTriggers(UpdateResultSet.java:825)
      at org.apache.derby.impl.sql.execute.UpdateResultSet.open(UpdateResultSet.java:288)
      at org.apache.derby.impl.sql.GenericPreparedStatement.execute(GenericPreparedStatement.java)
      at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1181)
      at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:584)
      at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:516)
      at org.apache.derbyTesting.functionTests.tests.lang.userDefMethods.derby388(userDefMethods.java:137)
      at org.apache.derby.exe.ac46a08075x010cx1122x5cc3x0000187d3624a5.g0(Unknown Source)
      at java.lang.reflect.AccessibleObject.invokeV(AccessibleObject.java:199)
      at java.lang.reflect.Method.invoke(Method.java:252)
      at org.apache.derby.impl.services.reflect.ReflectMethod.invoke(ReflectMethod.java:45)
      at org.apache.derby.impl.sql.execute.CallStatementResultSet.open(CallStatementResultSet.java:67)
      at org.apache.derby.impl.sql.GenericPreparedStatement.execute(GenericPreparedStatement.java)
      at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1181)
      at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:584)
      at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:516)
      at org.apache.derby.impl.tools.ij.ij.executeImmediate(ij.java)
      at org.apache.derby.impl.tools.ij.utilMain.doCatch(utilMain.java:433)
      at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java:310)
      at org.apache.derby.impl.tools.ij.Main.go(Main.java:207)
      at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java:173)
      at org.apache.derby.impl.tools.ij.Main.main(Main.java:75)
      at org.apache.derby.tools.ij.main(ij.java:56)

        Issue Links

          Activity

          Deepa Remesh created issue -
          A B made changes -
          Field Original Value New Value
          Summary lang/triggerGeneral.sql fails intermittently with wsdd 5.6 lang/triggerGeneral.sql fails intermittently
          Environment IBM wsdd5.6 j9_13 IBM wsdd5.6 j9_13, IBM 142
          Affects Version/s 10.3.0.0 [ 12310800 ]
          A B made changes -
          Environment IBM wsdd5.6 j9_13, IBM 142 - IBM wsdd5.6 j9_13
          - IBM 142:

              java version "1.4.2_07"
              Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_07-b05)
              Java HotSpot(TM) Client VM (build 1.4.2_07-b05, mixed mode)
          Sunitha Kambhampati made changes -
          Environment - IBM wsdd5.6 j9_13
          - IBM 142:

              java version "1.4.2_07"
              Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_07-b05)
              Java HotSpot(TM) Client VM (build 1.4.2_07-b05, mixed mode)
          - IBM wsdd5.6 j9_13
          - IBM 142:

              java version "1.4.2_07"
              Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_07-b05)
              Java HotSpot(TM) Client VM (build 1.4.2_07-b05, mixed mode)

          -ibm 1.5
          Kathey Marsden made changes -
          Resolution Duplicate [ 3 ]
          Status Open [ 1 ] Resolved [ 5 ]
          Dag H. Wanvik made changes -
          Derby Categories [Regression Test Failure]
          Dag H. Wanvik made changes -
          Component/s Regression Test Failure [ 12310664 ]
          Dag H. Wanvik made changes -
          Component/s Test [ 11413 ]
          Dag H. Wanvik made changes -
          Issue Type Test [ 6 ] Bug [ 1 ]
          Kristian Waagan made changes -
          Link This issue duplicates DERBY-2808 [ DERBY-2808 ]
          Kristian Waagan made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Gavin made changes -
          Workflow jira [ 12374469 ] Default workflow, editable Closed status [ 12799655 ]

            People

            • Assignee:
              Unassigned
              Reporter:
              Deepa Remesh
            • Votes:
              1 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development