2023-09-11T07:30:03.744547Z 0 [Warning] Plugin group_replication reported: 'Member with address db7-fw-us-east.sa.fwmrm.net:3306 has beco
me unreachable.'
2023-09-11T07:30:03.744598Z 0 [Warning] Plugin group_replication reported: 'Member with address db7-fw-us-east.sa.fwmrm.net:3306 is reach
able again.'
2023-09-11T07:30:03.744644Z 0 [Note] Plugin group_replication reported: '[GCS] Removing members that have failed while processing new vie
w.'
2023-09-11T07:30:03.746467Z 0 [Warning] Plugin group_replication reported: 'Member with address db7-fw-us-east.sa.fwmrm.net:3306 has beco
me unreachable.'
2023-09-11T07:30:03.746500Z 0 [Note] Plugin group_replication reported: '[GCS] Removing members that have failed while processing new vie
w.'
2023-09-11T07:30:20.118593Z 0 [Warning] Plugin group_replication reported: 'Member with address db7-fw-us-east.sa.fwmrm.net:3306 is reach
able again.'
2023-09-11T07:30:20.119125Z 0 [ERROR] Plugin group_replication reported: 'Member was expelled from the group due to network failures, cha
nging member status to ERROR.'
2023-09-11T07:30:20.134095Z 0 [Note] Plugin group_replication reported: 'Going to wait for view modification'
2023-09-11T07:30:20.134159Z 0 [ERROR] Plugin group_replication reported: 'Message received while the plugin is not ready, message discard
ed'
2023-09-11T07:30:20.134186Z 0 [ERROR] Plugin group_replication reported: 'Message received while the plugin is not ready, message discard
ed'
2023-09-11T07:30:20.134201Z 0 [ERROR] Plugin group_replication reported: 'Message received while the plugin is not ready, message discard
ed'
2023-09-11T07:30:20.134251Z 0 [ERROR] Plugin group_replication reported: 'This server is not able to reach a majority of members in the g
roup. 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.'
2023-09-11T07:30:20.134270Z 0 [Note] Plugin group_replication reported: '[GCS] Removing members that have failed while processing new vie
w.'
2023-09-11T07:30:20.134344Z 0 [Warning] Plugin group_replication reported: 'The member has resumed contact with a majority of the members
 in the group. Regular operation is restored and transactions are unblocked.'
2023-09-11T07:30:20.134396Z 0 [Warning] Plugin group_replication reported: 'Skipping this round of stable set computation as certificatio
n garbage collection process is still running.'
2023-09-11T07:30:20.134509Z 0 [Warning] Plugin group_replication reported: 'Skipping this round of stable set computation as certificatio
n garbage collection process is still running.'
2023-09-11T07:30:20.134575Z 0 [Note] Plugin group_replication reported: 'Old incarnation found while trying to remove node db7-fw-us-east
.sa.fwmrm.net:33061 16820714597004500.'
2023-09-11T07:30:20.135773Z 0 [ERROR] Plugin group_replication reported: 'There was a previous plugin error while the member joined the g
roup. The member will now exit the group.'
2023-09-11T07:41:09.153231Z 0 [Note] Plugin group_replication reported: 'Members joined the group: db7-fw-us-east.sa.fwmrm.net:3306'
2023-09-11T07:41:09.153383Z 0 [Warning] Plugin group_replication reported: 'Unable to set any member as primary. No suitable candidate.'
2023-09-11T07:41:09.153496Z 0 [Note] Plugin group_replication reported: 'Group membership changed to db7-fw-us-east.sa.fwmrm.net:3306, db
8-fw-us-east.sa.fwmrm.net:3306, db9-fw-us-east.sa.fwmrm.net:3306 on view 16550052402565658:52.'
2023-09-11T07:42:29.568705Z 0 [Note] Giving 8 client threads a chance to die gracefully
2023-09-11T07:42:29.568763Z 0 [Note] Shutting down slave threads
2023-09-11T07:42:37.572949Z 114926879 [Note] Error reading relay log event for channel 'group_replication_applier': slave SQL thread was
killed
2023-09-11T07:42:37.910130Z 114926879 [Note] Slave SQL thread for channel 'group_replication_applier' exiting, replication stopped in log
 'FIRST' at position 1250
2023-09-11T07:42:39.572732Z 0 [Note] Forcefully disconnecting 2 remaining clients
2023-09-11T07:42:39.572800Z 0 [Note] Plugin group_replication reported: 'Plugin 'group_replication' is stopping.'
2023-09-11T07:42:39.572832Z 0 [Note] Plugin group_replication reported: 'Going to wait for view modification'
2023-09-11T07:42:40.041214Z 0 [ERROR] Plugin group_replication reported: 'Error, maximum number of retries exceeded when waiting for the
internal server session state to be operating'
2023-09-11T07:42:40.041266Z 0 [ERROR] Plugin group_replication reported: 'Can't establish a internal server connection to execute plugin
operations'
2023-09-11T07:42:40.041280Z 0 [Warning] Plugin group_replication reported: 'Error when extracting information for group change. Operation
s and checks made to group joiners may be incomplete'
2023-09-11T07:42:45.415788Z 0 [ERROR] Plugin group_replication reported: 'Error, maximum number of retries exceeded when waiting for the
internal server session state to be operating'
2023-09-11T07:42:45.415841Z 0 [ERROR] Plugin group_replication reported: 'Can't establish a internal server connection to execute plugin
operations'
2023-09-11T07:42:45.415854Z 0 [Warning] Plugin group_replication reported: 'Unable to open session to (re)set read only mode. Skipping.'
2023-09-11T07:42:45.415871Z 0 [Note] Plugin group_replication reported: 'Group membership changed: This member has left the group.'
2023-09-11T07:42:50.427759Z 114926876 [Note] Plugin group_replication reported: 'The group replication applier thread was killed'
2023-09-11T07:42:56.647421Z 0 [Note] Plugin group_replication reported: 'Plugin 'group_replication' has been stopped.'
2023-09-11T07:42:56.647472Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2023-09-11T07:42:56.654095Z 0 [Note] Binlog end
2023-09-11T07:43:02.518490Z 0 [Note] Shutting down plugin 'group_replication'
2023-09-11T07:43:02.518555Z 0 [Note] Plugin group_replication reported: 'All Group Replication server observers have been successfully un
registered'
2023-09-11T07:43:02.518574Z 0 [Note] Shutting down plugin 'auth_socket'
2023-09-11T07:43:02.518709Z 0 [Note] Shutting down plugin 'ngram'
2023-09-11T07:43:02.518714Z 0 [Note] Shutting down plugin 'partition'
2023-09-11T07:43:02.518729Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2023-09-11T07:43:02.518733Z 0 [Note] Shutting down plugin 'ARCHIVE'
2023-09-11T07:43:02.518735Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2023-09-11T07:43:02.518771Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2023-09-11T07:43:02.519145Z 0 [Note] Shutting down plugin 'MyISAM'
2023-09-11T07:43:02.519461Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2023-09-11T07:43:02.519466Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2023-09-11T07:43:02.519468Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2023-09-11T07:43:02.519470Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2023-09-11T07:43:02.519472Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2023-09-11T07:43:02.519474Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2023-09-11T07:43:02.519476Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2023-09-11T07:43:02.519478Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2023-09-11T07:43:02.519481Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2023-09-11T07:43:02.519483Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2023-09-11T07:43:02.519485Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2023-09-11T07:43:02.519487Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2023-09-11T07:43:02.519489Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2023-09-11T07:43:02.519491Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2023-09-11T07:43:02.519492Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2023-09-11T07:43:02.519495Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2023-09-11T07:43:02.519497Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2023-09-11T07:43:02.519499Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2023-09-11T07:43:02.519502Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2023-09-11T07:43:02.519504Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2023-09-11T07:43:02.519506Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2023-09-11T07:43:02.519508Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2023-09-11T07:43:02.519510Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2023-09-11T07:43:02.519512Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2023-09-11T07:43:02.519514Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2023-09-11T07:43:02.519517Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2023-09-11T07:43:02.519519Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2023-09-11T07:43:02.519521Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2023-09-11T07:43:02.519523Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2023-09-11T07:43:02.519525Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2023-09-11T07:43:02.519527Z 0 [Note] Shutting down plugin 'InnoDB'
2023-09-11T07:43:02.520020Z 0 [Note] InnoDB: FTS optimize thread exiting.
2023-09-11T07:43:02.520173Z 0 [Note] InnoDB: Starting shutdown...
2023-09-11T07:43:49.811940Z 0 [Note] InnoDB: Shutdown completed; log sequence number 3403828098900
2023-09-11T07:43:49.812372Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2023-09-11T07:43:49.812390Z 0 [Note] Shutting down plugin 'MEMORY'
2023-09-11T07:43:49.812395Z 0 [Note] Shutting down plugin 'CSV'
2023-09-11T07:43:49.812401Z 0 [Note] Shutting down plugin 'sha256_password'
2023-09-11T07:43:49.812404Z 0 [Note] Shutting down plugin 'mysql_native_password'
2023-09-11T07:43:49.813439Z 0 [Note] Shutting down plugin 'binlog'
2023-09-11T07:43:49.815324Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2023-09-11T07:43:57.563324Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with
strict mode. They will be merged with strict mode in a future release.
2023-09-11T07:43:57.563402Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2023-09-11T07:43:57.564835Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.36-log) starting as process 877635 ...
2023-09-11T07:43:57.577380Z 0 [Note] InnoDB: PUNCH HOLE support available
2023-09-11T07:43:57.577418Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2023-09-11T07:43:57.577421Z 0 [Note] InnoDB: Uses event mutexes
2023-09-11T07:43:57.577424Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2023-09-11T07:43:57.577426Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2023-09-11T07:43:57.577431Z 0 [Note] InnoDB: Using Linux native AIO
2023-09-11T07:43:57.578100Z 0 [Note] InnoDB: Number of pools: 1
2023-09-11T07:43:57.578307Z 0 [Note] InnoDB: Using CPU crc32 instructions
2023-09-11T07:43:57.581594Z 0 [Note] InnoDB: Initializing buffer pool, total size = 200G, instances = 16, chunk size = 128M
2023-09-11T07:44:05.387891Z 0 [Note] InnoDB: Completed initialization of buffer pool
2023-09-11T07:44:06.500732Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See
 the man page of setpriority().
