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

Group by query with many aggregate columns and case statements fails with: ERROR XSDA7: Restore of a serializable or SQLData object of class , attempted to read more data than was originally stored

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.3.1.4
    • Fix Version/s: 10.5.1.1
    • Component/s: SQL
    • Labels:
      None

      Description

      using the attached database (v10.3) - " select * from pivotview " fails with the stack trace below. A view (pivotview_ok) created on a subset of the columns in pivotview executes fine. Adding one column back into pivotview_ok causes failures most of the time. See attached for view definitions.

      2007-11-21 00:58:49.421 GMT Thread[main,5,main] (XID = 2734422), (SESSIONID = 0), (DATABASE = pivotview), (DRDAID = null), Failed Statement is: select * from pivotview
      ERROR XSDA7: Restore of a serializable or SQLData object of class , attempted to read more data than was originally stored
      at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
      at org.apache.derby.impl.store.raw.data.StreamFileContainer.fetchNext(Unknown Source)
      at org.apache.derby.impl.store.raw.data.StreamFileContainerHandle.fetchNext(Unknown Source)
      at org.apache.derby.impl.store.access.sort.MergeScan.mergeARow(Unknown Source)
      at org.apache.derby.impl.store.access.sort.MergeScan.init(Unknown Source)
      at org.apache.derby.impl.store.access.sort.MergeSort.openSortScan(Unknown Source)
      at org.apache.derby.impl.store.access.RAMTransaction.openSortScan(Unknown Source)
      at org.apache.derby.impl.sql.execute.GroupedAggregateResultSet.loadSorter(Unknown Source)
      at org.apache.derby.impl.sql.execute.GroupedAggregateResultSet.openCore(Unknown Source)
      at org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.openCore(Unknown Source)
      at org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.open(Unknown Source)
      at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
      at org.apache.derby.impl.tools.ij.ij.executeImmediate(Unknown Source)
      at org.apache.derby.impl.tools.ij.utilMain.doCatch(Unknown Source)
      at org.apache.derby.impl.tools.ij.utilMain.runScriptGuts(Unknown Source)
      at org.apache.derby.impl.tools.ij.utilMain.go(Unknown Source)
      at org.apache.derby.impl.tools.ij.Main.go(Unknown Source)
      at org.apache.derby.impl.tools.ij.Main.mainCore(Unknown Source)
      at org.apache.derby.impl.tools.ij.Main14.main(Unknown Source)
      at org.apache.derby.tools.ij.main(Unknown Source)
      Caused by: java.io.EOFException
      at java.io.DataInputStream.readBoolean(DataInputStream.java:248)
      at org.apache.derby.impl.sql.execute.MaxMinAggregator.readExternal(Unknown Source)
      at org.apache.derby.iapi.services.io.FormatIdInputStream.readObject(Unknown Source)
      at org.apache.derby.iapi.types.UserType.readExternal(Unknown Source)
      ... 22 more
      ============= begin nested exception, level (1) ===========
      java.io.EOFException
      at java.io.DataInputStream.readBoolean(DataInputStream.java:248)
      at org.apache.derby.impl.sql.execute.MaxMinAggregator.readExternal(Unknown Source)
      at org.apache.derby.iapi.services.io.FormatIdInputStream.readObject(Unknown Source)
      at org.apache.derby.iapi.types.UserType.readExternal(Unknown Source)
      at org.apache.derby.impl.store.raw.data.StreamFileContainer.fetchNext(Unknown Source)
      at org.apache.derby.impl.store.raw.data.StreamFileContainerHandle.fetchNext(Unknown Source)
      at org.apache.derby.impl.store.access.sort.MergeScan.mergeARow(Unknown Source)
      at org.apache.derby.impl.store.access.sort.MergeScan.init(Unknown Source)
      at org.apache.derby.impl.store.access.sort.MergeSort.openSortScan(Unknown Source)
      at org.apache.derby.impl.store.access.RAMTransaction.openSortScan(Unknown Source)
      at org.apache.derby.impl.sql.execute.GroupedAggregateResultSet.loadSorter(Unknown Source)
      at org.apache.derby.impl.sql.execute.GroupedAggregateResultSet.openCore(Unknown Source)
      at org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.openCore(Unknown Source)
      at org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.open(Unknown Source)
      at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
      at org.apache.derby.impl.tools.ij.ij.executeImmediate(Unknown Source)
      at org.apache.derby.impl.tools.ij.utilMain.doCatch(Unknown Source)
      at org.apache.derby.impl.tools.ij.utilMain.runScriptGuts(Unknown Source)
      at org.apache.derby.impl.tools.ij.utilMain.go(Unknown Source)
      at org.apache.derby.impl.tools.ij.Main.go(Unknown Source)
      at org.apache.derby.impl.tools.ij.Main.mainCore(Unknown Source)
      at org.apache.derby.impl.tools.ij.Main14.main(Unknown Source)
      at org.apache.derby.tools.ij.main(Unknown Source)
      ============= end nested exception, level (1) ===========
      Cleanup action completed

        Attachments

        1. maxminPatch.diff
          0.8 kB
          Bryan Pendleton
        2. patchWithTest.diff
          3 kB
          Bryan Pendleton
        3. pivotView.zip
          6.58 MB
          Sun Seng David Tan
        4. repro.java
          1 kB
          Bryan Pendleton
        5. sanityTest.diff
          5 kB
          Bryan Pendleton
        6. ten_four_patch.diff
          5 kB
          Bryan Pendleton
        7. testWithMemControls.diff
          3 kB
          Bryan Pendleton

          Activity

            People

            • Assignee:
              bryanpendleton Bryan Pendleton
              Reporter:
              stan Sun Seng David Tan
            • Votes:
              1 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: