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:
- 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).
- Search results are inconsistent/incomplete although a full ES indexing is scheduled and runs every night.
- The crm’s log reports a slow sql query performing the search
- 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.