2021-07-06 14:02:16+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.4.19+maria~focal started. 2021-07-06 14:02:17+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql' 2021-07-06 14:02:17+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.4.19+maria~focal started. 2021-07-06 14:02:17+00:00 [Note] [Entrypoint]: Initializing database files 2021-07-06 14:02:17 6 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1017: Can't find file: './mysql/' (errno: 2 "No such file or directory") PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER ! To do so, start the server, then issue the following command: '/usr/bin/mysql_secure_installation' which will also give you the option of removing the test databases and anonymous user created by default. This is strongly recommended for production servers. See the MariaDB Knowledgebase at http://mariadb.com/kb or the MySQL manual for more instructions. Please report any problems at http://mariadb.org/jira The latest information about MariaDB is available at http://mariadb.org/. You can find additional information about the MySQL part at: http://dev.mysql.com Consider joining MariaDB's strong and vibrant community: https://mariadb.org/get-involved/ 2021-07-06 14:02:19+00:00 [Note] [Entrypoint]: Database files initialized 2021-07-06 14:02:19+00:00 [Note] [Entrypoint]: Starting temporary server 2021-07-06 14:02:19+00:00 [Note] [Entrypoint]: Waiting for server startup 2021-07-06 14:02:19 0 [Note] mysqld (mysqld 10.4.19-MariaDB-1:10.4.19+maria~focal-log) starting as process 116 ... 2021-07-06 14:02:19 0 [Note] InnoDB: Using Linux native AIO 2021-07-06 14:02:19 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2021-07-06 14:02:19 0 [Note] InnoDB: Uses event mutexes 2021-07-06 14:02:19 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-07-06 14:02:19 0 [Note] InnoDB: Number of pools: 1 2021-07-06 14:02:19 0 [Note] InnoDB: Using SSE2 crc32 instructions 2021-07-06 14:02:19 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts) 2021-07-06 14:02:19 0 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M 2021-07-06 14:02:20 0 [Note] InnoDB: Completed initialization of buffer pool 2021-07-06 14:02:20 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2021-07-06 14:02:20 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2021-07-06 14:02:20 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-07-06 14:02:20 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-07-06 14:02:20 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2021-07-06 14:02:20 0 [Note] InnoDB: Waiting for purge to start 2021-07-06 14:02:20 0 [Note] InnoDB: 10.4.19 started; log sequence number 60967; transaction id 20 2021-07-06 14:02:20 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2021-07-06 14:02:20 0 [Note] Plugin 'FEEDBACK' is disabled. 2021-07-06 14:02:20 0 [Note] InnoDB: Buffer pool(s) load completed at 210706 14:02:20 2021-07-06 14:02:20 0 [Warning] 'user' entry 'root@7ca80d653702' ignored in --skip-name-resolve mode. 2021-07-06 14:02:20 0 [Warning] 'proxies_priv' entry '@% root@7ca80d653702' ignored in --skip-name-resolve mode. 2021-07-06 14:02:20 0 [Note] Reading of all Master_info entries succeeded 2021-07-06 14:02:20 0 [Note] Added new Master_info '' to hash table 2021-07-06 14:02:20 0 [Note] mysqld: ready for connections. Version: '10.4.19-MariaDB-1:10.4.19+maria~focal-log' socket: '/var/run/mysqld/mysqld.sock' port: 0 mariadb.org binary distribution 2021-07-06 14:02:20+00:00 [Note] [Entrypoint]: Temporary server started. Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it. Warning: Unable to load '/usr/share/zoneinfo/leapseconds' as time zone. Skipping it. Warning: Unable to load '/usr/share/zoneinfo/tzdata.zi' as time zone. Skipping it. 2021-07-06 14:02:25 11 [Warning] 'proxies_priv' entry '@% root@7ca80d653702' ignored in --skip-name-resolve mode. 2021-07-06 14:02:25+00:00 [Note] [Entrypoint]: Creating database wordpress 2021-07-06 14:02:25+00:00 [Note] [Entrypoint]: Creating user wordpress 2021-07-06 14:02:25+00:00 [Note] [Entrypoint]: Giving user wordpress access to schema wordpress 2021-07-06 14:02:25+00:00 [Note] [Entrypoint]: Stopping temporary server 2021-07-06 14:02:25 0 [Note] mysqld (initiated by: root[root] @ localhost []): Normal shutdown 2021-07-06 14:02:25 0 [Note] Event Scheduler: Purging the queue. 0 events 2021-07-06 14:02:25 0 [Note] InnoDB: FTS optimize thread exiting. 2021-07-06 14:02:25 0 [Note] InnoDB: Starting shutdown... 2021-07-06 14:02:25 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2021-07-06 14:02:25 0 [Note] InnoDB: Buffer pool(s) dump completed at 210706 14:02:25 2021-07-06 14:02:27 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2021-07-06 14:02:27 0 [Note] InnoDB: Shutdown completed; log sequence number 60976; transaction id 21 2021-07-06 14:02:27 0 [Note] mysqld: Shutdown complete 2021-07-06 14:02:28+00:00 [Note] [Entrypoint]: Temporary server stopped 2021-07-06 14:02:28+00:00 [Note] [Entrypoint]: MariaDB init process done. Ready for start up. 2021-07-06 14:02:28 0 [Note] mysqld (mysqld 10.4.19-MariaDB-1:10.4.19+maria~focal-log) starting as process 1 ... 2021-07-06 14:02:28 0 [Note] WSREP: Loading provider /usr/lib/galera/libgalera_smm.so initial position: 00000000-0000-0000-0000-000000000000:-1 2021-07-06 14:02:28 0 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib/galera/libgalera_smm.so' 2021-07-06 14:02:28 0 [Note] WSREP: wsrep_load(): Galera 26.4.8(r902dd268) by Codership Oy loaded successfully. 2021-07-06 14:02:28 0 [Note] WSREP: CRC-32C: using 64-bit x86 acceleration. 2021-07-06 14:02:28 0 [Warning] WSREP: Could not open state file for reading: '/var/lib/mysql//grastate.dat' 2021-07-06 14:02:28 0 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1, safe_to_bootstrap: 1 2021-07-06 14:02:28 0 [Note] WSREP: GCache DEBUG: opened preamble: Version: 0 UUID: 00000000-0000-0000-0000-000000000000 Seqno: -1 - -1 Offset: -1 Synced: 0 2021-07-06 14:02:28 0 [Note] WSREP: Skipped GCache ring buffer recovery: could not determine history UUID. 2021-07-06 14:02:28 0 [Note] WSREP: Passing config to GCS: base_dir = /var/lib/mysql/; base_host = 172.19.0.2; base_port = 4567; cert.log_conflicts = no; cert.optimistic_pa = yes; debug = no; evs.auto_evict = 0; evs.delay_margin = PT1S; evs.delayed_keep_period = PT30S; evs.inactive_check_period = PT0.5S; evs.inactive_timeout = PT15S; evs.join_retrans_period = PT1S; evs.max_install_timeouts = 3; evs.send_window = 4; evs.stats_report_period = PT1M; evs.suspect_timeout = PT5S; evs.user_send_window = 2; evs.view_forget_timeout = PT24H; gcache.dir = /var/lib/mysql/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = galera.cache; gcache.page_size = 128M; gcache.recover = yes; gcache.size = 128M; gcomm.thread_prio = ; gcs.fc_debug = 0; gcs.fc_factor = 0.8; gcs.fc_limit = 80; gcs.fc_master_slave = no; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = no; gmcast.segment = 0; gmcast.version = 0; pc.announce_timeout = PT3S; pc.checksum = fa 2021-07-06 14:02:28 0 [Note] WSREP: Start replication 2021-07-06 14:02:28 0 [Note] WSREP: Connecting with bootstrap option: 1 2021-07-06 14:02:28 0 [Note] WSREP: Setting GCS initial position to 00000000-0000-0000-0000-000000000000:-1 2021-07-06 14:02:28 0 [Note] WSREP: protonet asio version 0 2021-07-06 14:02:28 0 [Note] WSREP: Using CRC-32C for message checksums. 2021-07-06 14:02:28 0 [Note] WSREP: backend: asio 2021-07-06 14:02:28 0 [Note] WSREP: gcomm thread scheduling priority set to other:0 2021-07-06 14:02:28 0 [Warning] WSREP: access file(/var/lib/mysql//gvwstate.dat) failed(No such file or directory) 2021-07-06 14:02:28 0 [Note] WSREP: restore pc from disk failed 2021-07-06 14:02:28 0 [Note] WSREP: GMCast version 0 2021-07-06 14:02:28 0 [Note] WSREP: (cc5d911f-ad80, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567 2021-07-06 14:02:28 0 [Note] WSREP: (cc5d911f-ad80, 'tcp://0.0.0.0:4567') multicast: , ttl: 1 2021-07-06 14:02:28 0 [Note] WSREP: EVS version 1 2021-07-06 14:02:28 0 [Note] WSREP: gcomm: bootstrapping new group 'galera-docker' 2021-07-06 14:02:28 0 [Note] WSREP: start_prim is enabled, turn off pc_recovery 2021-07-06 14:02:28 0 [Note] WSREP: EVS version upgrade 0 -> 1 2021-07-06 14:02:28 0 [Note] WSREP: PC protocol upgrade 0 -> 1 2021-07-06 14:02:28 0 [Note] WSREP: Node cc5d911f-ad80 state prim 2021-07-06 14:02:28 0 [Note] WSREP: view(view_id(PRIM,cc5d911f-ad80,1) memb { cc5d911f-ad80,0 } joined { } left { } partitioned { }) 2021-07-06 14:02:28 0 [Note] WSREP: save pc into disk 2021-07-06 14:02:28 0 [Note] WSREP: gcomm: connected 2021-07-06 14:02:28 0 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636 2021-07-06 14:02:28 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0) 2021-07-06 14:02:28 0 [Note] WSREP: Opened channel 'galera-docker' 2021-07-06 14:02:28 1 [Note] WSREP: Starting rollbacker thread 1 2021-07-06 14:02:28 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 1 2021-07-06 14:02:28 2 [Note] WSREP: Starting applier thread 2 2021-07-06 14:02:28 0 [Note] WSREP: Starting new group from scratch: cc5ea767-de62-11eb-849f-6f1c1e5640d4 2021-07-06 14:02:28 0 [Note] WSREP: STATE_EXCHANGE: sent state UUID: cc5ebc84-de62-11eb-8f32-eabc69e7835d 2021-07-06 14:02:28 0 [Note] WSREP: STATE EXCHANGE: sent state msg: cc5ebc84-de62-11eb-8f32-eabc69e7835d 2021-07-06 14:02:28 0 [Note] WSREP: STATE EXCHANGE: got state msg: cc5ebc84-de62-11eb-8f32-eabc69e7835d from 0 (galera-node-1) 2021-07-06 14:02:28 0 [Note] WSREP: Quorum results: version = 6, component = PRIMARY, conf_id = 0, members = 1/1 (joined/total), act_id = 0, last_appl. = 0, protocols = 2/10/4 (gcs/repl/appl), vote policy= 0, group UUID = cc5ea767-de62-11eb-849f-6f1c1e5640d4 2021-07-06 14:02:28 0 [Note] WSREP: Flow-control interval: [64, 80] 2021-07-06 14:02:28 0 [Note] WSREP: Restored state OPEN -> JOINED (1) 2021-07-06 14:02:28 0 [Note] WSREP: Member 0.0 (galera-node-1) synced with group. 2021-07-06 14:02:28 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 1) 2021-07-06 14:02:28 2 [Note] WSREP: ####### processing CC 1, local, ordered 2021-07-06 14:02:28 2 [Note] WSREP: Process first view: cc5ea767-de62-11eb-849f-6f1c1e5640d4 my uuid: cc5d911f-de62-11eb-ad80-8f500ed8688f 2021-07-06 14:02:28 2 [Note] WSREP: Server galera-node-1 connected to cluster at position cc5ea767-de62-11eb-849f-6f1c1e5640d4:1 with ID cc5d911f-de62-11eb-ad80-8f500ed8688f 2021-07-06 14:02:28 2 [Note] WSREP: Server status change disconnected -> connected 2021-07-06 14:02:28 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2021-07-06 14:02:28 2 [Note] WSREP: ####### My UUID: cc5d911f-de62-11eb-ad80-8f500ed8688f 2021-07-06 14:02:28 2 [Note] WSREP: Cert index reset to 00000000-0000-0000-0000-000000000000:-1 (proto: 10), state transfer needed: no 2021-07-06 14:02:28 0 [Note] WSREP: Service thread queue flushed. 2021-07-06 14:02:28 2 [Note] WSREP: ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:-1, protocol version: -1 2021-07-06 14:02:28 2 [Note] WSREP: REPL Protocols: 10 (5) 2021-07-06 14:02:28 2 [Note] WSREP: ####### Adjusting cert position: -1 -> 1 2021-07-06 14:02:28 0 [Note] WSREP: Service thread queue flushed. 2021-07-06 14:02:28 2 [Note] WSREP: GCache history reset: 00000000-0000-0000-0000-000000000000:0 -> cc5ea767-de62-11eb-849f-6f1c1e5640d4:0 2021-07-06 14:02:28 2 [Note] WSREP: ================================================ View: id: cc5ea767-de62-11eb-849f-6f1c1e5640d4:1 status: primary protocol_version: 4 capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO final: no own_index: 0 members(1): 0: cc5d911f-de62-11eb-ad80-8f500ed8688f, galera-node-1 ================================================= 2021-07-06 14:02:28 2 [Note] WSREP: Server status change connected -> joiner 2021-07-06 14:02:28 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2021-07-06 14:02:28 2 [Note] WSREP: Server status change joiner -> initializing 2021-07-06 14:02:28 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2021-07-06 14:02:28 0 [Note] InnoDB: Using Linux native AIO 2021-07-06 14:02:28 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2021-07-06 14:02:28 0 [Note] InnoDB: Uses event mutexes 2021-07-06 14:02:28 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-07-06 14:02:28 0 [Note] InnoDB: Number of pools: 1 2021-07-06 14:02:28 0 [Note] InnoDB: Using SSE2 crc32 instructions 2021-07-06 14:02:28 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts) 2021-07-06 14:02:28 0 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M 2021-07-06 14:02:28 0 [Note] InnoDB: Completed initialization of buffer pool 2021-07-06 14:02:28 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2021-07-06 14:02:28 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2021-07-06 14:02:28 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-07-06 14:02:28 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-07-06 14:02:28 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2021-07-06 14:02:28 0 [Note] InnoDB: Waiting for purge to start 2021-07-06 14:02:28 0 [Note] InnoDB: 10.4.19 started; log sequence number 60976; transaction id 20 2021-07-06 14:02:28 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2021-07-06 14:02:28 0 [Note] Plugin 'FEEDBACK' is disabled. 2021-07-06 14:02:28 0 [Note] InnoDB: Buffer pool(s) load completed at 210706 14:02:28 2021-07-06 14:02:28 0 [Note] Server socket created on IP: '::'. 2021-07-06 14:02:28 0 [Warning] 'proxies_priv' entry '@% root@7ca80d653702' ignored in --skip-name-resolve mode. 2021-07-06 14:02:28 0 [Note] WSREP: wsrep_init_schema_and_SR (nil) 2021-07-06 14:02:28 0 [Note] WSREP: Server initialized 2021-07-06 14:02:28 0 [Note] WSREP: Server status change initializing -> initialized 2021-07-06 14:02:28 0 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2021-07-06 14:02:28 2 [Note] WSREP: Bootstrapping a new cluster, setting initial position to 00000000-0000-0000-0000-000000000000:-1 2021-07-06 14:02:28 10 [Note] WSREP: Cluster table is empty, not recovering transactions 2021-07-06 14:02:28 2 [Note] WSREP: Server status change initialized -> joined 2021-07-06 14:02:28 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2021-07-06 14:02:28 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2021-07-06 14:02:28 12 [Note] WSREP: Starting applier thread 12 2021-07-06 14:02:28 22 [Note] WSREP: Starting applier thread 22 2021-07-06 14:02:28 14 [Note] WSREP: Starting applier thread 14 2021-07-06 14:02:28 15 [Note] WSREP: Starting applier thread 15 2021-07-06 14:02:28 11 [Note] WSREP: Starting applier thread 11 2021-07-06 14:02:28 0 [Note] Reading of all Master_info entries succeeded 2021-07-06 14:02:28 0 [Note] Added new Master_info '' to hash table 2021-07-06 14:02:28 13 [Note] WSREP: Starting applier thread 13 2021-07-06 14:02:28 17 [Note] WSREP: Starting applier thread 17 2021-07-06 14:02:28 16 [Note] WSREP: Starting applier thread 16 2021-07-06 14:02:28 25 [Note] WSREP: Starting applier thread 25 2021-07-06 14:02:28 19 [Note] WSREP: Starting applier thread 19 2021-07-06 14:02:28 20 [Note] WSREP: Starting applier thread 20 2021-07-06 14:02:28 18 [Note] WSREP: Starting applier thread 18 2021-07-06 14:02:28 0 [Note] mysqld: ready for connections. Version: '10.4.19-MariaDB-1:10.4.19+maria~focal-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution 2021-07-06 14:02:28 24 [Note] WSREP: Starting applier thread 24 2021-07-06 14:02:28 21 [Note] WSREP: Starting applier thread 21 2021-07-06 14:02:28 23 [Note] WSREP: Starting applier thread 23 2021-07-06 14:02:28 2 [Note] WSREP: Lowest cert index boundary for CC from group: 1 2021-07-06 14:02:28 2 [Note] WSREP: Min available from gcache for CC from group: 1 2021-07-06 14:02:28 2 [Note] WSREP: Server galera-node-1 synced with group 2021-07-06 14:02:28 2 [Note] WSREP: Server status change joined -> synced 2021-07-06 14:02:28 2 [Note] WSREP: Synchronized with group, ready for connections 2021-07-06 14:02:28 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2021-07-06 14:02:38 0 [Note] WSREP: (cc5d911f-ad80, 'tcp://0.0.0.0:4567') connection established to d2c5ba37-9ab2 tcp://172.19.0.3:4567 2021-07-06 14:02:38 0 [Note] WSREP: (cc5d911f-ad80, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: 2021-07-06 14:02:39 0 [Note] WSREP: declaring d2c5ba37-9ab2 at tcp://172.19.0.3:4567 stable 2021-07-06 14:02:39 0 [Note] WSREP: Node cc5d911f-ad80 state prim 2021-07-06 14:02:39 0 [Note] WSREP: view(view_id(PRIM,cc5d911f-ad80,2) memb { cc5d911f-ad80,0 d2c5ba37-9ab2,0 } joined { } left { } partitioned { }) 2021-07-06 14:02:39 0 [Note] WSREP: save pc into disk 2021-07-06 14:02:39 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 2 2021-07-06 14:02:39 0 [Note] WSREP: STATE_EXCHANGE: sent state UUID: d31381ce-de62-11eb-92a5-13a517e22f9b 2021-07-06 14:02:39 0 [Note] WSREP: STATE EXCHANGE: sent state msg: d31381ce-de62-11eb-92a5-13a517e22f9b 2021-07-06 14:02:39 0 [Note] WSREP: STATE EXCHANGE: got state msg: d31381ce-de62-11eb-92a5-13a517e22f9b from 0 (galera-node-1) 2021-07-06 14:02:39 0 [Note] WSREP: STATE EXCHANGE: got state msg: d31381ce-de62-11eb-92a5-13a517e22f9b from 1 (galera-node-2) 2021-07-06 14:02:39 0 [Note] WSREP: Quorum results: version = 6, component = PRIMARY, conf_id = 1, members = 1/2 (joined/total), act_id = 1, last_appl. = 0, protocols = 2/10/4 (gcs/repl/appl), vote policy= 0, group UUID = cc5ea767-de62-11eb-849f-6f1c1e5640d4 2021-07-06 14:02:39 0 [Note] WSREP: Flow-control interval: [90, 113] 2021-07-06 14:02:39 2 [Note] WSREP: ####### processing CC 2, local, ordered 2021-07-06 14:02:39 2 [Note] WSREP: ####### My UUID: cc5d911f-de62-11eb-ad80-8f500ed8688f 2021-07-06 14:02:39 2 [Note] WSREP: Skipping cert index reset 2021-07-06 14:02:39 2 [Note] WSREP: REPL Protocols: 10 (5) 2021-07-06 14:02:39 2 [Note] WSREP: ####### Adjusting cert position: 1 -> 2 2021-07-06 14:02:39 0 [Note] WSREP: Service thread queue flushed. 2021-07-06 14:02:39 2 [Note] WSREP: ================================================ View: id: cc5ea767-de62-11eb-849f-6f1c1e5640d4:2 status: primary protocol_version: 4 capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO final: no own_index: 0 members(2): 0: cc5d911f-de62-11eb-ad80-8f500ed8688f, galera-node-1 1: d2c5ba37-de62-11eb-9ab2-fed360ebd9e6, galera-node-2 ================================================= 2021-07-06 14:02:39 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2021-07-06 14:02:39 2 [Note] WSREP: Lowest cert index boundary for CC from group: 2 2021-07-06 14:02:39 2 [Note] WSREP: Min available from gcache for CC from group: 1 2021-07-06 14:02:40 0 [Note] WSREP: Member 1.0 (galera-node-2) requested state transfer from '*any*'. Selected 0.0 (galera-node-1)(SYNCED) as donor. 2021-07-06 14:02:40 0 [Note] WSREP: Shifting SYNCED -> DONOR/DESYNCED (TO: 2) 2021-07-06 14:02:40 2 [Note] WSREP: Detected STR version: 1, req_len: 110, req: STRv1 2021-07-06 14:02:40 2 [Note] WSREP: Cert index preload: 2 -> 2 2021-07-06 14:02:40 2 [Note] WSREP: Server status change synced -> donor 2021-07-06 14:02:40 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2021-07-06 14:02:40 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2021-07-06 14:02:40 0 [Note] WSREP: async IST sender starting to serve tcp://172.19.0.3:4568 sending 2-2, preload starts from 2 2021-07-06 14:02:40 0 [Note] WSREP: IST sender 2 -> 2 2021-07-06 14:02:40 0 [Note] WSREP: Donor monitor thread started to monitor 2021-07-06 14:02:40 0 [Note] WSREP: Running: 'wsrep_sst_rsync --role 'donor' --address '172.19.0.3:4444/rsync_sst' --socket '/var/run/mysqld/mysqld.sock' --datadir '/var/lib/mysql/' --gtid 'cc5ea767-de62-11eb-849f-6f1c1e5640d4:2' --gtid-domain-id '0' --binlog '/var/log/mysql/binlogs'' 2021-07-06 14:02:40 2 [Note] WSREP: sst_donor_thread signaled with 0 2021-07-06 14:02:40 0 [Note] WSREP: Flushing tables for SST... 2021-07-06 14:02:40 0 [Note] WSREP: pause 2021-07-06 14:02:40 0 [Note] WSREP: Provider paused at cc5ea767-de62-11eb-849f-6f1c1e5640d4:2 (5) 2021-07-06 14:02:40 0 [Note] WSREP: Server paused at: 2 2021-07-06 14:02:40 0 [Note] WSREP: Tables flushed. WSREP_SST: [INFO] Preparing binlog files for transfer: (20210706 14:02:41.189) binlogs.000004 2021-07-06 14:02:41 0 [Note] WSREP: resume 2021-07-06 14:02:41 0 [Note] WSREP: resuming provider at 5 2021-07-06 14:02:41 0 [Note] WSREP: Provider resumed. 2021-07-06 14:02:41 0 [Note] WSREP: SST sent: cc5ea767-de62-11eb-849f-6f1c1e5640d4:2 2021-07-06 14:02:41 0 [Note] WSREP: Server status change donor -> joined 2021-07-06 14:02:41 0 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2021-07-06 14:02:41 0 [Note] WSREP: Donor monitor thread ended with total time 1 sec 2021-07-06 14:02:41 0 [Note] WSREP: 0.0 (galera-node-1): State transfer to 1.0 (galera-node-2) complete. 2021-07-06 14:02:41 0 [Note] WSREP: Shifting DONOR/DESYNCED -> JOINED (TO: 2) 2021-07-06 14:02:41 0 [Note] WSREP: Member 0.0 (galera-node-1) synced with group. 2021-07-06 14:02:41 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 2) 2021-07-06 14:02:41 24 [Note] WSREP: Server galera-node-1 synced with group 2021-07-06 14:02:41 24 [Note] WSREP: Server status change joined -> synced 2021-07-06 14:02:41 24 [Note] WSREP: Synchronized with group, ready for connections 2021-07-06 14:02:41 24 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2021-07-06 14:02:42 0 [Note] WSREP: (cc5d911f-ad80, 'tcp://0.0.0.0:4567') turning message relay requesting off 2021-07-06 14:02:45 0 [Note] WSREP: async IST sender served 2021-07-06 14:02:45 0 [Note] WSREP: 1.0 (galera-node-2): State transfer from 0.0 (galera-node-1) complete. 2021-07-06 14:02:45 0 [Note] WSREP: Member 1.0 (galera-node-2) synced with group. 2021-07-06 14:03:00 0 [Note] WSREP: (cc5d911f-ad80, 'tcp://0.0.0.0:4567') connection established to dfaeb3ff-a663 tcp://172.19.0.4:4567 2021-07-06 14:03:00 0 [Note] WSREP: (cc5d911f-ad80, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: 2021-07-06 14:03:01 0 [Note] WSREP: declaring d2c5ba37-9ab2 at tcp://172.19.0.3:4567 stable 2021-07-06 14:03:01 0 [Note] WSREP: declaring dfaeb3ff-a663 at tcp://172.19.0.4:4567 stable 2021-07-06 14:03:01 0 [Note] WSREP: Node cc5d911f-ad80 state prim 2021-07-06 14:03:01 0 [Note] WSREP: view(view_id(PRIM,cc5d911f-ad80,3) memb { cc5d911f-ad80,0 d2c5ba37-9ab2,0 dfaeb3ff-a663,0 } joined { } left { } partitioned { }) 2021-07-06 14:03:01 0 [Note] WSREP: save pc into disk 2021-07-06 14:03:01 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 3 2021-07-06 14:03:01 0 [Note] WSREP: STATE_EXCHANGE: sent state UUID: dffd24a0-de62-11eb-8f20-5a92a8769d83 2021-07-06 14:03:01 0 [Note] WSREP: STATE EXCHANGE: sent state msg: dffd24a0-de62-11eb-8f20-5a92a8769d83 2021-07-06 14:03:01 0 [Note] WSREP: STATE EXCHANGE: got state msg: dffd24a0-de62-11eb-8f20-5a92a8769d83 from 0 (galera-node-1) 2021-07-06 14:03:01 0 [Note] WSREP: STATE EXCHANGE: got state msg: dffd24a0-de62-11eb-8f20-5a92a8769d83 from 1 (galera-node-2) 2021-07-06 14:03:01 0 [Note] WSREP: STATE EXCHANGE: got state msg: dffd24a0-de62-11eb-8f20-5a92a8769d83 from 2 (galera-node-3) 2021-07-06 14:03:01 0 [Note] WSREP: Quorum results: version = 6, component = PRIMARY, conf_id = 2, members = 2/3 (joined/total), act_id = 2, last_appl. = 0, protocols = 2/10/4 (gcs/repl/appl), vote policy= 0, group UUID = cc5ea767-de62-11eb-849f-6f1c1e5640d4 2021-07-06 14:03:01 0 [Note] WSREP: Flow-control interval: [111, 139] 2021-07-06 14:03:01 17 [Note] WSREP: ####### processing CC 3, local, ordered 2021-07-06 14:03:01 17 [Note] WSREP: ####### My UUID: cc5d911f-de62-11eb-ad80-8f500ed8688f 2021-07-06 14:03:01 17 [Note] WSREP: Skipping cert index reset 2021-07-06 14:03:01 17 [Note] WSREP: REPL Protocols: 10 (5) 2021-07-06 14:03:01 17 [Note] WSREP: ####### Adjusting cert position: 2 -> 3 2021-07-06 14:03:01 0 [Note] WSREP: Service thread queue flushed. 2021-07-06 14:03:01 17 [Note] WSREP: ================================================ View: id: cc5ea767-de62-11eb-849f-6f1c1e5640d4:3 status: primary protocol_version: 4 capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO final: no own_index: 0 members(3): 0: cc5d911f-de62-11eb-ad80-8f500ed8688f, galera-node-1 1: d2c5ba37-de62-11eb-9ab2-fed360ebd9e6, galera-node-2 2: dfaeb3ff-de62-11eb-a663-2b5f02d792dd, galera-node-3 ================================================= 2021-07-06 14:03:01 17 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2021-07-06 14:03:01 17 [Note] WSREP: Lowest cert index boundary for CC from group: 3 2021-07-06 14:03:01 17 [Note] WSREP: Min available from gcache for CC from group: 1 2021-07-06 14:03:02 0 [Note] WSREP: Member 2.0 (galera-node-3) requested state transfer from '*any*'. Selected 0.0 (galera-node-1)(SYNCED) as donor. 2021-07-06 14:03:02 0 [Note] WSREP: Shifting SYNCED -> DONOR/DESYNCED (TO: 3) 2021-07-06 14:03:02 17 [Note] WSREP: Detected STR version: 1, req_len: 110, req: STRv1 2021-07-06 14:03:02 17 [Note] WSREP: Cert index preload: 3 -> 3 2021-07-06 14:03:02 0 [Note] WSREP: async IST sender starting to serve tcp://172.19.0.4:4568 sending 3-3, preload starts from 3 2021-07-06 14:03:02 17 [Note] WSREP: Server status change synced -> donor 2021-07-06 14:03:02 17 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2021-07-06 14:03:02 17 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2021-07-06 14:03:02 0 [Note] WSREP: Donor monitor thread started to monitor 2021-07-06 14:03:02 0 [Note] WSREP: Running: 'wsrep_sst_rsync --role 'donor' --address '172.19.0.4:4444/rsync_sst' --socket '/var/run/mysqld/mysqld.sock' --datadir '/var/lib/mysql/' --gtid 'cc5ea767-de62-11eb-849f-6f1c1e5640d4:3' --gtid-domain-id '0' --binlog '/var/log/mysql/binlogs'' 2021-07-06 14:03:02 0 [Note] WSREP: IST sender 3 -> 3 2021-07-06 14:03:02 17 [Note] WSREP: sst_donor_thread signaled with 0 2021-07-06 14:03:02 0 [Note] WSREP: Flushing tables for SST... 2021-07-06 14:03:02 0 [Note] WSREP: pause 2021-07-06 14:03:02 0 [Note] WSREP: Provider paused at cc5ea767-de62-11eb-849f-6f1c1e5640d4:3 (10) 2021-07-06 14:03:02 0 [Note] WSREP: Server paused at: 3 2021-07-06 14:03:02 0 [Note] WSREP: Tables flushed. WSREP_SST: [INFO] Preparing binlog files for transfer: (20210706 14:03:02.774) binlogs.000005 2021-07-06 14:03:03 0 [Note] WSREP: resume 2021-07-06 14:03:03 0 [Note] WSREP: resuming provider at 10 2021-07-06 14:03:03 0 [Note] WSREP: Provider resumed. 2021-07-06 14:03:03 0 [Note] WSREP: SST sent: cc5ea767-de62-11eb-849f-6f1c1e5640d4:3 2021-07-06 14:03:03 0 [Note] WSREP: Server status change donor -> joined 2021-07-06 14:03:03 0 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2021-07-06 14:03:03 0 [Note] WSREP: 0.0 (galera-node-1): State transfer to 2.0 (galera-node-3) complete. 2021-07-06 14:03:03 0 [Note] WSREP: Shifting DONOR/DESYNCED -> JOINED (TO: 3) 2021-07-06 14:03:03 0 [Note] WSREP: Member 0.0 (galera-node-1) synced with group. 2021-07-06 14:03:03 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 3) 2021-07-06 14:03:03 25 [Note] WSREP: Server galera-node-1 synced with group 2021-07-06 14:03:03 25 [Note] WSREP: Server status change joined -> synced 2021-07-06 14:03:03 25 [Note] WSREP: Synchronized with group, ready for connections 2021-07-06 14:03:03 25 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2021-07-06 14:03:03 0 [Note] WSREP: Donor monitor thread ended with total time 1 sec 2021-07-06 14:03:03 0 [Note] WSREP: (cc5d911f-ad80, 'tcp://0.0.0.0:4567') turning message relay requesting off 2021-07-06 14:03:06 0 [Note] WSREP: async IST sender served 2021-07-06 14:03:06 0 [Note] WSREP: 2.0 (galera-node-3): State transfer from 0.0 (galera-node-1) complete. 2021-07-06 14:03:06 0 [Note] WSREP: Member 2.0 (galera-node-3) synced with group.