2023-09-11T07:44:06.507050Z 0 [Note] InnoDB: Opened 3 undo tablespaces
2023-09-11T07:44:06.507065Z 0 [Note] InnoDB: 3 undo tablespaces made active
2023-09-11T07:44:06.507220Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2023-09-11T07:44:09.075847Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-09-11T07:44:09.075996Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-09-11T07:44:09.141856Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2023-09-11T07:44:09.146239Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2023-09-11T07:44:09.146270Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2023-09-11T07:44:09.147366Z 0 [Note] InnoDB: Waiting for purge to start
2023-09-11T07:44:09.198040Z 0 [Note] InnoDB: 5.7.36 started; log sequence number 3403828098900
2023-09-11T07:44:09.200089Z 0 [Note] Plugin 'FEDERATED' is disabled.
2023-09-11T07:44:09.462557Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support usi
ng them.
2023-09-11T07:44:09.462582Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2023-09-11T07:44:09.462599Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
2023-09-11T07:44:09.462602Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
2023-09-11T07:44:09.463573Z 0 [Warning] CA certificate ca.pem is self signed.
2023-09-11T07:44:09.463653Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2023-09-11T07:44:09.463940Z 0 [Note] Server hostname (bind-address): '10.13.17.11'; port: 3306
2023-09-11T07:44:09.463966Z 0 [Note]   - '10.13.17.11' resolves to '10.13.17.11';
2023-09-11T07:44:09.464076Z 0 [Note] Server socket created on IP: '10.13.17.11'.
2023-09-11T07:44:09.469371Z 0 [Warning] 'user' entry 'root@ns231760.ovh.net' ignored in --skip-name-resolve mode.
2023-09-11T07:44:09.673264Z 0 [Note] Event Scheduler: Loaded 0 events
2023-09-11T07:44:09.673515Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.36-log'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server (GPL)
2023-09-11T07:44:09.674135Z 2 [Note] Plugin group_replication reported: 'Group communication SSL configuration: group_replication_ssl_mod
e: "REQUIRED"; server_key_file: "server-key.pem"; server_cert_file: "server-cert.pem"; client_key_file: "server-key.pem"; client_cert_fil
e: "server-cert.pem"; ca_file: "ca.pem"; ca_path: ""; cipher: ""; tls_version: "TLSv1,TLSv1.1,TLSv1.2"; crl_file: ""; crl_path: ""'
2023-09-11T07:44:09.674415Z 2 [Note] Plugin group_replication reported: '[GCS] Added automatically IP ranges 10.13.17.11/17,10.254.244.71
/20,127.0.0.1/8 to the whitelist'
2023-09-11T07:44:09.674893Z 2 [Note] Plugin group_replication reported: '[GCS] Translated 'db8-fw-us-east.sa.fwmrm.net' to 10.13.17.11'
2023-09-11T07:44:09.675203Z 2 [Warning] Plugin group_replication reported: '[GCS] Automatically adding IPv4 localhost address to the whit
elist. It is mandatory that it is added.'
2023-09-11T07:44:09.677248Z 2 [Note] Plugin group_replication reported: 'Initialized group communication with configuration: group_replic
ation_group_name: "82e0638a-e968-11ec-9a76-9cdc71bc2950"; group_replication_local_address: "db8-fw-us-east.sa.fwmrm.net:33061"; group_rep
lication_group_seeds: "db7-fw-us-east.sa.fwmrm.net:33061,db9-fw-us-east.sa.fwmrm.net:33061"; group_replication_bootstrap_group: false; gr
oup_replication_poll_spin_loops: 0; group_replication_compression_threshold: 1000000; group_replication_ip_whitelist: "AUTOMATIC"'
2023-09-11T07:44:09.677321Z 2 [Note] Plugin group_replication reported: '[GCS] Configured number of attempts to join: 0'
2023-09-11T07:44:09.677337Z 2 [Note] Plugin group_replication reported: '[GCS] Configured time between attempts to join: 5 seconds'
2023-09-11T07:44:09.677365Z 2 [Note] Plugin group_replication reported: 'Member configuration: member_id: 10131711; member_uuid: "c07ce69
f-e886-11ec-8aef-08f1ea7dba36"; single-primary mode: "true"; group_replication_auto_increment_increment: 7; '
2023-09-11T07:44:09.678309Z 6 [Note] 'CHANGE MASTER TO FOR CHANNEL 'group_replication_applier' executed'. Previous state master_host='<NU
LL>', master_port= 0, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='<NULL>', master_port= 0, master_log_f
ile='', master_log_pos= 4, master_bind=''.
2023-09-11T07:44:09.688682Z 9 [Note] Slave SQL thread for channel 'group_replication_applier' initialized, starting replication in log 'F
IRST' at position 0, relay log './db8-fw-us-east-relay-bin-group_replication_applier.002360' position: 4
2023-09-11T07:44:09.688728Z 2 [Note] Plugin group_replication reported: 'Group Replication applier module successfully initialized!'
2023-09-11T07:44:09.726568Z 0 [Note] Plugin group_replication reported: 'XCom protocol version: 3'
2023-09-11T07:44:09.726594Z 0 [Note] Plugin group_replication reported: 'XCom initialized and ready to accept incoming connections on por
t 33061'
2023-09-11T07:44:09.760783Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to db7-fw-us-east.sa.fwmrm.
net:33061 on local port: 33061.'
2023-09-11T07:44:09.761027Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to db9-fw-us-east.sa.fwmrm.
net:33061 on local port: 33061.'
2023-09-11T07:44:09.761251Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to db7-fw-us-east.sa.fwmrm.
net:33061 on local port: 33061.'
2023-09-11T07:44:09.761457Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to db9-fw-us-east.sa.fwmrm.
net:33061 on local port: 33061.'
2023-09-11T07:44:09.761611Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to db7-fw-us-east.sa.fwmrm.
net:33061 on local port: 33061.'
2023-09-11T07:44:09.761816Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to db9-fw-us-east.sa.fwmrm.
net:33061 on local port: 33061.'
2023-09-11T07:44:09.762020Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to db7-fw-us-east.sa.fwmrm.
net:33061 on local port: 33061.'
2023-09-11T07:44:09.762246Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to db9-fw-us-east.sa.fwmrm.
net:33061 on local port: 33061.'
2023-09-11T07:44:09.762472Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to db7-fw-us-east.sa.fwmrm.
net:33061 on local port: 33061.'
2023-09-11T07:44:09.762626Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to db9-fw-us-east.sa.fwmrm.
net:33061 on local port: 33061.'
2023-09-11T07:44:09.762835Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to db7-fw-us-east.sa.fwmrm.
net:33061 on local port: 33061.'
2023-09-11T07:44:09.763043Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to db9-fw-us-east.sa.fwmrm.
net:33061 on local port: 33061.'
2023-09-11T07:44:09.763210Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to db7-fw-us-east.sa.fwmrm.
net:33061 on local port: 33061.'
2023-09-11T07:44:09.763435Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to db9-fw-us-east.sa.fwmrm.
net:33061 on local port: 33061.'
2023-09-11T07:44:09.763603Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to db7-fw-us-east.sa.fwmrm.
net:33061 on local port: 33061.'
2023-09-11T07:44:09.763807Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to db9-fw-us-east.sa.fwmrm.
net:33061 on local port: 33061.'
2023-09-11T07:44:09.764016Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to db7-fw-us-east.sa.fwmrm.
net:33061 on local port: 33061.'
2023-09-11T07:44:09.764167Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to db9-fw-us-east.sa.fwmrm.
net:33061 on local port: 33061.'
2023-09-11T07:44:09.764380Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to db7-fw-us-east.sa.fwmrm.
net:33061 on local port: 33061.'
2023-09-11T07:44:09.764530Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to db9-fw-us-east.sa.fwmrm.
net:33061 on local port: 33061.'
2023-09-11T07:44:09.764546Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error connecting to all peers. Member join failed. Local
port: 33061'
2023-09-11T07:44:09.764676Z 0 [Warning] Plugin group_replication reported: 'read failed'
2023-09-11T07:44:09.772974Z 0 [ERROR] Plugin group_replication reported: '[GCS] The member was unable to join the group. Local port: 3306
1'
2023-09-11T07:44:37.577721Z 837 [Note] Start binlog_dump to master_thread_id(837) slave_server(53), pos(, 4)
2023-09-11T07:44:56.527194Z 1391 [Note] Start binlog_dump to master_thread_id(1391) slave_server(1013173), pos(, 4)
2023-09-11T07:45:09.688899Z 2 [ERROR] Plugin group_replication reported: 'Timeout on wait for view after joining group'
2023-09-11T07:45:09.688964Z 2 [Note] Plugin group_replication reported: 'Requesting to leave the group despite of not being a member'
2023-09-11T07:45:09.688989Z 2 [ERROR] Plugin group_replication reported: '[GCS] The member is leaving a group without being on one.'
2023-09-11T07:45:09.689541Z 9 [Note] Error reading relay log event for channel 'group_replication_applier': slave SQL thread was killed
2023-09-11T07:45:09.689735Z 9 [Note] Slave SQL thread for channel 'group_replication_applier' exiting, replication stopped in log 'FIRST'
 at position 1250
