|
配置信息： 数据库的版本是：8.4.4-4 GreatSQL (GPL), Release 4, Revision e6eca73c556 搭在smartx平台上的虚拟机，节点配置是8核16G，虚拟机的操作系统是华为欧拉2203sp1 ，网络是千兆网 下面是GreatSQL崩溃的报错信息： 2026-03-23T09:58:24.258330Z 0 [Note] [MY-011501] [Repl] Plugin group_replication reported: 'Members joined the group: 172.41.12.3:3308' 2026-03-23T09:58:24.258429Z 0 [Note] [MY-011071] [Repl] Plugin group_replication reported: 'handle_leader_election_if_needed is activated,suggested_primary:' 2026-03-23T09:58:24.258488Z 0 [System] [MY-011503] [Repl] Plugin group_replication reported: 'Group membership changed to 172.41.12.1:3308, 172.41.12.2:3308, 172.41.12.3:3308 on view 17742499629657369:7.' 2026-03-23T09:58:24.258564Z 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] ::process_control_message()::Install new view over' 2026-03-23T09:58:24.258664Z 12 [System] [MY-015045] [Repl] Plugin group_replication reported: 'The member 172.41.12.1:3308 will be the one sending the recovery metadata message.' 2026-03-23T09:58:24.258794Z 0 [Note] [MY-000000] [Server] Plugin greatdb_ha reported: 'Cur MGR group view_id change to [17742499629657369:7].' 2026-03-23T09:58:24.349287Z 396 [Note] [MY-010462] [Repl] Start binlog_dump to source_thread_id(396) replica_server(3), pos(, 4) 2026-03-23T09:58:24.390186Z 0 [System] [MY-011492] [Repl] Plugin group_replication reported: 'The member with address 172.41.12.3:3308 was declared online within the replication group.' 2026-03-23T09:58:26.077836Z 396 [Note] [MY-010914] [Server] Aborted connection 396 to db: 'unconnected' user: 'repl' host: '172.41.12.3' (failed on flush_net()). 2026-03-23T10:06:41.095439Z 14 [Note] [MY-010559] [Repl] Multi-threaded replica statistics for channel 'group_replication_applier': seconds elapsed = 915; events assigned = 15386; worker queues filled over overrun level = 0; waited due a Worker queue full = 0; waited due the total size = 0; waited at clock conflicts = 0 waited (count) when Workers occupied = 653 waited when Workers occupied = 1171799700 2026-03-23T10:11:43Z UTC - mysqld got signal 11 ; Signal SIGSEGV (Address not mapped to object) at address 0x61050000 Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware. BuildID[sha1]=467586728d64d2853d33ffd0f2f4539e2f6df6e5 Server Version: 8.4.4-4 GreatSQL (GPL), Release 4, Revision e6eca73c556 Thread pointer: 0x2408e000 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 7fadf5228978 thread_stack 0x100000 2026-03-23T10:11:43.610694Z 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Failure reading from fd=52 n=0 from 172.41.12.3:33061' 2026-03-23T10:11:43.610767Z 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:52 in close_connection' 2026-03-23T10:11:43.610816Z 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] fast_skip_allowed_for_kill is set here' 2026-03-23T10:11:43.610842Z 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:54 in close_connection' #0 0x239da2b _Z19my_print_stacktracePKhm #1 0x1428ff6 _ZL18print_fatal_signaliP9siginfo_t #2 0x14293cc _Z19handle_fatal_signaliP9siginfo_tPv #3 0x7fae4a932ecf <unknown> #4 0x7fadfbe1693f _ZN9Certifier14quick_add_itemEPKclPl #5 0x7fadfbe1e21b _ZN9Certifier34add_writeset_to_certification_infoEbRlP8Gtid_setPNSt7__cxx114listIPKcSaIS6_EEEbRij #6 0x7fadfbe1e95d _ZN9Certifier7certifyEP8Gtid_setPNSt7__cxx114listIPKcSaIS5_EEEbS5_bP14Gtid_log_eventbj #7 0x7fadfbe5b0e2 _ZN21Certification_handler21handle_transaction_idEP14Pipeline_eventP12Continuation #8 0x7fadfbe5e38a _ZN15Event_cataloger23handle_binary_log_eventEP14Pipeline_eventP12Continuation #9 0x7fadfbe053d0 _ZN14Applier_module26inject_event_into_pipelineEP14Pipeline_eventP12Continuation #10 0x7fadfbe07b5b _ZN14Applier_module17apply_data_packetEP11Data_packetP28Format_description_log_eventP12ContinuationbRb #11 0x7fadfbe0c4a9 _ZN14Applier_module21applier_thread_handleEv #12 0x7fadfbe0c678 _ZL21launch_handler_threadPv #13 0x2869b94 pfs_spawn_thread #14 0x7fae4a97d229 <unknown> #15 0x7fae4a9ffcef <unknown> #16 0xffffffffffffffff <unknown> Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (7fadfbfce268): Group replication applier module Connection ID (thread ID): 12 Status: NOT_KILLED Please help us make Percona Server better by reporting any bugs at https://bugs.percona.com/ You may download the Percona Server operations manual by visiting http://www.percona.com/software/percona-server/. You may find information in the manual which will help you identify the cause of the crash. 2026-03-23T10:11:45.543973Z 0 [Note] [MY-013930] [Server] systemd notify: STATUS=Server startup in progress 2026-03-23T10:11:45.545351Z 0 [System] [MY-015015] [Server] MySQL Server - start. 2026-03-23T10:11:45.811163Z 0 [Warning] [MY-011070] [Server] 'binlog_format' is deprecated and will be removed in a future release. 2026-03-23T10:11:45.811203Z 0 [Warning] [MY-011068] [Server] The syntax 'log_slave_updates' is deprecated and will be removed in a future release. Please use log_replica_updates instead. 2026-03-23T10:11:45.811313Z 0 [Warning] [MY-011069] [Server] The syntax '--replica-parallel-type' is deprecated and will be removed in a future release. 2026-03-23T10:11:45.812888Z 0 [Warning] [MY-010097] [Server] Insecure configuration for --secure-log-path: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path. 2026-03-23T10:11:45.812958Z 0 [Note] [MY-013932] [Server] BuildID[sha1]=467586728d64d2853d33ffd0f2f4539e2f6df6e5 2026-03-23T10:11:45.812964Z 0 [Note] [MY-010949] [Server] Basedir set to /usr/. 2026-03-23T10:11:45.812974Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.4.4-4) starting as process 3735634 2026-03-23T10:11:45.840696Z 0 [Note] [MY-012366] [InnoDB] Using Linux native AIO 2026-03-23T10:11:45.840798Z 0 [Warning] [MY-013869] [InnoDB] Ignored deprecated configuration parameter innodb_log_file_size. Used innodb_redo_log_capacity instead. 2026-03-23T10:11:45.841336Z 0 [Note] [MY-010747] [Server] Plugin 'FEDERATED' is disabled. 2026-03-23T10:11:45.841492Z 0 [Note] [MY-010747] [Server] Plugin 'ndbcluster' is disabled. 2026-03-23T10:11:45.841540Z 0 [Note] [MY-010747] [Server] Plugin 'ndbinfo' is disabled. 2026-03-23T10:11:45.841562Z 0 [Note] [MY-010747] [Server] Plugin 'ndb_transid_mysql_connection_map' is disabled. 2026-03-23T10:11:45.843855Z 1 [Note] [MY-013930] [Server] systemd notify: STATUS=InnoDB initialization in progress 2026-03-23T10:11:45.843937Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2026-03-23T10:11:45.843979Z 1 [Note] [MY-013546] [InnoDB] Atomic write enabled 2026-03-23T10:11:45.844032Z 1 [Note] [MY-012932] [InnoDB] PUNCH HOLE support available 2026-03-23T10:11:45.844066Z 1 [Note] [MY-012944] [InnoDB] Uses event mutexes 2026-03-23T10:11:45.844077Z 1 [Note] [MY-012945] [InnoDB] GCC builtin __atomic_thread_fence() is used for memory barrier 2026-03-23T10:11:45.844093Z 1 [Note] [MY-012948] [InnoDB] Compressed tables use zlib 1.3.1 2026-03-23T10:11:45.848968Z 1 [Note] [MY-011066] [InnoDB] File purge : set file purge path : /var/lib/mysql/#file_purge 2026-03-23T10:11:45.849142Z 1 [Note] [MY-012951] [InnoDB] Using hardware accelerated crc32 and polynomial multiplication. 2026-03-23T10:11:45.850217Z 1 [Note] [MY-012203] [InnoDB] Directories to scan './' 2026-03-23T10:11:45.850349Z 1 [Note] [MY-012204] [InnoDB] Scanning './' 2026-03-23T10:11:45.851928Z 1 [Note] [MY-013503] [InnoDB] Directory '/var/lib/mysql/percona-toolkit-3.0.13/blib/script/.exists' will not be scanned because it is a hidden directory. 2026-03-23T10:11:45.852061Z 1 [Note] [MY-013503] [InnoDB] Directory '/var/lib/mysql/percona-toolkit-3.0.13/blib/man3/.exists' will not be scanned because it is a hidden directory. 2026-03-23T10:11:45.852097Z 1 [Note] [MY-013503] [InnoDB] Directory '/var/lib/mysql/percona-toolkit-3.0.13/blib/lib/.exists' will not be scanned because it is a hidden directory. 2026-03-23T10:11:45.852141Z 1 [Note] [MY-013503] [InnoDB] Directory '/var/lib/mysql/percona-toolkit-3.0.13/blib/lib/auto/percona-toolkit/.exists' will not be scanned because it is a hidden directory. 2026-03-23T10:11:45.852185Z 1 [Note] [MY-013503] [InnoDB] Directory '/var/lib/mysql/percona-toolkit-3.0.13/blib/bin/.exists' will not be scanned because it is a hidden directory. 2026-03-23T10:11:45.852335Z 1 [Note] [MY-013503] [InnoDB] Directory '/var/lib/mysql/percona-toolkit-3.0.13/blib/man1/.exists' will not be scanned because it is a hidden directory. 2026-03-23T10:11:45.852425Z 1 [Note] [MY-013503] [InnoDB] Directory '/var/lib/mysql/percona-toolkit-3.0.13/blib/arch/.exists' will not be scanned because it is a hidden directory. 2026-03-23T10:11:45.852480Z 1 [Note] [MY-013503] [InnoDB] Directory '/var/lib/mysql/percona-toolkit-3.0.13/blib/arch/auto/percona-toolkit/.exists' will not be scanned because it is a hidden directory. 2026-03-23T10:11:45.856906Z 1 [Note] [MY-012208] [InnoDB] Completed space ID check of 103 files. 2026-03-23T10:11:45.859700Z 1 [Note] [MY-012955] [InnoDB] Initializing buffer pool, total size = 1.000000G, instances = 2, chunk size =128.000000M 2026-03-23T10:11:45.859769Z 1 [Note] [MY-011872] [InnoDB] Setting NUMA memory policy to MPOL_INTERLEAVE 2026-03-23T10:11:46.126920Z 1 [Note] [MY-011874] [InnoDB] Setting NUMA memory policy to MPOL_DEFAULT 2026-03-23T10:11:46.127006Z 1 [Note] [MY-012957] [InnoDB] Completed initialization of buffer pool 2026-03-23T10:11:46.145345Z 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_0.dblwr' for doublewrite 2026-03-23T10:11:46.175936Z 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_1.dblwr' for doublewrite 2026-03-23T10:11:46.224013Z 1 [Note] [MY-013566] [InnoDB] Double write buffer files: 2 2026-03-23T10:11:46.224068Z 1 [Note] [MY-013565] [InnoDB] Double write buffer pages per instance: 128 2026-03-23T10:11:46.224096Z 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_0.dblwr' for doublewrite 2026-03-23T10:11:46.224116Z 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_1.dblwr' for doublewrite 2026-03-23T10:11:46.289710Z 1 [Note] [MY-013883] [InnoDB] The latest found checkpoint is at lsn = 34175106810 in redo log file ./#innodb_redo/#ib_redo0. 2026-03-23T10:11:46.289784Z 1 [Note] [MY-012560] [InnoDB] The log sequence number 34146594111 in the system tablespace does not match the log sequence number 34175106810 in the redo log files! 2026-03-23T10:11:46.289799Z 1 [Note] [MY-012551] [InnoDB] Database was not shutdown normally! 2026-03-23T10:11:46.289811Z 1 [Note] [MY-012552] [InnoDB] Starting crash recovery. 2026-03-23T10:11:46.291336Z 1 [Note] [MY-013086] [InnoDB] Starting to parse redo log at lsn = 34175106606, whereas checkpoint_lsn = 34175106810 and start_lsn = 34175106560 2026-03-23T10:11:46.296773Z 1 [Note] [MY-012550] [InnoDB] Doing recovery: scanned up to log sequence number 34175394525 2026-03-23T10:11:46.299409Z 1 [Note] [MY-013083] [InnoDB] Log background threads are being started... 2026-03-23T10:11:46.300099Z 1 [Note] [MY-012532] [InnoDB] Applying a batch of 784 redo log records ... 2026-03-23T10:11:46.338239Z 1 [Note] [MY-012533] [InnoDB] 10% 2026-03-23T10:11:46.339221Z 1 [Note] [MY-012533] [InnoDB] 20% 2026-03-23T10:11:46.339329Z 1 [Note] [MY-012533] [InnoDB] 30% 2026-03-23T10:11:46.339426Z 1 [Note] [MY-012533] [InnoDB] 40% 2026-03-23T10:11:46.339461Z 1 [Note] [MY-012533] [InnoDB] 50% 2026-03-23T10:11:46.360517Z 1 [Note] [MY-012533] [InnoDB] 60% 2026-03-23T10:11:46.361986Z 1 [Note] [MY-012533] [InnoDB] 70% 2026-03-23T10:11:46.362163Z 1 [Note] [MY-012533] [InnoDB] 80% 2026-03-23T10:11:46.362256Z 1 [Note] [MY-012533] [InnoDB] 90% 2026-03-23T10:11:46.362305Z 1 [Note] [MY-012533] [InnoDB] 100% 2026-03-23T10:11:46.862505Z 1 [Note] [MY-012535] [InnoDB] Apply batch completed! 2026-03-23T10:11:46.992787Z 1 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_001'. 2026-03-23T10:11:46.993255Z 1 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_002'. 2026-03-23T10:11:46.993931Z 1 [Note] [MY-012910] [InnoDB] Opened 2 existing undo tablespaces. 2026-03-23T10:11:46.994015Z 1 [Note] [MY-011980] [InnoDB] GTID recovery trx_no: 29088791 2026-03-23T10:11:47.184855Z 1 [Note] [MY-013776] [InnoDB] Parallel initialization of rseg complete 2026-03-23T10:11:47.184962Z 1 [Note] [MY-013777] [InnoDB] Time taken to initialize rseg using 4 thread: 190 ms. 2026-03-23T10:11:47.185931Z 1 [Note] [MY-012255] [InnoDB] Removed temporary tablespace data file: "ibtmp1" 2026-03-23T10:11:47.185974Z 1 [Note] [MY-012923] [InnoDB] Creating shared tablespace for temporary tables 2026-03-23T10:11:47.186417Z 1 [Note] [MY-012265] [InnoDB] Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2026-03-23T10:11:47.237022Z 1 [Note] [MY-012266] [InnoDB] File './ibtmp1' size is now 12 MB. 2026-03-23T10:11:47.237314Z 1 [Note] [MY-013627] [InnoDB] Scanning temp tablespace dir:'./#innodb_temp/' 2026-03-23T10:11:47.257885Z 1 [Note] [MY-013018] [InnoDB] Created 128 and tracked 128 new rollback segment(s) in the temporary tablespace. 128 are now active. 2026-03-23T10:11:47.258558Z 1 [Note] [MY-012976] [InnoDB] Percona XtraDB (http://www.percona.com) 8.4.4-4 started; log sequence number 34175394590 2026-03-23T10:11:47.258853Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2026-03-23T10:11:47.258914Z 1 [Note] [MY-013930] [Server] systemd notify: STATUS=InnoDB initialization successful 2026-03-23T10:11:47.269348Z 1 [Note] [MY-011089] [Server] Data dictionary restarting version '80300'. 2026-03-23T10:11:47.405729Z 1 [Note] [MY-013930] [Server] systemd notify: STATUS=InnoDB crash recovery in progress 2026-03-23T10:11:47.422133Z 1 [Note] [MY-012357] [InnoDB] Reading DD tablespace files 2026-03-23T10:11:47.462179Z 1 [Note] [MY-012356] [InnoDB] Scanned 105 tablespaces. Validated 105. 2026-03-23T10:11:47.464306Z 1 [Note] [MY-013930] [Server] systemd notify: STATUS=InnoDB crash recovery successful 2026-03-23T10:11:47.478626Z 1 [Note] [MY-010006] [Server] Using data dictionary with version '80300'. 2026-03-23T10:11:47.480104Z 0 [Note] [MY-013930] [Server] systemd notify: STATUS=Initialization of dynamic plugins in progress 2026-03-23T10:11:47.505494Z 0 [Note] [MY-011332] [Server] Plugin mysqlx reported: 'IPv6 is available' 2026-03-23T10:11:47.506797Z 0 [Note] [MY-011323] [Server] Plugin mysqlx reported: 'X Plugin ready for connections. bind-address: '::' port: 33060' 2026-03-23T10:11:47.506835Z 0 [Note] [MY-011323] [Server] Plugin mysqlx reported: 'X Plugin ready for connections. socket: '/var/lib/mysql/mysqlx.sock'' 2026-03-23T10:11:47.515566Z 0 [System] [MY-013587] [Repl] Plugin group_replication reported: 'Plugin 'group_replication' is starting.' 2026-03-23T10:11:47.515627Z 0 [Note] [MY-011716] [Repl] Plugin group_replication reported: 'Current debug options are: 'GCS_DEBUG_NONE'.' 2026-03-23T10:11:47.515823Z 0 [System] [MY-014023] [Repl] Plugin group_replication reported: 'Plugin 'group_replication' has been started.' 2026-03-23T10:11:47.520348Z 0 [Note] [MY-013930] [Server] systemd notify: STATUS=Initialization of dynamic plugins successful 2026-03-23T10:11:47.540565Z 0 [Note] [MY-010902] [Server] Thread priority attribute setting in Resource Group SQL shall be ignored due to unsupported platform or insufficient privilege. 2026-03-23T10:11:47.542907Z 0 [Note] [MY-010855] [Server] Recovering after a crash using /var/lib/mysql/mysql-bin 2026-03-23T10:11:47.617618Z 0 [System] [MY-010229] [Server] Starting XA crash recovery... 2026-03-23T10:11:47.625159Z 0 [Note] [MY-013911] [Server] Crash recovery finished in binlog engine. No attempts to commit, rollback or prepare any transactions. 2026-03-23T10:11:47.625234Z 0 [Note] [MY-013911] [Server] Crash recovery finished in InnoDB engine. No attempts to commit, rollback or prepare any transactions. 2026-03-23T10:11:47.625243Z 0 [System] [MY-010232] [Server] XA crash recovery finished. 2026-03-23T10:11:47.627271Z 0 [Note] [MY-012487] [InnoDB] DDL log recovery : begin 2026-03-23T10:11:47.627689Z 0 [Note] [MY-012488] [InnoDB] DDL log recovery : end 2026-03-23T10:11:47.627982Z 0 [Note] [MY-011946] [InnoDB] Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2026-03-23T10:11:47.635547Z 0 [Note] [MY-012922] [InnoDB] Waiting for purge to start 2026-03-23T10:11:47.709430Z 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. 2026-03-23T10:11:47.709774Z 0 [Note] [MY-010304] [Server] Skipping generation of SSL certificates as certificate files are present in data directory. 2026-03-23T10:11:47.710838Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2026-03-23T10:11:47.710886Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel. 2026-03-23T10:11:47.711045Z 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. 2026-03-23T10:11:47.711170Z 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. 2026-03-23T10:11:47.711384Z 0 [Note] [MY-010252] [Server] Server hostname (bind-address): '*'; port: 3308 2026-03-23T10:11:47.711458Z 0 [Note] [MY-010253] [Server] IPv6 is available. 2026-03-23T10:11:47.711471Z 0 [Note] [MY-010264] [Server] - '::' resolves to '::'; 2026-03-23T10:11:47.711488Z 0 [Note] [MY-010251] [Server] Server socket created on IP: '::'. 2026-03-23T10:11:47.714218Z 0 [Note] [MY-013930] [Server] systemd notify: STATUS=Components initialization in progress 2026-03-23T10:11:47.717250Z 0 [Note] [MY-013930] [Server] systemd notify: STATUS=Components initialization successful 2026-03-23T10:11:47.717543Z 0 [Warning] [MY-000067] [Server] unknown variable 'loose-greatdb_ha_send_arp_package_times=5'. 2026-03-23T10:11:47.751657Z 0 [Warning] [MY-010604] [Repl] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a replica and has his hostname changed!! Please use '--relay-log=Euler-2-relay-bin' to avoid this problem. 2026-03-23T10:11:47.756361Z 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 GTID protocol will be used to replicate unapplied transactions. 2026-03-23T10:11:47.760501Z 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 GTID protocol will be used to replicate unapplied transactions. 2026-03-23T10:11:47.761262Z 0 [Note] [MY-011025] [Repl] Failed to start replica threads for channel ''. 2026-03-23T10:11:47.764362Z 8 [Note] [MY-010051] [Server] Event Scheduler: scheduler thread started with id 8 2026-03-23T10:11:47.764510Z 0 [Note] [MY-011240] [Server] Plugin mysqlx reported: 'Using SSL configuration from MySQL Server' 2026-03-23T10:11:47.765094Z 0 [Note] [MY-011243] [Server] Plugin mysqlx reported: 'Using OpenSSL for TLS connections' 2026-03-23T10:11:47.765293Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/lib/mysql/mysqlx.sock 2026-03-23T10:11:47.765398Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.4.4-4' socket: '/var/lib/mysql/mysql.sock' port: 3308 GreatSQL (GPL), Release 4, Revision e6eca73c556. 2026-03-23T10:11:47.766373Z 0 [Note] [MY-013930] [Server] systemd notify: READY=1 STATUS=Server is operational MAIN_PID=3735634 2026-03-23T10:11:47.767166Z 4 [System] [MY-011565] [Repl] Plugin group_replication reported: 'Setting super_read_only=ON.' 2026-03-23T10:11:47.767414Z 4 [Note] [MY-011673] [Repl] Plugin group_replication reported: 'Group communication SSL configuration: group_replication_ssl_mode: "DISABLED"' 2026-03-23T10:11:47.768303Z 4 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Debug messages will be sent to: asynchronous::/var/lib/mysql/GCS_DEBUG_TRACE' 2026-03-23T10:11:47.768984Z 4 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Automatically adding IPv4 localhost address to the allowlist. It is mandatory that it is added.' 2026-03-23T10:11:47.769024Z 4 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Automatically adding IPv6 localhost address to the allowlist. It is mandatory that it is added.' 2026-03-23T10:11:47.769136Z 4 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] SSL was not enabled' 2026-03-23T10:11:47.769240Z 4 [Note] [MY-011694] [Repl] Plugin group_replication reported: 'Initialized group communication with configuration: group_replication_group_name: 'ea0200b8-2a9e-4513-ae40-81297357823d'; group_replication_local_address: '172.41.12.2:33061'; group_replication_group_seeds: '172.41.12.1:33061,172.41.12.2:33061,172.41.12.3:33061'; group_replication_bootstrap_group: 'false'; group_replication_poll_spin_loops: 0; group_replication_compression_threshold: 1000000; group_replication_ip_allowlist: '172.41.12.1,172.41.12.2,172.41.12.3'; group_replication_communication_debug_options: 'GCS_DEBUG_NONE'; group_replication_member_expel_timeout: '30'; group_replication_communication_max_message_size: 5242880; group_replication_message_cache_size: '268435456u; group_replication_communication_stack: '0'' 2026-03-23T10:11:47.769314Z 4 [Note] [MY-011643] [Repl] Plugin group_replication reported: 'Member configuration: member_id: 3; member_uuid: "67023f3a-21b4-11f1-85ae-525400003603"; single-primary mode: "true"; group_replication_auto_increment_increment: 7; group_replication_view_change_uuid: "AUTOMATIC";' 2026-03-23T10:11:47.770040Z 4 [Note] [MY-000000] [Repl] Plugin group_replication reported: 'Init certifier broadcast thread' 2026-03-23T10:11:47.770541Z 12 [System] [MY-010597] [Repl] 'CHANGE REPLICATION SOURCE TO FOR CHANNEL 'group_replication_applier' executed'. Previous state source_host='<NULL>', source_port= 0, source_log_file='', source_log_pos= 4, source_bind=''. New state source_host='<NULL>', source_port= 0, source_log_file='', source_log_pos= 4, source_bind=''. 2026-03-23T10:11:47.794039Z 0 [Note] [MY-011946] [InnoDB] Buffer pool(s) load completed at 260323 18:11:47 2026-03-23T10:11:47.810081Z 4 [Note] [MY-011670] [Repl] Plugin group_replication reported: 'Group Replication applier module successfully initialized!' 2026-03-23T10:11:47.810133Z 14 [Note] [MY-010581] [Repl] Replica SQL thread for channel 'group_replication_applier' initialized, starting replication in log 'INVALID' at position 0, relay log './Euler-2-relay-bin-group_replication_applier.000003' position: 4 2026-03-23T10:11:47.810882Z 4 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buckets:2000000, dec_threshold_length:1000000' 2026-03-23T10:11:47.811730Z 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] retry_do_join is called' 2026-03-23T10:11:47.811995Z 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] 1774260707.811928 pid 3735634 xcom_id 0 state xcom_fsm_init action x_fsm_init' 2026-03-23T10:11:47.812057Z 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Init xcom thread' 2026-03-23T10:11:47.812093Z 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Do xcom_thread_init' 2026-03-23T10:11:48.937230Z 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Finish xcom_thread_init' 2026-03-23T10:11:48.937315Z 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Do start xcom_taskmain2' 2026-03-23T10:11:48.937327Z 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] enter taskmain' 2026-03-23T10:11:48.937355Z 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] start_active_network_provider calls configure' 2026-03-23T10:11:48.937366Z 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Using XCom as Communication Stack for XCom' 2026-03-23T10:11:48.937802Z 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] XCom initialized and ready to accept incoming connections on port 33061' 2026-03-23T10:11:48.937856Z 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Creating tcp_server task' 2026-03-23T10:11:48.937895Z 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Successfully connected to the local XCom via anonymous pipe' 2026-03-23T10:11:48.937934Z 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] enter task loop' 2026-03-23T10:11:48.938961Z 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] TCP_NODELAY already set' 2026-03-23T10:11:48.939013Z 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Sucessfully connected to peer 172.41.12.1:33061. Sending a request to be added to the group' 2026-03-23T10:11:48.939039Z 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Sending add_node request to a peer XCom node' 2026-03-23T10:11:48.998756Z 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] xcom_send_client_app_data sets CON_PROTO for fd:55' 2026-03-23T10:11:49.020752Z 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Sending a request to a remote XCom failed. Please check the remote node log for more details.' 2026-03-23T10:11:49.020836Z 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Failed to send add_node request to a peer XCom node.' 2026-03-23T10:11:49.021273Z 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on open 崩溃后，触发了GreatSQL重启，重启加入节点失败 下面是这个节点的GreatSQL配置信息： [mysql] loose-skip-binary-as-hex no-auto-rehash [mysqld] binlog_transaction_compression = ON binlog_expire_logs_seconds = 259200 datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid slow_query_log = OFF long_query_time = 1 log_slow_verbosity = FULL log_error_verbosity = 3 skip_name_resolve=ON character-set-server=UTF8MB4 mysql_native_password=ON lock_wait_timeout=3600 sync_binlog = 1000 max_connections = 5000 innodb_print_all_deadlocks=ON innodb_rollback_on_timeout=ON innodb_buffer_pool_size = 1024M innodb_log_file_size = 512M innodb_flush_log_at_trx_commit=2 innodb_redo_log_capacity=1G innodb_file_per_table = 1 innodb_doublewrite_pages=128 innodb_thread_concurrency=0 innodb_log_buffer_size = 16M innodb_spin_wait_delay=20 innodb_flush_method = O_DIRECT tmp_table_size = 32M max_heap_table_size = 32M thread_cache_size = 200 table_open_cache = 1024 open_files_limit = 65535 sql-mode = NO_ENGINE_SUBSTITUTION port=3308 join_buffer_size = 256K sort_buffer_size = 256K read_buffer_size = 256K read_rnd_buffer_size = 256K # add binlog-format=row binlog_checksum=CRC32 enforce-gtid-consistency=true gtid-mode=on log-bin=/var/lib/mysql/mysql-bin log_slave_updates=ON loose-greatdb_ha_enable_mgr_vip=1 loose-greatdb_ha_mgr_vip_ip=172.41.12.4 loose-greatdb_ha_mgr_vip_mask='255.255.0.0' loose-greatdb_ha_mgr_vip_nic='ens4' loose-greatdb_ha_send_arp_package_times=5 group_replication_ip_allowlist="172.41.12.1,172.41.12.2,172.41.12.3" group_replication_message_cache_size = 256M loose-group_replication_bootstrap_group=off loose-group_replication_exit_state_action=READ_ONLY loose-group_replication_flow_control_mode="QUOTA" loose-greatdb_ha_mgr_read_vip_floating_type = "TO_ANOTHER_SECONDARY" loose-group_replication_group_name="ea0200b8-2a9e-4513-ae40-81297357823d" loose-group_replication_group_seeds="172.41.12.1:33061,172.41.12.2:33061,172.41.12.3:33061" loose-group_replication_local_address="172.41.12.2:33061" loose-group_replication_transaction_size_limit = 5M loose-group_replication_communication_max_message_size = 5M loose-group_replication_member_expel_timeout = 30 loose-group_replication_majority_after_mode=ON loose-group_replication_arbitrator=OFF loose-group_replication_single_primary_fast_mode = 1 loose-group_replication_autorejoin_tries = 5 loose-group_replication_request_time_threshold = 100 loose-group_replication_single_primary_mode=ON loose-group_replication_primary_election_mode=GTID_FIRST loose-group_replication_start_on_boot=on loose-plugin_load_add='greatdb_ha.so' loose-plugin_load_add='group_replication.so' loose-plugin_load_add='mysql_clone.so' loose-group_replication_flow_control_applier_threshold = 3000 loose-group_replication_flow_control_certifier_threshold = 3000 relay_log_recovery=on server_id=3 replica_checkpoint_period=2 replica_parallel_type=LOGICAL_CLOCK replica_parallel_workers=8 replica_preserve_commit_order=ON sql_require_primary_key=1 report_host=172.41.12.2 麻烦大佬看下这个是什么问题，是哪里参数配置有问题吗 |
合作电话：010-64087828
社区邮箱：greatsql@greatdb.com
