Thread Details
  • State Verified Answer
  • Replies 3 replies
  • Subscribers 368 subscribers
  • Views 2109 views
  • Users 0 members are here
Forum Actions

v8 upgrade problem w/ Elasticsearch

Francesca Shiekh

I am trying to upgrade 7.9.4 to 8.0.1 SugarPro.

Sugar 8.0.1 supports, and requires, an Elasticsearch upgrade.

Based on this:

http://support.sugarcrm.com/Resources/Supported_Platforms/Sugar_8.0.x_Supported_Platforms/ 

We went with ES 6.2.1 for Sugar 8.0.1

Sysadmin set up a new VM for me with Elasticsearch 6.2.1 following instructions here:

http://support.sugarcrm.com/Knowledge_Base/Installation_Upgrade/Installing_and_Administering_Elasticsearch/#ES_Configura… 

When I attempt to point 7.9.4 to the new VM with ES 6.2.1 I get the following errors:

   

Tue Nov  6 14:12:45 2018 [9177][2053ed63-d2dc-52e8-0049-4ddab9fc33f1][FATAL] Elasticsearch: connection went away to elasticsearch-tst.mycompany.com:9200

Tue Nov  6 14:12:45 2018 [9177][2053ed63-d2dc-52e8-0049-4ddab9fc33f1][FATAL] Elasticsearch verify conn: failure

Tue Nov  6 14:12:45 2018 [9177][2053ed63-d2dc-52e8-0049-4ddab9fc33f1][FATAL] Elasticsearch no longer available

 

We verified that the sugar application server can see the ES server.

 

Now, I understand that 7.9.4 is not compatible with ES 6.2.1 but following the upgrade instructions it is recommended to point Sugar to a new, upgraded ES before upgrading to v8 and reindex - which is what I'm trying to do.. 

 

The errors seem to come from:

/var/www/html/sugarcrm/src/Elasticsearch/Adapter/Client.php

public function verifyConnectivity

and

public function onConnectionFailure

Now that same script has 

protected $allowedVersions = [
   '1.4',
   '1.7',
];

 

So, how do I get 7.9.4 to see ES 6.2.1?

What are my sysadmin and I missing?

 

thanks,

FrancescaS

  • 0

    Hi FrancescaS,

    When I did this, I first upgraded my SugarInstance with the new 8.01 version and then once the new Sugar instance was up I changed to point to the new Elastic Search 6.2.1

    I also found this, maybe it will help:

    select * from config where name like '%fts%';

    You could disable Elastic by changing the following setting on the config database table to '1', and then set it back to '0' to re-enable it:

    https://gist.github.com/esimonetti?page=1

    PC

  • 0 in reply to Peter Chimienti

    Peter Chimienti How do you upgrade Sugar before upgrading ElasitcSearch?

    If I try to do that I get an error:

    ERROR: Elastic version is unknown or unsupported!

    I get the same error if I try 7.9.4 to 8.0.1 w/ ES 5.6.13

     

    The value for category=info and name=fts_down on my instance is already 1.

    How is that setting used?

    Enrico Simonetti, Matt Marum what is the appropriate upgrade path from Sugar 7.9.4 to sugar 8.0.1?

    In my development environment some months ago I went from 7.9.4 to 8.0.0 (ES 5.6) then to 8.0.1 still on ES 5.6, do I need to follow that route again for this to work?

    FrancescaS

  • 0 in reply to Peter Chimienti

    There was an actual problem with the ES installation - I don't have the details though.
    We set up a VM with ES 5.6, pointed TST to that new ES (it did warn of an error when the setting was saved). Then ran the upgrade.

    The upgrade is now running.

    FrancescaS