AnsweredAssumed Answered

Solr - Missing transactions indexing slow

Question asked by loftux Moderator on Nov 17, 2011
Latest reply on Nov 22, 2011 by loftux
I'm seeing this in https://servername:8443/solr/admin/cores?action=REPORT&wt=xml

<response>
<lst name="responseHeader">
<int name="status">0</int>
<int name="QTime">454</int>
</lst>
<lst name="report">
<lst name="alfresco">
<long name="DB transaction count">3840</long>
<long name="DB acl transaction count">56</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">0</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">2472</long>
<long name="First transaction missing from the Index">15688</long>
<long name="Count of missing acl transactions from the Index">0</long>
<long name="Index transaction count">1368</long>
<long name="Index acl transaction count">56</long>
<long name="Index unique transaction count">1368</long>
<long name="Index unique acl transaction count">56</long>
<long name="Index leaf count">2031</long>
<long name="Count of duplicate leaves in the index">0</long>
<long name="Last index commit time">1318320543887</long>
<str name="Last Index commit date">2011-10-11T10:09:03</str>
<long name="Last TX id before holes">15687</long>
</lst>
<lst name="archive">
<long name="DB transaction count">3840</long>
<long name="DB acl transaction count">56</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">0</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">3840</long>
<long name="Index acl transaction count">56</long>
<long name="Index unique transaction count">3840</long>
<long name="Index unique acl transaction count">56</long>
<long name="Index leaf count">1766</long>
<long name="Count of duplicate leaves in the index">0</long>
<long name="Last index commit time">1321515768375</long>
<str name="Last Index commit date">2011-11-17T08:42:48</str>
<long name="Last TX id before holes">21961</long>
</lst>
</lst>
</response>
The issue here is <long name="Count of missing transactions from the Index">2472</long>
it has just changed the number slightly, and it has been so for almost 24 hours.

What is going on (or actually not going on)?
I constantly see around 50% cpu usage. Turned of solr and on lucene, and it indexes all in very short time, but solr is unusable.
What kind of debugging can I turn on to research this issue further?
The machine is rhel 6.1, mysql 5.1, tomcat 6.0.32 on the same machine.

Outcomes