运维工作中你遇到过哪些神奇事件？

GreatSQL社区

搜索

重建mgr多主集群后，3个节点的member_role均为SECONDARY

369 7 2023-7-27 11:24

环境
数据库：社区版5.7.28
操作系统：CentOS Linux release 7.6.1810 (Core)
配置文件
  1. [mysql]
  2. no-auto-rehash
  3. socket                              =/data/mysql/3306/tmp/mysql.sock                #   /tmp/mysql.sock
  4. prompt                              ="\\u@\\h \\R:\\m:\\s> [\\d]>"


  7. [mysqld]
  8. ####: for global
  9. user                                =mysql                          #   mysql
  10. basedir                             =/usr/local/mysql              #    /usr/local/mysql/
  11. datadir                             =/data/mysql/3306/data #    /usr/local/mysql/data
  12. tmpdir                              =/data/mysql/3306/tmp
  13. server_id                           =732                            #   0
  14. port                                =3306                           #   3306
  15. character_set_server                =utf8mb4                           #        latin1

  17. max_prepared_stmt_count             =1048576
  18. log_timestamps                      =system                         #   utc
  19. socket                              =/data/mysql/3306/tmp/mysql.sock                #   /tmp/mysql.sock

  21. #
  22. skip_name_resolve                   =1                              #   0

  24. auto_increment_increment             =5

  26. auto_increment_offset               =3

  28. lower_case_table_names              =1                              #   0
  29. secure_file_priv                    =  /tmp/                         #  null
  30. open_files_limit                    =65535                          #   1024
  31. max_connections                     =3000
  32. max_user_connections                =800
  33. innodb_lock_wait_timeout            =20
  34. interactive_timeout                 =600
  35. wait_timeout                        =600
  36. lock_wait_timeout                   =1800
  37. back_log                            =2048
  38. max_prepared_stmt_count             =1048576
  39. thread_stack                        =512K
  40. log_error_verbosity                 =3
  41. explicit_defaults_for_timestamp     =1
  42. external-locking                    =FALSE
  43. thread_cache_size                   =256                              #   9
  44. table_open_cache                    =4096                           #   2000
  45. table_definition_cache              =2048                           #   1400
  46. table_open_cache_instances          =64                            #   16
  47. max_prepared_stmt_count             =1048576                        #
  48. default_time_zone                   ="+8:00"
  49. innodb_undo_directory               =/data/mysql/3306/undolog
  50. max_allowed_packet                  =128M


  53. ####: for binlog
  54. log_bin_trust_function_creators     =on                             #   0
  55. log_bin                             =/data/mysql/3306/binlogs/mysql-bin                      #  off
  56. binlog_rows_query_log_events        =on                             #   off
  57. log_slave_updates                   =on                             #   off
  58. expire_logs_days                    =7                              #   0
  59. binlog_format                       =row
  60. binlog_row_image                    =full
  61. binlog_cache_size                   =4M                          #      65536(64k)
  62. binlog_checksum                     =none
  63. sync_binlog                         =1                              #   1
  64. slave-preserve-commit-order         =ON                             #
  65. log_error                           =err.log                        #
  66. general_log                         =off                            #   off
  67. general_log_file                    =general.log                    #   hostname.log

  69. ####: for slow query log
  70. slow_query_log                      =on                             #    off
  71. slow_query_log_file                 =/data/mysql/3306/slowlog/slow.log
  72. log_queries_not_using_indexes       =on                             #    off
  73. long_query_time                     =1.000000                       #    10.000000
  74. log_throttle_queries_not_using_indexes          =60
  75. log_slow_admin_statements                       =1
  76. log_slow_slave_statements                       =1

  78. ####: for gtid
  79. gtid_executed_compression_period    =1000                          #    1000
  80. gtid_mode                           =on                            #    off
  81. enforce_gtid_consistency            =on                            #    off
  82. binlog_gtid_simple_recovery         =on

  84. ####: for replication
  85. skip_slave_start                    =1                              #
  86. master_info_repository              =table                         #    file
  87. relay_log_info_repository           =table                         #    file
  88. slave_parallel_type                 =logical_clock                 #    database | LOGICAL_CLOCK
  89. slave_parallel_workers              =32                             #    0
  90. rpl_semi_sync_master_enabled        =1                             #    0
  91. rpl_semi_sync_slave_enabled         =1                             #    0
  92. rpl_semi_sync_master_timeout        =1000                          #    1000(1 second)
  93. plugin_load_add                     =semisync_master.so            #
  94. plugin_load_add                     =semisync_slave.so             #
  95. binlog_group_commit_sync_delay      =500                           #    0      500(0.05% seconde)
  96. binlog_group_commit_sync_no_delay_count = 13                       #    0


  99. ####: for innodb
  100. innodb_stats_on_metadata                        =0
  101. default_storage_engine                          =innodb                     #   innodb
  102. default_tmp_storage_engine                      =innodb                     #   innodb
  103. innodb_data_file_path                           =ibdata1:1G:autoextend     #    ibdata1:12M:autoextend
  104. innodb_temp_data_file_path                      =ibtmp1:12M:autoextend:max:4G      #    ibtmp1:12M:autoextend
  105. innodb_buffer_pool_filename                     =ib_buffer_pool             #   ib_buffer_pool
  106. innodb_log_group_home_dir                       =/data/mysql/3306/binlogs/   #  ./
  107. innodb_log_files_in_group                       =4
  108. innodb_log_file_size                            =2G
  109. innodb_file_per_table                           =on                         #   on
  110. innodb_online_alter_log_max_size                =1G                       #   134217728(128M)
  111. innodb_open_files                               =65535                      #   2000
  112. innodb_page_size                                =16k                        #   16384(16k)
  113. innodb_thread_concurrency                       =8                          #   0
  114. innodb_read_io_threads                          =8                          #   4
  115. innodb_write_io_threads                         =8                          #   4
  116. innodb_purge_threads                            =4                          #   4(garbage collection)
  117. innodb_page_cleaners                            =10                          #   4(flush lru list)
  118. innodb_print_all_deadlocks                      =on                         #   off
  119. innodb_deadlock_detect                          =on                         #   on
  120. innodb_lock_wait_timeout                        =50                         #   50
  121. innodb_spin_wait_delay                          =30                          #  6
  122. innodb_autoinc_lock_mode                        =2                          #   1
  123. innodb_io_capacity                              =15000                        #   200
  124. innodb_io_capacity_max                          =20000                       #   2000
  125. #--------Persistent Optimizer Statistics
  126. innodb_stats_auto_recalc                        =on                         #   on
  127. innodb_stats_persistent                         =on                         #   on
  128. innodb_stats_persistent_sample_pages            =64                         #   20
  129. innodb_buffer_pool_instances                    =18
  130. innodb_adaptive_hash_index                      =on                         #   on
  131. innodb_change_buffering                         =all                        #   all
  132. innodb_change_buffer_max_size                   =25                         #   25
  133. innodb_flush_neighbors                          =0                          #   1
  134. innodb_doublewrite                              =on                         #   on
  135. innodb_log_buffer_size                          =32M                        #   16777216(16M)
  136. innodb_flush_log_at_timeout                     =1                          #   1
  137. innodb_flush_log_at_trx_commit                  =1                          #   1
  138. innodb_buffer_pool_size                         =19200M                  #      134217728(128M)
  139. autocommit                                      =1                          #   1
  140. #--------innodb scan resistant
  141. innodb_old_blocks_pct                           =37                         #    37
  142. innodb_old_blocks_time                          =1000                       #    1000
  143. #--------innodb read ahead
  144. innodb_read_ahead_threshold                     =56                         #    56 (0..64)
  145. innodb_random_read_ahead                        =OFF                        #    OFF
  146. #--------innodb buffer pool state
  147. innodb_buffer_pool_dump_pct                     =40                         #    25
  148. innodb_buffer_pool_dump_at_shutdown             =ON                         #    ON
  149. innodb_buffer_pool_load_at_startup              =ON                         #    ON
  150. innodb_flush_method                             = O_DIRECT
  151. innodb_deadlock_detect                          =0
  152. innodb_print_all_deadlocks                      =1

  154. sort_buffer_size                    =4M
  155. join_buffer_size                    =4M
  156. innodb_status_file                  =1
  157. innodb_status_output                =0
  158. innodb_status_output_locks          =0
  159. innodb_checksum_algorithm           =crc32
  160. innodb_max_dirty_pages_pct          =50
  161. innodb_lru_scan_depth               =4096
  162. read_buffer_size                    =8M
  163. read_rnd_buffer_size                =4M
  164. key_buffer_size                     =32M
  165. bulk_insert_buffer_size             =64M
  166. tmp_table_size                      =96M
  167. max_heap_table_size                 =96M
  168. myisam_sort_buffer_size             =128M
  169. myisam_max_sort_file_size           =10G
  170. myisam_repair_threads               =1
  171. min_examined_row_limit              =1000

  173. innodb_checksums                                =1
  174. innodb_rollback_on_timeout                      =1
  175. innodb_rollback_segments                        =128
  176. innodb_sync_spin_loops                          =100
  177. transaction_isolation                           =READ-COMMITTED
  178. innodb_flush_sync                               =0
  179. relay_log_recovery                              =on
  180. max_binlog_size                                 =1024M
  181. max_binlog_cache_size                           =2G
  182. binlog_order_commits                            =OFF
  183. innodb_large_prefix                             =1
  184. innodb_strict_mode                              =1
  185. loose_innodb_numa_interleave                    =1
  186. innodb_max_undo_log_size                        =4G
  187. innodb_undo_logs                                =128
  188. innodb_undo_tablespaces                         =95
  189. innodb_undo_log_truncate                        =on
  190. innodb_purge_rseg_truncate_frequency            =128
  191. innodb_sort_buffer_size                         =32M
  192. query_cache_size                                =128
  193. query_cache_type                                =0
  194. internal_tmp_disk_storage_engine                =innoDB
  195. ####: for mysql group replication
  196. loose-group_replication_recovery_retry_count          =10                                         #   10
  197. loose-group_replication_recovery_reconnect_interval   =60                                         #   60
  198. loose-group_replication_allow_local_disjoint_gtids_join=off                                       #   off
  199. loose-group_replication_allow_local_lower_version_join=off                                        #   off
  200. loose-group_replication_ip_whitelist                  ="10. xxx. xxx.21,10. xxx. xxx.40,10. xxx. xxx.8"  #   AUTOMATIC
  201. loose-transaction_write_set_extraction                =XXHASH64                                   #     off
  202. loose-group_replication_group_name                    ="aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa"     #
  203. loose-group_replication_start_on_boot                 =off                                        #     off
  204. loose-group_replication_bootstrap_group               =off                                        #     off
  205. loose-group_replication_single_primary_mode           =off                                        #
  206. loose-group_replication_enforce_update_everywhere_checks=on   #
  207. loose-group_replication_gtid_assignment_block_size    =1000000                                    #   1000000
  208. loose-group_replication_poll_spin_loops               =0                                          #   0
  209. loose-group_replication_compression_threshold         =1024                                       #   1000000
  210. loose-group_replication_flow_control_mode             =QUOTA                                      #   QUOTA
  211. loose-group_replication_local_address                 ="10.xxx.xxx.8:33060"
  212. loose-group_replication_group_seeds                   ="10.xxx.xxx.21:33060,10. xxx. xxx.40:33060,10. xxx. xxx.8:33060"

  214. slave_rows_search_algorithms                      ='INDEX_SCAN,HASH_SCAN'
  215. loose-binlog_transaction_dependency_tracking      =WRITESET_SESSION
  216. loose-transaction_write_set_extraction            =XXHASH64
  217. slave_preserve_commit_order                       =1
  218. slave_net_timeout                                 =60
  219. log_slave_updates                                 =on
  220. skip_slave_start                                  =0

  222. max_relay_log_size                                =128M
  223. relay_log                                         =relay-bin

  225. ####  for performance_schema
  226. performance_schema                                                      =on    #    on
  227. performance_schema_consumer_global_instrumentation                      =on    #    on
  228. performance_schema_consumer_thread_instrumentation                      =on    #    on
  229. performance_schema_consumer_events_stages_current                       =on    #    off
  230. performance_schema_consumer_events_stages_history                       =on    #    off
  231. performance_schema_consumer_events_stages_history_long                  =off   #    off
  232. performance_schema_consumer_statements_digest                           =on    #    on
  233. performance_schema_consumer_events_statements_current                   =on    #    on
  234. performance_schema_consumer_events_statements_history                   =on    #    on
  235. performance_schema_consumer_events_statements_history_long              =off   #    off
  236. performance_schema_consumer_events_waits_current                        =on    #    off
  237. performance_schema_consumer_events_waits_history                        =on    #    off
  238. performance_schema_consumer_events_waits_history_long                   =off   #    off
  239. performance-schema-consumer-events-transactions-history-long            =ON
  240. performance-schema-instrument                                           ='stage/%=ON'
  241. performance_schema_digests_size = 40000
  242. performance_schema_max_table_instances = 40000
  243. performance_schema_max_sql_text_length = 4096
  244. performance_schema_max_digest_length = 4096


  247. #innodb monitor
  248. innodb_monitor_enable="module_innodb"
  249. innodb_monitor_enable="module_server"
  250. innodb_monitor_enable="module_dml"
  251. innodb_monitor_enable="module_ddl"
  252. innodb_monitor_enable="module_trx"
  253. innodb_monitor_enable="module_os"
  254. innodb_monitor_enable="module_purge"
  255. innodb_monitor_enable="module_log"
  256. innodb_monitor_enable="module_lock"
  257. innodb_monitor_enable="module_buffer"
  258. innodb_monitor_enable="module_index"
  259. innodb_monitor_enable="module_ibuf_system"
  260. innodb_monitor_enable="module_buffer_page"
  261. innodb_monitor_enable="module_adaptive_hash"
