MYSQL5.6，php5.3環(huán)境下 事務(wù)問題，懇請解答下

begin事務(wù)

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 結(jié)果 寫文件記錄：
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 結(jié)果 寫文件記錄：
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事務(wù)

commit 完 select 結(jié)果寫文件記錄：

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描述：同一個(gè)事務(wù)處理 update操作： 236166706;236166707;236166708;236166709;236166710 5個(gè)sku，其中 236166708;236166709;236166710 update成功 ,236166706;236166707 update失敗，以上是 236166707 sku 的日志記錄，根據(jù)代碼寫文件順序整理出來的。事務(wù)有TRY CATCH 捕獲異常，頁面提醒用戶操作成功，但實(shí)際數(shù)據(jù) 236166706;236166707 未更新。從未遇見此類問題，暫時(shí)無發(fā)定位問題，業(yè)務(wù)代碼PHP5.3的版本。