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:
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

[10 Apr 2017 23:18] Dale Dasker
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
[11 Apr 2017 4:11] Dale Dasker
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.
[11 Apr 2017 10:14] Miguel Araujo
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:

protocol = TCP
port = 3310
user = root


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
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

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?