复制代码




现象：mgr集群的三个节点member_role均为SECONDARY

  1. root@localhost 10:43:06> [(none)]>SELECT      MEMBER_ID,     MEMBER_HOST,     MEMBER_PORT,     MEMBER_STATE,     IF(global_status.VARIABLE_NAME IS NOT NULL,         'PRIMARY',         'SECONDARY') AS MEMBER_ROLE FROM     performance_schema.replication_group_members         LEFT JOIN     performance_schema.global_status ON global_status.VARIABLE_NAME = 'group_replication_primary_member'         AND global_status.VARIABLE_VALUE = replication_group_members.MEMBER_ID;
  2. +--------------------------------------+-----------------+-------------+--------------+-------------+
  3. | MEMBER_ID                            | MEMBER_HOST     | MEMBER_PORT | MEMBER_STATE | MEMBER_ROLE |
  4. +--------------------------------------+-----------------+-------------+--------------+-------------+
  5. | 7f6e3726-2c21-11ee-ae25-fa163e162e50 | xxxx-bS28 |        3306 | ONLINE       | SECONDARY   |
  6. | 994ec483-2c22-11ee-8470-fa163e5d1eb9 | xxxx-3V4E |        3306 | ONLINE       | SECONDARY   |
  7. | dcc74dde-dd8c-11ec-8543-fa163e85107c | xxxx-yYqW |        3306 | ONLINE       | SECONDARY   |
  8. +--------------------------------------+-----------------+-------------+--------------+-------------+
  9. 3 rows in set (0.00 sec)
复制代码


