docker部署到云服务器上启动失败
docker部署到多台云服务器上,启动不起来运行流程如下:
docker run -d --name mgr1 -p 3307:3306 -p 33060:33060 -p 33061:33061 -e MYSQL_ROOT_PASSWORD='root' -e MYSQL_IBP=1G -e MYSQL_MGR_NAME='aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaa1' -e MYSQL_MGR_LOCAL='39.108.220.160:33061' -e MYSQL_MGR_SEEDS='39.108.220.160:33061,103.39.221.66:33061,120.77.70.238:33061' -e MYSQL_INIT_MGR=1 -e MYSQL_MGR_USER='repl' -e MYSQL_MGR_USER_PWD='repl' -e MYSQL_SID=330602 greatsql/greatsql
执行后进入容器,进入到mysql内部
设置ip白名单
set global group_replication_ip_allowlist="39.108.220.160,103.39.221.66,120.77.70.238";
SET GLOBAL group_replication_bootstrap_group=ON;
START GROUP_REPLICATION;
出现一下报错
ERROR 3096 (HY000): The START GROUP_REPLICATION command failed as there was an error when initializing the group communication layer.
详细日志如下
22022-11-06T23:01:19.633925+08:00 0 Ignoring --secure-file-priv value as server is running with --initialize(-insecure).
2022-11-06T23:01:19.633982+08:00 0 Basedir set to /usr/.
2022-11-06T23:01:19.633996+08:00 0 /usr/sbin/mysqld (mysqld 8.0.25-16) initializing of server in progress as process 28
2022-11-06T23:01:19.636088+08:00 0 --initialize specified on an existing data directory.
2022-11-06T23:01:19.647578+08:00 0 Using Linux native AIO
2022-11-06T23:01:19.647928+08:00 0 Plugin 'FEDERATED' is disabled.
2022-11-06T23:01:19.649717+08:00 1 InnoDB initialization has started.
2022-11-06T23:01:19.649803+08:00 1 Atomic write enabled
2022-11-06T23:01:19.649859+08:00 1 The first innodb_system data file 'ibdata1' did not exist. A new tablespace will be created!
2022-11-06T23:01:19.649906+08:00 1 PUNCH HOLE support available
2022-11-06T23:01:19.649950+08:00 1 Uses event mutexes
2022-11-06T23:01:19.649985+08:00 1 GCC builtin __atomic_thread_fence() is used for memory barrier
2022-11-06T23:01:19.650021+08:00 1 Compressed tables use zlib 1.2.11
2022-11-06T23:01:19.653654+08:00 1 Number of pools: 1
2022-11-06T23:01:19.653856+08:00 1 Using CPU crc32 instructions
2022-11-06T23:01:19.654390+08:00 1 Directories to scan './'
2022-11-06T23:01:19.654505+08:00 1 Scanning './'
2022-11-06T23:01:19.654618+08:00 1 Completed space ID check of 0 files.
2022-11-06T23:01:19.656213+08:00 1 Initializing buffer pool, total size = 1.000000G, instances = 8, chunk size =128.000000M
2022-11-06T23:01:19.749251+08:00 1 Completed initialization of buffer pool
2022-11-06T23:01:19.755661+08:00 0 If the mysqld execution user is authorized, page cleaner and LRU manager thread priority can be changed. See the man page of setpriority().
2022-11-06T23:01:19.780039+08:00 1 Setting file './ibdata1' size to 12 MB. Physically writing the file full; Please wait ...
2022-11-06T23:01:19.834273+08:00 1 File './ibdata1' size is now 12 MB.
2022-11-06T23:01:19.834982+08:00 1 Creating log file ./ib_logfile101
2022-11-06T23:01:19.836193+08:00 1 Creating log file ./ib_logfile1
2022-11-06T23:01:19.869667+08:00 1 Double write buffer files: 2
2022-11-06T23:01:19.869772+08:00 1 Double write buffer pages per instance: 4
2022-11-06T23:01:19.869918+08:00 1 Using './#ib_16384_0.dblwr' for doublewrite
2022-11-06T23:01:19.873296+08:00 1 Using './#ib_16384_1.dblwr' for doublewrite
2022-11-06T23:01:19.910755+08:00 1 Log background threads are being started...
2022-11-06T23:01:19.936735+08:00 1 Creating UNDO Tablespace ./undo_001
2022-11-06T23:01:19.936865+08:00 1 Setting file ./undo_001 size to 16 MB
2022-11-06T23:01:19.936944+08:00 1 Physically writing the file full
2022-11-06T23:01:20.056872+08:00 1 Creating UNDO Tablespace ./undo_002
2022-11-06T23:01:20.056996+08:00 1 Setting file ./undo_002 size to 16 MB
2022-11-06T23:01:20.057080+08:00 1 Physically writing the file full
2022-11-06T23:01:20.173378+08:00 1 Created 2 undo tablespaces.
2022-11-06T23:01:20.173920+08:00 1 GTID recovery trx_no: 0
2022-11-06T23:01:20.186000+08:00 1 Log background threads are being closed...
2022-11-06T23:01:20.191732+08:00 1 Renaming log file ./ib_logfile101 to ./ib_logfile0
2022-11-06T23:01:20.191954+08:00 1 New log files created, LSN=8204
2022-11-06T23:01:20.192062+08:00 1 Log background threads are being started...
2022-11-06T23:01:20.192352+08:00 1 Legacy doublewrite buffer not found: creating new
2022-11-06T23:01:20.195634+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.196140+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.196275+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.230972+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.231141+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.231294+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.231491+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.232411+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.232574+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.232700+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.232833+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.233749+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.234047+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.234265+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.234452+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.235370+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.235531+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.235683+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.236762+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.236933+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.237084+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.237241+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.238522+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.238686+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.238857+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.239025+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.240447+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.240755+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.241082+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.241578+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.242537+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.242873+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.243986+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.244183+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.244372+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.244550+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.244737+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.245663+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.246141+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.246643+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.246922+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.247833+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.248032+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.248230+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.248453+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.249811+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.250112+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.250826+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.251083+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.252197+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.252433+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.252705+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.253170+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.254117+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.254404+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.255121+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.255438+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.256425+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.256678+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.256948+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.257447+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.258412+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.258670+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.258979+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.259259+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.260241+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.260519+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.261250+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.261868+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.262831+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.263110+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.264532+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.264846+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.265893+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.266189+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.266855+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.267142+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.268221+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.268530+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.268891+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.269491+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.270528+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.270834+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.271484+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.271801+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.272819+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.273110+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.273832+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.274163+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.275217+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.275546+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.276186+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.276528+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.277590+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.277944+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.278275+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.281015+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.281357+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.281689+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.282024+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.282332+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.283517+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.283903+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.284234+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.284568+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.285938+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.286324+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.286870+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.287280+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.288891+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.289383+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.289885+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.290292+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.291425+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.291845+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.292416+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.293105+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.294311+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.294830+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.295315+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.295838+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.296933+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.297380+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.297980+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.298574+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.299837+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.300875+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.301424+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.302078+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.303280+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.303804+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.304696+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.305131+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.306267+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.306691+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.307091+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.307469+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.308718+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.309282+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.309778+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.310262+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.311463+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.311939+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.312383+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.312802+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.313984+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.314473+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.314885+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.315280+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.332636+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.333279+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.333754+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.334249+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.336878+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.337414+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.337933+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.338389+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.339699+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.340178+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.340625+08:00 0 Resetting invalid page type 20 to 13 when flushing.
2022-11-06T23:01:20.375840+08:00 1 Legacy atomic write buffer created
2022-11-06T23:01:20.376398+08:00 1 Creating shared tablespace for temporary tables
2022-11-06T23:01:20.376968+08:00 1 Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-11-06T23:01:20.434485+08:00 1 File './ibtmp1' size is now 12 MB.
2022-11-06T23:01:20.456329+08:00 1 Created 128 and tracked 128 new rollback segment(s) in the temporary tablespace. 128 are now active.
2022-11-06T23:01:20.462113+08:00 1 Created 128 and tracked 128 new rollback segment(s) in undo tablespace number 1. 128 are now active.
2022-11-06T23:01:20.468274+08:00 1 Created 128 and tracked 128 new rollback segment(s) in undo tablespace number 2. 128 are now active.
2022-11-06T23:01:20.794404+08:00 1 Percona XtraDB (http://www.percona.com) 8.0.25-15 started; log sequence number 2399381
2022-11-06T23:01:20.799275+08:00 1 InnoDB initialization has ended.
2022-11-06T23:01:20.802314+08:00 1 Data dictionary initializing version '80023'.
2022-11-06T23:01:21.167384+08:00 1 Installed data dictionary with version 80023
2022-11-06T23:01:21.326396+08:00 2 Created system views with I_S version 80023.
2022-11-06T23:01:21.327302+08:00 0 Ignoring --plugin-load list as the server is running with --initialize(-insecure).
2022-11-06T23:01:21.737265+08:00 0 Generating a new UUID: e01df48a-5de3-11ed-9cbc-0242ac110005.
2022-11-06T23:01:21.759756+08:00 0 DDL log recovery : begin
2022-11-06T23:01:21.760398+08:00 0 DDL log recovery : end
2022-11-06T23:01:21.918128+08:00 0 Auto generated SSL certificates are placed in data directory.
2022-11-06T23:01:21.970939+08:00 0 Auto generated RSA key files through --sha256_password_auto_generate_rsa_keys are placed in data directory.
2022-11-06T23:01:21.971520+08:00 0 Skipping generation of RSA key pair through --caching_sha2_password_auto_generate_rsa_keys as key files are present in data directory.
2022-11-06T23:01:21.973062+08:00 0 unknown variable 'loose-group_replication_group_name=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaa1'.
2022-11-06T23:01:21.973675+08:00 0 unknown variable 'loose-group_replication_view_change_uuid=AUTOMATIC'.
2022-11-06T23:01:21.974218+08:00 0 unknown variable 'loose-group_replication_local_address=39.108.220.160:33061'.
2022-11-06T23:01:21.974708+08:00 0 unknown variable 'loose-group_replication_group_seeds=39.108.220.160:33061,103.39.221.66:33061,120.77.70.238:33061'.
2022-11-06T23:01:21.975778+08:00 0 unknown variable 'loose-group_replication_start_on_boot=START_MGR'.
2022-11-06T23:01:21.976360+08:00 0 unknown variable 'loose-group_replication_bootstrap_group=BOOTSTRAP_MGR'.
2022-11-06T23:01:21.977174+08:00 0 unknown variable 'loose-group_replication_exit_state_action=READ_ONLY'.
2022-11-06T23:01:21.977734+08:00 0 unknown variable 'loose-group_replication_flow_control_mode=DISABLED'.
2022-11-06T23:01:21.978394+08:00 0 unknown variable 'loose-group_replication_single_primary_mode=ON'.
2022-11-06T23:01:21.979028+08:00 0 unknown variable 'loose-group_replication_communication_max_message_size=10M'.
2022-11-06T23:01:21.979612+08:00 0 unknown variable 'loose-group_replication_arbitrator=0'.
2022-11-06T23:01:21.980203+08:00 0 unknown variable 'loose-group_replication_single_primary_fast_mode=0'.
2022-11-06T23:01:21.980837+08:00 0 unknown variable 'loose-group_replication_request_time_threshold=50'.
2022-11-06T23:01:21.983020+08:00 6 Creating the system database.
2022-11-06T23:01:21.983053+08:00 6 root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
2022-11-06T23:01:21.983120+08:00 6 Creating the system tables.
2022-11-06T23:01:22.378291+08:00 6 Filling in the system tables, part 1.
2022-11-06T23:01:22.434188+08:00 6 Filling in the system tables, part 2.
2022-11-06T23:01:22.776816+08:00 6 Filling in the mysql.help table.
2022-11-06T23:01:22.906834+08:00 6 Creating the system users for internal usage.
2022-11-06T23:01:22.933165+08:00 6 Creating the sys schema.
2022-11-06T23:01:23.492924+08:00 6 Bootstrapping complete
2022-11-06T23:01:23.538274+08:00 0 Giving 0 client threads a chance to die gracefully
2022-11-06T23:01:23.538316+08:00 0 Shutting down slave threads
2022-11-06T23:01:23.538331+08:00 0 Forcefully disconnecting 0 remaining clients
2022-11-06T23:01:23.539625+08:00 0 FTS optimize thread exiting.
2022-11-06T23:01:24.048874+08:00 0 Starting shutdown...
2022-11-06T23:01:24.051518+08:00 0 Dumping buffer pool(s) to /data/GreatSQL/ib_buffer_pool
2022-11-06T23:01:24.051819+08:00 0 Buffer pool(s) dump completed at 221106 23:01:24
2022-11-06T23:01:24.855162+08:00 0 Log background threads are being closed...
2022-11-06T23:01:25.390669+08:00 0 Shutdown completed; log sequence number 17834805
2022-11-06T23:01:25.390772+08:00 0 Removed temporary tablespace data file: "ibtmp1"
2022-11-06T23:01:25.769524+08:00 0 Basedir set to /usr/.
2022-11-06T23:01:25.769545+08:00 0 /usr/sbin/mysqld (mysqld 8.0.25-16) starting as process 94
2022-11-06T23:01:25.779657+08:00 0 Using Linux native AIO
2022-11-06T23:01:25.779980+08:00 0 Plugin 'FEDERATED' is disabled.
2022-11-06T23:01:25.781656+08:00 1 InnoDB initialization has started.
2022-11-06T23:01:25.781724+08:00 1 Atomic write enabled
2022-11-06T23:01:25.781795+08:00 1 PUNCH HOLE support available
2022-11-06T23:01:25.781839+08:00 1 Uses event mutexes
2022-11-06T23:01:25.781897+08:00 1 GCC builtin __atomic_thread_fence() is used for memory barrier
2022-11-06T23:01:25.781933+08:00 1 Compressed tables use zlib 1.2.11
2022-11-06T23:01:25.785715+08:00 1 Number of pools: 1
2022-11-06T23:01:25.785931+08:00 1 Using CPU crc32 instructions
2022-11-06T23:01:25.786488+08:00 1 Directories to scan './'
2022-11-06T23:01:25.786599+08:00 1 Scanning './'
2022-11-06T23:01:25.790022+08:00 1 Completed space ID check of 4 files.
2022-11-06T23:01:25.791534+08:00 1 Initializing buffer pool, total size = 1.000000G, instances = 8, chunk size =128.000000M
2022-11-06T23:01:25.907671+08:00 1 Completed initialization of buffer pool
2022-11-06T23:01:25.928228+08:00 0 If the mysqld execution user is authorized, page cleaner and LRU manager thread priority can be changed. See the man page of setpriority().
2022-11-06T23:01:25.938357+08:00 1 Using './#ib_16384_0.dblwr' for doublewrite
2022-11-06T23:01:25.940851+08:00 1 Using './#ib_16384_1.dblwr' for doublewrite
2022-11-06T23:01:25.994006+08:00 1 Double write buffer files: 2
2022-11-06T23:01:25.994110+08:00 1 Double write buffer pages per instance: 4
2022-11-06T23:01:25.994204+08:00 1 Using './#ib_16384_0.dblwr' for doublewrite
2022-11-06T23:01:25.994311+08:00 1 Using './#ib_16384_1.dblwr' for doublewrite
2022-11-06T23:01:25.998131+08:00 1 Starting to parse redo log at lsn = 17834536, whereas checkpoint_lsn = 17834805 and start_lsn = 17834496
2022-11-06T23:01:26.003568+08:00 1 Log background threads are being started...
2022-11-06T23:01:26.010917+08:00 1 Applying a batch of 0 redo log records ...
2022-11-06T23:01:26.011035+08:00 1 Apply batch completed!
2022-11-06T23:01:26.011657+08:00 1 Using undo tablespace './undo_001'.
2022-11-06T23:01:26.012706+08:00 1 Using undo tablespace './undo_002'.
2022-11-06T23:01:26.014024+08:00 1 Opened 2 existing undo tablespaces.
2022-11-06T23:01:26.014143+08:00 1 GTID recovery trx_no: 1269
2022-11-06T23:01:26.238117+08:00 1 Creating shared tablespace for temporary tables
2022-11-06T23:01:26.238323+08:00 1 Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-11-06T23:01:26.338745+08:00 1 File './ibtmp1' size is now 12 MB.
2022-11-06T23:01:26.339048+08:00 1 Scanning temp tablespace dir:'./#innodb_temp/'
2022-11-06T23:01:26.356995+08:00 1 Created 128 and tracked 128 new rollback segment(s) in the temporary tablespace. 128 are now active.
2022-11-06T23:01:26.364159+08:00 1 Percona XtraDB (http://www.percona.com) 8.0.25-15 started; log sequence number 17834805
2022-11-06T23:01:26.365145+08:00 1 InnoDB initialization has ended.
2022-11-06T23:01:26.376502+08:00 1 Data dictionary restarting version '80023'.
2022-11-06T23:01:26.479058+08:00 1 Reading DD tablespace files
2022-11-06T23:01:26.479987+08:00 1 Scanned 6 tablespaces. Validated 6.
2022-11-06T23:01:26.510781+08:00 1 Using data dictionary with version '80023'.
2022-11-06T23:01:26.516938+08:00 0 option 'group-replication-start-on-boot': boolean value 'START_MGR' was not recognized. Set to OFF.
2022-11-06T23:01:26.517126+08:00 0 option 'group-replication-bootstrap-group': boolean value 'BOOTSTRAP_MGR' was not recognized. Set to OFF.
2022-11-06T23:01:26.525404+08:00 0 Plugin mysqlx reported: 'X Plugin ready for connections. socket: '/var/lib/mysql/mysqlx.sock''
2022-11-06T23:01:26.525583+08:00 0 X Plugin ready for connections. Socket: /var/lib/mysql/mysqlx.sock
2022-11-06T23:01:26.638342+08:00 0 DDL log recovery : begin
2022-11-06T23:01:26.638970+08:00 0 DDL log recovery : end
2022-11-06T23:01:26.641003+08:00 0 Loading buffer pool(s) from /data/GreatSQL/ib_buffer_pool
2022-11-06T23:01:26.682061+08:00 0 Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2022-11-06T23:01:26.682298+08:00 0 Skipping generation of SSL certificates as certificate files are present in data directory.
2022-11-06T23:01:26.683548+08:00 0 CA certificate ca.pem is self signed.
2022-11-06T23:01:26.683780+08:00 0 Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2022-11-06T23:01:26.684000+08:00 0 Skipping generation of RSA key pair through --sha256_password_auto_generate_rsa_keys as key files are present in data directory.
2022-11-06T23:01:26.684155+08:00 0 Skipping generation of RSA key pair through --caching_sha2_password_auto_generate_rsa_keys as key files are present in data directory.
2022-11-06T23:01:26.688845+08:00 0 unknown variable 'loose-group_replication_view_change_uuid=AUTOMATIC'.
2022-11-06T23:01:26.763107+08:00 0 Failed to start slave threads for channel ''.
2022-11-06T23:01:26.766423+08:00 5 Event Scheduler: scheduler thread started with id 5
2022-11-06T23:01:26.767221+08:00 0 Plugin mysqlx reported: 'Using SSL configuration from MySQL Server'
2022-11-06T23:01:26.767921+08:00 0 Plugin mysqlx reported: 'Using OpenSSL for TLS connections'
2022-11-06T23:01:26.768132+08:00 0 /usr/sbin/mysqld: ready for connections. Version: '8.0.25-16'socket: '/data/GreatSQL/mysql.sock'port: 0GreatSQL (GPL), Release 16, Revision 8bb0e5af297.
2022-11-06T23:01:26.773970+08:00 0 Buffer pool(s) load completed at 221106 23:01:26
2022-11-06T23:01:27.572896+08:00 10 Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--relay-log=56545ec501fe-relay-bin' to avoid this problem.
2022-11-06T23:01:27.581153+08:00 10 'CHANGE MASTER TO FOR CHANNEL 'group_replication_recovery' executed'. Previous state master_host='', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''.
2022-11-06T23:01:27.599320+08:00 0 Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.0.25-16).
2022-11-06T23:01:27.600171+08:00 0 Giving 1 client threads a chance to die gracefully
2022-11-06T23:01:27.600200+08:00 0 Shutting down slave threads
2022-11-06T23:01:27.600214+08:00 0 Event Scheduler: Killing the scheduler thread, thread id 5
2022-11-06T23:01:27.600228+08:00 0 Event Scheduler: Waiting for the scheduler thread to reply
2022-11-06T23:01:27.600310+08:00 0 Event Scheduler: Stopped
2022-11-06T23:01:27.600322+08:00 0 Forcefully disconnecting 0 remaining clients
2022-11-06T23:01:27.600342+08:00 0 Event Scheduler: Purging the queue. 0 events
2022-11-06T23:01:27.603095+08:00 0 FTS optimize thread exiting.
2022-11-06T23:01:28.483231+08:00 0 Binlog end
2022-11-06T23:01:28.485813+08:00 0 Shutting down plugin 'group_replication'
2022-11-06T23:01:28.485877+08:00 0 Plugin group_replication reported: 'All Group Replication server observers have been successfully unregistered'
2022-11-06T23:01:28.485919+08:00 0 Shutting down plugin 'clone'
2022-11-06T23:01:28.485945+08:00 0 Shutting down plugin 'mysqlx'
2022-11-06T23:01:28.486439+08:00 0 Shutting down plugin 'mysqlx_cache_cleaner'
2022-11-06T23:01:28.486468+08:00 0 Shutting down plugin 'ngram'
2022-11-06T23:01:28.486486+08:00 0 Shutting down plugin 'BLACKHOLE'
2022-11-06T23:01:28.486499+08:00 0 Shutting down plugin 'ARCHIVE'
2022-11-06T23:01:28.486505+08:00 0 Shutting down plugin 'TempTable'
2022-11-06T23:01:28.486518+08:00 0 Shutting down plugin 'MRG_MYISAM'
2022-11-06T23:01:28.486525+08:00 0 Shutting down plugin 'MyISAM'
2022-11-06T23:01:28.486538+08:00 0 Shutting down plugin 'INNODB_CHANGED_PAGES'
2022-11-06T23:01:28.486545+08:00 0 Shutting down plugin 'INNODB_TABLESPACES_SCRUBBING'
2022-11-06T23:01:28.486550+08:00 0 Shutting down plugin 'INNODB_TABLESPACES_ENCRYPTION'
2022-11-06T23:01:28.486556+08:00 0 Shutting down plugin 'INNODB_SESSION_TEMP_TABLESPACES'
2022-11-06T23:01:28.486561+08:00 0 Shutting down plugin 'INNODB_CACHED_INDEXES'
2022-11-06T23:01:28.486568+08:00 0 Shutting down plugin 'INNODB_VIRTUAL'
2022-11-06T23:01:28.486576+08:00 0 Shutting down plugin 'INNODB_COLUMNS'
2022-11-06T23:01:28.486584+08:00 0 Shutting down plugin 'INNODB_TABLESPACES'
2022-11-06T23:01:28.486592+08:00 0 Shutting down plugin 'INNODB_INDEXES'
2022-11-06T23:01:28.486600+08:00 0 Shutting down plugin 'INNODB_TABLESTATS'
2022-11-06T23:01:28.486608+08:00 0 Shutting down plugin 'INNODB_TABLES'
2022-11-06T23:01:28.486613+08:00 0 Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2022-11-06T23:01:28.486619+08:00 0 Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2022-11-06T23:01:28.486624+08:00 0 Shutting down plugin 'INNODB_FT_CONFIG'
2022-11-06T23:01:28.486629+08:00 0 Shutting down plugin 'INNODB_FT_BEING_DELETED'
2022-11-06T23:01:28.486635+08:00 0 Shutting down plugin 'INNODB_FT_DELETED'
2022-11-06T23:01:28.486640+08:00 0 Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2022-11-06T23:01:28.486645+08:00 0 Shutting down plugin 'INNODB_METRICS'
2022-11-06T23:01:28.486651+08:00 0 Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2022-11-06T23:01:28.486656+08:00 0 Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2022-11-06T23:01:28.486661+08:00 0 Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2022-11-06T23:01:28.486666+08:00 0 Shutting down plugin 'INNODB_BUFFER_PAGE'
2022-11-06T23:01:28.486671+08:00 0 Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2022-11-06T23:01:28.486680+08:00 0 Shutting down plugin 'INNODB_CMP_PER_INDEX'
2022-11-06T23:01:28.486686+08:00 0 Shutting down plugin 'INNODB_CMPMEM_RESET'
2022-11-06T23:01:28.486691+08:00 0 Shutting down plugin 'INNODB_CMPMEM'
2022-11-06T23:01:28.486696+08:00 0 Shutting down plugin 'INNODB_CMP_RESET'
2022-11-06T23:01:28.486701+08:00 0 Shutting down plugin 'INNODB_CMP'
2022-11-06T23:01:28.486706+08:00 0 Shutting down plugin 'INNODB_TRX'
2022-11-06T23:01:28.486712+08:00 0 Shutting down plugin 'InnoDB'
2022-11-06T23:01:28.486739+08:00 0 Starting shutdown...
2022-11-06T23:01:28.486859+08:00 0 Dumping buffer pool(s) to /data/GreatSQL/ib_buffer_pool
2022-11-06T23:01:28.487048+08:00 0 Buffer pool(s) dump completed at 221106 23:01:28
2022-11-06T23:01:28.593567+08:00 0 Log background threads are being closed...
2022-11-06T23:01:29.117621+08:00 0 Shutdown completed; log sequence number 18239086
2022-11-06T23:01:29.117722+08:00 0 Removed temporary tablespace data file: "ibtmp1"
2022-11-06T23:01:29.117749+08:00 0 Shutting down plugin 'MEMORY'
2022-11-06T23:01:29.117768+08:00 0 Shutting down plugin 'CSV'
2022-11-06T23:01:29.117777+08:00 0 Shutting down plugin 'PERFORMANCE_SCHEMA'
2022-11-06T23:01:29.117836+08:00 0 Shutting down plugin 'daemon_keyring_proxy_plugin'
2022-11-06T23:01:29.117860+08:00 0 Shutting down plugin 'sha2_cache_cleaner'
2022-11-06T23:01:29.117867+08:00 0 Shutting down plugin 'caching_sha2_password'
2022-11-06T23:01:29.117874+08:00 0 Shutting down plugin 'sha256_password'
2022-11-06T23:01:29.117879+08:00 0 Shutting down plugin 'mysql_native_password'
2022-11-06T23:01:29.119655+08:00 0 Shutting down plugin 'binlog'
2022-11-06T23:01:29.122029+08:00 0 /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.25-16)GreatSQL (GPL), Release 16, Revision 8bb0e5af297.
2022-11-06T23:01:29.501699+08:00 0 Basedir set to /usr/.
2022-11-06T23:01:29.501718+08:00 0 /usr/sbin/mysqld (mysqld 8.0.25-16) starting as process 1
2022-11-06T23:01:29.512024+08:00 0 Using Linux native AIO
2022-11-06T23:01:29.512305+08:00 0 Plugin 'FEDERATED' is disabled.
2022-11-06T23:01:29.513871+08:00 1 InnoDB initialization has started.
2022-11-06T23:01:29.513937+08:00 1 Atomic write enabled
2022-11-06T23:01:29.513998+08:00 1 PUNCH HOLE support available
2022-11-06T23:01:29.514043+08:00 1 Uses event mutexes
2022-11-06T23:01:29.514077+08:00 1 GCC builtin __atomic_thread_fence() is used for memory barrier
2022-11-06T23:01:29.514112+08:00 1 Compressed tables use zlib 1.2.11
2022-11-06T23:01:29.517819+08:00 1 Number of pools: 1
2022-11-06T23:01:29.518009+08:00 1 Using CPU crc32 instructions
2022-11-06T23:01:29.518560+08:00 1 Directories to scan './'
2022-11-06T23:01:29.518670+08:00 1 Scanning './'
2022-11-06T23:01:29.520992+08:00 1 Completed space ID check of 4 files.
2022-11-06T23:01:29.522466+08:00 1 Initializing buffer pool, total size = 1.000000G, instances = 8, chunk size =128.000000M
2022-11-06T23:01:29.608469+08:00 1 Completed initialization of buffer pool
2022-11-06T23:01:29.635092+08:00 0 If the mysqld execution user is authorized, page cleaner and LRU manager thread priority can be changed. See the man page of setpriority().
2022-11-06T23:01:29.654991+08:00 1 Using './#ib_16384_0.dblwr' for doublewrite
2022-11-06T23:01:29.657315+08:00 1 Using './#ib_16384_1.dblwr' for doublewrite
2022-11-06T23:01:29.711695+08:00 1 Double write buffer files: 2
2022-11-06T23:01:29.711835+08:00 1 Double write buffer pages per instance: 4
2022-11-06T23:01:29.711935+08:00 1 Using './#ib_16384_0.dblwr' for doublewrite
2022-11-06T23:01:29.712031+08:00 1 Using './#ib_16384_1.dblwr' for doublewrite
2022-11-06T23:01:29.712978+08:00 1 Starting to parse redo log at lsn = 18239010, whereas checkpoint_lsn = 18239086 and start_lsn = 18238976
2022-11-06T23:01:29.718642+08:00 1 Log background threads are being started...
2022-11-06T23:01:29.719070+08:00 1 Applying a batch of 0 redo log records ...
2022-11-06T23:01:29.719222+08:00 1 Apply batch completed!
2022-11-06T23:01:29.719901+08:00 1 Using undo tablespace './undo_001'.
2022-11-06T23:01:29.721022+08:00 1 Using undo tablespace './undo_002'.
2022-11-06T23:01:29.722135+08:00 1 Opened 2 existing undo tablespaces.
2022-11-06T23:01:29.722261+08:00 1 GTID recovery trx_no: 1565
2022-11-06T23:01:29.950044+08:00 1 Creating shared tablespace for temporary tables
2022-11-06T23:01:29.950302+08:00 1 Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-11-06T23:01:30.049720+08:00 1 File './ibtmp1' size is now 12 MB.
2022-11-06T23:01:30.050044+08:00 1 Scanning temp tablespace dir:'./#innodb_temp/'
2022-11-06T23:01:30.072364+08:00 1 Created 128 and tracked 128 new rollback segment(s) in the temporary tablespace. 128 are now active.
2022-11-06T23:01:30.073279+08:00 1 Percona XtraDB (http://www.percona.com) 8.0.25-15 started; log sequence number 18239086
2022-11-06T23:01:30.074262+08:00 1 InnoDB initialization has ended.
2022-11-06T23:01:30.085315+08:00 1 Data dictionary restarting version '80023'.
2022-11-06T23:01:30.194838+08:00 1 Reading DD tablespace files
2022-11-06T23:01:30.195687+08:00 1 Scanned 6 tablespaces. Validated 6.
2022-11-06T23:01:30.211681+08:00 1 Using data dictionary with version '80023'.
2022-11-06T23:01:30.225241+08:00 0 Plugin mysqlx reported: 'IPv6 is available'
2022-11-06T23:01:30.227247+08:00 0 Plugin mysqlx reported: 'X Plugin ready for connections. bind-address: '::' port: 33060'
2022-11-06T23:01:30.227439+08:00 0 Plugin mysqlx reported: 'X Plugin ready for connections. socket: '/var/lib/mysql/mysqlx.sock''
2022-11-06T23:01:30.227570+08:00 0 X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/lib/mysql/mysqlx.sock
2022-11-06T23:01:30.236003+08:00 0 Plugin group_replication reported: 'Plugin 'group_replication' is starting.'
2022-11-06T23:01:30.236217+08:00 0 Plugin group_replication reported: 'Current debug options are: 'GCS_DEBUG_NONE'.'
2022-11-06T23:01:30.279733+08:00 0 DDL log recovery : begin
2022-11-06T23:01:30.280409+08:00 0 DDL log recovery : end
2022-11-06T23:01:30.281102+08:00 0 Loading buffer pool(s) from /data/GreatSQL/ib_buffer_pool
2022-11-06T23:01:30.308282+08:00 0 Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2022-11-06T23:01:30.308550+08:00 0 Skipping generation of SSL certificates as certificate files are present in data directory.
2022-11-06T23:01:30.309782+08:00 0 CA certificate ca.pem is self signed.
2022-11-06T23:01:30.310112+08:00 0 Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2022-11-06T23:01:30.310327+08:00 0 Skipping generation of RSA key pair through --sha256_password_auto_generate_rsa_keys as key files are present in data directory.
2022-11-06T23:01:30.310494+08:00 0 Skipping generation of RSA key pair through --caching_sha2_password_auto_generate_rsa_keys as key files are present in data directory.
2022-11-06T23:01:30.310834+08:00 0 Server hostname (bind-address): '*'; port: 3306
2022-11-06T23:01:30.311026+08:00 0 IPv6 is available.
2022-11-06T23:01:30.311217+08:00 0 - '::' resolves to '::';
2022-11-06T23:01:30.311427+08:00 0 Server socket created on IP: '::'.
2022-11-06T23:01:30.315081+08:00 0 unknown variable 'loose-group_replication_view_change_uuid=AUTOMATIC'.
2022-11-06T23:01:30.347283+08:00 0 Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--relay-log=56545ec501fe-relay-bin' to avoid this problem.
2022-11-06T23:01:30.352868+08:00 0 Relay log recovery skipped for group replication channel.
2022-11-06T23:01:30.353154+08:00 0 Recovery from master pos 4 and filefor channel 'group_replication_recovery'. Previous relay log pos and relay log file had been set to 4, ./56545ec501fe-relay-bin-group_replication_recovery.000001 respectively.
2022-11-06T23:01:30.355498+08:00 0 Failed to start slave threads for channel ''.
2022-11-06T23:01:30.357427+08:00 6 Event Scheduler: scheduler thread started with id 6
2022-11-06T23:01:30.358383+08:00 0 Plugin mysqlx reported: 'Using SSL configuration from MySQL Server'
2022-11-06T23:01:30.358959+08:00 0 Plugin mysqlx reported: 'Using OpenSSL for TLS connections'
2022-11-06T23:01:30.359174+08:00 0 /usr/sbin/mysqld: ready for connections. Version: '8.0.25-16'socket: '/data/GreatSQL/mysql.sock'port: 3306GreatSQL (GPL), Release 16, Revision 8bb0e5af297.
2022-11-06T23:01:30.359829+08:00 2 Plugin group_replication reported: 'Setting super_read_only=ON.'
2022-11-06T23:01:30.359910+08:00 2 Plugin group_replication reported: 'Group communication SSL configuration: group_replication_ssl_mode: "DISABLED"'
2022-11-06T23:01:30.360555+08:00 0 Buffer pool(s) load completed at 221106 23:01:30
2022-11-06T23:01:30.361389+08:00 2 Plugin group_replication reported: ' Debug messages will be sent to: asynchronous::/data/GreatSQL/GCS_DEBUG_TRACE'
2022-11-06T23:01:30.361538+08:00 2 Plugin group_replication reported: ' Added automatically IP ranges 127.0.0.1/8,172.17.0.5/16,::1/128,fe80::42:acff:fe11:5/64 to the allowlist'
2022-11-06T23:01:30.361613+08:00 2 Plugin group_replication reported: ' There is no local IP address matching the one configured for the local node (39.108.220.160:33061).'
2022-11-06T23:01:30.362755+08:00 2 Plugin group_replication reported: 'Unable to initialize the group communication engine'
2022-11-06T23:01:30.362779+08:00 2 Plugin group_replication reported: 'Error on group communication engine initialization'
2022-11-06T23:01:30.362803+08:00 2 Plugin group_replication reported: 'Requesting to leave the group despite of not being a member'
2022-11-06T23:01:30.362876+08:00 2 Plugin group_replication reported: 'Setting super_read_only=OFF.'
mbind: Operation not permitted
2022-11-06T23:02:33.338945+08:00 10 Plugin group_replication reported: 'Plugin 'group_replication' is starting.'
2022-11-06T23:02:33.339011+08:00 10 Plugin group_replication reported: 'Current debug options are: 'GCS_DEBUG_NONE'.'
2022-11-06T23:02:33.339769+08:00 11 Plugin group_replication reported: 'Setting super_read_only=ON.'
2022-11-06T23:02:33.339865+08:00 10 Plugin group_replication reported: 'Group communication SSL configuration: group_replication_ssl_mode: "DISABLED"'
2022-11-06T23:02:33.340906+08:00 10 Plugin group_replication reported: ' Debug messages will be sent to: asynchronous::/data/GreatSQL/GCS_DEBUG_TRACE'
2022-11-06T23:02:33.341053+08:00 10 Plugin group_replication reported: ' There is no local IP address matching the one configured for the local node (39.108.220.160:33061).'
2022-11-06T23:02:33.341263+08:00 10 Plugin group_replication reported: 'Unable to initialize the group communication engine'
2022-11-06T23:02:33.341281+08:00 10 Plugin group_replication reported: 'Error on group communication engine initialization'
2022-11-06T23:02:33.341290+08:00 10 Plugin group_replication reported: 'Requesting to leave the group despite of not being a member'
2022-11-06T23:02:33.341373+08:00 11 Plugin group_replication reported: 'Setting super_read_only=OFF.'
2022-11-06T23:12:34.441628+08:00 10 The wait_timeout period was exceeded, the idle time since last command was too long.
2022-11-06T23:12:34.441705+08:00 10 Aborted connection 10 to db: 'unconnected' user: 'root' host: 'localhost' (The client was disconnected by the server because of inactivity.).
mbind: Operation not permitted
2022-11-06T23:26:38.590603+08:00 12 Plugin group_replication reported: 'Plugin 'group_replication' is starting.'
2022-11-06T23:26:38.590663+08:00 12 Plugin group_replication reported: 'Current debug options are: 'GCS_DEBUG_NONE'.'
2022-11-06T23:26:38.592220+08:00 13 Plugin group_replication reported: 'Setting super_read_only=ON.'
2022-11-06T23:26:38.592315+08:00 12 Plugin group_replication reported: 'Group communication SSL configuration: group_replication_ssl_mode: "DISABLED"'
2022-11-06T23:26:38.593006+08:00 12 Plugin group_replication reported: ' Debug messages will be sent to: asynchronous::/data/GreatSQL/GCS_DEBUG_TRACE'
2022-11-06T23:26:38.593124+08:00 12 Plugin group_replication reported: ' There is no local IP address matching the one configured for the local node (39.108.220.160:33061).'
2022-11-06T23:26:38.593465+08:00 12 Plugin group_replication reported: 'Unable to initialize the group communication engine'
2022-11-06T23:26:38.593486+08:00 12 Plugin group_replication reported: 'Error on group communication engine initialization'
2022-11-06T23:26:38.593496+08:00 12 Plugin group_replication reported: 'Requesting to leave the group despite of not being a member'
2022-11-06T23:26:38.593571+08:00 13 Plugin group_replication reported: 'Setting super_read_only=OFF.'
建议用docker-compose尝试下
参考文档 https://gitee.com/GreatSQL/GreatSQL-Docker#%E5%A6%82%E4%BD%95%E9%80%9A%E8%BF%87docker-compose%E6%9E%84%E5%BB%BAmgr%E9%9B%86%E7%BE%A4 yejr 发表于 2022-11-7 15:02
建议用docker-compose尝试下
参考文档 https://gitee.com/GreatSQL/GreatSQL-Docker#%E5%A6%82%E4%BD%95%E9 ...
另外，初始化docker环境时，指定的IP地址，要和docker容器获取到的IP一致才行。
从你传入的参数来看，应该是传入的LOCAL和SEEDS地址和docker容器获取到的不一致，所以无法启动MGR服务。 yejr 发表于 2022-11-7 15:02
建议用docker-compose尝试下
参考文档 https://gitee.com/GreatSQL/GreatSQL-Docker#%E5%A6%82%E4%BD%95%E9 ...
docker-compose,不在同一个服务器能一次性初始化?
紫清风玲 发表于 2022-11-7 15:12
docker-compose,不在同一个服务器能一次性初始化?
不能。
跨服务器的话，可以考虑上K8S。
页:
[1]