2023-09-11T07:45:09.690500Z 6 [Note] Plugin group_replication reported: 'The group replication applier thread was killed'
2023-09-11T07:47:30.432788Z 2310 [Note] Plugin group_replication reported: 'Group communication SSL configuration: group_replication_ssl_
mode: "REQUIRED"; server_key_file: "server-key.pem"; server_cert_file: "server-cert.pem"; client_key_file: "server-key.pem"; client_cert_
file: "server-cert.pem"; ca_file: "ca.pem"; ca_path: ""; cipher: ""; tls_version: "TLSv1,TLSv1.1,TLSv1.2"; crl_file: ""; crl_path: ""'
2023-09-11T07:47:30.432965Z 2310 [Note] Plugin group_replication reported: '[GCS] Added automatically IP ranges 10.13.17.11/17,10.254.244
.71/20,127.0.0.1/8 to the whitelist'
2023-09-11T07:47:30.433143Z 2310 [Note] Plugin group_replication reported: '[GCS] Translated 'db8-fw-us-east.sa.fwmrm.net' to 10.13.17.11
'
2023-09-11T07:47:30.433303Z 2310 [Warning] Plugin group_replication reported: '[GCS] Automatically adding IPv4 localhost address to the w
hitelist. It is mandatory that it is added.'
2023-09-11T07:47:30.435548Z 2310 [Note] Plugin group_replication reported: 'Initialized group communication with configuration: group_rep
lication_group_name: "82e0638a-e968-11ec-9a76-9cdc71bc2950"; group_replication_local_address: "db8-fw-us-east.sa.fwmrm.net:33061"; group_
replication_group_seeds: "db7-fw-us-east.sa.fwmrm.net:33061,db9-fw-us-east.sa.fwmrm.net:33061"; group_replication_bootstrap_group: false;
 group_replication_poll_spin_loops: 0; group_replication_compression_threshold: 1000000; group_replication_ip_whitelist: "AUTOMATIC"'
2023-09-11T07:47:30.435621Z 2310 [Note] Plugin group_replication reported: '[GCS] Configured number of attempts to join: 0'
2023-09-11T07:47:30.435633Z 2310 [Note] Plugin group_replication reported: '[GCS] Configured time between attempts to join: 5 seconds'
2023-09-11T07:47:30.435663Z 2310 [Note] Plugin group_replication reported: 'Member configuration: member_id: 10131711; member_uuid: "c07c
e69f-e886-11ec-8aef-08f1ea7dba36"; single-primary mode: "true"; group_replication_auto_increment_increment: 7; '
2023-09-11T07:47:30.436099Z 2313 [Note] 'CHANGE MASTER TO FOR CHANNEL 'group_replication_applier' executed'. Previous state master_host='
<NULL>', master_port= 0, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='<NULL>', master_port= 0, master_lo
g_file='', master_log_pos= 4, master_bind=''.
2023-09-11T07:47:30.446552Z 2310 [Note] Plugin group_replication reported: 'Group Replication applier module successfully initialized!'
2023-09-11T07:47:30.446555Z 2316 [Note] Slave SQL thread for channel 'group_replication_applier' initialized, starting replication in log
 'FIRST' at position 0, relay log './db8-fw-us-east-relay-bin-group_replication_applier.002360' position: 4
