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

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 10.11.1.3, 10.12.1.1
    • 10.11.1.3, 10.12.1.1
    • Test
    • None
    • IBM 1.6 SR16 and IBM 1.6 SR16 FP1, windows and linux.
    • 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

              myrna Myrna van Lunteren
              mamtas Mamta A. Satoor
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: