Description:
hongbin@MBP ~/w/mysql-server> mysql -uroot -proot -P4409 -h127.0.0.1
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 31
Server version: 5.7.22-debug-log Homebrew
Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> use performance_schema
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
mysql> select * from replication_connection_status\G
*************************** 1. row ***************************
CHANNEL_NAME: group_replication_recovery
GROUP_NAME:
SOURCE_UUID:
THREAD_ID: NULL
SERVICE_STATE: OFF
COUNT_RECEIVED_HEARTBEATS: 0
LAST_HEARTBEAT_TIMESTAMP: 0000-00-00 00:00:00
RECEIVED_TRANSACTION_SET:
LAST_ERROR_NUMBER: 0
LAST_ERROR_MESSAGE:
LAST_ERROR_TIMESTAMP: 0000-00-00 00:00:00
*************************** 2. row ***************************
CHANNEL_NAME: group_replication_applier
GROUP_NAME: b05e9aa0-59e0-11e8-aa25-6ccdbf577238
SOURCE_UUID: b05e9aa0-59e0-11e8-aa25-6ccdbf577238
THREAD_ID: NULL
SERVICE_STATE: ON
COUNT_RECEIVED_HEARTBEATS: 0
LAST_HEARTBEAT_TIMESTAMP: 0000-00-00 00:00:00
RECEIVED_TRANSACTION_SET: 0a58a2de-59dd-11e8-8020-c67e22318e38:1-14,
b05e9aa0-59e0-11e8-aa25-6ccdbf577238:1-20450
LAST_ERROR_NUMBER: 0
LAST_ERROR_MESSAGE:
LAST_ERROR_TIMESTAMP: 0000-00-00 00:00:00
2 rows in set (0.00 sec)
hongbin@MBP ~/w/mysql-server> mysqlsh
MySQL Shell 8.0.11
Copyright (c) 2016, 2018, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type '\help' or '\?' for help; '\quit' to exit.
MySQL JS > \c root@localhost:4409
Creating a session to 'root@localhost:4409'
Enter password:
Fetching schema names for autocompletion... Press ^C to stop.
Your MySQL connection id is 30
Server version: 5.7.22-debug-log Homebrew
No default schema selected; type \use <schema> to set one.
MySQL localhost:4409 ssl JS > \sql
Switching to SQL mode... Commands end with ;
MySQL localhost:4409 ssl SQL > use performance_schema
Default schema set to `performance_schema`.
Fetching table and column names from `performance_schema` for auto-completion... Press ^C to stop.
MySQL localhost:4409 ssl performance_schema SQL > select * from replication_connection_status;
ERROR: ClassicResult.fetchOne: Valid month range is 1-12
How to repeat:
1. setup innodb cluster
2. insert some record
3. use mysqlsh client execute use performance_schema; select * from replication_connection_status;
Description: hongbin@MBP ~/w/mysql-server> mysql -uroot -proot -P4409 -h127.0.0.1 mysql: [Warning] Using a password on the command line interface can be insecure. Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 31 Server version: 5.7.22-debug-log Homebrew Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> use performance_schema Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A mysql> select * from replication_connection_status\G *************************** 1. row *************************** CHANNEL_NAME: group_replication_recovery GROUP_NAME: SOURCE_UUID: THREAD_ID: NULL SERVICE_STATE: OFF COUNT_RECEIVED_HEARTBEATS: 0 LAST_HEARTBEAT_TIMESTAMP: 0000-00-00 00:00:00 RECEIVED_TRANSACTION_SET: LAST_ERROR_NUMBER: 0 LAST_ERROR_MESSAGE: LAST_ERROR_TIMESTAMP: 0000-00-00 00:00:00 *************************** 2. row *************************** CHANNEL_NAME: group_replication_applier GROUP_NAME: b05e9aa0-59e0-11e8-aa25-6ccdbf577238 SOURCE_UUID: b05e9aa0-59e0-11e8-aa25-6ccdbf577238 THREAD_ID: NULL SERVICE_STATE: ON COUNT_RECEIVED_HEARTBEATS: 0 LAST_HEARTBEAT_TIMESTAMP: 0000-00-00 00:00:00 RECEIVED_TRANSACTION_SET: 0a58a2de-59dd-11e8-8020-c67e22318e38:1-14, b05e9aa0-59e0-11e8-aa25-6ccdbf577238:1-20450 LAST_ERROR_NUMBER: 0 LAST_ERROR_MESSAGE: LAST_ERROR_TIMESTAMP: 0000-00-00 00:00:00 2 rows in set (0.00 sec) hongbin@MBP ~/w/mysql-server> mysqlsh MySQL Shell 8.0.11 Copyright (c) 2016, 2018, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type '\help' or '\?' for help; '\quit' to exit. MySQL JS > \c root@localhost:4409 Creating a session to 'root@localhost:4409' Enter password: Fetching schema names for autocompletion... Press ^C to stop. Your MySQL connection id is 30 Server version: 5.7.22-debug-log Homebrew No default schema selected; type \use <schema> to set one. MySQL localhost:4409 ssl JS > \sql Switching to SQL mode... Commands end with ; MySQL localhost:4409 ssl SQL > use performance_schema Default schema set to `performance_schema`. Fetching table and column names from `performance_schema` for auto-completion... Press ^C to stop. MySQL localhost:4409 ssl performance_schema SQL > select * from replication_connection_status; ERROR: ClassicResult.fetchOne: Valid month range is 1-12 How to repeat: 1. setup innodb cluster 2. insert some record 3. use mysqlsh client execute use performance_schema; select * from replication_connection_status;