日志（包含服务启动、重组mgr的所有日志）
引导节点（业务访问该节点）
  1. 2023-07-27T10:13:08.054418+08:00 1476400 [Note] Plugin group_replication reported: 'Group communication SSL configuration: group_replication_ssl_mode: "DISABLED"'
  2. 2023-07-27T10:13:08.054801+08:00 1476400 [Warning] Plugin group_replication reported: '[GCS] Automatically adding IPv4 localhost address to the whitelist. It is mandatory that it is added.'
  3. 2023-07-27T10:13:08.054884+08:00 1476400 [Note] Plugin group_replication reported: '[GCS] SSL was not enabled'
  4. 2023-07-27T10:13:08.054905+08:00 1476400 [Note] Plugin group_replication reported: 'Initialized group communication with configuration: group_replication_group_name: "aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa"; group_replication_local_address: "10.202.149.21:33060"; group_replication_group_seeds: "10.202.149.21:33060,10.202.149.40:33060,10.202.149.8:33060"; group_replication_bootstrap_group: false; group_replication_poll_spin_loops: 0; group_replication_compression_threshold: 1024; group_replication_ip_whitelist: "10.202.149.21,10.202.149.40,10.202.149.8"'
  5. 2023-07-27T10:13:08.054933+08:00 1476400 [Note] Plugin group_replication reported: '[GCS] Configured number of attempts to join: 0'
  6. 2023-07-27T10:13:08.054939+08:00 1476400 [Note] Plugin group_replication reported: '[GCS] Configured time between attempts to join: 5 seconds'
  7. 2023-07-27T10:13:08.054970+08:00 1476400 [Note] Plugin group_replication reported: 'Member configuration: member_id: 147; member_uuid: "dcc74dde-dd8c-11ec-8543-fa163e85107c"; single-primary mode: "false"; group_replication_auto_increment_increment: 7; '
  8. 2023-07-27T10:13:08.151248+08:00 1476985 [Note] 'CHANGE MASTER TO FOR CHANNEL 'group_replication_applier' executed'. Previous state master_host='<NULL>', master_port= 0, master_log_file='', master_log_pos= 70, master_bind=''. New state master_host='<NULL>', master_port= 0, master_log_file='', master_log_pos= 4, master_bind=''.
  9. 2023-07-27T10:13:08.426976+08:00 1476988 [Note] Slave SQL thread for channel 'group_replication_applier' initialized, starting replication in log 'FIRST' at position 0, relay log './relay-bin-group_replication_applier.000007' position: 4
  10. 2023-07-27T10:13:08.427057+08:00 1476400 [Note] Plugin group_replication reported: 'Group Replication applier module successfully initialized!'
  11. 2023-07-27T10:13:08.483077+08:00 0 [Note] Plugin group_replication reported: 'XCom protocol version: 3'
  12. 2023-07-27T10:13:08.483121+08:00 0 [Note] Plugin group_replication reported: 'XCom initialized and ready to accept incoming connections on port 33060'
  13. 2023-07-27T10:13:08.484233+08:00 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to 10.202.149.40:33060 on local port: 33060.'
  14. 2023-07-27T10:13:08.484544+08:00 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to 10.202.149.8:33060 on local port: 33060.'
  15. 2023-07-27T10:13:08.484820+08:00 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to 10.202.149.40:33060 on local port: 33060.'
  16. 2023-07-27T10:13:08.485070+08:00 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to 10.202.149.8:33060 on local port: 33060.'
  17. 2023-07-27T10:13:08.485281+08:00 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to 10.202.149.40:33060 on local port: 33060.'
  18. 2023-07-27T10:13:08.485487+08:00 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to 10.202.149.8:33060 on local port: 33060.'
  19. 2023-07-27T10:13:08.485759+08:00 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to 10.202.149.40:33060 on local port: 33060.'
  20. 2023-07-27T10:13:08.485916+08:00 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to 10.202.149.8:33060 on local port: 33060.'
  21. 2023-07-27T10:13:08.486112+08:00 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to 10.202.149.40:33060 on local port: 33060.'
  22. 2023-07-27T10:13:08.486278+08:00 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to 10.202.149.8:33060 on local port: 33060.'
  23. 2023-07-27T10:13:08.486547+08:00 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to 10.202.149.40:33060 on local port: 33060.'
  24. 2023-07-27T10:13:08.486749+08:00 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to 10.202.149.8:33060 on local port: 33060.'
  25. 2023-07-27T10:13:08.486969+08:00 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to 10.202.149.40:33060 on local port: 33060.'
  26. 2023-07-27T10:13:08.487109+08:00 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to 10.202.149.8:33060 on local port: 33060.'
  27. 2023-07-27T10:13:08.487276+08:00 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to 10.202.149.40:33060 on local port: 33060.'
  28. 2023-07-27T10:13:08.487513+08:00 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to 10.202.149.8:33060 on local port: 33060.'
  29. 2023-07-27T10:13:08.487750+08:00 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to 10.202.149.40:33060 on local port: 33060.'
  30. 2023-07-27T10:13:08.487961+08:00 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to 10.202.149.8:33060 on local port: 33060.'
  31. 2023-07-27T10:13:08.488237+08:00 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to 10.202.149.40:33060 on local port: 33060.'
  32. 2023-07-27T10:13:08.488478+08:00 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to 10.202.149.8:33060 on local port: 33060.'
  33. 2023-07-27T10:13:08.488500+08:00 0 [ERROR] Plugin group_replication reported: '[GCS] Error connecting to all peers. Member join failed. Local port: 33060'
  34. 2023-07-27T10:13:08.491072+08:00 0 [Warning] Plugin group_replication reported: 'read failed'
  35. 2023-07-27T10:13:08.625397+08:00 0 [ERROR] Plugin group_replication reported: '[GCS] The member was unable to join the group. Local port: 33060'
  36. 2023-07-27T10:14:08.427315+08:00 1476400 [ERROR] Plugin group_replication reported: 'Timeout on wait for view after joining group'
  37. 2023-07-27T10:14:08.427382+08:00 1476400 [Note] Plugin group_replication reported: 'Requesting to leave the group despite of not being a member'
  38. 2023-07-27T10:14:08.427405+08:00 1476400 [ERROR] Plugin group_replication reported: '[GCS] The member is leaving a group without being on one.'
  39. 2023-07-27T10:14:08.553167+08:00 1476988 [Note] Error reading relay log event for channel 'group_replication_applier': slave SQL thread was killed
  40. 2023-07-27T10:14:08.554358+08:00 1476988 [Note] Slave SQL thread for channel 'group_replication_applier' exiting, replication stopped in log 'FIRST' at position 0
  41. 2023-07-27T10:14:08.614422+08:00 1476985 [Note] Plugin group_replication reported: 'The group replication applier thread was killed'
  42. 2023-07-27T10:14:09.615044+08:00 1476400 [Note] Aborted connection 1476400 to db: 'unconnected' user: 'root' host: 'localhost' (The server is not configured properly to be an active member of )
  43. 2023-07-27T10:14:09.615600+08:00 1477044 [Note] Plugin group_replication reported: 'Group communication SSL configuration: group_replication_ssl_mode: "DISABLED"'
  44. 2023-07-27T10:14:09.615754+08:00 1477044 [Warning] Plugin group_replication reported: '[GCS] Automatically adding IPv4 localhost address to the whitelist. It is mandatory that it is added.'
  45. 2023-07-27T10:14:09.615813+08:00 1477044 [Note] Plugin group_replication reported: '[GCS] SSL was not enabled'
  46. 2023-07-27T10:14:09.615831+08:00 1477044 [Note] Plugin group_replication reported: 'Initialized group communication with configuration: group_replication_group_name: "aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa"; group_replication_local_address: "10.202.149.21:33060"; group_replication_group_seeds: "10.202.149.21:33060,10.202.149.40:33060,10.202.149.8:33060"; group_replication_bootstrap_group: true; group_replication_poll_spin_loops: 0; group_replication_compression_threshold: 1024; group_replication_ip_whitelist: "10.202.149.21,10.202.149.40,10.202.149.8"'
  47. 2023-07-27T10:14:09.615853+08:00 1477044 [Note] Plugin group_replication reported: '[GCS] Configured number of attempts to join: 0'
  48. 2023-07-27T10:14:09.615859+08:00 1477044 [Note] Plugin group_replication reported: '[GCS] Configured time between attempts to join: 5 seconds'
  49. 2023-07-27T10:14:09.615883+08:00 1477044 [Note] Plugin group_replication reported: 'Member configuration: member_id: 147; member_uuid: "dcc74dde-dd8c-11ec-8543-fa163e85107c"; single-primary mode: "false"; group_replication_auto_increment_increment: 7; '
  50. 2023-07-27T10:14:09.616302+08:00 1477056 [Note] 'CHANGE MASTER TO FOR CHANNEL 'group_replication_applier' executed'. Previous state master_host='<NULL>', master_port= 0, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='<NULL>', master_port= 0, master_log_file='', master_log_pos= 4, master_bind=''.
  51. 2023-07-27T10:14:09.974034+08:00 1477059 [Note] Slave SQL thread for channel 'group_replication_applier' initialized, starting replication in log 'FIRST' at position 0, relay log './relay-bin-group_replication_applier.000007' position: 4
  52. 2023-07-27T10:14:09.974062+08:00 1477044 [Note] Plugin group_replication reported: 'Group Replication applier module successfully initialized!'
  53. 2023-07-27T10:14:09.974483+08:00 0 [Note] Plugin group_replication reported: 'XCom protocol version: 3'
  54. 2023-07-27T10:14:09.974514+08:00 0 [Note] Plugin group_replication reported: 'XCom initialized and ready to accept incoming connections on port 33060'
  55. 2023-07-27T10:14:10.976496+08:00 0 [Note] Plugin group_replication reported: 'Group membership changed to RightCloud-yYqW:3306 on view 16904240509758596:1.'
  56. 2023-07-27T10:14:10.976720+08:00 1477094 [Note] Plugin group_replication reported: 'Only one server alive. Declaring this server as online within thereplication group'
  57. 2023-07-27T10:14:11.280238+08:00 0 [Note] Plugin group_replication reported: 'This server was declared online within the replication group'
  58. 2023-07-27T10:15:00.405678+08:00 1476394 [Warning] InnoDB: Cannot add field `BE_xid_297` in table `tmp`.`#sql_1c95_0` because after adding it, the row size is 8138 which is greater than maximum allowed size (8126) for a record on index leaf page.
  59. 2023-07-27T10:15:39.103822+08:00 0 [Note] Plugin group_replication reported: 'Members joined the group: RightCloud-3V4E:3306'
  60. 2023-07-27T10:15:39.103923+08:00 0 [Note] Plugin group_replication reported: 'Group membership changed to RightCloud-3V4E:3306, RightCloud-yYqW:3306 on view 16904240509758596:2.'
  61. 2023-07-27T10:15:39.458087+08:00 1477114 [Note] Start binlog_dump to master_thread_id(1477114) slave_server(732), pos(, 4)
  62. 2023-07-27T10:15:39.458142+08:00 1477114 [Note] Start semi-sync binlog_dump to slave (server_id: 732), pos(, 4)
  63. 2023-07-27T10:15:45.884224+08:00 0 [Note] Semi-sync replication switched ON at (mysql-bin.000359, 355308799)
  64. 2023-07-27T10:16:06.098421+08:00 0 [Note] Plugin group_replication reported: 'Members joined the group: RightCloud-bS28:3306'
  65. 2023-07-27T10:16:06.098497+08:00 0 [Note] Plugin group_replication reported: 'Group membership changed to RightCloud-bS28:3306, RightCloud-3V4E:3306,RightCloud-yYqW:3306 on view 16904240509758596:3.'
  66. 2023-07-27T10:16:06.793296+08:00 1477130 [Note] Start binlog_dump to master_thread_id(1477130) slave_server(878), pos(, 4)
  67. 2023-07-27T10:16:06.793338+08:00 1477130 [Note] Start semi-sync binlog_dump to slave (server_id: 878), pos(, 4)
  68. 2023-07-27T10:17:24.291513+08:00 1476493 [Warning] InnoDB: Cannot add field `BE_xid_297` in table `tmp`.`#sql_1c95_0` because after adding it, the row size is 8138 which is greater than maximum allowed size (8126) for a record on index leaf page.
  69. 2023-07-27T10:17:24.464185+08:00 1476493 [Warning] InnoDB: Cannot add field `BE_xid_297` in table `tmp`.`#sql_1c95_0` because after adding it, the row size is 8138 which is greater than maximum allowed size (8126) for a record on index leaf page.
  70. 2023-07-27T10:18:33.931105+08:00 0 [ERROR] /usr/local/mysql/bin/mysqld: Got an error reading communication packets
  71. 2023-07-27T10:18:34.396653+08:00 0 [Note] Plugin group_replication reported: 'The member with address RightCloud-3V4E:3306 was declared online withinthe replication group'
  72. 2023-07-27T10:18:34.976883+08:00 1477114 [ERROR] Semi-sync master failed on net_flush() before waiting for slave reply
  73. 2023-07-27T10:18:35.070085+08:00 1477114 [Note] Stop semi-sync binlog_dump to slave (server_id: 732)
  74. 2023-07-27T10:18:35.070159+08:00 1477114 [Note] Aborted connection 1477114 to db: 'unconnected' user: 'repl' host: '10.202.149.8' (Found net error)
  75. 2023-07-27T10:18:51.546250+08:00 0 [ERROR] /usr/local/mysql/bin/mysqld: Got an error reading communication packets
  76. 2023-07-27T10:18:52.118308+08:00 0 [Note] Plugin group_replication reported: 'The member with address RightCloud-bS28:3306 was declared online withinthe replication group'
  77. 2023-07-27T10:18:54.908584+08:00 1477130 [ERROR] Semi-sync master failed on net_flush() before waiting for slave reply
  78. 2023-07-27T10:18:54.908671+08:00 1477130 [Note] Stop semi-sync binlog_dump to slave (server_id: 878)
  79. 2023-07-27T10:18:54.908700+08:00 1477130 [Note] Aborted connection 1477130 to db: 'unconnected' user: 'repl' host: '10.202.149.40' (Found net error)
  80. 2023-07-27T10:18:55.842577+08:00 1476456 [Warning] Timeout waiting for reply of binlog (file: mysql-bin.000359, pos: 355331918), semi-sync up to filemysql-bin.000359, position 355331309.
  81. 2023-07-27T10:18:55.842629+08:00 1476456 [Note] Semi-sync replication switched OFF.
复制代码


添加一个节点 （注，因为备份是昨天的，添加节点后，MEMBER_STATE 处于revovering了一段时间）
  1. 2023-07-27T10:01:13.819051+08:00 0 [Warning] Insecure configuration for --secure-file-priv: Location is accessible to all OS users. Consider choosinga different directory.
  2. 2023-07-27T10:01:13.819303+08:00 0 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.7.28-log) starting as process 9821 ...
  3. 2023-07-27T10:01:13.896244+08:00 0 [Note] InnoDB: PUNCH HOLE support available
  4. 2023-07-27T10:01:13.896332+08:00 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
  5. 2023-07-27T10:01:13.896345+08:00 0 [Note] InnoDB: Uses event mutexes
  6. 2023-07-27T10:01:13.896351+08:00 0 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
  7. 2023-07-27T10:01:13.896356+08:00 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
  8. 2023-07-27T10:01:13.896360+08:00 0 [Note] InnoDB: Using Linux native AIO
  9. 2023-07-27T10:01:13.897900+08:00 0 [Note] InnoDB: Number of pools: 1
  10. 2023-07-27T10:01:13.898088+08:00 0 [Note] InnoDB: Using CPU crc32 instructions
  11. 2023-07-27T10:01:13.904598+08:00 0 [Note] InnoDB: Initializing buffer pool, total size = 20.25G, instances = 18, chunk size = 128M
  12. 2023-07-27T10:01:13.904639+08:00 0 [Note] InnoDB: Setting NUMA memory policy to MPOL_INTERLEAVE
  13. 2023-07-27T10:01:14.994941+08:00 0 [Note] InnoDB: Setting NUMA memory policy to MPOL_DEFAULT
  14. 2023-07-27T10:01:14.994992+08:00 0 [Note] InnoDB: Completed initialization of buffer pool
  15. 2023-07-27T10:01:15.126844+08:00 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
  16. 2023-07-27T10:01:15.635872+08:00 0 [Note] InnoDB: Opened 95 undo tablespaces
  17. 2023-07-27T10:01:15.635908+08:00 0 [Note] InnoDB: 95 undo tablespaces made active
  18. 2023-07-27T10:01:15.636151+08:00 0 [Note] InnoDB: Highest supported file format is Barracuda.
  19. 2023-07-27T10:01:27.515300+08:00 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
  20. 2023-07-27T10:01:27.515345+08:00 0 [Note] InnoDB: Creating shared tablespace for temporary tables
  21. 2023-07-27T10:01:27.515426+08:00 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
  22. 2023-07-27T10:01:27.645213+08:00 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
  23. 2023-07-27T10:01:27.646275+08:00 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
  24. 2023-07-27T10:01:27.646330+08:00 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
  25. 2023-07-27T10:01:27.647214+08:00 0 [Note] InnoDB: Waiting for purge to start
  26. 2023-07-27T10:01:27.697476+08:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 12571ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
  27. 2023-07-27T10:01:27.705459+08:00 0 [Note] InnoDB: 5.7.28 started; log sequence number 383636317736
  28. 2023-07-27T10:01:27.705771+08:00 0 [Note] InnoDB: Loading buffer pool(s) from /data/mysql/3306/data/ib_buffer_pool
  29. 2023-07-27T10:01:27.706034+08:00 0 [Note] Plugin 'FEDERATED' is disabled.
  30. 2023-07-27T10:01:27.775126+08:00 0 [Note] Semi-sync replication initialized for transactions.
  31. 2023-07-27T10:01:27.775166+08:00 0 [Note] Semi-sync replication enabled on the master.
  32. 2023-07-27T10:01:27.775265+08:00 0 [Note] Starting ack receiver thread
  33. 2023-07-27T10:01:27.853561+08:00 0 [Note] Salting uuid generator variables, current_pid: 9821, server_start_time: 1690423273, bytes_sent: 0,
  34. 2023-07-27T10:01:27.853651+08:00 0 [Note] Generated uuid: '7f6e3726-2c21-11ee-ae25-fa163e162e50', server_start_time: 2764365747965785670, bytes_sent:625503232
  35. 2023-07-27T10:01:27.853675+08:00 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 7f6e3726-2c21-11ee-ae25-fa163e162e50.
  36. 2023-07-27T10:01:29.432471+08:00 0 [Note] Auto generated SSL certificates are placed in data directory.
  37. 2023-07-27T10:01:29.433269+08:00 0 [Warning] CA certificate ca.pem is self signed.
  38. 2023-07-27T10:01:29.740596+08:00 0 [Note] Auto generated RSA key files are placed in data directory.
  39. 2023-07-27T10:01:29.740849+08:00 0 [Note] Server hostname (bind-address): '*'; port: 3306
  40. 2023-07-27T10:01:29.740897+08:00 0 [Note] IPv6 is available.
  41. 2023-07-27T10:01:29.740918+08:00 0 [Note]   - '::' resolves to '::';
  42. 2023-07-27T10:01:29.740935+08:00 0 [Note] Server socket created on IP: '::'.
  43. 2023-07-27T10:01:30.217230+08:00 0 [Note] Relay log recovery skipped for group replication channel.
  44. 2023-07-27T10:01:30.217263+08:00 0 [Warning] Recovery from master pos 70 and file  for channel 'group_replication_applier'. Previous relay log pos and relay log file had been set to 4, ./relay-bin-group_replication_applier.000007 respectively.
  45. 2023-07-27T10:01:30.247231+08:00 0 [Note] Relay log recovery skipped for group replication channel.
  46. 2023-07-27T10:01:30.247257+08:00 0 [Warning] 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, ./relay-bin-group_replication_recovery.000006 respectively.
  47. 2023-07-27T10:01:30.251253+08:00 0 [Note] Failed to start slave threads for channel ''
  48. 2023-07-27T10:01:30.257672+08:00 0 [Note] Event Scheduler: Loaded 0 events
  49. 2023-07-27T10:01:30.258178+08:00 0 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
  50. Version: '5.7.28-log'  socket: '/data/mysql/3306/tmp/mysql.sock'  port: 3306  MySQL Community Server (GPL)
  51. 2023-07-27T10:05:04.680378+08:00 3 [Note] @@GLOBAL.GTID_PURGED was changed from '' to 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-52762013,
  52. dcc74dde-dd8c-11ec-8543-fa163e85107c:1-15336730'.
  53. 2023-07-27T10:05:04.680413+08:00 3 [Note] @@GLOBAL.GTID_EXECUTED was changed from '' to 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-52762013,
  54. dcc74dde-dd8c-11ec-8543-fa163e85107c:1-15336730'.
  55. 2023-07-27T10:16:02.893031+08:00 3 [Note] Plugin group_replication reported: 'Group communication SSL configuration: group_replication_ssl_mode: "DISABLED"'
  56. 2023-07-27T10:16:02.893344+08:00 3 [Warning] Plugin group_replication reported: '[GCS] Automatically adding IPv4 localhost address to the whitelist. It is mandatory that it is added.'
  57. 2023-07-27T10:16:02.893403+08:00 3 [Note] Plugin group_replication reported: '[GCS] SSL was not enabled'
  58. 2023-07-27T10:16:02.893420+08:00 3 [Note] Plugin group_replication reported: 'Initialized group communication with configuration: group_replication_group_name: "aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa"; group_replication_local_address: "10.202.149.40:33060"; group_replication_group_seeds: "10.202.149.21:33060,10.202.149.40:33060,10.202.149.8:33060"; group_replication_bootstrap_group: false; group_replication_poll_spin_loops: 0; group_replication_compression_threshold: 1024; group_replication_ip_whitelist: "10.202.149.21,10.202.149.40,10.202.149.8"'
  59. 2023-07-27T10:16:02.893444+08:00 3 [Note] Plugin group_replication reported: '[GCS] Configured number of attempts to join: 0'
  60. 2023-07-27T10:16:02.893450+08:00 3 [Note] Plugin group_replication reported: '[GCS] Configured time between attempts to join: 5 seconds'
  61. 2023-07-27T10:16:02.893471+08:00 3 [Note] Plugin group_replication reported: 'Member configuration: member_id: 878; member_uuid: "7f6e3726-2c21-11ee-ae25-fa163e162e50"; single-primary mode: "false"; group_replication_auto_increment_increment: 7; '
  62. 2023-07-27T10:16:02.893711+08:00 5 [Note] Plugin group_replication reported: 'Detected previous RESET MASTER invocation or an issue exists in the group replication applier relay log. Purging existing applier logs.'
  63. 2023-07-27T10:16:02.999421+08:00 5 [Note] 'CHANGE MASTER TO FOR CHANNEL 'group_replication_applier' executed'. Previous state master_host='', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='<NULL>', master_port= 0, master_log_file='', master_log_pos=4, master_bind=''.
  64. 2023-07-27T10:16:03.879192+08:00 8 [Note] Slave SQL thread for channel 'group_replication_applier' initialized, starting replication in log 'FIRST' at position 0, relay log './relay-bin-group_replication_applier.000001' position: 4
  65. 2023-07-27T10:16:03.879231+08:00 3 [Note] Plugin group_replication reported: 'Group Replication applier module successfully initialized!'
  66. 2023-07-27T10:16:03.898626+08:00 0 [Note] Plugin group_replication reported: 'XCom protocol version: 3'
  67. 2023-07-27T10:16:03.898676+08:00 0 [Note] Plugin group_replication reported: 'XCom initialized and ready to accept incoming connections on port 33060'
  68. 2023-07-27T10:16:06.098796+08:00 0 [Note] Plugin group_replication reported: 'Group membership changed to RightCloud-bS28:3306, RightCloud-3V4E:3306,RightCloud-yYqW:3306 on view 16904240509758596:3.'
  69. 2023-07-27T10:16:06.098815+08:00 43 [Note] Plugin group_replication reported: 'Establishing group recovery connection with a possible donor. Attempt 1/10'
  70. 2023-07-27T10:16:06.254185+08:00 43 [Note] '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='RightCloud-yYqW', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''.
  71. 2023-07-27T10:16:06.360214+08:00 43 [Note] Plugin group_replication reported: 'Establishing connection to a group replication recovery donor dcc74dde-dd8c-11ec-8543-fa163e85107c at RightCloud-yYqW port: 3306.'
  72. 2023-07-27T10:16:06.360595+08:00 44 [Note] Slave I/O thread: Start semi-sync replication to master 'repl@RightCloud-yYqW:3306' in log 'FIRST' at position 4
  73. 2023-07-27T10:16:06.360649+08:00 44 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
  74. 2023-07-27T10:16:06.362156+08:00 44 [Note] Slave I/O thread for channel 'group_replication_recovery': connected to master 'repl@RightCloud-yYqW:3306',replication started in log 'FIRST' at position 4
  75. 2023-07-27T10:16:06.790593+08:00 45 [Note] Slave SQL thread for channel 'group_replication_recovery' initialized, starting replication in log 'FIRST'at position 0, relay log './relay-bin-group_replication_recovery.000001' position: 4
  76. 2023-07-27T10:16:08.656698+08:00 46 [Warning] Timeout waiting for reply of binlog (file: mysql-bin.000001, pos: 739), semi-sync up to file , position0.
  77. 2023-07-27T10:16:08.656733+08:00 46 [Note] Semi-sync replication switched OFF.
  78. 2023-07-27T10:18:09.039868+08:00 45 [Note] Multi-threaded slave statistics for channel 'group_replication_recovery': seconds elapsed = 123; events assigned = 63489; worker queues filled over overrun level = 0; waited due a Worker queue full = 0; waited due the total size = 0; waited at clock conflicts = 118023348100 waited (count) when Workers occupied = 0 waited when Workers occupied = 0
  79. 2023-07-27T10:18:34.396897+08:00 0 [Note] Plugin group_replication reported: 'The member with address RightCloud-3V4E:3306 was declared online withinthe replication group'
  80. 2023-07-27T10:18:51.525572+08:00 43 [Note] Plugin group_replication reported: 'Terminating existing group replication donor connection and purging the corresponding logs.'
  81. 2023-07-27T10:18:51.539904+08:00 45 [Note] Slave SQL thread for channel 'group_replication_recovery' exiting, replication stopped in log 'mysql-bin.000359' at position 355311821
  82. 2023-07-27T10:18:51.546410+08:00 44 [Note] Slave I/O thread killed while reading event for channel 'group_replication_recovery'
  83. 2023-07-27T10:18:51.546445+08:00 44 [Note] Slave I/O thread exiting for channel 'group_replication_recovery', read up to log 'mysql-bin.000359', position 355331309
  84. 2023-07-27T10:18:51.623707+08:00 43 [Note] 'CHANGE MASTER TO FOR CHANNEL 'group_replication_recovery' executed'. Previous state master_host='RightCloud-yYqW', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='<NULL>', master_port= 0, master_log_file='', master_log_pos= 4, master_bind=''.
  85. 2023-07-27T10:18:52.118579+08:00 0 [Note] Plugin group_replication reported: 'This server was declared online within the replication group'
  86. 2023-07-27T10:31:46.743478+08:00 0 [Note] InnoDB: Buffer pool(s) load completed at 230727 10:31:46
  87. 2023-07-27T10:40:00.055967+08:00 8 [Note] Multi-threaded slave statistics for channel 'group_replication_applier': seconds elapsed = 1437; events assigned = 2049; worker queues filled over overrun level = 0; waited due a Worker queue full = 0; waited due the total size = 0; waited at clock conflicts = 169923500 waited (count) when Workers occupied = 0 waited when Workers occupied = 0
  88. 2023-07-27T10:52:30.513122+08:00 8 [Note] Multi-threaded slave statistics for channel 'group_replication_applier': seconds elapsed = 750; events assigned = 3073; worker queues filled over overrun level = 0; waited due a Worker queue full = 0; waited due the total size = 0; waited at clock conflicts= 343063200 waited (count) when Workers occupied = 0 waited when Workers occupied = 0
