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

XPLAIN feature does not work and gives ERROR XCL16: ResultSet not open

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 10.6.2.4, 10.7.1.4, 10.8.3.3, 10.9.1.0
    • 10.10.2.0, 10.11.1.1
    • Tools
    • Solaris 10, MacOS X 10.6, Windows XP
    • Normal
    • Repro attached
    • Regression, Seen in production

    Description

      I am running Derby 10.9.1.0 and am trying to figure out a performance problem with query taking too long. I don’t actually want to run the query so from the documentation, I try:

      call syscs_util.syscs_set_runtimestatistics(1);
      call syscs_util.syscs_set_xplain_schema('STATS');
      call syscs_util.syscs_set_xplain_mode(1);
      — my query here
      call syscs_util.syscs_set_runtimestatistics(0);
      call syscs_util.syscs_set_xplain_schema('');
      call syscs_util.syscs_set_xplain_mode(0);

      When it runs my query, I get:

      ERROR XCL16: ResultSet not open. Operation 'getMetaData' not permitted. Verify that autocommit is OFF.

      I try the following with IJ just to see:

      call syscs_util.syscs_set_runtimestatistics(1);
      call syscs_util.syscs_set_xplain_schema('STATS');
      call syscs_util.syscs_set_xplain_mode(1);
      select sql_text from syscs_diag.transaction_table where status != 'IDLE';
      call syscs_util.syscs_set_runtimestatistics(0);
      call syscs_util.syscs_set_xplain_schema('');
      call syscs_util.syscs_set_xplain_mode(0);

      Note I have tried this with real tables as apposed to the syscs_diag.transaction_table with the same result. The only reason that I posted this with this table is that it is a table that is accessible for any database.

      Attachments

        1. addTests.diff
          7 kB
          Bryan Pendleton
        2. emptyRS.diff
          24 kB
          Bryan Pendleton
        3. noMemberField.diff
          46 kB
          Bryan Pendleton
        4. preparedTests.diff
          46 kB
          Bryan Pendleton
        5. xplain-only.diff
          38 kB
          Bryan Pendleton

        Issue Links

          Activity

            People

              bryanpendleton Bryan Pendleton
              bbergquist Brett Bergquist
              Votes:
              0 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: