db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Db-derby Wiki] Update of "DatabaseConsistencyCheck" by KatheyMarsden
Date Tue, 17 May 2011 21:30:20 GMT
Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Db-derby Wiki" for change notification.

The "DatabaseConsistencyCheck" page has been changed by KatheyMarsden.
http://wiki.apache.org/db-derby/DatabaseConsistencyCheck?action=diff&rev1=4&rev2=5

--------------------------------------------------

  
   1. Continue to exclude problem tables from the select until it completes without exceptions.
 All tables have been checked.  The list of tables excluded are the ones that require rebuilding.
  
- SYSCS_CHECK_TABLE performs more checks in debug builds, so if the above procedure does not
reveal any inconsistencies and you still suspect something is wrong, you may want to repeat
the steps with a debug build of Derby.
+ SYSCS_CHECK_TABLE performs more checks in debug (sane)  builds, so if the above procedure
does not reveal any inconsistencies and you still suspect something is wrong, you may want
to repeat the steps with a debug build of Derby.
  
  === EXAMPLE : ===
  {{{
@@ -73, +73 @@

  6 rows selected
  }}}
  
+ == Identifying the Problematic Index With Just a Conglomerate Number ==
  
+ With an insane build if something very unexpected is wrong you may get 
+ just a NullPointerException or the errors will identify only the 
+ conglomerate number.   If this occurs, it is good to switch to 
+ a debug/sane  build which will provide more information. Use the lib debug 
+ distribution for your version from the derby downloads page and repeat the
+ process above. Now you may get an error that includes a Container and will reveal the conglomerate
number, in this case 7905:
+  {{{
+ .... ContainerHandle = 
+ BaseContainerHandle:(Container(0, 7905))' was thrown while 
+ evaluating an expression.
+ }}}
+ 
+ 
+ You can get the schema and index name with the following system table query.
+ 
+ {{{
+ SELECT C.CONGLOMERATENUMBER, C.CONGLOMERATENAME, S.SCHEMANAME  FROM SYS.SYSCONGLOMERATES
C, sys.sysschemas s  WHERE CONGLOMERATENUMBER = 7905 AND s.schemaid = C.schemaid ;
+ }}}
  
  == Repairing Corrupt Indexes found by the consistency check  ==
  

Mime
View raw message