|
mysql 8.0.33 MGR 单主 docker OS centos 7.6 #配置文件 [mysqld] # server user=mysql basedir=/usr/local/mysql datadir=/data/3306/data port=3306 #pid file pid_file=/data/3306/data/mysql.pid log_error=/data/3306/data/mysql_err.log #default 2 log_error_verbosity=3 log_timestamps = system socket=/tmp/mysql.sock skip_name_resolve report_host='10.0.0.61' ## password plugin default_authentication_plugin = mysql_native_password #replication log_bin_index=/data/3306/binlog/binlog_index expire_logs_days=7 log-bin=/data/3306/binlog/mysql-bin binlog_format = ROW transaction_isolation = READ-COMMITTED ## safe_slave for 8.0.3 master_info_repository = TABLE relay_log_info_repository = TABLE relay_log_recovery = 1 ## gtid mode gtid_mode = ON enforce_gtid_consistency = ON ## server_id server_id=8 binlog_transaction_dependency_tracking = WRITESET transaction_write_set_extraction=XXHASH64 # multi-threaded replica replica_parallel_type=LOGICAL_CLOCK #default 8.0.29 过期 replica_parallel_workers=4 #default 8.0.29 过期 replica_preserve_commit_order=on #default 8.0.29 过期 ## group replication settings #plugin_load_add = 'group_replication.so' sql_generate_invisible_primary_key = 1 disabled_storage_engines = "MyISAM,BLACKHOLE,FEDERATED,ARCHIVE,MEMORY" binlog_checksum = CRC32 # default loose_plugin_load_add = 'group_replication.so' group_replication_group_name = "0c400488-f659-11ed-84af-0242ac110002" group_replication_start_on_boot = off group_replication_local_address = "10.0.0.61:33061" group_replication_group_seeds = "10.0.0.60:33061,10.0.0.61:33061,10.0.0.62:33061" group_replication_bootstrap_group = off # binlog log_bin_index=/data/3306/binlog/binlog_index expire_logs_days=7 log_bin=/data/3306/binlog/mysql-bin binlog_format = ROW # relay relay_log = /data/3306/binlog/relay-log relay_log_index = /data/3306/binlog/relay_bin.index [mysql] prompt=(\\U)\\_[\\d]>\\_ [client] socket=/tmp/mysql.sock ##### 问题描述 主节点可以启动 MGR 从节点MySQL server都无法启动，尝试过将 MGR的参数都注释掉也不行; 备注: 前天是可以正常启动的 ### 报错如下 ### 检查过 plugin dir 有这个插件 2023-06-13T15:29:26.939319-00:00 0 [ERROR] [MY-013180] [Server] Function 'group_replication' already exists. 2023-06-13T15:29:26.939347-00:00 0 [ERROR] [MY-010736] [Server] Couldn't load plugin named 'group_replication' with soname 'group_replication.so'. 2023-06-13T15:29:27.238704-00:00 0 [Note] [MY-011332] [Server] Plugin mysqlx reported: 'IPv6 is available' 2023-06-13T15:29:27.259425-00:00 0 [Note] [MY-011323] [Server] Plugin mysqlx reported: 'X Plugin ready for connections. bind-address: '::' port: 33060' 2023-06-13T15:29:27.259782-00:00 0 [ERROR] [MY-011300] [Server] Plugin mysqlx reported: 'Setup of socket: '/tmp/mysqlx.sock' failed, another process with PID 783 is using UNIX socket file' 2023-06-13T15:29:27.259849-00:00 0 [Note] [MY-011322] [Server] Plugin mysqlx reported: 'Please see the MySQL documentation for 'mysqlx_socket' system variables to fix the error' 2023-06-13T15:29:27.412403-00:00 0 [Note] [MY-010855] [Server] Recovering after a crash using /data/3306/binlog/mysql-bin 2023-06-13T15:29:27.412450-00:00 0 [System] [MY-010229] [Server] Starting XA crash recovery... 2023-06-13T15:29:27.922369-00:00 0 [Note] [MY-013911] [Server] Crash recovery finished in binlog engine. No attempts to commit, rollback or prepare any transactions. 2023-06-13T15:29:27.922407-00:00 0 [Note] [MY-013911] [Server] Crash recovery finished in InnoDB engine. No attempts to commit, rollback or prepare any transactions. 2023-06-13T15:29:27.922414-00:00 0 [System] [MY-010232] [Server] XA crash recovery finished. 2023-06-13T15:29:27.924189-00:00 0 [Note] [MY-012487] [InnoDB] DDL log recovery : begin 2023-06-13T15:29:27.924225-00:00 0 [Note] [MY-012488] [InnoDB] DDL log recovery : end 2023-06-13T15:29:27.924354-00:00 0 [Note] [MY-011946] [InnoDB] Loading buffer pool(s) from /data/3306/data/ib_buffer_pool 2023-06-13T15:29:27.999680-00:00 0 [Note] [MY-011946] [InnoDB] Buffer pool(s) load completed at 230613 15:29:27 2023-06-13T15:29:28.029142-00:00 0 [Note] [MY-012922] [InnoDB] Waiting for purge to start 2023-06-13T15:29:28.117526-00:00 0 [Note] [MY-010182] [Server] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2023-06-13T15:29:28.117720-00:00 0 [Note] [MY-010304] [Server] Skipping generation of SSL certificates as certificate files are present in data directory. 2023-06-13T15:29:28.138387-00:00 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2023-06-13T15:29:28.138452-00:00 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel. 2023-06-13T15:29:28.138532-00:00 0 [Note] [MY-010308] [Server] Skipping generation of RSA key pair through --sha256_password_auto_generate_rsa_keys as key files are present in data directory. 2023-06-13T15:29:28.138575-00:00 0 [Note] [MY-010308] [Server] Skipping generation of RSA key pair through --caching_sha2_password_auto_generate_rsa_keys as key files are present in data directory. 2023-06-13T15:29:28.139526-00:00 0 [Note] [MY-010252] [Server] Server hostname (bind-address): '*'; port: 3306 2023-06-13T15:29:28.139564-00:00 0 [Note] [MY-010253] [Server] IPv6 is available. 2023-06-13T15:29:28.139571-00:00 0 [Note] [MY-010264] [Server] - '::' resolves to '::'; 2023-06-13T15:29:28.139580-00:00 0 [Note] [MY-010251] [Server] Server socket created on IP: '::'. 2023-06-13T15:29:28.147153-00:00 0 [ERROR] [MY-010259] [Server] Another process with pid 783 is using unix socket file. 2023-06-13T15:29:28.147167-00:00 0 [ERROR] [MY-010268] [Server] Unable to setup unix socket lock file. 2023-06-13T15:29:28.147175-00:00 0 [ERROR] [MY-010119] [Server] Aborting |
|
|
yejr
2023-6-14 08:40:33
| |
|
|
fander
2023-6-16 00:51:56
| |
合作电话：010-64087828
社区邮箱：greatsql@greatdb.com
