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
