Description:
use statement "create table xxx as select ..." in MGR ,cause master node offline
How to repeat:
execute the case in GR's master node
create table t1(c1 int,primary key(c1));
create table t2 as select * from t1;
insert into t1 values(1);
create table t3 as select * from t1;
==>
mysql> create table t1(c1 int,primary key(c1));
--------------
create table t1(c1 int,primary key(c1))
--------------
Query OK, 0 rows affected (0.11 sec)
mysql> create table t2 as select * from t1;
--------------
create table t2 as select * from t1
--------------
Query OK, 0 rows affected (0.15 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> insert into t1 values(1);
--------------
insert into t1 values(1)
--------------
Query OK, 1 row affected (0.01 sec)
mysql> create table t3 as select * from t1;
--------------
create table t3 as select * from t1
--------------
ERROR 2013 (HY000): Lost connection to MySQL server during query
mysql> desc t2;
--------------
desc t2
--------------
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 2
Current database: glow
+-------+---------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+---------+------+-----+---------+-------+
| c1 | int(11) | NO | | NULL | |
+-------+---------+------+-----+---------+-------+
1 row in set (0.04 sec)
mysql> SELECT * FROM performance_schema.replication_group_members;
--------------
SELECT * FROM performance_schema.replication_group_members
--------------
+---------------------------+-----------+-------------+-------------+--------------+
| CHANNEL_NAME | MEMBER_ID | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE |
+---------------------------+-----------+-------------+-------------+--------------+
| group_replication_applier | | | NULL | OFFLINE |
+---------------------------+-----------+-------------+-------------+--------------+
1 row in set (0.00 sec)
mysql>