Skip to content

--topology=innodb-cluster fails for 8.4.8 #87

@dendress

Description

@dendress

Environment

  • dbdeployer version: 2.1.1
  • Go version (if building from source): NA
  • OS: macOS Sequoia 15.7.4
  • MySQL/database version: 8.4.8
  • Flavor: MySQL
  • Topology: replication - innodb cluster

Describe the bug
Trying to create a 8.4.8 innodb cluster fails with mysql shell incompatibility errors:

$HOME/sandboxes/ic_msb_8_4_8/init_cluster
cmd: /Users/dovendress/sandboxes/ic_msb_8_4_8/init_cluster
err: exit status 1
stdout: Creating InnoDB Cluster...
Adding instance 127.0.0.1:30213...
Adding instance 127.0.0.1:30214...
Checking cluster status...

stderr: WARNING: Using a password on the command line interface can be insecure.
WARNING: The interactive option is deprecated and will be removed in a future release.

ERROR: Unsupported server version: AdminAPI operations in this version of MySQL Shell support MySQL Server up to version 8.0
WARNING: Using a password on the command line interface can be insecure.
MySQL Error 1045 (28000): Access denied for user 'icadmin'@'localhost' (using password: YES)
WARNING: Using a password on the command line interface can be insecure.
WARNING: The interactive option is deprecated and will be removed in a future release.

ERROR: Unsupported server version: AdminAPI operations in this version of MySQL Shell support MySQL Server up to version 8.0
WARNING: Using a password on the command line interface can be insecure.
MySQL Error 1045 (28000): Access denied for user 'icadmin'@'localhost' (using password: YES)
WARNING: Using a password on the command line interface can be insecure.
WARNING: The interactive option is deprecated and will be removed in a future release.

ERROR: Unsupported server version: AdminAPI operations in this version of MySQL Shell support MySQL Server up to version 8.0
WARNING: Using a password on the command line interface can be insecure.
MySQL Error 1045 (28000): Access denied for user 'icadmin'@'localhost' (using password: YES)
WARNING: Using a password on the command line interface can be insecure.
MySQL Error 1045 (28000): Access denied for user 'icadmin'@'localhost' (using password: YES)

Pre-exit cleanup.

#1 - Executing RmdirAll( /Users/dovendress/sandboxes/ic_msb_8_4_8)
error creating sandbox: 'error initializing InnoDB Cluster: exit status 1'
Mac:sandboxes dovendress$

Steps to reproduce

  1. dbdeployer deploy replication --topology=innodb-cluster 8.4.8
  2. See error:
    ERROR: Unsupported server version: AdminAPI operations in this version of MySQL Shell support MySQL Server up to version 8.0
    WARNING: Using a password on the command line interface can be insecure.
    MySQL Error 1045 (28000): Access denied for user 'icadmin'@'localhost' (using password: YES)
    WARNING: Using a password on the command line interface can be insecure.
    MySQL Error 1045 (28000): Access denied for user 'icadmin'@'localhost' (using password: YES)

Expected behavior
Create the cluster

Actual behavior
Cluster was not created. Full output:

