<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<style>
<!--
@font-face
{font-family:Wingdings}
@font-face
{font-family:Wingdings}
@font-face
{font-family:Calibri}
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif"}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{margin-top:0cm;
margin-right:0cm;
margin-bottom:0cm;
margin-left:36.0pt;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif"}
span.E-MailFormatvorlage17
{font-family:"Calibri","sans-serif";
color:windowtext}
.MsoChpDefault
{font-family:"Calibri","sans-serif"}
@page WordSection1
{margin:70.85pt 70.85pt 2.0cm 70.85pt}
div.WordSection1
{}
ol
{margin-bottom:0cm}
ul
{margin-bottom:0cm}
-->
</style>
</head>
<body lang="DE" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal">Hi!</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"><span lang="EN-US">I try to set up MySQL HA with pacemaker according to:</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US"><a href="http://www.mysqlperformanceblog.com/2011/11/29/percona-replication-manager-a-solution-for-mysql-high-availability-with-replication-using-pacemaker/">http://www.mysqlperformanceblog.com/2011/11/29/percona-replication-manager-a-solution-for-mysql-high-availability-with-replication-using-pacemaker/</a></span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US">When I do that, I find the following error in crm_mon:</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US">---</span></p>
<p class="MsoNormal"><span lang="EN-US">Master/Slave Set: ms_MySQL</span></p>
<p class="MsoNormal"><span lang="EN-US"> p_mysql:0 (ocf::heartbeat:mysql): Slave int-ipfuie-mgmt01 (unmanaged) FAILED</span></p>
<p class="MsoNormal"><span lang="EN-US"> p_mysql:1 (ocf::heartbeat:mysql): Slave int-ipfuie-mgmt02 (unmanaged) FAILED</span></p>
<p class="MsoNormal"><span lang="EN-US">writer_vip (ocf::heartbeat:IPaddr2): Started int-ipfuie-mgmt02</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US">Failed actions:</span></p>
<p class="MsoNormal"><span lang="EN-US"> p_mysql:0_monitor_0 (node=int-ipfuie-mgmt01, call=10, rc=1, status=complete): unknown error</span></p>
<p class="MsoNormal"><span lang="EN-US"> p_mysql:0_stop_0 (node=int-ipfuie-mgmt01, call=15, rc=1, status=complete): unknown error</span></p>
<p class="MsoNormal"><span lang="EN-US"> p_mysql:1_monitor_0 (node=int-ipfuie-mgmt02, call=10, rc=1, status=complete): unknown error</span></p>
<p class="MsoNormal"><span lang="EN-US"> p_mysql:1_stop_0 (node=int-ipfuie-mgmt02, call=15, rc=1, status=complete): unknown error</span></p>
<p class="MsoNormal"><span lang="EN-US">---</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US">Well, that isn’t the most detailed of all error messages.
</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US">I then did the following grep on /var/log/messages (debugging is already turned on in /etc/corosync/corosync.conf):</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US">grep -B 2 -A 2 -i mysql /var/log/messages | grep -i error | less</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US">The only message, that is a little more “revealing” says:</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US">---</span></p>
<p class="MsoNormal"><span lang="EN-US">Jan 23 12:50:46 int-ipfuie-mgmt01 crmd: [10070]: info: process_lrm_event: LRM operation p_mysql:0_monitor_0 (call=36, rc=1, cib-update=44, confirmed=true) unknown error</span></p>
<p class="MsoNormal"><span lang="EN-US">Jan 23 12:50:47 int-ipfuie-mgmt01 crmd: [10070]: info: process_lrm_event: LRM operation p_mysql:0_stop_0 (call=38, rc=1, cib-update=46, confirmed=true) unknown error</span></p>
<p class="MsoNormal"><span lang="EN-US">---</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US">Any ideas on how to get a little more information on why the resource failed? Where, for example, does the output of the resource scripts go by default? I feel they rather go to /dev/null, but definitely not to any logfile,
am I right? </span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US">If you have any suggestions, where else to look for more obvious error messages, please tell me so!</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US">What other means of debugging my config do I have?</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US">This all leads me to a more general question:</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US">Can I redirect pacemakers log messages to any other file than /var/log/messages (without configuring filters in syslog-ng)? The logging of pacemaker (at least in the version I’m using) does not seem to be influenced by
setting to_logfile: yes and logfile: /var/log/cluster.log in /etc/corosync.conf (which only get’s messages from corosync (TOTEM etc.).</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US">Thanks!</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US">Andreas</span></p>
</div>
<span style="font-family:Arial; font-size:9.0pt"><br>
------------------------ <br>
CONET Solutions GmbH, Theodor-Heuss-Allee 19, 53773 Hennef. <br>
Registergericht/Registration Court: Amtsgericht Siegburg (HRB Nr. 9136) <br>
Geschäftsführer/Managing Directors: Jürgen Zender (Sprecher/Chairman), Anke Höfer
</span>
</body>
</html>