点击参与 GreatSQL 8.0.32-26 文档捉虫~~~

GreatSQL社区

搜索

[已解决] 单机多实例加入第二台时第一个直接蹦了( GreatSQL-8.0.32-24)

812 1 2023-10-23 17:19
本帖最后由 周智林 于 2023-10-23 17:19 编辑

先贴配置
第一个的my3306.cnf 配置
  1. #mgr settings
  2. loose-plugin_load_add = 'mysql_clone.so'
  3. loose-plugin_load_add = 'group_replication.so'
  4. loose-group_replication_group_name = "aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaa1"
  5. #MGR本地节点IP:PORT，请自行替换
  6. loose-group_replication_local_address = "192.168.188.60:33061"
  7. #MGR集群所有节点IP:PORT，请自行替换
  8. loose-group_replication_group_seeds = "192.168.188.60:33061,192.168.188.60:33071,192.168.188.60:33081,192.168.188.60:33091"
  9. loose-group_replication_start_on_boot = OFF
  10. loose-group_replication_bootstrap_group = OFF
  11. loose-group_replication_exit_state_action = READ_ONLY
  12. loose-group_replication_flow_control_mode = "DISABLED"
  13. loose-group_replication_single_primary_mode = ON
  14. loose-group_replication_majority_after_mode = ON
  15. loose-group_replication_communication_max_message_size = 10M
  16. loose-group_replication_arbitrator = 0
  17. loose-group_replication_single_primary_fast_mode = 1
  18. loose-group_replication_request_time_threshold = 100
  19. loose-group_replication_primary_election_mode = GTID_FIRST
  20. loose-group_replication_unreachable_majority_timeout = 30
  21. loose-group_replication_member_expel_timeout = 5
  22. loose-group_replication_autorejoin_tries = 288
  23. #report_host = "192.168.188.60"
复制代码
第二个3307.cnf的配置
  1. #mgr settings
  2. loose-plugin_load_add = 'mysql_clone.so'
  3. loose-plugin_load_add = 'group_replication.so'
  4. loose-group_replication_group_name = "aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaa1"
  5. #MGR本地节点IP:PORT，请自行替换
  6. loose-group_replication_local_address = "192.168.188.60:33071"
  7. #MGR集群所有节点IP:PORT，请自行替换
  8. loose-group_replication_group_seeds = "192.168.188.60:33061,192.168.188.60:33071,192.168.188.60:33081,192.168.188.60:33091"
  9. loose-group_replication_start_on_boot = OFF
  10. loose-group_replication_bootstrap_group = OFF
  11. loose-group_replication_exit_state_action = READ_ONLY
  12. loose-group_replication_flow_control_mode = "DISABLED"
  13. loose-group_replication_single_primary_mode = ON
  14. loose-group_replication_majority_after_mode = ON
  15. loose-group_replication_communication_max_message_size = 10M
  16. loose-group_replication_arbitrator = 0
  17. loose-group_replication_single_primary_fast_mode = 1
  18. loose-group_replication_request_time_threshold = 100
  19. loose-group_replication_primary_election_mode = GTID_FIRST
  20. loose-group_replication_unreachable_majority_timeout = 30
  21. loose-group_replication_member_expel_timeout = 5
  22. loose-group_replication_autorejoin_tries = 288
  23. #report_host = "192.168.188.60"
复制代码




