Community Learn Tools Library Leisure
search
English
Home > Database > Mysql Tutorial > mysql事务rollback失效_MySQL

mysql事务rollback失效_MySQL

WBOY
Release： 2016-06-01 13:02:41
Original
2283 people have browsed it

最近支付业务发生了一件怪事，在一个事务 失败后，调用rollback，发现只rollback 了最后一条sql。

开发查了很久，发现是网络抖动，造成第一次创建链接的 begin 丢掉了，后面再重连后就变成autocommit了，这样就造成rollback的时候前面的sql 全都没有rollback。

tudou@b2c.xiaomi.com

只能是在 begin 的时候加一个变量将应用服务器的时间戳打到mysql 服务器上，后面所有操作都去读下这个时间戳，和应用服务器上的时间戳一致，就ok，否则就重做。效率差了很多，但是保证了事务。

tudou@b2c.xiaomi.com

其他同学有什么好办法么？

Related labels：
affairs
source：php.cn
Previous article：mysql常用命令整理总结_MySQL Next article：mysql多日志表结果集合拼接存储过程_MySQL
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
Can a workerpool declared in multiple routes still maintain its cpu usage without caring about the threshold I'm hoping to find a node.js system with a workerpool to handle CPU intensive tasks, but I...
From 2024-04-06 19:54:23
0
1
444
In mobile view, how can I close this navigation bar when the user clicks on the link? When the user clicks a link to browse the website, the navigation bar does not close? I've...
From 2024-04-06 19:23:03
0
1
411
CSS styles not applied to site I'm making a website using Bootstrap5 but the index.css properties are not being applied t...
From 2024-04-06 17:12:23
0
1
336
JavaScript hover events on vendor-specific pseudo-elements I have the following htmlinput tag. $("input[type='range']::-webkit-slider-thumb"...
From 2024-04-06 15:35:24
0
1
274
CSS bottom border on navigation bar I have a navigation bar and I have added a red line at the bottom when any item in the lis...
From 2024-04-06 15:04:41
0
2
347
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template