复制代码


添加另一个节点
  1. 2023-07-27T10:09:14.925423+08:00 0 [Warning] Insecure configuration for --secure-file-priv: Location is accessible to all OS users. Consider choosinga different directory.
  2. 2023-07-27T10:09:14.925614+08:00 0 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.7.28-log) starting as process 27155 ...
  3. 2023-07-27T10:09:14.939948+08:00 0 [Note] InnoDB: PUNCH HOLE support available
  4. 2023-07-27T10:09:14.939994+08:00 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
  5. 2023-07-27T10:09:14.940001+08:00 0 [Note] InnoDB: Uses event mutexes
  6. 2023-07-27T10:09:14.940005+08:00 0 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
  7. 2023-07-27T10:09:14.940010+08:00 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
  8. 2023-07-27T10:09:14.940014+08:00 0 [Note] InnoDB: Using Linux native AIO
  9. 2023-07-27T10:09:14.940977+08:00 0 [Note] InnoDB: Number of pools: 1
  10. 2023-07-27T10:09:14.941110+08:00 0 [Note] InnoDB: Using CPU crc32 instructions
  11. 2023-07-27T10:09:14.943876+08:00 0 [Note] InnoDB: Initializing buffer pool, total size = 20.25G, instances = 18, chunk size = 128M
  12. 2023-07-27T10:09:14.943904+08:00 0 [Note] InnoDB: Setting NUMA memory policy to MPOL_INTERLEAVE
  13. 2023-07-27T10:09:16.178984+08:00 0 [Note] InnoDB: Setting NUMA memory policy to MPOL_DEFAULT
  14. 2023-07-27T10:09:16.179045+08:00 0 [Note] InnoDB: Completed initialization of buffer pool
  15. 2023-07-27T10:09:16.304342+08:00 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
  16. 2023-07-27T10:09:16.463360+08:00 0 [Note] InnoDB: Opened 95 undo tablespaces
  17. 2023-07-27T10:09:16.463396+08:00 0 [Note] InnoDB: 95 undo tablespaces made active
  18. 2023-07-27T10:09:16.463695+08:00 0 [Note] InnoDB: Highest supported file format is Barracuda.
  19. 2023-07-27T10:09:20.614292+08:00 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
  20. 2023-07-27T10:09:20.614321+08:00 0 [Note] InnoDB: Creating shared tablespace for temporary tables
  21. 2023-07-27T10:09:20.614386+08:00 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
  22. 2023-07-27T10:09:20.649664+08:00 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
  23. 2023-07-27T10:09:20.650532+08:00 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
  24. 2023-07-27T10:09:20.650558+08:00 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
  25. 2023-07-27T10:09:20.651259+08:00 0 [Note] InnoDB: Waiting for purge to start
  26. 2023-07-27T10:09:20.701493+08:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4397ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
  27. 2023-07-27T10:09:20.701723+08:00 0 [Note] InnoDB: 5.7.28 started; log sequence number 383636317736
  28. 2023-07-27T10:09:20.702060+08:00 0 [Note] InnoDB: Loading buffer pool(s) from /data/mysql/3306/data/ib_buffer_pool
  29. 2023-07-27T10:09:20.702300+08:00 0 [Note] Plugin 'FEDERATED' is disabled.
  30. 2023-07-27T10:09:20.750537+08:00 0 [Note] Semi-sync replication initialized for transactions.
  31. 2023-07-27T10:09:20.750571+08:00 0 [Note] Semi-sync replication enabled on the master.
  32. 2023-07-27T10:09:20.750657+08:00 0 [Note] Starting ack receiver thread
  33. 2023-07-27T10:09:20.764898+08:00 0 [Note] Salting uuid generator variables, current_pid: 27155, server_start_time: 1690423754, bytes_sent: 0,
  34. 2023-07-27T10:09:20.765049+08:00 0 [Note] Generated uuid: '994ec483-2c22-11ee-8470-fa163e5d1eb9', server_start_time: 7643452994268314589, bytes_sent:622902160
  35. 2023-07-27T10:09:20.765112+08:00 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 994ec483-2c22-11ee-8470-fa163e5d1eb9.
  36. 2023-07-27T10:09:21.858405+08:00 0 [Note] Auto generated SSL certificates are placed in data directory.
  37. 2023-07-27T10:09:21.859263+08:00 0 [Warning] CA certificate ca.pem is self signed.
  38. 2023-07-27T10:09:22.076260+08:00 0 [Note] Auto generated RSA key files are placed in data directory.
  39. 2023-07-27T10:09:22.076524+08:00 0 [Note] Server hostname (bind-address): '*'; port: 3306
  40. 2023-07-27T10:09:22.076585+08:00 0 [Note] IPv6 is available.
  41. 2023-07-27T10:09:22.076602+08:00 0 [Note]   - '::' resolves to '::';
  42. 2023-07-27T10:09:22.076626+08:00 0 [Note] Server socket created on IP: '::'.
  43. 2023-07-27T10:09:23.018481+08:00 0 [Note] Relay log recovery skipped for group replication channel.
  44. 2023-07-27T10:09:23.018506+08:00 0 [Warning] Recovery from master pos 70 and file  for channel 'group_replication_applier'. Previous relay log pos and relay log file had been set to 4, ./relay-bin-group_replication_applier.000007 respectively.
  45. 2023-07-27T10:09:23.029544+08:00 0 [Note] Relay log recovery skipped for group replication channel.
  46. 2023-07-27T10:09:23.029563+08:00 0 [Warning] 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, ./relay-bin-group_replication_recovery.000006 respectively.
  47. 2023-07-27T10:09:23.031581+08:00 0 [Note] Failed to start slave threads for channel ''
  48. 2023-07-27T10:09:24.015469+08:00 0 [Note] Event Scheduler: Loaded 0 events
  49. 2023-07-27T10:09:24.016082+08:00 0 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
  50. Version: '5.7.28-log'  socket: '/data/mysql/3306/tmp/mysql.sock'  port: 3306  MySQL Community Server (GPL)
  51. 2023-07-27T10:11:04.104855+08:00 2 [Note] @@GLOBAL.GTID_PURGED was changed from '' to 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-52762013,
  52. dcc74dde-dd8c-11ec-8543-fa163e85107c:1-15336730'.
  53. 2023-07-27T10:11:04.104894+08:00 2 [Note] @@GLOBAL.GTID_EXECUTED was changed from '' to 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-52762013,
  54. dcc74dde-dd8c-11ec-8543-fa163e85107c:1-15336730'.
  55. 2023-07-27T10:15:34.141668+08:00 2 [Note] Plugin group_replication reported: 'Group communication SSL configuration: group_replication_ssl_mode: "DISABLED"'
  56. 2023-07-27T10:15:34.141927+08:00 2 [Warning] Plugin group_replication reported: '[GCS] Automatically adding IPv4 localhost address to the whitelist. It is mandatory that it is added.'
  57. 2023-07-27T10:15:34.141985+08:00 2 [Note] Plugin group_replication reported: '[GCS] SSL was not enabled'
  58. 2023-07-27T10:15:34.142003+08:00 2 [Note] Plugin group_replication reported: 'Initialized group communication with configuration: group_replication_group_name: "aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa"; group_replication_local_address: "10.202.149.8:33060"; group_replication_group_seeds: "10.202.149.21:33060,10.202.149.40:33060,10.202.149.8:33060"; group_replication_bootstrap_group: false; group_replication_poll_spin_loops: 0; group_replication_compression_threshold: 1024; group_replication_ip_whitelist: "10.202.149.21,10.202.149.40,10.202.149.8"'
  59. 2023-07-27T10:15:34.142031+08:00 2 [Note] Plugin group_replication reported: '[GCS] Configured number of attempts to join: 0'
  60. 2023-07-27T10:15:34.142039+08:00 2 [Note] Plugin group_replication reported: '[GCS] Configured time between attempts to join: 5 seconds'
  61. 2023-07-27T10:15:34.142059+08:00 2 [Note] Plugin group_replication reported: 'Member configuration: member_id: 732; member_uuid: "994ec483-2c22-11ee-8470-fa163e5d1eb9"; single-primary mode: "false"; group_replication_auto_increment_increment: 7; '
  62. 2023-07-27T10:15:34.142214+08:00 4 [Note] Plugin group_replication reported: 'Detected previous RESET MASTER invocation or an issue exists in the group replication applier relay log. Purging existing applier logs.'
  63. 2023-07-27T10:15:34.188954+08:00 4 [Note] 'CHANGE MASTER TO FOR CHANNEL 'group_replication_applier' executed'. Previous state master_host='', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='<NULL>', master_port= 0, master_log_file='', master_log_pos=4, master_bind=''.
  64. 2023-07-27T10:15:34.352600+08:00 7 [Note] Slave SQL thread for channel 'group_replication_applier' initialized, starting replication in log 'FIRST' at position 0, relay log './relay-bin-group_replication_applier.000001' position: 4
  65. 2023-07-27T10:15:34.352637+08:00 2 [Note] Plugin group_replication reported: 'Group Replication applier module successfully initialized!'
  66. 2023-07-27T10:15:34.369351+08:00 0 [Note] Plugin group_replication reported: 'XCom protocol version: 3'
  67. 2023-07-27T10:15:34.369412+08:00 0 [Note] Plugin group_replication reported: 'XCom initialized and ready to accept incoming connections on port 33060'
  68. 2023-07-27T10:15:39.103851+08:00 42 [Note] Plugin group_replication reported: 'Establishing group recovery connection with a possible donor. Attempt 1/10'
  69. 2023-07-27T10:15:39.103932+08:00 0 [Note] Plugin group_replication reported: 'Group membership changed to RightCloud-3V4E:3306, RightCloud-yYqW:3306 on view 16904240509758596:2.'
  70. 2023-07-27T10:15:39.140053+08:00 42 [Note] '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='RightCloud-yYqW', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''.
  71. 2023-07-27T10:15:39.175518+08:00 42 [Note] Plugin group_replication reported: 'Establishing connection to a group replication recovery donor dcc74dde-dd8c-11ec-8543-fa163e85107c at RightCloud-yYqW port: 3306.'
  72. 2023-07-27T10:15:39.175896+08:00 43 [Note] Slave I/O thread: Start semi-sync replication to master 'repl@RightCloud-yYqW:3306' in log 'FIRST' at position 4
  73. 2023-07-27T10:15:39.175948+08:00 43 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
  74. 2023-07-27T10:15:39.177163+08:00 43 [Note] Slave I/O thread for channel 'group_replication_recovery': connected to master 'repl@RightCloud-yYqW:3306',replication started in log 'FIRST' at position 4
  75. 2023-07-27T10:15:39.342726+08:00 44 [Note] Slave SQL thread for channel 'group_replication_recovery' initialized, starting replication in log 'FIRST'at position 0, relay log './relay-bin-group_replication_recovery.000001' position: 4
  76. 2023-07-27T10:15:46.329748+08:00 45 [Warning] Timeout waiting for reply of binlog (file: mysql-bin.000001, pos: 739), semi-sync up to file , position0.
  77. 2023-07-27T10:15:46.329797+08:00 45 [Note] Semi-sync replication switched OFF.
  78. 2023-07-27T10:16:06.097503+08:00 0 [Note] Plugin group_replication reported: 'Members joined the group: RightCloud-bS28:3306'
  79. 2023-07-27T10:16:06.097577+08:00 0 [Note] Plugin group_replication reported: 'Group membership changed to RightCloud-bS28:3306, RightCloud-3V4E:3306,RightCloud-yYqW:3306 on view 16904240509758596:3.'
  80. 2023-07-27T10:17:40.587343+08:00 44 [Note] Multi-threaded slave statistics for channel 'group_replication_recovery': seconds elapsed = 121; events assigned = 57345; worker queues filled over overrun level = 0; waited due a Worker queue full = 0; waited due the total size = 0; waited at clock conflicts = 112315460600 waited (count) when Workers occupied = 0 waited when Workers occupied = 0
  81. 2023-07-27T10:18:33.924137+08:00 42 [Note] Plugin group_replication reported: 'Terminating existing group replication donor connection and purging the corresponding logs.'
  82. 2023-07-27T10:18:33.928467+08:00 44 [Note] Slave SQL thread for channel 'group_replication_recovery' exiting, replication stopped in log 'mysql-bin.000359' at position 355307581
  83. 2023-07-27T10:18:33.930342+08:00 43 [Note] Slave I/O thread killed while reading event for channel 'group_replication_recovery'
  84. 2023-07-27T10:18:33.930371+08:00 43 [Note] Slave I/O thread exiting for channel 'group_replication_recovery', read up to log 'mysql-bin.000359', position 355328873
  85. 2023-07-27T10:18:33.967526+08:00 42 [Note] 'CHANGE MASTER TO FOR CHANNEL 'group_replication_recovery' executed'. Previous state master_host='RightCloud-yYqW', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='<NULL>', master_port= 0, master_log_file='', master_log_pos= 4, master_bind=''.
  86. 2023-07-27T10:18:34.396061+08:00 0 [Note] Plugin group_replication reported: 'This server was declared online within the replication group'
  87. 2023-07-27T10:18:40.775121+08:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4022ms. The settings might not be optimal. (flushed=4598 and evicted=0, during the time.)
  88. 2023-07-27T10:18:52.117676+08:00 0 [Note] Plugin group_replication reported: 'The member with address RightCloud-bS28:3306 was declared online withinthe replication group'
  89. 2023-07-27T10:25:53.184950+08:00 2 [Note] Aborted connection 2 to db: 'unconnected' user: 'root' host: 'localhost' (Got timeout reading communicationpackets)
  90. 2023-07-27T10:28:04.989347+08:00 7 [Note] Multi-threaded slave statistics for channel 'group_replication_applier': seconds elapsed = 750; events assigned = 1025; worker queues filled over overrun level = 0; waited due a Worker queue full = 0; waited due the total size = 0; waited at clock conflicts= 89501900 waited (count) when Workers occupied = 0 waited when Workers occupied = 0
  91. 2023-07-27T10:37:11.132928+08:00 0 [Note] InnoDB: Buffer pool(s) load completed at 230727 10:37:11
  92. 2023-07-27T10:39:45.028556+08:00 7 [Note] Multi-threaded slave statistics for channel 'group_replication_applier': seconds elapsed = 701; events assigned = 2049; worker queues filled over overrun level = 0; waited due a Worker queue full = 0; waited due the total size = 0; waited at clock conflicts= 115819900 waited (count) when Workers occupied = 0 waited when Workers occupied = 0
  93. 2023-07-27T10:51:50.505914+08:00 7 [Note] Multi-threaded slave statistics for channel 'group_replication_applier': seconds elapsed = 725; events assigned = 3073; worker queues filled over overrun level = 0; waited due a Worker queue full = 0; waited due the total size = 0; waited at clock conflicts= 325558800 waited (count) when Workers occupied = 0 waited when Workers occupied = 0
  94. 2023-07-27T11:02:11.316781+08:00 7 [Note] Multi-threaded slave statistics for channel 'group_replication_applier': seconds elapsed = 621; events assigned = 4097; worker queues filled over overrun level = 0; waited due a Worker queue full = 0; waited due the total size = 0; waited at clock conflicts= 558361900 waited (count) when Workers occupied = 0 waited when Workers occupied = 0
