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 error:

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
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-bin1_10275 'position 91642


2. log on to the mysql slave database and check the slave status.

mysql> show slave status\G*************************** 1. row ***************************               Slave_IO_State: Waiting for master to send event                  Master_Host: 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-bin.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_Ignore_DB:            Replicate_Do_Table:        Replicate_Ignore_Table:       Replicate_Wild_Do_Table:   Replicate_Wild_Ignore_Table:                    Last_Errno: 1590                   Last_Error: The incident LOST_EVENTS occured on the master. 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_SSL_CA_Path:               Master_SSL_Cert:             Master_SSL_Cipher:                Master_SSL_Key:         Seconds_Behind_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)mysql> 
It can be seen from this that the copy is down.


3. google has a lot of information, most of which appear in mysql cluster. Everyone's approach is to create a slave database or change the master Access Point.

Time urgent, I can only re-build from the library, leave this record here, if a friend sees this, there are other solutions, very welcome to leave a message or send an email to the mchdba@tom.com


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.