<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[more_better的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/more_better</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; more_better]]></copyright><item><title><![CDATA[web端微信授权登录处理(同适用于H5)]]></title><link>https://blog.youkuaiyun.com/more_better/article/details/137918833</link><guid>https://blog.youkuaiyun.com/more_better/article/details/137918833</guid><author>more_better</author><pubDate>Thu, 18 Apr 2024 16:26:03 +0800</pubDate><description><![CDATA[微信网页授权文档。]]></description><category></category></item><item><title><![CDATA[并发下单遇到问题记录]]></title><link>https://blog.youkuaiyun.com/more_better/article/details/110704732</link><guid>https://blog.youkuaiyun.com/more_better/article/details/110704732</guid><author>more_better</author><pubDate>Sat, 05 Dec 2020 18:02:51 +0800</pubDate><description><![CDATA[1、问题描述
平台直播时，遇到超买情况，即使事务中查库存加了for update锁，仍然出现超买情况。超买：库存剩余2个，生成订单多于2笔
2、排查问题
（1）并发压测
使用ab工具并发压测
ab -c 100 -n 100 xxx

（2）事务相关报错
记录错误日志有报错，貌似事务不存在
[42000]SQLSTATE[42000]: Syntax error or access violation: 1305 SAVEPOINT trans2 does not exist[/data/www_code/]]></description><category></category></item></channel></rss>