Master强行重启后的同步故障

从DB的ERROR日志：

080519 23:41:26 [ERROR] Slave I/O thread killed during or after a reconnect done to recover from failed read
080519 23:41:26 [ERROR] Slave I/O thread exiting, read up to log 'UE-us90-bin.000099', position 582469747
080519 23:41:26 [ERROR] Error reading relay log event: slave SQL thread was killed
080519 23:59:13 [Note] Slave I/O thread: connected to master ,  replication started in log 'UE-us90-bin.000099' at position 582469747
080519 23:59:13 [Note] Slave SQL thread initialized, starting replication in log 'UE-us90-bin.000099' at position 582469747, relay log './UE-US11-relay-bin.000092' position: 496342737
080519 23:59:13 [ERROR] Slave: Query partially completed on the master (error on master: 1053) and was aborted. There is a chance that your master is inconsistent at this point. If you are sure that your master is ok, run this query manually on the slave and then restart the slave with SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; START SLAVE; . Query: 'update store_realm set goldnum = '0', ctoc_goldnum = '10427', preorder_goldnum = '0' where serverarea=8 and servername='Eonar' and faction=1', Error_code: 1053
080519 23:59:13 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'UE-us90-bin.000099' position 582469747

照提示执行后，仍然出错为：

080520  0:00:17 [Note] Slave SQL thread initialized, starting replication in log 'UE-us90-bin.000099' at position 582469747, relay log './UE-US11-relay-bin.000092' position: 496342782
080520  0:00:17 [ERROR] Slave: Query partially completed on the master (error on master: 1053) and was aborted. There is a chance that your master is inconsistent at this point. If you are sure that your master is ok, run this query manually on the slave and then restart the slave with SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; START SLAVE; . Query: 'UPDATE `orders` SET  `country` = 'us', `v_oid` = '2008-05-19-5358-10077936', `studio_id` = '217', `game_area` = 'æ— ', `game_server` = 'Shandris', `game_race` = 'Dwarf', `game_role` = 'Sinjr', `game_user` = '667max', `game_pass` = '9431759912648401132108010695585792 400080949836310016000',
080520  0:00:17 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'UE-us90-bin.000099' position 582470130

 

检查主DB，发现每个记录后的error_code=1053，正常情况下为error_code=0. 判断可能是由强行关闭DB所致(server mysqld stop,因mysqladmin shutdown无效)。

# at 582469747
#080519 23:27:49 server id 11  log_pos 582469747        Query   thread_id=48223301      exec_time=1262  error_code=1053
SET TIMESTAMP=1211264869;
update store_realm set goldnum = '0', ctoc_goldnum = '10427', preorder_goldnum = '0' where serverarea=8 and servername='Eonar' and faction=1;
# at 582469925
#080519 23:27:56 server id 11  log_pos 582469925        Query   thread_id=48223649      exec_time=1255  error_code=1053
use gwmine;
SET TIMESTAMP=1211264876;
update osc_order_m a,osc_order_s b set b.OnlineAccountNO='616940702374726',b.PayType='google_checkout' where a.ID=b.OrderID and a.ID='470468' and a.OrderKey='001841659';
# at 582470130
#080519 23:28:09 server id 11  log_pos 582470130        Query   thread_id=48223690      exec_time=1242  error_code=1053
use roster;
SET TIMESTAMP=1211264889;
UPDATE `orders` SET  `country` = 'us', `v_oid` = '2008-05-19-5358-10077936', `studio_id` = '217', `game_area` = '无', `game_server` = 'Shandris', `game_race` = 'Dwarf', `game_role` = 'Sinjr', `game_user` = '667max', `game_pass` = '9431759912648401132108010695585792 400080949836310016000', `game_pin` = '', `protect_card` = '', `game_class` = 'Palalin', `price` = '11.00', `telphone` = '', `qq` = '', `msn` = '', `email` = , `card_money` = '0.00', `card_num` = '0', `is_recharge` = '0', `c_payment` = 'yes', `c_chargeback` = 'no', `a_payment` = 'no', `a_entrust` = 'yes', `s_gathering` = 'no', `s_inwork` = 'yes', `finish` = 'yes', `finish_confirm` = 'yes', `c_order_time` = '2008-05-19 12:18:13', `c_payment_time` = '2008-05-20 04:19:23', `c_chargeback_time` = '2000-00-00 00:00:00', `a_payment_time` = '2000-00-00 00:00:00', `s_gathering_time` = '0000-00-00 00:00:00', `finish_time` = '2008-05-20 14:24:23', `finish_confirm_time` = '2008-05-20 14:27:39', `game_new_pass` = '13320250958633983292810581589340009 10018214836622', `remark` = '', `a_send` = 'yes', `s_accept` = 'yes', `a_send_time` = '2008-05-20 03:55:32', `s_accept_time` = '0000-00-00 00:00:00', `charge_time` = '0000-00-00 00:00:00', `pl_start` = '37级', `pl_end` = '40级', `pl_time` = '1440', `pl_place` = '', `pl_c_require_stime` = '2008-05-19 16:00:00', `pl_s_require_stime` = '2008-05-19 16:00:00', `pl_s_require_etime` = '2008-05-20 16:00:00', `pl_s_evalation_level` = '1', `pl_s_evalation` = '0', `s_inwork_time` = '2008-05-20 04:53:41', `entrust_remark` = '无', `pl_type` = 'level', `pl_queue` = 'yes', `pl_s_time` = '24', `pl_c_require_etime` = '0000-00-00 00:00:00', `pl_s_price` = '75.00', `pl_s_foregift` = '0.00', `s_pledge` = 'yes', `s_pledge_time` = '2008-05-20 03:56:43', `a_entrust_time` = '2008-05-20 04:02:58', `isdelete` = '0', `timezoneoffset` = '-5', `dst` = '0', `customer_cookie` = 'b84b97f43ffe8db72e8eced569b78047', `customer_ip` = '71.249.21.81', `payment_type` = '4', `special_state` = '', `staff_name` = '张杰', `followName` = '', `other_payment` = '';

google搜到一个方案，

 

在配置文件中加skip-slave-error=1053 (which can be used on
your slave but that is scary)