db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mike Matrigali (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-2286) Exception NoSpaceOnPage does not provide SQLState or exception text
Date Mon, 01 Feb 2010 21:00:18 GMT

     [ 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.


Mime
View raw message