1. Home
  2. Docs
  3. ClusterControl
  4. Changelogs
  5. Changes in v1.7.6

Changes in v1.7.6

Maintenance Release: September 10th, 2020

  • Build:
    • clustercontrol-1.7.6-7237
  • Frontend (UI):
    • OpsGenie: Fixed a bug where the Integration could not be created due to Failed to parse request body:...
    • OpsGenie: Updated instructions. The API Key must be the API Key of the Team that may be used: https://docs.opsgenie.com/docs/api-key-management
    • HAProxy: Fixed a bug where disable HAProxy failed because UI didn’t send the hostname parameter to the job.
    • MariaBackup: Fixed an issue with partial backups. It was not possible to specify databases/tables.

Maintenance Release: September 8th, 2020

  • Build:
    • clustercontrol-contoller-1.7.6-4130
  • Controller:
    • Oracle/MySQL 8.0 compatibility & testing fixes.

Maintenance Release: September 2nd, 2020

  • Build:
    • clustercontrol-1.7.6-7207
    • clustercontrol-contoller-1.7.6-4120
  • Frontend (UI):
    • Topology View: Fixed an issue to avoid flickering on cluster update.
    • Topology View: Fixed an issue showing the topology for 3 or more multi-masters.
    • ProxySQL: The IP/Hostname Address column was truncated in ProxySQL Processlist.
  • Controller:
    • MongoDB: Node menu does not appear for MongoDB ReplicaSet due to an internal error.
    • MongoDB: Fixed a bug causing Mongo shard recovery to fail and Mongos is started last.
    • Prometheus: Upgraded node_exporter to 1.0.1 (no incompatible changes) with some typo fixes.
    • Prometheus: Bump Prometheus version to 2.20.1.
    • [improvement] OS Support: Updated compatibility matrix to support Ubuntu 20.04.

Maintenance Release: August 27th, 2020

  • Build:
    • clustercontrol-contoller-1.7.6-4108
  • Controller:
    • OS Detection: Fixed an error to be more tolerant to extra lines introduced by SSH login to a host. This caused an issue when detecting the operating system.
    • CMON Schema: Fixed an issue with the cmon_log_entries the table that has an invalid Foreign Key.
    • ProxySQL: Deploy fails on Debian 10 in combination with Percona or Oracle/MySQL 8.0.
    • Fixed an issue on MySQL based system where the rebuild replication slave would fail when using uppercased hostnames.

Maintenance Release: August 17th, 2020

  • Build:
    • clustercontrol-1.7.6-7158
    • clustercontrol-contoller-1.7.6-4083
  • Frontend (UI):
    • Dashboards: Fixed an issue in the Replication dashboard where the Master Server ID was presented as a decimal value and not an integer.
  • Controller:
    • ProxySQL: Fixed a bug with logs getting flooded with SAVE MYSQL SERVERS TO DISK and LOAD MYSQL ... commands if there was a MySQL server not present in the ProxySQL Server’s mysql_servers table.
    • Alarms: Fixed a timezone problem between the reported date in the Alarm Digest email and the triggered Alarm. Now the DateTime has the same timezone in both cases.

Maintenance Release: August 11th, 2020

  • Build:
    • clustercontrol-1.7.6-7146
    • clustercontrol-contoller-1.7.6-4077
  • Frontend (UI):
    • Fixed an issue with retrieving roles where a non-super-admin LDAP users always end up at the first cluster in the list.
    • Fixed an issue editing an OpsGenie integration which prompted the user to enter information in a field, but it was not possible.
  • Controller:
    • HAProxy: Fixed an issue using non-default ports as a user-specified value would be set to the default.
    • Mariabackup: A fix for Mariabackup 10.4.14 which has dropped support for some options.
    • Deployment: Fixed a bug deploying Percona on CentOS 8.

Maintenance Release: August 4th, 2020

  • Build:
    • clustercontrol-1.7.6-7124
    • clustercontrol-notifications-1.7.6-254
  • Frontend (UI):
    • Galera: Fixed an issue that made it impossible to activate Galera SSL Encryption when SSL Encryption was enabled.
    • Galera: Server Load graphs were not properly initialized when there was no data to graph (e.g, because a server was down for a period of time).
    • ServiceNow integration: Fixed a layout issue, and improved the usability by adding an All Clusters to simplify when having many clusters. This fix also includes two new fields: Service and Configuration Item.
  • Notifications service:
    • ServiceNow: Added support for Service and Configuration Item.