复制代码



除此之外，在应用连接的节点，日志中存在以下warning，不知道有没有影响
  1. 2023-07-27T10:19:31.060702+08:00 1476493 [Warning] InnoDB: Cannot add field `BE_xid_297` in table `tmp`.`#sql_1c95_0` because after adding it, the row size is 8138 which is greater than maximum allowed size (8126) for a record on index leaf page.
  2. 2023-07-27T10:19:31.233379+08:00 1476493 [Warning] InnoDB: Cannot add field `BE_xid_297` in table `tmp`.`#sql_1c95_0` because after adding it, the row size is 8138 which is greater than maximum allowed size (8126) for a record on index leaf page.
  3. 2023-07-27T10:20:00.534484+08:00 1476493 [Warning] InnoDB: Cannot add field `BE_xid_297` in table `tmp`.`#sql_1c95_0` because after adding it, the row size is 8138 which is greater than maximum allowed size (8126) for a record on index leaf page.
  4. 2023-07-27T10:20:04.176481+08:00 1476494 [Warning] InnoDB: Cannot add field `BE_xid_297` in table `tmp`.`#sql_1c95_0` because after adding it, the row size is 8138 which is greater than maximum allowed size (8126) for a record on index leaf page.
  5. 2023-07-27T10:20:04.413869+08:00 1476494 [Warning] InnoDB: Cannot add field `BE_xid_297` in table `tmp`.`#sql_1c95_0` because after adding it, the row size is 8138 which is greater than maximum allowed size (8126) for a record on index leaf page.
  6. 2023-07-27T10:20:54.409015+08:00 1476494 [Warning] InnoDB: Cannot add field `BE_xid_297` in table `tmp`.`#sql_1c95_0` because after adding it, the row size is 8138 which is greater than maximum allowed size (8126) for a record on index leaf page.
  7. 2023-07-27T10:20:54.593275+08:00 1476494 [Warning] InnoDB: Cannot add field `BE_xid_297` in table `tmp`.`#sql_1c95_0` because after adding it, the row size is 8138 which is greater than maximum allowed size (8126) for a record on index leaf page.
  8. 2023-07-27T10:21:23.036991+08:00 1476542 [Warning] InnoDB: Cannot add field `BE_xid_297` in table `tmp`.`#sql_1c95_0` because after adding it, the row size is 8138 which is greater than maximum allowed size (8126) for a record on index leaf page.
  9. 2023-07-27T10:21:23.212127+08:00 1476542 [Warning] InnoDB: Cannot add field `BE_xid_297` in table `tmp`.`#sql_1c95_0` because after adding it, the row size is 8138 which is greater than maximum allowed size (8126) for a record on index leaf page.
  10. 2023-07-27T10:21:25.768210+08:00 1476542 [Warning] InnoDB: Cannot add field `BE_xid_297` in table `tmp`.`#sql_1c95_0` because after adding it, the row size is 8138 which is greater than maximum allowed size (8126) for a record on index leaf page.
  11. 2023-07-27T10:21:25.929433+08:00 1476542 [Warning] InnoDB: Cannot add field `BE_xid_297` in table `tmp`.`#sql_1c95_0` because after adding it, the row size is 8138 which is greater than maximum allowed size (8126) for a record on index leaf page.
  12. 2023-07-27T10:21:46.722477+08:00 1476542 [Warning] InnoDB: Cannot add field `BE_xid_297` in table `tmp`.`#sql_1c95_0` because after adding it, the row size is 8138 which is greater than maximum allowed size (8126) for a record on index leaf page.
  13. 2023-07-27T10:21:46.949259+08:00 1476542 [Warning] InnoDB: Cannot add field `BE_xid_297` in table `tmp`.`#sql_1c95_0` because after adding it, the row size is 8138 which is greater than maximum allowed size (8126) for a record on index leaf page.
  14. 2023-07-27T10:25:00.602690+08:00 1476576 [Warning] InnoDB: Cannot add field `BE_xid_297` in table `tmp`.`#sql_1c95_0` because after adding it, the row size is 8138 which is greater than maximum allowed size (8126) for a record on index leaf page.
  15. 2023-07-27T10:26:59.835599+08:00 1476741 [Warning] InnoDB: Cannot add field `BE_xid_297` in table `tmp`.`#sql_1c95_0` because after adding it, the row size is 8138 which is greater than maximum allowed size (8126) for a record on index leaf page.
  16. 2023-07-27T10:26:59.999562+08:00 1476741 [Warning] InnoDB: Cannot add field `BE_xid_297` in table `tmp`.`#sql_1c95_0` because after adding it, the row size is 8138 which is greater than maximum allowed size (8126) for a record on index leaf page.
  17. 2023-07-27T10:27:56.545560+08:00 1476674 [Warning] InnoDB: Cannot add field `BE_xid_297` in table `tmp`.`#sql_1c95_0` because after adding it, the row size is 8138 which is greater than maximum allowed size (8126) for a record on index leaf page.
  18. 2023-07-27T10:27:58.062483+08:00 1476674 [Warning] InnoDB: Cannot add field `BE_xid_297` in table `tmp`.`#sql_1c95_0` because after adding it, the row size is 8138 which is greater than maximum allowed size (8126) for a record on index leaf page.
  19. 2023-07-27T10:28:05.023979+08:00 1476674 [Warning] InnoDB: Cannot add field `BE_xid_297` in table `tmp`.`#sql_1c95_0` because after adding it, the row size is 8138 which is greater than maximum allowed size (8126) for a record on index leaf page.
  20. 2023-07-27T10:28:06.398972+08:00 1476674 [Warning] InnoDB: Cannot add field `BE_xid_297` in table `tmp`.`#sql_1c95_0` because after adding it, the row size is 8138 which is greater than maximum allowed size (8126) for a record on index leaf page.
  21. 2023-07-27T10:28:50.790333+08:00 1476741 [Warning] InnoDB: Cannot add field `BE_xid_297` in table `tmp`.`#sql_1c95_0` because after adding it, the row size is 8138 which is greater than maximum allowed size (8126) for a record on index leaf page.
  22. 2023-07-27T10:28:52.204412+08:00 1476741 [Warning] InnoDB: Cannot add field `BE_xid_297` in table `tmp`.`#sql_1c95_0` because after adding it, the row size is 8138 which is greater than maximum allowed size (8126) for a record on index leaf page.
  23. 2023-07-27T10:28:54.230095+08:00 1476741 [Warning] InnoDB: Cannot add field `BE_xid_297` in table `tmp`.`#sql_1c95_0` because after adding it, the row size is 8138 which is greater than maximum allowed size (8126) for a record on index leaf page.
  24. 2023-07-27T10:28:54.371526+08:00 1476741 [Warning] InnoDB: Cannot add field `BE_xid_297` in table `tmp`.`#sql_1c95_0` because after adding it, the row size is 8138 which is greater than maximum allowed size (8126) for a record on index leaf page.
  25. 2023-07-27T10:29:15.777888+08:00 1476741 [Warning] InnoDB: Cannot add field `BE_xid_297` in table `tmp`.`#sql_1c95_0` because after adding it, the row size is 8138 which is greater than maximum allowed size (8126) for a record on index leaf page.
  26. 2023-07-27T10:29:17.123113+08:00 1476741 [Warning] InnoDB: Cannot add field `BE_xid_297` in table `tmp`.`#sql_1c95_0` because after adding it, the row size is 8138 which is greater than maximum allowed size (8126) for a record on index leaf page.
  27. 2023-07-27T10:29:21.624351+08:00 1476789 [Warning] InnoDB: Cannot add field `BE_xid_297` in table `tmp`.`#sql_1c95_0` because after adding it, the row size is 8138 which is greater than maximum allowed size (8126) for a record on index leaf page.
  28. 2023-07-27T10:29:23.092074+08:00 1476789 [Warning] InnoDB: Cannot add field `BE_xid_297` in table `tmp`.`#sql_1c95_0` because after adding it, the row size is 8138 which is greater than maximum allowed size (8126) for a record on index leaf page.
  29. 2023-07-27T10:30:00.568285+08:00 1476741 [Warning] InnoDB: Cannot add field `BE_xid_297` in table `tmp`.`#sql_1c95_0` because after adding it, the row size is 8138 which is greater than maximum allowed size (8126) for a record on index leaf page.
  30. 2023-07-27T10:35:00.657030+08:00 1476880 [Warning] InnoDB: Cannot add field `BE_xid_297` in table `tmp`.`#sql_1c95_0` because after adding it, the row size is 8138 which is greater than maximum allowed size (8126) for a record on index leaf page.
  31. 2023-07-27T10:40:00.469610+08:00 1477143 [Warning] InnoDB: Cannot add field `BE_xid_297` in table `tmp`.`#sql_1c95_0` because after adding it, the row size is 8138 which is greater than maximum allowed size (8126) for a record on index leaf page.
  32. 2023-07-27T10:45:00.513200+08:00 1477155 [Warning] InnoDB: Cannot add field `BE_xid_297` in table `tmp`.`#sql_1c95_0` because after adding it, the row size is 8138 which is greater than maximum allowed size (8126) for a record on index leaf page.
  33. 2023-07-27T10:50:00.685567+08:00 1477246 [Warning] InnoDB: Cannot add field `BE_xid_297` in table `tmp`.`#sql_1c95_0` because after adding it, the row size is 8138 which is greater than maximum allowed size (8126) for a record on index leaf page.
  34. 2023-07-27T10:50:44.313512+08:00 1477246 [Warning] InnoDB: Cannot add field `BE_xid_297` in table `tmp`.`#sql_1c95_0` because after adding it, the row size is 8138 which is greater than maximum allowed size (8126) for a record on index leaf page.
  35. 2023-07-27T10:50:44.471090+08:00 1477246 [Warning] InnoDB: Cannot add field `BE_xid_297` in table `tmp`.`#sql_1c95_0` because after adding it, the row size is 8138 which is greater than maximum allowed size (8126) for a record on index leaf page.
  36. 2023-07-27T10:50:52.186654+08:00 1477246 [Warning] InnoDB: Cannot add field `BE_xid_297` in table `tmp`.`#sql_1c95_0` because after adding it, the row size is 8138 which is greater than maximum allowed size (8126) for a record on index leaf page.
  37. 2023-07-27T10:50:52.382422+08:00 1477246 [Warning] InnoDB: Cannot add field `BE_xid_297` in table `tmp`.`#sql_1c95_0` because after adding it, the row size is 8138 which is greater than maximum allowed size (8126) for a record on index leaf page.
  38. 2023-07-27T10:55:00.657477+08:00 1477327 [Warning] InnoDB: Cannot add field `BE_xid_297` in table `tmp`.`#sql_1c95_0` because after adding it, the row size is 8138 which is greater than maximum allowed size (8126) for a record on index leaf page.
  39. 2023-07-27T11:00:00.647925+08:00 1477492 [Warning] InnoDB: Cannot add field `BE_xid_297` in table `tmp`.`#sql_1c95_0` because after adding it, the row size is 8138 which is greater than maximum allowed size (8126) for a record on index leaf page.
  40. 2023-07-27T11:05:00.743175+08:00 1477590 [Warning] InnoDB: Cannot add field `BE_xid_297` in table `tmp`.`#sql_1c95_0` because after adding it, the row size is 8138 which is greater than maximum allowed size (8126) for a record on index leaf page.
  41. 2023-07-27T11:09:02.833695+08:00 1477789 [Warning] InnoDB: Cannot add field `BE_xid_297` in table `tmp`.`#sql_1c95_0` because after adding it, the row size is 8138 which is greater than maximum allowed size (8126) for a record on index leaf page.
  42. 2023-07-27T11:09:03.122306+08:00 1477789 [Warning] InnoDB: Cannot add field `BE_xid_297` in table `tmp`.`#sql_1c95_0` because after adding it, the row size is 8138 which is greater than maximum allowed size (8126) for a record on index leaf page.
  43. 2023-07-27T11:10:00.558656+08:00 1477788 [Warning] InnoDB: Cannot add field `BE_xid_297` in table `tmp`.`#sql_1c95_0` because after adding it, the row size is 8138 which is greater than maximum allowed size (8126) for a record on index leaf page.
  44. 2023-07-27T11:10:19.341661+08:00 1477883 [Warning] InnoDB: Cannot add field `BE_xid_297` in table `tmp`.`#sql_1c95_0` because after adding it, the row size is 8138 which is greater than maximum allowed size (8126) for a record on index leaf page.
  45. 2023-07-27T11:10:19.507152+08:00 1477883 [Warning] InnoDB: Cannot add field `BE_xid_297` in table `tmp`.`#sql_1c95_0` because after adding it, the row size is 8138 which is greater than maximum allowed size (8126) for a record on index leaf page.
  46. 2023-07-27T11:10:47.610140+08:00 1477883 [Warning] InnoDB: Cannot add field `BE_xid_297` in table `tmp`.`#sql_1c95_0` because after adding it, the row size is 8138 which is greater than maximum allowed size (8126) for a record on index leaf page.
  47. 2023-07-27T11:10:47.771578+08:00 1477883 [Warning] InnoDB: Cannot add field `BE_xid_297` in table `tmp`.`#sql_1c95_0` because after adding it, the row size is 8138 which is greater than maximum allowed size (8126) for a record on index leaf page.
  48. 2023-07-27T11:12:37.955320+08:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 13878ms. The settings might not be optimal. (flushed=10 andevicted=0, during the time.)
  49. 2023-07-27T11:12:57.932366+08:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 14103ms. The settings might not be optimal. (flushed=13 andevicted=0, during the time.)
  50. 2023-07-27T11:13:10.381767+08:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6448ms. The settings might not be optimal. (flushed=74 and evicted=0, during the time.)
