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] [Created] (DERBY-5273) enhance SYSCS_CHECK_TABLE to check every page in the database
Date Fri, 10 Jun 2011 21:37:59 GMT
enhance SYSCS_CHECK_TABLE to check every page in the database
-------------------------------------------------------------

                 Key: DERBY-5273
                 URL: https://issues.apache.org/jira/browse/DERBY-5273
             Project: Derby
          Issue Type: Improvement
    Affects Versions: 10.8.1.2
            Reporter: Mike Matrigali


The current consistency checker operates at a logical layer.  It checks that indexes and base
user tables are consistent.  In doing so
it checks most of the pages in the database, but not all.  I don't think it checks blob/clob
chains.  I know it does not check free pages.

One simple enhancement would be to just read every page of every file in the database into
the cache.  This would at least check that
all pages were valid.   I believe code to do this can either be copied or shared with the
backup code which at a low level reads each page
from disk into cache and then writes it to the backup directory.  

DERBY-5266 looks like a case where the consistency checker missed an invalid page that backup
is subsequently finding.  It would
be great if anyone has an example of a database that they can post that has a similar problem
so that we can test a real live problem, 
rather than making one up.  

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message