Maintenance Release: August 3rd, 2020

  • Build:
    • clustercontrol-controller-1.7.6-4068
  • Controller:
    • Galera: Fixed a bug deploying Percona Server and XtraDB Cluster on CentOS 8.
    • PostgreSQL: Fixed an issue with PgBackRest using user-defined stanzas to prevent default configuration options defined by the controller from being set as command-line options. Thus, only the options set in the user-defined stanza will be used and nothing else.

Maintenance Release: July 27th, 2020

  • Build:
    • clustercontrol-1.7.6-7082
    • clustercontrol-controller-1.7.6-4059
  • Frontend (UI):
    • Cloud Deployment: Fixed an issue where the wrong disk size unit (GB) was sent in the job instead of MB.
    • Backup/Restore (MySQL-based): Fixed a couple of UX issues. Restoring a backup using Point In-time Recovery (PITR) may only be executed on the cluster nodes where the backup was created. All other options are now disabled (Restore on standalone/create a cluster from backup).
    • Import MySQL Replication: The option Import as a standalone node has been removed as it did not have any purpose.
  • Controller:
    • MySQL 8.0: Fixed an issue with parsing privileges in a GRANT statement (INNODB_REDO_LOG_ENABLE the privilege was missing).
    • Replication: Fixed an issue retrieving/creating user account information in case there was one server in the setup and it was not configured as a master. The error manifested itself as Server not found while trying to create an account.
    • Replication: Improved the behavior by not raising an alarm and disabling auto-recovery if the setting auto_manage_readonly=false is specified and the cluster has multiple writable masters.
    • Replication: Enable/Disable read-only job: Failed to run if auto_manage_readonly=false.
    • ProxySQL: Failed to sync instance in ProxySQL (GRANT option).

Maintenance Release: July 20th, 2020

  • Build:
    • clustercontrol-1.7.6-7059
    • clustercontrol-controller-1.7.6-4047
  • Frontend(UI):
    • Integrations: Fixed a bug when adding cluster on integration channel if cluster name only 2 characters.
    • PostgreSQL: Enable TimescaleDB for PostgreSQL 12.
    • User Management: Fixed an issue preventing a SuperAdmin used logged in from LDAP to change a cluster team.
  • Controller:
    • PostgreSQL: Fixed an issue where the controller failed to parse pg_hba.conf when a line ends up with empty space before a new line.
    • PostgreSQL: Ensure that directories created for PostgreSQL have the correct rights and even the newly created parent directories, such as /etc/postgres.
    • General: Extended OS compatibility matrix with Ubuntu Server 20.04 LTS (Focal Fossa).

Maintenance Release: July 10th, 2020

  • Build:
    • clustercontrol-controller-1.7.6-4036
  • Controller:
    • A fix for a race condition when the SSH connection is lost for a moment when sampling processes. This could lead to the process (e.g HAProxy, Garbd, ProxySQL) to have the wrong state for a short period of time.
      MongoDB: Consistent backup failed because the Storage Host was not set.

Maintenance Release: July 5th, 2020

  • Build:
    • clustercontrol-controller-1.7.6-4026
  • Controller:
    • Galera: Improved Cluster Split detection. Now, the cluster_size is measured over a three-second period, and the cluster will enter a failed state if the cluster_size is not the same on all nodes after this period of time.
    • PostgreSQL: Rebuilding a PostgreSQL node as a slave could make it appear with the role set to master (but non-writable, and streaming from the writable master).
    • ProxySQL: Removed unnecessary log messages when installing ProxySQL.

 Maintenance Release: June 28th, 2020

  • Build:
    • clustercontrol-1.7.6-6996
    • clustercontrol-controller-1.7.6-4013
  • Frontend (UI):
    • Query Monitor: Running Queries did only appear on the last page when filtering on hosts.
    • User Management: The number of visible Teams/LDAP groups was limited and more than 33 groups could not be shown in the UI.
  • Controller:
    • Query Monitor: Purge Query Monitor for MySQL did not purge the performance_schema.events_statements_summary_by_digest.
    • Ping time was set incorrectly (to a big value) when blocked by firewall or ICMP disabled in conf. Now it is set to -1 if blocked by the firewall or disabled.
    • HAProxy: It was possible to import a non-existing HAProxy.
    • ProxySQL: Fixed a bug syncing instances error when a database name contains backslash.
    • ProxySQL: Fixed an issue with MariaDB when importing users with a role in ProxySQL.
    • ProxySQL: Fixed an issue Installing ProxySQL 1.x failed on CentOS7.
    • ProxySQL: Could not install version 1 to two nodes in the same job.
      ProxySQL: Failed to stop the ProxySQL service while removing and uninstalling the node.

