bitscn.com
根据bin log分析管理员被莫名删除问题
============== 根据bin log 分析管理员被莫名删除问题
# at 88572251
#120907  7:45:34 server id 1  end_log_pos 88572346      query   thread_id=32426664      exec_time=0     error_code=0
set timestamp=1346975134/*!*/;
delete from admin where id=62 
/*!*/;
# at 88572346
#120907  7:45:34 server id 1  end_log_pos 88572418      query   thread_id=32426664      exec_time=0     error_code=0
set timestamp=1346975134/*!*/;
commit
/*!*/;
# at 88572418    
#120907  7:45:34 server id 1  end_log_pos 88572489      query   thread_id=32426664      exec_time=0     error_code=0
set timestamp=1346975134/*!*/;
begin
/*!*/;
# at 88572489
#120907  7:45:34 server id 1  end_log_pos 88572591      query   thread_id=32426664      exec_time=0     error_code=0
set timestamp=1346975134/*!*/;
delete from corp_db where corp_id=62 
/*!*/;
# at 88572591
#120907  7:45:34 server id 1  end_log_pos 88572618      xid = 132059217
commit/*!*/;
# at 88572618
#120907  7:45:34 server id 1  end_log_pos 88572689      query   thread_id=32426664      exec_time=0     error_code=0
set timestamp=1346975134/*!*/;
begin
/*!*/;
可以看到delete from admin where id=62的上下文的sql操作，delete from corp_db where corp_id=62
应该是删除公司的时候引起了delete from admin 的代码上的bug.
bitscn.com