The binlog analysis administrator is inexplicably deleted _ MySQL

The binlog analysis administrator is inexplicably deleted. bitsCN.com

The administrator is inexplicably deleted based on the bin log analysis.

================= The administrator is inexplicably deleted based on the bin log analysis.

# 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

/*! */;

You can see the SQL operation in the context of DELETE FROM admin WHERE id = 62, DELETE FROM corp_db WHERE corp_id = 62

It should have caused a bug in the delete from admin code when deleting the company.

BitsCN.com