AEM Datastore Consistency Check

This check is not normally run on a regular basis but can be used to find problems in the external datastore. Two different checks exist, one in CRX Explorer and one in the JMX console.
The CRX Explorer method has the advantage of showing any referencing nodes using objects in the datastore but uses a higher level API and will not show issues in some situations - such as with any indexes stored in the datastore.
The JMX method will go through all of the nodes and so give more complete information - but cannot give any information on the nodes referencing problematic objects in the datastore.
CRX Explorer

• ●  Go to http://AEM-INSTANCE:AEM-PORT/crx/explorer
  
• ●  Click on Repository Configuration
  
• ●  Click on Check Repository
  
• ●  Check ​Data store consistency check
  
• ●  Click on Run
  
• ●  Wait for results
  

JMX

• ●  Go to http://AEM-INSTANCE:AEM-PORT/system/console/jmx/org.apache.jackrabbit.oak%3Aname%3DDocu ment+node+store+blob+garbage+collection%2Ctype%3DBlobGarbageCollection
  
• ●  Click on ​checkConsistency
  
• ●  Click on the ​Invoke button
  
• ●  Wait for the results