2023-09-11T07:47:30.446862Z 0 [Note] Plugin group_replication reported: 'XCom protocol version: 3'
2023-09-11T07:47:30.446915Z 0 [Note] Plugin group_replication reported: 'XCom initialized and ready to accept incoming connections on por
t 33061'
2023-09-11T07:47:35.028736Z 2310 [Note] Plugin group_replication reported: 'This server is working as secondary member with primary membe
r address db7-fw-us-east.sa.fwmrm.net:3306.'
2023-09-11T07:47:35.028782Z 0 [ERROR] Plugin group_replication reported: 'Group contains 2 members which is greater than auto_increment_i
ncrement value of 1. This can lead to an higher rate of transactional aborts.'
2023-09-11T07:47:35.029083Z 2324 [Note] Plugin group_replication reported: 'Establishing group recovery connection with a possible donor.
 Attempt 1/10'
2023-09-11T07:47:35.029132Z 0 [Note] Plugin group_replication reported: 'Group membership changed to db7-fw-us-east.sa.fwmrm.net:3306, db
8-fw-us-east.sa.fwmrm.net:3306 on view 16944183276594499:2.'
2023-09-11T07:47:35.040526Z 2324 [Note] 'CHANGE MASTER TO FOR CHANNEL 'group_replication_recovery' executed'. Previous state master_host=
'<NULL>', master_port= 0, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='db7-fw-us-east.sa.fwmrm.net', mas
ter_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''.
2023-09-11T07:47:35.049764Z 2324 [Note] Plugin group_replication reported: 'Establishing connection to a group replication recovery donor
 be6c6809-e886-11ec-a496-9cdc71bc2950 at db7-fw-us-east.sa.fwmrm.net port: 3306.'
2023-09-11T07:47:35.050129Z 2326 [Warning] Storing MySQL user name or password information in the master info repository is not secure an
d is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Synt
ax' in the MySQL Manual for more information.
2023-09-11T07:47:35.053590Z 2327 [Note] Slave SQL thread for channel 'group_replication_recovery' initialized, starting replication in lo
g 'FIRST' at position 0, relay log './db8-fw-us-east-relay-bin-group_replication_recovery.000001' position: 4
2023-09-11T07:47:35.062486Z 2326 [Note] Slave I/O thread for channel 'group_replication_recovery': connected to master 'mysql_innodb_clus
ter_10131711@db7-fw-us-east.sa.fwmrm.net:3306',replication started in log 'FIRST' at position 4
2023-09-11T07:47:35.607900Z 2329 [ERROR] Slave SQL for channel 'group_replication_recovery': Worker 2 failed executing transaction '82e06
38a-e968-11ec-9a76-9cdc71bc2950:774245300' at master log mysql-bin.004136, end_log_pos 535344; Could not execute Write_rows event on tabl
e stickyads.campaigns; Duplicate entry '2761231785' for key 'PRIMARY', Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event's
 master log mysql-bin.004136, end_log_pos 535344, Error_code: 1062
2023-09-11T07:47:35.608528Z 2324 [Note] Plugin group_replication reported: 'Terminating existing group replication donor connection and p
urging the corresponding logs.'
2023-09-11T07:47:35.609430Z 2327 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread
 with "SLAVE START". We stopped at log 'mysql-bin.004136' position 534736.
2023-09-11T07:47:35.609892Z 2326 [Note] Slave I/O thread killed while reading event for channel 'group_replication_recovery'
2023-09-11T07:47:35.609914Z 2326 [Note] Slave I/O thread exiting for channel 'group_replication_recovery', read up to log 'mysql-bin.0041
36', position 25735028
2023-09-11T07:47:35.613314Z 2324 [Note] Plugin group_replication reported: 'Retrying group recovery connection with another donor. Attemp
t 2/10'
2023-09-11T07:47:39.036372Z 0 [Note] Plugin group_replication reported: 'Members joined the group: db9-fw-us-east.sa.fwmrm.net:3306'
2023-09-11T07:47:39.036549Z 0 [Note] Plugin group_replication reported: 'Group membership changed to db7-fw-us-east.sa.fwmrm.net:3306, db
8-fw-us-east.sa.fwmrm.net:3306, db9-fw-us-east.sa.fwmrm.net:3306 on view 16944183276594499:3.'
2023-09-11T07:48:35.631826Z 2324 [Note] 'CHANGE MASTER TO FOR CHANNEL 'group_replication_recovery' executed'. Previous state master_host=
'db7-fw-us-east.sa.fwmrm.net', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='db7-fw-us
-east.sa.fwmrm.net', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''.
2023-09-11T07:48:35.642084Z 2324 [Note] Plugin group_replication reported: 'Establishing connection to a group replication recovery donor
 be6c6809-e886-11ec-a496-9cdc71bc2950 at db7-fw-us-east.sa.fwmrm.net port: 3306.'
2023-09-11T07:48:35.642518Z 2361 [Warning] Storing MySQL user name or password information in the master info repository is not secure an
d is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Synt
ax' in the MySQL Manual for more information.
2023-09-11T07:48:35.647969Z 2362 [Note] Slave SQL thread for channel 'group_replication_recovery' initialized, starting replication in lo
g 'FIRST' at position 0, relay log './db8-fw-us-east-relay-bin-group_replication_recovery.000001' position: 4
2023-09-11T07:48:35.655837Z 2361 [Note] Slave I/O thread for channel 'group_replication_recovery': connected to master 'mysql_innodb_clus
ter_10131711@db7-fw-us-east.sa.fwmrm.net:3306',replication started in log 'FIRST' at position 4
2023-09-11T07:48:35.668743Z 2363 [ERROR] Slave SQL for channel 'group_replication_recovery': Worker 1 failed executing transaction '82e06
38a-e968-11ec-9a76-9cdc71bc2950:774245300' at master log mysql-bin.004136, end_log_pos 535344; Could not execute Write_rows event on tabl
e stickyads.campaigns; Duplicate entry '2761231785' for key 'PRIMARY', Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event's
 master log FIRST, end_log_pos 535344, Error_code: 1062
2023-09-11T07:48:35.668901Z 2324 [Note] Plugin group_replication reported: 'Terminating existing group replication donor connection and p
urging the corresponding logs.'
2023-09-11T07:48:35.668969Z 2362 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread
 with "SLAVE START". We stopped at log 'mysql-bin.004136' position 534736.
2023-09-11T07:48:35.669667Z 2361 [Note] Slave I/O thread exiting for channel 'group_replication_recovery', read up to log 'mysql-bin.0041
36', position 558423
2023-09-11T07:48:35.683659Z 2324 [Note] Plugin group_replication reported: 'Retrying group recovery connection with another donor. Attemp
t 3/10'
2023-09-11T07:49:35.696844Z 2324 [Note] 'CHANGE MASTER TO FOR CHANNEL 'group_replication_recovery' executed'. Previous state master_host=
'db7-fw-us-east.sa.fwmrm.net', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='db7-fw-us
-east.sa.fwmrm.net', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''.
2023-09-11T07:49:35.705936Z 2324 [Note] Plugin group_replication reported: 'Establishing connection to a group replication recovery donor
 be6c6809-e886-11ec-a496-9cdc71bc2950 at db7-fw-us-east.sa.fwmrm.net port: 3306.'
