Mailing List Archive

PacemakerでMySQLが起動できないことについて
$B=i$a$^$7$F!"EOJU$H?=$7$^$9!#(B
$B8=:_!"(BMySQL$B$N%U%'!<%k%*!<%P!<%/%i%9%?$r9=C[.$7$F$$$k$N$G$9$,!"(B
Pacemaker$B$+$i(BMySQL$B$r5/F0$5$;$k$3$H$,$G$-$:!":$$C$F$*$j$^$9!#(B

crm_mon$B$N%9%F!<%?%9$G(BMySQL$B$N%j%=!<%9$,(B"not installed"$B$H$J$C$F$*$j!"(B
"'Setup problem: couldn't find command: mysql"$B$H$N%(%i!<%m%0$,=P$F$*$j$^$9!#(B

$B0J2<$K>pJs$r5-:\$$$?$7$^$9$N$G!"@_Dj$NITB-$d8m$j$,$"$j$^$7$?$i!"(B
$B$465<x$$$?$@$1$J$$$G$7$g$&$+!#(B

$B"#4D6-(B
CentOS7
MySQL5.6.28
pacemaker1.1.13
corosync2.3.4
drbd8.4.6

$B"#(BPacemaker$B<B9T;~$N(Bcrm_mon$B$NFbMF(B
Last updated: Tue Jan 12 10:56:53 2016 Last change: Tue Jan
12 10:52:16 2016 by root via cibadmin on goss-db2.oss.co
Stack: corosync
Current DC: goss-db3.oss.co (version 1.1.13-10.el7-44eb2dd) -
partition with quorum
2 nodes and 5 resources configured

Online: [ goss-db2.oss.co goss-db3.oss.co ]

Master/Slave Set: ms_drbd_r0 [res_drbd_r0]
Masters: [ goss-db3.oss.co ]
Slaves: [ goss-db2.oss.co ]
Resource Group: rg_mysql
res_vipaddr (ocf::heartbeat:IPaddr2): Started goss-db3.oss.co
res_fsmnt (ocf::heartbeat:Filesystem): Started goss-db3.oss.co
res_mysql (ocf::heartbeat:mysql): Stopped

Failed Actions:
* res_mysql_start_0 on goss-db3.oss.co 'not installed' (5): call=32,
status=complete, exitreason='Setup problem: couldn't find command:
mysql',
last-rc-change='Tue Jan 12 10:56:51 2016', queued=1ms, exec=88ms
* res_mysql_start_0 on goss-db2.oss.co 'not installed' (5): call=27,
status=complete, exitreason='Setup problem: couldn't find command:
mysql',
last-rc-change='Tue Jan 12 10:56:49 2016', queued=0ms, exec=89ms

$B"#(Bcorosync.log$B$NFbMF(B
Jan 12 10:48:07 [2233] goss-db2.oss.co crmd: notice:
te_rsc_command: Initiating action 37: start res_mysql_start_0 on
goss-db2.oss.co (local)
Jan 12 10:48:07 [2233] goss-db2.oss.co crmd: info:
do_lrm_rsc_op: Performing
key=37:1:0:b2d31e23-57bf-458e-900e-d12f491bb439 op=res_mysql_start_0
Jan 12 10:48:07 [2230] goss-db2.oss.co lrmd: info:
log_execute: executing - rsc:res_mysql action:start call_id:27
mysql(res_mysql)[2846]: 2016/01/12_10:48:07 ERROR: Setup problem:
couldn't find command: mysql
Jan 12 10:48:07 [2230] goss-db2.oss.co lrmd: notice:
operation_finished: res_mysql_start_0:2846:stderr [
ocf-exit-reason:Setup problem: couldn't find command: mysql ]
Jan 12 10:48:07 [2230] goss-db2.oss.co lrmd: info:
log_finished: finished - rsc:res_mysql action:start call_id:27
pid:2846 exit-code:5 exec-time:89ms queue-time:0ms

$B"#(BPacemaker$B$N(BCRM$B@_Dj(B
node 1: goss-db2.oss.co
node 2: goss-db3.oss.co
primitive res_drbd_r0 ocf:linbit:drbd \
params drbd_resource=r0 \
op start interval=0 timeout=240 \
op stop interval=0 timeout=100
primitive res_fsmnt Filesystem \
params device="/dev/drbd0" directory="/drbd" fstype=xfs
options=noatime \
op start interval=0 timeout=60 \
op stop interval=0 timeout=60
primitive res_mysql mysql \
params binary="/usr/local/mysql/bin/mysqld_safe"
datadir="/usr/local/mysql/data" config="/usr/local/mysql/my.cnf"
socket="/tmp/mysql.sock" pid="/var/run/mysqld/mysqld.pid" user=mysql
group=mysql additional_parameters="--ledir=/usr/local/mysql/bin
--basedir=/usr/local/mysql" \
op start interval=0 timeout=120 \
op stop interval=0 timeout=120 \
op notify interval=90 timeout=90 \
op monitor interval=20 timeout=30 \
meta target-role=Started
primitive res_vipaddr IPaddr2 \
params ip=192.168.202.10 cidr_netmask=16 nic=eth0 \
op start interval=0 timeout=20 \
op stop interval=0 timeout=20 \
op monitor interval=10 timeout=20
group rg_mysql res_vipaddr res_fsmnt res_mysql \
meta target-role=Started
ms ms_drbd_r0 res_drbd_r0 \
meta master-max=1 master-node-max=1 clone-max=2
clone-node-max=1 notify=true
location l_mysql rg_mysql 100: goss-db2.oss.co
colocation c_mysql inf: rg_mysql ms_drbd_r0:Master
order o_mysql inf: ms_drbd_r0:promote rg_mysql:start
property cib-bootstrap-options: \
have-watchdog=false \
dc-version=1.1.13-10.el7-44eb2dd \
cluster-infrastructure=corosync \
stonith-enabled=false \
no-quorum-policy=ignore \
default-resource-stickiness=200 \
last-lrm-refresh=1452146199

$B"#(BMySQL$B$N%$%s%9%H!<%k>pJs(B
tar$B$r2rE`$7!"%P%$%J%j%U%!%$%k$r2<5-$N%G%#%l%/%H%j$KG[CV$7$F$*$j$^$9!#(B
data$B%G%#%l%/%H%j$K$D$$$F$O!"(BDRBD$B%l%W%j%1!<%7%g%sNN0h$G$"$k(B/drbd/data/$B%G%#%l%/%H%j$K<BBN$rG[CV$7!"(B
$B85$N>l=j$K%7%s%\%j%C%/%j%s%/$rG[CV$7$F$*$j$^$9!#(B

$B!Z(B/usr/local/mysql/$B![(B
-rw-r--r-- 1 root mysql 17987 11$B7n(B 16 18:38 COPYING
-rw-r--r-- 1 root mysql 105684 11$B7n(B 16 19:45 INSTALL-BINARY
-rw-r--r-- 1 root mysql 2496 11$B7n(B 16 18:38 README
drwxr-xr-x 2 root mysql 4096 1$B7n(B 8 20:20 bin
lrwxrwxrwx 1 root root 11 1$B7n(B 8 20:48 data -> /drbd/data/
drwxr-xr-x 2 root mysql 52 1$B7n(B 8 20:21 docs
drwxr-xr-x 3 root mysql 4096 1$B7n(B 8 20:21 include
drwxr-xr-x 3 root mysql 4096 1$B7n(B 8 20:21 lib
drwxr-xr-x 4 root mysql 28 1$B7n(B 8 20:20 man
-rw-r--r-- 1 root root 943 1$B7n(B 8 20:27 my.cnf
drwxr-xr-x 10 root mysql 4096 1$B7n(B 8 20:21 mysql-test
drwxr-xr-x 2 root mysql 29 1$B7n(B 8 20:21 scripts
drwxr-xr-x 28 root mysql 4096 1$B7n(B 8 20:20 share
drwxr-xr-x 4 root mysql 4096 1$B7n(B 8 20:21 sql-bench
drwxr-xr-x 2 root mysql 130 1$B7n(B 8 20:21 support-files

$B!Z(B/usr/local/mysql/bin$B![(B
-rwxr-xr-x 1 root mysql 4701024 11$B7n(B 17 03:18 innochecksum
-rwxr-xr-x 1 root mysql 1551 11$B7n(B 17 03:18 msql2mysql
-rwxr-xr-x 1 root mysql 4641950 11$B7n(B 17 03:18 my_print_defaults
-rwxr-xr-x 1 root mysql 6710319 11$B7n(B 17 03:19 myisam_ftdump
-rwxr-xr-x 1 root mysql 7115362 11$B7n(B 17 03:19 myisamchk
-rwxr-xr-x 1 root mysql 6592972 11$B7n(B 17 03:19 myisamlog
-rwxr-xr-x 1 root mysql 6794938 11$B7n(B 17 03:19 myisampack
-rwxr-xr-x 1 root mysql 9007758 11$B7n(B 17 03:19 mysql
-rwxr-xr-x 1 root mysql 9069359 11$B7n(B 17 03:19 mysql_client_test
-rwxr-xr-x 1 root mysql 74201485 11$B7n(B 17 03:21 mysql_client_test_embedded
-rwxr-xr-x 1 root mysql 6519 11$B7n(B 17 03:18 mysql_config
-rwxr-xr-x 1 root mysql 7247068 11$B7n(B 17 03:19 mysql_config_editor
-rwxr-xr-x 1 root mysql 4334 11$B7n(B 17 03:18 mysql_convert_table_format
-rwxr-xr-x 1 root mysql 74016631 11$B7n(B 17 03:21 mysql_embedded
-rwxr-xr-x 1 root mysql 3409 11$B7n(B 17 03:18 mysql_find_rows
-rwxr-xr-x 1 root mysql 1366 11$B7n(B 17 03:18 mysql_fix_extensions
-rwxr-xr-x 1 root mysql 4686721 11$B7n(B 17 03:19 mysql_plugin
-rwxr-xr-x 1 root mysql 10106 11$B7n(B 17 03:18 mysql_secure_installation
-rwxr-xr-x 1 root mysql 17584 11$B7n(B 17 03:18 mysql_setpermission
-rwxr-xr-x 1 root mysql 4371253 11$B7n(B 17 03:18 mysql_tzinfo_to_sql
-rwxr-xr-x 1 root mysql 4844189 11$B7n(B 17 03:19 mysql_upgrade
-rwxr-xr-x 1 root mysql 4639227 11$B7n(B 17 03:18 mysql_waitpid
-rwxr-xr-x 1 root mysql 3976 11$B7n(B 17 03:18 mysql_zap
-rwxr-xr-x 1 root mysql 111803 11$B7n(B 17 03:18 mysqlaccess
-rwxr-xr-x 1 root mysql 1702 11$B7n(B 17 03:18 mysqlaccess.conf
-rwxr-xr-x 1 root mysql 8040859 11$B7n(B 17 03:19 mysqladmin
-rwxr-xr-x 1 root mysql 8841737 11$B7n(B 17 03:19 mysqlbinlog
-rwxr-xr-x 1 root mysql 10940 11$B7n(B 17 03:18 mysqlbug
-rwxr-xr-x 1 root mysql 8019685 11$B7n(B 17 03:19 mysqlcheck
-rwxr-xr-x 1 root mysql 78702773 11$B7n(B 17 03:21 mysqld
-rwxr-xr-x 1 root mysql 99889287 11$B7n(B 17 03:18 mysqld-debug
-rwxr-xr-x 1 root mysql 26543 11$B7n(B 17 03:18 mysqld_multi
-rwxr-xr-x 1 root mysql 24837 11$B7n(B 17 03:18 mysqld_safe
-rwxr-xr-x 1 root mysql 8254227 11$B7n(B 17 03:19 mysqldump
-rwxr-xr-x 1 root mysql 7424 11$B7n(B 17 03:18 mysqldumpslow
-rwxr-xr-x 1 root mysql 34938 11$B7n(B 17 03:18 mysqlhotcopy
-rwxr-xr-x 1 root mysql 8035473 11$B7n(B 17 03:19 mysqlimport
-rwxr-xr-x 1 root mysql 8012414 11$B7n(B 17 03:19 mysqlshow
-rwxr-xr-x 1 root mysql 8088124 11$B7n(B 17 03:19 mysqlslap
-rwxr-xr-x 1 root mysql 8673494 11$B7n(B 17 03:19 mysqltest
-rwxr-xr-x 1 root mysql 73530803 11$B7n(B 17 03:21 mysqltest_embedded
-rwxr-xr-x 1 root mysql 4750680 11$B7n(B 17 03:19 perror
-rwxr-xr-x 1 root mysql 4489716 11$B7n(B 17 03:18 replace
-rwxr-xr-x 1 root mysql 4708639 11$B7n(B 17 03:18 resolve_stack_dump
-rwxr-xr-x 1 root mysql 4641283 11$B7n(B 17 03:18 resolveip

$BD9J8$H$J$j$^$7$?$3$H!"$4MF<O$/$@$5$$!#(B
$B0J>e!"$*<j?t$r$*$+$1$$$?$7$^$9$,!"$h$m$7$/$*4j$$$$$?$7$^$9!#(B

_______________________________________________
Linux-ha-japan mailing list
Linux-ha-japan@lists.osdn.me
http://lists.osdn.me/mailman/listinfo/linux-ha-japan
Re: PacemakerでMySQLが起動できないことについて [ In reply to ]
渡辺さん

こんにちは、松島と申します。

エラーメッセージにはmysqlコマンドについて書かれていますね。これはクライアントコマンドのことを言っているのだと思います。
MySQLのインストール先によっては(といってもスクリプト中ではPATHが通っていることをあまり期待できないのですが…)mysqlクライアントコマンドを叩けないことがあります。

RAのclient_binaryオプションにmysqlクライアントコマンドへのパスを設定されてみていかがでしょうか。
Re: PacemakerでMySQLが起動できないことについて [ In reply to ]
$B>>Eg$5$^(B

$B$*@$OC$K$J$C$F$*$j$^$9!#EOJU$H?=$7$^$9!#(B
$BAaB.$N$42sEz!"$"$j$,$H$&$4$6$$$^$7$?!#(B
$B$4Ds0F$$$?$@$$$?(Bclient_binary$B$K(Bmysql$B%/%i%$%"%s%H$N%P%$%J%j$N%Q%9$r;XDj$7$?$H$3$m!"(B
Pacemaker$B$+$i(BMySQL$B$r5/F0$5$;$k$3$H$,$G$-$^$7$?!#(B
$B!J6qBNE*$K$O!"(Bclient_binary="/usr/local/mysql/bin/mysql"$B$rDI2C!K(B

$B;29M$K$7$F$$$?(BWeb$B%Z!<%8$G$O(Bclient_binary$B$r;XDj$7$F$$$J$+$C$?$3$H$H!"(B
OS$B$G(B"/usr/local/mysql/bin/"$B$K%Q%9$rDL$7$F$$$?$?$a!"L$;XDj$H$7$F$$$^$7$?$,!"(B
$B4D6-$K$h$C$F$O;XDj$7$J$1$l$P$$$1$J$$$N$G$9$M!#(B

$B$3$NEY$OBgJQ=u$+$j$^$7$?!#$"$j$,$H$&$4$6$$$^$7$?!#(B


2016$BG/(B1$B7n(B13$BF|(B 19:37 Takehiro Matsushima <takehiro.dreamizm@gmail.com>:
> $BEOJU$5$s(B
>
> $B$3$s$K$A$O!">>Eg$H?=$7$^$9!#(B
>
> $B%(%i!<%a%C%;!<%8$K$O(Bmysql$B%3%^%s%I$K$D$$$F=q$+$l$F$$$^$9$M!#$3$l$O%/%i%$%"%s%H%3%^%s%I$N$3$H$r8@$C$F$$$k$N$@$H;W$$$^$9!#(B
> MySQL$B$N%$%s%9%H!<%k@h$K$h$C$F$O!J$H$$$C$F$b%9%/%j%W%HCf$G$O(BPATH$B$,DL$C$F$$$k$3$H$r$"$^$j4|BT$G$-$J$$$N$G$9$,!D!K(Bmysql$B%/%i%$%"%s%H%3%^%s%I$rC!$1$J$$$3$H$,$"$j$^$9!#(B
>
> RA$B$N(Bclient_binary$B%*%W%7%g%s$K(Bmysql$B%/%i%$%"%s%H%3%^%s%I$X$N%Q%9$r@_Dj$5$l$F$_$F$$$+$,$G$7$g$&$+!#(B
>
>
> _______________________________________________
> Linux-ha-japan mailing list
> Linux-ha-japan@lists.osdn.me
> http://lists.osdn.me/mailman/listinfo/linux-ha-japan
>
_______________________________________________
Linux-ha-japan mailing list
Linux-ha-japan@lists.osdn.me
http://lists.osdn.me/mailman/listinfo/linux-ha-japan