AnsweredAssumed Answered

Solr report - how to interpret

Question asked by loftux Moderator on Feb 15, 2012
Latest reply on Feb 20, 2012 by andy
If I run https://servername:8443/solr/admin/cores?action=REPORT I get a report like
<response>
<lst name="responseHeader">
<int name="status">0</int>
<int name="QTime">185419</int>
</lst>
<lst name="report">
<lst name="alfresco">
<long name="DB transaction count">13740</long>
<long name="DB acl transaction count">191</long>
<long name="Count of duplicated transactions in the index">0</long>
<long name="Count of duplicated acl transactions in the index">0</long>
<long name="Count of transactions in the index but not the DB">1478</long>
<long name="First transaction in the index but not the DB">716</long>
<long name="Count of acl transactions in the index but not the DB">0</long>
<long name="Count of missing transactions from the Index">0</long>
<long name="Count of missing acl transactions from the Index">0</long>
<long name="Index transaction count">15218</long>
<long name="Index acl transaction count">191</long>
<long name="Index unique transaction count">15218</long>
<long name="Index unique acl transaction count">191</long>
<long name="Index leaf count">12292</long>
<long name="Count of duplicate leaves in the index">0</long>
<long name="Last index commit time">1329291823222</long>
<str name="Last Index commit date">2012-02-15T08:43:43</str>
<long name="Last TX id before holes">6571433</long>
</lst>
<lst name="archive">
<long name="DB transaction count">13740</long>
<long name="DB acl transaction count">191</long>
<long name="Count of duplicated transactions in the index">0</long>
<long name="Count of duplicated acl transactions in the index">0</long>
<long name="Count of transactions in the index but not the DB">1478</long>
<long name="First transaction in the index but not the DB">716</long>
<long name="Count of acl transactions in the index but not the DB">0</long>
<long name="Count of missing transactions from the Index">0</long>
<long name="Count of missing acl transactions from the Index">0</long>
<long name="Index transaction count">15218</long>
<long name="Index acl transaction count">191</long>
<long name="Index unique transaction count">15218</long>
<long name="Index unique acl transaction count">191</long>
<long name="Index leaf count">5610</long>
<long name="Count of duplicate leaves in the index">0</long>
<long name="Last index commit time">1329291823222</long>
<str name="Last Index commit date">2012-02-15T08:43:43</str>
<long name="Last TX id before holes">6571433</long>
</lst>
</lst>
</response>
I need some help here on how to interpret some data in the report
"Count of transactions in the index but not the DB" 1478 - Why can this be, and is it a sign of serious error?
"First transaction in the index but not the DB" 716 - This I guess is complementary information to the above.
These are the ones I need to understand for the moment, but it could be useful if each post and what to make of them is added to http://wiki.alfresco.com/wiki/Alfresco_And_SOLR#Checking_the_status_of_the_SOLR_index (I could help with that if I had the answer).

Outcomes