Maintenance Release: June 20th, 2020

  • Build:
    • clustercontrol-1.7.6-6976
    • clustercontrol-controller-1.7.6-3995
  • Frontend (UI):
    • Query Monitor: Fixed a bug when purging data in the Query Monitor.
  • Controller:
    • SSL Certificates: Fixed a bug that prevented self-signed certificates to be imported. The error manifested itself as: Error 'CA certificate: Empty PEM string'.
    • MaxScale: The MaxScale nodes could in some situations appear as not available or offline, but the process was actually running.
    • Backups: Fixed a bug where a backup could end up in the wrong backup directory if the backup was re-executed too soon after a failed backup.

Maintenance Release: June 16th, 2020

  • Build:
    • clustercontrol-1.7.6-6959
    • clustercontrol-controller-1.7.6-3985
  • Controller:
    • Monitoring/disk: Skip monitoring NFS filesystem.
    • PostgreSQL: In case of an inconsistent view (master down, but load balancer or slave reports it is up) then performs double-check using SSH.
    • PostgreSQL: Log the replication failure alarm reasoning and server disconnected reason in the alarm text.
  • Frontend (UI):
    • MongoDB: Dashboards metrics updated to support new mongodb_exporter. A re-install of the MongoDB exporter is needed, which is done from the Dashboards action menu.
    • Schema Analyzer: Showed no data for community edition.
    • Stop Node action must always be visible. Even if the node is down/unknown.
    • Backup Scheduling: An issue specifying the time when using advanced settings.
    • User management: A User with Admin role cannot open the mail notifications page
    • User management: Users are shown in the wrong group (fixed ‘All users’ logic).
      User management: LDAP users can’t see alarms or jobs.

Maintenance Release: June 8th, 2020

  • Build:
    • clustercontrol-controller-1.7.6-3972
  • Controller:
    • ProxySQL: Supporting MariaDB roles when importing users to ProxySQL.
    • MongoDB: Upgraded mongodb_exporter to v0.11.0 to support newer MongoDB versions.
    • HAProxy: Fixed an issue where the node appears online but the VM is not even running.
    • Galera: Failed to create a slave cluster from backup for Galera.
    • PostgreSQL: Cluster-to-Cluster replication shows Cluster Failure in the slave cluster.
    • PostgreSQL: Failed to Create Slave Cluster on TimescaleDB.
    • Notifications: Extended the fallback email address query with, dcps.users with company_id=0, and the RPCv2 owner user of the cluster. This ensures that an admin that can see all clusters will get notifications from all clusters.

Maintenance Release: May 15th, 2020

 

  • Build
    • clustercontrol-1.7.6-6868
    • clustercontrol-controller-1.7.6-3940
  • Frontend (UI):
    • CC Teams and Users management issue (removed the strict linking on the company for SuperAdmin).
  • Controller:
    • PostgreSQL: Slave rebuild doesn’t work for PostgreSQL.
    • PostgreSQL: Failed create PostgreSQL cluster from pg_basebackup.
    • PostgreSQL: Remove slave (recovery/standby) signal files after restoring pg_basebackup.
    • Galera: Automatic failover is not working on MariaDB Cluster with slave nodes.
    • Galera: Create Galera Cluster From Backup fails.
    • Galera: Creating a Slave Cluster using PXC 5.6 failed. See note above.
    • Galera: Galera recovery fails repeatedly if automatic recovery is enabled (huge dataset) because of a systemd script timeout. Now CMON will patch the vendors’ broken systemd script.
    • Galera: PXC 5.7 failed to deploy on Centos 8.
    • MySQL/Galera: Added parser support for new MySQL 8.0 privileges.
    • ProxySQL: Fix for wildcard handling in MySQL grants (fixes a ProxySQL import users issue).
    • MongoDB: Deployment fails and fixed by preventing /var/run and /run from any owner/access changes, it makes the SSH connections failing.

