<html>
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<font face="sans-serif">As Patrick</font> pointed here:
<a class="moz-txt-link-freetext" href="http://serverfault.com/questions/405982/mysql-pacemaker-cannot-start-the-failed-master-as-a-new-slave">http://serverfault.com/questions/405982/mysql-pacemaker-cannot-start-the-failed-master-as-a-new-slave</a><br>
<br>
I need to set the additional variables to tells the script its a
master/slave resource.<br>
So, I've appended the following variables to my <code>~/.bash_profile</code>:<br>
<pre><code>export OCF_RESKEY_CRM_meta_clone_max="2"
export OCF_RESKEY_CRM_meta_role="Slave"</code></pre>
Make it take effect <code>. ~/.bash_profile</code> and manually
start mysql resource:<br>
<p><code>sh -x /usr/lib/ocf/resource.d/percona/mysql start</code>: <a
href="http://fpaste.org/EMwa/" rel="nofollow">http://fpaste.org/EMwa/</a></p>
and it works fine:<br>
<br>
<pre><code>mysql> show slave status\G
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: 192.168.6.38
Master_User: repl
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.000072
Read_Master_Log_Pos: 1428602
Relay_Log_File: mysqld-relay-bin.000006
Relay_Log_Pos: 39370
Relay_Master_Log_File: mysql-bin.000072
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 0
Last_Error:
Skip_Counter: 0
Exec_Master_Log_Pos: 1428602
Relay_Log_Space: 39527
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 0
Last_IO_Error:
Last_SQL_Errno: 0
Last_SQL_Error:
Replicate_Ignore_Server_Ids:
Master_Server_Id: 123
1 row in set (0.00 sec)</code></pre>
I've been turing on the debug, stop corosync and restart, here're
the logs: <a class="moz-txt-link-freetext" href="http://fpaste.org/mZzS/">http://fpaste.org/mZzS/</a><br>
As you can see, nothing details than 'unknown error':<br>
<ol class="paste_lines">
<ol class="paste_lines">
<pre class="paste_scroller"><li id="228" class="lineno"><div class="paste_content">Jul 13 10:48:06 serving-6192 crmd: [3341]: debug: get_xpath_object: No match for //cib_update_result//diff-added//crm_config in /notify/cib_update_result/diff</div></li><li id="229" class="lineno"><div class="paste_content">Jul 13 10:48:06 serving-6192 lrmd: [3338]: WARN: Managed p_mysql:1:start process 3416 exited with return code 1.</div></li><li id="230" class="lineno special"><div class="paste_content">Jul 13 10:48:06 serving-6192 crmd: [3341]: info: process_lrm_event: LRM operation p_mysql:1_start_0 (call=4, rc=1, cib-update=10, confirmed=true) unknown error</div></li></pre>
</ol>
</ol>
Any thoughts?<br>
<br>
<br>
On 07/10/2012 09:27 AM, quanta wrote:
<blockquote cite="mid:4FFB9312.8020304@gmail.com" type="cite">
<pre wrap="">
On 07/10/2012 05:08 AM, Andreas Kurz wrote:
</pre>
<blockquote type="cite">
<pre wrap="">and you also use the latest mysql RA from resource-agents github?
</pre>
</blockquote>
<pre wrap="">Yes.
</pre>
<blockquote type="cite">
<pre wrap="">Not enough logs ... at least for me ... to give more hints. Regards,
Andreas
</pre>
</blockquote>
<pre wrap="">
Sorry, here for you: <a class="moz-txt-link-freetext" href="http://fpaste.org/AyOZ/">http://fpaste.org/AyOZ/</a>
</pre>
</blockquote>
</body>
</html>