New Node Not Connected

33 views

Skip to first unread message

Bruno Macedo

unread,

Apr 29, 2025, 1:30:44 PMApr 29

to codership

Hello!

I'm having trouble starting a new node in my cluster.

I have a cluster with 3 nodes, it's working normally, now I'm trying to add another node and it just won't connect, if I check the wsrep_cluster_size variable, it alternates between 3 and 4, one second it has 3, the next it has 4 and so on.

It seems like it connects and then immediately loses the connection.

I am sending below the log of the server that is working and the log of what is trying to connect.

This is the log of the server that is connected and working:

2025-04-29T16:55:27.014025Z 0 [System] [MY-000000] [WSREP] P: (e65d51b5-a6da, 'tcp://0.0.0.0:4567') connection established to c00d70a0-94d5 tcp://IP_SERVER_ERROR:4567
2025-04-29T16:55:27.516005Z 0 [System] [MY-000000] [WSREP] P: declaring a3280a3c-accb at tcp://IP_SERVER3:4567 stable
2025-04-29T16:55:27.516066Z 0 [System] [MY-000000] [WSREP] P: declaring c00d70a0-94d5 at tcp://IP_SERVER_ERROR:4567 stable
2025-04-29T16:55:27.516082Z 0 [System] [MY-000000] [WSREP] P: declaring da95b9a7-a18c at tcp://IP_SERVER2:4567 stable
2025-04-29T16:55:27.525055Z 0 [System] [MY-000000] [WSREP] P: Node a3280a3c-accb state prim
2025-04-29T16:55:27.534195Z 0 [System] [MY-000000] [WSREP] P: view(view_id(PRIM,a3280a3c-accb,49556) memb {
a3280a3c-accb,0
c00d70a0-94d5,0
da95b9a7-a18c,0
e65d51b5-a6da,0
} joined {
} left {
} partitioned {
})
2025-04-29T16:55:27.534259Z 0 [System] [MY-000000] [WSREP] P: save pc into disk
2025-04-29T16:55:27.546862Z 0 [System] [MY-000000] [WSREP] P: New COMPONENT: primary = yes, bootstrap = no, my_idx = 3, memb_num = 4
2025-04-29T16:55:27.546965Z 0 [System] [MY-000000] [WSREP] P: STATE EXCHANGE: Waiting for state UUID.
2025-04-29T16:55:27.553564Z 0 [System] [MY-000000] [WSREP] P: STATE EXCHANGE: sent state msg: c05eab3b-251a-11f0-b1ba-1bc8d885fb2a
2025-04-29T16:55:27.561764Z 0 [System] [MY-000000] [WSREP] P: STATE EXCHANGE: got state msg: c05eab3b-251a-11f0-b1ba-1bc8d885fb2a from 0 (server_hostinger)
2025-04-29T16:55:27.561804Z 0 [System] [MY-000000] [WSREP] P: STATE EXCHANGE: got state msg: c05eab3b-251a-11f0-b1ba-1bc8d885fb2a from 2 (server_hostinger02)
2025-04-29T16:55:27.562258Z 0 [System] [MY-000000] [WSREP] P: STATE EXCHANGE: got state msg: c05eab3b-251a-11f0-b1ba-1bc8d885fb2a from 3 (server_onepanel)
2025-04-29T16:55:28.008619Z 0 [System] [MY-000000] [WSREP] P: STATE EXCHANGE: got state msg: c05eab3b-251a-11f0-b1ba-1bc8d885fb2a from 1 (server_vconnect)
2025-04-29T16:55:28.008712Z 0 [System] [MY-000000] [WSREP] P: Quorum results:
version = 6,
component = PRIMARY,
conf_id = 46325,
members = 3/4 (joined/total),
act_id = 156342,
last_appl. = 154744,
protocols = 5/11/7 (gcs/repl/appl),
vote policy= 0,
group UUID = 3d6e80f0-2216-11f0-a840-3754558a87f6
2025-04-29T16:55:28.008871Z 0 [System] [MY-000000] [WSREP] P: Flow-control interval: [32, 32]
2025-04-29T16:55:28.009010Z 1 [System] [MY-000000] [WSREP] P: ####### processing CC 156343, local, ordered
2025-04-29T16:55:28.009067Z 1 [System] [MY-000000] [WSREP] P: ####### My UUID: e65d51b5-247a-11f0-a6da-d3ecdad2675d
2025-04-29T16:55:28.009086Z 1 [System] [MY-000000] [WSREP] P: Skipping cert index reset
2025-04-29T16:55:28.009101Z 1 [System] [MY-000000] [WSREP] P: REPL Protocols: 11 (6)
2025-04-29T16:55:28.009116Z 1 [System] [MY-000000] [WSREP] P: ####### Adjusting cert position: 156342 -> 156343
2025-04-29T16:55:28.009222Z 0 [System] [MY-000000] [WSREP] P: Service thread queue flushed.
2025-04-29T16:55:28.030328Z 1 [System] [MY-000000] [WSREP] L: ================================================
View:
id: 3d6e80f0-2216-11f0-a840-3754558a87f6:156343
status: primary
protocol_version: 7
capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO
final: no
own_index: 3
members(4):
0: a3280a3c-2355-11f0-accb-1bff3611afa6, server_hostinger
1: c00d70a0-251a-11f0-94d5-86e55b75a5d2, server_vconnect
2: da95b9a7-2426-11f0-a18c-b6f6e08cdb72, server_hostinger02
3: e65d51b5-247a-11f0-a6da-d3ecdad2675d, server_onepanel

