[MDEV-10954] MariaDB Galera: wsrep_sst_common: line 120: which: command not found Created: 2016-10-04  Updated: 2017-09-28  Resolved: 2016-11-22

Status: Closed
Project: MariaDB Server
Component/s: Galera SST
Affects Version/s: 10.1.18
Fix Version/s: 10.1.20

Type: Bug Priority: Minor
Reporter: Rob Brown Assignee: Nirbhay Choubey (Inactive)
Resolution: Fixed Votes: 0
Labels: None
Environment:

CentOS 7


Issue Links:
Problem/Incident
causes MDEV-13946 Server RPMs have dependency on "which" Closed

 Description   

MariaDB can not start on CentOS 7 platform:

MariaDB-server-10.1.18-1.el7.centos.x86_64

Versions 10.1.5 through 10.1.18 are affected.

After looking in mysqld.log I see the following error:

/usr//bin/wsrep_sst_common: line 120: which: command not found



 Comments   
Comment by Rob Brown [ 2016-10-04 ]

This problem only exists from MariaDB 10.1.5 through 10.1.18

Comment by Rob Brown [ 2016-10-04 ]

One work around for this problem is to install the "which" package:

[root@node2 ~]# yum install -y which
[...]
[root@node2 ~]# systemctl restart mariadb

Then everything works fine.

Comment by Rob Brown [ 2016-10-04 ]

Maybe a better solution might be to include "Requires: which" in either the MariaDB-server or galera rpm spec file.

Comment by Rob Brown [ 2016-11-08 ]

I just upgraded to MariaDB 10.1.19 and when I try to enable "wsrep_on=ON" I'm still unable to start the server due to the following error:

2016-11-08 13:12:58 140186172258048 [Note] WSREP: Flow-control interval: [32, 32]
2016-11-08 13:12:58 140186172258048 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 6967208)
2016-11-08 13:12:58 140186526259968 [Note] WSREP: State transfer required:
Group state: 08c1571e-8956-11e6-b83e-c7f185019621:6967208
Local state: 08c1571e-8956-11e6-b83e-c7f185019621:6967167
2016-11-08 13:12:58 140186526259968 [Note] WSREP: New cluster view: global state: 08c1571e-8956-11e6-b83e-c7f185019621:6967208, view# 91: Primary, number of nodes: 4, my index: 3, protocol version 3
2016-11-08 13:12:58 140186526259968 [Warning] WSREP: Gap in state sequence. Need state transfer.
2016-11-08 13:12:58 140186147092224 [Note] WSREP: Running: 'wsrep_sst_rsync --role 'joiner' --address '192.168.71.100' --datadir '/var/lib/mysql/' --parent '4202' --binlog 'mysql-binlog' '
/usr//bin/wsrep_sst_common: line 120: which: command not found
2016-11-08 13:12:59 140186147092224 [ERROR] WSREP: Failed to read 'ready <addr>' from: wsrep_sst_rsync --role 'joiner' --address '192.168.71.100' --datadir '/var/lib/mysql/' --parent '4202' --binlog 'mysql-binlog'
Read: '(null)'
2016-11-08 13:12:59 140186147092224 [ERROR] WSREP: Process completed with error: wsrep_sst_rsync --role 'joiner' --address '192.168.71.100' --datadir '/var/lib/mysql/' --parent '4202' --binlog 'mysql-binlog' : 2 (No such file or directory)
2016-11-08 13:12:59 140186526259968 [ERROR] WSREP: Failed to prepare for 'rsync' SST. Unrecoverable.
2016-11-08 13:12:59 140186526259968 [ERROR] Aborting

Error in my_thread_global_end(): 1 threads didn't exit
161108 13:13:07 mysqld_safe mysqld from pid file /var/log/mysqld/mysqld.pid ended

Generated at Thu Feb 08 07:46:11 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.