Details

    • Type: Task
    • Status: Closed
    • Priority: Major
    • Resolution: Duplicate
    • Fix Version/s: N/A
    • Component/s: None
    • 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

        Gliffy Diagrams

          Attachments

            Activity

            Hide
            elenst Elena Stepanova added a comment -

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

            Show
            elenst Elena Stepanova added a comment - Which MariaDB version are you using? It should be fixed in 10.0.13 ( MDEV-6364 ).
            Hide
            jwang james wang added a comment -

            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:

            Show
            jwang james wang added a comment - 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:
            Hide
            jwang james wang added a comment -

            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

            Show
            jwang james wang added a comment - 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
            Hide
            elenst Elena Stepanova added a comment -

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

            Show
            elenst Elena Stepanova added a comment - It looks like MDEV-5151 , also fixed in 10.0.13.
            Hide
            jwang james wang added a comment -

            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

            Show
            jwang james wang added a comment - 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
            Hide
            elenst Elena Stepanova added a comment -

            Duplicate of MDEV-6364 and MDEV-5151.

            Show
            elenst Elena Stepanova added a comment - Duplicate of MDEV-6364 and MDEV-5151 .

              People

              • Assignee:
                Unassigned
                Reporter:
                jwang james wang
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: