topic Solr - Missing transactions indexing slow in Alfresco Archive

Solr - Missing transactions indexing slow

loftux — Thu, 17 Nov 2011 15:38:48 GMT

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 transact

Re: Solr - Missing transactions indexing slow

loftux — Thu, 17 Nov 2011 16:42:58 GMT

Andy just updated the wiki page http://wiki.alfresco.com/wiki/Alfresco_And_SOLR with some Logging howto.

Following that, I have

Nov 17, 2011 5:39:30 PM org.alfresco.solr.tracker.CoreTracker trackRepository
INFO: …. from Transaction [id=21961, commitTimeMs=1321515768375, updates=1, deletes=1]
Nov 17, 2011 5:39:30 PM org.alfresco.solr.tracker.CoreTracker trackRepository
INFO: …. to Transaction [id=21961, commitTimeMs=1321515768375, updates=1, deletes=1]‍‍‍‍

and

mysql> select max(id) from alf_transaction;
+———+
| max(id) |
+———+
|   21961 |
+———+‍‍‍‍‍‍

That is according to documentation, index is up to date, since transaction id is the latest. Still, why am I seeing missing transactions from index in the report page?

Re: Solr - Missing transactions indexing slow

loftux — Fri, 18 Nov 2011 07:08:54 GMT

I found the cause of the issue looking in tomcat/logs/catalina.out, that is where solr logs its errors.
The error i found was "Node without parents does not have root aspect", this post helped me resolve the issue, it involves doing direct changes to the db. There were 112 nodes in the db that had no root aspect, all created on the day for the upgrade. Since I didn't help out with the upgrade, I'm not sure if they are the result of failing patches during the upgrade.

Once past that error, it does take a long time to complete initial full indexing with solr compared to lucene. That I think may be due to https://forums.alfresco.com/en/viewtopic.php?f=14&t=41573 "alfresco 4.0.b overuse database", and that this user filed as issue https://issues.alfresco.com/jira/browse/ALF-11546.

Re: Solr - Missing transactions indexing slow

fstnboy — Tue, 22 Nov 2011 11:59:26 GMT

Hi Loftux,

Quick question. Which version of Alfresco are you using? Community or Enterprise? I'm struggling to get Solr working with Alfresco (I'm using Enterprise 4 Beta…)

Adei

Re: Solr - Missing transactions indexing slow

loftux — Tue, 22 Nov 2011 12:13:37 GMT

I'm using the Community, built from head r31944