3306的日志
  1. [root@localhost 3306]# more error.log

  3. 2023-10-23T17:10:15.346694+08:00 0 [Warning] [MY-010140] [Server] Could not increase number of max_open_files to more than 10000 (request: 65535)
  4. 2023-10-23T17:10:15.544255+08:00 0 [Warning] [MY-011068] [Server] The syntax 'log_slow_slave_statements' is deprecated and will be removed in a future release. Plea
  5. se use log_slow_replica_statements instead.
  6. 2023-10-23T17:10:15.544302+08:00 0 [Warning] [MY-011068] [Server] The syntax 'slave_parallel_type' is deprecated and will be removed in a future release. Please use
  7. replica_parallel_type instead.
  8. 2023-10-23T17:10:15.544307+08:00 0 [Warning] [MY-011069] [Server] The syntax '--replica-parallel-type' is deprecated and will be removed in a future release.
  9. 2023-10-23T17:10:15.544315+08:00 0 [Warning] [MY-011068] [Server] The syntax 'slave_parallel_workers' is deprecated and will be removed in a future release. Please
  10. use replica_parallel_workers instead.
  11. 2023-10-23T17:10:15.544325+08:00 0 [Warning] [MY-011068] [Server] The syntax 'slave_preserve_commit_order' is deprecated and will be removed in a future release. Pl
  12. ease use replica_preserve_commit_order instead.
  13. 2023-10-23T17:10:15.544335+08:00 0 [Warning] [MY-011068] [Server] The syntax 'slave_checkpoint_period' is deprecated and will be removed in a future release. Please
  14. use replica_checkpoint_period instead.
  15. 2023-10-23T17:10:15.544471+08:00 0 [Warning] [MY-010097] [Server] Insecure configuration for --secure-file-priv: Current value does not restrict location of generat
  16. ed files. Consider setting it to a valid, non-empty path.
  17. 2023-10-23T17:10:15.544476+08:00 0 [Warning] [MY-010097] [Server] Insecure configuration for --secure-log-path: Current value does not restrict location of generate
  18. d files. Consider setting it to a valid, non-empty path.
  19. 2023-10-23T17:10:15.544530+08:00 0 [Note] [MY-013932] [Server] BuildID[sha1]=5850d8e16b7845a955d11d6965d9d658fd24b257
  20. 2023-10-23T17:10:15.544535+08:00 0 [Note] [MY-010949] [Server] Basedir set to /usr/local/GreatSQL-8.0.32-24-Linux-glibc2.17-x86_64/.
  21. 2023-10-23T17:10:15.544542+08:00 0 [System] [MY-010116] [Server] /usr/local/GreatSQL-8.0.32-24-Linux-glibc2.17-x86_64/bin/mysqld (mysqld 8.0.32-24) starting as proc
  22. ess 30223
  23. 2023-10-23T17:10:15.556405+08:00 0 [Warning] [MY-012364] [InnoDB] innodb_open_files should not be greater than the open_files_limit.
  24. 2023-10-23T17:10:15.556445+08:00 0 [Note] [MY-012366] [InnoDB] Using Linux native AIO
  25. 2023-10-23T17:10:15.556469+08:00 0 [Warning] [MY-013869] [InnoDB] Ignored deprecated configuration parameter innodb_log_file_size. Used innodb_redo_log_capacity ins
  26. tead.
  27. 2023-10-23T17:10:15.556480+08:00 0 [Warning] [MY-013870] [InnoDB] Ignored deprecated configuration parameter innodb_log_files_in_group. Used innodb_redo_log_capacit
  28. y instead.
  29. 2023-10-23T17:10:15.556793+08:00 0 [Note] [MY-010747] [Server] Plugin 'FEDERATED' is disabled.
  30. 2023-10-23T17:10:15.556883+08:00 0 [Note] [MY-010747] [Server] Plugin 'ndbcluster' is disabled.
  31. 2023-10-23T17:10:15.556905+08:00 0 [Note] [MY-010747] [Server] Plugin 'ndbinfo' is disabled.
  32. 2023-10-23T17:10:15.556917+08:00 0 [Note] [MY-010747] [Server] Plugin 'ndb_transid_mysql_connection_map' is disabled.
  33. 2023-10-23T17:10:15.561467+08:00 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
  34. 2023-10-23T17:10:15.561503+08:00 1 [Note] [MY-013546] [InnoDB] Atomic write enabled
  35. 2023-10-23T17:10:15.561533+08:00 1 [Note] [MY-012932] [InnoDB] PUNCH HOLE support available
  36. 2023-10-23T17:10:15.561548+08:00 1 [Note] [MY-012944] [InnoDB] Uses event mutexes
  37. 2023-10-23T17:10:15.561555+08:00 1 [Note] [MY-012945] [InnoDB] GCC builtin __atomic_thread_fence() is used for memory barrier
  38. 2023-10-23T17:10:15.561564+08:00 1 [Note] [MY-012948] [InnoDB] Compressed tables use zlib 1.2.13
  39. 2023-10-23T17:10:15.564106+08:00 1 [Note] [MY-012951] [InnoDB] Using hardware accelerated crc32 and polynomial multiplication.
  40. 2023-10-23T17:10:15.564505+08:00 1 [Note] [MY-012203] [InnoDB] Directories to scan './'
  41. 2023-10-23T17:10:15.564557+08:00 1 [Note] [MY-012204] [InnoDB] Scanning './'
  42. 2023-10-23T17:10:15.571617+08:00 1 [Note] [MY-012208] [InnoDB] Completed space ID check of 5 files.
  43. 2023-10-23T17:10:15.572741+08:00 1 [Note] [MY-012955] [InnoDB] Initializing buffer pool, total size = 2.000000G, instances = 8, chunk size =128.000000M
  44. 2023-10-23T17:10:15.572762+08:00 1 [Note] [MY-011872] [InnoDB] Setting NUMA memory policy to MPOL_INTERLEAVE
  45. 2023-10-23T17:10:20.767248+08:00 1 [Note] [MY-011874] [InnoDB] Setting NUMA memory policy to MPOL_DEFAULT
  46. 2023-10-23T17:10:20.822804+08:00 1 [Note] [MY-012957] [InnoDB] Completed initialization of buffer pool
  47. 2023-10-23T17:10:22.352134+08:00 0 [Note] [MY-011952] [InnoDB] If the mysqld execution user is authorized, page cleaner and LRU manager thread priority can be chang
  48. ed. See the man page of setpriority().
  49. 2023-10-23T17:10:23.116978+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_0.dblwr' for doublewrite
  50. 2023-10-23T17:10:23.183223+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_1.dblwr' for doublewrite
  51. 2023-10-23T17:10:23.191288+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_2.dblwr' for doublewrite
  52. 2023-10-23T17:10:23.202994+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_3.dblwr' for doublewrite
  53. 2023-10-23T17:10:23.220992+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_4.dblwr' for doublewrite
  54. 2023-10-23T17:10:23.221441+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_5.dblwr' for doublewrite
  55. 2023-10-23T17:10:23.225543+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_6.dblwr' for doublewrite
  56. 2023-10-23T17:10:23.236496+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_7.dblwr' for doublewrite
  57. 2023-10-23T17:10:23.239336+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_8.dblwr' for doublewrite
  58. 2023-10-23T17:10:23.239745+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_9.dblwr' for doublewrite
  59. 2023-10-23T17:10:23.241927+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_10.dblwr' for doublewrite
  60. 2023-10-23T17:10:23.243484+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_11.dblwr' for doublewrite
  61. 2023-10-23T17:10:23.245607+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_12.dblwr' for doublewrite
  62. 2023-10-23T17:10:23.318329+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_13.dblwr' for doublewrite
  63. 2023-10-23T17:10:23.449407+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_14.dblwr' for doublewrite
  64. 2023-10-23T17:10:23.451398+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_15.dblwr' for doublewrite
  65. 2023-10-23T17:10:23.457437+08:00 1 [Note] [MY-013566] [InnoDB] Double write buffer files: 16
  66. 2023-10-23T17:10:23.457475+08:00 1 [Note] [MY-013565] [InnoDB] Double write buffer pages per instance: 4
  67. 2023-10-23T17:10:23.457505+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_0.dblwr' for doublewrite
  68. 2023-10-23T17:10:23.457530+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_1.dblwr' for doublewrite
  69. 2023-10-23T17:10:23.457547+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_2.dblwr' for doublewrite
  70. 2023-10-23T17:10:23.457564+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_3.dblwr' for doublewrite
  71. 2023-10-23T17:10:23.457581+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_4.dblwr' for doublewrite
  72. 2023-10-23T17:10:23.457596+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_5.dblwr' for doublewrite
  73. 2023-10-23T17:10:23.457612+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_6.dblwr' for doublewrite
  74. 2023-10-23T17:10:23.457628+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_7.dblwr' for doublewrite
  75. 2023-10-23T17:10:23.457645+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_8.dblwr' for doublewrite
  76. 2023-10-23T17:10:23.457661+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_9.dblwr' for doublewrite
  77. 2023-10-23T17:10:23.457677+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_10.dblwr' for doublewrite
  78. 2023-10-23T17:10:23.457693+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_11.dblwr' for doublewrite
  79. 2023-10-23T17:10:23.457710+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_12.dblwr' for doublewrite
  80. 2023-10-23T17:10:23.457726+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_13.dblwr' for doublewrite
  81. 2023-10-23T17:10:23.457749+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_14.dblwr' for doublewrite
  82. 2023-10-23T17:10:23.457765+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_15.dblwr' for doublewrite
  83. 2023-10-23T17:10:23.696425+08:00 1 [Note] [MY-013883] [InnoDB] The latest found checkpoint is at lsn = 20958876 in redo log file ./#innodb_redo/#ib_redo0.
  84. 2023-10-23T17:10:23.700597+08:00 1 [Note] [MY-012560] [InnoDB] The log sequence number 20055393 in the system tablespace does not match the log sequence number 2095
  85. 8876 in the redo log files!
  86. 2023-10-23T17:10:23.700630+08:00 1 [Note] [MY-012551] [InnoDB] Database was not shutdown normally!
  87. 2023-10-23T17:10:23.700638+08:00 1 [Note] [MY-012552] [InnoDB] Starting crash recovery.
  88. 2023-10-23T17:10:23.759786+08:00 1 [Note] [MY-013086] [InnoDB] Starting to parse redo log at lsn = 20958770, whereas checkpoint_lsn = 20958876 and start_lsn = 20958
  89. 720
  90. 2023-10-23T17:10:23.759873+08:00 1 [Note] [MY-012550] [InnoDB] Doing recovery: scanned up to log sequence number 20958876
  91. 2023-10-23T17:10:23.766719+08:00 1 [Note] [MY-013083] [InnoDB] Log background threads are being started...
  92. 2023-10-23T17:10:23.901795+08:00 1 [Note] [MY-012532] [InnoDB] Applying a batch of 0 redo log records ...
  93. 2023-10-23T17:10:23.901832+08:00 1 [Note] [MY-012535] [InnoDB] Apply batch completed!
  94. 2023-10-23T17:10:23.902343+08:00 1 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_001'.
  95. 2023-10-23T17:10:23.902901+08:00 1 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_002'.
  96. 2023-10-23T17:10:23.904097+08:00 1 [Note] [MY-012910] [InnoDB] Opened 2 existing undo tablespaces.
  97. 2023-10-23T17:10:23.904184+08:00 1 [Note] [MY-011980] [InnoDB] GTID recovery trx_no: 8818
  98. 2023-10-23T17:10:23.967782+08:00 1 [Note] [MY-013776] [InnoDB] Parallel initialization of rseg complete
  99. 2023-10-23T17:10:23.967848+08:00 1 [Note] [MY-013777] [InnoDB] Time taken to initialize rseg using 2 thread: 63669 ms.
  100. 2023-10-23T17:10:23.968278+08:00 1 [Note] [MY-012255] [InnoDB] Removed temporary tablespace data file: "ibtmp1"
  101. 2023-10-23T17:10:23.968299+08:00 1 [Note] [MY-012923] [InnoDB] Creating shared tablespace for temporary tables
  102. 2023-10-23T17:10:23.968332+08:00 1 [Note] [MY-012265] [InnoDB] Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
  103. 2023-10-23T17:10:23.977301+08:00 1 [Note] [MY-012266] [InnoDB] File './ibtmp1' size is now 12 MB.
  104. 2023-10-23T17:10:23.977414+08:00 1 [Note] [MY-013627] [InnoDB] Scanning temp tablespace dir:'./#innodb_temp/'
  105. 2023-10-23T17:10:23.985654+08:00 1 [Note] [MY-013018] [InnoDB] Created 128 and tracked 128 new rollback segment(s) in the temporary tablespace. 128 are now active.
  106. 2023-10-23T17:10:23.992697+08:00 1 [Note] [MY-012976] [InnoDB] Percona XtraDB (http://www.percona.com) 8.0.32-8.0.32 started; log sequence number 20958886
  107. 2023-10-23T17:10:23.993756+08:00 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
  108. 2023-10-23T17:10:24.001916+08:00 1 [Note] [MY-011089] [Server] Data dictionary restarting version '80023'.
  109. 2023-10-23T17:10:24.095437+08:00 1 [Note] [MY-012357] [InnoDB] Reading DD tablespace files
  110. 2023-10-23T17:10:24.096886+08:00 1 [Note] [MY-012356] [InnoDB] Scanned 7 tablespaces. Validated 7.
  111. 2023-10-23T17:10:24.110091+08:00 1 [Note] [MY-010006] [Server] Using data dictionary with version '80023'.
  112. 2023-10-23T17:10:24.142006+08:00 0 [Note] [MY-011332] [Server] Plugin mysqlx reported: 'IPv6 is available'
  113. 2023-10-23T17:10:24.142105+08:00 0 [Note] [MY-011324] [Server] Plugin mysqlx reported: 'Retrying `bind()` on TCP/IP port 33060'
  114. 2023-10-23T17:10:25.144557+08:00 0 [ERROR] [MY-011292] [Server] Plugin mysqlx reported: 'Preparation of I/O interfaces failed, X Protocol won't be accessible'
  115. 2023-10-23T17:10:25.144664+08:00 0 [ERROR] [MY-011300] [Server] Plugin mysqlx reported: 'Setup of bind-address: '*' port: 33060 failed, `bind()` failed with error:
  116. Address already in use (98). Do you already have another mysqld server running with Mysqlx ?'
  117. 2023-10-23T17:10:25.144675+08:00 0 [ERROR] [MY-013597] [Server] Plugin mysqlx reported: 'Value '*' set to `Mysqlx_bind_address`, X Plugin can't bind to it. Skipping
  118. this value.'
  119. 2023-10-23T17:10:25.144703+08:00 0 [ERROR] [MY-011300] [Server] Plugin mysqlx reported: 'Setup of socket: '/tmp/mysqlx.sock' failed, another process with PID 28816
  120. is using UNIX socket file'
  121. 2023-10-23T17:10:25.144710+08:00 0 [Note] [MY-011322] [Server] Plugin mysqlx reported: 'Please see the MySQL documentation for 'mysqlx_port,mysqlx_bind_address' sys
  122. tem variables to fix the error'
  123. 2023-10-23T17:10:25.144720+08:00 0 [Note] [MY-011322] [Server] Plugin mysqlx reported: 'Please see the MySQL documentation for 'mysqlx_socket' system variables to f
  124. ix the error'
  125. 2023-10-23T17:10:25.219420+08:00 0 [Note] [MY-010902] [Server] Thread priority attribute setting in Resource Group SQL shall be ignored due to unsupported platform
  126. or insufficient privilege.
  127. 2023-10-23T17:10:25.223839+08:00 0 [Note] [MY-010855] [Server] Recovering after a crash using binlog
  128. 2023-10-23T17:10:25.224071+08:00 0 [System] [MY-010229] [Server] Starting XA crash recovery...
  129. 2023-10-23T17:10:25.237938+08:00 0 [Note] [MY-013911] [Server] Crash recovery finished in binlog engine. No attempts to commit, rollback or prepare any transactions
  130. .
  131. 2023-10-23T17:10:25.238085+08:00 0 [Note] [MY-013911] [Server] Crash recovery finished in InnoDB engine. No attempts to commit, rollback or prepare any transactions
  132. .
  133. 2023-10-23T17:10:25.238113+08:00 0 [System] [MY-010232] [Server] XA crash recovery finished.
  134. 2023-10-23T17:10:25.248950+08:00 0 [Note] [MY-012487] [InnoDB] DDL log recovery : begin
  135. 2023-10-23T17:10:25.249473+08:00 0 [Note] [MY-012488] [InnoDB] DDL log recovery : end
  136. 2023-10-23T17:10:25.260595+08:00 0 [Note] [MY-011946] [InnoDB] Loading buffer pool(s) from /data/GreatSQL/3306/ib_buffer_pool
  137. 2023-10-23T17:10:25.357836+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 usin
  138. g them.
  139. 2023-10-23T17:10:25.357950+08:00 0 [Note] [MY-010304] [Server] Skipping generation of SSL certificates as certificate files are present in data directory.
  140. 2023-10-23T17:10:25.362222+08:00 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
  141. 2023-10-23T17:10:25.362364+08:00 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this chan
  142. nel.
  143. 2023-10-23T17:10:25.362512+08:00 0 [Note] [MY-010308] [Server] Skipping generation of RSA key pair through --sha256_password_auto_generate_rsa_keys as key files are
  144. present in data directory.
  145. 2023-10-23T17:10:25.362549+08:00 0 [Note] [MY-010308] [Server] Skipping generation of RSA key pair through --caching_sha2_password_auto_generate_rsa_keys as key fil
  146. es are present in data directory.
  147. 2023-10-23T17:10:25.363960+08:00 0 [Note] [MY-010252] [Server] Server hostname (bind-address): '*'; port: 3306
  148. 2023-10-23T17:10:25.364028+08:00 0 [Note] [MY-010253] [Server] IPv6 is available.
  149. 2023-10-23T17:10:25.364053+08:00 0 [Note] [MY-010264] [Server]   - '::' resolves to '::';
  150. 2023-10-23T17:10:25.364064+08:00 0 [Note] [MY-010251] [Server] Server socket created on IP: '::'.
  151. 2023-10-23T17:10:25.426397+08:00 0 [Warning] [MY-010604] [Repl] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server
  152. acts as a slave and has his hostname changed!! Please use '--relay-log=localhost-relay-bin' to avoid this problem.
  153. 2023-10-23T17:10:25.430412+08:00 0 [Warning] [MY-013836] [Repl] Relay log recovery on channel with GTID_ONLY=1. The channel will switch to a new relay log and the G
  154. TID protocol will be used to replicate unapplied transactions.
  155. 2023-10-23T17:10:25.438915+08:00 0 [Warning] [MY-013836] [Repl] Relay log recovery on channel with GTID_ONLY=1. The channel will switch to a new relay log and the G
  156. TID protocol will be used to replicate unapplied transactions.
  157. 2023-10-23T17:10:25.440935+08:00 0 [Note] [MY-011025] [Repl] Failed to start slave threads for channel ''.
  158. 2023-10-23T17:10:25.445123+08:00 0 [System] [MY-010931] [Server] /usr/local/GreatSQL-8.0.32-24-Linux-glibc2.17-x86_64/bin/mysqld: ready for connections. Version: '8
  159. .0.32-24'  socket: '/data/GreatSQL/3306/mysql.sock'  port: 3306  GreatSQL, Release 24, Revision 3714067bc8c.
  160. 2023-10-23T17:10:25.445422+08:00 0 [Note] [MY-011240] [Server] Plugin mysqlx reported: 'Using SSL configuration from MySQL Server'
  161. 2023-10-23T17:10:25.445786+08:00 0 [Note] [MY-011243] [Server] Plugin mysqlx reported: 'Using OpenSSL for TLS connections'
  162. 2023-10-23T17:10:25.449703+08:00 7 [Note] [MY-010051] [Server] Event Scheduler: scheduler thread started with id 7
  163. 2023-10-23T17:10:25.497606+08:00 0 [Note] [MY-011946] [InnoDB] Buffer pool(s) load completed at 231023 17:10:25
复制代码
3307的日志
  1. [root@localhost 3306]# more /data/GreatSQL/3307/error.log

  3. 2023-10-23T17:10:13.833136+08:00 17 [System] [MY-013587] [Repl] Plugin group_replication reported: 'Plugin 'group_replication' is starting.'
  4. 2023-10-23T17:10:13.833632+08:00 17 [Note] [MY-011716] [Repl] Plugin group_replication reported: 'Current debug options are: 'GCS_DEBUG_NONE'.'
  5. 2023-10-23T17:10:13.839342+08:00 17 [System] [MY-011565] [Repl] Plugin group_replication reported: 'Setting super_read_only=ON.'
  6. 2023-10-23T17:10:13.847596+08:00 17 [Note] [MY-011673] [Repl] Plugin group_replication reported: 'Group communication SSL configuration: group_replication_ssl_mode:
  7. "DISABLED"'
  8. 2023-10-23T17:10:13.848869+08:00 17 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Debug messages will be sent to: asynchronous::/data/GreatSQL
  9. /3307/GCS_DEBUG_TRACE'
  10. 2023-10-23T17:10:13.853125+08:00 17 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Added automatically IP ranges 127.0.0.1/8,192.168.188.60/24,
  11. ::1/128,fe80::5c30:c5fd:1c8d:a5e3/64 to the allowlist'
  12. 2023-10-23T17:10:13.854896+08:00 17 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] SSL was not enabled'
  13. 2023-10-23T17:10:13.854984+08:00 17 [Note] [MY-011694] [Repl] Plugin group_replication reported: 'Initialized group communication with configuration: group_replicat
  14. ion_group_name: 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaa1'; group_replication_local_address: '192.168.188.60:33071'; group_replication_group_seeds: '192.168.188.60:3306
  15. 1,192.168.188.60:33071,192.168.188.60:33081,192.168.188.60:33091'; group_replication_bootstrap_group: 'false'; group_replication_poll_spin_loops: 0; group_replicati
  16. on_compression_threshold: 1000000; group_replication_ip_allowlist: 'AUTOMATIC'; group_replication_communication_debug_options: 'GCS_DEBUG_NONE'; group_replication_m
  17. ember_expel_timeout: '5'; group_replication_communication_max_message_size: 10485760; group_replication_message_cache_size: '1073741824u; group_replication_communic
  18. ation_stack: '0''
  19. 2023-10-23T17:10:13.855496+08:00 17 [Note] [MY-011643] [Repl] Plugin group_replication reported: 'Member configuration: member_id: 3307; member_uuid: "514668fd-7173
  20. -11ee-b9b4-000c29e3b420"; single-primary mode: "true"; group_replication_auto_increment_increment: 7; group_replication_view_change_uuid: "AUTOMATIC";'
  21. 2023-10-23T17:10:13.855559+08:00 17 [Note] [MY-011071] [Repl] Plugin group_replication reported: 'Init certifier broadcast thread'
  22. 2023-10-23T17:10:13.861469+08:00 19 [Note] [MY-011531] [Repl] Plugin group_replication reported: 'Detected previous RESET MASTER invocation or an issue exists in th
  23. e group replication applier relay log. Purging existing applier logs.'
  24. 2023-10-23T17:10:13.874092+08:00 19 [System] [MY-010597] [Repl] 'CHANGE MASTER TO FOR CHANNEL 'group_replication_applier' executed'. Previous state master_host='<NU
  25. LL>', master_port= 0, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='<NULL>', master_port= 0, master_log_file='', master_log_pos= 4,
  26. master_bind=''.
  27. 2023-10-23T17:10:14.046125+08:00 21 [Note] [MY-010581] [Repl] Slave SQL thread for channel 'group_replication_applier' initialized, starting replication in log 'FIR
  28. ST' at position 0, relay log './localhost-relay-bin-group_replication_applier.000001' position: 4
  29. 2023-10-23T17:10:14.046877+08:00 17 [Note] [MY-011670] [Repl] Plugin group_replication reported: 'Group Replication applier module successfully initialized!'
  30. 2023-10-23T17:10:14.050156+08:00 17 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buckets:2000000, dec_threshold_length:1000000'
  31. 2023-10-23T17:10:14.051118+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] 1698052214.051087 pid 28817 xcom_id 0 state xcom_fsm_init act
  32. ion x_fsm_init'
  33. 2023-10-23T17:10:14.051154+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Init xcom thread'
  34. 2023-10-23T17:10:15.655314+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Using XCom as Communication Stack for XCom'
  35. 2023-10-23T17:10:15.656914+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] XCom initialized and ready to accept incoming connections on
  36. port 33071'
  37. 2023-10-23T17:10:15.657713+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Successfully connected to the local XCom via anonymous pipe'
  38. 2023-10-23T17:10:15.658697+08:00 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to peer node 192.168.188.60:33
  39. 061 when joining a group. My local port is: 33071.'
  40. 2023-10-23T17:10:15.658878+08:00 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to peer node 192.168.188.60:33
  41. 081 when joining a group. My local port is: 33071.'
  42. 2023-10-23T17:10:15.658981+08:00 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to peer node 192.168.188.60:33
  43. 091 when joining a group. My local port is: 33071.'
  44. 2023-10-23T17:10:15.659079+08:00 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to peer node 192.168.188.60:33
  45. 061 when joining a group. My local port is: 33071.'
  46. 2023-10-23T17:10:15.659179+08:00 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to peer node 192.168.188.60:33
  47. 081 when joining a group. My local port is: 33071.'
  48. 2023-10-23T17:10:15.659269+08:00 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to peer node 192.168.188.60:33
  49. 091 when joining a group. My local port is: 33071.'
  50. 2023-10-23T17:10:15.659325+08:00 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to peer node 192.168.188.60:33
  51. 061 when joining a group. My local port is: 33071.'
  52. 2023-10-23T17:10:15.659345+08:00 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to peer node 192.168.188.60:33
  53. 081 when joining a group. My local port is: 33071.'
  54. 2023-10-23T17:10:15.659361+08:00 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to peer node 192.168.188.60:33
  55. 091 when joining a group. My local port is: 33071.'
  56. 2023-10-23T17:10:15.659375+08:00 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to peer node 192.168.188.60:33
  57. 061 when joining a group. My local port is: 33071.'
  58. 2023-10-23T17:10:15.659391+08:00 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to peer node 192.168.188.60:33
  59. 081 when joining a group. My local port is: 33071.'
  60. 2023-10-23T17:10:15.659406+08:00 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to peer node 192.168.188.60:33
  61. 091 when joining a group. My local port is: 33071.'
  62. 2023-10-23T17:10:15.659426+08:00 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to peer node 192.168.188.60:33
  63. 061 when joining a group. My local port is: 33071.'
  64. 2023-10-23T17:10:15.659442+08:00 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to peer node 192.168.188.60:33
  65. 081 when joining a group. My local port is: 33071.'
  66. 2023-10-23T17:10:15.659541+08:00 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to peer node 192.168.188.60:33
  67. 091 when joining a group. My local port is: 33071.'
  68. 2023-10-23T17:10:15.659632+08:00 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to peer node 192.168.188.60:33
  69. 061 when joining a group. My local port is: 33071.'
  70. 2023-10-23T17:10:15.659693+08:00 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to peer node 192.168.188.60:33
  71. 081 when joining a group. My local port is: 33071.'
  72. 2023-10-23T17:10:15.659743+08:00 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to peer node 192.168.188.60:33
  73. 091 when joining a group. My local port is: 33071.'
  74. 2023-10-23T17:10:15.659839+08:00 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to peer node 192.168.188.60:33
  75. 061 when joining a group. My local port is: 33071.'
  76. 2023-10-23T17:10:15.659918+08:00 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to peer node 192.168.188.60:33
  77. 081 when joining a group. My local port is: 33071.'
  78. 2023-10-23T17:10:15.659985+08:00 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to peer node 192.168.188.60:33
  79. 091 when joining a group. My local port is: 33071.'
  80. 2023-10-23T17:10:15.660053+08:00 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to peer node 192.168.188.60:33
  81. 061 when joining a group. My local port is: 33071.'
  82. 2023-10-23T17:10:15.660131+08:00 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to peer node 192.168.188.60:33
  83. 081 when joining a group. My local port is: 33071.'
  84. 2023-10-23T17:10:15.660190+08:00 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to peer node 192.168.188.60:33
  85. 091 when joining a group. My local port is: 33071.'
  86. 2023-10-23T17:10:15.660266+08:00 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to peer node 192.168.188.60:33
  87. 061 when joining a group. My local port is: 33071.'
  88. 2023-10-23T17:10:15.660348+08:00 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to peer node 192.168.188.60:33
  89. 081 when joining a group. My local port is: 33071.'
  90. 2023-10-23T17:10:15.660441+08:00 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to peer node 192.168.188.60:33
  91. 091 when joining a group. My local port is: 33071.'
  92. 2023-10-23T17:10:15.660530+08:00 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to peer node 192.168.188.60:33
  93. 061 when joining a group. My local port is: 33071.'
  94. 2023-10-23T17:10:15.660612+08:00 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to peer node 192.168.188.60:33
  95. 081 when joining a group. My local port is: 33071.'
  96. 2023-10-23T17:10:15.660681+08:00 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to peer node 192.168.188.60:33
  97. 091 when joining a group. My local port is: 33071.'
  98. 2023-10-23T17:10:15.660708+08:00 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error connecting to all peers. Member join failed. Local por
  99. t: 33071'
  100. 2023-10-23T17:10:15.668077+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] 1698052215.667896 pid 28817 xcom_id b039bd31 state xcom_fsm_s
  101. tart action x_fsm_terminate'
  102. 2023-10-23T17:10:15.668258+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] 1698052215.668241 pid 28817 xcom_id b039bd31 state xcom_fsm_s
  103. tart action x_fsm_exit'
  104. 2023-10-23T17:10:15.668320+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Exiting xcom thread'
  105. 2023-10-23T17:10:15.668434+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:59 in close_connection'
  106. 2023-10-23T17:10:15.878116+08:00 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] The member was unable to join the group. Local port: 33071'
  107. 2023-10-23T17:10:15.878296+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Sleeping for 5 seconds before retrying to join the group. The
  108. re are 9 more attempt(s) before giving up.'
  109. 2023-10-23T17:10:21.075144+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] 1698052221.040079 pid 28817 xcom_id b039bd31 state xcom_fsm_s
  110. tart action x_fsm_init'
  111. 2023-10-23T17:10:24.265037+08:00 0 [Warning] [MY-010140] [Server] Could not increase number of max_open_files to more than 10000 (request: 65535)
  112. 2023-10-23T17:10:24.465777+08:00 0 [Warning] [MY-011068] [Server] The syntax 'log_slow_slave_statements' is deprecated and will be removed in a future release. Plea
  113. se use log_slow_replica_statements instead.
  114. 2023-10-23T17:10:24.465809+08:00 0 [Warning] [MY-011068] [Server] The syntax 'slave_parallel_type' is deprecated and will be removed in a future release. Please use
  115. replica_parallel_type instead.
  116. 2023-10-23T17:10:24.465812+08:00 0 [Warning] [MY-011069] [Server] The syntax '--replica-parallel-type' is deprecated and will be removed in a future release.
  117. 2023-10-23T17:10:24.465817+08:00 0 [Warning] [MY-011068] [Server] The syntax 'slave_parallel_workers' is deprecated and will be removed in a future release. Please
  118. use replica_parallel_workers instead.
  119. 2023-10-23T17:10:24.465823+08:00 0 [Warning] [MY-011068] [Server] The syntax 'slave_preserve_commit_order' is deprecated and will be removed in a future release. Pl
  120. ease use replica_preserve_commit_order instead.
  121. 2023-10-23T17:10:24.465829+08:00 0 [Warning] [MY-011068] [Server] The syntax 'slave_checkpoint_period' is deprecated and will be removed in a future release. Please
  122. use replica_checkpoint_period instead.
  123. 2023-10-23T17:10:24.465908+08:00 0 [Warning] [MY-010097] [Server] Insecure configuration for --secure-file-priv: Current value does not restrict location of generat
  124. ed files. Consider setting it to a valid, non-empty path.
  125. 2023-10-23T17:10:24.465911+08:00 0 [Warning] [MY-010097] [Server] Insecure configuration for --secure-log-path: Current value does not restrict location of generate
  126. d files. Consider setting it to a valid, non-empty path.
  127. 2023-10-23T17:10:24.465951+08:00 0 [Note] [MY-013932] [Server] BuildID[sha1]=5850d8e16b7845a955d11d6965d9d658fd24b257
  128. 2023-10-23T17:10:24.465954+08:00 0 [Note] [MY-010949] [Server] Basedir set to /usr/local/GreatSQL-8.0.32-24-Linux-glibc2.17-x86_64/.
  129. 2023-10-23T17:10:24.465958+08:00 0 [System] [MY-010116] [Server] /usr/local/GreatSQL-8.0.32-24-Linux-glibc2.17-x86_64/bin/mysqld (mysqld 8.0.32-24) starting as proc
  130. ess 30314
  131. 2023-10-23T17:10:24.473715+08:00 0 [Warning] [MY-012364] [InnoDB] innodb_open_files should not be greater than the open_files_limit.
  132. 2023-10-23T17:10:24.473741+08:00 0 [Note] [MY-012366] [InnoDB] Using Linux native AIO
  133. 2023-10-23T17:10:24.473758+08:00 0 [Warning] [MY-013869] [InnoDB] Ignored deprecated configuration parameter innodb_log_file_size. Used innodb_redo_log_capacity ins
  134. tead.
  135. 2023-10-23T17:10:24.473765+08:00 0 [Warning] [MY-013870] [InnoDB] Ignored deprecated configuration parameter innodb_log_files_in_group. Used innodb_redo_log_capacit
  136. y instead.
  137. 2023-10-23T17:10:24.473943+08:00 0 [Note] [MY-010747] [Server] Plugin 'FEDERATED' is disabled.
  138. 2023-10-23T17:10:24.474012+08:00 0 [Note] [MY-010747] [Server] Plugin 'ndbcluster' is disabled.
  139. 2023-10-23T17:10:24.474027+08:00 0 [Note] [MY-010747] [Server] Plugin 'ndbinfo' is disabled.
  140. 2023-10-23T17:10:24.474034+08:00 0 [Note] [MY-010747] [Server] Plugin 'ndb_transid_mysql_connection_map' is disabled.
  141. 2023-10-23T17:10:24.477236+08:00 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
  142. 2023-10-23T17:10:24.477267+08:00 1 [Note] [MY-013546] [InnoDB] Atomic write enabled
  143. 2023-10-23T17:10:24.477288+08:00 1 [Note] [MY-012932] [InnoDB] PUNCH HOLE support available
  144. 2023-10-23T17:10:24.477299+08:00 1 [Note] [MY-012944] [InnoDB] Uses event mutexes
  145. 2023-10-23T17:10:24.477304+08:00 1 [Note] [MY-012945] [InnoDB] GCC builtin __atomic_thread_fence() is used for memory barrier
  146. 2023-10-23T17:10:24.477310+08:00 1 [Note] [MY-012948] [InnoDB] Compressed tables use zlib 1.2.13
  147. 2023-10-23T17:10:24.479093+08:00 1 [Note] [MY-012951] [InnoDB] Using hardware accelerated crc32 and polynomial multiplication.
  148. 2023-10-23T17:10:24.479387+08:00 1 [Note] [MY-012203] [InnoDB] Directories to scan './'
  149. 2023-10-23T17:10:24.479426+08:00 1 [Note] [MY-012204] [InnoDB] Scanning './'
  150. 2023-10-23T17:10:24.485376+08:00 1 [Note] [MY-012208] [InnoDB] Completed space ID check of 5 files.
  151. 2023-10-23T17:10:24.486187+08:00 1 [Note] [MY-012955] [InnoDB] Initializing buffer pool, total size = 2.000000G, instances = 8, chunk size =128.000000M
  152. 2023-10-23T17:10:24.486209+08:00 1 [Note] [MY-011872] [InnoDB] Setting NUMA memory policy to MPOL_INTERLEAVE
  153. 2023-10-23T17:10:26.508289+08:00 1 [Note] [MY-011874] [InnoDB] Setting NUMA memory policy to MPOL_DEFAULT
  154. 2023-10-23T17:10:26.538786+08:00 1 [Note] [MY-012957] [InnoDB] Completed initialization of buffer pool
  155. 2023-10-23T17:10:26.664916+08:00 0 [Note] [MY-011952] [InnoDB] If the mysqld execution user is authorized, page cleaner and LRU manager thread priority can be chang
  156. ed. See the man page of setpriority().
  157. 2023-10-23T17:10:26.731933+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_0.dblwr' for doublewrite
  158. 2023-10-23T17:10:26.735804+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_1.dblwr' for doublewrite
  159. 2023-10-23T17:10:26.738182+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_2.dblwr' for doublewrite
  160. 2023-10-23T17:10:26.738648+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_3.dblwr' for doublewrite
  161. 2023-10-23T17:10:26.740873+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_4.dblwr' for doublewrite
  162. 2023-10-23T17:10:26.741337+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_5.dblwr' for doublewrite
  163. 2023-10-23T17:10:26.743268+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_6.dblwr' for doublewrite
  164. 2023-10-23T17:10:26.743720+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_7.dblwr' for doublewrite
  165. 2023-10-23T17:10:26.746396+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_8.dblwr' for doublewrite
  166. 2023-10-23T17:10:26.746802+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_9.dblwr' for doublewrite
  167. 2023-10-23T17:10:26.754946+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_10.dblwr' for doublewrite
  168. 2023-10-23T17:10:26.755899+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_11.dblwr' for doublewrite
  169. 2023-10-23T17:10:26.758893+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_12.dblwr' for doublewrite
  170. 2023-10-23T17:10:26.759725+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_13.dblwr' for doublewrite
  171. 2023-10-23T17:10:26.762937+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_14.dblwr' for doublewrite
  172. 2023-10-23T17:10:26.763194+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_15.dblwr' for doublewrite
  173. 2023-10-23T17:10:26.791103+08:00 1 [Note] [MY-013566] [InnoDB] Double write buffer files: 16
  174. 2023-10-23T17:10:26.791182+08:00 1 [Note] [MY-013565] [InnoDB] Double write buffer pages per instance: 4
  175. 2023-10-23T17:10:26.791231+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_0.dblwr' for doublewrite
  176. 2023-10-23T17:10:26.791259+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_1.dblwr' for doublewrite
  177. 2023-10-23T17:10:26.791278+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_2.dblwr' for doublewrite
  178. 2023-10-23T17:10:26.791297+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_3.dblwr' for doublewrite
  179. 2023-10-23T17:10:26.791316+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_4.dblwr' for doublewrite
  180. 2023-10-23T17:10:26.791335+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_5.dblwr' for doublewrite
  181. 2023-10-23T17:10:26.791355+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_6.dblwr' for doublewrite
  182. 2023-10-23T17:10:26.791422+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_7.dblwr' for doublewrite
  183. 2023-10-23T17:10:26.791453+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_8.dblwr' for doublewrite
  184. 2023-10-23T17:10:26.791470+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_9.dblwr' for doublewrite
  185. 2023-10-23T17:10:26.791489+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_10.dblwr' for doublewrite
  186. 2023-10-23T17:10:26.791506+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_11.dblwr' for doublewrite
  187. 2023-10-23T17:10:26.791523+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_12.dblwr' for doublewrite
  188. 2023-10-23T17:10:26.791540+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_13.dblwr' for doublewrite
  189. 2023-10-23T17:10:26.791557+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_14.dblwr' for doublewrite
  190. 2023-10-23T17:10:26.791587+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_15.dblwr' for doublewrite
  191. 2023-10-23T17:10:26.962970+08:00 1 [Note] [MY-013883] [InnoDB] The latest found checkpoint is at lsn = 20671660 in redo log file ./#innodb_redo/#ib_redo0.
  192. 2023-10-23T17:10:26.995701+08:00 1 [Note] [MY-012560] [InnoDB] The log sequence number 20053481 in the system tablespace does not match the log sequence number 2067
  193. 1660 in the redo log files!
  194. 2023-10-23T17:10:27.000907+08:00 1 [Note] [MY-012551] [InnoDB] Database was not shutdown normally!
  195. 2023-10-23T17:10:27.000944+08:00 1 [Note] [MY-012552] [InnoDB] Starting crash recovery.
  196. 2023-10-23T17:10:27.061646+08:00 1 [Note] [MY-013086] [InnoDB] Starting to parse redo log at lsn = 20671529, whereas checkpoint_lsn = 20671660 and start_lsn = 20671
  197. 488
  198. 2023-10-23T17:10:27.061690+08:00 1 [Note] [MY-012550] [InnoDB] Doing recovery: scanned up to log sequence number 20671660
  199. 2023-10-23T17:10:27.121076+08:00 1 [Note] [MY-013083] [InnoDB] Log background threads are being started...
  200. 2023-10-23T17:10:27.282804+08:00 1 [Note] [MY-012532] [InnoDB] Applying a batch of 0 redo log records ...
  201. 2023-10-23T17:10:27.284115+08:00 1 [Note] [MY-012535] [InnoDB] Apply batch completed!
  202. 2023-10-23T17:10:27.284716+08:00 1 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_001'.
  203. 2023-10-23T17:10:27.285180+08:00 1 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_002'.
  204. 2023-10-23T17:10:27.285856+08:00 1 [Note] [MY-012910] [InnoDB] Opened 2 existing undo tablespaces.
  205. 2023-10-23T17:10:27.287149+08:00 1 [Note] [MY-011980] [InnoDB] GTID recovery trx_no: 7318
  206. 2023-10-23T17:10:27.384809+08:00 1 [Note] [MY-013776] [InnoDB] Parallel initialization of rseg complete
  207. 2023-10-23T17:10:27.386421+08:00 1 [Note] [MY-013777] [InnoDB] Time taken to initialize rseg using 2 thread: 99275 ms.
  208. 2023-10-23T17:10:27.386560+08:00 1 [Note] [MY-012255] [InnoDB] Removed temporary tablespace data file: "ibtmp1"
  209. 2023-10-23T17:10:27.386578+08:00 1 [Note] [MY-012923] [InnoDB] Creating shared tablespace for temporary tables
  210. 2023-10-23T17:10:27.386607+08:00 1 [Note] [MY-012265] [InnoDB] Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
  211. 2023-10-23T17:10:27.396242+08:00 1 [Note] [MY-012266] [InnoDB] File './ibtmp1' size is now 12 MB.
  212. 2023-10-23T17:10:27.396455+08:00 1 [Note] [MY-013627] [InnoDB] Scanning temp tablespace dir:'./#innodb_temp/'
  213. 2023-10-23T17:10:27.401950+08:00 1 [Note] [MY-013018] [InnoDB] Created 128 and tracked 128 new rollback segment(s) in the temporary tablespace. 128 are now active.
  214. 2023-10-23T17:10:27.402244+08:00 1 [Note] [MY-012976] [InnoDB] Percona XtraDB (http://www.percona.com) 8.0.32-8.0.32 started; log sequence number 20671670
  215. 2023-10-23T17:10:27.406307+08:00 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
  216. 2023-10-23T17:10:27.439941+08:00 1 [Note] [MY-011089] [Server] Data dictionary restarting version '80023'.
  217. 2023-10-23T17:10:27.531815+08:00 1 [Note] [MY-012357] [InnoDB] Reading DD tablespace files
  218. 2023-10-23T17:10:27.534356+08:00 1 [Note] [MY-012356] [InnoDB] Scanned 7 tablespaces. Validated 7.
  219. 2023-10-23T17:10:27.560140+08:00 1 [Note] [MY-010006] [Server] Using data dictionary with version '80023'.
  220. 2023-10-23T17:10:27.603406+08:00 0 [Note] [MY-011332] [Server] Plugin mysqlx reported: 'IPv6 is available'
  221. 2023-10-23T17:10:27.603493+08:00 0 [Note] [MY-011324] [Server] Plugin mysqlx reported: 'Retrying `bind()` on TCP/IP port 33060'
  222. 2023-10-23T17:10:28.604094+08:00 0 [ERROR] [MY-011292] [Server] Plugin mysqlx reported: 'Preparation of I/O interfaces failed, X Protocol won't be accessible'
  223. 2023-10-23T17:10:28.604142+08:00 0 [ERROR] [MY-011300] [Server] Plugin mysqlx reported: 'Setup of bind-address: '*' port: 33060 failed, `bind()` failed with error:
  224. Address already in use (98). Do you already have another mysqld server running with Mysqlx ?'
  225. 2023-10-23T17:10:28.604151+08:00 0 [ERROR] [MY-013597] [Server] Plugin mysqlx reported: 'Value '*' set to `Mysqlx_bind_address`, X Plugin can't bind to it. Skipping
  226. this value.'
  227. 2023-10-23T17:10:28.604170+08:00 0 [ERROR] [MY-011300] [Server] Plugin mysqlx reported: 'Setup of socket: '/tmp/mysqlx.sock' failed, another process with PID 28816
  228. is using UNIX socket file'
  229. 2023-10-23T17:10:28.604177+08:00 0 [Note] [MY-011322] [Server] Plugin mysqlx reported: 'Please see the MySQL documentation for 'mysqlx_port,mysqlx_bind_address' sys
  230. tem variables to fix the error'
  231. 2023-10-23T17:10:28.604183+08:00 0 [Note] [MY-011322] [Server] Plugin mysqlx reported: 'Please see the MySQL documentation for 'mysqlx_socket' system variables to f
  232. ix the error'
  233. 2023-10-23T17:10:28.642641+08:00 0 [Note] [MY-010902] [Server] Thread priority attribute setting in Resource Group SQL shall be ignored due to unsupported platform
  234. or insufficient privilege.
  235. 2023-10-23T17:10:28.645404+08:00 0 [Note] [MY-010855] [Server] Recovering after a crash using binlog
  236. 2023-10-23T17:10:28.645447+08:00 0 [System] [MY-010229] [Server] Starting XA crash recovery...
  237. 2023-10-23T17:10:28.664329+08:00 0 [Note] [MY-013911] [Server] Crash recovery finished in binlog engine. No attempts to commit, rollback or prepare any transactions
  238. .
  239. 2023-10-23T17:10:28.664395+08:00 0 [Note] [MY-013911] [Server] Crash recovery finished in InnoDB engine. No attempts to commit, rollback or prepare any transactions
  240. .
  241. 2023-10-23T17:10:28.664403+08:00 0 [System] [MY-010232] [Server] XA crash recovery finished.
  242. 2023-10-23T17:10:28.667744+08:00 0 [Note] [MY-012487] [InnoDB] DDL log recovery : begin
  243. 2023-10-23T17:10:28.667944+08:00 0 [Note] [MY-012488] [InnoDB] DDL log recovery : end
  244. 2023-10-23T17:10:28.668071+08:00 0 [Note] [MY-011946] [InnoDB] Loading buffer pool(s) from /data/GreatSQL/3307/ib_buffer_pool
  245. 2023-10-23T17:10:28.737188+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 usin
  246. g them.
  247. 2023-10-23T17:10:28.737228+08:00 0 [Note] [MY-010304] [Server] Skipping generation of SSL certificates as certificate files are present in data directory.
  248. 2023-10-23T17:10:28.739371+08:00 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
  249. 2023-10-23T17:10:28.739475+08:00 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this chan
  250. nel.
  251. 2023-10-23T17:10:28.739527+08:00 0 [Note] [MY-010308] [Server] Skipping generation of RSA key pair through --sha256_password_auto_generate_rsa_keys as key files are
  252. present in data directory.
  253. 2023-10-23T17:10:28.739542+08:00 0 [Note] [MY-010308] [Server] Skipping generation of RSA key pair through --caching_sha2_password_auto_generate_rsa_keys as key fil
  254. es are present in data directory.
  255. 2023-10-23T17:10:28.740062+08:00 0 [Note] [MY-010252] [Server] Server hostname (bind-address): '*'; port: 3307
  256. 2023-10-23T17:10:28.740094+08:00 0 [Note] [MY-010253] [Server] IPv6 is available.
  257. 2023-10-23T17:10:28.740110+08:00 0 [Note] [MY-010264] [Server]   - '::' resolves to '::';
  258. 2023-10-23T17:10:28.740121+08:00 0 [Note] [MY-010251] [Server] Server socket created on IP: '::'.
  259. 2023-10-23T17:10:28.753812+08:00 0 [Note] [MY-011946] [InnoDB] Buffer pool(s) load completed at 231023 17:10:28
  260. 2023-10-23T17:10:28.757085+08:00 0 [Warning] [MY-010604] [Repl] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server
  261. acts as a slave and has his hostname changed!! Please use '--relay-log=localhost-relay-bin' to avoid this problem.
  262. 2023-10-23T17:10:28.758776+08:00 0 [Warning] [MY-013836] [Repl] Relay log recovery on channel with GTID_ONLY=1. The channel will switch to a new relay log and the G
  263. TID protocol will be used to replicate unapplied transactions.
  264. 2023-10-23T17:10:28.763140+08:00 0 [Warning] [MY-013836] [Repl] Relay log recovery on channel with GTID_ONLY=1. The channel will switch to a new relay log and the G
  265. TID protocol will be used to replicate unapplied transactions.
  266. 2023-10-23T17:10:28.763878+08:00 0 [Note] [MY-011025] [Repl] Failed to start slave threads for channel ''.
  267. 2023-10-23T17:10:28.765145+08:00 7 [Note] [MY-010051] [Server] Event Scheduler: scheduler thread started with id 7
  268. 2023-10-23T17:10:28.765251+08:00 0 [System] [MY-010931] [Server] /usr/local/GreatSQL-8.0.32-24-Linux-glibc2.17-x86_64/bin/mysqld: ready for connections. Version: '8
  269. .0.32-24'  socket: '/data/GreatSQL/3307/mysql.sock'  port: 3307  GreatSQL, Release 24, Revision 3714067bc8c.
  270. 2023-10-23T17:10:28.765355+08:00 0 [Note] [MY-011240] [Server] Plugin mysqlx reported: 'Using SSL configuration from MySQL Server'
  271. 2023-10-23T17:10:28.765798+08:00 0 [Note] [MY-011243] [Server] Plugin mysqlx reported: 'Using OpenSSL for TLS connections'
复制代码




全部回复(1)
只看楼主
yejr 2023-10-24 14:06:52
看起来关于MGR这部分似乎没设置正确，可以参考手册再做一遍


RPM安装并构建MGR集群 | GreatSQL官方手册

回复 采纳

举报

周智林

1

主题

0

博客

6

贡献

新手上路

Rank: 1

积分
9
发消息
互动与交流
社区活动
论坛问答
加入社区
贡献者指南
学习与应用
文章博客
文档资料
视频资料
常见问题
发现社区
社区准则
建议反馈
社区之星

合作电话：010-64087828

社区邮箱：greatsql@greatdb.com

社区公众号
社区小助手
QQ群
友情链接
万里数据库开源中国墨天轮开放原子开源基金会OpenEuler
©2022 GreatSQL All Rights Reserved. ( 京ICP备06057874号 )
GMT+8, 2024-11-23 20:56 , Processed in 0.020217 second(s), 13 queries , Redis On.
快速回复 返回顶部 返回列表