从奴隶获得错误的SQL线程时开始之前PXC 8.0节点准备接受连接而加入PXC集群

[1];做mysql d1 < data.sql;睡眠0.1;完成

[1];做mysql d2 < data.sql;睡眠0.1;完成

2022 - 07 - 12 t02:41:24.920734z 9(错误)[我- 010584][Repl]奴隶SQL频道”:错误的WSREP尚未准备节点应用程序使用的查询。默认数据库:“员工”。查询:‘开始’,Error_code:我- 001047 2022 - 07 - 12 - t02:41:24.920850z 9[警告][我- 010584][Repl]奴隶:WSREP尚未准备节点应用程序使用Error_code:我- 001047 2022 - 07 - 12 - t02:41:24.920883z 9(错误)[我- 010586][Repl]错误运行查询,奴隶SQL线程中止。解决这个问题,并重新启动奴隶SQL线程与“奴隶”开始。我们停在mysql-bin日志”。000004' position 23890123 2022-07-12T02:41:24.923467Z 2 [Note] [MY-000000] [Galera] Recording CC from sst: 296 2022-07-12T02:41:24.923566Z 2 [Note] [MY-000000] [Galera] Lowest cert index boundary for CC from sst: 296 2022-07-12T02:41:24.923630Z 2 [Note] [MY-000000] [Galera] Min available from gcache for CC from sst: 68 2022-07-12T02:41:24.923892Z 0 [Note] [MY-000000] [Galera] 2.0 (test-work): State transfer from 0.0 (test-work) complete. 2022-07-12T02:41:24.923929Z 0 [Note] [MY-000000] [Galera] SST leaving flow control 2022-07-12T02:41:24.923957Z 0 [Note] [MY-000000] [Galera] Shifting JOINER -> JOINED (TO: 296) 2022-07-12T02:41:24.924299Z 0 [Note] [MY-000000] [Galera] Member 2.0 (test-work) synced with group. 2022-07-12T02:41:24.924323Z 0 [Note] [MY-000000] [Galera] Shifting JOINED -> SYNCED (TO: 296) 2022-07-12T02:41:24.924381Z 2 [Note] [MY-000000] [Galera] Server test-work synced with group 2022-07-12T02:41:24.924434Z 2 [Note] [MY-000000] [WSREP] Server status change joined -> synced 2022-07-12T02:41:24.924508Z 2 [Note] [MY-000000] [WSREP] Synchronized with group, ready for connections 2022-07-12T02:41:24.924559Z 2 [Note] [MY-000000] [WSREP] wsrep_notify_cmd is not defined, skipping notification.

2022 - 07 - 12 - t03:15:31.139508z 3[注]奴隶I / O的线程频道”:连接到主(电子邮件保护):20541,开始复制日志mysql-bin。000002' at position 464635733 2022-07-12T03:15:31.152385Z 0 [Note] Event Scheduler: Loaded 0 events 2022-07-12T03:15:31.158387Z 0 [Note] WSREP: Signalling provider to continue on SST completion. 2022-07-12T03:15:31.158445Z 0 [Note] WSREP: Initialized wsrep sidno 3 2022-07-12T03:15:31.158493Z 0 [Note] WSREP: SST received: f16aa510-018c-11ed-a03b-97efe1fe04a0:2039 2022-07-12T03:15:31.158725Z 0 [Note] /home/test/opt/percona-xtradb-cluster/5.7.38/bin/mysqld: ready for connections. Version: '5.7.38-41-59-log' socket: '/tmp/mysql_sandbox27541.sock' port: 27541 Percona XtraDB Cluster binary (GPL) 5.7.38-rel41-59, Revision 37a6216, wsrep_31.59 2022-07-12T03:15:31.170359Z 1 [Note] WSREP: Receiving IST: 973 writesets, seqnos 2039-3012 2022-07-12T03:15:31.170632Z 0 [Note] WSREP: Receiving IST... 0.0% ( 0/973 events) complete. 2022-07-12T03:15:41.252819Z 0 [Note] WSREP: Receiving IST... 97.0% (944/973 events) complete. 2022-07-12T03:15:46.326208Z 0 [Note] WSREP: Receiving IST...100.0% (973/973 events) complete. 2022-07-12T03:15:46.326555Z 1 [Note] WSREP: IST received: f16aa510-018c-11ed-a03b-97efe1fe04a0:3012 2022-07-12T03:15:46.327181Z 0 [Note] WSREP: 2.0 (test-work): State transfer from 1.0 (test-work) complete. 2022-07-12T03:15:46.327201Z 0 [Note] WSREP: SST leaving flow control 2022-07-12T03:15:46.327211Z 0 [Note] WSREP: Shifting JOINER -> JOINED (TO: 3062) 2022-07-12T03:15:46.327509Z 0 [Note] WSREP: Member 2.0 (test-work) synced with group. 2022-07-12T03:15:46.327527Z 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 3062) 2022-07-12T03:15:53.841359Z 1 [Note] WSREP: Synchronized with group, ready for connections 2022-07-12T03:15:53.841402Z 1 [Note] WSREP: Setting wsrep_ready to true 2022-07-12T03:15:53.841417Z 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2022-07-12T03:15:53.841426Z 4 [Note] Slave SQL thread for channel '' initialized, starting replication in log 'mysql-bin.000002' at position 464635733, relay log './mysql-relay.000009' position: 4