[Frubar Paste] Hosted by SkyLime - Chat with us at XChannel IRC

Posted by pent1ckel on Mon 13th Aug 20:48
download

  1. *************************** 1. row ***************************
  2.                Slave_IO_State: Waiting for master to send event
  3.                   Master_Host: 127.0.0.1
  4.                   Master_User: badeio_repli
  5.                   Master_Port: 63306
  6.                 Connect_Retry: 60
  7.               Master_Log_File: mysql-bin.000020
  8.           Read_Master_Log_Pos: 2324778
  9.                Relay_Log_File: mysqld-relay-bin.000059
  10.                 Relay_Log_Pos: 378
  11.         Relay_Master_Log_File: mysql-bin.000014
  12.              Slave_IO_Running: Yes
  13.             Slave_SQL_Running: No
  14.               Replicate_Do_DB:
  15.           Replicate_Ignore_DB: mysql,phpmyadmin
  16.            Replicate_Do_Table:
  17.        Replicate_Ignore_Table:
  18.       Replicate_Wild_Do_Table:
  19.   Replicate_Wild_Ignore_Table:
  20.                    Last_Errno: 1594
  21.                    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.
  22.                  Skip_Counter: 1
  23.           Exec_Master_Log_Pos: 24133697
  24.               Relay_Log_Space: 20011742
  25.               Until_Condition: None
  26.                Until_Log_File:
  27.                 Until_Log_Pos: 0
  28.            Master_SSL_Allowed: No
  29.            Master_SSL_CA_File:
  30.            Master_SSL_CA_Path:
  31.               Master_SSL_Cert:
  32.             Master_SSL_Cipher:
  33.                Master_SSL_Key:
  34.         Seconds_Behind_Master: NULL
  35. Master_SSL_Verify_Server_Cert: No
  36.                 Last_IO_Errno: 0
  37.                 Last_IO_Error:
  38.                Last_SQL_Errno: 1594
  39.                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.
  40. 1 row in set (0.00 sec)
  41.  
  42. ERROR:
  43. No query specified


Submit a correction or amendment below. (click here to make a fresh posting)
After submitting an amendment, you'll be able to view the differences between the old and new posts easily.



Remember my name in a cookie


Code: To highlight particular lines, prefix each line with @@.
Include comments to indicate what you need feedback on.