Update problem 5.7.11 -> 5.8.5

[peterberlin]

Hallo,
To perform this update ESPO has reported that MySQL must be updated. Now it is the version 5.7.0 .
An update of ESPO is rejected. See log file

[2020-05-25 20:03:13] Espo.DEBUG: Installation process [5ecc2481905e4d393]: start upload the package. [] []
[2020-05-25 20:03:14] Espo.DEBUG: Installation process [5ecc2481905e4d393]: end upload the package. [] []
[2020-05-25 20:03:14] Espo.INFO: Installation process [5ecc2481905e4d393]: Start "init" step. [] []
[2020-05-25 20:03:14] Espo.ERROR: Database rebuild failure, details: SQLSTATE[HY000]: General error: 1682 Native table 'performance_schema'.'session_variables' has the wrong structure. [] []
[2020-05-25 20:03:14] Espo.INFO: Installer: Restore previous files. [] []
[2020-05-25 20:03:15] Espo.ERROR: Upgrade Error: Error: Rebuild is failed. Fix all errors before upgrade. [] []
[2020-05-25 20:04:01] Espo.DEBUG: BPM: processPendingFlows [] []
[2020-05-25 20:05:02] Espo.DEBUG: BPM: processPendingFlows [] []
[2020-05-25 20:06:02] Espo.DEBUG: BPM: processPendingFlows [] []
[2020-05-25 20:06:12] Espo.ERROR: Uncaught Exception PDOException: "SQLSTATE[HY000]: General error: 1682 Native table 'performance_schema'.'session_variables' has the wrong structure" at /var/www/html/crm/application/Espo/Core/DataManager.php line 209 {"exception":"[object] (PDOException(code: HY000): SQLSTATE[HY000]: General error: 1682 Native table 'performance_schema'.'session_variables' has the wrong structure at /var/www/html/crm/application/Espo/Core/DataManager.php:209)"} []
[2020-05-25 20:06:23] Espo.DEBUG: Installation process [5ecc253ff3f4617fb]: start upload the package. [] []
[2020-05-25 20:06:24] Espo.DEBUG: Installation process [5ecc253ff3f4617fb]: end upload the package. [] []
[2020-05-25 20:06:25] Espo.INFO: Installation process [5ecc253ff3f4617fb]: Start "init" step. [] []
[2020-05-25 20:06:25] Espo.ERROR: Database rebuild failure, details: SQLSTATE[HY000]: General error: 1682 Native table 'performance_schema'.'session_variables' has the wrong structure. [] []
[2020-05-25 20:06:25] Espo.INFO: Installer: Restore previous files. [] []
[2020-05-25 20:06:25] Espo.ERROR: Upgrade Error: Error: Rebuild is failed. Fix all errors before upgrade. [] []

What can we do?
peter

[Maximus]

Hi Peter.
Did you try to upgrade it through CLI?

[peterberlin]

Hi Maximus,
we tried that too. see logfile above.

[Maximus]

Do you mean that you tried to upgrade with:

php command.php upgrade -y --file="EspoCRM-upgrade.zip"

I asked about a step by step way:

php command.php upgrade

[peterberlin]

Does not work:

2020-05-26 08:37:28] Espo.DEBUG: Installation process [5eccd548a29c2f4d1]: start upload the package. [] []
[2020-05-26 08:37:29] Espo.DEBUG: Installation process [5eccd548a29c2f4d1]: end upload the package. [] []
[2020-05-26 08:37:29] Espo.INFO: Installation process [5eccd548a29c2f4d1]: Start "init" step. [] []
[2020-05-26 08:37:29] Espo.ERROR: Database rebuild failure, details: SQLSTATE[HY000]: General error: 1682 Native table 'performance_schema'.'session_variables' has the wrong structure. [] []
[2020-05-26 08:37:29] Espo.INFO: Installer: Restore previous files. [] []
[2020-05-26 08:37:30] Espo.ERROR: Upgrade Error: Error: Rebuild is failed. Fix all errors before upgrade. [] []
[2020-05-26 08:38:01] Espo.DEBUG: BPM: processPendingFlows [] []

[esforim]

Hi peter, why are you using
--file="EspoCRM-upgrade.zip"?

Why not just let it automated run using the command without it specific file? Let the script determine what need to be done.

[peterberlin]

We have now used with the tool mysql_upgrate and had forgotten to restart the server Now it works.

[esforim]

Good to hear, are you going to update to 5.9.1 too? There quite a few good feature.