CRM doesn't search using ES even though it is enabled and on-line.

Hello all,

I performed an upgrade from 7.10.8 to 7.11.6 in my testing environment and everything worked as expected. When I replicated the upgrade in my production instance, even though I followed the guide (set the docker-compose service, enabled the ES search engine, etc), I’m 99% sure the system is still using basic/advanced search instead.

My evidence for this last statement is that:

  1. The user interface shown is the one used for Basic/Advanced search instead of the ES’s one (which I saw in my testing evironment).
  2. Search results are inconsistent/incomplete although a full ES indexing is scheduled and runs every night.
  3. The crm’s log reports a slow sql query performing the search
  4. The search is indeed slow, not what one would expect from ES

My environment settings are as follows:

SuiteCRM Version: 7.11.6
PHP Version: 7.0.33-0+deb9u3
Apache Version: Apache/2.4.25 (Debian)
DB: 10.0.35-MariaDB-1~xenial

None of my logs (suitecrm’s logs, php/apache’s logs, docker-compose’s logs) show anything suspicious apart from the already mentioned slow SQL search query. I also include screenshot from the admin module’s relevant configurations.

Any help is greatly thanked in advance. Greetings.

Have you enabled the new search engine from within the admin panel?

Thanks for the reply, samus-aran!

Yes I did (I guess i messed up the attached images :S ).