2023-09-11T07:49:35.706188Z 2388 [Warning] Storing MySQL user name or password information in the master info repository is not secure an
d is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Synt
ax' in the MySQL Manual for more information.
2023-09-11T07:49:35.710175Z 2389 [Note] Slave SQL thread for channel 'group_replication_recovery' initialized, starting replication in lo
g 'FIRST' at position 0, relay log './db8-fw-us-east-relay-bin-group_replication_recovery.000001' position: 4
2023-09-11T07:49:35.714604Z 2388 [Note] Slave I/O thread for channel 'group_replication_recovery': connected to master 'mysql_innodb_clus
ter_10131711@db7-fw-us-east.sa.fwmrm.net:3306',replication started in log 'FIRST' at position 4
2023-09-11T07:49:35.727081Z 2390 [ERROR] Slave SQL for channel 'group_replication_recovery': Worker 1 failed executing transaction '82e06
38a-e968-11ec-9a76-9cdc71bc2950:774245300' at master log mysql-bin.004136, end_log_pos 535344; Could not execute Write_rows event on tabl
e stickyads.campaigns; Duplicate entry '2761231785' for key 'PRIMARY', Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event's
 master log FIRST, end_log_pos 535344, Error_code: 1062
2023-09-11T07:49:35.727162Z 2389 [Warning] Slave SQL for channel 'group_replication_recovery': ... The slave coordinator and worker threa
ds are stopped, possibly leaving data in inconsistent state. A restart should restore consistency automatically, although using non-trans
actional storage for data or info tables or DDL queries could lead to problems. In such cases you have to examine your data (see document
ation for details). Error_code: 1756
2023-09-11T07:49:35.727246Z 2324 [Note] Plugin group_replication reported: 'Terminating existing group replication donor connection and p
urging the corresponding logs.'
2023-09-11T07:49:35.727336Z 2389 [Note] Slave SQL thread for channel 'group_replication_recovery' exiting, replication stopped in log 'my
sql-bin.004136' at position 534736
2023-09-11T07:49:35.727730Z 2388 [Note] Slave I/O thread exiting for channel 'group_replication_recovery', read up to log 'mysql-bin.0041
36', position 550197
2023-09-11T07:49:35.741165Z 2324 [Note] Plugin group_replication reported: 'Retrying group recovery connection with another donor. Attemp
t 4/10'
2023-09-11T07:50:35.753639Z 2324 [Note] 'CHANGE MASTER TO FOR CHANNEL 'group_replication_recovery' executed'. Previous state master_host=
'db7-fw-us-east.sa.fwmrm.net', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='db7-fw-us
-east.sa.fwmrm.net', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''.
2023-09-11T07:50:35.763171Z 2324 [Note] Plugin group_replication reported: 'Establishing connection to a group replication recovery donor
 be6c6809-e886-11ec-a496-9cdc71bc2950 at db7-fw-us-east.sa.fwmrm.net port: 3306.'
2023-09-11T07:50:35.763483Z 2413 [Warning] Storing MySQL user name or password information in the master info repository is not secure an
d is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Synt
ax' in the MySQL Manual for more information.
2023-09-11T07:50:35.767612Z 2414 [Note] Slave SQL thread for channel 'group_replication_recovery' initialized, starting replication in lo
g 'FIRST' at position 0, relay log './db8-fw-us-east-relay-bin-group_replication_recovery.000001' position: 4
2023-09-11T07:50:35.777442Z 2413 [Note] Slave I/O thread for channel 'group_replication_recovery': connected to master 'mysql_innodb_clus
ter_10131711@db7-fw-us-east.sa.fwmrm.net:3306',replication started in log 'FIRST' at position 4
2023-09-11T07:50:35.788641Z 2415 [ERROR] Slave SQL for channel 'group_replication_recovery': Worker 1 failed executing transaction '82e06
38a-e968-11ec-9a76-9cdc71bc2950:774245300' at master log mysql-bin.004136, end_log_pos 535344; Could not execute Write_rows event on tabl
e stickyads.campaigns; Duplicate entry '2761231785' for key 'PRIMARY', Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event's
 master log FIRST, end_log_pos 535344, Error_code: 1062
2023-09-11T07:50:35.788770Z 2324 [Note] Plugin group_replication reported: 'Terminating existing group replication donor connection and p
urging the corresponding logs.'
2023-09-11T07:50:35.788844Z 2414 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread
 with "SLAVE START". We stopped at log 'mysql-bin.004136' position 534736.
2023-09-11T07:50:35.789258Z 2413 [Note] Slave I/O thread exiting for channel 'group_replication_recovery', read up to log 'mysql-bin.0041
36', position 548352
2023-09-11T07:50:35.796745Z 2324 [Note] Plugin group_replication reported: 'Retrying group recovery connection with another donor. Attemp
t 5/10'
2023-09-11T07:51:35.808962Z 2324 [Note] 'CHANGE MASTER TO FOR CHANNEL 'group_replication_recovery' executed'. Previous state master_host=
'db7-fw-us-east.sa.fwmrm.net', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='db7-fw-us
-east.sa.fwmrm.net', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''.
2023-09-11T07:51:35.817952Z 2324 [Note] Plugin group_replication reported: 'Establishing connection to a group replication recovery donor
 be6c6809-e886-11ec-a496-9cdc71bc2950 at db7-fw-us-east.sa.fwmrm.net port: 3306.'
2023-09-11T07:51:35.818386Z 2434 [Warning] Storing MySQL user name or password information in the master info repository is not secure an
d is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Synt
ax' in the MySQL Manual for more information.
2023-09-11T07:51:35.822299Z 2435 [Note] Slave SQL thread for channel 'group_replication_recovery' initialized, starting replication in lo
g 'FIRST' at position 0, relay log './db8-fw-us-east-relay-bin-group_replication_recovery.000001' position: 4
2023-09-11T07:51:35.831518Z 2434 [Note] Slave I/O thread for channel 'group_replication_recovery': connected to master 'mysql_innodb_clus
ter_10131711@db7-fw-us-east.sa.fwmrm.net:3306',replication started in log 'FIRST' at position 4
2023-09-11T07:51:35.843434Z 2436 [ERROR] Slave SQL for channel 'group_replication_recovery': Worker 1 failed executing transaction '82e06
38a-e968-11ec-9a76-9cdc71bc2950:774245300' at master log mysql-bin.004136, end_log_pos 535344; Could not execute Write_rows event on tabl
e stickyads.campaigns; Duplicate entry '2761231785' for key 'PRIMARY', Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event's
 master log FIRST, end_log_pos 535344, Error_code: 1062
2023-09-11T07:51:35.843578Z 2324 [Note] Plugin group_replication reported: 'Terminating existing group replication donor connection and p
urging the corresponding logs.'
2023-09-11T07:51:35.843681Z 2435 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread
 with "SLAVE START". We stopped at log 'mysql-bin.004136' position 534736.
