MySQL error 1594
ΠΡΠΈΠ²Π΅Ρ,
ΠΡ ΠΈΠ·Π²Π΅ΡΡΠ½ΠΎ Π²ΡΠ΅ΠΌΠ΅ Π² Π΅Π΄ΠΈΠ½ proxmox cluster ΠΌΠΈ ΡΠ΅ ΡΠ»ΡΡΠ²Π° ΡΠ»Π΅Π΄Π½ΠΎΡΠΎ – ΠΏΡΠΈ ΡΠ΅ΡΡΠ°ΡΡΠΈΡΠ°Π½Π΅ Π½Π° MySQL ΡΡΡΠ²ΡΡ ΡΠ°Π±ΠΎΡΠ΅Ρ ΠΊΠ°ΡΠΎ slave, ΡΠ΅ΠΏΠ»ΠΈΠΊΠ°ΡΠΈΡΡΠ° ΡΠΏΠΈΡΠ° Π΄Π° ΡΠ°Π±ΠΎΡΠΈ, ΠΈ Π²ΡΡΡΠ° Π³ΡΠ΅ΡΠΊΠ° : MySQL error 1594.
ΠΠΎΠ»ΠΎΠΆΠ΅Π½ΠΈΠ΅ΡΠΎ ΠΈΠ·Π³Π»Π΅ΠΆΠ΄Π° Π΄ΠΎΠ»Ρ-Π³ΠΎΡΠ΅ ΡΠ°ΠΊΠ° :
Slave_IO_State: Waiting for master to send event Master_Host: 192.168.188.223 Master_User: replicator Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.002046 Read_Master_Log_Pos: 70104169 Relay_Log_File: mysql-relay-bin.001957 Relay_Log_Pos: 243 Relay_Master_Log_File: mysql-bin.004319 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: 70104169 Relay_Log_Space: 983411603 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
ΠΠΎ ΡΠ΅Π³Π° ΡΠ΅ΡΠ°Π²Π°Ρ ΠΏΡΠΎΠ±Π»Π΅ΠΌΠ°, ΠΊΠ°ΡΠΎ dump-Π²Π°Ρ Π±Π°Π·Π°ΡΠ° ΠΎΡ ΠΌΠ°ΡΡΡΡ ΡΡΡΠ²ΡΡΠ° ΠΈ Ρ Π½Π°Π»ΠΈΠ²Π°Ρ Π½Π° Π½ΠΎΠ²ΠΎ ΡΡΡ ΡΡΠΎΡΠ²Π΅ΡΠ½ΠΈΡΠ΅ master_log_file ΠΏΠΎΠ·ΠΈΡΠΈΡ ΠΈ master_log_pos. ΠΠ°Π·Π°ΡΠ° Π½ΠΈ ΠΎΠ±Π°ΡΠ΅ ΡΡΠ°Π½Π° ΠΏΡΠ΅ΠΊΠ°Π»Π΅Π½ΠΎ Π³ΠΎΠ»ΡΠΌΠ°, ΠΈ ΠΏΠΎΠ΄ΠΎΠ±Π΅Π½ dump Π·Π°ΠΏΠΎΡΠ½Π° Π΄Π° ΠΎΡΠ½Π΅ΠΌΠ° ΠΌΠ½ΠΎΠ³ΠΎ Π²ΡΠ΅ΠΌΠ΅. ΠΠ° ΡΠΎΠ²Π° ΡΠ΅ Π½Π°Π»ΠΎΠΆΠΈ Π΄Π° Π½Π°ΠΌΠ΅ΡΠΈΠΌ Π°Π»ΡΠ΅ΡΠ½Π°ΡΠΈΠ²Π΅Π½ Π½Π°ΡΠΈΠ½ Π·Π° ΡΠ°Π·ΡΠ΅ΡΠ°Π²Π°Π½Π΅ Π½Π° ΡΠΎΠ·ΠΈ ΠΏΡΠΎΠ±Π»Π΅ΠΌ.
ΠΡΠΎ ΠΈ Π½Π°ΡΠΈΠ½Π°!
ΠΠ° ΡΠ΅Π»ΡΠ° Π΅ Π½ΡΠΆΠ½Π° ΡΠ»Π΅Π΄Π½Π°ΡΠ° ΠΈΠ½ΡΠΎΡΠΌΠ°ΡΠΈΡ ΠΎΡ:
show slave status \G;
Exec_Master_Log_Pos: 70104169 Relay_Master_Log_File: mysql-bin.004319
ΠΠ°ΠΏΡΠ°ΠΊΡΠΈΠΊΠ° ΡΠΎΠ²Π° ΡΠ° ΠΏΠΎΡΠ»Π΅Π΄Π½ΠΈΡΠ΅ Π°ΠΊΡΡΠ°Π»Π½ΠΈ Π΄Π°Π½Π½ΠΈ ΠΎΡ ΠΌΠ°ΡΡΡΡ ΡΡΡΠ²ΡΡΠ° Π½ΠΈ, ΠΏΡΠ΅Π΄ΠΈ ΡΠ»Π΅ΠΉΠ²Π° Π½ΠΈ Π΄Π° ΡΠΏΡΠ΅ Π΄Π° ΡΠ΅ΠΏΠ»ΠΈΠΊΠΈΡΠ°.
ΠΠ° Π΄Π° ΠΎΠΏΡΠ°Π²ΠΈΠΌ ΠΏΡΠΎΠ±Π»Π΅ΠΌΠ° ΠΏΠΈΡΠ΅ΠΌΒ ΡΠ»Π΅Π΄Π½ΠΎΡΠΎ Π½Π° ΡΠ»Π΅ΠΉΠ²-Π° :
stop slave; reset slave; change master to master_log_file='mysql-bin.004319', master_log_pos= 70104169; start slave;
Π Π±Π»Π°Π³ΠΎΠ΄Π°ΡΠ΅Π½ΠΈΠ΅ Π½Π° mytop ΠΌΠΎΠΆΠ΅ΠΌ Π΄Π° Π½Π°Π±Π»ΡΠ΄Π°Π²Π°ΠΌΠ΅ Π² ΡΠ΅Π°Π»Π½ΠΎ Π²ΡΠ΅ΠΌΠ΅ ΠΊΠ°ΠΊ Π²ΡΡΠ²ΠΈ ΡΠΈΠ½Ρ ΡΠΎΠ½ΠΈΠ·Π°ΡΠΈΡΡΠ° Π½Π° MySQL ΡΡΡΠ²ΡΡΠ° Π½ΠΈ. Π‘Π»Π΅Π΄ ΠΊΠ°ΡΠΎ ΡΠ΅ Π½Π°ΡΡΠΈΠ³Π½Π΅ Ρ ΠΌΠ°ΡΡΡΡ-Π° Π²Π΅ΡΠ΅ Π²ΡΠΈΡΠΊΠΎ ΡΡΡΠ±Π²Π° Π΄Π° Π΅ ΠΎΠΊ!
Π’ΠΎΠ²Π° Π΅! π