Grafana extension is not working after its update or installation: Failed to update the Grafana stats in turn

Symptoms

• After the Grafana extension update or installation, the next error could be found in Log Browser and in /var/log/plesk/panel.log file:

  Failed to update the Grafana stats in turn.

• In an attempt to access the Plesk > Extensions > My Extensions > Grafana > Open page, the following is shown:

  The integration has failed or new changes exist.

•  When pressing the Restart integration button on the same page, it fails with the error:

  Request failed with status code 500

Cause

The update/installation of the Grafana extension was interrupted as the result the installation flag for Grafana was not removed from its SQLite3 database.

Resolution

1. Log into the server via SSH.
2. Create a backup of the /usr/local/psa/var/modules/grafana/grafana.sqlite3 file:

   # cp -pr /usr/local/psa/var/modules/grafana/grafana.sqlite3 /usr/local/psa/var/modules/grafana/grafana.sqlite3.back

3. Access the Grafana SQLite3 database:

   # sqlite3 /usr/local/psa/var/modules/grafana/grafana.sqlite3

4. Remove the installation flag for Grafana extension:

   # delete from params where name = 'ms_update_is_in_progress';

5. Log into Plesk.
6. Press the Restart integration button in Extensions > My Extensions > Grafana > Open.