2023-09-11T06:11:04.294931Z 12543392 [Note] Got timeout reading communication packets
2023-09-11T06:11:04.296755Z 12543400 [Note] Got an error reading communication packets
2023-09-11T07:29:32.156345Z 0 [Warning] Plugin group_replication reported: 'Member with address db7-fw-us-east.sa.fwmrm.net:3306 has beco
me unreachable.'
2023-09-11T07:29:33.156251Z 0 [Warning] Plugin group_replication reported: 'Member with address db7-fw-us-east.sa.fwmrm.net:3306 is reach
able again.'
2023-09-11T07:29:57.330305Z 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:29:57.350861Z 0 [Note] Plugin group_replication reported: 'Going to wait for view modification'
2023-09-11T07:29:57.350941Z 0 [ERROR] Plugin group_replication reported: 'Message received while the plugin is not ready, message discard
ed'
2023-09-11T07:29:57.350970Z 0 [ERROR] Plugin group_replication reported: 'Message received while the plugin is not ready, message discard
ed'
2023-09-11T07:29:57.350993Z 0 [ERROR] Plugin group_replication reported: 'Message received while the plugin is not ready, message discard
ed'
2023-09-11T07:29:57.351064Z 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:29:57.351098Z 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:29:57.351156Z 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:00.244089Z 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.135848Z 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.152998Z 0 [Note] Plugin group_replication reported: 'Members joined the group: db7-fw-us-east.sa.fwmrm.net:3306'
2023-09-11T07:41:09.153144Z 0 [Warning] Plugin group_replication reported: 'Unable to set any member as primary. No suitable candidate.'
2023-09-11T07:41:09.153242Z 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:35.212253Z 0 [Note] Giving 8 client threads a chance to die gracefully
2023-09-11T07:42:35.212399Z 0 [Note] Shutting down slave threads
2023-09-11T07:42:37.214091Z 0 [Note] Forcefully disconnecting 7 remaining clients
2023-09-11T07:42:37.214157Z 0 [Note] Plugin group_replication reported: 'Plugin 'group_replication' is stopping.'
2023-09-11T07:42:37.214198Z 0 [Note] Plugin group_replication reported: 'Going to wait for view modification'
2023-09-11T07:42:42.857255Z 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:42.857321Z 0 [ERROR] Plugin group_replication reported: 'Can't establish a internal server connection to execute plugin
operations'
2023-09-11T07:42:42.857334Z 0 [Warning] Plugin group_replication reported: 'Unable to open session to (re)set read only mode. Skipping.'
2023-09-11T07:42:42.857350Z 0 [Note] Plugin group_replication reported: 'Group membership changed: This member has left the group.'
2023-09-11T07:42:47.861205Z 11592426 [Note] Error reading relay log event for channel 'group_replication_applier': slave SQL thread was k
illed
2023-09-11T07:42:47.861373Z 11592426 [Note] Slave SQL thread for channel 'group_replication_applier' exiting, replication stopped in log
'FIRST' at position 1250
2023-09-11T07:42:47.862365Z 11592423 [Note] Plugin group_replication reported: 'The group replication applier thread was killed'
2023-09-11T07:42:53.374031Z 0 [Note] Plugin group_replication reported: 'Plugin 'group_replication' has been stopped.'
2023-09-11T07:42:53.374069Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2023-09-11T07:42:53.379022Z 0 [Note] Binlog end
2023-09-11T07:42:57.753151Z 0 [Note] Shutting down plugin 'group_replication'
2023-09-11T07:42:57.753230Z 0 [Note] Plugin group_replication reported: 'All Group Replication server observers have been successfully un
registered'
2023-09-11T07:42:57.753252Z 0 [Note] Shutting down plugin 'auth_socket'
2023-09-11T07:42:57.753409Z 0 [Note] Shutting down plugin 'ngram'
2023-09-11T07:42:57.753420Z 0 [Note] Shutting down plugin 'partition'
2023-09-11T07:42:57.753428Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2023-09-11T07:42:57.753439Z 0 [Note] Shutting down plugin 'ARCHIVE'
2023-09-11T07:42:57.753448Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2023-09-11T07:42:57.753675Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2023-09-11T07:42:57.753688Z 0 [Note] Shutting down plugin 'MyISAM'
2023-09-11T07:42:57.753725Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2023-09-11T07:42:57.753728Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2023-09-11T07:42:57.753730Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2023-09-11T07:42:57.753732Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2023-09-11T07:42:57.753735Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2023-09-11T07:42:57.753737Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2023-09-11T07:42:57.753739Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2023-09-11T07:42:57.753742Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2023-09-11T07:42:57.753744Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2023-09-11T07:42:57.753747Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2023-09-11T07:42:57.753749Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2023-09-11T07:42:57.753751Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2023-09-11T07:42:57.753753Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2023-09-11T07:42:57.753755Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2023-09-11T07:42:57.753757Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2023-09-11T07:42:57.753760Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2023-09-11T07:42:57.753762Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2023-09-11T07:42:57.753765Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2023-09-11T07:42:57.753767Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2023-09-11T07:42:57.753769Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2023-09-11T07:42:57.753771Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2023-09-11T07:42:57.753773Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2023-09-11T07:42:57.753776Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2023-09-11T07:42:57.753778Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2023-09-11T07:42:57.753780Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2023-09-11T07:42:57.753783Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2023-09-11T07:42:57.753793Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2023-09-11T07:42:57.753795Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2023-09-11T07:42:57.753797Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2023-09-11T07:42:57.753798Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2023-09-11T07:42:57.753800Z 0 [Note] Shutting down plugin 'InnoDB'
2023-09-11T07:42:57.755094Z 0 [Note] InnoDB: FTS optimize thread exiting.
2023-09-11T07:42:57.755244Z 0 [Note] InnoDB: Starting shutdown...
2023-09-11T07:44:01.588938Z 0 [Note] InnoDB: Shutdown completed; log sequence number 3533811185230
2023-09-11T07:44:01.589253Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2023-09-11T07:44:01.589267Z 0 [Note] Shutting down plugin 'MEMORY'
2023-09-11T07:44:01.589272Z 0 [Note] Shutting down plugin 'CSV'
2023-09-11T07:44:01.589278Z 0 [Note] Shutting down plugin 'sha256_password'
2023-09-11T07:44:01.589281Z 0 [Note] Shutting down plugin 'mysql_native_password'
2023-09-11T07:44:01.590411Z 0 [Note] Shutting down plugin 'binlog'
2023-09-11T07:44:01.591981Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2023-09-11T07:45:00.568154Z 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:45:00.568232Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2023-09-11T07:45:00.569688Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.36-log) starting as process 1454124 ...
2023-09-11T07:45:00.585895Z 0 [Note] InnoDB: PUNCH HOLE support available
2023-09-11T07:45:00.585920Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2023-09-11T07:45:00.585924Z 0 [Note] InnoDB: Uses event mutexes
2023-09-11T07:45:00.585926Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2023-09-11T07:45:00.585929Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2023-09-11T07:45:00.585932Z 0 [Note] InnoDB: Using Linux native AIO
2023-09-11T07:45:00.586578Z 0 [Note] InnoDB: Number of pools: 1
2023-09-11T07:45:00.586660Z 0 [Note] InnoDB: Using CPU crc32 instructions
2023-09-11T07:45:00.590287Z 0 [Note] InnoDB: Initializing buffer pool, total size = 200G, instances = 16, chunk size = 128M
2023-09-11T07:45:08.638564Z 0 [Note] InnoDB: Completed initialization of buffer pool
2023-09-11T07:45:09.737166Z 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:45:09.744540Z 0 [Note] InnoDB: Opened 3 undo tablespaces
2023-09-11T07:45:09.744557Z 0 [Note] InnoDB: 3 undo tablespaces made active
2023-09-11T07:45:09.744709Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2023-09-11T07:45:12.284821Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-09-11T07:45:12.284933Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-09-11T07:45:12.374619Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2023-09-11T07:45:12.379401Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2023-09-11T07:45:12.379431Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2023-09-11T07:45:12.380466Z 0 [Note] InnoDB: Waiting for purge to start
2023-09-11T07:45:12.431003Z 0 [Note] InnoDB: 5.7.36 started; log sequence number 3533811185230
2023-09-11T07:45:12.432448Z 0 [Note] Plugin 'FEDERATED' is disabled.
2023-09-11T07:45:12.582773Z 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:45:12.582793Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2023-09-11T07:45:12.582800Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
2023-09-11T07:45:12.582802Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
2023-09-11T07:45:12.584214Z 0 [Warning] CA certificate ca.pem is self signed.
2023-09-11T07:45:12.584254Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2023-09-11T07:45:12.584584Z 0 [Note] Server hostname (bind-address): '10.13.17.12'; port: 3306
2023-09-11T07:45:12.584594Z 0 [Note]   - '10.13.17.12' resolves to '10.13.17.12';
2023-09-11T07:45:12.584654Z 0 [Note] Server socket created on IP: '10.13.17.12'.
2023-09-11T07:45:12.588751Z 0 [Warning] 'user' entry 'root@ns231760.ovh.net' ignored in --skip-name-resolve mode.
2023-09-11T07:45:12.644486Z 0 [Note] Event Scheduler: Loaded 0 events
2023-09-11T07:45:12.644738Z 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:45:12.645242Z 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:45:12.646104Z 2 [Note] Plugin group_replication reported: '[GCS] Added automatically IP ranges 10.13.17.12/17,127.0.0.1/8 t
o the whitelist'
2023-09-11T07:45:12.646391Z 2 [Note] Plugin group_replication reported: '[GCS] Translated 'db9-fw-us-east.sa.fwmrm.net' to 10.13.17.12'
2023-09-11T07:45:12.646567Z 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:45:12.648686Z 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: "db9-fw-us-east.sa.fwmrm.net:33061"; group_rep
lication_group_seeds: "db7-fw-us-east.sa.fwmrm.net:33061,db8-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:45:12.648762Z 2 [Note] Plugin group_replication reported: '[GCS] Configured number of attempts to join: 0'
2023-09-11T07:45:12.648777Z 2 [Note] Plugin group_replication reported: '[GCS] Configured time between attempts to join: 5 seconds'
2023-09-11T07:45:12.648805Z 2 [Note] Plugin group_replication reported: 'Member configuration: member_id: 10131712; member_uuid: "c1e402c
c-e886-11ec-8568-c6f2f45ba149"; single-primary mode: "true"; group_replication_auto_increment_increment: 7; '
2023-09-11T07:45:12.649285Z 3 [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:45:12.660859Z 6 [Note] Slave SQL thread for channel 'group_replication_applier' initialized, starting replication in log 'F
IRST' at position 0, relay log './db9-fw-us-east-relay-bin-group_replication_applier.003963' position: 4
2023-09-11T07:45:12.660913Z 2 [Note] Plugin group_replication reported: 'Group Replication applier module successfully initialized!'
2023-09-11T07:45:12.680446Z 0 [Note] Plugin group_replication reported: 'XCom protocol version: 3'
2023-09-11T07:45:12.680464Z 0 [Note] Plugin group_replication reported: 'XCom initialized and ready to accept incoming connections on por
t 33061'
2023-09-11T07:45:12.748444Z 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:45:12.748673Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to db8-fw-us-east.sa.fwmrm.
net:33061 on local port: 33061.'
2023-09-11T07:45:12.748951Z 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:45:12.749192Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to db8-fw-us-east.sa.fwmrm.
net:33061 on local port: 33061.'
2023-09-11T07:45:12.749411Z 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:45:12.749590Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to db8-fw-us-east.sa.fwmrm.
net:33061 on local port: 33061.'
2023-09-11T07:45:12.749811Z 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:45:12.750031Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to db8-fw-us-east.sa.fwmrm.
net:33061 on local port: 33061.'
2023-09-11T07:45:12.750247Z 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:45:12.750399Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to db8-fw-us-east.sa.fwmrm.
net:33061 on local port: 33061.'
2023-09-11T07:45:12.750623Z 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:45:12.750844Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to db8-fw-us-east.sa.fwmrm.
net:33061 on local port: 33061.'
2023-09-11T07:45:12.751002Z 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:45:12.751227Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to db8-fw-us-east.sa.fwmrm.
net:33061 on local port: 33061.'
2023-09-11T07:45:12.751451Z 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:45:12.751630Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to db8-fw-us-east.sa.fwmrm.
net:33061 on local port: 33061.'
2023-09-11T07:45:12.751842Z 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:45:12.752073Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to db8-fw-us-east.sa.fwmrm.
net:33061 on local port: 33061.'
2023-09-11T07:45:12.752289Z 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:45:12.752450Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to db8-fw-us-east.sa.fwmrm.
net:33061 on local port: 33061.'
2023-09-11T07:45:12.752467Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error connecting to all peers. Member join failed. Local
port: 33061'
2023-09-11T07:45:12.752633Z 0 [Warning] Plugin group_replication reported: 'read failed'
2023-09-11T07:45:12.759556Z 0 [ERROR] Plugin group_replication reported: '[GCS] The member was unable to join the group. Local port: 3306
1'
2023-09-11T07:46:12.661062Z 2 [ERROR] Plugin group_replication reported: 'Timeout on wait for view after joining group'
2023-09-11T07:46:12.661123Z 2 [Note] Plugin group_replication reported: 'Requesting to leave the group despite of not being a member'
2023-09-11T07:46:12.661152Z 2 [ERROR] Plugin group_replication reported: '[GCS] The member is leaving a group without being on one.'
2023-09-11T07:46:12.661667Z 6 [Note] Error reading relay log event for channel 'group_replication_applier': slave SQL thread was killed
2023-09-11T07:46:12.661843Z 6 [Note] Slave SQL thread for channel 'group_replication_applier' exiting, replication stopped in log 'FIRST'
 at position 1250
2023-09-11T07:46:12.662588Z 3 [Note] Plugin group_replication reported: 'The group replication applier thread was killed'
2023-09-11T07:47:36.956842Z 143 [Note] Plugin group_replication reported: 'Group communication SSL configuration: group_replication_ssl_m
ode: "REQUIRED"; server_key_file: "server-key.pem"; server_cert_file: "server-cert.pem"; client_key_file: "server-key.pem"; client_cert_f
ile: "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:36.957024Z 143 [Note] Plugin group_replication reported: '[GCS] Added automatically IP ranges 10.13.17.12/17,127.0.0.1/8
 to the whitelist'
2023-09-11T07:47:36.957209Z 143 [Note] Plugin group_replication reported: '[GCS] Translated 'db9-fw-us-east.sa.fwmrm.net' to 10.13.17.12'
2023-09-11T07:47:36.957364Z 143 [Warning] Plugin group_replication reported: '[GCS] Automatically adding IPv4 localhost address to the wh
itelist. It is mandatory that it is added.'
2023-09-11T07:47:36.959318Z 143 [Note] Plugin group_replication reported: 'Initialized group communication with configuration: group_repl
ication_group_name: "82e0638a-e968-11ec-9a76-9cdc71bc2950"; group_replication_local_address: "db9-fw-us-east.sa.fwmrm.net:33061"; group_r
eplication_group_seeds: "db7-fw-us-east.sa.fwmrm.net:33061,db8-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:36.959394Z 143 [Note] Plugin group_replication reported: '[GCS] Configured number of attempts to join: 0'
2023-09-11T07:47:36.959411Z 143 [Note] Plugin group_replication reported: '[GCS] Configured time between attempts to join: 5 seconds'
2023-09-11T07:47:36.959444Z 143 [Note] Plugin group_replication reported: 'Member configuration: member_id: 10131712; member_uuid: "c1e40
2cc-e886-11ec-8568-c6f2f45ba149"; single-primary mode: "true"; group_replication_auto_increment_increment: 7; '
2023-09-11T07:47:36.959999Z 469 [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_log
_file='', master_log_pos= 4, master_bind=''.
2023-09-11T07:47:36.970264Z 472 [Note] Slave SQL thread for channel 'group_replication_applier' initialized, starting replication in log
'FIRST' at position 0, relay log './db9-fw-us-east-relay-bin-group_replication_applier.003963' position: 4
2023-09-11T07:47:36.970343Z 143 [Note] Plugin group_replication reported: 'Group Replication applier module successfully initialized!'
2023-09-11T07:47:36.970636Z 0 [Note] Plugin group_replication reported: 'XCom protocol version: 3'
2023-09-11T07:47:36.970676Z 0 [Note] Plugin group_replication reported: 'XCom initialized and ready to accept incoming connections on por
t 33061'
2023-09-11T07:47:39.037313Z 143 [Note] Plugin group_replication reported: 'This server is working as secondary member with primary member
 address db7-fw-us-east.sa.fwmrm.net:3306.'
2023-09-11T07:47:39.037448Z 0 [ERROR] Plugin group_replication reported: 'Group contains 3 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:39.037687Z 479 [Note] Plugin group_replication reported: 'Establishing group recovery connection with a possible donor.
Attempt 1/10'
2023-09-11T07:47:39.037753Z 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:47:39.048152Z 479 [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', mast
er_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''.
2023-09-11T07:47:39.055913Z 479 [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:39.056208Z 481 [Warning] Storing MySQL user name or password information in the master info repository is not secure and
 is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Synta
x' in the MySQL Manual for more information.
2023-09-11T07:47:39.060764Z 482 [Note] Slave SQL thread for channel 'group_replication_recovery' initialized, starting replication in log
 'FIRST' at position 0, relay log './db9-fw-us-east-relay-bin-group_replication_recovery.000001' position: 4
2023-09-11T07:47:39.067077Z 481 [Note] Slave I/O thread for channel 'group_replication_recovery': connected to master 'mysql_innodb_clust
er_10131712@db7-fw-us-east.sa.fwmrm.net:3306',replication started in log 'FIRST' at position 4
2023-09-11T07:47:39.654370Z 484 [ERROR] Slave SQL for channel 'group_replication_recovery': Worker 2 failed executing transaction '82e063
8a-e968-11ec-9a76-9cdc71bc2950:774245300' at master log mysql-bin.004136, end_log_pos 535344; Could not execute Write_rows event on table
 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:39.654544Z 479 [Note] Plugin group_replication reported: 'Terminating existing group replication donor connection and pu
rging the corresponding logs.'
2023-09-11T07:47:39.655212Z 482 [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:39.655496Z 481 [Note] Slave I/O thread killed while reading event for channel 'group_replication_recovery'
2023-09-11T07:47:39.655514Z 481 [Note] Slave I/O thread exiting for channel 'group_replication_recovery', read up to log 'mysql-bin.00413
6', position 25787025
2023-09-11T07:47:39.658556Z 479 [Note] Plugin group_replication reported: 'Retrying group recovery connection with another donor. Attempt
 2/10'
2023-09-11T07:48:39.676117Z 479 [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:39.683594Z 479 [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:39.683880Z 509 [Warning] Storing MySQL user name or password information in the master info repository is not secure and
 is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Synta
x' in the MySQL Manual for more information.
2023-09-11T07:48:39.690107Z 510 [Note] Slave SQL thread for channel 'group_replication_recovery' initialized, starting replication in log
 'FIRST' at position 0, relay log './db9-fw-us-east-relay-bin-group_replication_recovery.000001' position: 4
2023-09-11T07:48:39.696950Z 509 [Note] Slave I/O thread for channel 'group_replication_recovery': connected to master 'mysql_innodb_clust
er_10131712@db7-fw-us-east.sa.fwmrm.net:3306',replication started in log 'FIRST' at position 4
2023-09-11T07:48:39.707898Z 511 [ERROR] Slave SQL for channel 'group_replication_recovery': Worker 1 failed executing transaction '82e063
8a-e968-11ec-9a76-9cdc71bc2950:774245300' at master log mysql-bin.004136, end_log_pos 535344; Could not execute Write_rows event on table
 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:39.708003Z 479 [Note] Plugin group_replication reported: 'Terminating existing group replication donor connection and pu
rging the corresponding logs.'
2023-09-11T07:48:39.708159Z 510 [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:39.708747Z 509 [Note] Slave I/O thread exiting for channel 'group_replication_recovery', read up to log 'mysql-bin.00413
6', position 548646
2023-09-11T07:48:39.719388Z 479 [Note] Plugin group_replication reported: 'Retrying group recovery connection with another donor. Attempt
 3/10'
2023-09-11T07:49:39.730006Z 479 [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:39.737086Z 479 [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:39.737451Z 530 [Warning] Storing MySQL user name or password information in the master info repository is not secure and
 is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Synta
x' in the MySQL Manual for more information.
2023-09-11T07:49:39.741578Z 531 [Note] Slave SQL thread for channel 'group_replication_recovery' initialized, starting replication in log
 'FIRST' at position 0, relay log './db9-fw-us-east-relay-bin-group_replication_recovery.000001' position: 4
2023-09-11T07:49:39.751166Z 530 [Note] Slave I/O thread for channel 'group_replication_recovery': connected to master 'mysql_innodb_clust
er_10131712@db7-fw-us-east.sa.fwmrm.net:3306',replication started in log 'FIRST' at position 4
2023-09-11T07:49:39.761909Z 532 [ERROR] Slave SQL for channel 'group_replication_recovery': Worker 1 failed executing transaction '82e063
8a-e968-11ec-9a76-9cdc71bc2950:774245300' at master log mysql-bin.004136, end_log_pos 535344; Could not execute Write_rows event on table
 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:39.761991Z 531 [Warning] Slave SQL for channel 'group_replication_recovery': ... The slave coordinator and worker thread
s are stopped, possibly leaving data in inconsistent state. A restart should restore consistency automatically, although using non-transa
ctional storage for data or info tables or DDL queries could lead to problems. In such cases you have to examine your data (see documenta
tion for details). Error_code: 1756
2023-09-11T07:49:39.762079Z 479 [Note] Plugin group_replication reported: 'Terminating existing group replication donor connection and pu
rging the corresponding logs.'
2023-09-11T07:49:39.762192Z 531 [Note] Slave SQL thread for channel 'group_replication_recovery' exiting, replication stopped in log 'mys
ql-bin.004136' at position 534736
2023-09-11T07:49:39.762663Z 530 [Note] Slave I/O thread exiting for channel 'group_replication_recovery', read up to log 'mysql-bin.00413
6', position 545805
2023-09-11T07:49:39.776342Z 479 [Note] Plugin group_replication reported: 'Retrying group recovery connection with another donor. Attempt
 4/10'
2023-09-11T07:50:39.789896Z 479 [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:39.798101Z 479 [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:39.798404Z 559 [Warning] Storing MySQL user name or password information in the master info repository is not secure and
 is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Synta
x' in the MySQL Manual for more information.
2023-09-11T07:50:39.802495Z 560 [Note] Slave SQL thread for channel 'group_replication_recovery' initialized, starting replication in log
 'FIRST' at position 0, relay log './db9-fw-us-east-relay-bin-group_replication_recovery.000001' position: 4
2023-09-11T07:50:39.805079Z 559 [Note] Slave I/O thread for channel 'group_replication_recovery': connected to master 'mysql_innodb_clust
er_10131712@db7-fw-us-east.sa.fwmrm.net:3306',replication started in log 'FIRST' at position 4
2023-09-11T07:50:39.814633Z 561 [ERROR] Slave SQL for channel 'group_replication_recovery': Worker 1 failed executing transaction '82e063
8a-e968-11ec-9a76-9cdc71bc2950:774245300' at master log mysql-bin.004136, end_log_pos 535344; Could not execute Write_rows event on table
 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:39.814727Z 479 [Note] Plugin group_replication reported: 'Terminating existing group replication donor connection and pu
rging the corresponding logs.'
2023-09-11T07:50:39.814861Z 560 [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:39.815110Z 559 [Note] Slave I/O thread exiting for channel 'group_replication_recovery', read up to log 'mysql-bin.00413
6', position 547472
2023-09-11T07:50:39.827690Z 479 [Note] Plugin group_replication reported: 'Retrying group recovery connection with another donor. Attempt
 5/10'
2023-09-11T07:51:39.839700Z 479 [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:39.847408Z 479 [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:39.847666Z 582 [Warning] Storing MySQL user name or password information in the master info repository is not secure and
 is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Synta
x' in the MySQL Manual for more information.
2023-09-11T07:51:39.853230Z 583 [Note] Slave SQL thread for channel 'group_replication_recovery' initialized, starting replication in log
 'FIRST' at position 0, relay log './db9-fw-us-east-relay-bin-group_replication_recovery.000001' position: 4
2023-09-11T07:51:39.860092Z 582 [Note] Slave I/O thread for channel 'group_replication_recovery': connected to master 'mysql_innodb_clust
er_10131712@db7-fw-us-east.sa.fwmrm.net:3306',replication started in log 'FIRST' at position 4
2023-09-11T07:51:39.872687Z 584 [ERROR] Slave SQL for channel 'group_replication_recovery': Worker 1 failed executing transaction '82e063
8a-e968-11ec-9a76-9cdc71bc2950:774245300' at master log mysql-bin.004136, end_log_pos 535344; Could not execute Write_rows event on table
 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:39.872772Z 479 [Note] Plugin group_replication reported: 'Terminating existing group replication donor connection and pu
rging the corresponding logs.'
2023-09-11T07:51:39.872920Z 583 [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:39.873625Z 582 [Note] Slave I/O thread exiting for channel 'group_replication_recovery', read up to log 'mysql-bin.00413
6', position 566854
2023-09-11T07:51:39.887810Z 479 [Note] Plugin group_replication reported: 'Retrying group recovery connection with another donor. Attempt
 6/10'
2023-09-11T07:52:39.901257Z 479 [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:39.909372Z 479 [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:39.909666Z 608 [Warning] Storing MySQL user name or password information in the master info repository is not secure and
 is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Synta
x' in the MySQL Manual for more information.
2023-09-11T07:52:39.914151Z 609 [Note] Slave SQL thread for channel 'group_replication_recovery' initialized, starting replication in log
 'FIRST' at position 0, relay log './db9-fw-us-east-relay-bin-group_replication_recovery.000001' position: 4
2023-09-11T07:52:39.922998Z 608 [Note] Slave I/O thread for channel 'group_replication_recovery': connected to master 'mysql_innodb_clust
er_10131712@db7-fw-us-east.sa.fwmrm.net:3306',replication started in log 'FIRST' at position 4
2023-09-11T07:52:39.933405Z 610 [ERROR] Slave SQL for channel 'group_replication_recovery': Worker 1 failed executing transaction '82e063
8a-e968-11ec-9a76-9cdc71bc2950:774245300' at master log mysql-bin.004136, end_log_pos 535344; Could not execute Write_rows event on table
 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:39.933451Z 609 [Warning] Slave SQL for channel 'group_replication_recovery': ... The slave coordinator and worker thread
s are stopped, possibly leaving data in inconsistent state. A restart should restore consistency automatically, although using non-transa
ctional storage for data or info tables or DDL queries could lead to problems. In such cases you have to examine your data (see documenta
tion for details). Error_code: 1756
2023-09-11T07:52:39.933502Z 479 [Note] Plugin group_replication reported: 'Terminating existing group replication donor connection and pu
rging the corresponding logs.'
2023-09-11T07:52:39.933634Z 609 [Note] Slave SQL thread for channel 'group_replication_recovery' exiting, replication stopped in log 'mys
ql-bin.004136' at position 534736
2023-09-11T07:52:39.934183Z 608 [Note] Slave I/O thread exiting for channel 'group_replication_recovery', read up to log 'mysql-bin.00413
6', position 551136
2023-09-11T07:52:39.946940Z 479 [Note] Plugin group_replication reported: 'Retrying group recovery connection with another donor. Attempt
 7/10'
2023-09-11T07:53:39.961933Z 479 [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:39.970401Z 479 [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:39.970705Z 633 [Warning] Storing MySQL user name or password information in the master info repository is not secure and
 is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Synta
x' in the MySQL Manual for more information.
2023-09-11T07:53:39.974375Z 634 [Note] Slave SQL thread for channel 'group_replication_recovery' initialized, starting replication in log
 'FIRST' at position 0, relay log './db9-fw-us-east-relay-bin-group_replication_recovery.000001' position: 4
2023-09-11T07:53:39.983829Z 633 [Note] Slave I/O thread for channel 'group_replication_recovery': connected to master 'mysql_innodb_clust
er_10131712@db7-fw-us-east.sa.fwmrm.net:3306',replication started in log 'FIRST' at position 4
2023-09-11T07:53:39.995775Z 635 [ERROR] Slave SQL for channel 'group_replication_recovery': Worker 1 failed executing transaction '82e063
8a-e968-11ec-9a76-9cdc71bc2950:774245300' at master log mysql-bin.004136, end_log_pos 535344; Could not execute Write_rows event on table
 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:39.995876Z 479 [Note] Plugin group_replication reported: 'Terminating existing group replication donor connection and pu
rging the corresponding logs.'
2023-09-11T07:53:39.996013Z 634 [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:39.996290Z 633 [Note] Slave I/O thread exiting for channel 'group_replication_recovery', read up to log 'mysql-bin.00413
6', position 549262
2023-09-11T07:53:40.011446Z 479 [Note] Plugin group_replication reported: 'Retrying group recovery connection with another donor. Attempt
 8/10'
2023-09-11T07:54:40.022927Z 479 [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:40.031951Z 479 [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:40.032328Z 655 [Warning] Storing MySQL user name or password information in the master info repository is not secure and
 is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Synta
x' in the MySQL Manual for more information.
2023-09-11T07:54:40.036305Z 656 [Note] Slave SQL thread for channel 'group_replication_recovery' initialized, starting replication in log
 'FIRST' at position 0, relay log './db9-fw-us-east-relay-bin-group_replication_recovery.000001' position: 4
2023-09-11T07:54:40.045608Z 655 [Note] Slave I/O thread for channel 'group_replication_recovery': connected to master 'mysql_innodb_clust
er_10131712@db7-fw-us-east.sa.fwmrm.net:3306',replication started in log 'FIRST' at position 4
2023-09-11T07:54:40.057395Z 657 [ERROR] Slave SQL for channel 'group_replication_recovery': Worker 1 failed executing transaction '82e063
8a-e968-11ec-9a76-9cdc71bc2950:774245300' at master log mysql-bin.004136, end_log_pos 535344; Could not execute Write_rows event on table
 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:40.057478Z 656 [Warning] Slave SQL for channel 'group_replication_recovery': ... The slave coordinator and worker thread
s are stopped, possibly leaving data in inconsistent state. A restart should restore consistency automatically, although using non-transa
ctional storage for data or info tables or DDL queries could lead to problems. In such cases you have to examine your data (see documenta
tion for details). Error_code: 1756
2023-09-11T07:54:40.057566Z 479 [Note] Plugin group_replication reported: 'Terminating existing group replication donor connection and pu
rging the corresponding logs.'
2023-09-11T07:54:40.057689Z 656 [Note] Slave SQL thread for channel 'group_replication_recovery' exiting, replication stopped in log 'mys
ql-bin.004136' at position 534736
2023-09-11T07:54:40.058290Z 655 [Note] Slave I/O thread exiting for channel 'group_replication_recovery', read up to log 'mysql-bin.00413
6', position 548352
2023-09-11T07:54:40.074292Z 479 [Note] Plugin group_replication reported: 'Retrying group recovery connection with another donor. Attempt
 9/10'
2023-09-11T07:55:40.085423Z 479 [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:40.094242Z 479 [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:40.094556Z 677 [Warning] Storing MySQL user name or password information in the master info repository is not secure and
 is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Synta
x' in the MySQL Manual for more information.
2023-09-11T07:55:40.098941Z 678 [Note] Slave SQL thread for channel 'group_replication_recovery' initialized, starting replication in log
 'FIRST' at position 0, relay log './db9-fw-us-east-relay-bin-group_replication_recovery.000001' position: 4
2023-09-11T07:55:40.106947Z 677 [Note] Slave I/O thread for channel 'group_replication_recovery': connected to master 'mysql_innodb_clust
er_10131712@db7-fw-us-east.sa.fwmrm.net:3306',replication started in log 'FIRST' at position 4
2023-09-11T07:55:40.119060Z 679 [ERROR] Slave SQL for channel 'group_replication_recovery': Worker 1 failed executing transaction '82e063
8a-e968-11ec-9a76-9cdc71bc2950:774245300' at master log mysql-bin.004136, end_log_pos 535344; Could not execute Write_rows event on table
 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:40.119242Z 479 [Note] Plugin group_replication reported: 'Terminating existing group replication donor connection and pu
rging the corresponding logs.'
2023-09-11T07:55:40.119321Z 678 [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:40.119685Z 677 [Note] Slave I/O thread exiting for channel 'group_replication_recovery', read up to log 'mysql-bin.00413
6', position 546525
2023-09-11T07:55:40.127272Z 479 [Note] Plugin group_replication reported: 'Retrying group recovery connection with another donor. Attempt
 10/10'
2023-09-11T07:56:37.352368Z 0 [Warning] Plugin group_replication reported: 'Members removed from the group: db8-fw-us-east.sa.fwmrm.net:3
306'
2023-09-11T07:56:37.352558Z 0 [Note] Plugin group_replication reported: 'Group membership changed to db7-fw-us-east.sa.fwmrm.net:3306, db
9-fw-us-east.sa.fwmrm.net:3306 on view 16944183276594499:4.'
2023-09-11T07:56:40.138563Z 479 [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:40.146715Z 479 [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:40.147077Z 700 [Warning] Storing MySQL user name or password information in the master info repository is not secure and
 is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Synta
x' in the MySQL Manual for more information.
2023-09-11T07:56:40.150093Z 701 [Note] Slave SQL thread for channel 'group_replication_recovery' initialized, starting replication in log
 'FIRST' at position 0, relay log './db9-fw-us-east-relay-bin-group_replication_recovery.000001' position: 4
2023-09-11T07:56:40.158921Z 700 [Note] Slave I/O thread for channel 'group_replication_recovery': connected to master 'mysql_innodb_clust
er_10131712@db7-fw-us-east.sa.fwmrm.net:3306',replication started in log 'FIRST' at position 4
2023-09-11T07:56:40.171290Z 702 [ERROR] Slave SQL for channel 'group_replication_recovery': Worker 1 failed executing transaction '82e063
8a-e968-11ec-9a76-9cdc71bc2950:774245300' at master log mysql-bin.004136, end_log_pos 535344; Could not execute Write_rows event on table
 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:40.171392Z 479 [Note] Plugin group_replication reported: 'Terminating existing group replication donor connection and pu
rging the corresponding logs.'
2023-09-11T07:56:40.171544Z 701 [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:40.171897Z 700 [Note] Slave I/O thread exiting for channel 'group_replication_recovery', read up to log 'mysql-bin.00413
6', position 550285
2023-09-11T07:56:40.187286Z 479 [ERROR] Plugin group_replication reported: 'Maximum number of retries when trying to connect to a donor r
eached. Aborting group replication recovery.'
2023-09-11T07:56:40.187325Z 479 [Note] Plugin group_replication reported: 'Terminating existing group replication donor connection and pu
rging the corresponding logs.'
2023-09-11T07:56:40.187341Z 479 [ERROR] Plugin group_replication reported: 'Fatal error during the Recovery process of Group Replication.
 The server will leave the group.'
2023-09-11T07:56:40.187371Z 479 [Note] Plugin group_replication reported: 'Going to wait for view modification'
2023-09-11T07:56:43.490092Z 0 [Note] Plugin group_replication reported: 'Group membership changed: This member has left the group.'
2023-09-11T10:46:16.707741Z 3628 [Note] Plugin group_replication reported: 'Plugin 'group_replication' is stopping.'
2023-09-11T10:46:16.707805Z 3628 [Note] Plugin group_replication reported: 'Requesting to leave the group despite of not being a member'
2023-09-11T10:46:16.708333Z 472 [Note] Error reading relay log event for channel 'group_replication_applier': slave SQL thread was killed
2023-09-11T10:46:16.708759Z 472 [Note] Slave SQL thread for channel 'group_replication_applier' exiting, replication stopped in log 'FIRS
T' at position 1250
2023-09-11T10:46:16.709845Z 469 [Note] Plugin group_replication reported: 'The group replication applier thread was killed'
2023-09-11T10:46:16.714006Z 3628 [Note] Plugin group_replication reported: 'Plugin 'group_replication' has been stopped.'
2023-09-11T10:46:57.707837Z 3628 [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:46:57.708020Z 3628 [Note] Plugin group_replication reported: '[GCS] Added automatically IP ranges 10.13.17.12/17,127.0.0.1/
8 to the whitelist'
2023-09-11T10:46:57.708198Z 3628 [Note] Plugin group_replication reported: '[GCS] Translated 'db9-fw-us-east.sa.fwmrm.net' to 10.13.17.12
'
2023-09-11T10:46:57.708385Z 3628 [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:46:57.710345Z 3628 [Note] Plugin group_replication reported: 'Initialized group communication with configuration: group_rep
lication_group_name: "82e0638a-e968-11ec-9a76-9cdc71bc2950"; group_replication_local_address: "db9-fw-us-east.sa.fwmrm.net:33061"; group_
replication_group_seeds: "db7-fw-us-east.sa.fwmrm.net:33061,db8-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:46:57.710420Z 3628 [Note] Plugin group_replication reported: '[GCS] Configured number of attempts to join: 0'
2023-09-11T10:46:57.710437Z 3628 [Note] Plugin group_replication reported: '[GCS] Configured time between attempts to join: 5 seconds'
2023-09-11T10:46:57.710472Z 3628 [Note] Plugin group_replication reported: 'Member configuration: member_id: 10131712; member_uuid: "c1e4
02cc-e886-11ec-8568-c6f2f45ba149"; single-primary mode: "true"; group_replication_auto_increment_increment: 7; '
2023-09-11T10:46:57.710969Z 3644 [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:46:57.722411Z 3647 [Note] Slave SQL thread for channel 'group_replication_applier' initialized, starting replication in log
 'FIRST' at position 0, relay log './db9-fw-us-east-relay-bin-group_replication_applier.003963' position: 4
2023-09-11T10:46:57.722428Z 3628 [Note] Plugin group_replication reported: 'Group Replication applier module successfully initialized!'
2023-09-11T10:46:57.722708Z 0 [Note] Plugin group_replication reported: 'XCom protocol version: 3'
2023-09-11T10:46:57.722751Z 0 [Note] Plugin group_replication reported: 'XCom initialized and ready to accept incoming connections on por
t 33061'
2023-09-11T10:47:00.006373Z 3628 [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:47:00.006412Z 0 [ERROR] Plugin group_replication reported: 'Group contains 3 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:47:00.006702Z 3654 [Note] Plugin group_replication reported: 'Establishing group recovery connection with a possible donor.
 Attempt 1/10'
2023-09-11T10:47:00.006828Z 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.019021Z 3654 [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='db8-fw-us
-east.sa.fwmrm.net', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''.
2023-09-11T10:47:00.028557Z 3654 [Note] Plugin group_replication reported: 'Establishing connection to a group replication recovery donor
 c07ce69f-e886-11ec-8aef-08f1ea7dba36 at db8-fw-us-east.sa.fwmrm.net port: 3306.'
2023-09-11T10:47:00.028794Z 3656 [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:47:00.034134Z 3657 [Note] Slave SQL thread for channel 'group_replication_recovery' initialized, starting replication in lo
g 'FIRST' at position 0, relay log './db9-fw-us-east-relay-bin-group_replication_recovery.000001' position: 4
2023-09-11T10:47:00.040877Z 3656 [Note] Slave I/O thread for channel 'group_replication_recovery': connected to master 'mysql_innodb_clus
ter_10131712@db8-fw-us-east.sa.fwmrm.net:3306',replication started in log 'FIRST' at position 4
2023-09-11T10:49:05.554551Z 3654 [Note] Plugin group_replication reported: 'Terminating existing group replication donor connection and p
urging the corresponding logs.'
2023-09-11T10:49:05.554844Z 3657 [Note] Slave SQL thread for channel 'group_replication_recovery' exiting, replication stopped in log 'my
sql-bin.004140' at position 127916673
2023-09-11T10:49:05.555196Z 3656 [Note] Slave I/O thread killed while reading event for channel 'group_replication_recovery'
2023-09-11T10:49:05.555237Z 3656 [Note] Slave I/O thread exiting for channel 'group_replication_recovery', read up to log 'mysql-bin.0041
40', position 135435292
2023-09-11T10:49:05.613220Z 3654 [Note] 'CHANGE MASTER TO FOR CHANNEL 'group_replication_recovery' executed'. Previous state master_host=
'db8-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:49:07.067257Z 0 [Note] Plugin group_replication reported: 'This server was declared online within the replication group'