MySQL Cluster Manager 1.3 Release Notes  /  Changes in MySQL Cluster Manager 1.3.2 (2014-08-15)

Changes in MySQL Cluster Manager 1.3.2 (2014-08-15)

This section documents all changes and bug fixes that have been applied in MySQL Cluster Manager 1.3.2 since the release of MySQL Cluster Manager version 1.3.1.

Functionality Added or Changed

  • Agent; Client: In order to improve execution robustness, MySQL Cluster Manager now fails any commands that reconfigure a cluster with the message ERROR 5027 Unable to perform command due to utility <proc_name> with pid <ospid> on <host> if any utility process (for example, mysql_upgrade, mysql_install_db, or ndb_restore) that was started by a previous command still remained (running or hung) on any host when the command was issued. (Bug #18966650)

  • Client: MySQL Cluster Manager now throws an error if the user tries to import a cluster or a cluster configuration using import cluster or import config when the user running the mcmd process does not have permission to access PID files for the cluster processes. This happens typically when mcmd is started as the mysql the user but the cluster is started as root. (Bug #18887139)

Bugs Fixed

  • Agent; Client: On Windows platforms, when a data node could not be restarted during a rolling restart of the cluster, it was not reported to the user. With this fix, the user now gets a report when a maintenance restart of a data node fails. (Bug #19227535)

  • Agent; Client: The import config command did not import configuration settings from a cluster's my.cnf file properly. Problems with the import included the following:

    • Some settings in the [mysqld] section were left out (for example, key_buffer_size and query_cache_type).

    • Some options in the [client] section were included by mistake.

    • The !include and !includedir statements for including settings from other files were ignored

    • Quoted values were not handled properly—the quotes were taken literally.

    • Lines starting with a semicolon (;) were not treated as comments.

    • The option modifiers loose_ and maximum_ were not recognized.

    • Option groups for specific release series (for example, [mysqld-5.6]) were not imported.

    (Bug #19078129)

  • Agent; Client: When the configuration of a running cluster was imported using import config, even if the parameter ThreadConfig was not defined in the config.ini file, its value could be imported from the running node's setting for it. The imported value overrode the configuration prescribed by the MaxNoOfExecutionThreads parameter in config.ini, which is supposed to set the thread configuration when ThreadConfig is not specified in config.ini. This fix prevents the importation of the value for ThreadConfig from the running node, making MySQL Cluster Manager rely on the config.ini file for the thread configuration. (Bug #19032714)

  • Agent; Client: When using the import config command, the format of an imported configuration setting was sometimes changed from that which was used in the config.ini file—for example, a value in megabytes was imported as a value in bytes and then shown as such by the get command. That made it more difficult for the user to compare the original and the imported value. This fix makes MySQL Cluster Manager follow the original format in the config.ini file when importing a cluster's configuration. (Bug #18651726)

  • Agent; Client: The import config command sometimes imported MySQL server default values that were not specified in the cluster's configuration files. With this fix, no such values are imported. (Bug #18651301)

  • Agent: Executing import config when managing more than one cluster could cause the MySQL Cluster Manager agent to fail. (Bug #19380825)

  • Agent: During a recovery for a MySQL Cluster Manager agent that used IP addresses instead of hostnames, the agent sent out an excessive amount of information, the processing of which slowed down the restart process considerably. This fix changes the way the IP addresses are handled, reducing the amount of sent information to a much more reasonable level. (Bug #19269735)

  • Agent: When a wild cluster's process PIDs were not available to MySQL Cluster Manager, executing an import cluster command resulted in a process error and the complaint that a process handle could not be opened. With this fix (which is a side effect of the fix for Bug #19209870), MySQL Cluster Manager no longer attempts to open handles for unknown PIDs. (Bug #19205183)

    References: See also: Bug #19209870.

  • Agent: Upgrades from MySQL Cluster Manager 1.2.4 (to 1.3.1) failed when the last command executed before the upgrade was any one of backup cluster, restore cluster, abort backup, or import cluster. This problem has been fixed, and users of version 1.2.4 can now upgrade to version 1.3.2. (Bug #19199645)

  • Agent: The MySQL Cluster Manager agent sometimes threw SIGABRT errors while executing SQL statements. (Bug #19032927)

  • Agent: mcmd crashed due to an out-of-memory error after a combination of the following conditions:

    • An abrupt failure of one of the site hosts, instead of a clean stop.

    • Only a minority of the agents were available.

    • Some unmanaged SQL slots came into use, changed their states to connected, and the changes were reported by a ndb_mgmd process.

    (Bug #18781345)

  • Client: Restoration of a cluster failed when the cluster contained API nodes with and without specified hostnames. (Bug #19313429)

  • Client: If a mysqld process was specified in a create cluster statement using mysqld@* syntax (with no host specified), the show status --process commands did not show the process as connected, even when it was. (Bug #19152161)

  • Client: When using the show status command with the --backup option, the MySQL Cluster Manager client sometimes accepted additional options, which was actually meaningless. This fix makes the client throw an error when any other option is used in combination with --backup. (Bug #19032714)

  • Client: MySQL Cluster Manager threw an error when the add package command was run with the argument for the --basedir option being double quoted, which claimed that the path did not exist. This was because MySQL Cluster Manager took the double quotes literally, as parts of the path name. (Bug #18973711)

  • Client: On Windows platforms, the MySQL Cluster Manager client's response to the list hosts command was very slow when any one of the MySQL Cluster Manager agents was down. (Bug #18966650)

  • Client: When the configuration of a running cluster was being imported, the import config command took the settings from the global session variables instead of the configuration files of the cluster and the MySQL servers. This fix makes MySQL Cluster Manager import the settings from the configuration files, and only use values of the global session variables when it cannot find, open, or access the configuration files. (Bug #18652366)

  • Client: When using the import config command, some process-level settings in the cluster's config.ini file were imported as instance-level settings. (Bug #18651663)