2023-09-11T07:51:35.844285Z 2434 [Note] Slave I/O thread exiting for channel 'group_replication_recovery', read up to log 'mysql-bin.0041
36', position 551136
2023-09-11T07:51:35.859898Z 2324 [Note] Plugin group_replication reported: 'Retrying group recovery connection with another donor. Attemp
t 6/10'
2023-09-11T07:52:35.872470Z 2324 [Note] 'CHANGE MASTER TO FOR CHANNEL 'group_replication_recovery' executed'. Previous state master_host=
'db7-fw-us-east.sa.fwmrm.net', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='db7-fw-us
-east.sa.fwmrm.net', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''.
2023-09-11T07:52:35.881336Z 2324 [Note] Plugin group_replication reported: 'Establishing connection to a group replication recovery donor
 be6c6809-e886-11ec-a496-9cdc71bc2950 at db7-fw-us-east.sa.fwmrm.net port: 3306.'
2023-09-11T07:52:35.881663Z 2455 [Warning] Storing MySQL user name or password information in the master info repository is not secure an
d is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Synt
ax' in the MySQL Manual for more information.
2023-09-11T07:52:35.885592Z 2456 [Note] Slave SQL thread for channel 'group_replication_recovery' initialized, starting replication in lo
g 'FIRST' at position 0, relay log './db8-fw-us-east-relay-bin-group_replication_recovery.000001' position: 4
2023-09-11T07:52:35.894624Z 2455 [Note] Slave I/O thread for channel 'group_replication_recovery': connected to master 'mysql_innodb_clus
ter_10131711@db7-fw-us-east.sa.fwmrm.net:3306',replication started in log 'FIRST' at position 4
2023-09-11T07:52:35.906821Z 2457 [ERROR] Slave SQL for channel 'group_replication_recovery': Worker 1 failed executing transaction '82e06
38a-e968-11ec-9a76-9cdc71bc2950:774245300' at master log mysql-bin.004136, end_log_pos 535344; Could not execute Write_rows event on tabl
e stickyads.campaigns; Duplicate entry '2761231785' for key 'PRIMARY', Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event's
 master log FIRST, end_log_pos 535344, Error_code: 1062
2023-09-11T07:52:35.906900Z 2456 [Warning] Slave SQL for channel 'group_replication_recovery': ... The slave coordinator and worker threa
ds are stopped, possibly leaving data in inconsistent state. A restart should restore consistency automatically, although using non-trans
actional storage for data or info tables or DDL queries could lead to problems. In such cases you have to examine your data (see document
ation for details). Error_code: 1756
2023-09-11T07:52:35.906963Z 2324 [Note] Plugin group_replication reported: 'Terminating existing group replication donor connection and p
urging the corresponding logs.'
2023-09-11T07:52:35.907145Z 2456 [Note] Slave SQL thread for channel 'group_replication_recovery' exiting, replication stopped in log 'my
sql-bin.004136' at position 534736
2023-09-11T07:52:35.907861Z 2455 [Note] Slave I/O thread exiting for channel 'group_replication_recovery', read up to log 'mysql-bin.0041
36', position 547472
2023-09-11T07:52:35.921740Z 2324 [Note] Plugin group_replication reported: 'Retrying group recovery connection with another donor. Attemp
t 7/10'
2023-09-11T07:53:35.933221Z 2324 [Note] 'CHANGE MASTER TO FOR CHANNEL 'group_replication_recovery' executed'. Previous state master_host=
'db7-fw-us-east.sa.fwmrm.net', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='db7-fw-us
-east.sa.fwmrm.net', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''.
2023-09-11T07:53:35.942067Z 2324 [Note] Plugin group_replication reported: 'Establishing connection to a group replication recovery donor
 be6c6809-e886-11ec-a496-9cdc71bc2950 at db7-fw-us-east.sa.fwmrm.net port: 3306.'
2023-09-11T07:53:35.942375Z 2482 [Warning] Storing MySQL user name or password information in the master info repository is not secure an
d is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Synt
ax' in the MySQL Manual for more information.
2023-09-11T07:53:35.946267Z 2483 [Note] Slave SQL thread for channel 'group_replication_recovery' initialized, starting replication in lo
g 'FIRST' at position 0, relay log './db8-fw-us-east-relay-bin-group_replication_recovery.000001' position: 4
2023-09-11T07:53:35.953624Z 2482 [Note] Slave I/O thread for channel 'group_replication_recovery': connected to master 'mysql_innodb_clus
ter_10131711@db7-fw-us-east.sa.fwmrm.net:3306',replication started in log 'FIRST' at position 4
2023-09-11T07:53:35.964534Z 2484 [ERROR] Slave SQL for channel 'group_replication_recovery': Worker 1 failed executing transaction '82e06
38a-e968-11ec-9a76-9cdc71bc2950:774245300' at master log mysql-bin.004136, end_log_pos 535344; Could not execute Write_rows event on tabl
e stickyads.campaigns; Duplicate entry '2761231785' for key 'PRIMARY', Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event's
 master log FIRST, end_log_pos 535344, Error_code: 1062
2023-09-11T07:53:35.964656Z 2324 [Note] Plugin group_replication reported: 'Terminating existing group replication donor connection and p
urging the corresponding logs.'
2023-09-11T07:53:35.964813Z 2483 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread
 with "SLAVE START". We stopped at log 'mysql-bin.004136' position 534736.
2023-09-11T07:53:35.965593Z 2482 [Note] Slave I/O thread exiting for channel 'group_replication_recovery', read up to log 'mysql-bin.0041
36', position 562263
2023-09-11T07:53:35.980718Z 2324 [Note] Plugin group_replication reported: 'Retrying group recovery connection with another donor. Attemp
t 8/10'
2023-09-11T07:54:35.993537Z 2324 [Note] 'CHANGE MASTER TO FOR CHANNEL 'group_replication_recovery' executed'. Previous state master_host=
'db7-fw-us-east.sa.fwmrm.net', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='db7-fw-us
-east.sa.fwmrm.net', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''.
2023-09-11T07:54:36.001785Z 2324 [Note] Plugin group_replication reported: 'Establishing connection to a group replication recovery donor
 be6c6809-e886-11ec-a496-9cdc71bc2950 at db7-fw-us-east.sa.fwmrm.net port: 3306.'
2023-09-11T07:54:36.002014Z 2509 [Warning] Storing MySQL user name or password information in the master info repository is not secure an
d is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Synt
ax' in the MySQL Manual for more information.
2023-09-11T07:54:36.005821Z 2510 [Note] Slave SQL thread for channel 'group_replication_recovery' initialized, starting replication in lo
g 'FIRST' at position 0, relay log './db8-fw-us-east-relay-bin-group_replication_recovery.000001' position: 4
2023-09-11T07:54:36.016004Z 2509 [Note] Slave I/O thread for channel 'group_replication_recovery': connected to master 'mysql_innodb_clus
ter_10131711@db7-fw-us-east.sa.fwmrm.net:3306',replication started in log 'FIRST' at position 4
2023-09-11T07:54:36.028517Z 2511 [ERROR] Slave SQL for channel 'group_replication_recovery': Worker 1 failed executing transaction '82e06
38a-e968-11ec-9a76-9cdc71bc2950:774245300' at master log mysql-bin.004136, end_log_pos 535344; Could not execute Write_rows event on tabl
e stickyads.campaigns; Duplicate entry '2761231785' for key 'PRIMARY', Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event's
 master log FIRST, end_log_pos 535344, Error_code: 1062
