topic Re: Solr Count of transactions in the index in Alfresco Archive

Solr Count of transactions in the index

babarlefou — Mon, 28 Jan 2013 19:03:13 GMT

Hello,I have a problem with my Solr index :- My index size on the disk (40G) is higher than the repository size (14G)- The "Count of transactions in the index" is not equal to 0 (about 58000).What is the solution to resolve there problems ? Reindex the repository ?ps : I use Alfresco 4.0d.Nicolas.

Re: Solr Count of transactions in the index

sujaypillai — Tue, 29 Jan 2013 03:03:45 GMT

Hello Nicolas,

I would suggest you to first hit the URL : http://<yourservername>:<portnumber>/solr/admin/cores?action=FIX to repair an unindexed or failed transaction. Please give it some time to FIX as the results may take some time to show up.

If that doesn't work then you should definitely go for a index rebuild.

Thanks,
Sujay

Re: Solr Count of transactions in the index

babarlefou — Thu, 31 Jan 2013 20:25:24 GMT

Hi,

My index was reindexed. After 1 day, I have 11 "Count of transactions in the index but not the database".

Do you know where it can come ?
How can I remove these entries ?
How do I remove a specific transaction in the index ?

Thanks.

Re: Solr Count of transactions in the index

andy — Mon, 04 Feb 2013 13:16:05 GMT

Hi

It is possible there are transactions in the index but not in the DB.
Transactions can become empty (if they contain one node and that node is updated later)
The repository will clear these out. At the moment SOLR does not go looking for empty transactions and remove them

So this is OK. You can use the FIX option if you want. The wiki page covers what the various parts of the REPORT
mean and how they can arise.

Andy

Re: Solr Count of transactions in the index

babarlefou — Mon, 04 Feb 2013 19:57:22 GMT

Hi,

Thank you for the response, I try it.