Maintenance Release: May 6th, 2020

  • Build:
    • clustercontrol-1.7.6-6854
      clustercontrol-controller-1.7.6-3910
  • Frontend (UI):
    • HAProxy: Auto-filling HAProxy socket, port, and credentials fields are not working in the import section (fixed template).
  • Controller:
    • PostgreSQL: Fix a pg_hba.conf parsing error (whitespace in empty lines).
    • PostgreSQL: Bugfix for duplicated pg_hba.conf entries.
    • PostgreSQL: Bugfix for repetitive CREATE ROLE calls following a failover.
    • MongoDB: Backups created by s9s CLI did not contain the node name in the backup file.
    • MaxScale: Remove/Register fixes.
    • MySQL: A strong root password is now auto-created if not specified explicitly by the job.
      MySQL: Refresh variables after restarting a node so the node is up to date in the UI.
    • Prometheus: Make sure tar and gzip are installed to be able to deploy the packages.
    • cmon_upgrade.log: Add timestamp and filenames.

Maintenance Release: May 3rd, 2020

  • Build:
    • clustercontrol-1.7.6-6846
  • Frontend (UI):
    • HAProxy: Import error, fixed the job spec.
    • Redundant nodes when Select Stream from Master in Create Slave Cluster dialog.
    • Backup: Got error Cannot set unknown key encrypt_backup on RecordType in the UI when configuring backup with verifying backup (added property to Verification model and fixed unit tests).
    • CSS fixes.

Maintenance Release: April 27th, 2020

  • Build:
    • clustercontrol-controller-1.7.6-3892
  • Controller:
    • s9s_error_reporter is not working for Cluster ID 0 (fixed error-report fallback path).
    • PostgreSQL: Include the pgdg common repository for PgBackRest on CentOS/RHEL.
    • PostgreSQL: Fixes to failover in case of deleting/erasing the master’s datadir.
    • PostgreSQL: Ping lets do a disconnect first, so we can detect if no new connection can be made to the PostgreSQL server.
    • MySQL: Bugfix for parsing the role syntax of a MySQL database user, which could lead to the frontend failing to handle the request to show database users in Manage → Schema and Users.

Maintenance Release: April 22nd, 2020

  • Build:
    • clustercontrol-1.7.6-6830
    • clustercontrol-controller-1.7.6-3880
  • Frontend (UI):
    • Backup Schedule: When changing a backup method (from non-PgBackRest) to PgBackRest it could cause the UI to become stuck.
    • Overview graph: The Cluster Overview graph was truncated in some cases to 30 minutes instead of 1 hour.
  • Controller:
    • Verify Backup: A user will be notified by email if the verification fails.
    • PostgreSQL: Backup Verification made a backup of datadir before restoring the backup, which was unnecessary.
    • PostgreSQL: Fixed an issue with replication lag calculation and alarming.
    • PostgreSQL: Skip nodes from failover whose lagging more than MAX_REPLICATION_LAG setting.
      MySQL Replication: A fix for rebuilding replication slave where there was a race condition checking if MySQL is down.
    • Galera: Fixed an issue when manipulating the my.cnf files that could manifest themselves as Got error Could not read 'wsrep_provider_options' when enabling Galera SSL Encryption.
    • Galera: Add a Replication Slave in PXC 5.7 overwrote the my.cnf if it was a symlink.
    • Password Escaping: Fix a password escaping issue in cmon configuration, that could lead to e.g the Prometheus database exporters to fail to connect to the database.
    • LibSSH: Fixes to prevent zombie/defunct ssh proxy commands (such as sssd_ssh_known_hosts_proxy) processes due to a missing waitpid in libssh.

Initial Release: April 10th, 2020

  • Build:
    • clustercontrol-1.7.6-6815
    • clustercontrol-controller-1.7.6-3854
    • clustercontrol-notifications-1.7.6-251
    • clustercontrol-cloud-1.7.6-241
    • clustercontrol-ssh-1.7.6-92

Feature Details

  • Cloud Deployment of HAProxy
    • Deploy a database stack containing your favorite SQL database and HAProxy load balancer.
  • MySQL Freeze Frame (BETA)
    • Snapshot MySQL process list before cluster failure.
  • Misc:
    • CMON Upgrade operations are logged in a log file.
    • Many improvements and fixes for PostgreSQL Backup, Restore, and Verify Backup.
    • A number of legacy ExtJS pages have been migrated to AngularJS.
Was this article helpful to you? Yes No