2023-09-11T07:54:36.028600Z 2510 [Warning] Slave SQL for channel 'group_replication_recovery': ... The slave coordinator and worker threa
ds are stopped, possibly leaving data in inconsistent state. A restart should restore consistency automatically, although using non-trans
actional storage for data or info tables or DDL queries could lead to problems. In such cases you have to examine your data (see document
ation for details). Error_code: 1756
2023-09-11T07:54:36.028683Z 2324 [Note] Plugin group_replication reported: 'Terminating existing group replication donor connection and p
urging the corresponding logs.'
2023-09-11T07:54:36.028754Z 2510 [Note] Slave SQL thread for channel 'group_replication_recovery' exiting, replication stopped in log 'my
sql-bin.004136' at position 534736
2023-09-11T07:54:36.029226Z 2509 [Note] Slave I/O thread exiting for channel 'group_replication_recovery', read up to log 'mysql-bin.0041
36', position 548325
2023-09-11T07:54:36.043396Z 2324 [Note] Plugin group_replication reported: 'Retrying group recovery connection with another donor. Attemp
t 9/10'
2023-09-11T07:55:36.056063Z 2324 [Note] 'CHANGE MASTER TO FOR CHANNEL 'group_replication_recovery' executed'. Previous state master_host=
'db7-fw-us-east.sa.fwmrm.net', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='db7-fw-us
-east.sa.fwmrm.net', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''.
2023-09-11T07:55:36.064683Z 2324 [Note] Plugin group_replication reported: 'Establishing connection to a group replication recovery donor
 be6c6809-e886-11ec-a496-9cdc71bc2950 at db7-fw-us-east.sa.fwmrm.net port: 3306.'
2023-09-11T07:55:36.064938Z 2532 [Warning] Storing MySQL user name or password information in the master info repository is not secure an
d is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Synt
ax' in the MySQL Manual for more information.
2023-09-11T07:55:36.070016Z 2533 [Note] Slave SQL thread for channel 'group_replication_recovery' initialized, starting replication in lo
g 'FIRST' at position 0, relay log './db8-fw-us-east-relay-bin-group_replication_recovery.000001' position: 4
2023-09-11T07:55:36.073637Z 2532 [Note] Slave I/O thread for channel 'group_replication_recovery': connected to master 'mysql_innodb_clus
ter_10131711@db7-fw-us-east.sa.fwmrm.net:3306',replication started in log 'FIRST' at position 4
2023-09-11T07:55:36.083785Z 2534 [ERROR] Slave SQL for channel 'group_replication_recovery': Worker 1 failed executing transaction '82e06
38a-e968-11ec-9a76-9cdc71bc2950:774245300' at master log mysql-bin.004136, end_log_pos 535344; Could not execute Write_rows event on tabl
e stickyads.campaigns; Duplicate entry '2761231785' for key 'PRIMARY', Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event's
 master log FIRST, end_log_pos 535344, Error_code: 1062
2023-09-11T07:55:36.083950Z 2324 [Note] Plugin group_replication reported: 'Terminating existing group replication donor connection and p
urging the corresponding logs.'
2023-09-11T07:55:36.084017Z 2533 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread
 with "SLAVE START". We stopped at log 'mysql-bin.004136' position 534736.
2023-09-11T07:55:36.084703Z 2532 [Note] Slave I/O thread exiting for channel 'group_replication_recovery', read up to log 'mysql-bin.0041
36', position 543692
2023-09-11T07:55:36.099091Z 2324 [Note] Plugin group_replication reported: 'Retrying group recovery connection with another donor. Attemp
t 10/10'
2023-09-11T07:56:36.110989Z 2324 [Note] 'CHANGE MASTER TO FOR CHANNEL 'group_replication_recovery' executed'. Previous state master_host=
'db7-fw-us-east.sa.fwmrm.net', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='db7-fw-us
-east.sa.fwmrm.net', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''.
2023-09-11T07:56:36.119570Z 2324 [Note] Plugin group_replication reported: 'Establishing connection to a group replication recovery donor
 be6c6809-e886-11ec-a496-9cdc71bc2950 at db7-fw-us-east.sa.fwmrm.net port: 3306.'
2023-09-11T07:56:36.119902Z 2554 [Warning] Storing MySQL user name or password information in the master info repository is not secure an
d is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Synt
ax' in the MySQL Manual for more information.
2023-09-11T07:56:36.123985Z 2555 [Note] Slave SQL thread for channel 'group_replication_recovery' initialized, starting replication in lo
g 'FIRST' at position 0, relay log './db8-fw-us-east-relay-bin-group_replication_recovery.000001' position: 4
2023-09-11T07:56:36.132438Z 2554 [Note] Slave I/O thread for channel 'group_replication_recovery': connected to master 'mysql_innodb_clus
ter_10131711@db7-fw-us-east.sa.fwmrm.net:3306',replication started in log 'FIRST' at position 4
2023-09-11T07:56:36.144028Z 2556 [ERROR] Slave SQL for channel 'group_replication_recovery': Worker 1 failed executing transaction '82e06
38a-e968-11ec-9a76-9cdc71bc2950:774245300' at master log mysql-bin.004136, end_log_pos 535344; Could not execute Write_rows event on tabl
e stickyads.campaigns; Duplicate entry '2761231785' for key 'PRIMARY', Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event's
 master log FIRST, end_log_pos 535344, Error_code: 1062
2023-09-11T07:56:36.144217Z 2324 [Note] Plugin group_replication reported: 'Terminating existing group replication donor connection and p
urging the corresponding logs.'
2023-09-11T07:56:36.144296Z 2555 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread
 with "SLAVE START". We stopped at log 'mysql-bin.004136' position 534736.
2023-09-11T07:56:36.145010Z 2554 [Note] Slave I/O thread exiting for channel 'group_replication_recovery', read up to log 'mysql-bin.0041
36', position 550365
2023-09-11T07:56:36.157667Z 2324 [ERROR] Plugin group_replication reported: 'Maximum number of retries when trying to connect to a donor
reached. Aborting group replication recovery.'
2023-09-11T07:56:36.157705Z 2324 [Note] Plugin group_replication reported: 'Terminating existing group replication donor connection and p
urging the corresponding logs.'
2023-09-11T07:56:36.157720Z 2324 [ERROR] Plugin group_replication reported: 'Fatal error during the Recovery process of Group Replication
. The server will leave the group.'
2023-09-11T07:56:36.157751Z 2324 [Note] Plugin group_replication reported: 'Going to wait for view modification'
2023-09-11T07:56:39.450430Z 0 [Note] Plugin group_replication reported: 'Group membership changed: This member has left the group.'
2023-09-11T10:41:53.891428Z 5401 [Note] Plugin group_replication reported: 'Plugin 'group_replication' is stopping.'
2023-09-11T10:41:53.891495Z 5401 [Note] Plugin group_replication reported: 'Requesting to leave the group despite of not being a member'
2023-09-11T10:41:53.892830Z 2316 [Note] Error reading relay log event for channel 'group_replication_applier': slave SQL thread was kille
d
2023-09-11T10:41:53.893147Z 2316 [Note] Slave SQL thread for channel 'group_replication_applier' exiting, replication stopped in log 'FIR
ST' at position 1250
2023-09-11T10:41:53.895713Z 2313 [Note] Plugin group_replication reported: 'The group replication applier thread was killed'
2023-09-11T10:41:53.901336Z 5401 [Note] Plugin group_replication reported: 'Plugin 'group_replication' has been stopped.'
2023-09-11T10:42:46.517381Z 5401 [Note] Plugin group_replication reported: 'Group communication SSL configuration: group_replication_ssl_
mode: "REQUIRED"; server_key_file: "server-key.pem"; server_cert_file: "server-cert.pem"; client_key_file: "server-key.pem"; client_cert_
file: "server-cert.pem"; ca_file: "ca.pem"; ca_path: ""; cipher: ""; tls_version: "TLSv1,TLSv1.1,TLSv1.2"; crl_file: ""; crl_path: ""'
2023-09-11T10:42:46.517558Z 5401 [Note] Plugin group_replication reported: '[GCS] Added automatically IP ranges 10.13.17.11/17,10.254.244
.71/20,127.0.0.1/8 to the whitelist'
2023-09-11T10:42:46.517746Z 5401 [Note] Plugin group_replication reported: '[GCS] Translated 'db8-fw-us-east.sa.fwmrm.net' to 10.13.17.11
'
2023-09-11T10:42:46.517908Z 5401 [Warning] Plugin group_replication reported: '[GCS] Automatically adding IPv4 localhost address to the w
hitelist. It is mandatory that it is added.'
2023-09-11T10:42:46.519922Z 5401 [Note] Plugin group_replication reported: 'Initialized group communication with configuration: group_rep
lication_group_name: "82e0638a-e968-11ec-9a76-9cdc71bc2950"; group_replication_local_address: "db8-fw-us-east.sa.fwmrm.net:33061"; group_
replication_group_seeds: "db7-fw-us-east.sa.fwmrm.net:33061,db9-fw-us-east.sa.fwmrm.net:33061"; group_replication_bootstrap_group: false;
 group_replication_poll_spin_loops: 0; group_replication_compression_threshold: 1000000; group_replication_ip_whitelist: "AUTOMATIC"'
