topic Re: Mismatched Solr Index numDocs and Size on Disk in Alfresco Forum

Mismatched Solr Index numDocs and Size on Disk

alfresconewbie — Thu, 23 May 2019 11:05:47 GMT

Hi,Can anyone provide some advice please, we have a load balanced Alfresco CE 4 environment using Solr for indexing. The environment has two front end Alfresco servers, each pointing to their own solr server. The Alfresco environments are synchronized, however we are seeing a difference in the sta

Re: Mismatched Solr Index numDocs and Size on Disk

angelborroy — Thu, 23 May 2019 11:46:03 GMT

¿Alfresco CE 4.0.d?

Re: Mismatched Solr Index numDocs and Size on Disk

alfresconewbie — Thu, 23 May 2019 11:48:18 GMT

CE 4.2f

Re: Mismatched Solr Index numDocs and Size on Disk

angelborroy — Thu, 23 May 2019 11:49:46 GMT

That version does not support clustering, so probably it will be additional errors to the SOLR one you found.

Re: Mismatched Solr Index numDocs and Size on Disk

alfresconewbie — Thu, 23 May 2019 11:51:42 GMT

Clustering isn't configured, the two front end servers are load balanced without clustering. that isn't the problem.

Re: Mismatched Solr Index numDocs and Size on Disk

angelborroy — Thu, 23 May 2019 11:56:02 GMT

So you have 2 alfresco webapps using their own SOLR but sharing the same database and filesystem?

Re: Mismatched Solr Index numDocs and Size on Disk

alfresconewbie — Thu, 23 May 2019 11:58:48 GMT

yep.

Re: Mismatched Solr Index numDocs and Size on Disk

angelborroy — Thu, 23 May 2019 12:19:14 GMT

When you say that reindexing leaves the system unusable is because the process consumes a lot of resources, right?

If you cannot reindex to have both SOLR Indexes paired, then you can inspect every node to identify and classify the errors.

What looks weird is that maxDoc in Node 1 is 2... but 3... in Node 2. This number should be, more or less, the same, as is the max value for the ID in the table ALF_NODE.

Re: Mismatched Solr Index numDocs and Size on Disk

alfresconewbie — Thu, 23 May 2019 12:55:53 GMT

Yes, during a re-index the solr server doesn't have enough resource to respond to new queries in a timely manner.

The max value in the ALF_NODE table is: 18341293

Re: Mismatched Solr Index numDocs and Size on Disk

lcolorado — Thu, 23 May 2019 14:07:28 GMT

If you trust server 2, I would recommend copying the index directories from that server to server 1. This is a well known procedure during upgrades of clusters (that is, creating the index in a single server, and then copy the files to the other servers).

As usual, keep a backup copy of index 1, just in case. Ideally, you should stop both servers before getting the backup and performing the copy of the files. Although that may mean a short period of down time, it will be much faster that performing a full reindex.

Let us know how it went.

Cheers,

Luis