Bug #79853 MCC does not work with Cluster 7.5
Submitted: 5 Jan 2016 14:41 Modified: 3 May 2016 9:39
Reporter: Kari Juul Wedde Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Cluster: Configurator Severity:S2 (Serious)
Version:7.5.0 OS:Any
Assigned to: CPU Architecture:Any

[5 Jan 2016 14:41] Kari Juul Wedde
Description:
MCC does not work with Cluster 7.5 due to changed behavior in Server 5.7.

On Solaris MCC is not able to start the mysqlds.
On Windows the cluster starts but MCC is not able to use the mysqladmin client to perform shutdown.

From the MCC log on Solaris

/tmp/ndb_setup-2269.log:2016-01-05 11:10:23,074: ERROR [_exec_cmdv;clusterhost.py:490]: output=2016-01-05 11:10:23 [WARNING] mysql_install_db is deprecated. Please consider switching to mysqld --initialize
/tmp/ndb_setup-2269.log:CalledProcessError: Command '[u'/export/home/tmp/kwedde/mysql-cluster-gpl-7.5.0-solaris11-x86_64/bin/mysql_install_db', '--no-defaults', '--datadir=/home/kwedde/MySQL_Cluster/53/', '--basedir=/export/home/tmp/kwedde/mysql-cluster-gpl-7.5.0-solaris11-x86_64/']' returned non-zero exit status 1

How to repeat:
Solaris:

Start MCC and a default cluster. "Deploy and start cluster will fail"

Windows:

Start a default cluster with MCC. A following "Stop cluster" will fail.
[6 Jan 2016 8:50] MySQL Verification Team
Hello Kari,

Thank you for the report.
Verified as described with 7.5 daily build.

Thanks,
Umesh
[6 Jan 2016 8:50] MySQL Verification Team
-- from ndb_setup log

016-01-06 08:40:14,003: ERROR [_exec_cmdv;clusterhost.py:490]: output=2016-01-06 08:40:13 [WARNING] mysql_install_db is deprecated. Please consider switching to mysqld --initialize
2016-01-06 08:40:13 [ERROR]   The data directory '/export/home/ushastry/MySQL_Cluster/53/' already exist and is not empty.
 
2016-01-06 08:40:14,004: ERROR [do_POST;request_handler.py:394]: POST request failed: 
Traceback (most recent call last):
  File "/export/home/ushastry/Downloads/mysql-cluster-gpl-7.5.0-solaris11-x86_64/share/mcc/request_handler.py", line 389, in do_POST
    rep = handle_req(msg)
  File "/export/home/ushastry/Downloads/mysql-cluster-gpl-7.5.0-solaris11-x86_64/share/mcc/request_handler.py", line 93, in handle_req
    return h(req, req['body'])
  File "/export/home/ushastry/Downloads/mysql-cluster-gpl-7.5.0-solaris11-x86_64/share/mcc/request_handler.py", line 170, in handle_executeCommandReq
    return make_rep(req, {'out': start_proc(body['command'], body) })
  File "/export/home/ushastry/Downloads/mysql-cluster-gpl-7.5.0-solaris11-x86_64/share/mcc/request_handler.py", line 162, in start_proc
    return ch.exec_cmdv(cmdv, pc, stdinFile)
  File "/export/home/ushastry/Downloads/mysql-cluster-gpl-7.5.0-solaris11-x86_64/share/mcc/clusterhost.py", line 376, in exec_cmdv
    return self._exec_cmdv(cmdv, procCtrl, stdinFile)
  File "/export/home/ushastry/Downloads/mysql-cluster-gpl-7.5.0-solaris11-x86_64/share/mcc/clusterhost.py", line 486, in _exec_cmdv
    subprocess.check_call(cmdv, stdin=stdin, stdout=output, stderr=output)
  File "/usr/lib/python2.6/subprocess.py", line 488, in check_call
    raise CalledProcessError(retcode, cmd)
CalledProcessError: Command '[u'/export/home/ushastry/Downloads/mysql-cluster-gpl-7.5.0-solaris11-x86_64/bin/mysql_install_db', '--no-defaults', '--datadir=/export/home/ushastry/MySQL_Cluster/53/', '--basedir=/export/home/ushastry/Downloads/mysql-cluster-gpl-7.5.0-solaris11-x86_64/']' returned non-zero exit status 1

-- Build used

root@ushastry:~/Downloads/mysql-cluster-gpl-7.5.0-solaris11-x86_64# cat docs/INFO_SRC
commit: 0e818171cecf5594dfb32889661e1e141f7d9465
date: 2015-12-23 11:19:57 +0100
build-date: 2015-12-23 11:23:08 +0100
short: 0e81817
branch: mysql-5.7-cluster-7.5

MySQL source 5.7.10
[3 May 2016 9:39] Jon Stephens
Documented fix in the NDB 7.5.2 changelog as follows:

    The MySQL Cluster Auto-Installer failed to work in various ways
    on different platforms.

Also noted in the Manual that the Auto-Installer is not supported with NDB 7.5.0 or 7.5.1.

Closed.