复制代码


全部回复(7)
只看楼主
yejr 2023-7-27 11:29:17
连接使用的MySQL客户端版本号是多少？
$ mysql --version 看看
回复 采纳

举报

金同学 2023-7-27 11:31:29
yejr 发表于 2023-7-27 11:29
连接使用的MySQL客户端版本号是多少？
$ mysql --version 看看

[root@RightCloud-3V4E ~]# mysql -V
mysql  Ver 14.14 Distrib 5.7.28, for linux-glibc2.12 (x86_64) using  EditLine wrapper
回复 采纳

举报

yejr 2023-7-27 11:53:13
金同学 发表于 2023-7-27 11:31
[root@RightCloud-3V4E ~]# mysql -V
mysql  Ver 14.14 Distrib 5.7.28, for linux-glibc2.12 (x86_64) u ...

应该不对，怀疑你是用了8.0的客户端连接的，所以才有MEMBER_ROLE这列
因为在5.7版本中，是没有MEMBER_ROLE这列的（只有在GreatSQL 5.7.36-39版本中才支持）
你再仔细检查检查
回复 采纳

举报

金同学 2023-7-27 14:09:52
yejr 发表于 2023-7-27 11:53
应该不对，怀疑你是用了8.0的客户端连接的，所以才有MEMBER_ROLE这列
因为在5.7版本中，是没有MEMBER_ROL ...

SELECT
    MEMBER_ID,
    MEMBER_HOST,
    MEMBER_PORT,
    MEMBER_STATE,
    IF(global_status.VARIABLE_NAME IS NOT NULL,
        'PRIMARY',
        'SECONDARY') AS MEMBER_ROLE
FROM
    performance_schema.replication_group_members
        LEFT JOIN
    performance_schema.global_status ON global_status.VARIABLE_NAME = 'group_replication_primary_member'
        AND global_status.VARIABLE_VALUE = replication_group_members.MEMBER_ID;
回复 采纳

举报

金同学 2023-7-27 14:10:41
yejr 发表于 2023-7-27 11:53
应该不对，怀疑你是用了8.0的客户端连接的，所以才有MEMBER_ROLE这列
因为在5.7版本中，是没有MEMBER_ROL ...

我是关联查询出来的，可能跟我的SQL有关。
回复 采纳

举报

金同学 2023-7-27 14:11:40
yejr 发表于 2023-7-27 11:53
应该不对，怀疑你是用了8.0的客户端连接的，所以才有MEMBER_ROLE这列
因为在5.7版本中，是没有MEMBER_ROL ...

感谢老师解答。
回复 采纳

举报

yejr 2023-7-27 14:54:28
金同学 发表于 2023-7-27 14:11
感谢老师解答。

该查询SQL确实不严谨：
  1. group_replication_primary_member

  3. Shows the primary member's UUID when the group is operating in single-primary mode. If the group is operating in multi-primary mode, shows an empty string.
复制代码


详见：https://dev.mysql.com/doc/refman ... tion_primary_member
回复 采纳

举报

金同学

1

主题

0

博客

6

贡献

新手上路

Rank: 1

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

合作电话：010-64087828

社区邮箱：greatsql@greatdb.com

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