Before changing , I confirmed that all the data in in sync and taken the site
off for 5 mintutes ..and then performed this ..
Any way to resolve this issue . ?
I even tried by taking the fresh data from the present mater using
native ndb_backup
and after getting the epoch and postions , tried to start this ..
Still it is failing ...
- Umapathi.
On Thu, May 10, 2012 at 1:00 PM, 谭俊青 <drinching@stripped> wrote:
>> 1) Cluster to Cluster :
> The slave cluster did not catch up all updated data, and the replication
> channel broke.
> You change your slave cluster as master, then you get your errors.
>
>> 2) Cluster to Non Cluster
> This should be a bug. We encountered the same error.
>
>
> On Thu, May 10, 2012 at 3:22 PM, umapathi b <umapathi.b@stripped> wrote:
>>
>> Hi All,
>>
>> I was having two set ups i.e 1 ) cluster to cluster 2) cluster to
>> non-cluster replication which were running previously successfully.
>>
>> 57-58 : master cluster ( 7.1.15 )
>> 58-59 : slave cluster ( 7.2 )
>> 60 : non-cluster slave ( 5.1 )
>>
>> Application was pointing to 57/58 and yesterday we changed the
>> application to point to 58/59 , after taking the site down for a
>> while.
>> After this , I cross checked the data from 57/58 to 58/59 and after
>> confirming , everything is fine .. I tried to change 57/58 as the
>> slave
>> of 59 and 60 as the slave of 59 .
>>
>> Till then , I have been getting the following errors ..which I could
>> not resolve.
>> I googled a lot ..but couldn't get the solution ..
>> Help in this regard is highly requested.
>>
>> Thanks,
>> Umapathi.
>>
>>
>>
>> 1) Cluster to Cluster :
>>
>> mysql> show slave status \G
>> *************************** 1. row ***************************
>> Slave_IO_State: Waiting for
> master to send event
>> Master_Host:
> 10.10.90.59
>> Master_User: repl
>> Master_Port: 3306
>> Connect_Retry: 60
>> Master_Log_File:
> mysql-log-bin.000021
>> Read_Master_Log_Pos: 43898958
>> Relay_Log_File:
> houdb02-relay-bin.000002
>> Relay_Log_Pos: 15409
>> Relay_Master_Log_File: mysql-log-bin.000021
>> Slave_IO_Running: Yes
>> Slave_SQL_Running: No
>> Replicate_Do_DB:
>> Replicate_Ignore_DB:
>> Replicate_Do_Table:
>> Replicate_Ignore_Table:
>> Replicate_Wild_Do_Table:
>> Replicate_Wild_Ignore_Table:
>> Last_Errno: 1032
>> Last_Error: Could
> not execute Update_rows event on
>> table usi.user_cookie; Can't find record in 'user_cookie', Error_code:
>> 1032; handler error HA_ERR_END_OF_FILE; the event's master log
>> mysql-log-bin.000021, end_log_pos 37018579
>> Skip_Counter: 0
>> Exec_Master_Log_Pos: 37018123
>> Relay_Log_Space: 6896407
>> 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: NULL
>> Master_SSL_Verify_Server_Cert: No
>> Last_IO_Errno: 0
>> Last_IO_Error:
>> Last_SQL_Errno: 1032
>> Last_SQL_Error: Could not
> execute Update_rows event on
>> table usi.user_cookie; Can't find record in 'user_cookie', Error_code:
>> 1032; handler error HA_ERR_END_OF_FILE; the event's master log
>> mysql-log-bin.000021, end_log_pos 37018579
>> Replicate_Ignore_Server_Ids:
>> Master_Server_Id: 59
>> Master_Bind:
>> 1 row in set (0.00 sec)
>>
>> 2) Cluster to Non Cluster :
>>
>> root@localhost[Wed May 9 22:57:04 2012][usi]> show slave status \G
>> *************************** 1. row ***************************
>> Slave_IO_State: Waiting for
> master to send event
>> Master_Host:
> 10.10.90.59
>> Master_User: repl
>> Master_Port: 3306
>> Connect_Retry: 60
>> Master_Log_File:
> mysql-log-bin.000021
>> Read_Master_Log_Pos: 115898426
>> Relay_Log_File:
> houdb04-relay-bin.000002
>> Relay_Log_Pos: 262
>> Relay_Master_Log_File: mysql-log-bin.000019
>> Slave_IO_Running: Yes
>> Slave_SQL_Running: No
>> Replicate_Do_DB:
>> Replicate_Ignore_DB:
>> Replicate_Do_Table:
>> Replicate_Ignore_Table:
>> Replicate_Wild_Do_Table:
>> Replicate_Wild_Ignore_Table:
>> Last_Errno: 1594
>> Last_Error: Relay
> log read failure: Could not parse
>> relay log event entry. The possible reasons are: the master's binary
>> log is corrupted (you can check this by running 'mysqlbinlog' on the
>> binary log), the slave's relay log is corrupted (you can check this by
>> running 'mysqlbinlog' on the relay log), a network problem, or a bug
>> in the master's or slave's MySQL code. If you want to check the
>> master's binary log or slave's relay log, you will be able to know
>> their names by issuing 'SHOW SLAVE STATUS' on this slave.
>> Skip_Counter: 0
>> Exec_Master_Log_Pos: 112
>> Relay_Log_Space: 118227567
>> 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: NULL
>> Master_SSL_Verify_Server_Cert: No
>> Last_IO_Errno: 0
>> Last_IO_Error:
>> Last_SQL_Errno: 1594
>> Last_SQL_Error: Relay log read
> failure: Could not parse
>> relay log event entry. The possible reasons are: the master's binary
>> log is corrupted (you can check this by running 'mysqlbinlog' on the
>> binary log), the slave's relay log is corrupted (you can check this by
>> running 'mysqlbinlog' on the relay log), a network problem, or a bug
>> in the master's or slave's MySQL code. If you want to check the
>> master's binary log or slave's relay log, you will be able to know
>> their names by issuing 'SHOW SLAVE STATUS' on this slave.
>> Replicate_Ignore_Server_Ids:
>> Master_Server_Id: 59
>> 1 row in set (0.00 sec)
>>
>> --
>> MySQL Cluster Mailing List
>> For list archives: http://lists.mysql.com/cluster
>> To unsubscribe: http://lists.mysql.com/cluster
>>
>
>
>
> --
> 谭俊青(Ivan)
> Blog: http://www.mysqlab.net/blog/
> +86-l86-2l-586-587 (Shanghai)
> +1-5l8-7l2-988l (New York)
