Upgraded mariadb version from 10.0 to 10.1.13. Galera cluster not starting up

[Trupti Mali]

Hi,

Recently I upgraded from mariadb version 10.0 to 10.1.13. For upgrade - i followed the steps as follows on my debian machine.

1) Uninstall old version

2) install new version

3)  inspite of debian installation - I had to explicitly call mysql_upgrade to fix incompatibility issues.

4) During installation I overwrote the existing my.cnf file. I have a seperate galera.cnf file which has wsrep details as below.

wsrep_provider=/usr/lib/galera/libgalera_smm.so

wsrep_cluster_name=my_galera_cluster

wsrep_cluster_address=gcomm://

wsrep_sst_method=xtrabackup-v2

wsrep_sst_auth="root:XXXX"

wsrep_restart_slave=1

# Galera Node Configuration

wsrep_node_address="192.168.xxx.yyy"

wsrep_node_name="192.168.xxx.yyy"

But when I try to start the server with mysqld --wsrep-new-cluster - i dont see galera cluster started.. There are no updates / errors in the log about galera or wsrep. (another note _ after uninstall from 10.0 - i have retained the old data folders for mysql)

Attaching logs of mysql start -

 [Note] InnoDB: Using mutexes to ref count buffer pool pages

 [Note] InnoDB: The InnoDB memory heap is disabled

 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins

 [Note] InnoDB: Memory barrier is not used

 [Note] InnoDB: Compressed tables use zlib 1.2.8

 [Note] InnoDB: Using Linux native AIO

 [Note] InnoDB: Using SSE crc32 instructions

 [Note] InnoDB: Initializing buffer pool, size = 256.0M

 [Note] InnoDB: Completed initialization of buffer pool

 [Note] InnoDB: Highest supported file format is Barracuda.

 [Note] InnoDB: 128 rollback segment(s) are active.

 [Note] InnoDB: Waiting for purge to start

 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.28-76.1 started; log sequence number 352079035

Mar 27 17:16:36 localhost mysqld[22219]: 2016-03-27 17:16:36 140020635633408 [Note] InnoDB: Dumping buffer pool(s) not yet started

 [Note] Plugin 'FEEDBACK' is disabled.

 [Note] Server socket created on IP: '0.0.0.0'.

 [Note] Reading of all Master_info entries succeded

 [Note] Added new Master_info '' to hash table

 [Note] /usr/sbin/mysqld: ready for connections.

Mar 27 17:16:36 localhost mysqld[22219]: Version: '10.1.13-MariaDB-1~jessie'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  mariadb.org binary distribution

Mar 27 17:16:36 localhost mysqld[22249]: Checking for corrupt, not cleanly closed and upgrade needing tables.

Mar 27 17:16:36 localhost systemd[1]: Started MariaDB database server.

[Michaël de Groot]

In MariaDB 10.1, galera is built into the server's sourcecode. There is no different Galera package anymore.

This does mean that you have to ENABLE galera now by adding 'wsrep_on = 1' into your configuration file.

Hope that solves your issue!