0

My cluster crashed and i cannot restart the first node with galera_new_cluster.

The nodes are distributed geographically in France with medium latency of 12ms.

It remains on /usr/bin/galera_recovery without doing anything.Htop screenshot

This is my Galera config on all nodes (values may change in order to match node IP etc)...

#
# * Galera-related settings
#
# See the examples of server wsrep.cnf files in /usr/share/mysql
# and read more at https://mariadb.com/kb/en/galera-cluster/

[galera]
# Mandatory settings
wsrep_provider           = /usr/lib/libgalera_smm.so
wsrep_on                 = ON
wsrep_cluster_name       = "xxxxCLUSTER"
wsrep_cluster_address    = "gcomm://xxx.xxx.xxx.100,xxx.xxx.xxx.101,xxx.xxx.xxx.102"
binlog_format            = ROW
default_storage_engine   = InnoDB
#innodb_autoinc_lock_mode = 2

wsrep_sst_method         = rsync

# Allow server to accept connections on all interfaces.
bind-address = 0.0.0.0

#wsrep_sst_donor          = "DB2"

# Optional settings
wsrep_slave_threads      = 32
wsrep_node_name          = "DB0"
wsrep_node_address       = "xxx.xxx.xxx.100"

#innodb_flush_log_at_trx_commit = 0

Since i've been using Galera for years in his MariaDB 10.x version i know that safe_to_bootstrap has to be set 1 ecc...But nothing works with galera_new_cluster and i cannot figure out why.

This is a typical log from wsrep_recovery

021-03-27  2:06:14 0 [Note] /usr/sbin/mysqld (mysqld 10.5.9-MariaDB-1:10.5.9+maria~buster) starting as process 8286 ...
2021-03-27  2:06:14 0 [Note] InnoDB: Uses event mutexes
2021-03-27  2:06:14 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-03-27  2:06:14 0 [Note] InnoDB: Number of pools: 1
2021-03-27  2:06:14 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2021-03-27  2:06:14 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
2021-03-27  2:06:14 0 [Note] InnoDB: Using Linux native AIO
2021-03-27  2:06:14 0 [Note] InnoDB: Initializing buffer pool, total size = 1073741824, chunk size = 134217728
2021-03-27  2:06:14 0 [Note] InnoDB: Completed initialization of buffer pool
2021-03-27  2:06:14 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2021-03-27  2:06:14 0 [Note] InnoDB: 128 rollback segments are active.
2021-03-27  2:06:14 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-03-27  2:06:14 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-03-27  2:06:14 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2021-03-27  2:06:14 0 [Note] InnoDB: 10.5.9 started; log sequence number 57353507521; transaction id 2641101
2021-03-27  2:06:14 0 [Warning] InnoDB: Skipping buffer pool dump/restore during wsrep recovery.
2021-03-27  2:06:14 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-03-27  2:06:14 0 [Note] Recovering after a crash using tc.log
2021-03-27  2:06:14 0 [Note] Starting crash recovery...
2021-03-27  2:06:14 0 [Note] Crash recovery finished.
2021-03-27  2:06:14 0 [Note] Server socket created on IP: '::'.
2021-03-27  2:06:14 0 [Note] WSREP: Recovered position: 2edc32a3-8e96-11eb-9165-6281b552400d:7

Can someone help me figuring out why? I'm really desperated.

Thank you so much!

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.