[MDEV-6585] Migrate from Percona Created: 2014-08-14  Updated: 2014-08-14  Resolved: 2014-08-14

Status: Closed
Project: MariaDB Server
Component/s: None
Fix Version/s: N/A

Type: Task Priority: Major
Reporter: james wang Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: None


 Description   

Hi,

I rsync data from a Percona Mysql (5.6).

And replication showed the following error:

Failed to open the relay log '7' (relay_log_pos 0)
140814 15:32:02 [ERROR] Could not find target log during relay log initialization
ERROR 1201 (HY000): Could not initialize master info structure for ''; more error messages can be found in the MariaDB error log

Please help.

Thanks a lot in advance

 Comments   
Comment by Elena Stepanova [ 2014-08-14 ]

Which MariaDB version are you using? It should be fixed in 10.0.13 (MDEV-6364).

Comment by james wang [ 2014-08-14 ]

Master_User: replication
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.004703
Read_Master_Log_Pos: 172380344
Relay_Log_File: 7
Relay_Log_Pos: 0
Relay_Master_Log_File: 172380503
Slave_IO_Running: No
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: 0
Last_Error:
Skip_Counter: 0
Exec_Master_Log_Pos: 0
Relay_Log_Space: 0
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: 0
Last_SQL_Error:
Replicate_Ignore_Server_Ids:
Master_Server_Id: 0
Master_SSL_Crl:
Master_SSL_Crlpath:
Using_Gtid: No
Gtid_IO_Pos:

Comment by james wang [ 2014-08-14 ]

10.0.12

we fixed the replication issue.

however, we have new error message:
2014-08-14 16:42:15 7fc468ff7700 InnoDB: Recalculation of persistent statistics requested for table tableName but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
2014-08-14 16:42:21 7fc468ff7700 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is BINARY(4) NOT NULL but should be INT NOT NULL (type mismatch).

please shed some light to fix the above error.

thanks a lot in advance

Comment by Elena Stepanova [ 2014-08-14 ]

It looks like MDEV-5151, also fixed in 10.0.13.

Comment by james wang [ 2014-08-14 ]

thanks a lot. shall upgrade to 10.0.13 soon

please close this ticket and i shall re-open if 10.0.13 does not fix this.

thanks a lot indeed

Comment by Elena Stepanova [ 2014-08-14 ]

Duplicate of MDEV-6364 and MDEV-5151.

Generated at Thu Feb 08 07:13:02 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.