You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Andrew McIntyre (JIRA)" <ji...@apache.org> on 2007/02/02 06:33:05 UTC
[jira] Created: (DERBY-2286) Exception NoSpaceOnPage does not
provide SQLState or exception text
Exception NoSpaceOnPage does not provide SQLState or exception text
-------------------------------------------------------------------
Key: DERBY-2286
URL: https://issues.apache.org/jira/browse/DERBY-2286
Project: Derby
Issue Type: Bug
Components: Store
Affects Versions: 10.2.2.0, 10.2.1.6, 10.1.3.1
Reporter: Andrew McIntyre
Priority: Minor
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.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Reopened: (DERBY-2286) Exception NoSpaceOnPage does not
provide SQLState or exception text
Posted by "Knut Anders Hatlen (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2286?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Knut Anders Hatlen reopened DERBY-2286:
---------------------------------------
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.
> Exception NoSpaceOnPage does not provide SQLState or exception text
> -------------------------------------------------------------------
>
> Key: DERBY-2286
> URL: https://issues.apache.org/jira/browse/DERBY-2286
> Project: Derby
> Issue Type: Bug
> Components: Store
> Affects Versions: 10.1.3.1, 10.2.1.6, 10.2.2.0, 10.5.3.0
> Reporter: Andrew McIntyre
> Priority: Minor
> Attachments: NoSpaceBug.java
>
>
> 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.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-2286) Exception NoSpaceOnPage does not
provide SQLState or exception text
Posted by "Mike Matrigali (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2286?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Mike Matrigali updated DERBY-2286:
----------------------------------
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.
> Exception NoSpaceOnPage does not provide SQLState or exception text
> -------------------------------------------------------------------
>
> Key: DERBY-2286
> URL: https://issues.apache.org/jira/browse/DERBY-2286
> Project: Derby
> Issue Type: Bug
> Components: Store
> Affects Versions: 10.1.3.1, 10.2.1.6, 10.2.2.0, 10.5.3.0
> Reporter: Andrew McIntyre
> Priority: Minor
> Attachments: NoSpaceBug.java
>
>
> 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.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-2286) Exception NoSpaceOnPage does not
provide SQLState or exception text
Posted by "Mike Matrigali (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2286?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Mike Matrigali updated DERBY-2286:
----------------------------------
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.
> Exception NoSpaceOnPage does not provide SQLState or exception text
> -------------------------------------------------------------------
>
> Key: DERBY-2286
> URL: https://issues.apache.org/jira/browse/DERBY-2286
> Project: Derby
> Issue Type: Bug
> Components: Store
> Affects Versions: 10.1.3.1, 10.2.1.6, 10.2.2.0, 10.5.3.0
> Reporter: Andrew McIntyre
> Priority: Minor
> Attachments: NoSpaceBug.java
>
>
> 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.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-2286) Exception NoSpaceOnPage does not
provide SQLState or exception text
Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2286?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12614808#action_12614808 ]
Kathey Marsden commented on DERBY-2286:
---------------------------------------
Do you have a way to reproduce this error:? There may be a more serious bug than just the message text and SQLState missing.
> Exception NoSpaceOnPage does not provide SQLState or exception text
> -------------------------------------------------------------------
>
> Key: DERBY-2286
> URL: https://issues.apache.org/jira/browse/DERBY-2286
> Project: Derby
> Issue Type: Bug
> Components: Store
> Affects Versions: 10.1.3.1, 10.2.1.6, 10.2.2.0
> Reporter: Andrew McIntyre
> Priority: Minor
>
> 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.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-2286) Exception NoSpaceOnPage does not
provide SQLState or exception text
Posted by "Karl Pietrzak (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2286?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12618303#action_12618303 ]
Karl Pietrzak commented on DERBY-2286:
--------------------------------------
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.
> Exception NoSpaceOnPage does not provide SQLState or exception text
> -------------------------------------------------------------------
>
> Key: DERBY-2286
> URL: https://issues.apache.org/jira/browse/DERBY-2286
> Project: Derby
> Issue Type: Bug
> Components: Store
> Affects Versions: 10.1.3.1, 10.2.1.6, 10.2.2.0
> Reporter: Andrew McIntyre
> Priority: Minor
>
> 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.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Resolved: (DERBY-2286) Exception NoSpaceOnPage does not
provide SQLState or exception text
Posted by "Mike Matrigali (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2286?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Mike Matrigali resolved DERBY-2286.
-----------------------------------
Resolution: Duplicate
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.
> Exception NoSpaceOnPage does not provide SQLState or exception text
> -------------------------------------------------------------------
>
> Key: DERBY-2286
> URL: https://issues.apache.org/jira/browse/DERBY-2286
> Project: Derby
> Issue Type: Bug
> Components: Store
> Affects Versions: 10.1.3.1, 10.2.1.6, 10.2.2.0, 10.5.3.0
> Reporter: Andrew McIntyre
> Priority: Minor
> Attachments: NoSpaceBug.java
>
>
> 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.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-2286) Exception NoSpaceOnPage does not
provide SQLState or exception text
Posted by "Jim Rayfield (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2286?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12831835#action_12831835 ]
Jim Rayfield commented on DERBY-2286:
-------------------------------------
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
> Exception NoSpaceOnPage does not provide SQLState or exception text
> -------------------------------------------------------------------
>
> Key: DERBY-2286
> URL: https://issues.apache.org/jira/browse/DERBY-2286
> Project: Derby
> Issue Type: Bug
> Components: Store
> Affects Versions: 10.1.3.1, 10.2.1.6, 10.2.2.0, 10.5.3.0
> Reporter: Andrew McIntyre
> Priority: Minor
> Attachments: NoSpaceBug.java
>
>
> 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.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-2286) Exception NoSpaceOnPage does not
provide SQLState or exception text
Posted by "Karl Pietrzak (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2286?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12614802#action_12614802 ]
Karl Pietrzak commented on DERBY-2286:
--------------------------------------
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>
> Exception NoSpaceOnPage does not provide SQLState or exception text
> -------------------------------------------------------------------
>
> Key: DERBY-2286
> URL: https://issues.apache.org/jira/browse/DERBY-2286
> Project: Derby
> Issue Type: Bug
> Components: Store
> Affects Versions: 10.1.3.1, 10.2.1.6, 10.2.2.0
> Reporter: Andrew McIntyre
> Priority: Minor
>
> 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.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-2286) Exception NoSpaceOnPage does not
provide SQLState or exception text
Posted by "Knut Anders Hatlen (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2286?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12830574#action_12830574 ]
Knut Anders Hatlen commented on DERBY-2286:
-------------------------------------------
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.
> Exception NoSpaceOnPage does not provide SQLState or exception text
> -------------------------------------------------------------------
>
> Key: DERBY-2286
> URL: https://issues.apache.org/jira/browse/DERBY-2286
> Project: Derby
> Issue Type: Bug
> Components: Store
> Affects Versions: 10.1.3.1, 10.2.1.6, 10.2.2.0, 10.5.3.0
> Reporter: Andrew McIntyre
> Priority: Minor
> Attachments: NoSpaceBug.java
>
>
> 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.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Closed: (DERBY-2286) Exception NoSpaceOnPage does not
provide SQLState or exception text
Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2286?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rick Hillegas closed DERBY-2286.
--------------------------------
Resolution: Won't Fix
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.
> Exception NoSpaceOnPage does not provide SQLState or exception text
> -------------------------------------------------------------------
>
> Key: DERBY-2286
> URL: https://issues.apache.org/jira/browse/DERBY-2286
> Project: Derby
> Issue Type: Bug
> Components: Store
> Affects Versions: 10.1.3.1, 10.2.1.6, 10.2.2.0
> Reporter: Andrew McIntyre
> Priority: Minor
>
> 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.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-2286) Exception NoSpaceOnPage does not
provide SQLState or exception text
Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2286?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12727731#action_12727731 ]
Kathey Marsden commented on DERBY-2286:
---------------------------------------
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.
> Exception NoSpaceOnPage does not provide SQLState or exception text
> -------------------------------------------------------------------
>
> Key: DERBY-2286
> URL: https://issues.apache.org/jira/browse/DERBY-2286
> Project: Derby
> Issue Type: Bug
> Components: Store
> Affects Versions: 10.1.3.1, 10.2.1.6, 10.2.2.0
> Reporter: Andrew McIntyre
> Priority: Minor
>
> 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.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-2286) Exception NoSpaceOnPage does not
provide SQLState or exception text
Posted by "Mike Matrigali (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2286?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Mike Matrigali updated DERBY-2286:
----------------------------------
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());
> Exception NoSpaceOnPage does not provide SQLState or exception text
> -------------------------------------------------------------------
>
> Key: DERBY-2286
> URL: https://issues.apache.org/jira/browse/DERBY-2286
> Project: Derby
> Issue Type: Bug
> Components: Store
> Affects Versions: 10.1.3.1, 10.2.1.6, 10.2.2.0, 10.5.3.0
> Reporter: Andrew McIntyre
> Priority: Minor
> Attachments: NoSpaceBug.java
>
>
> 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.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-2286) Exception NoSpaceOnPage does not
provide SQLState or exception text
Posted by "Karl Pietrzak (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2286?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12614877#action_12614877 ]
Karl Pietrzak commented on DERBY-2286:
--------------------------------------
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.
> Exception NoSpaceOnPage does not provide SQLState or exception text
> -------------------------------------------------------------------
>
> Key: DERBY-2286
> URL: https://issues.apache.org/jira/browse/DERBY-2286
> Project: Derby
> Issue Type: Bug
> Components: Store
> Affects Versions: 10.1.3.1, 10.2.1.6, 10.2.2.0
> Reporter: Andrew McIntyre
> Priority: Minor
>
> 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.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-2286) Exception NoSpaceOnPage does not
provide SQLState or exception text
Posted by "Knut Anders Hatlen (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2286?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Knut Anders Hatlen updated DERBY-2286:
--------------------------------------
Issue & fix info: [Repro attached]
Affects Version/s: 10.5.3.0
> Exception NoSpaceOnPage does not provide SQLState or exception text
> -------------------------------------------------------------------
>
> Key: DERBY-2286
> URL: https://issues.apache.org/jira/browse/DERBY-2286
> Project: Derby
> Issue Type: Bug
> Components: Store
> Affects Versions: 10.1.3.1, 10.2.1.6, 10.2.2.0, 10.5.3.0
> Reporter: Andrew McIntyre
> Priority: Minor
> Attachments: NoSpaceBug.java
>
>
> 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.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-2286) Exception NoSpaceOnPage does not
provide SQLState or exception text
Posted by "Jim Rayfield (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2286?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12806567#action_12806567 ]
Jim Rayfield commented on DERBY-2286:
-------------------------------------
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.
> Exception NoSpaceOnPage does not provide SQLState or exception text
> -------------------------------------------------------------------
>
> Key: DERBY-2286
> URL: https://issues.apache.org/jira/browse/DERBY-2286
> Project: Derby
> Issue Type: Bug
> Components: Store
> Affects Versions: 10.1.3.1, 10.2.1.6, 10.2.2.0
> Reporter: Andrew McIntyre
> Priority: Minor
>
> 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.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-2286) Exception NoSpaceOnPage does not
provide SQLState or exception text
Posted by "Jim Rayfield (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2286?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jim Rayfield updated DERBY-2286:
--------------------------------
Attachment: NoSpaceBug.java
Reproduces the bug in about an hour on a 2.67GHz Linux multicore system.
> Exception NoSpaceOnPage does not provide SQLState or exception text
> -------------------------------------------------------------------
>
> Key: DERBY-2286
> URL: https://issues.apache.org/jira/browse/DERBY-2286
> Project: Derby
> Issue Type: Bug
> Components: Store
> Affects Versions: 10.1.3.1, 10.2.1.6, 10.2.2.0
> Reporter: Andrew McIntyre
> Priority: Minor
> Attachments: NoSpaceBug.java
>
>
> 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.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-2286) Exception NoSpaceOnPage does not
provide SQLState or exception text
Posted by "Knut Anders Hatlen (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2286?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12828157#action_12828157 ]
Knut Anders Hatlen commented on DERBY-2286:
-------------------------------------------
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.
> Exception NoSpaceOnPage does not provide SQLState or exception text
> -------------------------------------------------------------------
>
> Key: DERBY-2286
> URL: https://issues.apache.org/jira/browse/DERBY-2286
> Project: Derby
> Issue Type: Bug
> Components: Store
> Affects Versions: 10.1.3.1, 10.2.1.6, 10.2.2.0, 10.5.3.0
> Reporter: Andrew McIntyre
> Priority: Minor
> Attachments: NoSpaceBug.java
>
>
> 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.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-2286) Exception NoSpaceOnPage does not
provide SQLState or exception text
Posted by "Suresh Thalamati (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2286?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12469915 ]
Suresh Thalamati commented on DERBY-2286:
-----------------------------------------
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.
> Exception NoSpaceOnPage does not provide SQLState or exception text
> -------------------------------------------------------------------
>
> Key: DERBY-2286
> URL: https://issues.apache.org/jira/browse/DERBY-2286
> Project: Derby
> Issue Type: Bug
> Components: Store
> Affects Versions: 10.1.3.1, 10.2.1.6, 10.2.2.0
> Reporter: Andrew McIntyre
> Priority: Minor
>
> 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.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.