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