Skip to content
English
Customer portal
Contact us
  • There are no suggestions because the search field is empty.

SimpleRisk Will not Backup due to Column Statistics Flag (Ubuntu)+(RDS only)

This FAQ aims to address a potential issue that may occur during the upgrade process. If your SimpleRisk installation and Apache server are hosted on a different server than your database, such as an AWS RDS, there is a chance that the MySQL client version differs from the MySQL version running on the RDS. When this discrepancy exists, it can lead to the backup function generating the `mysqldump` command based on the MySQL server version, while the MySQL client that executes it may not properly understand the command.

Symptom

The systems are currently unable to proceed with the upgrade because of a backup failure. The Apache log will show the following error message: mysqldump: [ERROR] unknown variable 'column-statistics=0'.


The Fix

To address this issue, we need to ensure that the MySQL client version matches that of the RDS. Currently, we're observing that the client is often at version 5.7, while the server is running version 8.0.2. To proceed, you'll need terminal access on the client machine where Apache is running. Please execute the following commands in the terminal:

wget https://dev.mysql.com/get/mysql-apt-config_0.8.22-1_all.deb
dpkg -i mysql-apt-config_0.8.22-1_all.deb
apt update
apt install mysql-client


After these installations are complete, you may need to restart both Apache and MySQL using the following commands:

systemctl restart mysql
systemctl restart apache2


This concludes this FAQ. If you require assistance with this issue on another operating system please let us know and we can attempt to help. Contact us at support@simplerisk.com for further assistance.