`Mac:sandboxes dovendress$ dbdeployer deploy replication --topology=innodb-cluster 8.4.8
Installing and starting node 1
.. sandbox server started
Installing and starting node 2
. sandbox server started
Installing and starting node 3
. sandbox server started
$HOME/sandboxes/ic_msb_8_4_8/initialize_nodes

Node 1 # RESET BINARY LOGS AND GTIDS; CHANGE REPLICATION SOURCE TO source_user='rsandbox', source_password='rsandbox' FOR CHANNEL 'group_replication_recovery';

Node 2 # RESET BINARY LOGS AND GTIDS; CHANGE REPLICATION SOURCE TO source_user='rsandbox', source_password='rsandbox' FOR CHANNEL 'group_replication_recovery';

Node 3 # RESET BINARY LOGS AND GTIDS; CHANGE REPLICATION SOURCE TO source_user='rsandbox', source_password='rsandbox' FOR CHANNEL 'group_replication_recovery';

Node 1 # SET GLOBAL group_replication_bootstrap_group=ON;

Node 1 # START GROUP_REPLICATION;

Node 2 # START GROUP_REPLICATION;

Node 3 # START GROUP_REPLICATION;

Node 1 # SET GLOBAL group_replication_bootstrap_group=OFF;

Node 1 # select * from performance_schema.replication_group_members

+---------------------------+--------------------------------------+-------------+-------------+--------------+-------------+----------------+----------------------------+
| CHANNEL_NAME | MEMBER_ID | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE | MEMBER_ROLE | MEMBER_VERSION | MEMBER_COMMUNICATION_STACK |
+---------------------------+--------------------------------------+-------------+-------------+--------------+-------------+----------------+----------------------------+
| group_replication_applier | 00030212-1111-1111-1111-111111111111 | 127.0.0.1 | 30212 | ONLINE | PRIMARY | 8.4.8 | XCom |
| group_replication_applier | 00030213-2222-2222-2222-222222222222 | 127.0.0.1 | 30213 | ONLINE | SECONDARY | 8.4.8 | XCom |
| group_replication_applier | 00030214-3333-3333-3333-333333333333 | 127.0.0.1 | 30214 | ONLINE | SECONDARY | 8.4.8 | XCom |
+---------------------------+--------------------------------------+-------------+-------------+--------------+-------------+----------------+----------------------------+

Node 2 # select * from performance_schema.replication_group_members

+---------------------------+--------------------------------------+-------------+-------------+--------------+-------------+----------------+----------------------------+
| CHANNEL_NAME | MEMBER_ID | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE | MEMBER_ROLE | MEMBER_VERSION | MEMBER_COMMUNICATION_STACK |
+---------------------------+--------------------------------------+-------------+-------------+--------------+-------------+----------------+----------------------------+
| group_replication_applier | 00030212-1111-1111-1111-111111111111 | 127.0.0.1 | 30212 | ONLINE | PRIMARY | 8.4.8 | XCom |
| group_replication_applier | 00030213-2222-2222-2222-222222222222 | 127.0.0.1 | 30213 | ONLINE | SECONDARY | 8.4.8 | XCom |
| group_replication_applier | 00030214-3333-3333-3333-333333333333 | 127.0.0.1 | 30214 | ONLINE | SECONDARY | 8.4.8 | XCom |
+---------------------------+--------------------------------------+-------------+-------------+--------------+-------------+----------------+----------------------------+

Node 3 # select * from performance_schema.replication_group_members

+---------------------------+--------------------------------------+-------------+-------------+--------------+-------------+----------------+----------------------------+
| CHANNEL_NAME | MEMBER_ID | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE | MEMBER_ROLE | MEMBER_VERSION | MEMBER_COMMUNICATION_STACK |
+---------------------------+--------------------------------------+-------------+-------------+--------------+-------------+----------------+----------------------------+
| group_replication_applier | 00030212-1111-1111-1111-111111111111 | 127.0.0.1 | 30212 | ONLINE | PRIMARY | 8.4.8 | XCom |
| group_replication_applier | 00030213-2222-2222-2222-222222222222 | 127.0.0.1 | 30213 | ONLINE | SECONDARY | 8.4.8 | XCom |
| group_replication_applier | 00030214-3333-3333-3333-333333333333 | 127.0.0.1 | 30214 | ONLINE | SECONDARY | 8.4.8 | XCom |
+---------------------------+--------------------------------------+-------------+-------------+--------------+-------------+----------------+----------------------------+
$HOME/sandboxes/ic_msb_8_4_8/init_cluster
cmd: /Users/dovendress/sandboxes/ic_msb_8_4_8/init_cluster
err: exit status 1
stdout: Creating InnoDB Cluster...
Adding instance 127.0.0.1:30213...
Adding instance 127.0.0.1:30214...
Checking cluster status...

stderr: WARNING: Using a password on the command line interface can be insecure.
WARNING: The interactive option is deprecated and will be removed in a future release.

ERROR: Unsupported server version: AdminAPI operations in this version of MySQL Shell support MySQL Server up to version 8.0
WARNING: Using a password on the command line interface can be insecure.
MySQL Error 1045 (28000): Access denied for user 'icadmin'@'localhost' (using password: YES)
WARNING: Using a password on the command line interface can be insecure.
WARNING: The interactive option is deprecated and will be removed in a future release.

ERROR: Unsupported server version: AdminAPI operations in this version of MySQL Shell support MySQL Server up to version 8.0
WARNING: Using a password on the command line interface can be insecure.
MySQL Error 1045 (28000): Access denied for user 'icadmin'@'localhost' (using password: YES)
WARNING: Using a password on the command line interface can be insecure.
WARNING: The interactive option is deprecated and will be removed in a future release.

ERROR: Unsupported server version: AdminAPI operations in this version of MySQL Shell support MySQL Server up to version 8.0
WARNING: Using a password on the command line interface can be insecure.
MySQL Error 1045 (28000): Access denied for user 'icadmin'@'localhost' (using password: YES)
WARNING: Using a password on the command line interface can be insecure.
MySQL Error 1045 (28000): Access denied for user 'icadmin'@'localhost' (using password: YES)

Pre-exit cleanup.

#1 - Executing RmdirAll( /Users/dovendress/sandboxes/ic_msb_8_4_8)
error creating sandbox: 'error initializing InnoDB Cluster: exit status 1'
Mac:sandboxes dovendress$
`

Hardware (if applicable)
NA

Additional context

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions