The incident lost_events occured on the master. Message:error writing to the binary log, Error_code

Source: Internet
Author: User

1 mysq error log errors such as the following:

2014-05-12 11:29:54 22977 [ERROR] Slave SQL: The incident lost_events occured on the master. Message:error writing to the binary log, error_code:1590
2014-05-12 11:29:54 22977 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "Slave START". We stopped at log ' mysql-bin.010275 ' position 91642


2 login MySQL from library, check slave status

Mysql> Show slave status\g*************************** 1. Row *************************** slave_io_state:waiting for master to send event Master_hos              t:10.2xx.3.xx Master_user:repl master_port:3306 connect_retry:60 master_log_file:mysql-bin.010298 read_master_log_pos:67843 Relay_log_file:mysql-relay-b  in.003125 relay_log_pos:91805 relay_master_log_file:mysql-bin.010275 slave_io_running: Yes Slave_sql_running:no Replicate_do_db:business_db,user_db,plocc_system Replicate_ig Nore_DB:Replicate_Do_Table:Replicate_Ignore_Table:Replicate_Wild_Do_Table:Replicate_Wild_Ign ore_table:last_errno:1590 last_error:the incident Lost_events occured on the Maste R. message:error writing to the binary log skip_counter:0 Exec_master_log_pos:91642 relay_log_space:2420882 Until_condition:none Until_log _file:until_log_pos:0 Master_ssl_allowed:no master_ssl_ca_file:master_s SL_CA_Path:Master_SSL_Cert:Master_SSL_Cipher:Master_SSL_Key:Seconds_B                Ehind_Master:NULLMaster_SSL_Verify_Server_Cert:No last_io_errno:0 Last_io_error: last_sql_errno:1590 last_sql_error:the incident Lost_events occured on the master.                  Message:error writing to the binary log replicate_ignore_server_ids:master_server_id:71                    master_uuid:9b0dcf62-29f4-11e3-9471-677b33903869 Master_Info_File:mysql.slave_master_info                  sql_delay:0 Sql_remaining_delay:null slave_sql_running_state:master_retry_count:86400 Master_bind:last_io_error_timestamp:last_sql_error_timestamp:140512 11:29:54 Master_ssl_crl:master_ssl_crlpath: Retrieved_gtid_set:executed_gtid_set:auto_position:01 row in Set (0.00 sec) mysq  L>
From here, copy down.


3. Google has a lot of information, most of the MySQL cluster now, everyone's practice is from the new library. or change to a master access point.

Time is urgent, I can only build from the new library. Leave this record here, assuming that a friend sees here, a different way of solving it. Very welcome message or send email to [email protected]


The incident lost_events occured on the master. Message:error writing to the binary log, Error_code

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.