The Master/Slave node cannot be synchronized because the master disk is full. After the disk is added to the master node and the service is restored, the following error occurs:
Mysql> show slave status \ G;
* *************************** 1. row ***************************
Slave_io_state:
Master_host: 192.168.1.60
Master_user: syncuser
Master_port: 3306
Connect_retry: 60
Master_log_file: mysql-bin.000016
Read_master_log_pos: 1011285945
Relay_log_file: syncuser022-relay-bin.000003
Relay_log_pos: 253
Relay_master_log_file: mysql-bin.000001
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.: 145
Last_error: Error 'table '. /MySQL/proc 'is marked as crashed and shoshould be retried red' on query. default Database: 'imusers '. query: 'drop schema if exists' imusers''
Skip_counter: 0
Exec_master_log_pos: 107
Relay_log_space: 17117426719
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: 1236
Last_io_error: Got fatal error 1236 from master when reading data from binary log: 'binlog truncated in the middle of event; Consider out of disk space on Master; the last event was read from '. /mysql-bin.000016 'at 1011285945, the last byte
Read was read from './mysql-bin.000016' At 1011286016 .'
Last_ SQL _errno: 145
Last_ SQL _error: Error 'table '. /MySQL/proc 'is marked as crashed and shoshould be retried red' on query. default Database: 'imusers '. query: 'drop schema if exists' imusers''
Replicate_ignore_server_ids:
Master_server_id: 60
1 row in SET (0.00 Sec)
Error:
No query specified
Solution:
Solve the exception on the slave machine: 'table'./MySQL/proc' is marked as crashed and shoshould be retried red' on query. Error.
Or
Error 145 (hy000): Table './MySQL/proc' is marked as crashed and shoshould be retried red
Solution
Mysql> repair table mysql. Proc;
+ ------------ + -------- + ---------- +
| Table | op | msg_type | msg_text |
+ ------------ + -------- + ---------- +
| Mysql. Proc | repair | status | OK |
+ ------------ + -------- + ---------- +
Then execute:
Slave stop;
Change master to master_host = '192. 168.1.60 ', master_user = 'syncuser', master_password = 'st @ rhu6kb00k', master_log_file = 'binlog. 100', master_log_pos = 192;
Slave start;
Slave stop;
Reset slave;
Slave start;
Show slave status \ G;
Synchronize with the host again.