[MDEV-16032] 10.0.34 (probably) package broken on Ubuntu Trusty (unable to join Galera cluster) Created: 2018-04-25  Updated: 2018-08-30  Resolved: 2018-08-29

Status: Closed
Project: MariaDB Server
Component/s: Galera, Galera SST
Affects Version/s: 10.0, 10.0.34-galera
Fix Version/s: 10.0.36-galera

Type: Bug Priority: Blocker
Reporter: Claudio Kuenzler Assignee: Jan Lindström (Inactive)
Resolution: Fixed Votes: 0
Labels: None
Environment:

Linux, Ubuntu 14.04 Trusty

Attachments: Text File galera-node-error.log     Text File galera-node-success.log    
Issue Links:
Relates
relates to MDEV-15254 10.1.31 does not join an existing clu... Closed

 Description   

After updating today from 10.0.32 to 10.0.34 on a Ubuntu 14.04 Trusty, the node does not join the Galera cluster anymore with xtrabackup.

Relevant error message: 

Apr 25 22:06:10 galera-node-2 mysqld: /usr//bin/wsrep_sst_xtrabackup: line 397: setup_ports: command not found

After having copied the old /usr/bin/wsrep_sst_xtrabackup from a node with 10.0.31, this node was able to join the cluster again after a MariaDB restart.

Installed packages (after the update):

# dpkg -l| egrep "(mariadb|galera|wsrep)"
 
ii  galera-3                             25.3.22-trusty                             amd64        Replication framework for transactional applications
 
ii  libmariadbclient18                   10.0.34+maria-1~trusty                     amd64        MariaDB database client library
 
ii  mariadb-client-10.0                  10.0.34+maria-1~trusty                     amd64        MariaDB database client binaries
 
ii  mariadb-client-core-10.0             10.0.34+maria-1~trusty                     amd64        MariaDB database core client binaries
 
ii  mariadb-common                       10.0.34+maria-1~trusty                     all          MariaDB database common files (e.g. /etc/mysql/conf.d/mariadb.cnf)
 
ii  mariadb-galera-server                10.0.34+maria-1~trusty                     all          MariaDB database server with Galera cluster (metapackage depending on the latest version)
 
ii  mariadb-galera-server-10.0           10.0.34+maria-1~trusty                     amd64        MariaDB database server with Galera cluster binaries

According to apt, this file (/usr/bin/wsrep_sst_xtrabackup) comes from:

# dpkg -S /usr/bin/wsrep_sst_xtrabackup
 
mariadb-galera-server-10.0: /usr/bin/wsrep_sst_xtrabackup

I find this is very similar to issue https://jira.mariadb.org/browse/MDEV-15254 but there the ticket was closed already. Feel free to mark this is dupe if it should be followed-up on an already existing issue.

 Comments   
Comment by Claudio Kuenzler [ 2018-04-25 ]

Looks like the function setup_ports got removed in https://github.com/mariadb-corporation/mariadb-columnstore-server/commit/c383418cbf754c654a9a705ddb73a107e390ecb2#diff-7128ccb1c704591dbe0ce47aac7b6d76 but the function is still called.

Comment by Jan Lindström (Inactive) [ 2018-05-08 ]

serg Can you check is this merge error ?

Comment by Daniel Black [ 2018-05-08 ]

aka MDEV-15857 / MDEV-15351 / https://github.com/MariaDB/server/pull/717

sorry to say its probably a my error and the function should be removed. wsrep_sst_common sets the same vars.

Comment by Sergei Golubchik [ 2018-05-08 ]

following commit https://github.com/MariaDB/server/commit/a2a038152eb9ea setup_ports should be removed from wsrep_sst_xtrabackup.sh

Comment by Jan Lindström (Inactive) [ 2018-08-29 ]

I do no see setup_ports on current version of 10.0-galera.

Comment by Claudio Kuenzler [ 2018-08-30 ]

Can confirm:

$ dpkg -l|grep mariadb
 
ii  libmariadbclient18                   10.0.33+maria-1~trusty                     amd64        MariaDB database client library
 
ii  mariadb-client-10.0                  10.0.33+maria-1~trusty                     amd64        MariaDB database client binaries
 
ii  mariadb-client-core-10.0             10.0.33+maria-1~trusty                     amd64        MariaDB database core client binaries
 
ii  mariadb-common                       10.0.33+maria-1~trusty                     all          MariaDB database common files (e.g. /etc/mysql/conf.d/mariadb.cnf)
 
ii  mariadb-galera-server                10.0.33+maria-1~trusty                     all          MariaDB database server with Galera cluster (metapackage depending on the latest version)
 
ii  mariadb-galera-server-10.0           10.0.33+maria-1~trusty                     amd64        MariaDB database server with Galera cluster binaries
 
 
 
$ grep setup_ports /usr//bin/wsrep_sst_xtrabackup
 
setup_ports()
 
setup_ports

Then ran in general a system update (apt-get upgrade) which installed 10.0.36:

$ dpkg -l|grep mariadb
 
ii  libmariadbclient18                   10.0.36+maria-1~trusty                     amd64        MariaDB database client library
 
ii  mariadb-client-10.0                  10.0.36+maria-1~trusty                     amd64        MariaDB database client binaries
 
ii  mariadb-client-core-10.0             10.0.36+maria-1~trusty                     amd64        MariaDB database core client binaries
 
ii  mariadb-common                       10.0.36+maria-1~trusty                     all          MariaDB database common files (e.g. /etc/mysql/conf.d/mariadb.cnf)
 
ii  mariadb-galera-server                10.0.36+maria-1~trusty                     all          MariaDB database server with Galera cluster (metapackage depending on the latest version)
 
ii  mariadb-galera-server-10.0           10.0.36+maria-1~trusty                     amd64        MariaDB database server with Galera cluster binaries

setup_ports function is now gone:

$ grep setup_ports /usr//bin/wsrep_sst_xtrabackup; date
 
Thu Aug 30 10:56:55 CEST 2018

Generated at Thu Feb 08 08:25:51 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.