The master disk of the MySQL host is full, which prevents synchronization of Master/Slave Data.

Source: Internet
Author: User
Tags mysql host

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.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.