MySQL Bugs: #85887: AdminAPI error not descriptive for dba.checkInstanceConfiguration

Bug #85887	AdminAPI error not descriptive for dba.checkInstanceConfiguration
Submitted:	10 Apr 2017 23:18	Modified:	11 Apr 2017 15:11
Reporter:	Dale Dasker	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Document Store: MySQL Shell	Severity:	S3 (Non-critical)
Version:	1.0.8RC	OS:	CentOS (6)
Assigned to:	Miguel Araujo	CPU Architecture:	Any

Description:
When executing dba.checkInstanceConfiguration against a server that is already configured for Group Replication, the following error does not provide any insite.

The following issues were encountered:

Please fix these issues and try again.

{
    "errors": [],
    "restart_required": false,
    "status": "error"
}"

How to repeat:
Execute dba.checkConfigInstance('root@localhost:3306') against a MySQL 5.7.17+ server that is already configured with loose_group_replication.. values.  

Suggested fix:
Should be something like: "The instance is already configured for Group Replication. You can use dba.createCluster( "<name>", {adoptFromGR: true}) to import it

Further testing by setting  dba.verbose = 2 showed that I was running Python 2.6 and needed to upgrade to Python 2.7.  It would help our customers if an error message can be displayed in the standard output informing the user of the version incompatibility of the Python interpreter they are running and the requirement of 2.7.

Dale, thanks for reporting this bug. However, I cannot reproduce it.

Using MySQL Shell 1.0.8-rc:

mysql-js> dba.checkInstanceConfiguration("localhost:3310")

Please provide the password for 'root@localhost:3310':

Validating instance...

Dba.checkInstanceConfiguration: The instance 'root@localhost:3310' is already
part of a Replication Group (RuntimeError)

 
The instance is MySQL 5.7.18 with the following configuration:

[client]
protocol = TCP
port = 3310
user = root

[mysqld]

transaction_write_set_extraction = XXHASH64
disabled_storage_engines = BLACKHOLE,FEDERATED,ARCHIVE
binlog_checksum = NONE
gtid_mode = ON
server_id = 995466846
basedir = /usr
port = 3310
datadir = /home/miguel/mysql-sandboxes/3310/sandboxdata
log_error = /home/miguel/mysql-sandboxes/3310/sandboxdata/error.log
pid_file = /home/miguel/mysql-sandboxes/3310/3310.pid
log_bin
loose_mysqlx_socket = /home/miguel/mysql-sandboxes/3310/mysqlx.sock
log_slave_updates = ON
relay_log_info_repository = TABLE
secure_file_priv = /home/miguel/mysql-sandboxes/3310/mysql-files
master_info_repository = TABLE
binlog_format = ROW
plugin_load = mysqlx.so
enforce_gtid_consistency = ON
loose_mysqlx_port = 33100
socket = /home/miguel/mysql-sandboxes/3310/mysqld.sock
report_port = 3310
log_syslog = OFF

transaction_write_set_extraction=XXHASH64
loose-group_replication_group_name="aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa"
loose-group_replication_start_on_boot=on
loose-group_replication_local_address= "localhost:13310"
loose-group_replication_bootstrap_group= on

Can you please provide the full list of configuration variables you are using on the MySQL server?