MYSQL5.6，php5.3环境下 事务问题，恳请解答下

Question

begin事务

update操作：
2017-11-09T18:04:56+08:00 INFO (6): CLIENT:10.36.4.102 DATE:2017-11-09 FILE:/DATA/WWW/LIBRARY/ZEND/DB/ADAPTER/ABSTRACT.PHP LINE:668 MODULE:product CONTROLLER:saveaudit ACTION:maiyang MESSAGES:{"sql":"UPDATE p_product_maiyang_sku_audit_image SET audit_user = ?, audit_status = ?, audit_time = ?, shoot_user = ?, shoot_start_time = ?, shoot_end_time = ?, other_audit_user = ?, ps_user = ?, ps_start_time = ?, ps_end_time = ?, model_dress_size = ? WHERE (goods_sn = '236166707')","bind":{"audit_user":"fengshanshan","audit_status":4,"audit_time":"2017-11-09 18:04:56","shoot_user":"","shoot_start_time":"0000-00-00 00:00:00","shoot_end_time":"0000-00-00 00:00:00","other_audit_user":"u51afu73cau73ca","ps_user":"zhangxiaoying","ps_start_time":"2017-11-09 11:53:30","ps_end_time":"2017-11-09 17:53:47","model_dress_size":""}}

update 完 select 结果 写文件记录：
2017-11-09T18:04:56+08:00 INFO (6): CLIENT:10.36.4.102 DATE:2017-11-09 FILE:/DATA/WWW/APPS/PRODUCT/CONTROLLERS/MAIYANGCONTROLLER.PHP LINE:727 MODULE:product CONTROLLER:saveaudit ACTION:maiyang MESSAGES:{"id":"658202","goods_sn":"236166707","audit_status":"4"}

update 完 select 结果 写文件记录：
2017-11-09T18:05:01+08:00 INFO (6): CLIENT:10.36.4.102 DATE:2017-11-09 FILE:/DATA/WWW/APPS/PRODUCT/CONTROLLERS/MAIYANGCONTROLLER.PHP LINE:845 MODULE:product CONTROLLER:saveaudit ACTION:maiyang MESSAGES:[{"id":"658201","goods_sn":"236166706","audit_status":"10"},{"id":"658202","goods_sn":"236166707","audit_status":"10"},{"id":"658203","goods_sn":"236166708","audit_status":"4"},{"id":"658204","goods_sn":"236166709","audit_status":"4"},{"id":"658205","goods_sn":"236166710","audit_status":"4"}]

commit事务

commit 完 select 结果写文件记录：

2017-11-09T18:05:01+08:00 INFO (6): CLIENT:10.36.4.102 DATE:2017-11-09 FILE:/DATA/WWW/APPS/PRODUCT/CONTROLLERS/MAIYANGCONTROLLER.PHP LINE:852 MODULE:product CONTROLLER:saveaudit ACTION:maiyang MESSAGES:[{"id":"658201","goods_sn":"236166706","audit_status":"10"},{"id":"658202","goods_sn":"236166707","audit_status":"10"},{"id":"658203","goods_sn":"236166708","audit_status":"4"},{"id":"658204","goods_sn":"236166709","audit_status":"4"},{"id":"658205","goods_sn":"236166710","audit_status":"4"}]

bug描述：同一个事务处理 update操作： 236166706;236166707;236166708;236166709;236166710 5个sku，其中 236166708;236166709;236166710 update成功 ,236166706;236166707 update失败，以上是 236166707 sku 的日志记录，根据代码写文件顺序整理出来的。事务有TRY CATCH 捕获异常，页面提醒用户操作成功，但实际数据 236166706;236166707 未更新。从未遇见此类问题，暂时无发定位问题，业务代码PHP5.3的版本。

Answer 1

看一下两个数据表引擎是不是一样的