db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mike Matrigali (JIRA)" <derby-...@db.apache.org>
Subject [jira] Created: (DERBY-692) improve post commit committed delete handling when system crashes
Date Tue, 08 Nov 2005 19:57:20 GMT
improve post commit committed delete handling when system crashes
-----------------------------------------------------------------

         Key: DERBY-692
         URL: http://issues.apache.org/jira/browse/DERBY-692
     Project: Derby
        Type: Improvement
  Components: Store  
    Versions: 10.0.2.0    
    Reporter: Mike Matrigali
    Priority: Minor


Currently  space reclamation of committed deleted rows is handled by queueing to an in memory
list a queue of work
items when certain conditions are noticed.  The usual condition is that the last row on a
page has been deleted.  If the
system crashes then this queue of work is lost.  Work could be done during recovery to try
to recover from this.  Some
possibilities include:
1) modify redo of  delete to queue post commit if appropriate
2) modify redo of abort of insert to queue post commit if appropriate
3) moditfy redo loop which finds page that needs no redo to check if all rows are delted and
queue post commit if appropriate.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


Mime
View raw message