topic Solr report - how to interpret in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/solr-report-how-to-interpret/m-p/263771#M216901 <HTML><HEAD></HEAD><BODY><SPAN>If I run </SPAN><A href="https://servername:8443/solr/admin/cores?action=REPORT" rel="nofollow noopener noreferrer">https://servername:8443/solr/admin/cores?action=REPORT</A><SPAN> I get a report like</SPAN><BR /><PRE class="language-none line-numbers"><CODE>&lt;response&gt;<BR />&lt;lst name="responseHeader"&gt;<BR />&lt;int name="status"&gt;0&lt;/int&gt;<BR />&lt;int name="QTime"&gt;185419&lt;/int&gt;<BR />&lt;/lst&gt;<BR />&lt;lst name="report"&gt;<BR />&lt;lst name="alfresco"&gt;<BR />&lt;long name="DB transaction count"&gt;13740&lt;/long&gt;<BR />&lt;long name="DB acl transaction count"&gt;191&lt;/long&gt;<BR />&lt;long name="Count of duplicated transactions in the index"&gt;0&lt;/long&gt;<BR />&lt;long name="Count of duplicated acl transactions in the index"&gt;0&lt;/long&gt;<BR />&lt;long name="Count of transactions in the index but not the DB"&gt;1478&lt;/long&gt;<BR />&lt;long name="First transaction in the index but not the DB"&gt;716&lt;/long&gt;<BR />&lt;long name="Count of acl transactions in the index but not the DB"&gt;0&lt;/long&gt;<BR />&lt;long name="Count of missing transactions from the Index"&gt;0&lt;/long&gt;<BR />&lt;long name="Count of missing acl transactions from the Index"&gt;0&lt;/long&gt;<BR />&lt;long name="Index transaction count"&gt;15218&lt;/long&gt;<BR />&lt;long name="Index acl transaction count"&gt;191&lt;/long&gt;<BR />&lt;long name="Index unique transaction count"&gt;15218&lt;/long&gt;<BR />&lt;long name="Index unique acl transaction count"&gt;191&lt;/long&gt;<BR />&lt;long name="Index leaf count"&gt;12292&lt;/long&gt;<BR />&lt;long name="Count of duplicate leaves in the index"&gt;0&lt;/long&gt;<BR />&lt;long name="Last index commit time"&gt;1329291823222&lt;/long&gt;<BR />&lt;str name="Last Index commit date"&gt;2012-02-15T08:43:43&lt;/str&gt;<BR />&lt;long name="Last TX id before holes"&gt;6571433&lt;/long&gt;<BR />&lt;/lst&gt;<BR />&lt;lst name="archive"&gt;<BR />&lt;long name="DB transaction count"&gt;13740&lt;/long&gt;<BR />&lt;long name="DB acl transaction count"&gt;191&lt;/long&gt;<BR />&lt;long name="Count of duplicated transactions in the index"&gt;0&lt;/long&gt;<BR />&lt;long name="Count of duplicated acl transactions in the index"&gt;0&lt;/long&gt;<BR />&lt;long name="Count of transactions in the index but not the DB"&gt;1478&lt;/long&gt;<BR />&lt;long name="First transaction in the index but not the DB"&gt;716&lt;/long&gt;<BR />&lt;long name="Count of acl transactions in the index but not the DB"&gt;0&lt;/long&gt;<BR />&lt;long name="Count of missing transactions from the Index"&gt;0&lt;/long&gt;<BR />&lt;long name="Count of missing acl transactions from the Index"&gt;0&lt;/long&gt;<BR />&lt;long name="Index transaction count"&gt;15218&lt;/long&gt;<BR />&lt;long name="Index acl transaction count"&gt;191&lt;/long&gt;<BR />&lt;long name="Index unique transaction count"&gt;15218&lt;/long&gt;<BR />&lt;long name="Index unique acl transaction count"&gt;191&lt;/long&gt;<BR />&lt;long name="Index leaf count"&gt;5610&lt;/long&gt;<BR />&lt;long name="Count of duplicate leaves in the index"&gt;0&lt;/long&gt;<BR />&lt;long name="Last index commit time"&gt;1329291823222&lt;/long&gt;<BR />&lt;str name="Last Index commit date"&gt;2012-02-15T08:43:43&lt;/str&gt;<BR />&lt;long name="Last TX id before holes"&gt;6571433&lt;/long&gt;<BR />&lt;/lst&gt;<BR />&lt;/lst&gt;<BR />&lt;/response&gt;<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><SPAN>I need some help here on how to interpret some data in the report</SPAN><BR /><SPAN>"Count of transactions in the index but not the DB" 1478 - Why can this be, and is it a sign of serious error?</SPAN><BR /><SPAN>"First transaction in the index but not the DB" 716 - This I guess is complementary information to the above.</SPAN><BR /><SPAN>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 </SPAN><A href="http://wiki.alfresco.com/wiki/Alfresco_And_SOLR#Checking_the_status_of_the_SOLR_index" rel="nofollow noopener noreferrer">http://wiki.alfresco.com/wiki/Alfresco_And_SOLR#Checking_the_status_of_the_SOLR_index</A><SPAN> (I could help with that if I had the answer).</SPAN></BODY></HTML> Wed, 15 Feb 2012 08:16:22 GMT loftux 2012-02-15T08:16:22Z Solr report - how to interpret https://connect.hyland.com/t5/alfresco-archive/solr-report-how-to-interpret/m-p/263771#M216901 If I run https://servername:8443/solr/admin/cores?action=REPORT I get a report like&lt;response&gt;&lt;lst name="responseHeader"&gt;&lt;int name="status"&gt;0&lt;/int&gt;&lt;int name="QTime"&gt;185419&lt;/int&gt;&lt;/lst&gt;&lt;lst name="report"&gt;&lt;lst name="alfresco"&gt;&lt;long name="DB transa Wed, 15 Feb 2012 08:16:22 GMT https://connect.hyland.com/t5/alfresco-archive/solr-report-how-to-interpret/m-p/263771#M216901 loftux 2012-02-15T08:16:22Z Re: Solr report - how to interpret https://connect.hyland.com/t5/alfresco-archive/solr-report-how-to-interpret/m-p/263772#M216902 <HTML><HEAD></HEAD><BODY><SPAN>Hi</SPAN><BR /><BR /><SPAN>I have added the extra information to the Wiki.</SPAN><BR /><BR /><SPAN>"Count of transactions in the index but not the DB" 1478 </SPAN><BR /><SPAN>"First transaction in the index but not the DB" 716</SPAN><BR /><BR /><SPAN>This can mean your index does not match the DB (which we should check for at start up using the first TXN)</SPAN><BR /><SPAN>Emtpy transactions can be purged from the repo (and still remain in the index) with no related docs.</SPAN><BR /><SPAN>This is no issue.</SPAN><BR /><SPAN>You can check the doc count on the DB or directly against the index using INTXID=716</SPAN><BR /><BR /><SPAN>It is also possible this transaction has been skipped due to a known bug (there are a couple)</SPAN><BR /><SPAN>Using the FIX option will sort this out.</SPAN><BR /><SPAN>Normally the tracker will stop and retry rather then skip past and never return.</SPAN><BR /><SPAN>Again this may change. </SPAN><BR /><BR /><SPAN>At some point we will add TX purging to match the DB and in teh report check for "real" problems.</SPAN><BR /><BR /><SPAN>Andy</SPAN></BODY></HTML> Mon, 20 Feb 2012 14:18:14 GMT https://connect.hyland.com/t5/alfresco-archive/solr-report-how-to-interpret/m-p/263772#M216902 andy 2012-02-20T14:18:14Z