2023-09-11T10:42:46.519994Z 5401 [Note] Plugin group_replication reported: '[GCS] Configured number of attempts to join: 0'
2023-09-11T10:42:46.520006Z 5401 [Note] Plugin group_replication reported: '[GCS] Configured time between attempts to join: 5 seconds'
2023-09-11T10:42:46.520037Z 5401 [Note] Plugin group_replication reported: 'Member configuration: member_id: 10131711; member_uuid: "c07c
e69f-e886-11ec-8aef-08f1ea7dba36"; single-primary mode: "true"; group_replication_auto_increment_increment: 7; '
2023-09-11T10:42:46.520557Z 5421 [Note] 'CHANGE MASTER TO FOR CHANNEL 'group_replication_applier' executed'. Previous state master_host='
<NULL>', master_port= 0, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='<NULL>', master_port= 0, master_lo
g_file='', master_log_pos= 4, master_bind=''.
2023-09-11T10:42:46.531192Z 5401 [Note] Plugin group_replication reported: 'Group Replication applier module successfully initialized!'
2023-09-11T10:42:46.531215Z 5424 [Note] Slave SQL thread for channel 'group_replication_applier' initialized, starting replication in log
 'FIRST' at position 0, relay log './db8-fw-us-east-relay-bin-group_replication_applier.002360' position: 4
2023-09-11T10:42:46.531486Z 0 [Note] Plugin group_replication reported: 'XCom protocol version: 3'
2023-09-11T10:42:46.531540Z 0 [Note] Plugin group_replication reported: 'XCom initialized and ready to accept incoming connections on por
t 33061'
2023-09-11T10:42:51.136417Z 5401 [Note] Plugin group_replication reported: 'This server is working as secondary member with primary membe
r address db7-fw-us-east.sa.fwmrm.net:3306.'
2023-09-11T10:42:51.136493Z 0 [ERROR] Plugin group_replication reported: 'Group contains 2 members which is greater than auto_increment_i
ncrement value of 1. This can lead to an higher rate of transactional aborts.'
2023-09-11T10:42:51.136778Z 5441 [Note] Plugin group_replication reported: 'Establishing group recovery connection with a possible donor.
 Attempt 1/10'
2023-09-11T10:42:51.136822Z 0 [Note] Plugin group_replication reported: 'Group membership changed to db7-fw-us-east.sa.fwmrm.net:3306, db
8-fw-us-east.sa.fwmrm.net:3306 on view 16944183276594499:6.'
2023-09-11T10:42:51.158350Z 5441 [Note] 'CHANGE MASTER TO FOR CHANNEL 'group_replication_recovery' executed'. Previous state master_host=
'db7-fw-us-east.sa.fwmrm.net', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='db7-fw-us
-east.sa.fwmrm.net', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''.
2023-09-11T10:42:51.180466Z 5441 [Note] Plugin group_replication reported: 'Establishing connection to a group replication recovery donor
 be6c6809-e886-11ec-a496-9cdc71bc2950 at db7-fw-us-east.sa.fwmrm.net port: 3306.'
2023-09-11T10:42:51.180788Z 5443 [Warning] Storing MySQL user name or password information in the master info repository is not secure an
d is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Synt
ax' in the MySQL Manual for more information.
2023-09-11T10:42:51.185473Z 5444 [Note] Slave SQL thread for channel 'group_replication_recovery' initialized, starting replication in lo
g 'FIRST' at position 0, relay log './db8-fw-us-east-relay-bin-group_replication_recovery.000001' position: 4
2023-09-11T10:42:51.193508Z 5443 [Note] Slave I/O thread for channel 'group_replication_recovery': connected to master 'mysql_innodb_clus
ter_10131711@db7-fw-us-east.sa.fwmrm.net:3306',replication started in log 'FIRST' at position 4
2023-09-11T10:45:04.362866Z 5441 [Note] Plugin group_replication reported: 'Terminating existing group replication donor connection and p
urging the corresponding logs.'
2023-09-11T10:45:04.363221Z 5444 [Note] Slave SQL thread for channel 'group_replication_recovery' exiting, replication stopped in log 'my
sql-bin.004137' at position 115388942
2023-09-11T10:45:04.363476Z 5443 [Note] Slave I/O thread killed while reading event for channel 'group_replication_recovery'
2023-09-11T10:45:04.363508Z 5443 [Note] Slave I/O thread exiting for channel 'group_replication_recovery', read up to log 'mysql-bin.0041
37', position 124819572
2023-09-11T10:45:04.424616Z 5441 [Note] 'CHANGE MASTER TO FOR CHANNEL 'group_replication_recovery' executed'. Previous state master_host=
'db7-fw-us-east.sa.fwmrm.net', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='<NULL>',
master_port= 0, master_log_file='', master_log_pos= 4, master_bind=''.
2023-09-11T10:45:06.042212Z 0 [Note] Plugin group_replication reported: 'This server was declared online within the replication group'
2023-09-11T10:47:00.006230Z 0 [Note] Plugin group_replication reported: 'Members joined the group: db9-fw-us-east.sa.fwmrm.net:3306'
2023-09-11T10:47:00.006415Z 0 [Note] Plugin group_replication reported: 'Group membership changed to db7-fw-us-east.sa.fwmrm.net:3306, db
8-fw-us-east.sa.fwmrm.net:3306, db9-fw-us-east.sa.fwmrm.net:3306 on view 16944183276594499:7.'
2023-09-11T10:47:00.043294Z 5922 [Note] Start binlog_dump to master_thread_id(5922) slave_server(10131712), pos(, 4)
2023-09-11T10:49:07.067178Z 0 [Note] Plugin group_replication reported: 'The member with address db9-fw-us-east.sa.fwmrm.net:3306 was dec
lared online within the replication group'