Bug #114771 Mysql 8.3.0 group replication causes the cluster to crash during large transacti
Submitted: 25 Apr 3:20 Modified: 7 May 7:41
Reporter: David David Email Updates:
Status: Not a Bug Impact on me:
Category:MySQL Server Severity:S3 (Non-critical)
Version:8.3.0 OS:Linux (7.9.2009 (Core))
Assigned to: MySQL Verification Team CPU Architecture:x86 (Intel(R) Xeon(R) CPU E5-2620 v4 @ 2.10GHz)

[25 Apr 3:20] David David
I have a three-node group replication cluster on a VMware virtual machine. Because I must have a large transaction, I turned off the group_replication_transaction_size_limit limit. My purpose is to copy the data of one table to another table, where the table data is about 1G. , for example: inset a select * from b, it will cause the cluster to crash, and there will be the following error in the log:
2024-04-25T19:07:01.265995+08:00 0 [ERROR] [MY-011495] [Repl] Plugin group_replication reported: 'This server is not able to reach a majority of members in the group. This server will now block all updates. The server will remain blocked until contact with the majority is restored. It is possible to use group_replication_force_members to force a new group membership.'
2024-04-25T19:07:01.265996+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Shutting down an outgoing connection. This happens because something might be wrong on a bi- directional connection to node Please check the connection status to this member'

I checked my network and there was no congestion issue, how can I set it up to support this transaction

How to repeat:
Create a larger table, and then use insert to insert the data into another table. It is easy to reproduce the problem.
[7 May 7:41] MySQL Verification Team
We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

For details on getting support for MySQL products see http://www.mysql.com/support/
You can also check our forums (free) at http://forums.mysql.com/

Thank you for your interest in MySQL.