Derby
  1. Derby
  2. DERBY-2286

Exception NoSpaceOnPage does not provide SQLState or exception text

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Minor Minor
    • Resolution: Duplicate
    • Affects Version/s: 10.1.3.1, 10.2.1.6, 10.2.2.0, 10.5.3.0
    • Fix Version/s: None
    • Component/s: Store
    • Labels:
      None
    • Urgency:
      Normal
    • Issue & fix info:
      Repro attached

      Description

      Originally reported on the derby-user list in this post:

      http://mail-archives.apache.org/mod_mbox/db-derby-user/200701.mbox/%3c20070131165447.230840@gmx.net%3e

      The user encountered an impl.store.raw.data.NoSpaceOnPage exception during a batch update. The exception currently does not provide a SQLState or exception text explaining the cause of the error.

      1. NoSpaceBug.java
        4 kB
        Jim Rayfield

        Issue Links

          Activity

          Andrew McIntyre created issue -
          Hide
          Suresh Thalamati added a comment -

          This exception most probably is not expected to be thrown to the user. By briefly looking at the code it looks like , this exception is excepted to be caught and recovers from it. Most probably there is a real bug in some cases.

          Show
          Suresh Thalamati added a comment - This exception most probably is not expected to be thrown to the user. By briefly looking at the code it looks like , this exception is excepted to be caught and recovers from it. Most probably there is a real bug in some cases.
          Hide
          Karl Pietrzak added a comment -

          I think this issue is still around, and I'm using the latest Derby 10.4.1. It looks like some of the classes and methods have been renamed, but the stack trace looks awfully similar:

          <pre>
          Caused by: java.sql.SQLException: nospc.U :
          at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
          at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
          at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Sour
          at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
          at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
          at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
          at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
          at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source)
          at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source)
          at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeDirectNoAccessor.java:647)
          ... 33 more
          Caused by: java.sql.SQLException: nospc.U :
          at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
          at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Un
          ... 43 more
          Caused by: ERROR nospc: nospc.U :
          at org.apache.derby.impl.store.raw.data.StoredPage.logRow(Unknown Source)
          at org.apache.derby.impl.store.raw.data.UpdateOperation.writeOptionalDataToBuffer(Unk
          at org.apache.derby.impl.store.raw.data.UpdateOperation.<init>(Unknown Source)
          at org.apache.derby.impl.store.raw.data.LoggableActions.actionUpdate(Unknown Source)
          at org.apache.derby.impl.store.raw.data.StoredPage.doUpdateAtSlot(Unknown Source)
          at org.apache.derby.impl.store.raw.data.BasePage.updateAtSlot(Unknown Source)
          at org.apache.derby.impl.store.access.conglomerate.GenericConglomerateController.replrce)
          at org.apache.derby.impl.sql.execute.RowChangerImpl.updateRow(Unknown Source)
          at org.apache.derby.impl.sql.execute.UpdateResultSet.collectAffectedRows(Unknown Sour
          at org.apache.derby.impl.sql.execute.UpdateResultSet.open(Unknown Source)
          at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)
          ... 37 more
          </pre>

          Show
          Karl Pietrzak added a comment - I think this issue is still around, and I'm using the latest Derby 10.4.1. It looks like some of the classes and methods have been renamed, but the stack trace looks awfully similar: <pre> Caused by: java.sql.SQLException: nospc.U : at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Sour at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source) at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeDirectNoAccessor.java:647) ... 33 more Caused by: java.sql.SQLException: nospc.U : at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Un ... 43 more Caused by: ERROR nospc: nospc.U : at org.apache.derby.impl.store.raw.data.StoredPage.logRow(Unknown Source) at org.apache.derby.impl.store.raw.data.UpdateOperation.writeOptionalDataToBuffer(Unk at org.apache.derby.impl.store.raw.data.UpdateOperation.<init>(Unknown Source) at org.apache.derby.impl.store.raw.data.LoggableActions.actionUpdate(Unknown Source) at org.apache.derby.impl.store.raw.data.StoredPage.doUpdateAtSlot(Unknown Source) at org.apache.derby.impl.store.raw.data.BasePage.updateAtSlot(Unknown Source) at org.apache.derby.impl.store.access.conglomerate.GenericConglomerateController.replrce) at org.apache.derby.impl.sql.execute.RowChangerImpl.updateRow(Unknown Source) at org.apache.derby.impl.sql.execute.UpdateResultSet.collectAffectedRows(Unknown Sour at org.apache.derby.impl.sql.execute.UpdateResultSet.open(Unknown Source) at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source) ... 37 more </pre>
          Hide
          Kathey Marsden added a comment -

          Do you have a way to reproduce this error:? There may be a more serious bug than just the message text and SQLState missing.

          Show
          Kathey Marsden added a comment - Do you have a way to reproduce this error:? There may be a more serious bug than just the message text and SQLState missing.
          Hide
          Karl Pietrzak added a comment -

          Thank you for the comment, Kathey! As the original poster at http://mail-archives.apache.org/mod_mbox/db-derby-user/200701.mbox/%3C20070131165447.230840@gmx.net%3E states, the issue happens sporadically but very consistently, so it's difficult to reproduce. We have a long-running process that uses the Derby database, and it's died every time so far (almost always within 5 hours of the 60 hour process).

          I'm going to try to write a test program and have it run over the weekend. For us, we're updating some BLOBs (0KB-1MB) very often.

          Show
          Karl Pietrzak added a comment - Thank you for the comment, Kathey! As the original poster at http://mail-archives.apache.org/mod_mbox/db-derby-user/200701.mbox/%3C20070131165447.230840@gmx.net%3E states, the issue happens sporadically but very consistently, so it's difficult to reproduce. We have a long-running process that uses the Derby database, and it's died every time so far (almost always within 5 hours of the 60 hour process). I'm going to try to write a test program and have it run over the weekend. For us, we're updating some BLOBs (0KB-1MB) very often.
          Hide
          Karl Pietrzak added a comment -

          I just wanted to let everyone know that I built the 10.4 branch Derby JARs from source control a few days ago (7/21/2008?), and I no longer experienced this problem. This is an indication to us that it was fixed, and we can't wait for the next stable release.

          The original ticket is for lacking SQLState and exception text, which I believe is still an open issue.

          Show
          Karl Pietrzak added a comment - I just wanted to let everyone know that I built the 10.4 branch Derby JARs from source control a few days ago (7/21/2008?), and I no longer experienced this problem. This is an indication to us that it was fixed, and we can't wait for the next stable release. The original ticket is for lacking SQLState and exception text, which I believe is still an open issue.
          Hide
          Rick Hillegas added a comment -

          Closing this issue for the following reasons:

          1) There is no reproducible test case.

          2) The problem went away after using a later version of Derby.

          Show
          Rick Hillegas added a comment - Closing this issue for the following reasons: 1) There is no reproducible test case. 2) The problem went away after using a later version of Derby.
          Rick Hillegas made changes -
          Field Original Value New Value
          Status Open [ 1 ] Closed [ 6 ]
          Resolution Won't Fix [ 2 ]
          Hide
          Kathey Marsden added a comment -

          I think it is ok to leave this Won't Fix unless someone wants to fix it or can find a way to get it in normal operations, but I wanted to note that the problem with lack of SQLState and message seems to still be an issue from code inspection. In NoSpaceOnPage.java we have:
          class NoSpaceOnPage extends StandardException

          protected NoSpaceOnPage(boolean onOverflowPage)

          { super("nospc.U"); this.onOverflowPage = onOverflowPage; }

          In some cases we seem to catch this exception and throw something with an actual SQLState, but in others we do not.

          Show
          Kathey Marsden added a comment - I think it is ok to leave this Won't Fix unless someone wants to fix it or can find a way to get it in normal operations, but I wanted to note that the problem with lack of SQLState and message seems to still be an issue from code inspection. In NoSpaceOnPage.java we have: class NoSpaceOnPage extends StandardException protected NoSpaceOnPage(boolean onOverflowPage) { super("nospc.U"); this.onOverflowPage = onOverflowPage; } In some cases we seem to catch this exception and throw something with an actual SQLState, but in others we do not.
          Hide
          Jim Rayfield added a comment -

          I have a testcase that reproduces this behavior on 10.5.3.0:

          INFO: Unexpected error
          java.sql.SQLException: nospc.U
          at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
          at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
          at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
          at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
          at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
          at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
          at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
          at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source)
          at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source)
          at NoSpaceBug$ThreadRunner.run(NoSpaceBug.java:100)
          at java.lang.Thread.run(Thread.java:811)
          Caused by: ERROR nospc: nospc.U
          at org.apache.derby.impl.store.raw.data.StoredPage.logRow(Unknown Source)
          at org.apache.derby.impl.store.raw.data.UpdateOperation.writeOptionalDataToBuffer(Unknown Source)
          at org.apache.derby.impl.store.raw.data.UpdateOperation.<init>(Unknown Source)
          at org.apache.derby.impl.store.raw.data.LoggableActions.actionUpdate(Unknown Source)
          at org.apache.derby.impl.store.raw.data.StoredPage.doUpdateAtSlot(Unknown Source)
          at org.apache.derby.impl.store.raw.data.BasePage.updateAtSlot(Unknown Source)
          at org.apache.derby.impl.store.access.conglomerate.GenericConglomerateController.replace(Unknown Source)
          at org.apache.derby.impl.sql.execute.RowChangerImpl.updateRow(Unknown Source)
          at org.apache.derby.impl.sql.execute.UpdateResultSet.collectAffectedRows(Unknown Source)
          at org.apache.derby.impl.sql.execute.UpdateResultSet.open(Unknown Source)
          at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source)
          at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)
          ... 5 more

          It needs to be run for a while (an hour for me) on a modern multiprocessor linux system. I could not reproduce it on a Windows laptop running overnight.

          ------------------ Java Information ------------------
          Java Version: 1.5.0
          Java Vendor: IBM Corporation
          Java home: /opt/ibm/java2-i386-50/jre
          Java classpath: derby.jar
          OS name: Linux
          OS architecture: x86
          OS version: 2.6.18-128.el5xen
          Java user name: root
          Java user home: /root
          Java user dir: /root/cvs/ccache
          java.specification.name: Java Platform API Specification
          java.specification.version: 1.5
          --------- Derby Information --------
          JRE - JDBC: J2SE 5.0 - JDBC 3.0
          [/root/cvs/ccache/derby.jar] 10.5.3.0 - (802917)
          ------------------------------------------------------
          ----------------- Locale Information -----------------
          ------------------------------------------------------

          I'll attach the source file.

          Show
          Jim Rayfield added a comment - I have a testcase that reproduces this behavior on 10.5.3.0: INFO: Unexpected error java.sql.SQLException: nospc.U at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source) at NoSpaceBug$ThreadRunner.run(NoSpaceBug.java:100) at java.lang.Thread.run(Thread.java:811) Caused by: ERROR nospc: nospc.U at org.apache.derby.impl.store.raw.data.StoredPage.logRow(Unknown Source) at org.apache.derby.impl.store.raw.data.UpdateOperation.writeOptionalDataToBuffer(Unknown Source) at org.apache.derby.impl.store.raw.data.UpdateOperation.<init>(Unknown Source) at org.apache.derby.impl.store.raw.data.LoggableActions.actionUpdate(Unknown Source) at org.apache.derby.impl.store.raw.data.StoredPage.doUpdateAtSlot(Unknown Source) at org.apache.derby.impl.store.raw.data.BasePage.updateAtSlot(Unknown Source) at org.apache.derby.impl.store.access.conglomerate.GenericConglomerateController.replace(Unknown Source) at org.apache.derby.impl.sql.execute.RowChangerImpl.updateRow(Unknown Source) at org.apache.derby.impl.sql.execute.UpdateResultSet.collectAffectedRows(Unknown Source) at org.apache.derby.impl.sql.execute.UpdateResultSet.open(Unknown Source) at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source) at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source) ... 5 more It needs to be run for a while (an hour for me) on a modern multiprocessor linux system. I could not reproduce it on a Windows laptop running overnight. ------------------ Java Information ------------------ Java Version: 1.5.0 Java Vendor: IBM Corporation Java home: /opt/ibm/java2-i386-50/jre Java classpath: derby.jar OS name: Linux OS architecture: x86 OS version: 2.6.18-128.el5xen Java user name: root Java user home: /root Java user dir: /root/cvs/ccache java.specification.name: Java Platform API Specification java.specification.version: 1.5 --------- Derby Information -------- JRE - JDBC: J2SE 5.0 - JDBC 3.0 [/root/cvs/ccache/derby.jar] 10.5.3.0 - (802917) ------------------------------------------------------ ----------------- Locale Information ----------------- ------------------------------------------------------ I'll attach the source file.
          Hide
          Jim Rayfield added a comment -

          Reproduces the bug in about an hour on a 2.67GHz Linux multicore system.

          Show
          Jim Rayfield added a comment - Reproduces the bug in about an hour on a 2.67GHz Linux multicore system.
          Jim Rayfield made changes -
          Attachment NoSpaceBug.java [ 12431838 ]
          Hide
          Knut Anders Hatlen added a comment -

          Thanks for the repro, Jim. I'm also able to reproduce it on a dual-core AMD running OpenSolaris. The repro ran for 45 minutes, with derby.system.durability=test to speed it up, before it failed. Reopening.

          Show
          Knut Anders Hatlen added a comment - Thanks for the repro, Jim. I'm also able to reproduce it on a dual-core AMD running OpenSolaris. The repro ran for 45 minutes, with derby.system.durability=test to speed it up, before it failed. Reopening.
          Knut Anders Hatlen made changes -
          Resolution Won't Fix [ 2 ]
          Status Closed [ 6 ] Reopened [ 4 ]
          Knut Anders Hatlen made changes -
          Affects Version/s 10.5.3.0 [ 12314117 ]
          Issue & fix info [Repro attached]
          Hide
          Knut Anders Hatlen added a comment -

          The failing call to UpdateOperation.writeOptionalDataToBuffer() has the following rather cryptic comment:

          // RESOLVE SRW-DJD/YYZ

          Does anyone know how to decipher that?

          I agree with Suresh's observation that it looks like NoSpaceOnPage is supposed to be caught and recovered from. Perhaps it would be better if it didn't extend StandardException, so that all callers would have to handle it explicitly. When it extends StandardException, it's easier that it falls through the cracks and gets handled by the default StandardException handler, which eventually returns the error to the user.

          Show
          Knut Anders Hatlen added a comment - The failing call to UpdateOperation.writeOptionalDataToBuffer() has the following rather cryptic comment: // RESOLVE SRW-DJD/YYZ Does anyone know how to decipher that? I agree with Suresh's observation that it looks like NoSpaceOnPage is supposed to be caught and recovered from. Perhaps it would be better if it didn't extend StandardException, so that all callers would have to handle it explicitly. When it extends StandardException, it's easier that it falls through the cracks and gets handled by the default StandardException handler, which eventually returns the error to the user.
          Hide
          Mike Matrigali added a comment -

          the comment is not of much use, old cruft from many years ago pre-derby submission. basically a note to come back and look at this with initials of people
          who don't work on the product any more.

          Show
          Mike Matrigali added a comment - the comment is not of much use, old cruft from many years ago pre-derby submission. basically a note to come back and look at this with initials of people who don't work on the product any more.
          Hide
          Mike Matrigali added a comment -

          i also agree with that most likely a piece of code should be catching the exception
          and taking a path. From reading code and the stack my best guess is that the update
          is happening on a long row (a row that is split across multiple pages), and that when trying to write the first piece of the update on an overflow page there is not enough
          room.

          logically seems like what should be happening is for the error to be caught and the update result be placed on a different page.

          But am wondering if the real bug might be that we were supposed to reserve
          enough space on the page so that one could always update a row on the page
          to a single row with an overflow pointer. So again not sure if bug is in handling
          of the thrown error or if other code should have made it such that this case is
          not encountered.

          But before doing the work it would be nice to get a better repro or some dump of
          information about the bug, to make sure it is not just a bug in the code checking if
          there is enough room. My guess is if we could identify the problem row that it is
          likely repeated tries with the same update statement would cause the problem over
          and over, if we could just get the db to crash with no other changes when the error
          happens. So far I have not gotten it to happen but have just been trying on my
          laptop.

          Show
          Mike Matrigali added a comment - i also agree with that most likely a piece of code should be catching the exception and taking a path. From reading code and the stack my best guess is that the update is happening on a long row (a row that is split across multiple pages), and that when trying to write the first piece of the update on an overflow page there is not enough room. logically seems like what should be happening is for the error to be caught and the update result be placed on a different page. But am wondering if the real bug might be that we were supposed to reserve enough space on the page so that one could always update a row on the page to a single row with an overflow pointer. So again not sure if bug is in handling of the thrown error or if other code should have made it such that this case is not encountered. But before doing the work it would be nice to get a better repro or some dump of information about the bug, to make sure it is not just a bug in the code checking if there is enough room. My guess is if we could identify the problem row that it is likely repeated tries with the same update statement would cause the problem over and over, if we could just get the db to crash with no other changes when the error happens. So far I have not gotten it to happen but have just been trying on my laptop.
          Hide
          Mike Matrigali added a comment -

          i am still not having luck reproducing on my machine. If anyone has reproduced and has a stack
          trace with line numbers, please post it. I would like to know which of the places in logRow() is
          throwing the exception - there are a number of places:
          throw new NoSpaceOnPage(isOverflowPage());

          Show
          Mike Matrigali added a comment - i am still not having luck reproducing on my machine. If anyone has reproduced and has a stack trace with line numbers, please post it. I would like to know which of the places in logRow() is throwing the exception - there are a number of places: throw new NoSpaceOnPage(isOverflowPage());
          Hide
          Knut Anders Hatlen added a comment -

          I managed to reproduce it somewhat faster on a quad-core by upping the number of threads to 4 and using the in-memory backend. As to line numbers, the only failure I've seen with sane jars is the assert failure from DERBY-2254.

          Show
          Knut Anders Hatlen added a comment - I managed to reproduce it somewhat faster on a quad-core by upping the number of threads to 4 and using the in-memory backend. As to line numbers, the only failure I've seen with sane jars is the assert failure from DERBY-2254 .
          Hide
          Jim Rayfield added a comment -

          Here is a stack trace with line numbers:

          Feb 9, 2010 1:05:18 PM NoSpaceBug$ThreadRunner run
          INFO: Thread running
          Feb 9, 2010 6:14:27 PM NoSpaceBug$ThreadRunner run
          INFO: Unexpected error
          java.sql.SQLException: nospc.U
          at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:45)
          at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java:201)
          at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(TransactionResourceImpl.java:391)
          at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(TransactionResourceImpl.java:346)
          at org.apache.derby.impl.jdbc.EmbedConnection.handleException(EmbedConnection.java:2201)
          at org.apache.derby.impl.jdbc.ConnectionChild.handleException(ConnectionChild.java:81)
          at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1323)
          at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(EmbedPreparedStatement.java:1675)
          at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(EmbedPreparedStatement.java:302)
          at NoSpaceBug$ThreadRunner.run(NoSpaceBug.java:100)
          at java.lang.Thread.run(Thread.java:811)
          Caused by: ERROR nospc: nospc.U
          at org.apache.derby.impl.store.raw.data.StoredPage.logRow(StoredPage.java:4134)
          at org.apache.derby.impl.store.raw.data.UpdateOperation.writeOptionalDataToBuffer(UpdateOperation.java:255)
          at org.apache.derby.impl.store.raw.data.UpdateOperation.<init>(UpdateOperation.java:106)
          at org.apache.derby.impl.store.raw.data.LoggableActions.actionUpdate(LoggableActions.java:80)
          at org.apache.derby.impl.store.raw.data.StoredPage.doUpdateAtSlot(StoredPage.java:8579)
          at org.apache.derby.impl.store.raw.data.BasePage.updateAtSlot(BasePage.java:1062)
          at org.apache.derby.impl.store.access.conglomerate.GenericConglomerateController.replace(GenericConglomerateController.java:472)
          at org.apache.derby.impl.sql.execute.RowChangerImpl.updateRow(RowChangerImpl.java:523)
          at org.apache.derby.impl.sql.execute.UpdateResultSet.collectAffectedRows(UpdateResultSet.java:561)
          at org.apache.derby.impl.sql.execute.UpdateResultSet.open(UpdateResultSet.java:254)
          at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(GenericPreparedStatement.java:416)
          at org.apache.derby.impl.sql.GenericPreparedStatement.execute(GenericPreparedStatement.java:297)
          at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1235)
          ... 4 more
          Feb 9, 2010 6:14:38 PM NoSpaceBug$ThreadRunner run
          INFO: Unexpected error
          java.sql.SQLException: nospc.U
          at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:45)
          at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java:201)
          at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(TransactionResourceImpl.java:391)
          at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(TransactionResourceImpl.java:346)
          at org.apache.derby.impl.jdbc.EmbedConnection.handleException(EmbedConnection.java:2201)
          at org.apache.derby.impl.jdbc.ConnectionChild.handleException(ConnectionChild.java:81)
          at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1323)
          at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(EmbedPreparedStatement.java:1675)
          at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(EmbedPreparedStatement.java:302)
          at NoSpaceBug$ThreadRunner.run(NoSpaceBug.java:100)
          at java.lang.Thread.run(Thread.java:811)
          Caused by: ERROR nospc: nospc.U
          at org.apache.derby.impl.store.raw.data.StoredPage.logRow(StoredPage.java:4134)
          at org.apache.derby.impl.store.raw.data.UpdateOperation.writeOptionalDataToBuffer(UpdateOperation.java:255)
          at org.apache.derby.impl.store.raw.data.UpdateOperation.<init>(UpdateOperation.java:106)
          at org.apache.derby.impl.store.raw.data.LoggableActions.actionUpdate(LoggableActions.java:80)
          at org.apache.derby.impl.store.raw.data.StoredPage.doUpdateAtSlot(StoredPage.java:8579)
          at org.apache.derby.impl.store.raw.data.BasePage.updateAtSlot(BasePage.java:1062)
          at org.apache.derby.impl.store.access.conglomerate.GenericConglomerateController.replace(GenericConglomerateController.java:472)
          at org.apache.derby.impl.sql.execute.RowChangerImpl.updateRow(RowChangerImpl.java:523)
          at org.apache.derby.impl.sql.execute.UpdateResultSet.collectAffectedRows(UpdateResultSet.java:561)
          at org.apache.derby.impl.sql.execute.UpdateResultSet.open(UpdateResultSet.java:254)
          at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(GenericPreparedStatement.java:416)
          at org.apache.derby.impl.sql.GenericPreparedStatement.execute(GenericPreparedStatement.java:297)
          at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1235)
          ... 4 more

          Show
          Jim Rayfield added a comment - Here is a stack trace with line numbers: Feb 9, 2010 1:05:18 PM NoSpaceBug$ThreadRunner run INFO: Thread running Feb 9, 2010 6:14:27 PM NoSpaceBug$ThreadRunner run INFO: Unexpected error java.sql.SQLException: nospc.U at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:45) at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java:201) at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(TransactionResourceImpl.java:391) at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(TransactionResourceImpl.java:346) at org.apache.derby.impl.jdbc.EmbedConnection.handleException(EmbedConnection.java:2201) at org.apache.derby.impl.jdbc.ConnectionChild.handleException(ConnectionChild.java:81) at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1323) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(EmbedPreparedStatement.java:1675) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(EmbedPreparedStatement.java:302) at NoSpaceBug$ThreadRunner.run(NoSpaceBug.java:100) at java.lang.Thread.run(Thread.java:811) Caused by: ERROR nospc: nospc.U at org.apache.derby.impl.store.raw.data.StoredPage.logRow(StoredPage.java:4134) at org.apache.derby.impl.store.raw.data.UpdateOperation.writeOptionalDataToBuffer(UpdateOperation.java:255) at org.apache.derby.impl.store.raw.data.UpdateOperation.<init>(UpdateOperation.java:106) at org.apache.derby.impl.store.raw.data.LoggableActions.actionUpdate(LoggableActions.java:80) at org.apache.derby.impl.store.raw.data.StoredPage.doUpdateAtSlot(StoredPage.java:8579) at org.apache.derby.impl.store.raw.data.BasePage.updateAtSlot(BasePage.java:1062) at org.apache.derby.impl.store.access.conglomerate.GenericConglomerateController.replace(GenericConglomerateController.java:472) at org.apache.derby.impl.sql.execute.RowChangerImpl.updateRow(RowChangerImpl.java:523) at org.apache.derby.impl.sql.execute.UpdateResultSet.collectAffectedRows(UpdateResultSet.java:561) at org.apache.derby.impl.sql.execute.UpdateResultSet.open(UpdateResultSet.java:254) at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(GenericPreparedStatement.java:416) at org.apache.derby.impl.sql.GenericPreparedStatement.execute(GenericPreparedStatement.java:297) at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1235) ... 4 more Feb 9, 2010 6:14:38 PM NoSpaceBug$ThreadRunner run INFO: Unexpected error java.sql.SQLException: nospc.U at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:45) at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java:201) at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(TransactionResourceImpl.java:391) at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(TransactionResourceImpl.java:346) at org.apache.derby.impl.jdbc.EmbedConnection.handleException(EmbedConnection.java:2201) at org.apache.derby.impl.jdbc.ConnectionChild.handleException(ConnectionChild.java:81) at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1323) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(EmbedPreparedStatement.java:1675) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(EmbedPreparedStatement.java:302) at NoSpaceBug$ThreadRunner.run(NoSpaceBug.java:100) at java.lang.Thread.run(Thread.java:811) Caused by: ERROR nospc: nospc.U at org.apache.derby.impl.store.raw.data.StoredPage.logRow(StoredPage.java:4134) at org.apache.derby.impl.store.raw.data.UpdateOperation.writeOptionalDataToBuffer(UpdateOperation.java:255) at org.apache.derby.impl.store.raw.data.UpdateOperation.<init>(UpdateOperation.java:106) at org.apache.derby.impl.store.raw.data.LoggableActions.actionUpdate(LoggableActions.java:80) at org.apache.derby.impl.store.raw.data.StoredPage.doUpdateAtSlot(StoredPage.java:8579) at org.apache.derby.impl.store.raw.data.BasePage.updateAtSlot(BasePage.java:1062) at org.apache.derby.impl.store.access.conglomerate.GenericConglomerateController.replace(GenericConglomerateController.java:472) at org.apache.derby.impl.sql.execute.RowChangerImpl.updateRow(RowChangerImpl.java:523) at org.apache.derby.impl.sql.execute.UpdateResultSet.collectAffectedRows(UpdateResultSet.java:561) at org.apache.derby.impl.sql.execute.UpdateResultSet.open(UpdateResultSet.java:254) at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(GenericPreparedStatement.java:416) at org.apache.derby.impl.sql.GenericPreparedStatement.execute(GenericPreparedStatement.java:297) at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1235) ... 4 more
          Mike Matrigali made changes -
          Link This issue relates to DERBY-4577 [ DERBY-4577 ]
          Mike Matrigali made changes -
          Link This issue duplicates DERBY-4577 [ DERBY-4577 ]
          Hide
          Mike Matrigali added a comment -

          resolving this issue as duplicate of DERBY-4577. Ran the most recently attached test case against the DERBY-4577 and could not reproduce the problem. On the same machine the bug would repro within an hour on every try.

          Show
          Mike Matrigali added a comment - resolving this issue as duplicate of DERBY-4577 . Ran the most recently attached test case against the DERBY-4577 and could not reproduce the problem. On the same machine the bug would repro within an hour on every try.
          Mike Matrigali made changes -
          Status Reopened [ 4 ] Resolved [ 5 ]
          Resolution Duplicate [ 3 ]
          Rick Hillegas made changes -
          Link This issue is related to DERBY-2254 [ DERBY-2254 ]
          Hide
          Knut Anders Hatlen added a comment -

          [bulk update] Close all resolved issues that haven't been updated for more than one year.

          Show
          Knut Anders Hatlen added a comment - [bulk update] Close all resolved issues that haven't been updated for more than one year.
          Knut Anders Hatlen made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Gavin made changes -
          Workflow jira [ 12395598 ] Default workflow, editable Closed status [ 12802798 ]
          Transition Time In Source Status Execution Times Last Executer Last Execution Date
          Open Open Closed Closed
          885d 14h 4m 1 Rick Hillegas 06/Jul/09 20:36
          Closed Closed Reopened Reopened
          209d 20h 2m 1 Knut Anders Hatlen 01/Feb/10 15:39
          Reopened Reopened Resolved Resolved
          148d 1h 16m 1 Mike Matrigali 29/Jun/10 17:55
          Resolved Resolved Closed Closed
          1083d 16h 24m 1 Knut Anders Hatlen 17/Jun/13 10:19

            People

            • Assignee:
              Unassigned
              Reporter:
              Andrew McIntyre
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development