Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-6760

test_01_planCost has been failing for last couple nights on trunk and 10.11 with Unexpected SQL state. expected:<XIE0S> but was:<null>

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.11.1.3, 10.12.1.1
    • Fix Version/s: 10.11.1.3, 10.12.1.1
    • Component/s: Test
    • Labels:
      None
    • Environment:
      IBM 1.6 SR16 and IBM 1.6 SR16 FP1, windows and linux.
    • Bug behavior facts:
      Regression Test Failure

      Description

      test_01_planCost has failed on trunk and 10.11 for last couple nightly runs. Output from 10.11(revision 1629345) test run is as follows

      http://people.apache.org/~myrnavl/derby_test_results/v10_11/linux/testlog/ibm16/1629345-suites.All_diff.txt
      1) test_01_planCost(org.apache.derbyTesting.functionTests.tests.lang.XMLOptimizerTraceTest)junit.framework.ComparisonFailure: Unexpected SQL state. expected:<XIE0S> but was:<null>
      Caused by: java.sql.SQLException: java.sql.SQLException: The operation was not performed, because the specified output file (extinout/xott.xml) already exists. The procedure will not overwrite an existing file, even if the process has permissions to write to that file, due to security concerns, and to avoid accidental file damage. Please either change the output file name in the procedure arguments to specify a file which does not exist, or delete the existing file, then retry the operation.
      Caused by: java.security.PrivilegedActionException: java.sql.SQLException: The operation was not performed, because the specified output file (extinout/xott.xml) already exists. The procedure will not overwrite an existing file, even if the process has permissions to write to that file, due to security concerns, and to avoid accidental file damage. Please either change the output file name in the procedure arguments to specify a file which does not exist, or delete the existing file, then retry the operation.
      Caused by: java.sql.SQLException: The operation was not performed, because the specified output file (extinout/xott.xml) already exists. The procedure will not overwrite an existing file, even if the process has permissions to write to that file, due to security concerns, and to avoid accidental file damage. Please either change the output file name in the procedure arguments to specify a file which does not exist, or delete the existing file, then retry the operation.
      Caused by: ERROR XIE0S: The operation was not performed, because the specified output file (extinout/xott.xml) already exists. The procedure will not overwrite an existing file, even if the process has permissions to write to that file, due to security concerns, and to avoid accidental file damage. Please either change the output file name in the procedure arguments to specify a file which does not exist, or delete the existing file, then retry the operation.
      2) test_01_planCost(org.apache.derbyTesting.functionTests.tests.lang.XMLOptimizerTraceTest)junit.framework.AssertionFailedError: The exception's SQL state must be five characters long
      Caused by: java.sql.SQLNonTransientConnectionException: java.sql.SQLException: The operation was not performed, because the specified output file (extinout/xott.xml) already exists. The procedure will not overwrite an existing file, even if the process has permissions to write to that file, due to security concerns, and to avoid accidental file damage. Please either change the output file name in the procedure arguments to specify a file which does not exist, or delete the existing file, then retry the operation.
      Caused by: ERROR null: java.sql.SQLException: The operation was not performed, because the specified output file (extinout/xott.xml) already exists. The procedure will not overwrite an existing file, even if the process has permissions to write to that file, due to security concerns, and to avoid accidental file damage. Please either change the output file name in the procedure arguments to specify a file which does not exist, or delete the existing file, then retry the operation.

      The failures from trunk are at
      http://people.apache.org/~myrnavl/derby_test_results/main/windows/testlog/ibm16/1629352-suites.All_diff.txt
      http://people.apache.org/~myrnavl/derby_test_results/main/linux/testlog/ibm16/1629345-suites.All_diff.txt

        Attachments

        1. DERBY-6610_1.diff
          1 kB
          Myrna van Lunteren

          Issue Links

            Activity

              People

              • Assignee:
                myrna Myrna van Lunteren
                Reporter:
                mamtas Mamta A. Satoor
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: