mysql: [Warning] Using a password on the command line interface can be insecure.

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is

Server version: 5.7.-log MySQL Community Server (GPL)

Copyright (c) , , Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show slave status\G;

*************************** . row ***************************

               Slave_IO_State: Waiting for master to send event

                  Master_Host: 10.2.86.107

                  Master_User: replication

                  Master_Port:

                Connect_Retry:

              Master_Log_File: mysql-bin.

          Read_Master_Log_Pos:

               Relay_Log_File: mysqlbackup-relay-bin.

                Relay_Log_Pos:

        Relay_Master_Log_File: mysql-bin.

             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:

                   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:

          Exec_Master_Log_Pos:

              Relay_Log_Space:

              Until_Condition: None

               Until_Log_File:

                Until_Log_Pos:

           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:

                Last_IO_Error:

               Last_SQL_Errno:

               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:

                  Master_UUID: 09ec7145--11e9-9be2-0050568d4cd5

             Master_Info_File: /usr/local/mysql/mysqldata/data3/master.info

                    SQL_Delay:

          SQL_Remaining_Delay: NULL

      Slave_SQL_Running_State:

           Master_Retry_Count:

                  Master_Bind:

      Last_IO_Error_Timestamp:

     Last_SQL_Error_Timestamp:  ::

               Master_SSL_Crl:

           Master_SSL_Crlpath:

           Retrieved_Gtid_Set:

            Executed_Gtid_Set: 1f450d13-b612-11e6-9aed-0050568d7852:-

                Auto_Position:

         Replicate_Rewrite_DB:

                 Channel_Name:

           Master_TLS_Version:

 row in set (0.00 sec)

ERROR:

No query specified

mysql> stop slave;

Query OK,  rows affected (0.02 sec)

mysql> change master to master_log_file='mysql-bin.000480' , master_log_pos=;

Query OK,  rows affected (0.28 sec)

mysql> start slave;

Query OK,  rows affected (0.00 sec)

mysql> show slave status\G;

*************************** . row ***************************

               Slave_IO_State: Waiting for master to send event

                  Master_Host: 10.2.86.107

                  Master_User: replication

                  Master_Port:

                Connect_Retry:

              Master_Log_File: mysql-bin.

          Read_Master_Log_Pos:

               Relay_Log_File: mysqlbackup-relay-bin.

                Relay_Log_Pos:

        Relay_Master_Log_File: mysql-bin.

             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:

                   Last_Error:

                 Skip_Counter:

          Exec_Master_Log_Pos:

              Relay_Log_Space:

              Until_Condition: None

               Until_Log_File:

                Until_Log_Pos:

           Master_SSL_Allowed: No

           Master_SSL_CA_File:

           Master_SSL_CA_Path:

              Master_SSL_Cert:

            Master_SSL_Cipher:

               Master_SSL_Key:

        Seconds_Behind_Master:

Master_SSL_Verify_Server_Cert: No

                Last_IO_Errno:

                Last_IO_Error:

               Last_SQL_Errno:

               Last_SQL_Error:

  Replicate_Ignore_Server_Ids:

             Master_Server_Id:

                  Master_UUID: 09ec7145--11e9-9be2-0050568d4cd5

             Master_Info_File: /usr/local/mysql/mysqldata/data3/master.info

                    SQL_Delay:

          SQL_Remaining_Delay: NULL

      Slave_SQL_Running_State: Reading event from the relay log

           Master_Retry_Count:

                  Master_Bind:

      Last_IO_Error_Timestamp:

     Last_SQL_Error_Timestamp:

               Master_SSL_Crl:

           Master_SSL_Crlpath:

           Retrieved_Gtid_Set:

            Executed_Gtid_Set: 1f450d13-b612-11e6-9aed-0050568d7852:-

                Auto_Position:

         Replicate_Rewrite_DB:

                 Channel_Name:

           Master_TLS_Version:

 row in set (0.00 sec)

ERROR:

No query specified

mysql>