=================================================
2025-04-29T16:55:28.030403Z 1 [System] [MY-000000] [WSREP] wsrep_notify_cmd is not defined, skipping notification.
2025-04-29T16:55:28.039235Z 1 [System] [MY-000000] [WSREP] P: Lowest cert index boundary for CC from group: 154745
2025-04-29T16:55:28.039272Z 1 [System] [MY-000000] [WSREP] P: Min available from gcache for CC from group: 151042
2025-04-29T16:55:28.110109Z 0 [System] [MY-000000] [WSREP] P: Member 1.0 (server_vconnect) requested state transfer from '*any*'. Selected 0.0 (server_hostinger)(SYNCED) as donor.
2025-04-29T16:55:28.117870Z 0 [Warning] [MY-000000] [WSREP] P: 0.0 (server_hostinger): State transfer to 1.0 (server_vconnect) failed: No message of desired type
2025-04-29T16:55:28.130226Z 0 [System] [MY-000000] [WSREP] P: declaring a3280a3c-accb at tcp://IP_SERVER3:4567 stable
2025-04-29T16:55:28.130235Z 0 [System] [MY-000000] [WSREP] P: Member 0.0 (server_hostinger) synced with group.
2025-04-29T16:55:28.130292Z 0 [System] [MY-000000] [WSREP] P: declaring da95b9a7-a18c at tcp://IP_SERVER2:4567 stable
2025-04-29T16:55:28.130352Z 0 [System] [MY-000000] [WSREP] P: forgetting c00d70a0-94d5 (tcp://IP_SERVER_ERROR:4567)
2025-04-29T16:55:28.135000Z 0 [System] [MY-000000] [WSREP] P: Node a3280a3c-accb state prim
2025-04-29T16:55:28.142325Z 0 [System] [MY-000000] [WSREP] P: view(view_id(PRIM,a3280a3c-accb,49557) memb {
a3280a3c-accb,0
da95b9a7-a18c,0
e65d51b5-a6da,0
} joined {
} left {
} partitioned {
c00d70a0-94d5,0
})
2025-04-29T16:55:28.142383Z 0 [System] [MY-000000] [WSREP] P: save pc into disk
2025-04-29T16:55:28.152028Z 0 [System] [MY-000000] [WSREP] P: forgetting c00d70a0-94d5 (tcp://IP_SERVER_ERROR:4567)
2025-04-29T16:55:28.152060Z 0 [System] [MY-000000] [WSREP] P: New COMPONENT: primary = yes, bootstrap = no, my_idx = 2, memb_num = 3
2025-04-29T16:55:28.152096Z 0 [System] [MY-000000] [WSREP] P: STATE EXCHANGE: Waiting for state UUID.
2025-04-29T16:55:28.158526Z 0 [System] [MY-000000] [WSREP] P: STATE EXCHANGE: sent state msg: c0bb6247-251a-11f0-b79b-7653b729f07d
2025-04-29T16:55:28.162197Z 0 [System] [MY-000000] [WSREP] P: STATE EXCHANGE: got state msg: c0bb6247-251a-11f0-b79b-7653b729f07d from 0 (server_hostinger)
2025-04-29T16:55:28.162240Z 0 [System] [MY-000000] [WSREP] P: STATE EXCHANGE: got state msg: c0bb6247-251a-11f0-b79b-7653b729f07d from 1 (server_hostinger02)
2025-04-29T16:55:28.166802Z 0 [System] [MY-000000] [WSREP] P: STATE EXCHANGE: got state msg: c0bb6247-251a-11f0-b79b-7653b729f07d from 2 (server_onepanel)
2025-04-29T16:55:28.166863Z 0 [System] [MY-000000] [WSREP] P: Quorum results:
version = 6,
component = PRIMARY,
conf_id = 46326,
members = 3/3 (joined/total),
act_id = 156343,
last_appl. = 154744,
protocols = 5/11/7 (gcs/repl/appl),
vote policy= 0,
group UUID = 3d6e80f0-2216-11f0-a840-3754558a87f6
2025-04-29T16:55:28.166947Z 0 [System] [MY-000000] [WSREP] P: Flow-control interval: [28, 28]
2025-04-29T16:55:28.167059Z 1 [System] [MY-000000] [WSREP] P: ####### processing CC 156344, local, ordered
2025-04-29T16:55:28.167091Z 1 [System] [MY-000000] [WSREP] P: ####### My UUID: e65d51b5-247a-11f0-a6da-d3ecdad2675d
2025-04-29T16:55:28.167108Z 1 [System] [MY-000000] [WSREP] P: Skipping cert index reset
2025-04-29T16:55:28.167123Z 1 [System] [MY-000000] [WSREP] P: REPL Protocols: 11 (6)
2025-04-29T16:55:28.167138Z 1 [System] [MY-000000] [WSREP] P: ####### Adjusting cert position: 156343 -> 156344
2025-04-29T16:55:28.167247Z 0 [System] [MY-000000] [WSREP] P: Service thread queue flushed.
2025-04-29T16:55:28.187349Z 1 [System] [MY-000000] [WSREP] L: ================================================

View:
id: 3d6e80f0-2216-11f0-a840-3754558a87f6:156344
status: primary
protocol_version: 7
capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO
final: no
own_index: 2
members(3):
0: a3280a3c-2355-11f0-accb-1bff3611afa6, server_hostinger
1: da95b9a7-2426-11f0-a18c-b6f6e08cdb72, server_hostinger02
2: e65d51b5-247a-11f0-a6da-d3ecdad2675d, server_onepanel
=================================================
2025-04-29T16:55:28.187416Z 1 [System] [MY-000000] [WSREP] wsrep_notify_cmd is not defined, skipping notification.
2025-04-29T16:55:28.196728Z 1 [System] [MY-000000] [WSREP] P: Lowest cert index boundary for CC from group: 154745
2025-04-29T16:55:28.196766Z 1 [System] [MY-000000] [WSREP] P: Min available from gcache for CC from group: 151042
2025-04-29T16:55:30.252855Z 0 [System] [MY-000000] [WSREP] P: (e65d51b5-a6da, 'tcp://0.0.0.0:4567') turning message relay requesting off
2025-04-29T16:55:31.132981Z 0 [System] [MY-000000] [WSREP] P: (e65d51b5-a6da, 'tcp://0.0.0.0:4567') connection established to c2821fd5-a130 tcp://IP_SERVER_ERROR:4567
2025-04-29T16:55:31.133045Z 0 [System] [MY-000000] [WSREP] P: remote endpoint tcp://IP_SERVER_ERROR:4567 changed identity c00d70a0-251a-11f0-94d5-86e55b75a5d2 -> c2821fd5-251a-11f0-a130-52c5c3ab8c88
2025-04-29T16:55:32.641455Z 0 [System] [MY-000000] [WSREP] P: declaring a3280a3c-accb at tcp://IP_SERVER3:4567 stable
2025-04-29T16:55:32.641515Z 0 [System] [MY-000000] [WSREP] P: declaring c2821fd5-a130 at tcp://IP_SERVER_ERROR:4567 stable
2025-04-29T16:55:32.641530Z 0 [System] [MY-000000] [WSREP] P: declaring da95b9a7-a18c at tcp://IP_SERVER2:4567 stable
2025-04-29T16:55:32.647035Z 0 [System] [MY-000000] [WSREP] P: Node a3280a3c-accb state prim
2025-04-29T16:55:32.654904Z 0 [System] [MY-000000] [WSREP] P: view(view_id(PRIM,a3280a3c-accb,49558) memb {
a3280a3c-accb,0
c2821fd5-a130,0
da95b9a7-a18c,0
e65d51b5-a6da,0
} joined {
} left {
} partitioned {
})
2025-04-29T16:55:32.654966Z 0 [System] [MY-000000] [WSREP] P: save pc into disk
2025-04-29T16:55:32.668017Z 0 [System] [MY-000000] [WSREP] P: New COMPONENT: primary = yes, bootstrap = no, my_idx = 3, memb_num = 4
2025-04-29T16:55:32.668093Z 0 [System] [MY-000000] [WSREP] P: STATE EXCHANGE: Waiting for state UUID.
2025-04-29T16:55:32.674327Z 0 [System] [MY-000000] [WSREP] P: STATE EXCHANGE: sent state msg: c36c6854-251a-11f0-a6ee-8b65c1bfe90a
2025-04-29T16:55:32.681116Z 0 [System] [MY-000000] [WSREP] P: STATE EXCHANGE: got state msg: c36c6854-251a-11f0-a6ee-8b65c1bfe90a from 0 (server_hostinger)
2025-04-29T16:55:32.681219Z 0 [System] [MY-000000] [WSREP] P: STATE EXCHANGE: got state msg: c36c6854-251a-11f0-a6ee-8b65c1bfe90a from 2 (server_hostinger02)
2025-04-29T16:55:32.681264Z 0 [System] [MY-000000] [WSREP] P: STATE EXCHANGE: got state msg: c36c6854-251a-11f0-a6ee-8b65c1bfe90a from 3 (server_onepanel)
2025-04-29T16:55:33.128428Z 0 [System] [MY-000000] [WSREP] P: STATE EXCHANGE: got state msg: c36c6854-251a-11f0-a6ee-8b65c1bfe90a from 1 (server_vconnect)
2025-04-29T16:55:33.128493Z 0 [System] [MY-000000] [WSREP] P: Quorum results:

version = 6,
component = PRIMARY,
conf_id = 46327,
members = 3/4 (joined/total),
act_id = 156344,
last_appl. = 154744,
protocols = 5/11/7 (gcs/repl/appl),
vote policy= 0,
group UUID = 3d6e80f0-2216-11f0-a840-3754558a87f6
2025-04-29T16:55:33.128554Z 0 [System] [MY-000000] [WSREP] P: Flow-control interval: [32, 32]
2025-04-29T16:55:33.128655Z 1 [System] [MY-000000] [WSREP] P: ####### processing CC 156345, local, ordered
2025-04-29T16:55:33.128695Z 1 [System] [MY-000000] [WSREP] P: ####### My UUID: e65d51b5-247a-11f0-a6da-d3ecdad2675d
2025-04-29T16:55:33.128714Z 1 [System] [MY-000000] [WSREP] P: Skipping cert index reset
2025-04-29T16:55:33.128729Z 1 [System] [MY-000000] [WSREP] P: REPL Protocols: 11 (6)
2025-04-29T16:55:33.128744Z 1 [System] [MY-000000] [WSREP] P: ####### Adjusting cert position: 156344 -> 156345
2025-04-29T16:55:33.128838Z 0 [System] [MY-000000] [WSREP] P: Service thread queue flushed.
2025-04-29T16:55:33.148448Z 1 [System] [MY-000000] [WSREP] L: ================================================
View:
id: 3d6e80f0-2216-11f0-a840-3754558a87f6:156345
status: primary
protocol_version: 7
capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO
final: no
own_index: 3
members(4):
0: a3280a3c-2355-11f0-accb-1bff3611afa6, server_hostinger
1: c2821fd5-251a-11f0-a130-52c5c3ab8c88, server_vconnect
2: da95b9a7-2426-11f0-a18c-b6f6e08cdb72, server_hostinger02
3: e65d51b5-247a-11f0-a6da-d3ecdad2675d, server_onepanel

=================================================
2025-04-29T16:55:33.148521Z 1 [System] [MY-000000] [WSREP] wsrep_notify_cmd is not defined, skipping notification.
2025-04-29T16:55:33.158851Z 1 [System] [MY-000000] [WSREP] P: Lowest cert index boundary for CC from group: 154745
2025-04-29T16:55:33.158916Z 1 [System] [MY-000000] [WSREP] P: Min available from gcache for CC from group: 151042
2025-04-29T16:55:33.241511Z 0 [System] [MY-000000] [WSREP] P: Member 1.0 (server_vconnect) requested state transfer from '*any*'. Selected 0.0 (server_hostinger)(SYNCED) as donor.
2025-04-29T16:55:33.251473Z 0 [Warning] [MY-000000] [WSREP] P: 0.0 (server_hostinger): State transfer to 1.0 (server_vconnect) failed: No message of desired type
2025-04-29T16:55:33.261609Z 0 [System] [MY-000000] [WSREP] P: Member 0.0 (server_hostinger) synced with group.
2025-04-29T16:55:33.261608Z 0 [System] [MY-000000] [WSREP] P: declaring a3280a3c-accb at tcp://IP_SERVER3:4567 stable
2025-04-29T16:55:33.261730Z 0 [System] [MY-000000] [WSREP] P: declaring da95b9a7-a18c at tcp://IP_SERVER2:4567 stable
2025-04-29T16:55:33.261835Z 0 [System] [MY-000000] [WSREP] P: forgetting c2821fd5-a130 (tcp://IP_SERVER_ERROR:4567)
2025-04-29T16:55:33.268074Z 0 [System] [MY-000000] [WSREP] P: Node a3280a3c-accb state prim
2025-04-29T16:55:33.273041Z 0 [System] [MY-000000] [WSREP] P: view(view_id(PRIM,a3280a3c-accb,49559) memb {
a3280a3c-accb,0
da95b9a7-a18c,0
e65d51b5-a6da,0
} joined {
} left {
} partitioned {
c2821fd5-a130,0
})
2025-04-29T16:55:33.273109Z 0 [System] [MY-000000] [WSREP] P: save pc into disk
2025-04-29T16:55:33.283465Z 0 [System] [MY-000000] [WSREP] P: forgetting c2821fd5-a130 (tcp://IP_SERVER_ERROR:4567)
2025-04-29T16:55:33.283509Z 0 [System] [MY-000000] [WSREP] P: New COMPONENT: primary = yes, bootstrap = no, my_idx = 2, memb_num = 3
2025-04-29T16:55:33.283563Z 0 [System] [MY-000000] [WSREP] P: STATE EXCHANGE: Waiting for state UUID.
2025-04-29T16:55:33.289648Z 0 [System] [MY-000000] [WSREP] P: STATE EXCHANGE: sent state msg: c3ca9d09-251a-11f0-a1e1-23610ade598a
2025-04-29T16:55:33.292684Z 0 [System] [MY-000000] [WSREP] P: STATE EXCHANGE: got state msg: c3ca9d09-251a-11f0-a1e1-23610ade598a from 0 (server_hostinger)
2025-04-29T16:55:33.294168Z 0 [System] [MY-000000] [WSREP] P: STATE EXCHANGE: got state msg: c3ca9d09-251a-11f0-a1e1-23610ade598a from 1 (server_hostinger02)
2025-04-29T16:55:33.294247Z 0 [System] [MY-000000] [WSREP] P: STATE EXCHANGE: got state msg: c3ca9d09-251a-11f0-a1e1-23610ade598a from 2 (server_onepanel)
2025-04-29T16:55:33.294289Z 0 [System] [MY-000000] [WSREP] P: Quorum results:
version = 6,
component = PRIMARY,
conf_id = 46328,
members = 3/3 (joined/total),
act_id = 156345,
last_appl. = 154744,
protocols = 5/11/7 (gcs/repl/appl),
vote policy= 0,
group UUID = 3d6e80f0-2216-11f0-a840-3754558a87f6

This is the server node that is trying to connect:

2025-04-29T16:55:24.768442Z 0 [System] [MY-015015] [Server] MySQL Server - start.
2025-04-29T16:55:24.939088Z 0 [Warning] [MY-011070] [Server] 'binlog_format' is deprecated and will be removed in a future release.
2025-04-29T16:55:24.939982Z 0 [Note] [MY-013932] [Server] BuildID[sha1]=fcbc0dba1e619a96ac1da4d4cd7c29e3e902e50f
2025-04-29T16:55:24.939986Z 0 [Note] [MY-010949] [Server] Basedir set to /usr/.
2025-04-29T16:55:24.939993Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.4.4) starting as process 1004073
2025-04-29T16:55:24.943711Z 0 [Note] [MY-012366] [InnoDB] Using Linux native AIO
2025-04-29T16:55:24.943741Z 0 [Note] [MY-015140] [InnoDB] Using innodb_flush_method=O_DIRECT
2025-04-29T16:55:24.943874Z 0 [Note] [MY-010747] [Server] Plugin 'FEDERATED' is disabled.
2025-04-29T16:55:24.943911Z 0 [Note] [MY-010747] [Server] Plugin 'ndbcluster' is disabled.
2025-04-29T16:55:24.943918Z 0 [Note] [MY-010747] [Server] Plugin 'ndbinfo' is disabled.
2025-04-29T16:55:24.943922Z 0 [Note] [MY-010747] [Server] Plugin 'ndb_transid_mysql_connection_map' is disabled.
2025-04-29T16:55:24.943966Z 0 [Note] [MY-010747] [Server] Plugin 'wsrep_provider' is disabled.
2025-04-29T16:55:24.943969Z 0 [Note] [MY-010747] [Server] Plugin 'mysql_native_password' is disabled.
2025-04-29T16:55:24.944738Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2025-04-29T16:55:24.944761Z 1 [Note] [MY-013546] [InnoDB] Atomic write enabled
2025-04-29T16:55:24.944778Z 1 [Note] [MY-012932] [InnoDB] PUNCH HOLE support available
2025-04-29T16:55:24.944784Z 1 [Note] [MY-012944] [InnoDB] Uses event mutexes
2025-04-29T16:55:24.944788Z 1 [Note] [MY-012945] [InnoDB] GCC builtin __atomic_thread_fence() is used for memory barrier
2025-04-29T16:55:24.944794Z 1 [Note] [MY-012948] [InnoDB] Compressed tables use zlib 1.2.13
2025-04-29T16:55:24.946049Z 1 [Note] [MY-012951] [InnoDB] Using hardware accelerated crc32 and polynomial multiplication.
2025-04-29T16:55:24.946326Z 1 [Note] [MY-012203] [InnoDB] Directories to scan './'
2025-04-29T16:55:24.946354Z 1 [Note] [MY-012204] [InnoDB] Scanning './'
2025-04-29T16:55:24.947141Z 1 [Note] [MY-012208] [InnoDB] Completed space ID check of 4 files.
2025-04-29T16:55:24.947598Z 1 [Note] [MY-012955] [InnoDB] Initializing buffer pool, total size = 128.000000M, instances = 1, chunk size =128.000000M
2025-04-29T16:55:24.947609Z 1 [Note] [MY-011872] [InnoDB] Setting NUMA memory policy to MPOL_INTERLEAVE
2025-04-29T16:55:24.951493Z 1 [Note] [MY-011874] [InnoDB] Setting NUMA memory policy to MPOL_DEFAULT
2025-04-29T16:55:24.951508Z 1 [Note] [MY-012957] [InnoDB] Completed initialization of buffer pool
2025-04-29T16:55:24.953339Z 0 [Note] [MY-011952] [InnoDB] If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2025-04-29T16:55:24.953686Z 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_0.dblwr' for doublewrite
2025-04-29T16:55:24.958443Z 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_1.dblwr' for doublewrite
2025-04-29T16:55:24.969343Z 1 [Note] [MY-013566] [InnoDB] Double write buffer files: 2
2025-04-29T16:55:24.969363Z 1 [Note] [MY-013565] [InnoDB] Double write buffer pages per instance: 128
2025-04-29T16:55:24.969377Z 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_0.dblwr' for doublewrite
2025-04-29T16:55:24.969388Z 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_1.dblwr' for doublewrite
2025-04-29T16:55:25.024708Z 1 [Note] [MY-013883] [InnoDB] The latest found checkpoint is at lsn = 167175243 in redo log file ./#innodb_redo/#ib_redo51.
2025-04-29T16:55:25.024748Z 1 [Note] [MY-013086] [InnoDB] Starting to parse redo log at lsn = 167175190, whereas checkpoint_lsn = 167175243 and start_lsn = 167175168
2025-04-29T16:55:25.025906Z 1 [Note] [MY-013083] [InnoDB] Log background threads are being started...
2025-04-29T16:55:25.026320Z 1 [Note] [MY-012532] [InnoDB] Applying a batch of 0 redo log records ...
2025-04-29T16:55:25.026332Z 1 [Note] [MY-012535] [InnoDB] Apply batch completed!
2025-04-29T16:55:25.026628Z 1 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_001'.
2025-04-29T16:55:25.026862Z 1 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_002'.
2025-04-29T16:55:25.027271Z 1 [Note] [MY-012910] [InnoDB] Opened 2 existing undo tablespaces.
2025-04-29T16:55:25.027304Z 1 [Note] [MY-011980] [InnoDB] GTID recovery trx_no: 1647884
2025-04-29T16:55:25.034165Z 1 [Note] [MY-013776] [InnoDB] Parallel initialization of rseg complete
2025-04-29T16:55:25.034202Z 1 [Note] [MY-013777] [InnoDB] Time taken to initialize rseg using 4 thread: 6 ms.
2025-04-29T16:55:25.034256Z 1 [Note] [MY-012923] [InnoDB] Creating shared tablespace for temporary tables
2025-04-29T16:55:25.034989Z 1 [Note] [MY-012265] [InnoDB] Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2025-04-29T16:55:25.042802Z 1 [Note] [MY-012266] [InnoDB] File './ibtmp1' size is now 12 MB.
2025-04-29T16:55:25.042866Z 1 [Note] [MY-013627] [InnoDB] Scanning temp tablespace dir:'./#innodb_temp/'
2025-04-29T16:55:25.058595Z 1 [Note] [MY-013018] [InnoDB] Created 128 and tracked 128 new rollback segment(s) in the temporary tablespace. 128 are now active.
2025-04-29T16:55:25.058823Z 1 [Note] [MY-012976] [InnoDB] 8.4.4 started; log sequence number 167175253
2025-04-29T16:55:25.058981Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2025-04-29T16:55:25.062249Z 1 [Note] [MY-011089] [Server] Data dictionary restarting version '80300'.
2025-04-29T16:55:25.110292Z 1 [Note] [MY-012357] [InnoDB] Reading DD tablespace files
2025-04-29T16:55:25.110631Z 1 [Note] [MY-012356] [InnoDB] Scanned 6 tablespaces. Validated 6.
2025-04-29T16:55:25.119356Z 1 [Note] [MY-010006] [Server] Using data dictionary with version '80300'.
2025-04-29T16:55:25.122399Z 0 [Note] [MY-011332] [Server] Plugin mysqlx reported: 'IPv6 is available'
2025-04-29T16:55:25.122477Z 0 [Note] [MY-011323] [Server] Plugin mysqlx reported: 'X Plugin ready for connections. bind-address: '::' port: 33060'
2025-04-29T16:55:25.122486Z 0 [Note] [MY-011323] [Server] Plugin mysqlx reported: 'X Plugin ready for connections. socket: '/var/run/mysqld/mysqlx.sock''
2025-04-29T16:55:25.137654Z 0 [Note] [MY-013911] [Server] Crash recovery finished in binlog engine. No attempts to commit, rollback or prepare any transactions.
2025-04-29T16:55:25.137680Z 0 [Note] [MY-013911] [Server] Crash recovery finished in InnoDB engine. No attempts to commit, rollback or prepare any transactions.
2025-04-29T16:55:25.139369Z 0 [Note] [MY-012487] [InnoDB] DDL log recovery : begin
2025-04-29T16:55:25.139499Z 0 [Note] [MY-012488] [InnoDB] DDL log recovery : end
2025-04-29T16:55:25.142757Z 0 [Note] [MY-012922] [InnoDB] Waiting for purge to start
2025-04-29T16:55:25.201072Z 0 [System] [MY-000000] [WSREP] Recovered position: 00000000-0000-0000-0000-000000000000:-1
2025-04-29T16:55:25.201086Z 0 [System] [MY-000000] [WSREP] Recovered full position: 00000000-0000-0000-0000-000000000000:-1/0/0/00000000-0000-0000-0000-000000000000
2025-04-29T16:55:25.202180Z 0 [Note] [MY-012330] [InnoDB] FTS optimize thread exiting.
2025-04-29T16:55:26.201704Z 0 [Note] [MY-010120] [Server] Binlog end
2025-04-29T16:55:26.201966Z 0 [Note] [MY-015019] [Server] MySQL Server: Plugins Shutdown - start.
2025-04-29T16:55:26.201976Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'mysqlx'
2025-04-29T16:55:26.202223Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'mysqlx_cache_cleaner'
2025-04-29T16:55:26.202231Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'ngram'
2025-04-29T16:55:26.202233Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'BLACKHOLE'
2025-04-29T16:55:26.202238Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'ARCHIVE'
2025-04-29T16:55:26.202241Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'TempTable'
2025-04-29T16:55:26.202243Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'PERFORMANCE_SCHEMA'
2025-04-29T16:55:26.202270Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'MRG_MYISAM'
2025-04-29T16:55:26.202275Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'MyISAM'
2025-04-29T16:55:26.202282Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_SESSION_TEMP_TABLESPACES'
2025-04-29T16:55:26.202290Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CACHED_INDEXES'
2025-04-29T16:55:26.202293Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_VIRTUAL'
2025-04-29T16:55:26.202296Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_COLUMNS'
2025-04-29T16:55:26.202298Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TABLESPACES'
2025-04-29T16:55:26.202300Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_INDEXES'
2025-04-29T16:55:26.202303Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TABLESTATS'
2025-04-29T16:55:26.202306Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TABLES'
2025-04-29T16:55:26.202308Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2025-04-29T16:55:26.202311Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2025-04-29T16:55:26.202313Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_CONFIG'
2025-04-29T16:55:26.202315Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2025-04-29T16:55:26.202318Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_DELETED'
2025-04-29T16:55:26.202320Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2025-04-29T16:55:26.202323Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_METRICS'
2025-04-29T16:55:26.202325Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2025-04-29T16:55:26.202328Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2025-04-29T16:55:26.202330Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2025-04-29T16:55:26.202332Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_BUFFER_PAGE'
2025-04-29T16:55:26.202335Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2025-04-29T16:55:26.202337Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2025-04-29T16:55:26.202340Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMPMEM_RESET'
2025-04-29T16:55:26.202342Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMPMEM'
2025-04-29T16:55:26.202344Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP_RESET'
2025-04-29T16:55:26.202347Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP'
2025-04-29T16:55:26.202349Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TRX'
2025-04-29T16:55:26.202351Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'InnoDB'
2025-04-29T16:55:26.202366Z 0 [Note] [MY-013072] [InnoDB] Starting shutdown...
2025-04-29T16:55:26.207848Z 0 [Note] [MY-013084] [InnoDB] Log background threads are being closed...
2025-04-29T16:55:26.720507Z 0 [Note] [MY-013854] [InnoDB] Bytes written to disk by DBLWR (ON): 704512
2025-04-29T16:55:26.720627Z 0 [Note] [MY-012980] [InnoDB] Shutdown completed; log sequence number 167220509
2025-04-29T16:55:26.721379Z 0 [Note] [MY-012255] [InnoDB] Removed temporary tablespace data file: "ibtmp1"
2025-04-29T16:55:26.721402Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'MEMORY'
2025-04-29T16:55:26.721408Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'CSV'
2025-04-29T16:55:26.721412Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'wsrep'
2025-04-29T16:55:26.721415Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'daemon_keyring_proxy_plugin'
2025-04-29T16:55:26.721426Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'sha2_cache_cleaner'
2025-04-29T16:55:26.721430Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'caching_sha2_password'
2025-04-29T16:55:26.721435Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'sha256_password'
2025-04-29T16:55:26.721525Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'binlog'
2025-04-29T16:55:26.721532Z 0 [Note] [MY-015020] [Server] MySQL Server: Plugins Shutdown - end.
2025-04-29T16:55:26.721783Z 0 [Note] [MY-015021] [Server] MySQL Server: Components Shutdown - start.
2025-04-29T16:55:26.722323Z 0 [Note] [MY-015022] [Server] MySQL Server: Components Shutdown - end (with return value = 0).
2025-04-29T16:55:26.722393Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.4.4) Galera Cluster for MySQL.
2025-04-29T16:55:26.722397Z 0 [System] [MY-015016] [Server] MySQL Server - end.
2025-04-29T16:55:26.817144Z 0 [System] [MY-015015] [Server] MySQL Server - start.
2025-04-29T16:55:26.987205Z 0 [Warning] [MY-011070] [Server] 'binlog_format' is deprecated and will be removed in a future release.
2025-04-29T16:55:26.988161Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.4.4) starting as process 1004122
2025-04-29T16:55:26.989479Z 0 [System] [MY-000000] [WSREP] L: Loading provider /usr/lib/galera/libgalera_smm.so initial position: 00000000-0000-0000-0000-000000000000:-1
2025-04-29T16:55:26.989487Z 0 [System] [MY-000000] [WSREP] P: wsrep_load(): loading provider library '/usr/lib/galera/libgalera_smm.so'
2025-04-29T16:55:26.989830Z 0 [System] [MY-000000] [WSREP] P: wsrep_load(): Galera 4.22(rXXXX) by Codership Oy <in...@codership.com> loaded successfully.
2025-04-29T16:55:26.989841Z 0 [System] [MY-000000] [WSREP] L: Initializing allowlist service v1
2025-04-29T16:55:26.989845Z 0 [System] [MY-000000] [WSREP] L: Initializing event service v1
2025-04-29T16:55:26.989848Z 0 [System] [MY-000000] [WSREP] L: Resolved symbol 'wsrep_node_isolation_mode_set_v1'
2025-04-29T16:55:26.989865Z 0 [System] [MY-000000] [WSREP] P: CRC-32C: using 64-bit x86 acceleration.
2025-04-29T16:55:26.989984Z 0 [System] [MY-000000] [WSREP] P: Found saved state: 00000000-0000-0000-0000-000000000000:-1, safe_to_bootstrap: 1
2025-04-29T16:55:26.990020Z 0 [System] [MY-000000] [WSREP] P: GCache DEBUG: opened preamble:
Version: 2
UUID: 3d6e80f0-2216-11f0-a840-3754558a87f6
Seqno: -1 - -1
Offset: -1
Synced: 0
2025-04-29T16:55:26.990026Z 0 [System] [MY-000000] [WSREP] P: Recovering GCache ring buffer: version: 2, UUID: 3d6e80f0-2216-11f0-a840-3754558a87f6, offset: -1
2025-04-29T16:55:26.990070Z 0 [System] [MY-000000] [WSREP] P: GCache::RingBuffer initial scan... 0.0% (0/134217752 bytes) complete.
2025-04-29T16:55:26.990096Z 0 [System] [MY-000000] [WSREP] P: GCache::RingBuffer initial scan... 100.0% (134217752/134217752 bytes) complete.
2025-04-29T16:55:26.990101Z 0 [System] [MY-000000] [WSREP] P: Recovering GCache ring buffer: Recovery failed, need to do full reset.
2025-04-29T16:55:26.991976Z 0 [System] [MY-000000] [WSREP] P: Passing config to GCS: base_dir = /var/lib/mysql/; base_host = IP_SERVER_ERROR; base_port = 4567; cert.log_conflicts = no; cert.optimistic_pa = yes; debug = no; evs.auto_evict = 0; evs.del>
2025-04-29T16:55:26.996561Z 0 [System] [MY-000000] [WSREP] Start replication
2025-04-29T16:55:26.996604Z 0 [System] [MY-000000] [WSREP] L: Connecting with bootstrap option: 0
2025-04-29T16:55:26.996620Z 0 [System] [MY-000000] [WSREP] P: Setting GCS initial position to 00000000-0000-0000-0000-000000000000:-1
2025-04-29T16:55:26.996651Z 0 [System] [MY-000000] [WSREP] P: protonet asio version 0
2025-04-29T16:55:26.996680Z 0 [System] [MY-000000] [WSREP] P: Using CRC-32C for message checksums.
2025-04-29T16:55:26.996685Z 0 [System] [MY-000000] [WSREP] P: backend: asio
2025-04-29T16:55:26.996736Z 0 [System] [MY-000000] [WSREP] P: gcomm thread scheduling priority set to other:0
2025-04-29T16:55:26.996875Z 0 [System] [MY-000000] [WSREP] P: access file(/var/lib/mysql//gvwstate.dat) failed(No such file or directory)
2025-04-29T16:55:26.996893Z 0 [System] [MY-000000] [WSREP] P: restore pc from disk failed
2025-04-29T16:55:26.996976Z 0 [System] [MY-000000] [WSREP] P: GMCast version 0
2025-04-29T16:55:26.997085Z 0 [System] [MY-000000] [WSREP] P: (c00d70a0-94d5, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567
2025-04-29T16:55:26.997092Z 0 [System] [MY-000000] [WSREP] P: (c00d70a0-94d5, 'tcp://0.0.0.0:4567') multicast: , ttl: 1
2025-04-29T16:55:26.997247Z 0 [System] [MY-000000] [WSREP] P: EVS version 1
2025-04-29T16:55:26.997284Z 0 [System] [MY-000000] [WSREP] P: gcomm: connecting to group 'MYCLUSTER_CLUSTER', peer 'IP_SERVER1:,IP_SERVER_ERROR:,IP_SERVER2:,IP_SERVER3:'
2025-04-29T16:55:26.998681Z 0 [System] [MY-000000] [WSREP] P: (c00d70a0-94d5, 'tcp://0.0.0.0:4567') Found matching local endpoint for a connection, blacklisting address tcp://IP_SERVER_ERROR:4567
2025-04-29T16:55:27.015859Z 0 [System] [MY-000000] [WSREP] P: (c00d70a0-94d5, 'tcp://0.0.0.0:4567') connection established to a3280a3c-accb tcp://IP_SERVER3:4567
2025-04-29T16:55:27.017026Z 0 [System] [MY-000000] [WSREP] P: (c00d70a0-94d5, 'tcp://0.0.0.0:4567') connection established to da95b9a7-a18c tcp://IP_SERVER2:4567
2025-04-29T16:55:27.018466Z 0 [System] [MY-000000] [WSREP] P: (c00d70a0-94d5, 'tcp://0.0.0.0:4567') connection established to e65d51b5-a6da tcp://IP_SERVER1:4567
2025-04-29T16:55:27.517389Z 0 [System] [MY-000000] [WSREP] P: EVS version upgrade 0 -> 1
2025-04-29T16:55:27.517404Z 0 [System] [MY-000000] [WSREP] P: declaring a3280a3c-accb at tcp://IP_SERVER3:4567 stable
2025-04-29T16:55:27.517411Z 0 [System] [MY-000000] [WSREP] P: declaring da95b9a7-a18c at tcp://IP_SERVER2:4567 stable
2025-04-29T16:55:27.517414Z 0 [System] [MY-000000] [WSREP] P: declaring e65d51b5-a6da at tcp://IP_SERVER1:4567 stable
2025-04-29T16:55:27.517423Z 0 [System] [MY-000000] [WSREP] P: PC protocol upgrade 0 -> 1
2025-04-29T16:55:27.523604Z 0 [System] [MY-000000] [WSREP] P: Node a3280a3c-accb state prim
2025-04-29T16:55:27.535494Z 0 [System] [MY-000000] [WSREP] P: view(view_id(PRIM,a3280a3c-accb,49556) memb {
a3280a3c-accb,0
c00d70a0-94d5,0
da95b9a7-a18c,0
e65d51b5-a6da,0
} joined {
} left {
} partitioned {
})
2025-04-29T16:55:27.535507Z 0 [System] [MY-000000] [WSREP] P: save pc into disk
2025-04-29T16:55:27.997701Z 0 [System] [MY-000000] [WSREP] P: gcomm: connected
2025-04-29T16:55:27.997770Z 0 [System] [MY-000000] [WSREP] P: Changing maximum packet size to 64500, resulting msg size: 32636
2025-04-29T16:55:27.997824Z 0 [System] [MY-000000] [WSREP] P: Shifting CLOSED -> OPEN (TO: 0)
2025-04-29T16:55:27.997830Z 0 [System] [MY-000000] [WSREP] P: Opened channel 'MYCLUSTER_CLUSTER'
2025-04-29T16:55:27.997917Z 0 [System] [MY-000000] [WSREP] L: Initializing config service v1
2025-04-29T16:55:27.997923Z 0 [System] [MY-000000] [WSREP] P: New COMPONENT: primary = yes, bootstrap = no, my_idx = 1, memb_num = 4
2025-04-29T16:55:27.997952Z 0 [System] [MY-000000] [WSREP] P: STATE EXCHANGE: Waiting for state UUID.
2025-04-29T16:55:27.997970Z 0 [System] [MY-000000] [WSREP] P: STATE EXCHANGE: sent state msg: c05eab3b-251a-11f0-b1ba-1bc8d885fb2a
2025-04-29T16:55:27.997979Z 0 [System] [MY-000000] [WSREP] P: STATE EXCHANGE: got state msg: c05eab3b-251a-11f0-b1ba-1bc8d885fb2a from 0 (server_hostinger)
2025-04-29T16:55:27.997988Z 0 [System] [MY-000000] [WSREP] P: STATE EXCHANGE: got state msg: c05eab3b-251a-11f0-b1ba-1bc8d885fb2a from 2 (server_hostinger02)
2025-04-29T16:55:27.997997Z 0 [System] [MY-000000] [WSREP] P: STATE EXCHANGE: got state msg: c05eab3b-251a-11f0-b1ba-1bc8d885fb2a from 3 (server_onepanel)
2025-04-29T16:55:27.998105Z 1 [System] [MY-000000] [WSREP] Starting rollbacker thread 1
2025-04-29T16:55:27.998127Z 2 [System] [MY-000000] [WSREP] Starting applier thread 2
2025-04-29T16:55:27.998144Z 0 [System] [MY-000000] [WSREP] L: Deinitializing config service v1
2025-04-29T16:55:28.006607Z 0 [System] [MY-000000] [WSREP] P: STATE EXCHANGE: got state msg: c05eab3b-251a-11f0-b1ba-1bc8d885fb2a from 1 (server_vconnect)
2025-04-29T16:55:28.006624Z 0 [System] [MY-000000] [WSREP] P: Quorum results:
version = 6,
component = PRIMARY,
conf_id = 46325,
members = 3/4 (joined/total),
act_id = 156342,
last_appl. = 154744,
protocols = 5/11/7 (gcs/repl/appl),
vote policy= 0,
group UUID = 3d6e80f0-2216-11f0-a840-3754558a87f6
2025-04-29T16:55:28.006648Z 0 [System] [MY-000000] [WSREP] P: Flow-control interval: [32, 32]
2025-04-29T16:55:28.006652Z 0 [System] [MY-000000] [WSREP] P: Shifting OPEN -> PRIMARY (TO: 156343)
2025-04-29T16:55:28.006721Z 2 [System] [MY-000000] [WSREP] P: ####### processing CC 156343, local, ordered
2025-04-29T16:55:28.006736Z 2 [System] [MY-000000] [WSREP] P: Process first view: 3d6e80f0-2216-11f0-a840-3754558a87f6 my uuid: c00d70a0-251a-11f0-94d5-86e55b75a5d2
2025-04-29T16:55:28.006746Z 2 [System] [MY-000000] [WSREP] L: Server server_vconnect connected to cluster at position 3d6e80f0-2216-11f0-a840-3754558a87f6:156343 with ID c00d70a0-251a-11f0-94d5-86e55b75a5d2
2025-04-29T16:55:28.006750Z 2 [System] [MY-000000] [WSREP] Server status change disconnected -> connected
2025-04-29T16:55:28.006755Z 2 [System] [MY-000000] [WSREP] wsrep_notify_cmd is not defined, skipping notification.
2025-04-29T16:55:28.006768Z 2 [System] [MY-000000] [WSREP] P: ####### My UUID: c00d70a0-251a-11f0-94d5-86e55b75a5d2
2025-04-29T16:55:28.006773Z 2 [System] [MY-000000] [WSREP] P: Cert index reset to 00000000-0000-0000-0000-000000000000:-1 (proto: 11), state transfer needed: yes
2025-04-29T16:55:28.006832Z 0 [System] [MY-000000] [WSREP] P: Service thread queue flushed.
2025-04-29T16:55:28.006857Z 2 [System] [MY-000000] [WSREP] P: ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:-1, protocol version: -1
2025-04-29T16:55:28.006863Z 2 [System] [MY-000000] [WSREP] P: State transfer required:
Group state: 3d6e80f0-2216-11f0-a840-3754558a87f6:156343
Local state: 00000000-0000-0000-0000-000000000000:-1
2025-04-29T16:55:28.006866Z 2 [System] [MY-000000] [WSREP] Server status change connected -> joiner
2025-04-29T16:55:28.006871Z 2 [System] [MY-000000] [WSREP] wsrep_notify_cmd is not defined, skipping notification.
2025-04-29T16:55:28.006957Z 0 [System] [MY-000000] [WSREP] Running: 'wsrep_sst_rsync --role 'joiner' --address 'IP_SERVER_ERROR' --datadir '/var/lib/mysql/' --parent '1004122' --mysqld-version '8.4.4' --protocol '7' --plugin-dir '/usr/lib/mysql/plu>
2025-04-29T16:55:28.099894Z 2 [System] [MY-000000] [WSREP] P: ####### IST uuid:00000000-0000-0000-0000-000000000000 f: 0, l: 156343, STRv: 3
2025-04-29T16:55:28.099960Z 2 [System] [MY-000000] [WSREP] P: IST receiver addr using tcp://IP_SERVER_ERROR:4568
2025-04-29T16:55:28.100034Z 2 [Warning] [MY-000000] [WSREP] P: Failed to prepare for incremental state transfer: Failed to open IST listener at tcp://IP_SERVER_ERROR:4568', asio error 'Failed to listen: bind: Cannot assign requested address: System e>
at ./galerautils/src/gu_asio_stream_react.cpp:listen():894'
at ./galera/src/ist.cpp:prepare():319. IST will be unavailable.
2025-04-29T16:55:28.109221Z 0 [System] [MY-000000] [WSREP] P: Member 1.0 (server_vconnect) requested state transfer from '*any*'. Selected 0.0 (server_hostinger)(SYNCED) as donor.
2025-04-29T16:55:28.109243Z 0 [System] [MY-000000] [WSREP] P: Shifting PRIMARY -> JOINER (TO: 156343)
2025-04-29T16:55:28.109259Z 2 [System] [MY-000000] [WSREP] P: Requesting state transfer: success, donor: 0
2025-04-29T16:55:28.109270Z 2 [System] [MY-000000] [WSREP] P: Resetting GCache seqno map due to different histories.
2025-04-29T16:55:28.109275Z 2 [System] [MY-000000] [WSREP] P: GCache history reset: 3d6e80f0-2216-11f0-a840-3754558a87f6:0 -> 3d6e80f0-2216-11f0-a840-3754558a87f6:156343
2025-04-29T16:55:28.119615Z 0 [Warning] [MY-000000] [WSREP] P: 0.0 (server_hostinger): State transfer to 1.0 (server_vconnect) failed: No message of desired type
2025-04-29T16:55:28.119628Z 0 [ERROR] [MY-000000] [WSREP] P: ./gcs/src/gcs_group.cpp:gcs_group_handle_join_msg():1213: Will never receive state. Need to abort.
2025-04-29T16:55:28.119634Z 0 [System] [MY-000000] [WSREP] P: gcomm: terminating thread
2025-04-29T16:55:28.119643Z 0 [System] [MY-000000] [WSREP] P: gcomm: joining thread
2025-04-29T16:55:28.119701Z 0 [System] [MY-000000] [WSREP] P: gcomm: closing backend
2025-04-29T16:55:28.126229Z 0 [System] [MY-000000] [WSREP] P: view(view_id(NON_PRIM,a3280a3c-accb,49556) memb {
c00d70a0-94d5,0
} joined {
} left {
} partitioned {
a3280a3c-accb,0
da95b9a7-a18c,0
e65d51b5-a6da,0
})
2025-04-29T16:55:28.126252Z 0 [System] [MY-000000] [WSREP] P: PC protocol downgrade 1 -> 0
2025-04-29T16:55:28.126257Z 0 [System] [MY-000000] [WSREP] P: view((empty))
2025-04-29T16:55:28.126338Z 0 [System] [MY-000000] [WSREP] P: gcomm: closed
2025-04-29T16:55:28.126347Z 0 [System] [MY-000000] [WSREP] P: /usr/sbin/mysqld: Terminated.
Terminado
WSREP_SST: [INFO] Joiner cleanup. rsync PID: 1004291 (20250429 13:55:28.133)
WSREP_SST: [INFO] Joiner cleanup done. (20250429 13:55:28.637)
2025-04-29T16:55:28.904529Z 0 [System] [MY-015015] [Server] MySQL Server - start.
2025-04-29T16:55:29.079126Z 0 [Warning] [MY-011070] [Server] 'binlog_format' is deprecated and will be removed in a future release.
2025-04-29T16:55:29.079715Z 0 [Note] [MY-013932] [Server] BuildID[sha1]=fcbc0dba1e619a96ac1da4d4cd7c29e3e902e50f
2025-04-29T16:55:29.079719Z 0 [Note] [MY-010949] [Server] Basedir set to /usr/.
2025-04-29T16:55:29.079726Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.4.4) starting as process 1004370
2025-04-29T16:55:29.082811Z 0 [Note] [MY-012366] [InnoDB] Using Linux native AIO
2025-04-29T16:55:29.082840Z 0 [Note] [MY-015140] [InnoDB] Using innodb_flush_method=O_DIRECT
2025-04-29T16:55:29.082963Z 0 [Note] [MY-010747] [Server] Plugin 'FEDERATED' is disabled.
2025-04-29T16:55:29.082999Z 0 [Note] [MY-010747] [Server] Plugin 'ndbcluster' is disabled.
2025-04-29T16:55:29.083006Z 0 [Note] [MY-010747] [Server] Plugin 'ndbinfo' is disabled.
2025-04-29T16:55:29.083009Z 0 [Note] [MY-010747] [Server] Plugin 'ndb_transid_mysql_connection_map' is disabled.
2025-04-29T16:55:29.083051Z 0 [Note] [MY-010747] [Server] Plugin 'wsrep_provider' is disabled.
2025-04-29T16:55:29.083054Z 0 [Note] [MY-010747] [Server] Plugin 'mysql_native_password' is disabled.
2025-04-29T16:55:29.083812Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2025-04-29T16:55:29.083839Z 1 [Note] [MY-013546] [InnoDB] Atomic write enabled
2025-04-29T16:55:29.083868Z 1 [Note] [MY-012932] [InnoDB] PUNCH HOLE support available
2025-04-29T16:55:29.083874Z 1 [Note] [MY-012944] [InnoDB] Uses event mutexes
2025-04-29T16:55:29.083877Z 1 [Note] [MY-012945] [InnoDB] GCC builtin __atomic_thread_fence() is used for memory barrier
2025-04-29T16:55:29.083891Z 1 [Note] [MY-012948] [InnoDB] Compressed tables use zlib 1.2.13
2025-04-29T16:55:29.085164Z 1 [Note] [MY-012951] [InnoDB] Using hardware accelerated crc32 and polynomial multiplication.
2025-04-29T16:55:29.085452Z 1 [Note] [MY-012203] [InnoDB] Directories to scan './'
2025-04-29T16:55:29.085481Z 1 [Note] [MY-012204] [InnoDB] Scanning './'

I changed the IPs to names for security reasons. I've already formatted the VPS, changed networks, changed internet providers and it still won't connect.

Matt Horwood

unread,

Apr 30, 2025, 3:12:17 AMApr 30

to codership

Hello,

I would recommend that you don't add just one new node, as all clusters should have an odd number of nodes.

To make up the numbers, you could add an arbitrator -> https://galeracluster.com/library/documentation/arbitrator.html

brian....@gmail.com

unread,

Apr 30, 2025, 3:48:17 AMApr 30

to codership

I don't know if it's obvious but I'd concentrate on these two entries:

2025-04-29T16:55:28.117870Z 0 [Warning] [MY-000000] [WSREP] P: 0.0 (server_hostinger): State transfer to 1.0 (server_vconnect) failed: No message of desired type

2025-04-29T16:55:26.998681Z 0 [System] [MY-000000] [WSREP] P: (c00d70a0-94d5, 'tcp://0.0.0.0:4567') Found matching local endpoint for a connection, blacklisting address tcp://IP_SERVER_ERROR:4567

And agreed - You should ensure odd number cluster servers, but that's almost certain not what bugs your config here.

No, I don't have the solution ;)

Bruno Macedo

unread,

Apr 30, 2025, 4:17:00 AMApr 30

to Matt Horwood, codership

Thanks for the reply.

Our goal is to have 5 nodes, in fact we have already configured these two nodes, unfortunately neither of them connects, it shows practically the same log.

I have tried connecting both together, separately, always the same result.

Quando a última árvore for cortada,
Quando o último rio estiver seco,
Quando o último animal for morto,
O ser humano perceberá que não se come dinheiro

Mayden | The Old Dairy, Melcombe Road | Bath | BA2 3LR
Tel: 01249 701100 | www.mayden.co.uk

This email and any attachments are confidential and intended for the addressee only. If you are not the named recipient, you must not use, disclose, reproduce, copy or distribute the contents of this communication; instead, please contact the sender and delete this email from your system.
Company information | Privacy Policy | Disclaimer

--
You received this message because you are subscribed to the Google Groups "codership" group.
To unsubscribe from this group and stop receiving emails from it, send an email to codership-tea...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/codership-team/bec81cc6-dea4-4522-87d7-4909dcf4dc90n%40googlegroups.com.

Bruno Macedo

unread,

Apr 30, 2025, 4:17:56 AMApr 30

to Matt Horwood, codership

Thanks for the reply.

Our goal is to have 5 nodes, in fact we have already configured these two nodes, unfortunately neither of them connects, it shows practically the same log.

I have tried connecting both together, separately, always the same result.

Quando a última árvore for cortada,
Quando o último rio estiver seco,
Quando o último animal for morto,
O ser humano perceberá que não se come dinheiro

Em qua., 30 de abr. de 2025, 04:12, 'Matt Horwood' via codership <codersh...@googlegroups.com> escreveu:

Bruno Macedo

unread,

Apr 30, 2025, 4:22:32 AMApr 30

to brian....@gmail.com, codership

Thanks for the reply.

I really think it must be something like that, because the other servers don't show this message. I just don't know what could cause this to happen.

I even hired a new VPS to test it, but no matter where it is, it always has the same problem, basically no one connects except those that are already connected.

Quando a última árvore for cortada,
Quando o último rio estiver seco,
Quando o último animal for morto,
O ser humano perceberá que não se come dinheiro

--
You received this message because you are subscribed to the Google Groups "codership" group.
To unsubscribe from this group and stop receiving emails from it, send an email to codership-tea...@googlegroups.com.

To view this discussion visit https://groups.google.com/d/msgid/codership-team/0ca7c3fc-f5d0-44cf-b2f0-6503dd63a127n%40googlegroups.com.

Reply all

Reply to author

Forward

0 new messages