GreatSQL社区

搜索

[已解决] docker部署到云服务器上启动失败

551 4 2022-11-6 19:05
本帖最后由 紫清风玲 于 2022-11-6 23:30 编辑

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 [Note] [MY-010096] [Server] Ignoring --secure-file-priv value as server is running with --initialize(-insecure).
2022-11-06T23:01:19.633982+08:00 0 [Note] [MY-010949] [Server] Basedir set to /usr/.
2022-11-06T23:01:19.633996+08:00 0 [System] [MY-013169] [Server] /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 [Note] [MY-010458] [Server] --initialize specified on an existing data directory.
2022-11-06T23:01:19.647578+08:00 0 [Note] [MY-012366] [InnoDB] Using Linux native AIO
2022-11-06T23:01:19.647928+08:00 0 [Note] [MY-010747] [Server] Plugin 'FEDERATED' is disabled.
2022-11-06T23:01:19.649717+08:00 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-11-06T23:01:19.649803+08:00 1 [Note] [MY-013546] [InnoDB] Atomic write enabled
2022-11-06T23:01:19.649859+08:00 1 [Note] [MY-012274] [InnoDB] 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 [Note] [MY-012932] [InnoDB] PUNCH HOLE support available
2022-11-06T23:01:19.649950+08:00 1 [Note] [MY-012944] [InnoDB] Uses event mutexes
2022-11-06T23:01:19.649985+08:00 1 [Note] [MY-012945] [InnoDB] GCC builtin __atomic_thread_fence() is used for memory barrier
2022-11-06T23:01:19.650021+08:00 1 [Note] [MY-012948] [InnoDB] Compressed tables use zlib 1.2.11
2022-11-06T23:01:19.653654+08:00 1 [Note] [MY-013251] [InnoDB] Number of pools: 1
2022-11-06T23:01:19.653856+08:00 1 [Note] [MY-012951] [InnoDB] Using CPU crc32 instructions
2022-11-06T23:01:19.654390+08:00 1 [Note] [MY-012203] [InnoDB] Directories to scan './'
2022-11-06T23:01:19.654505+08:00 1 [Note] [MY-012204] [InnoDB] Scanning './'
2022-11-06T23:01:19.654618+08:00 1 [Note] [MY-012208] [InnoDB] Completed space ID check of 0 files.
2022-11-06T23:01:19.656213+08:00 1 [Note] [MY-012955] [InnoDB] Initializing buffer pool, total size = 1.000000G, instances = 8, chunk size =128.000000M
2022-11-06T23:01:19.749251+08:00 1 [Note] [MY-012957] [InnoDB] Completed initialization of buffer pool
2022-11-06T23:01:19.755661+08:00 0 [Note] [MY-011952] [InnoDB] 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 [Note] [MY-012265] [InnoDB] Setting file './ibdata1' size to 12 MB. Physically writing the file full; Please wait ...
2022-11-06T23:01:19.834273+08:00 1 [Note] [MY-012266] [InnoDB] File './ibdata1' size is now 12 MB.
2022-11-06T23:01:19.834982+08:00 1 [Note] [MY-013575] [InnoDB] Creating log file ./ib_logfile101
2022-11-06T23:01:19.836193+08:00 1 [Note] [MY-013575] [InnoDB] Creating log file ./ib_logfile1
2022-11-06T23:01:19.869667+08:00 1 [Note] [MY-013566] [InnoDB] Double write buffer files: 2
2022-11-06T23:01:19.869772+08:00 1 [Note] [MY-013565] [InnoDB] Double write buffer pages per instance: 4
2022-11-06T23:01:19.869918+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_0.dblwr' for doublewrite
2022-11-06T23:01:19.873296+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_1.dblwr' for doublewrite
2022-11-06T23:01:19.910755+08:00 1 [Note] [MY-013083] [InnoDB] Log background threads are being started...
2022-11-06T23:01:19.936735+08:00 1 [Note] [MY-012896] [InnoDB] Creating UNDO Tablespace ./undo_001
2022-11-06T23:01:19.936865+08:00 1 [Note] [MY-012897] [InnoDB] Setting file ./undo_001 size to 16 MB
2022-11-06T23:01:19.936944+08:00 1 [Note] [MY-012898] [InnoDB] Physically writing the file full
2022-11-06T23:01:20.056872+08:00 1 [Note] [MY-012896] [InnoDB] Creating UNDO Tablespace ./undo_002
2022-11-06T23:01:20.056996+08:00 1 [Note] [MY-012897] [InnoDB] Setting file ./undo_002 size to 16 MB
2022-11-06T23:01:20.057080+08:00 1 [Note] [MY-012898] [InnoDB] Physically writing the file full
2022-11-06T23:01:20.173378+08:00 1 [Note] [MY-012915] [InnoDB] Created 2 undo tablespaces.
2022-11-06T23:01:20.173920+08:00 1 [Note] [MY-011980] [InnoDB] GTID recovery trx_no: 0
2022-11-06T23:01:20.186000+08:00 1 [Note] [MY-013084] [InnoDB] Log background threads are being closed...
2022-11-06T23:01:20.191732+08:00 1 [Note] [MY-012892] [InnoDB] Renaming log file ./ib_logfile101 to ./ib_logfile0
2022-11-06T23:01:20.191954+08:00 1 [Note] [MY-012893] [InnoDB] New log files created, LSN=8204
2022-11-06T23:01:20.192062+08:00 1 [Note] [MY-013083] [InnoDB] Log background threads are being started...
2022-11-06T23:01:20.192352+08:00 1 [Note] [MY-011920] [InnoDB] Legacy doublewrite buffer not found: creating new
2022-11-06T23:01:20.195634+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=24] type 20 to 13 when flushing.
2022-11-06T23:01:20.196140+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=23] type 20 to 13 when flushing.
2022-11-06T23:01:20.196275+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=22] type 20 to 13 when flushing.
2022-11-06T23:01:20.230972+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=21] type 20 to 13 when flushing.
2022-11-06T23:01:20.231141+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=20] type 20 to 13 when flushing.
2022-11-06T23:01:20.231294+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=19] type 20 to 13 when flushing.
2022-11-06T23:01:20.231491+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=18] type 20 to 13 when flushing.
2022-11-06T23:01:20.232411+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=17] type 20 to 13 when flushing.
2022-11-06T23:01:20.232574+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=16] type 20 to 13 when flushing.
2022-11-06T23:01:20.232700+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=15] type 20 to 13 when flushing.
2022-11-06T23:01:20.232833+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=14] type 20 to 13 when flushing.
2022-11-06T23:01:20.233749+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=13] type 20 to 13 when flushing.
2022-11-06T23:01:20.234047+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=12] type 20 to 13 when flushing.
2022-11-06T23:01:20.234265+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=11] type 20 to 13 when flushing.
2022-11-06T23:01:20.234452+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=10] type 20 to 13 when flushing.
2022-11-06T23:01:20.235370+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=9] type 20 to 13 when flushing.
2022-11-06T23:01:20.235531+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=40] type 20 to 13 when flushing.
2022-11-06T23:01:20.235683+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=39] type 20 to 13 when flushing.
2022-11-06T23:01:20.236762+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=38] type 20 to 13 when flushing.
2022-11-06T23:01:20.236933+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=37] type 20 to 13 when flushing.
2022-11-06T23:01:20.237084+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=36] type 20 to 13 when flushing.
2022-11-06T23:01:20.237241+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=35] type 20 to 13 when flushing.
2022-11-06T23:01:20.238522+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=34] type 20 to 13 when flushing.
2022-11-06T23:01:20.238686+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=33] type 20 to 13 when flushing.
2022-11-06T23:01:20.238857+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=32] type 20 to 13 when flushing.
2022-11-06T23:01:20.239025+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=31] type 20 to 13 when flushing.
2022-11-06T23:01:20.240447+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=30] type 20 to 13 when flushing.
2022-11-06T23:01:20.240755+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=29] type 20 to 13 when flushing.
2022-11-06T23:01:20.241082+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=28] type 20 to 13 when flushing.
2022-11-06T23:01:20.241578+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=27] type 20 to 13 when flushing.
2022-11-06T23:01:20.242537+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=26] type 20 to 13 when flushing.
2022-11-06T23:01:20.242873+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=25] type 20 to 13 when flushing.
2022-11-06T23:01:20.243986+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=79] type 20 to 13 when flushing.
2022-11-06T23:01:20.244183+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=78] type 20 to 13 when flushing.
2022-11-06T23:01:20.244372+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=77] type 20 to 13 when flushing.
2022-11-06T23:01:20.244550+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=76] type 20 to 13 when flushing.
2022-11-06T23:01:20.244737+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=75] type 20 to 13 when flushing.
2022-11-06T23:01:20.245663+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=74] type 20 to 13 when flushing.
2022-11-06T23:01:20.246141+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=73] type 20 to 13 when flushing.
2022-11-06T23:01:20.246643+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=72] type 20 to 13 when flushing.
2022-11-06T23:01:20.246922+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=71] type 20 to 13 when flushing.
2022-11-06T23:01:20.247833+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=70] type 20 to 13 when flushing.
2022-11-06T23:01:20.248032+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=69] type 20 to 13 when flushing.
2022-11-06T23:01:20.248230+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=68] type 20 to 13 when flushing.
2022-11-06T23:01:20.248453+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=67] type 20 to 13 when flushing.
2022-11-06T23:01:20.249811+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=66] type 20 to 13 when flushing.
2022-11-06T23:01:20.250112+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=65] type 20 to 13 when flushing.
2022-11-06T23:01:20.250826+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=64] type 20 to 13 when flushing.
2022-11-06T23:01:20.251083+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=95] type 20 to 13 when flushing.
2022-11-06T23:01:20.252197+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=94] type 20 to 13 when flushing.
2022-11-06T23:01:20.252433+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=93] type 20 to 13 when flushing.
2022-11-06T23:01:20.252705+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=92] type 20 to 13 when flushing.
2022-11-06T23:01:20.253170+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=91] type 20 to 13 when flushing.
2022-11-06T23:01:20.254117+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=90] type 20 to 13 when flushing.
2022-11-06T23:01:20.254404+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=89] type 20 to 13 when flushing.
2022-11-06T23:01:20.255121+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=88] type 20 to 13 when flushing.
2022-11-06T23:01:20.255438+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=87] type 20 to 13 when flushing.
2022-11-06T23:01:20.256425+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=86] type 20 to 13 when flushing.
2022-11-06T23:01:20.256678+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=85] type 20 to 13 when flushing.
2022-11-06T23:01:20.256948+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=84] type 20 to 13 when flushing.
2022-11-06T23:01:20.257447+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=83] type 20 to 13 when flushing.
2022-11-06T23:01:20.258412+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=82] type 20 to 13 when flushing.
2022-11-06T23:01:20.258670+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=81] type 20 to 13 when flushing.
2022-11-06T23:01:20.258979+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=80] type 20 to 13 when flushing.
2022-11-06T23:01:20.259259+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=111] type 20 to 13 when flushing.
2022-11-06T23:01:20.260241+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=110] type 20 to 13 when flushing.
2022-11-06T23:01:20.260519+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=109] type 20 to 13 when flushing.
2022-11-06T23:01:20.261250+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=108] type 20 to 13 when flushing.
2022-11-06T23:01:20.261868+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=107] type 20 to 13 when flushing.
2022-11-06T23:01:20.262831+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=106] type 20 to 13 when flushing.
2022-11-06T23:01:20.263110+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=105] type 20 to 13 when flushing.
2022-11-06T23:01:20.264532+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=104] type 20 to 13 when flushing.
2022-11-06T23:01:20.264846+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=103] type 20 to 13 when flushing.
2022-11-06T23:01:20.265893+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=102] type 20 to 13 when flushing.
2022-11-06T23:01:20.266189+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=101] type 20 to 13 when flushing.
2022-11-06T23:01:20.266855+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=100] type 20 to 13 when flushing.
2022-11-06T23:01:20.267142+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=99] type 20 to 13 when flushing.
2022-11-06T23:01:20.268221+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=98] type 20 to 13 when flushing.
2022-11-06T23:01:20.268530+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=97] type 20 to 13 when flushing.
2022-11-06T23:01:20.268891+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=96] type 20 to 13 when flushing.
2022-11-06T23:01:20.269491+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=127] type 20 to 13 when flushing.
2022-11-06T23:01:20.270528+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=126] type 20 to 13 when flushing.
2022-11-06T23:01:20.270834+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=125] type 20 to 13 when flushing.
2022-11-06T23:01:20.271484+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=124] type 20 to 13 when flushing.
2022-11-06T23:01:20.271801+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=123] type 20 to 13 when flushing.
2022-11-06T23:01:20.272819+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=122] type 20 to 13 when flushing.
2022-11-06T23:01:20.273110+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=121] type 20 to 13 when flushing.
2022-11-06T23:01:20.273832+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=120] type 20 to 13 when flushing.
2022-11-06T23:01:20.274163+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=119] type 20 to 13 when flushing.
2022-11-06T23:01:20.275217+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=118] type 20 to 13 when flushing.
2022-11-06T23:01:20.275546+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=117] type 20 to 13 when flushing.
2022-11-06T23:01:20.276186+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=116] type 20 to 13 when flushing.
2022-11-06T23:01:20.276528+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=115] type 20 to 13 when flushing.
2022-11-06T23:01:20.277590+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=114] type 20 to 13 when flushing.
2022-11-06T23:01:20.277944+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=113] type 20 to 13 when flushing.
2022-11-06T23:01:20.278275+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=112] type 20 to 13 when flushing.
2022-11-06T23:01:20.281015+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=143] type 20 to 13 when flushing.
2022-11-06T23:01:20.281357+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=142] type 20 to 13 when flushing.
2022-11-06T23:01:20.281689+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=141] type 20 to 13 when flushing.
2022-11-06T23:01:20.282024+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=140] type 20 to 13 when flushing.
2022-11-06T23:01:20.282332+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=139] type 20 to 13 when flushing.
2022-11-06T23:01:20.283517+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=138] type 20 to 13 when flushing.
2022-11-06T23:01:20.283903+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=137] type 20 to 13 when flushing.
2022-11-06T23:01:20.284234+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=136] type 20 to 13 when flushing.
2022-11-06T23:01:20.284568+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=135] type 20 to 13 when flushing.
2022-11-06T23:01:20.285938+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=134] type 20 to 13 when flushing.
2022-11-06T23:01:20.286324+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=133] type 20 to 13 when flushing.
2022-11-06T23:01:20.286870+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=132] type 20 to 13 when flushing.
2022-11-06T23:01:20.287280+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=131] type 20 to 13 when flushing.
2022-11-06T23:01:20.288891+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=130] type 20 to 13 when flushing.
2022-11-06T23:01:20.289383+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=129] type 20 to 13 when flushing.
2022-11-06T23:01:20.289885+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=128] type 20 to 13 when flushing.
2022-11-06T23:01:20.290292+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=159] type 20 to 13 when flushing.
2022-11-06T23:01:20.291425+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=158] type 20 to 13 when flushing.
2022-11-06T23:01:20.291845+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=157] type 20 to 13 when flushing.
2022-11-06T23:01:20.292416+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=156] type 20 to 13 when flushing.
2022-11-06T23:01:20.293105+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=155] type 20 to 13 when flushing.
2022-11-06T23:01:20.294311+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=154] type 20 to 13 when flushing.
2022-11-06T23:01:20.294830+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=153] type 20 to 13 when flushing.
2022-11-06T23:01:20.295315+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=152] type 20 to 13 when flushing.
2022-11-06T23:01:20.295838+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=151] type 20 to 13 when flushing.
2022-11-06T23:01:20.296933+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=150] type 20 to 13 when flushing.
2022-11-06T23:01:20.297380+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=149] type 20 to 13 when flushing.
2022-11-06T23:01:20.297980+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=148] type 20 to 13 when flushing.
2022-11-06T23:01:20.298574+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=147] type 20 to 13 when flushing.
2022-11-06T23:01:20.299837+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=146] type 20 to 13 when flushing.
2022-11-06T23:01:20.300875+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=145] type 20 to 13 when flushing.
2022-11-06T23:01:20.301424+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=144] type 20 to 13 when flushing.
2022-11-06T23:01:20.302078+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=175] type 20 to 13 when flushing.
2022-11-06T23:01:20.303280+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=174] type 20 to 13 when flushing.
2022-11-06T23:01:20.303804+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=173] type 20 to 13 when flushing.
2022-11-06T23:01:20.304696+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=172] type 20 to 13 when flushing.
2022-11-06T23:01:20.305131+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=171] type 20 to 13 when flushing.
2022-11-06T23:01:20.306267+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=170] type 20 to 13 when flushing.
2022-11-06T23:01:20.306691+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=169] type 20 to 13 when flushing.
2022-11-06T23:01:20.307091+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=168] type 20 to 13 when flushing.
2022-11-06T23:01:20.307469+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=167] type 20 to 13 when flushing.
2022-11-06T23:01:20.308718+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=166] type 20 to 13 when flushing.
2022-11-06T23:01:20.309282+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=165] type 20 to 13 when flushing.
2022-11-06T23:01:20.309778+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=164] type 20 to 13 when flushing.
2022-11-06T23:01:20.310262+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=163] type 20 to 13 when flushing.
2022-11-06T23:01:20.311463+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=162] type 20 to 13 when flushing.
2022-11-06T23:01:20.311939+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=161] type 20 to 13 when flushing.
2022-11-06T23:01:20.312383+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=160] type 20 to 13 when flushing.
2022-11-06T23:01:20.312802+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=191] type 20 to 13 when flushing.
2022-11-06T23:01:20.313984+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=190] type 20 to 13 when flushing.
2022-11-06T23:01:20.314473+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=189] type 20 to 13 when flushing.
2022-11-06T23:01:20.314885+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=188] type 20 to 13 when flushing.
2022-11-06T23:01:20.315280+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=187] type 20 to 13 when flushing.
2022-11-06T23:01:20.332636+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=186] type 20 to 13 when flushing.
2022-11-06T23:01:20.333279+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=185] type 20 to 13 when flushing.
2022-11-06T23:01:20.333754+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=184] type 20 to 13 when flushing.
2022-11-06T23:01:20.334249+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=183] type 20 to 13 when flushing.
2022-11-06T23:01:20.336878+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=182] type 20 to 13 when flushing.
2022-11-06T23:01:20.337414+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=181] type 20 to 13 when flushing.
2022-11-06T23:01:20.337933+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=180] type 20 to 13 when flushing.
2022-11-06T23:01:20.338389+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=179] type 20 to 13 when flushing.
2022-11-06T23:01:20.339699+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=178] type 20 to 13 when flushing.
2022-11-06T23:01:20.340178+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=177] type 20 to 13 when flushing.
2022-11-06T23:01:20.340625+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=176] type 20 to 13 when flushing.
2022-11-06T23:01:20.375840+08:00 1 [Note] [MY-011924] [InnoDB] Legacy atomic write buffer created
2022-11-06T23:01:20.376398+08:00 1 [Note] [MY-012923] [InnoDB] Creating shared tablespace for temporary tables
2022-11-06T23:01:20.376968+08:00 1 [Note] [MY-012265] [InnoDB] Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-11-06T23:01:20.434485+08:00 1 [Note] [MY-012266] [InnoDB] File './ibtmp1' size is now 12 MB.
2022-11-06T23:01:20.456329+08:00 1 [Note] [MY-013018] [InnoDB] 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 [Note] [MY-013018] [InnoDB] 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 [Note] [MY-013018] [InnoDB] 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 [Note] [MY-012976] [InnoDB] Percona XtraDB (http://www.percona.com) 8.0.25-15 started; log sequence number 2399381
2022-11-06T23:01:20.799275+08:00 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2022-11-06T23:01:20.802314+08:00 1 [Note] [MY-011088] [Server] Data dictionary initializing version '80023'.
2022-11-06T23:01:21.167384+08:00 1 [Note] [MY-010007] [Server] Installed data dictionary with version 80023
2022-11-06T23:01:21.326396+08:00 2 [Note] [MY-011019] [Server] Created system views with I_S version 80023.
2022-11-06T23:01:21.327302+08:00 0 [Warning] [MY-013501] [Server] Ignoring --plugin-load[_add] list as the server is running with --initialize(-insecure).
2022-11-06T23:01:21.737265+08:00 0 [Note] [MY-010938] [Server] Generating a new UUID: e01df48a-5de3-11ed-9cbc-0242ac110005.
2022-11-06T23:01:21.759756+08:00 0 [Note] [MY-012487] [InnoDB] DDL log recovery : begin
2022-11-06T23:01:21.760398+08:00 0 [Note] [MY-012488] [InnoDB] DDL log recovery : end
2022-11-06T23:01:21.918128+08:00 0 [Note] [MY-010305] [Server] Auto generated SSL certificates are placed in data directory.
2022-11-06T23:01:21.970939+08:00 0 [Note] [MY-010309] [Server] 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 [Note] [MY-010308] [Server] 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 [Warning] [MY-000067] [Server] unknown variable 'loose-group_replication_group_name=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaa1'.
2022-11-06T23:01:21.973675+08:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose-group_replication_view_change_uuid=AUTOMATIC'.
2022-11-06T23:01:21.974218+08:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose-group_replication_local_address=39.108.220.160:33061'.
2022-11-06T23:01:21.974708+08:00 0 [Warning] [MY-000067] [Server] 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 [Warning] [MY-000067] [Server] unknown variable 'loose-group_replication_start_on_boot=START_MGR'.
2022-11-06T23:01:21.976360+08:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose-group_replication_bootstrap_group=BOOTSTRAP_MGR'.
2022-11-06T23:01:21.977174+08:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose-group_replication_exit_state_action=READ_ONLY'.
2022-11-06T23:01:21.977734+08:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose-group_replication_flow_control_mode=DISABLED'.
2022-11-06T23:01:21.978394+08:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose-group_replication_single_primary_mode=ON'.
2022-11-06T23:01:21.979028+08:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose-group_replication_communication_max_message_size=10M'.
2022-11-06T23:01:21.979612+08:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose-group_replication_arbitrator=0'.
2022-11-06T23:01:21.980203+08:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose-group_replication_single_primary_fast_mode=0'.
2022-11-06T23:01:21.980837+08:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose-group_replication_request_time_threshold=50'.
2022-11-06T23:01:21.983020+08:00 6 [Note] [MY-011061] [Server] Creating the system database.
2022-11-06T23:01:21.983053+08:00 6 [Warning] [MY-010453] [Server] 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 [Note] [MY-011061] [Server] Creating the system tables.
2022-11-06T23:01:22.378291+08:00 6 [Note] [MY-011061] [Server] Filling in the system tables, part 1.
2022-11-06T23:01:22.434188+08:00 6 [Note] [MY-011061] [Server] Filling in the system tables, part 2.
2022-11-06T23:01:22.776816+08:00 6 [Note] [MY-011061] [Server] Filling in the mysql.help table.
2022-11-06T23:01:22.906834+08:00 6 [Note] [MY-011061] [Server] Creating the system users for internal usage.
2022-11-06T23:01:22.933165+08:00 6 [Note] [MY-011061] [Server] Creating the sys schema.
2022-11-06T23:01:23.492924+08:00 6 [Note] [MY-010456] [Server] Bootstrapping complete
2022-11-06T23:01:23.538274+08:00 0 [Note] [MY-010067] [Server] Giving 0 client threads a chance to die gracefully
2022-11-06T23:01:23.538316+08:00 0 [Note] [MY-010117] [Server] Shutting down slave threads
2022-11-06T23:01:23.538331+08:00 0 [Note] [MY-010118] [Server] Forcefully disconnecting 0 remaining clients
2022-11-06T23:01:23.539625+08:00 0 [Note] [MY-012330] [InnoDB] FTS optimize thread exiting.
2022-11-06T23:01:24.048874+08:00 0 [Note] [MY-013072] [InnoDB] Starting shutdown...
2022-11-06T23:01:24.051518+08:00 0 [Note] [MY-011944] [InnoDB] Dumping buffer pool(s) to /data/GreatSQL/ib_buffer_pool
2022-11-06T23:01:24.051819+08:00 0 [Note] [MY-011944] [InnoDB] Buffer pool(s) dump completed at 221106 23:01:24
2022-11-06T23:01:24.855162+08:00 0 [Note] [MY-013084] [InnoDB] Log background threads are being closed...
2022-11-06T23:01:25.390669+08:00 0 [Note] [MY-012980] [InnoDB] Shutdown completed; log sequence number 17834805
2022-11-06T23:01:25.390772+08:00 0 [Note] [MY-012255] [InnoDB] Removed temporary tablespace data file: "ibtmp1"
2022-11-06T23:01:25.769524+08:00 0 [Note] [MY-010949] [Server] Basedir set to /usr/.
2022-11-06T23:01:25.769545+08:00 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.25-16) starting as process 94
2022-11-06T23:01:25.779657+08:00 0 [Note] [MY-012366] [InnoDB] Using Linux native AIO
2022-11-06T23:01:25.779980+08:00 0 [Note] [MY-010747] [Server] Plugin 'FEDERATED' is disabled.
2022-11-06T23:01:25.781656+08:00 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-11-06T23:01:25.781724+08:00 1 [Note] [MY-013546] [InnoDB] Atomic write enabled
2022-11-06T23:01:25.781795+08:00 1 [Note] [MY-012932] [InnoDB] PUNCH HOLE support available
2022-11-06T23:01:25.781839+08:00 1 [Note] [MY-012944] [InnoDB] Uses event mutexes
2022-11-06T23:01:25.781897+08:00 1 [Note] [MY-012945] [InnoDB] GCC builtin __atomic_thread_fence() is used for memory barrier
2022-11-06T23:01:25.781933+08:00 1 [Note] [MY-012948] [InnoDB] Compressed tables use zlib 1.2.11
2022-11-06T23:01:25.785715+08:00 1 [Note] [MY-013251] [InnoDB] Number of pools: 1
2022-11-06T23:01:25.785931+08:00 1 [Note] [MY-012951] [InnoDB] Using CPU crc32 instructions
2022-11-06T23:01:25.786488+08:00 1 [Note] [MY-012203] [InnoDB] Directories to scan './'
2022-11-06T23:01:25.786599+08:00 1 [Note] [MY-012204] [InnoDB] Scanning './'
2022-11-06T23:01:25.790022+08:00 1 [Note] [MY-012208] [InnoDB] Completed space ID check of 4 files.
2022-11-06T23:01:25.791534+08:00 1 [Note] [MY-012955] [InnoDB] Initializing buffer pool, total size = 1.000000G, instances = 8, chunk size =128.000000M
2022-11-06T23:01:25.907671+08:00 1 [Note] [MY-012957] [InnoDB] Completed initialization of buffer pool
2022-11-06T23:01:25.928228+08:00 0 [Note] [MY-011952] [InnoDB] 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 [Note] [MY-013532] [InnoDB] Using './#ib_16384_0.dblwr' for doublewrite
2022-11-06T23:01:25.940851+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_1.dblwr' for doublewrite
2022-11-06T23:01:25.994006+08:00 1 [Note] [MY-013566] [InnoDB] Double write buffer files: 2
2022-11-06T23:01:25.994110+08:00 1 [Note] [MY-013565] [InnoDB] Double write buffer pages per instance: 4
2022-11-06T23:01:25.994204+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_0.dblwr' for doublewrite
2022-11-06T23:01:25.994311+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_1.dblwr' for doublewrite
2022-11-06T23:01:25.998131+08:00 1 [Note] [MY-013086] [InnoDB] 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 [Note] [MY-013083] [InnoDB] Log background threads are being started...
2022-11-06T23:01:26.010917+08:00 1 [Note] [MY-012532] [InnoDB] Applying a batch of 0 redo log records ...
2022-11-06T23:01:26.011035+08:00 1 [Note] [MY-012535] [InnoDB] Apply batch completed!
2022-11-06T23:01:26.011657+08:00 1 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_001'.
2022-11-06T23:01:26.012706+08:00 1 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_002'.
2022-11-06T23:01:26.014024+08:00 1 [Note] [MY-012910] [InnoDB] Opened 2 existing undo tablespaces.
2022-11-06T23:01:26.014143+08:00 1 [Note] [MY-011980] [InnoDB] GTID recovery trx_no: 1269
2022-11-06T23:01:26.238117+08:00 1 [Note] [MY-012923] [InnoDB] Creating shared tablespace for temporary tables
2022-11-06T23:01:26.238323+08:00 1 [Note] [MY-012265] [InnoDB] Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-11-06T23:01:26.338745+08:00 1 [Note] [MY-012266] [InnoDB] File './ibtmp1' size is now 12 MB.
2022-11-06T23:01:26.339048+08:00 1 [Note] [MY-013627] [InnoDB] Scanning temp tablespace dir:'./#innodb_temp/'
2022-11-06T23:01:26.356995+08:00 1 [Note] [MY-013018] [InnoDB] 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 [Note] [MY-012976] [InnoDB] Percona XtraDB (http://www.percona.com) 8.0.25-15 started; log sequence number 17834805
2022-11-06T23:01:26.365145+08:00 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2022-11-06T23:01:26.376502+08:00 1 [Note] [MY-011089] [Server] Data dictionary restarting version '80023'.
2022-11-06T23:01:26.479058+08:00 1 [Note] [MY-012357] [InnoDB] Reading DD tablespace files
2022-11-06T23:01:26.479987+08:00 1 [Note] [MY-012356] [InnoDB] Scanned 6 tablespaces. Validated 6.
2022-11-06T23:01:26.510781+08:00 1 [Note] [MY-010006] [Server] Using data dictionary with version '80023'.
2022-11-06T23:01:26.516938+08:00 0 [Warning] [MY-000076] [Server] 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 [Warning] [MY-000076] [Server] option 'group-replication-bootstrap-group': boolean value 'BOOTSTRAP_MGR' was not recognized. Set to OFF.
2022-11-06T23:01:26.525404+08:00 0 [Note] [MY-011323] [Server] Plugin mysqlx reported: 'X Plugin ready for connections. socket: '/var/lib/mysql/mysqlx.sock''
2022-11-06T23:01:26.525583+08:00 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: /var/lib/mysql/mysqlx.sock
2022-11-06T23:01:26.638342+08:00 0 [Note] [MY-012487] [InnoDB] DDL log recovery : begin
2022-11-06T23:01:26.638970+08:00 0 [Note] [MY-012488] [InnoDB] DDL log recovery : end
2022-11-06T23:01:26.641003+08:00 0 [Note] [MY-011946] [InnoDB] Loading buffer pool(s) from /data/GreatSQL/ib_buffer_pool
2022-11-06T23:01:26.682061+08:00 0 [Note] [MY-010182] [Server] 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 [Note] [MY-010304] [Server] Skipping generation of SSL certificates as certificate files are present in data directory.
2022-11-06T23:01:26.683548+08:00 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2022-11-06T23:01:26.683780+08:00 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2022-11-06T23:01:26.684000+08:00 0 [Note] [MY-010308] [Server] 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 [Note] [MY-010308] [Server] 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 [Warning] [MY-000067] [Server] unknown variable 'loose-group_replication_view_change_uuid=AUTOMATIC'.
2022-11-06T23:01:26.763107+08:00 0 [Note] [MY-011025] [Repl] Failed to start slave threads for channel ''.
2022-11-06T23:01:26.766423+08:00 5 [Note] [MY-010051] [Server] Event Scheduler: scheduler thread started with id 5
2022-11-06T23:01:26.767221+08:00 0 [Note] [MY-011240] [Server] Plugin mysqlx reported: 'Using SSL configuration from MySQL Server'
2022-11-06T23:01:26.767921+08:00 0 [Note] [MY-011243] [Server] Plugin mysqlx reported: 'Using OpenSSL for TLS connections'
2022-11-06T23:01:26.768132+08:00 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.25-16'  socket: '/data/GreatSQL/mysql.sock'  port: 0  GreatSQL (GPL), Release 16, Revision 8bb0e5af297.
2022-11-06T23:01:26.773970+08:00 0 [Note] [MY-011946] [InnoDB] Buffer pool(s) load completed at 221106 23:01:26
2022-11-06T23:01:27.572896+08:00 10 [Warning] [MY-010604] [Repl] 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 [System] [MY-010597] [Repl] '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 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.0.25-16).
2022-11-06T23:01:27.600171+08:00 0 [Note] [MY-010067] [Server] Giving 1 client threads a chance to die gracefully
2022-11-06T23:01:27.600200+08:00 0 [Note] [MY-010117] [Server] Shutting down slave threads
2022-11-06T23:01:27.600214+08:00 0 [Note] [MY-010054] [Server] Event Scheduler: Killing the scheduler thread, thread id 5
2022-11-06T23:01:27.600228+08:00 0 [Note] [MY-010050] [Server] Event Scheduler: Waiting for the scheduler thread to reply
2022-11-06T23:01:27.600310+08:00 0 [Note] [MY-010048] [Server] Event Scheduler: Stopped
2022-11-06T23:01:27.600322+08:00 0 [Note] [MY-010118] [Server] Forcefully disconnecting 0 remaining clients
2022-11-06T23:01:27.600342+08:00 0 [Note] [MY-010043] [Server] Event Scheduler: Purging the queue. 0 events
2022-11-06T23:01:27.603095+08:00 0 [Note] [MY-012330] [InnoDB] FTS optimize thread exiting.
2022-11-06T23:01:28.483231+08:00 0 [Note] [MY-010120] [Server] Binlog end
2022-11-06T23:01:28.485813+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'group_replication'
2022-11-06T23:01:28.485877+08:00 0 [Note] [MY-011665] [Repl] Plugin group_replication reported: 'All Group Replication server observers have been successfully unregistered'
2022-11-06T23:01:28.485919+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'clone'
2022-11-06T23:01:28.485945+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'mysqlx'
2022-11-06T23:01:28.486439+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'mysqlx_cache_cleaner'
2022-11-06T23:01:28.486468+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'ngram'
2022-11-06T23:01:28.486486+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'BLACKHOLE'
2022-11-06T23:01:28.486499+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'ARCHIVE'
2022-11-06T23:01:28.486505+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'TempTable'
2022-11-06T23:01:28.486518+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'MRG_MYISAM'
2022-11-06T23:01:28.486525+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'MyISAM'
2022-11-06T23:01:28.486538+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CHANGED_PAGES'
2022-11-06T23:01:28.486545+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TABLESPACES_SCRUBBING'
2022-11-06T23:01:28.486550+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TABLESPACES_ENCRYPTION'
2022-11-06T23:01:28.486556+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_SESSION_TEMP_TABLESPACES'
2022-11-06T23:01:28.486561+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CACHED_INDEXES'
2022-11-06T23:01:28.486568+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_VIRTUAL'
2022-11-06T23:01:28.486576+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_COLUMNS'
2022-11-06T23:01:28.486584+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TABLESPACES'
2022-11-06T23:01:28.486592+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_INDEXES'
2022-11-06T23:01:28.486600+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TABLESTATS'
2022-11-06T23:01:28.486608+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TABLES'
2022-11-06T23:01:28.486613+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2022-11-06T23:01:28.486619+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2022-11-06T23:01:28.486624+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_CONFIG'
2022-11-06T23:01:28.486629+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2022-11-06T23:01:28.486635+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_DELETED'
2022-11-06T23:01:28.486640+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2022-11-06T23:01:28.486645+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_METRICS'
2022-11-06T23:01:28.486651+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2022-11-06T23:01:28.486656+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2022-11-06T23:01:28.486661+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2022-11-06T23:01:28.486666+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_BUFFER_PAGE'
2022-11-06T23:01:28.486671+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2022-11-06T23:01:28.486680+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2022-11-06T23:01:28.486686+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMPMEM_RESET'
2022-11-06T23:01:28.486691+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMPMEM'
2022-11-06T23:01:28.486696+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP_RESET'
2022-11-06T23:01:28.486701+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP'
2022-11-06T23:01:28.486706+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TRX'
2022-11-06T23:01:28.486712+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'InnoDB'
2022-11-06T23:01:28.486739+08:00 0 [Note] [MY-013072] [InnoDB] Starting shutdown...
2022-11-06T23:01:28.486859+08:00 0 [Note] [MY-011944] [InnoDB] Dumping buffer pool(s) to /data/GreatSQL/ib_buffer_pool
2022-11-06T23:01:28.487048+08:00 0 [Note] [MY-011944] [InnoDB] Buffer pool(s) dump completed at 221106 23:01:28
2022-11-06T23:01:28.593567+08:00 0 [Note] [MY-013084] [InnoDB] Log background threads are being closed...
2022-11-06T23:01:29.117621+08:00 0 [Note] [MY-012980] [InnoDB] Shutdown completed; log sequence number 18239086
2022-11-06T23:01:29.117722+08:00 0 [Note] [MY-012255] [InnoDB] Removed temporary tablespace data file: "ibtmp1"
2022-11-06T23:01:29.117749+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'MEMORY'
2022-11-06T23:01:29.117768+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'CSV'
2022-11-06T23:01:29.117777+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'PERFORMANCE_SCHEMA'
2022-11-06T23:01:29.117836+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'daemon_keyring_proxy_plugin'
2022-11-06T23:01:29.117860+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'sha2_cache_cleaner'
2022-11-06T23:01:29.117867+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'caching_sha2_password'
2022-11-06T23:01:29.117874+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'sha256_password'
2022-11-06T23:01:29.117879+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'mysql_native_password'
2022-11-06T23:01:29.119655+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'binlog'
2022-11-06T23:01:29.122029+08:00 0 [System] [MY-010910] [Server] /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 [Note] [MY-010949] [Server] Basedir set to /usr/.
2022-11-06T23:01:29.501718+08:00 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.25-16) starting as process 1
2022-11-06T23:01:29.512024+08:00 0 [Note] [MY-012366] [InnoDB] Using Linux native AIO
2022-11-06T23:01:29.512305+08:00 0 [Note] [MY-010747] [Server] Plugin 'FEDERATED' is disabled.
2022-11-06T23:01:29.513871+08:00 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-11-06T23:01:29.513937+08:00 1 [Note] [MY-013546] [InnoDB] Atomic write enabled
2022-11-06T23:01:29.513998+08:00 1 [Note] [MY-012932] [InnoDB] PUNCH HOLE support available
2022-11-06T23:01:29.514043+08:00 1 [Note] [MY-012944] [InnoDB] Uses event mutexes
2022-11-06T23:01:29.514077+08:00 1 [Note] [MY-012945] [InnoDB] GCC builtin __atomic_thread_fence() is used for memory barrier
2022-11-06T23:01:29.514112+08:00 1 [Note] [MY-012948] [InnoDB] Compressed tables use zlib 1.2.11
2022-11-06T23:01:29.517819+08:00 1 [Note] [MY-013251] [InnoDB] Number of pools: 1
2022-11-06T23:01:29.518009+08:00 1 [Note] [MY-012951] [InnoDB] Using CPU crc32 instructions
2022-11-06T23:01:29.518560+08:00 1 [Note] [MY-012203] [InnoDB] Directories to scan './'
2022-11-06T23:01:29.518670+08:00 1 [Note] [MY-012204] [InnoDB] Scanning './'
2022-11-06T23:01:29.520992+08:00 1 [Note] [MY-012208] [InnoDB] Completed space ID check of 4 files.
2022-11-06T23:01:29.522466+08:00 1 [Note] [MY-012955] [InnoDB] Initializing buffer pool, total size = 1.000000G, instances = 8, chunk size =128.000000M
2022-11-06T23:01:29.608469+08:00 1 [Note] [MY-012957] [InnoDB] Completed initialization of buffer pool
2022-11-06T23:01:29.635092+08:00 0 [Note] [MY-011952] [InnoDB] 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 [Note] [MY-013532] [InnoDB] Using './#ib_16384_0.dblwr' for doublewrite
2022-11-06T23:01:29.657315+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_1.dblwr' for doublewrite
2022-11-06T23:01:29.711695+08:00 1 [Note] [MY-013566] [InnoDB] Double write buffer files: 2
2022-11-06T23:01:29.711835+08:00 1 [Note] [MY-013565] [InnoDB] Double write buffer pages per instance: 4
2022-11-06T23:01:29.711935+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_0.dblwr' for doublewrite
2022-11-06T23:01:29.712031+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_1.dblwr' for doublewrite
2022-11-06T23:01:29.712978+08:00 1 [Note] [MY-013086] [InnoDB] 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 [Note] [MY-013083] [InnoDB] Log background threads are being started...
2022-11-06T23:01:29.719070+08:00 1 [Note] [MY-012532] [InnoDB] Applying a batch of 0 redo log records ...
2022-11-06T23:01:29.719222+08:00 1 [Note] [MY-012535] [InnoDB] Apply batch completed!
2022-11-06T23:01:29.719901+08:00 1 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_001'.
2022-11-06T23:01:29.721022+08:00 1 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_002'.
2022-11-06T23:01:29.722135+08:00 1 [Note] [MY-012910] [InnoDB] Opened 2 existing undo tablespaces.
2022-11-06T23:01:29.722261+08:00 1 [Note] [MY-011980] [InnoDB] GTID recovery trx_no: 1565
2022-11-06T23:01:29.950044+08:00 1 [Note] [MY-012923] [InnoDB] Creating shared tablespace for temporary tables
2022-11-06T23:01:29.950302+08:00 1 [Note] [MY-012265] [InnoDB] Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-11-06T23:01:30.049720+08:00 1 [Note] [MY-012266] [InnoDB] File './ibtmp1' size is now 12 MB.
2022-11-06T23:01:30.050044+08:00 1 [Note] [MY-013627] [InnoDB] Scanning temp tablespace dir:'./#innodb_temp/'
2022-11-06T23:01:30.072364+08:00 1 [Note] [MY-013018] [InnoDB] 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 [Note] [MY-012976] [InnoDB] Percona XtraDB (http://www.percona.com) 8.0.25-15 started; log sequence number 18239086
2022-11-06T23:01:30.074262+08:00 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2022-11-06T23:01:30.085315+08:00 1 [Note] [MY-011089] [Server] Data dictionary restarting version '80023'.
2022-11-06T23:01:30.194838+08:00 1 [Note] [MY-012357] [InnoDB] Reading DD tablespace files
2022-11-06T23:01:30.195687+08:00 1 [Note] [MY-012356] [InnoDB] Scanned 6 tablespaces. Validated 6.
2022-11-06T23:01:30.211681+08:00 1 [Note] [MY-010006] [Server] Using data dictionary with version '80023'.
2022-11-06T23:01:30.225241+08:00 0 [Note] [MY-011332] [Server] Plugin mysqlx reported: 'IPv6 is available'
2022-11-06T23:01:30.227247+08:00 0 [Note] [MY-011323] [Server] Plugin mysqlx reported: 'X Plugin ready for connections. bind-address: '::' port: 33060'
2022-11-06T23:01:30.227439+08:00 0 [Note] [MY-011323] [Server] Plugin mysqlx reported: 'X Plugin ready for connections. socket: '/var/lib/mysql/mysqlx.sock''
2022-11-06T23:01:30.227570+08:00 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/lib/mysql/mysqlx.sock
2022-11-06T23:01:30.236003+08:00 0 [System] [MY-013587] [Repl] Plugin group_replication reported: 'Plugin 'group_replication' is starting.'
2022-11-06T23:01:30.236217+08:00 0 [Note] [MY-011716] [Repl] Plugin group_replication reported: 'Current debug options are: 'GCS_DEBUG_NONE'.'
2022-11-06T23:01:30.279733+08:00 0 [Note] [MY-012487] [InnoDB] DDL log recovery : begin
2022-11-06T23:01:30.280409+08:00 0 [Note] [MY-012488] [InnoDB] DDL log recovery : end
2022-11-06T23:01:30.281102+08:00 0 [Note] [MY-011946] [InnoDB] Loading buffer pool(s) from /data/GreatSQL/ib_buffer_pool
2022-11-06T23:01:30.308282+08:00 0 [Note] [MY-010182] [Server] 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 [Note] [MY-010304] [Server] Skipping generation of SSL certificates as certificate files are present in data directory.
2022-11-06T23:01:30.309782+08:00 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2022-11-06T23:01:30.310112+08:00 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2022-11-06T23:01:30.310327+08:00 0 [Note] [MY-010308] [Server] 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 [Note] [MY-010308] [Server] 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 [Note] [MY-010252] [Server] Server hostname (bind-address): '*'; port: 3306
2022-11-06T23:01:30.311026+08:00 0 [Note] [MY-010253] [Server] IPv6 is available.
2022-11-06T23:01:30.311217+08:00 0 [Note] [MY-010264] [Server]   - '::' resolves to '::';
2022-11-06T23:01:30.311427+08:00 0 [Note] [MY-010251] [Server] Server socket created on IP: '::'.
2022-11-06T23:01:30.315081+08:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose-group_replication_view_change_uuid=AUTOMATIC'.
2022-11-06T23:01:30.347283+08:00 0 [Warning] [MY-010604] [Repl] 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 [Note] [MY-010536] [Repl] Relay log recovery skipped for group replication channel.
2022-11-06T23:01:30.353154+08:00 0 [Warning] [MY-010539] [Repl] Recovery from master pos 4 and file  for 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 [Note] [MY-011025] [Repl] Failed to start slave threads for channel ''.
2022-11-06T23:01:30.357427+08:00 6 [Note] [MY-010051] [Server] Event Scheduler: scheduler thread started with id 6
2022-11-06T23:01:30.358383+08:00 0 [Note] [MY-011240] [Server] Plugin mysqlx reported: 'Using SSL configuration from MySQL Server'
2022-11-06T23:01:30.358959+08:00 0 [Note] [MY-011243] [Server] Plugin mysqlx reported: 'Using OpenSSL for TLS connections'
2022-11-06T23:01:30.359174+08:00 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.25-16'  socket: '/data/GreatSQL/mysql.sock'  port: 3306  GreatSQL (GPL), Release 16, Revision 8bb0e5af297.
2022-11-06T23:01:30.359829+08:00 2 [System] [MY-011565] [Repl] Plugin group_replication reported: 'Setting super_read_only=ON.'
2022-11-06T23:01:30.359910+08:00 2 [Note] [MY-011673] [Repl] Plugin group_replication reported: 'Group communication SSL configuration: group_replication_ssl_mode: "DISABLED"'
2022-11-06T23:01:30.360555+08:00 0 [Note] [MY-011946] [InnoDB] Buffer pool(s) load completed at 221106 23:01:30
2022-11-06T23:01:30.361389+08:00 2 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Debug messages will be sent to: asynchronous::/data/GreatSQL/GCS_DEBUG_TRACE'
2022-11-06T23:01:30.361538+08:00 2 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] 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 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] 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 [ERROR] [MY-011674] [Repl] Plugin group_replication reported: 'Unable to initialize the group communication engine'
2022-11-06T23:01:30.362779+08:00 2 [ERROR] [MY-011637] [Repl] Plugin group_replication reported: 'Error on group communication engine initialization'
2022-11-06T23:01:30.362803+08:00 2 [Note] [MY-011649] [Repl] Plugin group_replication reported: 'Requesting to leave the group despite of not being a member'
2022-11-06T23:01:30.362876+08:00 2 [System] [MY-011566] [Repl] Plugin group_replication reported: 'Setting super_read_only=OFF.'
mbind: Operation not permitted
2022-11-06T23:02:33.338945+08:00 10 [System] [MY-013587] [Repl] Plugin group_replication reported: 'Plugin 'group_replication' is starting.'
2022-11-06T23:02:33.339011+08:00 10 [Note] [MY-011716] [Repl] Plugin group_replication reported: 'Current debug options are: 'GCS_DEBUG_NONE'.'
2022-11-06T23:02:33.339769+08:00 11 [System] [MY-011565] [Repl] Plugin group_replication reported: 'Setting super_read_only=ON.'
2022-11-06T23:02:33.339865+08:00 10 [Note] [MY-011673] [Repl] Plugin group_replication reported: 'Group communication SSL configuration: group_replication_ssl_mode: "DISABLED"'
2022-11-06T23:02:33.340906+08:00 10 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Debug messages will be sent to: asynchronous::/data/GreatSQL/GCS_DEBUG_TRACE'
2022-11-06T23:02:33.341053+08:00 10 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] 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 [ERROR] [MY-011674] [Repl] Plugin group_replication reported: 'Unable to initialize the group communication engine'
2022-11-06T23:02:33.341281+08:00 10 [ERROR] [MY-011637] [Repl] Plugin group_replication reported: 'Error on group communication engine initialization'
2022-11-06T23:02:33.341290+08:00 10 [Note] [MY-011649] [Repl] Plugin group_replication reported: 'Requesting to leave the group despite of not being a member'
2022-11-06T23:02:33.341373+08:00 11 [System] [MY-011566] [Repl] Plugin group_replication reported: 'Setting super_read_only=OFF.'
2022-11-06T23:12:34.441628+08:00 10 [Note] [MY-013417] [Server] The wait_timeout period was exceeded, the idle time since last command was too long.
2022-11-06T23:12:34.441705+08:00 10 [Note] [MY-010914] [Server] 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 [System] [MY-013587] [Repl] Plugin group_replication reported: 'Plugin 'group_replication' is starting.'
2022-11-06T23:26:38.590663+08:00 12 [Note] [MY-011716] [Repl] Plugin group_replication reported: 'Current debug options are: 'GCS_DEBUG_NONE'.'
2022-11-06T23:26:38.592220+08:00 13 [System] [MY-011565] [Repl] Plugin group_replication reported: 'Setting super_read_only=ON.'
2022-11-06T23:26:38.592315+08:00 12 [Note] [MY-011673] [Repl] Plugin group_replication reported: 'Group communication SSL configuration: group_replication_ssl_mode: "DISABLED"'
2022-11-06T23:26:38.593006+08:00 12 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Debug messages will be sent to: asynchronous::/data/GreatSQL/GCS_DEBUG_TRACE'
2022-11-06T23:26:38.593124+08:00 12 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] 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 [ERROR] [MY-011674] [Repl] Plugin group_replication reported: 'Unable to initialize the group communication engine'
2022-11-06T23:26:38.593486+08:00 12 [ERROR] [MY-011637] [Repl] Plugin group_replication reported: 'Error on group communication engine initialization'
2022-11-06T23:26:38.593496+08:00 12 [Note] [MY-011649] [Repl] Plugin group_replication reported: 'Requesting to leave the group despite of not being a member'
2022-11-06T23:26:38.593571+08:00 13 [System] [MY-011566] [Repl] Plugin group_replication reported: 'Setting super_read_only=OFF.'

全部回复(4)
yejr 2022-11-7 15:02:21
建议用docker-compose尝试下
参考文档 https://gitee.com/GreatSQL/Great ... r%E9%9B%86%E7%BE%A4
yejr 2022-11-7 15:08:37
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服务。
紫清风玲 2022-11-7 15:12:53
yejr 发表于 2022-11-7 15:02
建议用docker-compose尝试下
参考文档 https://gitee.com/GreatSQL/GreatSQL-Docker#%E5%A6%82%E4%BD%95%E9 ...

docker-compose,不在同一个服务器能一次性初始化?
yejr 2022-11-9 08:32:59
紫清风玲 发表于 2022-11-7 15:12
docker-compose,不在同一个服务器能一次性初始化?

不能。
跨服务器的话,可以考虑上K8S。
紫清风玲

4

主题

0

博客

21

贡献

新手上路

Rank: 1

积分
32

合作电话:010-64087828

社区邮箱:greatsql@greatdb.com

社区公众号
社区小助手
QQ群
GMT+8, 2024-3-29 13:18 , Processed in 0.019101 second(s), 11 queries , Redis On.
快速回复 返回顶部 返回列表