[Pacemaker] Cannot start the failed MySQL master as a new slave?

[quanta]

As Patrick pointed here:
http://serverfault.com/questions/405982/mysql-pacemaker-cannot-start-the-failed-master-as-a-new-slave

I need to set the additional variables to tells the script its a
master/slave resource.
So, I've appended the following variables to my |~/.bash_profile|:

|export OCF_RESKEY_CRM_meta_clone_max="2"
export OCF_RESKEY_CRM_meta_role="Slave"|

Make it take effect |. ~/.bash_profile| and manually start mysql resource:

|sh -x /usr/lib/ocf/resource.d/percona/mysql start|: http://fpaste.org/EMwa/

and it works fine:

|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)|

I've been turing on the debug, stop corosync and restart, here're the
logs: http://fpaste.org/mZzS/
As you can see, nothing details than 'unknown error':

     1.
        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
     2.
        Jul 13 10:48:06 serving-6192 lrmd: [3338]: WARN: Managed
        p_mysql:1:start process 3416 exited with return code 1.
     3.
        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

Any thoughts?


On 07/10/2012 09:27 AM, quanta wrote:
>
> On 07/10/2012 05:08 AM, Andreas Kurz wrote:
>> and you also use the latest mysql RA from resource-agents github? 
> Yes.
>> Not enough logs ... at least for me ... to give more hints. Regards,
>> Andreas
> Sorry, here for you: http://fpaste.org/AyOZ/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.clusterlabs.org/pipermail/pacemaker/attachments/20120713/2b18671a/attachment.htm>