db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mike Matrigali (Updated) (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DERBY-5273) enhance SYSCS_CHECK_TABLE to check every page in the database
Date Thu, 16 Feb 2012 20:22:59 GMT

     [ https://issues.apache.org/jira/browse/DERBY-5273?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel

Mike Matrigali updated DERBY-5273:

    Component/s: Store
> 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
>          Components: Store
>    Affects Versions:
>            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.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira


View raw message