{"id":50648,"date":"2023-02-16T16:07:00","date_gmt":"2023-05-16T02:23:12","guid":{"rendered":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8%e5%ba%94%e7%94%a8%e7%a8%8b%e5%ba%8f%e5%bc%80%e5%8f%91%e4%b8%ad%ef%bc%8c%e6%88%91%e4%bb%ac%e8%a6%81%e6%b7%b1%e5%85%a5%e6%8e%a2%e8%ae%a8%e9%87%8d%e8%a6%81%e7%9a%84%e9%94%81%e5%ae%9a%e9%97%ae\/"},"modified":"2024-04-29T14:52:53","modified_gmt":"2024-04-29T06:52:53","slug":"%e5%9c%a8%e5%ba%94%e7%94%a8%e7%a8%8b%e5%ba%8f%e5%bc%80%e5%8f%91%e4%b8%ad%ef%bc%8c%e6%88%91%e4%bb%ac%e8%a6%81%e6%b7%b1%e5%85%a5%e6%8e%a2%e8%ae%a8%e9%87%8d%e8%a6%81%e7%9a%84%e9%94%81%e5%ae%9a%e9%97%ae","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8%e5%ba%94%e7%94%a8%e7%a8%8b%e5%ba%8f%e5%bc%80%e5%8f%91%e4%b8%ad%ef%bc%8c%e6%88%91%e4%bb%ac%e8%a6%81%e6%b7%b1%e5%85%a5%e6%8e%a2%e8%ae%a8%e9%87%8d%e8%a6%81%e7%9a%84%e9%94%81%e5%ae%9a%e9%97%ae\/","title":{"rendered":"\u5728\u5e94\u7528\u7a0b\u5e8f\u5f00\u53d1\u4e2d\uff0c\u6211\u4eec\u8981\u6df1\u5165\u63a2\u8ba8\u91cd\u8981\u7684\u9501\u5b9a\u95ee\u9898\uff0c\u5e76\u4ecb\u7ecd\u5728ORM\u4e2d\u5b9e\u73b0\u4e50\u89c2\u9501\u7684\u793a\u4f8b"},"content":{"rendered":"<h1>\u5f15\u5165<\/h1>\n<p>\u5728\u5e94\u7528\u7a0b\u5e8f\u5f00\u53d1\u8fc7\u7a0b\u4e2d\uff0c\u5bf9\u6570\u636e\u8fdb\u884c\u52a0\u9501\u662f\u4e3a\u4e86\u4fdd\u8bc1\u6570\u636e\u7684\u5b89\u5168\u6027\u800c\u975e\u5e38\u91cd\u8981\u7684\u3002<\/p>\n<p>\u672c\u6587\u5c06\u6df1\u5165\u8ba8\u8bba\u5e94\u7528\u7a0b\u5e8f\u4e2d\u7684\u201c\u9501\u201d\uff0c\u4ecb\u7ecd\u4e86\u9501\u5b9a\u65b9\u6cd5\u7684\u7c7b\u578b\u4ee5\u53ca\u4e0e\u6570\u636e\u5e93\u4e8b\u52a1\u7684\u5173\u7cfb\u3002<\/p>\n<h1>\u6447\u6eda\u662f\u4e00\u79cd\u97f3\u4e50\u98ce\u683c<\/h1>\n<p>\u9996\u5148\uff0c\u9501\uff08Lock\uff09\u662f\u4e00\u79cd\u673a\u5236\uff0c\u7528\u4e8e\u6392\u9664\u5bf9\u6570\u636e\u540c\u65f6\u8fdb\u884c\u8bfb\u5199\u64cd\u4f5c\u3002<\/p>\n<p>\u5982\u679c\u4e0d\u8fdb\u884c\u9501\u5b9a\uff0c\u5bf9\u4e8e\u76f8\u540c\u7684\u6570\u636e\u8fdb\u884c\u591a\u4e2a\u5904\u7406\u65f6\uff0c\u53ef\u80fd\u4f1a\u5bfc\u81f4\u7ed3\u679c\u4e0d\u4e00\u81f4\u3002<\/p>\n<p>\u5728\u8ba1\u7b97\u5546\u54c1\u5206\u7c7b\u7684\u9500\u552e\u603b\u989d\u7684\u8fc7\u7a0b\u4e2d\uff0c\u5982\u679c\u5546\u54c1\u5206\u7c7b\u53d1\u751f\u53d8\u5316\uff0c\u90a3\u4e48\u6bcf\u4e2a\u5546\u54c1\u5206\u7c7b\u7684\u9500\u552e\u603b\u989d\u5c06\u4e0e\u603b\u9500\u552e\u989d\u4e0d\u540c\u3002<\/p>\n<p>\u901a\u8fc7\u4f7f\u7528\u9501\uff0c\u53ef\u4ee5\u7981\u6b62\u4e00\u4e2a\u5904\u7406\u8fc7\u7a0b\u5728\u53e6\u4e00\u4e2a\u5904\u7406\u8fc7\u7a0b\u5b8c\u6210\u4e4b\u524d\u8fdb\u884c\u8bfb\u5199\u64cd\u4f5c\uff0c\u4ee5\u4fdd\u8bc1\u7ed3\u679c\u7684\u4e00\u81f4\u6027\u3002<\/p>\n<h1>\u6df1\u5165\u63a2\u7a76\u6447\u6eda\u97f3\u4e50<\/h1>\n<p>\u6839\u636e\u7cfb\u7edf\u4e2d\u8fdb\u884c\u9501\u5b9a\u7684\u201c\u54ea\u4e2a\u7ea7\u522b\u201d\uff0c\u9700\u8981\u8003\u8651\u7684\u8981\u70b9\u548c\u53ef\u4ee5\u9501\u5b9a\u7684\u6570\u636e\u5355\u4f4d\u4f1a\u6709\u6240\u4e0d\u540c\u3002\u6211\u4eec\u5c06\u6309\u7167\u6bcf\u4e2a\u7ea7\u522b\u9010\u6b65\u6df1\u5165\u3002<\/p>\n<h2>\u6570\u636e\u5e93\u7ea7\u522b\u7684\u9501\u548c\u5e94\u7528\u7a0b\u5e8f\u7ea7\u522b\u7684\u9501<\/h2>\n<p>DB\u5305\u62ecMySQL\u3001PostgreSQL\u3001Oracle\u3001Microsoft SQL Server\u3001MongoDB\u3001Cassandra\u3001Redis\u7b49\u51e0\u79cd\u7c7b\u578b\uff0c\u4f46\u51e0\u4e4e\u90fd\u5177\u5907\u9501\u5b9a\u529f\u80fd\u3002<\/p>\n<p>\u5728\u4f7f\u7528\u6570\u636e\u5e93\u8fdb\u884c\u9501\u5b9a\u65f6\uff0c\u5177\u4f53\u7684\u884c\u4e3a\u56e0\u6570\u636e\u5e93\u800c\u5f02\u3002\u53ef\u4ee5\u9009\u62e9\u5bf9\u540c\u65f6\u8fdb\u884c\u8bfb\u5199\uff08RW\uff09\u7684\u64cd\u4f5c\u8fdb\u884c\u6392\u9664\u9501\u5b9a\uff0c\u6216\u8005\u53ea\u6392\u9664\u5199\u5165\u64cd\u4f5c\u7684\u9501\u5b9a\u7b49\u3002\u5728\u5173\u7cfb\u578b\u6570\u636e\u5e93\u4e2d\uff0c\u8fd8\u53ef\u4ee5\u9009\u62e9\u5bf9\u8868\u64cd\u4f5c\u8fdb\u884c\u6392\u9664\u9501\u5b9a\uff0c\u6216\u8005\u5bf9\u8bb0\u5f55\u64cd\u4f5c\u8fdb\u884c\u6392\u9664\u9501\u5b9a\u7b49\u3002<\/p>\n<p>\u5728\u5e94\u7528\u7a0b\u5e8f\u4e2d\uff0c\u901a\u8fc7\u4e3a\u591a\u4e2a\u5904\u7406\u8fc7\u7a0b\u8bbe\u5b9a\u5171\u540c\u7684\u89c4\u5219\uff0c\u53ef\u4ee5\u5b9e\u73b0\u9501\u5b9a\u3002\uff08\u5047\u8bbe\u6ca1\u6709\u8fdd\u53cd\u89c4\u5219\u7684\u5904\u7406\uff09<\/p>\n<p>\u6211\u4eec\u53ef\u4ee5\u901a\u8fc7\u5728\u6574\u4e2a\u5e94\u7528\u7a0b\u5e8f\u4e2d\u5171\u4eab\u7684\u5185\u5b58\u7a7a\u95f4\u4e2d\u51c6\u5907\u4e00\u4e2a\u6307\u793a\u9501\u5b9a\u72b6\u6001\u7684\u5e03\u5c14\u53d8\u91cf\uff0c\u5e76\u901a\u8fc7\u8bbe\u5b9a\u4e0b\u5217\u89c4\u5219\u6765\u8fdb\u884c\u9501\u5b9a\u3002<\/p>\n<ol>\u5728\u8fdb\u884c\u5bf9DB\u7684\u8bfb\u5199\u65f6\uff0c\u5fc5\u987b\u59cb\u7ec8\u53c2\u8003\u8be5\u53d8\u91cf\u3002\u5982\u679c\u9501\u5b9a\u72b6\u6001\u4e3afalse\uff0c\u5219\u5c06\u53d8\u91cf\u8bbe\u7f6e\u4e3atrue\uff0c\u5e76\u8fdb\u884c\u5bf9DB\u7684\u8bfb\u5199\u64cd\u4f5c\uff0c\u7ed3\u675f\u540e\u5c06\u53d8\u91cf\u6062\u590d\u4e3afalse\u3002\u5982\u679c\u9501\u5b9a\u72b6\u6001\u4e3atrue\uff0c\u5219\u4e00\u76f4\u7b49\u5f85\u76f4\u5230\u53d8\u91cf\u53d8\u4e3afalse\u3002<\/ol>\n<h2>\u5173\u4e8e\u4ea4\u6613<\/h2>\n<p>\u4e8b\u52a1\u662f\u5c06\u5bf9\u6570\u636e\u5e93\u7684\u4e00\u7cfb\u5217\u64cd\u4f5c\u4f5c\u4e3a\u4e00\u4e2a\u5904\u7406\u5355\u5143\u8fdb\u884c\u5904\u7406\u7684\u529f\u80fd\u3002<br \/>\n\u5982\u679c\u5904\u7406\u8fc7\u7a0b\u4e2d\u51fa\u73b0\u5931\u8d25\uff0c\u5c06\u56de\u6eda\u5230\u64cd\u4f5c\u5f00\u59cb\u65f6\u7684\u72b6\u6001\u3002<br \/>\n\u5904\u7406\u5b8c\u6210\u79f0\u4e3a\u63d0\u4ea4\u3002<\/p>\n<p>\u4e3a\u4e86\u786e\u4fdd\u5728\u5e76\u53d1\u4e8b\u52a1\u6267\u884c\u65f6\u64cd\u4f5c\u7684\u4e00\u81f4\u6027\uff0c\u9700\u8981\u4f7f\u7528\u9501\u3002\u5728\u8fd9\u79cd\u60c5\u51b5\u4e0b\uff0c\u51b3\u5b9a\u9501\u5b9a\u54ea\u4e9b\u64cd\u4f5c\u88ab\u79f0\u4e3a\u4e8b\u52a1\u7684\u9694\u79bb\u7ea7\u522b\uff0c\u5e76\u4e14\u6bcf\u4e2a\u6570\u636e\u5e93\u90fd\u63d0\u4f9b\u4e86\u51e0\u79cd\u9694\u79bb\u7ea7\u522b\u3002<\/p>\n<p>\u4e3e\u4f8b\u6765\u8bf4\uff0cMySQL \u7684\u9694\u79bb\u7ea7\u522b\u6709\u4ee5\u4e0b\u51e0\u79cd\u7c7b\u578b\u3002<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">READ UNCOMMITTED<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">READ COMMITTED<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">REPEATABLE READ<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">SERIALIZABLE<\/ul>\n<p>\u6211\u4f1a\u4e3a\u6bcf\u4e00\u4e2a\u7b80\u5355\u89e3\u91ca\u4e00\u4e0b\u3002<\/p>\n<p>\u5982\u679c\u5c06\u9694\u79bb\u7ea7\u522b\u8bbe\u7f6e\u4e3a&#8221;\u8bfb\u53d6\u672a\u63d0\u4ea4&#8221;\uff0c\u90a3\u4e48\u5728\u4e8b\u52a1\u4e2d\u5c31\u53ef\u4ee5\u8bfb\u53d6\u5230\u5df2\u7ecf\u88ab\u6539\u53d8\u4f46\u662f\u8fd8\u672a\u88ab\u63d0\u4ea4\u7684\u503c\u3002<\/p>\n<p>\u5f53\u6267\u884c\u4e86\u4e24\u4e2a\u4e8b\u52a1\u65f6\uff0c\u5982\u679c\u5176\u4e2d\u4e00\u4e2a\u4e8b\u52a1\u8fdb\u884c\u4e86\u503c\u7684\u66f4\u6539\u4f46\u88ab\u56de\u6eda\uff0c\u53e6\u4e00\u4e2a\u4e8b\u52a1\u5219\u53ef\u80fd\u8bfb\u53d6\u5230\u5df2\u66f4\u6539\u7684\u503c\uff0c\u5bfc\u81f4\u7ed3\u679c\u4e0d\u4e00\u81f4\u7684\u53ef\u80fd\u6027\u5b58\u5728\u3002<\/p>\n<p>\u5c06\u5206\u9694\u7ea7\u522b\u8bbe\u7f6e\u4e3a READ COMMITTED\uff0c\u5c06\u4f1a\u8bfb\u53d6\u5df2\u63d0\u4ea4\u7684\u503c\u3002<\/p>\n<p>\u7136\u800c\uff0c\u5982\u679c\u5728\u6267\u884c\u4e24\u4e2a\u4e8b\u52a1\u65f6\uff0c\u4e00\u4e2a\u4e8b\u52a1\u4fee\u6539\u4e86\u503c\uff0c\u800c\u53e6\u4e00\u4e2a\u4e8b\u52a1\u5f15\u7528\u4e86\u76f8\u540c\u7684\u503c\uff0c\u90a3\u4e48\u5f53\u4fee\u6539\u503c\u7684\u4e8b\u52a1\u5b8c\u6210\u540e\uff0c\u53e6\u4e00\u4e2a\u4e8b\u52a1\u5c06\u5f15\u7528\u4fee\u6539\u540e\u7684\u503c\u3002<\/p>\n<p>\u56e0\u6b64\uff0c\u8003\u8651\u5230\u8fdb\u884c\u503c\u7684\u5f15\u7528\u7684\u4e8b\u52a1\u4e00\u65b9\u9762\uff0c\u4ece\u4e8b\u52a1\u7684\u4e2d\u95f4\u8fdb\u884c\u76f8\u540c\u503c\u7684\u8c03\u7528\u5c06\u5bfc\u81f4\u7ed3\u679c\u4e0d\u540c\u3002<\/p>\n<p>\u8bbe\u7f6e\u5206\u79bb\u7ea7\u522b\u4e3aREPEATABLE READ\u540e\uff0c\u65e0\u8bba\u5728\u4e8b\u52a1\u4e2d\u8bfb\u53d6\u503c\u591a\u5c11\u6b21\uff0c\u7ed3\u679c\u90fd\u4fdd\u6301\u4e0d\u53d8\u3002<\/p>\n<p>\u6700\u540e\uff0c\u5c06\u5206\u79bb\u7ea7\u522b\u8bbe\u7f6e\u4e3aSERIALIZABLE\uff0c\u4e8b\u52a1\u5c06\u4e0d\u4f1a\u5e76\u884c\u6267\u884c\uff0c\u800c\u662f\u6309\u987a\u5e8f\u8fdb\u884c\u3002<\/p>\n<h1>\u63d0\u9ad8\u4ea4\u6613\u7cfb\u7edf\u7684\u53ef\u9760\u6027\u7279\u6027<\/h1>\n<p>\u5728\u80fd\u591f\u8fdb\u884c\u4ea4\u6613\u7684\u7cfb\u7edf\u4e2d\uff0c\u4e3a\u4e86\u63d0\u9ad8\u5176\u53ef\u9760\u6027\uff0c\u53ef\u4ee5\u5b9e\u73b0\u4ee5\u4e0b\u7279\u6027\u3002<br \/>\n\u8fd9\u4e9b\u7279\u6027\u5305\u62ec\uff1a\u8868\u793a\u4ea4\u6613\u672c\u8eab\u7279\u6027\u7684ACID\u7279\u6027\u548c\u8868\u793a\u7cfb\u7edf\u81ea\u8eab\u7279\u6027\u7684BASE\u7279\u6027\u3002<\/p>\n<p>\u5f53\u8bd5\u56fe\u4e3a\u7cfb\u7edf\u672c\u8eab\u8d4b\u4e88ACID\u7279\u6027\u65f6\uff0c\u4f1a\u53d1\u751f\u53ef\u7528\u6027\u548c\u6027\u80fd\u7684\u6298\u8877\uff0c\u56e0\u6b64Eric Brewer\u63d0\u51fa\u4e86\u4ee5\u53ef\u7528\u6027\u548c\u6027\u80fd\u4e3a\u91cd\u70b9\u7684BASE\u7279\u6027\u3002 (\u53c2\u8003\u4fe1\u606f http:\/\/yohei-y.blogspot.com\/2009\/03\/cap-base.html)<\/p>\n<p>ACID\u7279\u6027\u548cBASE\u7279\u6027\u53ef\u4ee5\u5171\u5b58\uff0c\u56e0\u6b64\u6570\u636e\u5e93\u53ef\u4ee5\u4fdd\u6301ACID\u7279\u6027\uff0c\u800c\u7cfb\u7edf\u53ef\u4ee5\u9075\u5faaBASE\u7279\u6027\u7684\u914d\u7f6e\u3002<\/p>\n<h2>\u9178\u6027\u7279\u5f81<\/h2>\n<p>ACID\u7279\u6027\u662f\u6307\u4ee5\u4e0b\u56db\u4e2a\u7279\u70b9\u3002<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">\u539f\u5b50\u6027(Atomicity)<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">\u4e00\u8cab\u6027(Consistency)<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">\u72ec\u7acb\u6027(Isolation)<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\u6c38\u7d9a\u6027(Durability)<\/ul>\n<p>\u5bf9\u4e8e\u6bcf\u4e00\u4e2a\uff0c\u7b80\u5355\u5730\u89e3\u91ca\u5982\u4e0b\u3002<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">\u539f\u5b50\u6027\u3068\u306f\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u51e6\u7406\u304c\u4e00\u9023\u306e\u51e6\u7406\u300c\u5168\u3066\u304c\u5b9f\u884c\u3055\u308c\u305f\u300d\u304b\u3001\u3042\u308b\u3044\u306f\u300c\u5168\u3066\u304c\u5b9f\u884c\u3055\u308c\u306a\u304b\u3063\u305f\u300d(\u5b9f\u884c\u524d\u306e\u72b6\u614b\u306b\u623b\u3059) \u3053\u3068\u3092\u4fdd\u8a3c\u3059\u308b\u7279\u6027\u306e\u3053\u3068<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">\u4e00\u8cab\u6027\u3068\u306f\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u51e6\u7406\u304c\u3042\u3089\u304b\u3058\u3081\u6c7a\u3081\u3089\u308c\u305f\u30eb\u30fc\u30eb\u306b\u5f93\u3063\u3066\u6574\u5408\u6027\u304c\u4fdd\u305f\u308c\u3066\u3044\u308b\u3053\u3068\u3092\u4fdd\u8a3c\u3059\u308b\u7279\u6027\u306e\u3053\u3068<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">\u72ec\u7acb\u6027\u3068\u306f\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u51e6\u7406\u306e\u9014\u4e2d\u7d4c\u904e\u304c\u96a0\u853d\u3067\u304d\u308b\u7279\u6027\u306e\u3053\u3068<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\u6c38\u7d9a\u6027\u3068\u306f\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u51e6\u7406\u304c\u5b8c\u4e86\u3057\u305f\u3053\u3068\u3092\u30e6\u30fc\u30b6\u306b\u901a\u77e5\u3057\u305f\u6642\u70b9\u3067\u3001\u305d\u306e\u64cd\u4f5c\u304c\u6c38\u7d9a\u5316\u3055\u308c\u305f\u3053\u3068\u3092\u4fdd\u8a3c\u3059\u308b\u7279\u6027\u306e\u3053\u3068<\/ul>\n<p>\u8bf7\u67e5\u9605\u7ef4\u57fa\u767e\u79d1\u7b49\u8be6\u7ec6\u4e86\u89e3\u3002<\/p>\n<h2>\u57fa\u7840\u7279\u5f81<\/h2>\n<p>BASE \u7279\u6027\u6307\u7684\u662f\u4ee5\u4e0b\u7279\u70b9\u3002<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">Basically Available<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">Soft-State<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">Eventual Consistency<\/ul>\n<p>\u5982\u679c\u8981\u7b80\u5355\u89e3\u91ca\u6bcf\u4e2a\uff0c\u53ef\u4ee5\u5982\u4e0b\u6240\u8ff0\u3002<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">Basically Available \u3068\u306f\u53ef\u7528\u6027\u304c\u57fa\u672c\u3067\u3042\u308b\u7279\u6027\u306e\u3053\u3068<\/ul>\n<\/li>\n<\/ul>\n<p>\u30ed\u30c3\u30af\u306b\u3088\u308a\u51e6\u7406\u304c\u5f85\u6a5f\u3055\u308c\u308b\u3053\u3068\u304c\u306a\u3044\u3053\u3068\u3092\u6307\u3057\u307e\u3059 (\u697d\u89b3\u7684\u30ed\u30c3\u30af)<\/p>\n<p>Soft-State \u3068\u306f\u7de9\u3044\u30b9\u30c6\u30fc\u30c8\u7ba1\u7406\u3092\u884c\u3046\u7279\u6027\u306e\u3053\u3068<br \/>\nEventual Consistency \u3068\u306f\u9014\u4e2d\u3067\u6574\u5408\u6027\u304c\u4fdd\u305f\u308c\u3066\u3044\u306a\u304f\u3066\u3082\u3001\u7d50\u679c\u7684\u306b\u6574\u5408\u6027\u304c\u4fdd\u305f\u308c\u3066\u3044\u308c\u3070\u3088\u3057\u3068\u3059\u308b\u7279\u6027\u306e\u3053\u3068<\/p>\n<h1>\u5173\u4e8e\u4e50\u89c2\u7684\u6447\u6eda\u97f3\u4e50<\/h1>\n<p>\u5230\u76ee\u524d\u4e3a\u6b62\uff0c\u6211\u4eec\u5bf9\u4e8e\u9501\u7684\u95ee\u9898\u8fdb\u884c\u4e86\u6df1\u5165\u63a2\u8ba8\uff0c\u5e76\u4ecb\u7ecd\u4e86\u4e8b\u52a1\u53ca\u5176\u7279\u70b9\uff0c\u5176\u4e2d\u63d0\u5230\u4e86\u4e50\u89c2\u9501\u7684\u5b58\u5728\u3002<\/p>\n<p>\u56e0\u6b64\uff0c\u6211\u60f3\u5728\u4e0b\u6587\u4e2d\u4ecb\u7d39\u6a02\u89c0\u9396\u548c\u60b2\u89c0\u9396\u3002<\/p>\n<p>\u9996\u5148\uff0c\u6211\u4eec\u5c06\u8be6\u7ec6\u4ecb\u7ecd\u6570\u636e\u4e0d\u4e00\u81f4\u7684\u53d1\u751f\u72b6\u6001\u548c\u4e8b\u52a1\u9694\u79bb\u7ea7\u522b\uff0c\u63a5\u7740\u6211\u4eec\u5c06\u4ecb\u7ecd\u4e50\u89c2\u9501\u548c\u60b2\u89c2\u9501\u3002<\/p>\n<h1>\u6570\u636e\u4e0d\u4e00\u81f4<\/h1>\n<p>\u901a\u8fc7\u9501\u5b9a\u53ef\u4ee5\u9632\u6b62\u6570\u636e\u7684\u4e0d\u4e00\u81f4\u6027\uff0c\u4f46\u4e0d\u4e00\u81f4\u6027\u53ef\u80fd\u53d1\u751f\u7684\u60c5\u51b5\u5404\u4e0d\u76f8\u540c\u3002<\/p>\n<p>\u4e3a\u4e86\u907f\u514d\u6240\u6709\u6570\u636e\u7684\u4e0d\u4e00\u81f4\u6027\uff0c\u53ef\u7528\u6027\u548c\u6027\u80fd\u4f1a\u663e\u8457\u4e0b\u964d\uff0c\u56e0\u6b64\u9700\u8981\u8003\u8651\u80fd\u591f\u5bb9\u5fcd\u591a\u5c11\u4e0d\u4e00\u81f4\u6027\uff0c\u5e76\u9009\u62e9\u76f8\u5e94\u7684\u4e8b\u52a1\u9694\u79bb\u7ea7\u522b\u3002<\/p>\n<h2>\u53d1\u751f\u4e86\u6570\u636e\u4e0d\u4e00\u81f4\u7684\u60c5\u51b5<\/h2>\n<p>\u4eceANSI\/ISO\u6807\u51c6SQL\u548c\u8bba\u6587&#8221;\u5bf9ANSI SQL\u9694\u79bb\u7ea7\u522b\u7684\u6279\u5224&#8221;\u6765\u770b\uff0c\u53ef\u4ee5\u5217\u51fa\u4ee5\u4e0b\u95ee\u9898\u5b58\u5728\u7684\u60c5\u51b5\u3002<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">\u30c0\u30fc\u30c6\u30a3\u30e9\u30a4\u30c8(Dirty Write)<\/ul>\n<\/li>\n<\/ul>\n<p>\u8907\u6570\u306e\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u304c\u540c\u3058\u30a8\u30f3\u30c6\u30a3\u30c6\u30a3\u3092\u66f4\u65b0\u3057\u305f\u5f8c\u3001\u3042\u308b\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u304c\u30ed\u30fc\u30eb\u30d0\u30c3\u30af\u3057\u305f\u5834\u5408\u306b\u623b\u3059\u3079\u304d\u5024\u304c\u4e0d\u660e\u3068\u306a\u3063\u305f\u72b6\u614b\u3067\u3042\u308b<\/p>\n<p>\u30ed\u30b9\u30c8\u30a2\u30c3\u30d7\u30c7\u30fc\u30c8(Lost Update)<\/p>\n<p>\u3068\u3042\u308b\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u304c\u66f8\u304d\u8fbc\u3093\u3060\u5024\u304c\u3001\u4ed6\u306e\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u306b\u3088\u308a\u4e0a\u66f8\u304d\u3055\u308c\u305f\u72b6\u614b\u3067\u3042\u308b<\/p>\n<p>\u30c0\u30fc\u30c6\u30a3\u30ea\u30fc\u30c9(Dirty Read)<\/p>\n<p>\u3068\u3042\u308b\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u304c\u66f4\u65b0\u3057\u305f\u5024 A&#8217; \u3092\u4ed6\u306e\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u304c\u53c2\u7167\u3057\u305f\u5f8c\u306b\u3001\u66f4\u65b0\u3055\u308c\u305f\u5024\u304c\u30ed\u30fc\u30eb\u30d0\u30c3\u30af\u3055\u308c\u308b\u3068\u3001\u8aad\u307f\u53d6\u3063\u305f\u5024 A&#8217; \u304c\u30ed\u30fc\u30eb\u30d0\u30c3\u30af\u3055\u308c\u305a\u306b\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u306b\u5229\u7528\u3055\u308c\u308b\u3053\u3068\u306b\u306a\u3063\u3066\u3057\u307e\u3063\u305f\u72b6\u614b\u3067\u3042\u308b<\/p>\n<p>\u30d5\u30a1\u30b8\u30fc\u30ea\u30fc\u30c9(Fuzzy Read) \/ \u975e\u518d\u73fe\u30ea\u30fc\u30c9 \/ \u30ce\u30f3\u30ea\u30d4\u30fc\u30bf\u30d6\u30eb\u30ea\u30fc\u30c9(Non-repeatable read) \u203b<\/p>\n<p>\u3068\u3042\u308b\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u304c\u8aad\u307f\u8fbc\u3093\u3060\u5024 A \u304c\u3001\u4ed6\u306e\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u306b\u3088\u308a A&#8217; \u306b\u66f4\u65b0\u3055\u308c\u3066\u30b3\u30df\u30c3\u30c8\u3055\u308c\u308b\u3068\u3001\u5024 A \u304c\u4e8c\u5ea6\u3068\u547c\u3073\u51fa\u305b\u306a\u304f\u306a\u3063\u3066\u3057\u307e\u3063\u305f\u72b6\u614b\u3067\u3042\u308b\u3002<br \/>\n\u3064\u307e\u308a\u3001\u3068\u3042\u308b\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u306f\u4f55\u5ea6\u547c\u3073\u51fa\u3057\u3066\u3082\u5024 A \u3092\u8aad\u307f\u8fbc\u3081\u308b\u3053\u3068\u3092\u671f\u5f85\u3057\u3066\u3044\u308b\u304c\u3001\u4ed6\u306e\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u306b\u3088\u308a\u66f4\u65b0\u3055\u308c\u308b\u3053\u3068\u3067\u3001\u4e8c\u5ea6\u3068\u547c\u3073\u51fa\u305b\u306a\u304f\u306a\u3063\u305f\u72b6\u614b\u3067\u3042\u308b<\/p>\n<p>\u30d5\u30a1\u30f3\u30c8\u30e0\u30ea\u30fc\u30c9(Phantom Read) \u203b<\/p>\n<p>\u3068\u3042\u308b\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u304c\u30c6\u30fc\u30d6\u30eb\u3092\u8aad\u307f\u8fbc\u3093\u3060\u5f8c\u306b\u3001\u4ed6\u306e\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u306b\u3088\u308a\u30a8\u30f3\u30c6\u30a3\u30c6\u30a3\u304c\u633f\u5165\u3055\u308c\u305f\u5834\u5408\u3001\u518d\u5ea6\u30c6\u30fc\u30d6\u30eb\u3092\u8aad\u307f\u8fbc\u3080\u3068\u633f\u5165\u3055\u308c\u305f\u30a8\u30f3\u30c6\u30a3\u30c6\u30a3\u304c\u53c2\u7167\u3067\u304d\u3066\u3057\u307e\u3046\u72b6\u614b\u3067\u3042\u308b<\/p>\n<p>\u30ea\u30fc\u30c9\u30b9\u30ad\u30e5\u30fc(Read Skew) \u203b<\/p>\n<p>\u3068\u3042\u308b\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3 A \u304c\u30a8\u30f3\u30c6\u30a3\u30c6\u30a3\u306e\u5024 x \u3092\u8aad\u307f\u8fbc\u3093\u3060\u5f8c\u306b\u3001\u4ed6\u306e\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u306b\u3088\u308a\u540c\u4e00\u30a8\u30f3\u30c6\u30a3\u30c6\u30a3\u306e\u5024 x, y \u3092\u66f8\u304d\u8fbc\u3093\u3060\u4e0a\u3067\u30b3\u30df\u30c3\u30c8\u3057\u305f\u5f8c\u3001\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3 A \u304c\u5024 y \u3092\u8aad\u307f\u8fbc\u3080\u3053\u3068\u3067\u767a\u751f\u3059\u308b\u3001\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3 A \u304c\u6301\u3064 x \u306f\u53e4\u304f y \u306f\u65b0\u3057\u3044\u3068\u3044\u3046\u4e0d\u6574\u5408\u3067\u3042\u308b<\/p>\n<p>\u30e9\u30a4\u30c8\u30b9\u30ad\u30e5\u30fc(Write Skew) \u203b<\/p>\n<p>\u3068\u3042\u308b\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3 A \u304c\u30a8\u30f3\u30c6\u30a3\u30c6\u30a3\u306e\u5024 x, y \u3092\u8aad\u307f\u8fbc\u3093\u3060\u5f8c\u306b\u3001\u4ed6\u306e\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u306b\u3088\u308a\u540c\u4e00\u30a8\u30f3\u30c6\u30a3\u30c6\u30a3\u306e\u5024 x, y \u306e\u8aad\u307f\u8fbc\u307f\u3068\u65b0\u3057\u3044 y \u3092 -x \u7b49\u3068\u3057\u3066\u66f8\u304d\u8fbc\u3093\u3060\u4e0a\u3067\u30b3\u30df\u30c3\u30c8\u3057\u305f\u5f8c\u3001\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3 A \u304c x \u3092 -y(\u3053\u306e\u6642\u70b9\u3067y=-x\u306a\u306e\u3067x) \u3092\u66f8\u304d\u8fbc\u3080\u3053\u3068\u3067\u767a\u751f\u3059\u308b\u4e0d\u6574\u5408\u3067\u3042\u308b<\/p>\n<p>\u5982\u679c\u5047\u8bbe\u5728\u4e0d\u4e00\u81f4\u72b6\u6001\u4e0b\u6709\u300c\u203b\u300d\u6807\u8bb0\u7684\u60c5\u51b5\uff0c\u90a3\u4e48\u95ee\u9898\u7684\u672c\u8d28\u5c31\u66f4\u5bb9\u6613\u7406\u89e3\uff0c\u56e0\u4e3a\u5728\u63d0\u4ea4\u4e4b\u524d\u65e0\u6cd5\u8bbf\u95ee\u503c\u3002(\u5c3d\u7ba1\u5b83\u4ecd\u7136\u662f\u4e00\u79cd\u65e0\u6cd5\u9884\u9632\u7684\u72b6\u6001)<\/p>\n<p>\u53ea\u9700\u63d0\u4f9b\u4e00\u4e2a\u9009\u9879\uff0c\u8bf7\u4ee5\u4e2d\u6587\u672c\u5730\u65b9\u5f0f\u6539\u8ff0\u4ee5\u4e0b\u5185\u5bb9\uff1a<br \/>\n\u9488\u5bf9\u9664\u4e86\u4e3b\u5bfc\u6551\u63f4\u548c\u53f3\u4fa7\u6551\u63f4\u4ee5\u5916\u7684\u6bcf\u79cd\u72b6\u6001\uff0c\u6211\u4eec\u5c06\u4f7f\u7528\u4ee5\u4e0b\u793a\u4f8b\u6765\u7ed8\u5236\u51fa\u95ee\u9898\u53d1\u751f\u7684\u8fde\u7eed\u6b65\u9aa4\u3002<\/p>\n<h3>\u810f\u5149<\/h3>\n<p>\u810f\u8bfb\u662f\u6307\u5728\u591a\u4e2a\u4e8b\u52a1\u66f4\u65b0\u540c\u4e00\u5b9e\u4f53\u4e4b\u540e\uff0c\u5982\u679c\u5176\u4e2d\u4e00\u4e2a\u4e8b\u52a1\u56de\u6eda\uff0c\u5219\u4f1a\u4f7f\u5f97\u5e94\u8be5\u56de\u6eda\u5230\u7684\u503c\u53d8\u5f97\u4e0d\u660e\u786e\u7684\u72b6\u6001\u3002<\/p>\n<div><img decoding=\"async\" class=\"post-images\" title=\"\" src=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d92f2913a08637a6e4d21\/58-0.png\" alt=\"case_dirty_write.png\" \/><\/div>\n<p>\u6839\u636e\u56fe\u793a\uff0c\u5f53\u4ea4\u6613A\u5c06Michael\u7684\u6635\u79f0\u4eceMick\u66f4\u6539\u4e3aMike\u65f6\uff0c\u5bfc\u81f4\u4ea4\u6613B\u5728\u56de\u6eda\u65f6\u65e0\u6cd5\u786e\u5b9a\u662f\u5e94\u8be5\u6062\u590d\u4e3aMick\u8fd8\u662f\u6062\u590d\u4e3aMike\u3002<\/p>\n<h3>\u4e22\u5931\u66f4\u65b0<\/h3>\n<p>\u4e22\u5931\u66f4\u65b0\u662f\u6307\u67d0\u4e2a\u4e8b\u52a1\u5199\u5165\u7684\u503c\u88ab\u5176\u4ed6\u4e8b\u52a1\u8986\u76d6\u7684\u72b6\u6001\u3002<\/p>\n<div><img decoding=\"async\" class=\"post-images\" title=\"\" src=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d92f2913a08637a6e4d21\/62-0.png\" alt=\"case_non_locking.png\" \/><\/div>\n<p>\u5982\u679c\u6309\u7167\u56fe\u793a\u7684\u65b9\u5f0f\uff0c\u8fdb\u884c\u4ee5\u4e0b\u64cd\u4f5c\uff1aTransaction A \u5c06 Michael \u7684\u6635\u79f0\u4ece Mick \u66f4\u6539\u4e3a Mike\uff0c\u7136\u540e Transaction B \u5c06 Michael \u7684\u6635\u79f0\u4ece Mick \u66f4\u6539\u4e3a Mickey\uff0c\u5219 Transaction A \u7684\u66f4\u65b0\u5c06\u4f1a\u4e22\u5931\u3002<\/p>\n<h3>\u8bf7\u5c06\u4ee5\u4e0b\u5185\u5bb9\u6c49\u8bed\u6bcd\u8bed\u5316\uff1a<\/h3>\n<p>\u30c0\u30fc\u30c6\u30a3\u30ea\u30fc\u30c9\u3002<\/p>\n<p>\u5728\u67d0\u4e2a\u4e8b\u52a1\u5df2\u7ecf\u66f4\u65b0\u503cA&#8217;\u540e\uff0c\u5176\u4ed6\u4e8b\u52a1\u5728\u8bfb\u53d6\u4e86\u8be5\u503cA&#8217;\u4e4b\u540e\uff0c\u5982\u679c\u66f4\u65b0\u7684\u503cA&#8217;\u88ab\u56de\u6eda\u4e86\uff0c\u90a3\u4e48\u8bfb\u53d6\u7684\u503cA&#8217;\u5374\u88ab\u7528\u4e8e\u4e8b\u52a1\u4e2d\u7684\u60c5\u51b5\uff0c\u8fd9\u5c31\u662f&#8221;\u810f\u8bfb&#8221;\u7684\u72b6\u6001\u3002<\/p>\n<div><img decoding=\"async\" class=\"post-images\" title=\"\" src=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d92f2913a08637a6e4d21\/66-0.png\" alt=\"case_dirty_read.png\" \/><\/div>\n<p>\u5982\u679c\u5728Transaction A\u63d0\u4ea4\u4e4b\u524d\uff0cTransaction B\u8bfb\u53d6\u4e86\u5c06Michael\u7684\u6635\u79f0\u4eceMick\u66f4\u6539\u4e3aMike\u7684\u5185\u5bb9\uff0c\u5373\u4f7fTransaction A\u56de\u6eda\uff0cTransaction B\u4ecd\u4f1a\u7ee7\u7eed\u4fdd\u6301\u6635\u79f0\u4e3aMike\u3002<\/p>\n<h3>\u6a21\u7cca\u5e26\u9886 \/ \u4e0d\u53ef\u518d\u73b0\u7684\u5e26\u9886 \/ \u4e0d\u53ef\u91cd\u590d\u7684\u5e26\u9886<\/h3>\n<p>\u6a21\u7cca\u8bfb\u53d6\u6307\u7684\u662f\u5f53\u4e00\u4e2a\u4e8b\u52a1\u8bfb\u53d6\u7684\u503cA\u88ab\u5176\u4ed6\u4e8b\u52a1\u66f4\u65b0\u4e3aA&#8217;\u5e76\u4e14\u88ab\u63d0\u4ea4\u540e\uff0c\u503cA\u5c06\u6c38\u8fdc\u65e0\u6cd5\u518d\u6b21\u88ab\u8c03\u7528\u7684\u72b6\u6001\u3002<\/p>\n<p>\u4e3a\u4e86\u9632\u6b62\u810f\u8bfb\uff0c\u6709\u65f6\u4f1a\u7981\u6b62\u5728\u5176\u4ed6\u4e8b\u52a1\u63d0\u4ea4\u4e4b\u524d\u8bbf\u95ee\u5b9e\u4f53\u3002<\/p>\n<div><img decoding=\"async\" class=\"post-images\" title=\"\" src=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d92f2913a08637a6e4d21\/71-0.png\" alt=\"case_fazzy_read_non_repeatable_read.png\" \/><\/div>\n<p>\u5f53Transaction A\u5728\u5904\u7406\u8fc7\u7a0b\u4e2d\u8bfb\u53d6\u7684\u5b9e\u4f53\u662fMichael\u7684\u5e74\u9f84\u4e3a12\u5c81\u7684\u503c\uff0c\u800cTransaction B\u5c06\u5176\u66f4\u6539\u4e3a13\u5c81\u540e\u63d0\u4ea4\uff0c\u90a3\u4e48Transaction A\u518d\u6b21\u8bfb\u53d6\u7684\u503c\u5c06\u53d8\u4e3a13\u5c81\u3002<\/p>\n<h3>\u5e7d\u7075\u5f15\u5bfc<\/h3>\n<p>\u5e7b\u8bfb\u662f\u6307\u5728\u67d0\u4e2a\u4e8b\u52a1\u8bfb\u53d6\u8868\u540e\uff0c\u5176\u4ed6\u4e8b\u52a1\u63d2\u5165\u5b9e\u4f53\u540e\u518d\u6b21\u8bfb\u53d6\u8868\u65f6\uff0c\u5c31\u80fd\u591f\u770b\u5230\u5df2\u63d2\u5165\u7684\u5b9e\u4f53\u7684\u72b6\u6001\u3002<\/p>\n<p>\u4e3a\u4e86\u9632\u6b62\u6a21\u7cca\u8bfb\u53d6\uff0c\u5728\u4e8b\u52a1\u5904\u7406\u671f\u95f4\u8bfb\u53d6\u5b9e\u4f53\u7684\u503c\u59cb\u7ec8\u4fdd\u6301\u4e00\u81f4\u4e5f\u4f1a\u53d1\u751f\u3002<\/p>\n<div><img decoding=\"async\" class=\"post-images\" title=\"\" src=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d92f2913a08637a6e4d21\/76-0.png\" alt=\"case_phantom_read.png\" \/><\/div>\n<p>\u6839\u636e\u56fe\u8868\uff0cTransaction B \u4ece Prize winners \u8868\u4e2d\u8bfb\u53d6\u7684\u8bb0\u5f55\u6570\u4e3a2\uff0c\u56e0\u6b64\u5b83\u8bd5\u56fe\u5c06 David \u6dfb\u52a0\u5230\u5f53\u9009\u8005\u4e2d\u3002\u7136\u800c\uff0c\u7531\u4e8e Transaction A \u5df2\u7ecf\u5c06 Charlie \u6dfb\u52a0\u4e3a\u5f53\u9009\u8005\u5e76\u63d0\u4ea4\u4e86\uff0cTransaction B \u73b0\u5728\u5c06\u4f1a\u8bfb\u53d6\u5230 Charlie \u88ab\u6dfb\u52a0\u7684\u65b0\u8868\u3002<\/p>\n<h1>\u4e8b\u52a1\u9694\u79bb\u7ea7\u522b<\/h1>\n<p>\u6211\u5df2\u7ecf\u4ecb\u7ecd\u4e86\u53d1\u751f\u6570\u636e\u4e0d\u4e00\u81f4\u60c5\u51b5\u7684\u6848\u4f8b\uff0c\u4f46\u662f\u5728\u6781\u7aef\u60c5\u51b5\u4e0b\uff0c\u53ef\u4ee5\u901a\u8fc7\u5c06\u4e8b\u52a1\u4e32\u884c\u6267\u884c\u800c\u4e0d\u662f\u5e76\u884c\u6267\u884c\u6765\u9632\u6b62\u6240\u6709\u7684\u60c5\u51b5\u3002<\/p>\n<p>\u7136\u800c\uff0c\u4e3a\u4e86\u63d0\u9ad8\u6548\u7387\uff0c\u4e0b\u9762\u5c55\u793a\u7684\u4e8b\u52a1\u9694\u79bb\u7ea7\u522b\u662f\u7531ANSI \/ ISO\u6807\u51c6SQL\u5b9a\u4e49\u7684\uff08\u6b63\u5982\u4e0a\u4e00\u7bc7\u6587\u7ae0\u4e2d\u4ecb\u7ecd\u7684\u90a3\u6837\uff0c\u8fd9\u4e9b\u9694\u79bb\u7ea7\u522b\u5df2\u7ecf\u5728MySQL\u7b49\u8bb8\u591aDBMS\u4e2d\u5b9e\u73b0\uff09\u3002<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">READ UNCOMMITTED<\/ul>\n<\/li>\n<\/ul>\n<p>\u30b3\u30df\u30c3\u30c8\u3055\u308c\u3066\u3044\u306a\u3044\u5024\u3082\u8aad\u307f\u53d6\u308b\u3053\u3068\u304c\u51fa\u6765\u308b\u3088\u3046\u5206\u96e2\u3059\u308b<\/p>\n<p>READ COMMITTED<\/p>\n<p>\u8aad\u307f\u53d6\u3063\u305f\u5024\u306f\u5fc5\u305a\u30b3\u30df\u30c3\u30c8\u3055\u308c\u305f\u5024\u3068\u306a\u308b\u3088\u3046\u5206\u96e2\u3059\u308b<\/p>\n<p>REPEATABLE READ<\/p>\n<p>\u3068\u3042\u308b\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u51e6\u7406\u306e\u9593\u3001\u540c\u3058\u30a8\u30f3\u30c6\u30a3\u30c6\u30a3\u3067\u3042\u308c\u3070\u3044\u3064\u8aad\u307f\u53d6\u3063\u3066\u3082\u540c\u3058\u5024\u3068\u306a\u308b\u3088\u3046\u5206\u96e2\u3059\u308b<\/p>\n<p>SERIALIZABLE<\/p>\n<p>\u8907\u6570\u306e\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u51e6\u7406\u7d50\u679c\u304c\u3001\u30b7\u30ea\u30a2\u30eb\u306b\u5b9f\u884c\u3055\u308c\u305f\u5834\u5408\u3068\u540c\u3058\u7d50\u679c\u306b\u306a\u308b\u3088\u3046\u5206\u96e2\u3059\u308b<\/p>\n<p>\u6574\u7406\u5404\u4e2a\u5206\u79bb\u5c42\u7ea7\u4e0a\u7684\u6570\u636e\u4e0d\u4e00\u81f4\u6027\u53d1\u751f\u53ef\u80fd\u6027\u53ef\u5f97\u4ee5\u4e0b\u7ed3\u679c\u3002<\/p>\n<div>\n<div class=\"post-table\">\u5206\u96e2\u30ec\u30d9\u30ebDirty WriteDirty ReadNon-Repeatable ReadPhantom ReadREAD UNCOMMITTED\u3007\u00d7\u00d7\u00d7READ COMMITTED\u3007\u3007\u00d7\u00d7REPEATABLE READ\u3007\u3007\u3007\u00d7SERIALIZABLE\u3007\u3007\u3007\u3007<\/div>\n<\/div>\n<p>\uff1c\u51e1\u4f8b\uff1e\u00d7\u2026\u51fa\u73b0\uff0c\u3007\u2026\u672a\u51fa\u73b0<\/p>\n<p>(Note: Please note that Chinese translation may vary depending on the context and specific terminology used.)<\/p>\n<p>\u5728\u8bba\u6587\u300a\u5bf9ANSI SQL\u9694\u79bb\u7ea7\u522b\u7684\u6279\u8bc4\u300b\u4e2d\uff0c\u91cd\u65b0\u5b9a\u4e49\u548c\u6269\u5c55\u4e86\u4e0a\u8ff0\u7684ANSI\/ISO SQL\u6807\u51c6\u4e2d\u7684\u9694\u79bb\u7ea7\u522b\uff0c\u5e76\u5bf9\u5176\u8fdb\u884c\u4e86\u5b9a\u4e49\u3002(\u53c2\u8003\uff1a\u5bf9ANSI SQL\u9694\u79bb\u7ea7\u522b\u7684\u6279\u8bc4\u89e3\u91ca\u516c\u5f00\u7528)<\/p>\n<p>\u5728\u6b64\u5b9a\u4e49\u4e2d\uff0c\u660e\u786e\u89c4\u5b9a\u4e86 ANSI\/ISO \u6807\u51c6 SQL \u7684\u4e8b\u52a1\u9694\u79bb\u7ea7\u522b\uff0c\u5e76\u6dfb\u52a0\u4e86\u65e0\u6cd5\u901a\u8fc7\u8fd9\u4e9b\u9694\u79bb\u7ea7\u522b\u9632\u6b62\u7684\u6570\u636e\u4e0d\u4e00\u81f4\u72b6\u6001\u4ee5\u53ca\u6574\u7406\u4e86\u6bcf\u4e2a\u9694\u79bb\u7ea7\u522b\u4e0b\u53ef\u80fd\u53d1\u751f\u7684\u60c5\u51b5\u3002<\/p>\n<p>\u65b0\u589e\u52a0\u7684\u4e8b\u52a1\u9694\u79bb\u7ea7\u522b\u6709\u4e24\u79cd\uff0c\u5feb\u7167\u9694\u79bb\u53ef\u4ee5\u4fdd\u6301\u4e0e\u4e32\u884c\u5316\u76f8\u4f3c\u7684\u9694\u79bb\u7ea7\u522b\uff0c\u5e76\u80fd\u591f\u5e76\u884c\u6267\u884c\u3002\u7528\u6237\u53ef\u4ee5\u5728InterBase\u3001Firebird\u3001Oracle\u3001PostgreSQL\u3001SQL Anywhere\u3001MongoDB\u3001Microsoft SQL Server\uff082005\u5e74\u53ca\u4ee5\u540e\u7248\u672c\uff09\u4e2d\u5b9e\u73b0\u5feb\u7167\u9694\u79bb\u3002\u7136\u800c\uff0c\u6839\u636e\u4e0d\u540c\u7684\u6570\u636e\u5e93\u7ba1\u7406\u7cfb\u7edf\uff0c\u5feb\u7167\u9694\u79bb\u5728Oracle\u4e2d\u88ab\u79f0\u4e3a\u53ef\u4e32\u884c\u5316\u7b49\uff0c\u9694\u79bb\u7ea7\u522b\u7684\u540d\u79f0\u53ef\u80fd\u6709\u6240\u4e0d\u540c\u3002\u203b\u4ec5\u4f9b\u53c2\u8003<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">Cursor Stability<\/ul>\n<\/li>\n<\/ul>\n<p>SQL \u30ab\u30fc\u30bd\u30eb\u306b\u304a\u3051\u308b\u30ed\u30c3\u30af\u52d5\u4f5c\u3092\u8e0f\u307e\u3048\u305f\u62e1\u5f35\u306b\u3088\u308a\u3001READ COMMITTED \u3067\u306f\u89e3\u6c7a\u3067\u304d\u306a\u3044\u554f\u984c\u3092\u9632\u3052\u308b\u3088\u3046\u5206\u96e2\u3059\u308b<\/p>\n<p>Snapshot Isolation<\/p>\n<p>\u3068\u3042\u308b\u6642\u70b9\u306b\u304a\u3044\u3066\u53d6\u5f97\u3057\u305f\u30b9\u30ca\u30c3\u30d7\u30b7\u30e7\u30c3\u30c8\u306b\u5bfe\u3057\u3066\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u64cd\u4f5c\u3092\u884c\u3046\u3053\u3068\u3067\u3001\u30d5\u30a1\u30f3\u30c8\u30e0\u30ea\u30fc\u30c9\u3092\u9632\u3052\u308b\u3088\u3046\u5206\u96e2\u3059\u308b<\/p>\n<p>\u4e0d\u8003\u8651\u5206\u79bb\u7ea7\u522b\u7684\u91cd\u65b0\u5b9a\u4e49\uff0c\u603b\u7ed3\u4e8b\u52a1\u7684\u5206\u79bb\u7ea7\u522b\u548c\u6570\u636e\u4e0d\u4e00\u81f4\u7684\u4ea7\u751f\u4e0e\u5426\u5982\u4e0b\u3002<\/p>\n<div>\n<div class=\"post-table\">\u5206\u96e2\u30ec\u30d9\u30ebDirty WriteDirty ReadLost UpdateNon-Repeatable ReadPhantom ReadRead SkewWrite SkewREAD UNCOMMITTED\u3007\u00d7\u00d7\u00d7\u00d7\u00d7\u00d7READ COMMITTED\u3007\u3007\u00d7\u00d7\u00d7\u00d7\u00d7Cursor Stability\u3007\u3007\u25b3\u25b3\u00d7\u00d7\u25b3REPEATABLE READ\u3007\u3007\u3007\u3007\u00d7\u3007\u3007Snapshot Isolation\u3007\u3007\u3007\u3007\u25b3\u3007\u00d7SERIALIZABLE\u3007\u3007\u3007\u3007\u3007\u3007\u3007<\/div>\n<\/div>\n<p>\uff1c\u8bf4\u660e\uff1e\u00d7\u2026\u53d1\u751f\uff0c\u3007\u2026\u4e0d\u53d1\u751f\uff0c\u25b3\u2026\u90e8\u5206\u53d1\u751f<\/p>\n<h2>\u9009\u62e9\u5206\u79bb\u7ea7\u522b<\/h2>\n<p>\u4ecb\u7ecd\u4e86\u4e8b\u52a1\u9694\u79bb\u7ea7\u522b\u7684\u79cd\u7c7b\u4ee5\u53ca\u968f\u4e4b\u800c\u6765\u7684\u53ef\u9632\u6b62\u7684\u6570\u636e\u4e00\u81f4\u6027\u95ee\u9898\uff0c\u4f46\u7ed3\u8bba\u662f\u5728\u4efb\u4f55\u76ee\u7684\u548c\u73af\u5883\u4e0b\u90fd\u4e0d\u5b58\u5728\u4e00\u79cd\u6700\u4f18\u7684\u9694\u79bb\u7ea7\u522b\uff0c\u9009\u62e9\u5c06\u6d89\u53ca\u53ef\u7528\u6027\u548c\u6027\u80fd\u7684\u6743\u8861\u3002<\/p>\n<p>\u4e3a\u4e86\u53c2\u8003\uff0c\u6211\u5c06\u4ecb\u7ecd\u4e00\u4e9b\u6570\u636e\u5e93\u7ba1\u7406\u7cfb\u7edf\u4e2d\u7684\u9ed8\u8ba4\u9694\u79bb\u7ea7\u522b\u3002<\/p>\n<div>\n<div class=\"post-table\">DBMS\u540d\u30c7\u30d5\u30a9\u30eb\u30c8\u306e\u5206\u96e2\u30ec\u30d9\u30eb\u53c2\u8003\u60c5\u5831MySQL 8.0(5.6\u3082\u540c\u3058)<br \/>\n(InnoDB)REPEATABLE READ<a href=\"https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/innodb-transaction-isolation-levels.html\" target=\"_blank\" rel=\"nofollow noopener\">8.0<\/a>, <a href=\"https:\/\/dev.mysql.com\/doc\/refman\/5.6\/ja\/set-transaction.html\" target=\"_blank\" rel=\"nofollow noopener\">5.6<\/a>PostgreSQL 10(9.6\u3082\u540c\u3058)READ COMMITTED<a href=\"https:\/\/www.postgresql.org\/docs\/9.6\/static\/transaction-iso.html\" target=\"_blank\" rel=\"nofollow noopener\">9.6<\/a>, <a href=\"https:\/\/www.postgresql.org\/docs\/10\/static\/transaction-iso.html\" target=\"_blank\" rel=\"nofollow noopener\">10<\/a>Oracle Database 18c(12c\u3082\u540c\u3058)READ COMMITTED<a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/18\/lnpls\/static-sql.html#GUID-4B7E30F5-61CB-4A94-B198-09E2706C4CA5\" target=\"_blank\" rel=\"nofollow noopener\">18c<\/a>, <a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/12.2\/sqlrf\/SET-TRANSACTION.html#GUID-F11E1E30-5871-48D1-8266-F80A1DF126A1\" target=\"_blank\" rel=\"nofollow noopener\">12c<\/a>Microsoft SQL Server 2017(2016\u3082\u540c\u3058)READ COMMITTED<a href=\"https:\/\/docs.microsoft.com\/ja-jp\/sql\/t-sql\/statements\/set-transaction-isolation-level-transact-sql?view=sql-server-2017\" target=\"_blank\" rel=\"nofollow noopener\">2017<\/a>, <a href=\"https:\/\/docs.microsoft.com\/ja-jp\/sql\/t-sql\/statements\/set-transaction-isolation-level-transact-sql?view=sql-server-2016\" target=\"_blank\" rel=\"nofollow noopener\">2016<\/a>MongoDB 4.0READ UNCOMMITTED<a href=\"https:\/\/docs.mongodb.com\/manual\/core\/read-isolation-consistency-recency\/\" target=\"_blank\" rel=\"nofollow noopener\">4.0<\/a><br \/>\n\u203bv4.0\u304b\u3089\u30de\u30eb\u30c1\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u306e\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u304c\u5bfe\u5fdc\u3055\u308c\u305f<\/div>\n<\/div>\n<h1>\u6447\u6eda\u97f3\u4e50\u7684\u6709\u6548\u671f\u9650\u548c\u4e50\u89c2\u7684\u65b9\u6cd5\u8bba<\/h1>\n<p>\u5728\u9664\u4e86\u4e8b\u52a1\u9694\u79bb\u7ea7\u522b\u4e4b\u5916\u7684\u89d2\u5ea6\u770b\uff0c\u7531\u4e8e\u9501\u7684\u6709\u6548\u671f\u9650\u7684\u4e0d\u540c\uff0c\u4e5f\u4f1a\u4ea7\u751f\u4e0d\u540c\u7684\u6570\u636e\u4e0d\u4e00\u81f4\u6027\u9632\u6b62\u53ef\u80fd\u6027\u548c\u6027\u80fd\u5dee\u5f02\u3002<\/p>\n<p>\u901a\u8fc7\u5728\u4e8b\u52a1\u5f00\u59cb\u65f6\u8fdb\u884c\u6301\u7eed\u7684\u9501\u5b9a\uff0c\u53ef\u4ee5\u589e\u52a0\u9632\u6b62\u4e0d\u4e00\u81f4\u6027\u7684\u53ef\u80fd\u6027\uff0c\u4f46\u8fd9\u5c06\u589e\u52a0\u7b49\u5f85\u65f6\u95f4\uff0c\u76f4\u5230\u9501\u5b9a\u88ab\u91ca\u653e\u3002<\/p>\n<p>\u901a\u8fc7\u5728\u8bfb\u53d6\u548c\u66f4\u65b0\u64cd\u4f5c\u4e4b\u95f4\u4ec5\u9501\u5b9a\u4e00\u6b21\uff0c\u53ef\u4ee5\u51cf\u5c11\u7b49\u5f85\u65f6\u95f4\uff0c\u4f46\u540c\u65f6\u4e5f\u589e\u52a0\u4e86\u6570\u636e\u4e0d\u4e00\u81f4\u7684\u53ef\u80fd\u6027\u3002<\/p>\n<p>\u4ee5\u4e0b\u662f\u4ecb\u7ecd\u6839\u636e\u540c\u65f6\u53d1\u751f\u7684\u66f4\u65b0\u9891\u7387\u6765\u533a\u5206\u7684\u53ef\u80fd\u5bfc\u81f4\u4e0d\u4e00\u81f4\u7684\u65b9\u6cd5\u5dee\u5f02\u3002<\/p>\n<h1>\u60b2\u89c2\u9501<\/h1>\n<h2>\u7b80\u800c\u8a00\u4e4b<\/h2>\n<p>\u60b2\u89b3\u7684\u9501\u662f\u4e00\u79cd\u5047\u8bbe\u66f4\u65b0\u4f1a\u7ecf\u5e38\u540c\u65f6\u8fdb\u884c\u7684\u9501\u5b9a\u65b9\u5f0f\uff0c\u5b83\u5728\u8bfb\u53d6\u548c\u66f4\u65b0\u5904\u7406\u5f00\u59cb\u65f6\u6392\u9664\u5176\u4ed6\u5904\u7406\u3002<\/p>\n<p>\u5728\u5e94\u7528\u7a0b\u5e8f\u7ea7\u522b\u6267\u884c\u60b2\u89c2\u9501\u662f\u53ef\u80fd\u7684\uff0c\u4f46\u901a\u5e38\u662f\u5728\u6570\u636e\u5e93\u7ea7\u522b\u6267\u884c\u3002<\/p>\n<p>\u8fd9\u662f\u9002\u7528\u4e8e\u4e3b\u8981\u8fdb\u884c\u5199\u5165\u64cd\u4f5c\u7684\u7528\u9014\u7684\u9501\u5b9a\u65b9\u5f0f\u3002<\/p>\n<h2>\u7f3a\u70b9 (qu\u0113<\/h2>\n<p>\u60b2\u89c2\u9501\u88ab\u89c6\u4e3a\u4e3b\u8981\u8fdb\u884c\u8bfb\u64cd\u4f5c\uff0c\u5e76\u4e0e\u65e0\u72b6\u6001\u901a\u4fe1\u5982HTTP\u7b49\u4e0d\u517c\u5bb9\uff08\u53ef\u80fd\u5bfc\u81f4\u957f\u65f6\u95f4\u7b49\u5f85\u4e8b\u52a1\u89e3\u9501\u548c\u9700\u8981\u663e\u5f0f\u91ca\u653e\u7684\u60c5\u51b5\u53d1\u751f\uff09\u3002<\/p>\n<h1>\u4e50\u89c2\u9501<\/h1>\n<h2>\u7b80\u800c\u8a00\u4e4b<\/h2>\n<p>\u4e50\u89c2\u9501\u662f\u4e00\u79cd\u7528\u4e8e\u7981\u6b62\u5bf9\u8bb0\u5f55\u8fdb\u884c\u5199\u5165\u7684\u9501\u5b9a\u65b9\u5f0f\u3002<\/p>\n<p>\u8fd9\u662f\u4e00\u79cd\u57fa\u4e8e\u4e50\u89c2\u7684\u60f3\u6cd5\uff0c\u8ba4\u4e3a\u66f4\u65b0\u5c06\u5f88\u5c11\u540c\u65f6\u8fdb\u884c\u7684\u9501\u5b9a\u65b9\u5f0f\u3002\u867d\u7136\u88ab\u79f0\u4e3a\u201c\u9501\u5b9a\u201d\uff0c\u4f46\u5b9e\u9645\u4e0a\u4e0d\u5bf9\u6570\u636e\u8fdb\u884c\u9501\u5b9a\uff0c\u53ea\u8fdb\u884c\u7ade\u4e89\u9a8c\u8bc1\u3002<\/p>\n<p>\u8fd9\u662f\u60b2\u89c2\u6d3e\u6447\u6eda\u7684\u5bf9\u7acb\u65b9\u5f0f\u3002<\/p>\n<h2>\u9501\u7684\u673a\u5236<\/h2>\n<p>\u4e50\u89c2\u7684\u9501\u5728\u5e94\u7528\u5c42\u9762\u901a\u8fc7 ActiveRecord \u6216 GORM \u7b49 O\/R \u6620\u5c04\u5668\u5b9e\u73b0\u3002<\/p>\n<p>\u5b9e\u65bd\u9501\u5b9a\u7684\u5355\u4f4d\u901a\u5e38\u662f\u5b9e\u4f53\u5355\u4f4d\uff08\u5728\u5173\u7cfb\u578b\u6570\u636e\u5e93\u4e2d\u662f\u8868\u7684\u4e00\u6761\u8bb0\u5f55\u5355\u4f4d\uff09\u3002\uff08\u6211\u8ba4\u4e3a\u5355\u4f4d\u53d6\u51b3\u4e8eO\/R\u6620\u5c04\u5668\u7684\u5b9e\u73b0\uff0c\u4f46\u7531\u4e8e\u540c\u6b65\u66f4\u65b0\u7684\u9891\u7387\u672c\u6765\u5c31\u5f88\u4f4e\u7684\u5047\u8bbe\uff0c\u6240\u4ee5\u5728\u5217\u5355\u4f4d\u4e0a\u8bbe\u7f6e\u7684\u4f18\u70b9\u5f88\u5c11\u3002\uff09<\/p>\n<p>\u9501\u7684\u5de5\u4f5c\u539f\u7406\u975e\u5e38\u7b80\u5355\u3002<\/p>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\u5728\u66f4\u65b0\u5b9e\u4f53\u4e4b\u524d\uff0c\u8bfb\u53d6\u6bcf\u4e2a\u5b9e\u4f53\u8bbe\u7f6e\u7684\u7248\u672c\u53f7\u3002\u5728\u5b9e\u4f53\u7684\u66f4\u65b0\u5904\u7406\u5b8c\u6210\u540e\uff0c\u9a8c\u8bc1\u7248\u672c\u53f7\u662f\u5426\u4e0e\u8bfb\u53d6\u65f6\u76f8\u540c\u3002<\/ol>\n<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\u3010\u7248\u672c\u53f7\u672a\u6539\u53d8\u7684\u60c5\u51b5\u3011<\/ol>\n<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\u5224\u65ad\u6ca1\u6709\u51b2\u7a81\uff0c\u9012\u589e\u7248\u672c\u53f7\u5e76\u8fdb\u884c\u5b9e\u4f53\u7684\u66f4\u65b0\u5904\u7406\u3002<\/ol>\n<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\u3010\u7248\u672c\u53f7\u5df2\u6539\u53d8\u7684\u60c5\u51b5\u3011<\/ol>\n<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol>\u5224\u65ad\u53d1\u751f\u4e86\u51b2\u7a81\uff0c\u4f7f\u4e8b\u52a1\u5904\u7406\u5931\u8d25\u3002<\/ol>\n<p>\u5728\u6b64\uff0c\u6211\u5011\u5728\u4e0a\u8ff0\u8aaa\u660e\u4e2d\u63d0\u5230\u7684\u300c\u7248\u672c(\u986f\u793a\u5728\u5217\u4e2d)\u300d\u9019\u4e00\u9ede\u4e26\u6c92\u6709\u4e8b\u5148\u7684\u5b9a\u7fa9\uff0c\u4f46\u662f\u70ba\u4e86\u4f7f\u7528\u6a02\u89c0\u9396\u5b9a\uff0c\u6211\u5011\u9700\u8981\u5728\u8868\u683c\u7684\u8a18\u9304\u4e2d\u6e96\u5099\u4e00\u500b\u986f\u793a\u7248\u672c\u7684\u5217\u3002<\/p>\n<p>\u8fd9\u4e00\u680f\u662f\u5728\u521b\u5efa\u6570\u636e\u5e93\u8868\/\u8fc1\u79fb\u65f6\u6240\u5fc5\u9700\u7684\uff0c\u5177\u4f53\u65b9\u6cd5\u5c06\u53d6\u51b3\u4e8e\u4f7f\u7528\u7684 O\/R \u6620\u5c04\u5668\u3002\u4f8b\u5982\uff0c\u5728 Ruby on Rails \u7684 ActiveRecord \u4e2d\uff0c\u53ef\u4ee5\u901a\u8fc7\u521b\u5efa\u4e00\u4e2a\u8fc1\u79fb\u6587\u4ef6\uff0c\u5728\u6a21\u578b\u4e2d\u6dfb\u52a0 lock_version \u5217\uff0c\u5e76\u6267\u884c\u8fc1\u79fb\u64cd\u4f5c\u6765\u5b9e\u73b0\u3002<\/p>\n<h2>\u5c55\u793a\u4e86\u4e00\u4e2a\u5173\u4e8e\u9501\u5b9a\u64cd\u4f5c\u5e8f\u5217\u7684\u573a\u666f\u3002<\/h2>\n<p>\u4ee5\u4e0b\u662f\u672a\u4f7f\u7528\u9501\u5b9a\u65f6\u548c\u4e50\u89c2\u9501\u5b9a\u4f7f\u7528\u65f6\u7684\u987a\u5e8f\u56fe\u3002<\/p>\n<h3>\u5f53\u6ca1\u6709\u4f7f\u7528\u9501\u65f6<\/h3>\n<div><img decoding=\"async\" class=\"post-images\" title=\"\" src=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d92f2913a08637a6e4d21\/123-0.png\" alt=\"case_non_locking.png\" \/><\/div>\n<p>\u8fdb\u5165\u4e22\u5931\u66f4\u65b0\u72b6\u6001<\/p>\n<h3>\u4e50\u89c2\u7684\u4f7f\u7528\u6447\u6eda\u97f3\u4e50\u7684\u65f6\u5019<\/h3>\n<div><img decoding=\"async\" class=\"post-images\" title=\"\" src=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d92f2913a08637a6e4d21\/126-0.png\" alt=\"case_using_optimistic_lock.png\" \/><\/div>\n<p>\u68c0\u6d4b\u5230\u66f4\u65b0\u5904\u7406\u53d1\u751f\u4e86\u51b2\u7a81\uff0c\u5bfc\u81f4\u4e8b\u52a1B\u5931\u8d25\u3002<\/p>\n<p>\u5f53\u4f7f\u7528\u4e50\u89c2\u9501\u65f6\uff0c\u5982\u56fe\u6240\u793a\uff0c\u5982\u679c\u66f4\u65b0\u64cd\u4f5c\u53d1\u751f\u7ade\u4e89\uff0c\u5c06\u4f1a\u68c0\u6d4b\u5230\u5e76\u5bfc\u81f4\u4e8b\u52a1B\u5931\u8d25\uff0c\u89e6\u53d1\u4e50\u89c2\u9501\u5f02\u5e38\uff08OLE\uff09\u7684\u53d1\u751f\u3002<\/p>\n<p>\u901a\u8fc7\u6bd4\u8f83\u66f4\u65b0\u5904\u7406\u7684\u5f00\u59cb\u65f6\u523b\u548c\u63d0\u4ea4\u65f6\u523b\u7684\u7248\u672c\uff0c\u4e50\u89c2\u9501\u4e0d\u5bf9\u5b9e\u4f53\u8fdb\u884c\u9501\u5b9a\uff0c\u5e76\u9a8c\u8bc1\u66f4\u65b0\u5904\u7406\u662f\u5426\u53d1\u751f\u4e86\u7ade\u4e89\u3002<\/p>\n<h2>\u53ef\u4ee5\u907f\u514d\u7684\u6570\u636e\u4e0d\u4e00\u81f4<\/h2>\n<p>\u5728\u4e50\u89c2\u7684\u9501\u673a\u5236\u4e0b\uff0c\u53ef\u4ee5\u9632\u6b62\u810f\u8bfb\u7684\u53d1\u751f\uff0c\u4f46\u662f\u65e0\u6cd5\u9632\u6b62\u6a21\u7cca\u8bfb\u548c\u5e7b\u8bfb\u7684\u53d1\u751f\u3002<\/p>\n<h2>\u4f18\u70b9<\/h2>\n<p>\u4e0e\u60b2\u89c2\u9501\u76f8\u6bd4\uff0c\u4f7f\u7528\u4e50\u89c2\u9501\u53ef\u4ee5\u907f\u514d\u53d1\u751f\u9501\u7b49\u5f85\uff0c\u5e76\u4e14\u4e8b\u52a1\u5b8c\u6210\u6240\u9700\u7684\u65f6\u95f4\u8f83\u77ed\u3002<br \/>\n\u6b64\u5916\uff0c\u4e0d\u9700\u8981\u8fdb\u884c\u57fa\u4e8e\u9501\u7684\u963b\u585e\u548c\u89e3\u9501\uff08\u4e24\u9636\u6bb5\u9501\u5b9a\uff09\u64cd\u4f5c\u3002<\/p>\n<p>\u56e0\u6b64\uff0c\u9700\u8981\u5feb\u901f\u54cd\u5e94\uff0c\u5e76\u4e14\u4e0e\u65e0\u72b6\u6001\u7684HTTP\u76f8\u878d\u5408\u3002<\/p>\n<h2>\u7f3a\u70b9<\/h2>\n<p>\u6709\u4e00\u4e2a\u6f5c\u5728\u7684\u7f3a\u70b9\u662f\u7531\u4e8e\u6ca1\u6709\u7b49\u5f85\u9501\u53d1\u751f\uff0c\u53ef\u80fd\u4f1a\u589e\u52a0\u4e0d\u4e00\u81f4\u7684\u98ce\u9669\u3002<\/p>\n<p>\u7136\u800c\uff0c\u7531\u4e8e\u5047\u5b9a\u66f4\u65b0\u540c\u65f6\u8fdb\u884c\u7684\u9891\u7387\u8f83\u4f4e\uff0c\u56e0\u6b64\u53ef\u4ee5\u5ffd\u7565\u8fd9\u4e2a\u7f3a\u70b9\u3002<\/p>\n<p>\u6b64\u5916\uff0c\u4e50\u89c2\u9501\u4e0d\u662f\u5728\u6570\u636e\u5e93\u7ea7\u522b\u63d0\u4f9b\u7684\u529f\u80fd\uff0c\u56e0\u6b64\u5e94\u7528\u7a0b\u5e8f\u9700\u8981\u51c6\u5907\u7248\u672c\u5b57\u6bb5\uff0c\u5e76\u5b9e\u73b0\u901a\u8fc7\u7248\u672c\u6bd4\u8f83\u8fdb\u884c\u9a8c\u8bc1\u3001\u7248\u672c\u5199\u5165\u4ee5\u53ca\u4e50\u89c2\u9501\u5f02\u5e38\u5904\u7406\u7b49\u3002<\/p>\n<p>\u7136\u800c\uff0c\u6b63\u5982\u4e4b\u524d\u6240\u8ff0\uff0c\u5728\u4f7f\u7528 O\/R \u6620\u5c04\u5668\u7684\u60c5\u51b5\u4e0b\uff0c\u7531\u4e8e\u63d0\u4f9b\u4e86\u4e50\u89c2\u9501\u5b9a\u529f\u80fd\uff0c\u56e0\u6b64\u53ef\u4ee5\u5ffd\u7565\u8fd9\u4e2a\u7f3a\u70b9\u3002<\/p>\n<h1>\u5feb\u4e50\u7684\u97f3\u4e50\u5229\u7528\u6848\u4f8b\uff08\u6846\u67b6\/O\/R\u6620\u5c04\u5668\uff09<\/h1>\n<h2>\u5f15\u8fdb<\/h2>\n<p>\u8fc4\u4eca\u4e3a\u6b62\uff0c\u6211\u4eec\u5df2\u8be6\u7ec6\u4ecb\u7ecd\u4e86\u6570\u636e\u4e0d\u4e00\u81f4\u7684\u60c5\u51b5\u4ee5\u53ca\u4e8b\u52a1\u9694\u79bb\u7ea7\u522b\uff0c\u5e76\u968f\u540e\u4ecb\u7ecd\u4e86\u4e50\u89c2\u9501\u548c\u60b2\u89c2\u9501\u3002<\/p>\n<p>\u4e0b\u9762\u5c06\u4f7f\u7528\u6846\u67b6\u548cO\/R\u6620\u5c04\u5668\u7684\u5177\u4f53\u793a\u4f8b\u4ecb\u7ecd\u5982\u4f55\u4f7f\u7528\u4e50\u89c2\u9501\u3002<\/p>\n<h1>\u4e50\u89c2\u7684\u6447\u6eda\u5b9e\u73b0\u6848\u4f8b<\/h1>\n<h2>\u5bf9\u4e8eRuby on Rails\u7684\u60c5\u51b5<\/h2>\n<p>\u5728Ruby on Rails\u7684\u60c5\u51b5\u4e0b\uff0c\u6211\u4eec\u4f7f\u7528ActiveRecord\u4f5c\u4e3a\u5bf9\u8c61\u5173\u7cfb\u6620\u5c04\u5668\uff08O\/R Mapper\uff09\u3002<br \/>\n\uff08ActiveRecord\u662f\u5bf9\u8c61\u5173\u7cfb\u6620\u5c04\u5668\u5b9e\u73b0\u6a21\u5f0f\u7684\u540d\u79f0\uff0c\u5e76\u4e14\u4f7f\u7528\u76f8\u540c\u7684\u540d\u79f0\u3002\uff09<\/p>\n<p>\u8bf7\u6309\u4ee5\u4e0b\u8fc1\u79fb\u6587\u4ef6\u7684\u65b9\u5f0f\uff0c\u5728\u6a21\u578b\u4e2d\u521b\u5efa\u4e00\u4e2a\u540d\u4e3alock_version\u7684\u6574\u6570\u7c7b\u578b\u5217\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"c1\"># \u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3\u30d5\u30a1\u30a4\u30eb<\/span>\r\n<span class=\"err\">$<\/span> <span class=\"n\">cat<\/span> <span class=\"n\">db<\/span><span class=\"o\">\/<\/span><span class=\"n\">migrate<\/span><span class=\"o\">\/<\/span><span class=\"mi\">20180906171026<\/span><span class=\"n\">_create_users<\/span><span class=\"p\">.<\/span><span class=\"nf\">rb<\/span>\r\n<span class=\"k\">class<\/span> <span class=\"nc\">CreateUsers<\/span> <span class=\"o\">&lt;<\/span> <span class=\"no\">ActiveRecord<\/span><span class=\"o\">::<\/span><span class=\"no\">Migration<\/span><span class=\"p\">[<\/span><span class=\"mf\">5.1<\/span><span class=\"p\">]<\/span>\r\n  <span class=\"k\">def<\/span> <span class=\"nf\">change<\/span>\r\n    <span class=\"n\">create_table<\/span> <span class=\"ss\">:users<\/span> <span class=\"k\">do<\/span> <span class=\"o\">|<\/span><span class=\"n\">t<\/span><span class=\"o\">|<\/span>\r\n\r\n      <span class=\"n\">t<\/span><span class=\"p\">.<\/span><span class=\"nf\">string<\/span> <span class=\"ss\">:name<\/span><span class=\"p\">,<\/span> <span class=\"ss\">default: <\/span><span class=\"s1\">''<\/span>\r\n      <span class=\"n\">t<\/span><span class=\"p\">.<\/span><span class=\"nf\">timestamps<\/span>\r\n      <span class=\"n\">t<\/span><span class=\"p\">.<\/span><span class=\"nf\">integer<\/span> <span class=\"ss\">:lock_version<\/span>\r\n    <span class=\"k\">end<\/span>\r\n  <span class=\"k\">end<\/span>\r\n<span class=\"k\">end<\/span>\r\n<\/code><\/pre>\n<p>\u7136\u540e\uff0cActiveRecord \u5728\u4f7f\u7528 update \u65b9\u6cd5\u66f4\u65b0\u6570\u636e\u65f6\u4f1a\u9012\u589e\u5217\u7684 lock_version\uff0c\u4ee5\u5b9e\u73b0\u4e50\u89c2\u9501\u3002<\/p>\n<p>\u5982\u679c\u66f4\u65b0\u53d1\u751f\u51b2\u7a81\uff0c\u5c06\u4f1a\u5f15\u53d1 ActiveRecord::StaleObjectError\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"c1\"># update\u5b9f\u884c\u6642\u306eSQL\u3067\u4f8b\u5916\u767a\u751f\u52d5\u4f5c<\/span>\r\n<span class=\"c1\">## [\u30b9\u30ec\u30c3\u30c91] \u30e6\u30fc\u30b6(user1) \u3092\u4f5c\u6210<\/span>\r\n<span class=\"p\">[<\/span><span class=\"mi\">1<\/span><span class=\"p\">]<\/span> <span class=\"n\">pry<\/span><span class=\"p\">(<\/span><span class=\"n\">main<\/span><span class=\"p\">)<\/span><span class=\"o\">&gt;<\/span> <span class=\"n\">user1<\/span> <span class=\"o\">=<\/span> <span class=\"no\">User<\/span><span class=\"p\">.<\/span><span class=\"nf\">create!<\/span><span class=\"p\">(<\/span><span class=\"ss\">name: <\/span><span class=\"s1\">'test'<\/span><span class=\"p\">)<\/span>\r\n   <span class=\"p\">(<\/span><span class=\"mf\">0.0<\/span><span class=\"n\">ms<\/span><span class=\"p\">)<\/span>  <span class=\"no\">SAVEPOINT<\/span> <span class=\"n\">active_record_1<\/span>\r\n  <span class=\"no\">SQL<\/span> <span class=\"p\">(<\/span><span class=\"mf\">0.6<\/span><span class=\"n\">ms<\/span><span class=\"p\">)<\/span>  <span class=\"no\">INSERT<\/span> <span class=\"no\">INTO<\/span> <span class=\"s2\">\"users\"<\/span> <span class=\"p\">(<\/span><span class=\"s2\">\"name\"<\/span><span class=\"p\">,<\/span> <span class=\"s2\">\"created_at\"<\/span><span class=\"p\">,<\/span> <span class=\"s2\">\"updated_at\"<\/span><span class=\"p\">,<\/span> <span class=\"s2\">\"lock_version\"<\/span><span class=\"p\">)<\/span> <span class=\"no\">VALUES<\/span> <span class=\"p\">(<\/span><span class=\"sc\">?,<\/span> <span class=\"p\">?,<\/span> <span class=\"sc\">?,<\/span> <span class=\"p\">?)<\/span>  <span class=\"p\">[[<\/span><span class=\"s2\">\"name\"<\/span><span class=\"p\">,<\/span> <span class=\"s2\">\"test\"<\/span><span class=\"p\">],<\/span> <span class=\"p\">[<\/span><span class=\"s2\">\"created_at\"<\/span><span class=\"p\">,<\/span> <span class=\"s2\">\"2018-09-06 17:23:40.408881\"<\/span><span class=\"p\">],<\/span> <span class=\"p\">[<\/span><span class=\"s2\">\"updated_at\"<\/span><span class=\"p\">,<\/span> <span class=\"s2\">\"2018-09-06 17:23:40.408881\"<\/span><span class=\"p\">],<\/span> <span class=\"p\">[<\/span><span class=\"s2\">\"lock_version\"<\/span><span class=\"p\">,<\/span> <span class=\"mi\">0<\/span><span class=\"p\">]]<\/span>\r\n   <span class=\"p\">(<\/span><span class=\"mf\">0.1<\/span><span class=\"n\">ms<\/span><span class=\"p\">)<\/span>  <span class=\"no\">RELEASE<\/span> <span class=\"no\">SAVEPOINT<\/span> <span class=\"n\">active_record_1<\/span>\r\n<span class=\"o\">=&gt;<\/span> <span class=\"c1\">#&lt;User:0x00007fb2786676f0<\/span>\r\n <span class=\"ss\">id: <\/span><span class=\"mi\">1<\/span><span class=\"p\">,<\/span>\r\n <span class=\"ss\">name: <\/span><span class=\"s2\">\"test\"<\/span><span class=\"p\">,<\/span>\r\n <span class=\"ss\">created_at: <\/span><span class=\"no\">Thu<\/span><span class=\"p\">,<\/span> <span class=\"mo\">06<\/span> <span class=\"no\">Sep<\/span> <span class=\"mi\">2018<\/span> <span class=\"mi\">17<\/span><span class=\"p\">:<\/span><span class=\"mi\">23<\/span><span class=\"p\">:<\/span><span class=\"mi\">40<\/span> <span class=\"no\">UTC<\/span> <span class=\"o\">+<\/span><span class=\"mo\">00<\/span><span class=\"p\">:<\/span><span class=\"mo\">00<\/span><span class=\"p\">,<\/span>\r\n <span class=\"ss\">updated_at: <\/span><span class=\"no\">Thu<\/span><span class=\"p\">,<\/span> <span class=\"mo\">06<\/span> <span class=\"no\">Sep<\/span> <span class=\"mi\">2018<\/span> <span class=\"mi\">17<\/span><span class=\"p\">:<\/span><span class=\"mi\">23<\/span><span class=\"p\">:<\/span><span class=\"mi\">40<\/span> <span class=\"no\">UTC<\/span> <span class=\"o\">+<\/span><span class=\"mo\">00<\/span><span class=\"p\">:<\/span><span class=\"mo\">00<\/span><span class=\"p\">,<\/span>\r\n <span class=\"ss\">lock_version: <\/span><span class=\"mi\">0<\/span><span class=\"o\">&gt;<\/span>\r\n\r\n<span class=\"c1\">## [\u30b9\u30ec\u30c3\u30c92] \u30e6\u30fc\u30b6(user1) \u3092\u53c2\u7167<\/span>\r\n<span class=\"p\">[<\/span><span class=\"mi\">2<\/span><span class=\"p\">]<\/span> <span class=\"n\">pry<\/span><span class=\"p\">(<\/span><span class=\"n\">main<\/span><span class=\"p\">)<\/span><span class=\"o\">&gt;<\/span> <span class=\"n\">user2<\/span> <span class=\"o\">=<\/span> <span class=\"no\">User<\/span><span class=\"p\">.<\/span><span class=\"nf\">find<\/span><span class=\"p\">(<\/span><span class=\"mi\">1<\/span><span class=\"p\">)<\/span>\r\n  <span class=\"no\">User<\/span> <span class=\"no\">Load<\/span> <span class=\"p\">(<\/span><span class=\"mf\">0.2<\/span><span class=\"n\">ms<\/span><span class=\"p\">)<\/span>  <span class=\"no\">SELECT<\/span>  <span class=\"s2\">\"users\"<\/span><span class=\"p\">.<\/span><span class=\"nf\">*<\/span> <span class=\"no\">FROM<\/span> <span class=\"s2\">\"users\"<\/span> <span class=\"no\">WHERE<\/span> <span class=\"s2\">\"users\"<\/span><span class=\"o\">.<\/span><span class=\"s2\">\"id\"<\/span> <span class=\"o\">=<\/span> <span class=\"p\">?<\/span> <span class=\"no\">LIMIT<\/span> <span class=\"p\">?<\/span>  <span class=\"p\">[[<\/span><span class=\"s2\">\"id\"<\/span><span class=\"p\">,<\/span> <span class=\"mi\">1<\/span><span class=\"p\">],<\/span> <span class=\"p\">[<\/span><span class=\"s2\">\"LIMIT\"<\/span><span class=\"p\">,<\/span> <span class=\"mi\">1<\/span><span class=\"p\">]]<\/span>\r\n<span class=\"o\">=&gt;<\/span> <span class=\"c1\">#&lt;User:0x00005605bcfecaf0<\/span>\r\n <span class=\"ss\">id: <\/span><span class=\"mi\">1<\/span><span class=\"p\">,<\/span>\r\n <span class=\"ss\">name: <\/span><span class=\"s2\">\"test\"<\/span><span class=\"p\">,<\/span>\r\n <span class=\"ss\">created_at: <\/span><span class=\"no\">Thu<\/span><span class=\"p\">,<\/span> <span class=\"mo\">06<\/span> <span class=\"no\">Sep<\/span> <span class=\"mi\">2018<\/span> <span class=\"mi\">17<\/span><span class=\"p\">:<\/span><span class=\"mi\">23<\/span><span class=\"p\">:<\/span><span class=\"mi\">40<\/span> <span class=\"no\">UTC<\/span> <span class=\"o\">+<\/span><span class=\"mo\">00<\/span><span class=\"p\">:<\/span><span class=\"mo\">00<\/span><span class=\"p\">,<\/span>\r\n <span class=\"ss\">updated_at: <\/span><span class=\"no\">Thu<\/span><span class=\"p\">,<\/span> <span class=\"mo\">06<\/span> <span class=\"no\">Sep<\/span> <span class=\"mi\">2018<\/span> <span class=\"mi\">17<\/span><span class=\"p\">:<\/span><span class=\"mi\">23<\/span><span class=\"p\">:<\/span><span class=\"mi\">40<\/span> <span class=\"no\">UTC<\/span> <span class=\"o\">+<\/span><span class=\"mo\">00<\/span><span class=\"p\">:<\/span><span class=\"mo\">00<\/span><span class=\"p\">,<\/span>\r\n <span class=\"ss\">lock_version: <\/span><span class=\"mi\">0<\/span><span class=\"o\">&gt;<\/span>\r\n\r\n<span class=\"c1\">## [\u30b9\u30ec\u30c3\u30c91] \u30e6\u30fc\u30b6(user1) \u306e name \u3092 test2 \u306b\u66f4\u65b0<\/span>\r\n<span class=\"p\">[<\/span><span class=\"mi\">3<\/span><span class=\"p\">]<\/span> <span class=\"n\">pry<\/span><span class=\"p\">(<\/span><span class=\"n\">main<\/span><span class=\"p\">)<\/span><span class=\"o\">&gt;<\/span> <span class=\"n\">user1<\/span><span class=\"p\">.<\/span><span class=\"nf\">update<\/span><span class=\"p\">(<\/span><span class=\"ss\">name: <\/span><span class=\"s1\">'test2'<\/span><span class=\"p\">)<\/span>\r\n   <span class=\"p\">(<\/span><span class=\"mf\">0.1<\/span><span class=\"n\">ms<\/span><span class=\"p\">)<\/span>  <span class=\"no\">SAVEPOINT<\/span> <span class=\"n\">active_record_1<\/span>\r\n  <span class=\"no\">SQL<\/span> <span class=\"p\">(<\/span><span class=\"mf\">0.2<\/span><span class=\"n\">ms<\/span><span class=\"p\">)<\/span>  <span class=\"no\">UPDATE<\/span> <span class=\"s2\">\"users\"<\/span> <span class=\"no\">SET<\/span> <span class=\"s2\">\"name\"<\/span> <span class=\"o\">=<\/span> <span class=\"sc\">?,<\/span> <span class=\"s2\">\"updated_at\"<\/span> <span class=\"o\">=<\/span> <span class=\"sc\">?,<\/span> <span class=\"s2\">\"lock_version\"<\/span> <span class=\"o\">=<\/span> <span class=\"p\">?<\/span> <span class=\"no\">WHERE<\/span> <span class=\"s2\">\"users\"<\/span><span class=\"o\">.<\/span><span class=\"s2\">\"id\"<\/span> <span class=\"o\">=<\/span> <span class=\"p\">?<\/span> <span class=\"no\">AND<\/span> <span class=\"s2\">\"users\"<\/span><span class=\"o\">.<\/span><span class=\"s2\">\"lock_version\"<\/span> <span class=\"o\">=<\/span> <span class=\"p\">?<\/span>  <span class=\"p\">[[<\/span><span class=\"s2\">\"name\"<\/span><span class=\"p\">,<\/span> <span class=\"s2\">\"test2\"<\/span><span class=\"p\">],<\/span> <span class=\"p\">[<\/span><span class=\"s2\">\"updated_at\"<\/span><span class=\"p\">,<\/span> <span class=\"s2\">\"2018-09-06 17:24:07.820275\"<\/span><span class=\"p\">],<\/span> <span class=\"p\">[<\/span><span class=\"s2\">\"lock_version\"<\/span><span class=\"p\">,<\/span> <span class=\"mi\">1<\/span><span class=\"p\">],<\/span> <span class=\"p\">[<\/span><span class=\"s2\">\"id\"<\/span><span class=\"p\">,<\/span> <span class=\"mi\">1<\/span><span class=\"p\">],<\/span> <span class=\"p\">[<\/span><span class=\"s2\">\"lock_version\"<\/span><span class=\"p\">,<\/span> <span class=\"mi\">0<\/span><span class=\"p\">]]<\/span>\r\n   <span class=\"p\">(<\/span><span class=\"mf\">0.1<\/span><span class=\"n\">ms<\/span><span class=\"p\">)<\/span>  <span class=\"no\">RELEASE<\/span> <span class=\"no\">SAVEPOINT<\/span> <span class=\"n\">active_record_1<\/span>\r\n<span class=\"o\">=&gt;<\/span> <span class=\"kp\">true<\/span>\r\n\r\n<span class=\"c1\">## [\u30b9\u30ec\u30c3\u30c92] \u30e6\u30fc\u30b6(user1) \u306e namae \u3092 test3 \u306b\u66f4\u65b0(\u2605\u4f8b\u5916\u767a\u751f)<\/span>\r\n<span class=\"p\">[<\/span><span class=\"mi\">4<\/span><span class=\"p\">]<\/span> <span class=\"n\">pry<\/span><span class=\"p\">(<\/span><span class=\"n\">main<\/span><span class=\"p\">)<\/span><span class=\"o\">&gt;<\/span> <span class=\"n\">user2<\/span><span class=\"p\">.<\/span><span class=\"nf\">update<\/span><span class=\"p\">(<\/span><span class=\"ss\">name: <\/span><span class=\"s1\">'test3'<\/span><span class=\"p\">)<\/span>\r\n   <span class=\"p\">(<\/span><span class=\"mf\">0.1<\/span><span class=\"n\">ms<\/span><span class=\"p\">)<\/span>  <span class=\"no\">SAVEPOINT<\/span> <span class=\"n\">active_record_1<\/span>\r\n  <span class=\"no\">SQL<\/span> <span class=\"p\">(<\/span><span class=\"mf\">0.2<\/span><span class=\"n\">ms<\/span><span class=\"p\">)<\/span>  <span class=\"no\">UPDATE<\/span> <span class=\"s2\">\"users\"<\/span> <span class=\"no\">SET<\/span> <span class=\"s2\">\"name\"<\/span> <span class=\"o\">=<\/span> <span class=\"sc\">?,<\/span> <span class=\"s2\">\"updated_at\"<\/span> <span class=\"o\">=<\/span> <span class=\"sc\">?,<\/span> <span class=\"s2\">\"lock_version\"<\/span> <span class=\"o\">=<\/span> <span class=\"p\">?<\/span> <span class=\"no\">WHERE<\/span> <span class=\"s2\">\"users\"<\/span><span class=\"o\">.<\/span><span class=\"s2\">\"id\"<\/span> <span class=\"o\">=<\/span> <span class=\"p\">?<\/span> <span class=\"no\">AND<\/span> <span class=\"s2\">\"users\"<\/span><span class=\"o\">.<\/span><span class=\"s2\">\"lock_version\"<\/span> <span class=\"o\">=<\/span> <span class=\"p\">?<\/span>  <span class=\"p\">[[<\/span><span class=\"s2\">\"name\"<\/span><span class=\"p\">,<\/span> <span class=\"s2\">\"test3\"<\/span><span class=\"p\">],<\/span> <span class=\"p\">[<\/span><span class=\"s2\">\"updated_at\"<\/span><span class=\"p\">,<\/span> <span class=\"s2\">\"2018-09-06 17:24:15.752651\"<\/span><span class=\"p\">],<\/span> <span class=\"p\">[<\/span><span class=\"s2\">\"lock_version\"<\/span><span class=\"p\">,<\/span> <span class=\"mi\">1<\/span><span class=\"p\">],<\/span> <span class=\"p\">[<\/span><span class=\"s2\">\"id\"<\/span><span class=\"p\">,<\/span> <span class=\"mi\">1<\/span><span class=\"p\">],<\/span> <span class=\"p\">[<\/span><span class=\"s2\">\"lock_version\"<\/span><span class=\"p\">,<\/span> <span class=\"mi\">0<\/span><span class=\"p\">]]<\/span>\r\n   <span class=\"p\">(<\/span><span class=\"mf\">0.1<\/span><span class=\"n\">ms<\/span><span class=\"p\">)<\/span>  <span class=\"no\">ROLLBACK<\/span> <span class=\"no\">TO<\/span> <span class=\"no\">SAVEPOINT<\/span> <span class=\"n\">active_record_1<\/span>\r\n<span class=\"no\">ActiveRecord<\/span><span class=\"o\">::<\/span><span class=\"no\">StaleObjectError<\/span><span class=\"p\">:<\/span> <span class=\"no\">Attempted<\/span> <span class=\"n\">to<\/span> <span class=\"n\">update<\/span> <span class=\"n\">a<\/span> <span class=\"n\">stale<\/span> <span class=\"ss\">object: <\/span><span class=\"no\">User<\/span><span class=\"p\">.<\/span>\r\n<span class=\"nf\">from<\/span> <span class=\"sr\">\/usr\/<\/span><span class=\"n\">local<\/span><span class=\"o\">\/<\/span><span class=\"n\">src<\/span><span class=\"o\">\/<\/span><span class=\"n\">rails<\/span><span class=\"o\">-<\/span><span class=\"n\">sample<\/span><span class=\"o\">\/<\/span><span class=\"n\">vendor<\/span><span class=\"o\">\/<\/span><span class=\"n\">bundle<\/span><span class=\"o\">\/<\/span><span class=\"n\">ruby<\/span><span class=\"o\">\/<\/span><span class=\"mf\">2.5<\/span><span class=\"o\">.<\/span><span class=\"mi\">0<\/span><span class=\"o\">\/<\/span><span class=\"n\">gems<\/span><span class=\"o\">\/<\/span><span class=\"n\">activerecord<\/span><span class=\"o\">-<\/span><span class=\"mf\">5.1<\/span><span class=\"o\">.<\/span><span class=\"mi\">6<\/span><span class=\"o\">\/<\/span><span class=\"n\">lib<\/span><span class=\"o\">\/<\/span><span class=\"n\">active_record<\/span><span class=\"o\">\/<\/span><span class=\"n\">locking<\/span><span class=\"o\">\/<\/span><span class=\"n\">optimistic<\/span><span class=\"p\">.<\/span><span class=\"nf\">rb<\/span><span class=\"p\">:<\/span><span class=\"mi\">95<\/span><span class=\"p\">:<\/span><span class=\"k\">in<\/span> <span class=\"sb\">`_update_row'\r\n<\/span><\/code><\/pre>\n<h2>\u5173\u4e8eGrails\u7684\u60c5\u51b5<\/h2>\n<p>\u5728Grails\u4e2d\uff0c\u6211\u4eec\u4f7f\u7528GORM\u4f5c\u4e3a\u5bf9\u8c61\u5173\u7cfb\u6620\u5c04\u5de5\u5177\uff08O\/R Mapper\uff09\u3002<br \/>\nGORM\u5728\u8bbf\u95eeSQL\u6570\u636e\u5e93\u65f6\u4f1a\u4f7f\u7528Hibernate\u3002<\/p>\n<p>\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u5728\u57df\u7c7b\u4e2d\u6dfb\u52a0\u4e86version\u5c5e\u6027\uff0c\u5e76\u5c06\u5176\u7528\u4f5c\u4e50\u89c2\u9501\u7684\u7248\u672c\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"err\">#<\/span> <span class=\"n\">User<\/span><span class=\"err\">\u30c9\u30e1\u30a4\u30f3<\/span>\r\n<span class=\"kn\">package<\/span> <span class=\"nn\">grails.sample.app<\/span>\r\n\r\n<span class=\"kd\">class<\/span> <span class=\"nc\">User<\/span> <span class=\"o\">{<\/span>\r\n\r\n  <span class=\"n\">String<\/span> <span class=\"n\">name<\/span>\r\n\r\n  <span class=\"kd\">static<\/span> <span class=\"n\">constraints<\/span> <span class=\"o\">=<\/span> <span class=\"o\">{<\/span>\r\n  <span class=\"o\">}<\/span>\r\n<span class=\"o\">}<\/span>\r\n<\/code><\/pre>\n<p>\u4e0d\u9700\u8981\u5728\u57df\u7c7b\u4e2d\u660e\u786e\u6307\u5b9aversion\u5b57\u6bb5\uff0c\u5b83\u5c06\u9ed8\u8ba4\u6dfb\u52a0\u3002\uff08\u5982\u679c\u4e0d\u60f3\u4f7f\u7528\u4e50\u89c2\u9501\uff0c\u9700\u8981\u5728\u6620\u5c04\u4e2d\u6307\u5b9aversion false\uff09<\/p>\n<pre class=\"post-pre\"><code><span class=\"c1\">\/\/ User\u30c9\u30e1\u30a4\u30f3\u306e name \u3092 test2 \u306b\u5909\u66f4<\/span>\r\n<span class=\"kt\">def<\/span> <span class=\"n\">user<\/span> <span class=\"o\">=<\/span> <span class=\"n\">User<\/span><span class=\"o\">.<\/span><span class=\"na\">get<\/span><span class=\"o\">(<\/span><span class=\"mi\">1<\/span><span class=\"o\">)<\/span>\r\n<span class=\"n\">println<\/span> <span class=\"s1\">'name: '<\/span> <span class=\"o\">+<\/span> <span class=\"n\">user<\/span><span class=\"o\">.<\/span><span class=\"na\">name<\/span> <span class=\"o\">+<\/span> <span class=\"s1\">', version: '<\/span> <span class=\"o\">+<\/span> <span class=\"n\">user<\/span><span class=\"o\">.<\/span><span class=\"na\">version<\/span>\r\n<span class=\"n\">user<\/span><span class=\"o\">.<\/span><span class=\"na\">name<\/span> <span class=\"o\">=<\/span> <span class=\"s1\">'test2'<\/span>\r\n<span class=\"n\">user<\/span><span class=\"o\">.<\/span><span class=\"na\">save<\/span><span class=\"o\">(<\/span><span class=\"nl\">flush:<\/span> <span class=\"kc\">true<\/span><span class=\"o\">)<\/span>\r\n<span class=\"n\">println<\/span> <span class=\"s1\">'name: '<\/span> <span class=\"o\">+<\/span> <span class=\"n\">user<\/span><span class=\"o\">.<\/span><span class=\"na\">name<\/span> <span class=\"o\">+<\/span> <span class=\"s1\">', version: '<\/span> <span class=\"o\">+<\/span> <span class=\"n\">user<\/span><span class=\"o\">.<\/span><span class=\"na\">version<\/span>\r\n\r\n<span class=\"c1\">\/\/ \u5b9f\u884c\u7d50\u679c<\/span>\r\n<span class=\"nl\">name:<\/span> <span class=\"n\">test<\/span><span class=\"o\">,<\/span> <span class=\"nl\">version:<\/span> <span class=\"mi\">40<\/span>\r\n<span class=\"nl\">name:<\/span> <span class=\"n\">test2<\/span><span class=\"o\">,<\/span> <span class=\"nl\">version:<\/span> <span class=\"mi\">41<\/span>\r\n<\/code><\/pre>\n<p>\u5f53\u6709\u4f8b\u5916\u53d1\u751f\u65f6\uff0c\u5c06\u4f1a\u629b\u51fa org.springframework.dao.OptimisticLockingFailureException \u9519\u8bef\u3002<\/p>\n<h2>\u5728\u4f7f\u7528SQLAlchemy\u7684\u60c5\u51b5\u4e0b<\/h2>\n<p>SQLAlchemy\u662f\u4e00\u6b3e\u7528\u4e8ePython\u7684SQL\u5de5\u5177\u5305\uff0c\u5176\u4e2d\u5305\u62ec\u5bf9\u8c61\u5173\u7cfb\u6620\u5c04\u5668\u3002<\/p>\n<p>\u53ef\u4ee5\u4f7f\u7528\u4efb\u610f\u5b57\u6bb5\uff08\u5982 BigInteger \u7c7b\u578b\uff09\u5728\u6a21\u578b\u4e2d\u4fdd\u5b58\u6570\u503c\uff0c\u5c31\u50cf\u4e0b\u9762\u7684\u6587\u4ef6\u4e00\u6837\uff0c\u5e76\u5728 __mapper_args__ \u7684\u5b9a\u4e49\u5185\u8bbe\u7f6e version_id_col\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"kn\">from<\/span> <span class=\"nn\">sqlalchemy<\/span> <span class=\"kn\">import<\/span> <span class=\"o\">*<\/span>\r\n<span class=\"kn\">from<\/span> <span class=\"nn\">sqlalchemy.orm<\/span> <span class=\"kn\">import<\/span> <span class=\"o\">*<\/span>\r\n<span class=\"kn\">from<\/span> <span class=\"nn\">sqlalchemy.ext.declarative<\/span> <span class=\"kn\">import<\/span> <span class=\"n\">declarative_base<\/span>\r\n<span class=\"kn\">from<\/span> <span class=\"nn\">sqlalchemy<\/span> <span class=\"kn\">import<\/span> <span class=\"n\">Column<\/span><span class=\"p\">,<\/span> <span class=\"n\">Integer<\/span><span class=\"p\">,<\/span> <span class=\"n\">String<\/span>\r\n\r\n<span class=\"k\">class<\/span> <span class=\"nc\">User<\/span><span class=\"p\">(<\/span><span class=\"n\">Base<\/span><span class=\"p\">):<\/span>\r\n  <span class=\"n\">__tablename__<\/span> <span class=\"o\">=<\/span> <span class=\"s\">'users'<\/span>\r\n\r\n  <span class=\"nb\">id<\/span> <span class=\"o\">=<\/span> <span class=\"n\">Column<\/span><span class=\"p\">(<\/span><span class=\"s\">'id'<\/span><span class=\"p\">,<\/span> <span class=\"n\">Integer<\/span><span class=\"p\">,<\/span> <span class=\"n\">primary_key<\/span> <span class=\"o\">=<\/span> <span class=\"bp\">True<\/span><span class=\"p\">)<\/span>\r\n  <span class=\"n\">name<\/span> <span class=\"o\">=<\/span> <span class=\"n\">Column<\/span><span class=\"p\">(<\/span><span class=\"s\">'name'<\/span><span class=\"p\">,<\/span> <span class=\"n\">String<\/span><span class=\"p\">(<\/span><span class=\"mi\">200<\/span><span class=\"p\">))<\/span>\r\n  <span class=\"n\">version_id<\/span> <span class=\"o\">=<\/span> <span class=\"n\">Column<\/span><span class=\"p\">(<\/span><span class=\"n\">BigInteger<\/span><span class=\"p\">,<\/span> <span class=\"n\">nullable<\/span><span class=\"o\">=<\/span><span class=\"bp\">False<\/span><span class=\"p\">)<\/span>\r\n\r\n  <span class=\"n\">__mapper_args__<\/span> <span class=\"o\">=<\/span> <span class=\"p\">{<\/span>\r\n    <span class=\"s\">'version_id_col'<\/span><span class=\"p\">:<\/span> <span class=\"n\">version_id<\/span>\r\n  <span class=\"p\">}<\/span>\r\n<\/code><\/pre>\n<p>\u7136\u540e\uff0cSQLAlchemy\u4f1a\u5728\u4f1a\u8bdd\u63d0\u4ea4\u5e76\u66f4\u65b0\u6570\u636e\u65f6\u9012\u589e\u5217\u7248\u672c\u53f7\uff08version_id\uff09\uff0c\u4ece\u800c\u5b9e\u73b0\u4e50\u89c2\u9501\u3002<\/p>\n<p>\u5982\u679c\u5b58\u5728\u66f4\u65b0\u51b2\u7a81\u7684\u60c5\u51b5\uff0c\u4f1a\u89e6\u53d1 sqlalchemy.orm.exc.StaleDataError\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"c1\"># \u30b9\u30ec\u30c3\u30c91\r\n## \u30e2\u30c7\u30eb\u30d5\u30a1\u30a4\u30eb\u3068 DB Connector \u306e\u8aad\u307f\u8fbc\u307f\r\n<\/span><span class=\"o\">&gt;&gt;&gt;<\/span> <span class=\"kn\">from<\/span> <span class=\"nn\">setting<\/span> <span class=\"kn\">import<\/span> <span class=\"n\">session<\/span>\r\n<span class=\"o\">&gt;&gt;&gt;<\/span> <span class=\"kn\">from<\/span> <span class=\"nn\">user<\/span> <span class=\"kn\">import<\/span> <span class=\"o\">*<\/span>\r\n\r\n<span class=\"c1\">## User \u306e name \u3092 test \u3068\u3057\u3066\u4f5c\u6210\r\n<\/span><span class=\"o\">&gt;&gt;&gt;<\/span> <span class=\"n\">user<\/span> <span class=\"o\">=<\/span> <span class=\"n\">User<\/span><span class=\"p\">()<\/span>\r\n<span class=\"o\">&gt;&gt;&gt;<\/span> <span class=\"n\">user<\/span><span class=\"p\">.<\/span><span class=\"n\">name<\/span> <span class=\"o\">=<\/span> <span class=\"s\">'test'<\/span>\r\n<span class=\"o\">&gt;&gt;&gt;<\/span> <span class=\"n\">session<\/span><span class=\"p\">.<\/span><span class=\"n\">add<\/span><span class=\"p\">(<\/span><span class=\"n\">user<\/span><span class=\"p\">)<\/span>\r\n<span class=\"o\">&gt;&gt;&gt;<\/span> <span class=\"n\">session<\/span><span class=\"p\">.<\/span><span class=\"n\">commit<\/span><span class=\"p\">()<\/span>\r\n\r\n<span class=\"c1\">## User \u306e name \u3092 test6 \u3078\u5909\u66f4\r\n<\/span><span class=\"o\">&gt;&gt;&gt;<\/span> <span class=\"n\">user<\/span><span class=\"p\">.<\/span><span class=\"n\">name<\/span> <span class=\"o\">=<\/span> <span class=\"s\">'test6'<\/span>\r\n<span class=\"o\">&gt;&gt;&gt;<\/span> <span class=\"n\">session<\/span><span class=\"p\">.<\/span><span class=\"n\">commit<\/span><span class=\"p\">()<\/span>\r\n<span class=\"mi\">2018<\/span><span class=\"o\">-<\/span><span class=\"mi\">09<\/span><span class=\"o\">-<\/span><span class=\"mi\">11<\/span> <span class=\"mi\">03<\/span><span class=\"p\">:<\/span><span class=\"mi\">34<\/span><span class=\"p\">:<\/span><span class=\"mi\">45<\/span><span class=\"p\">,<\/span><span class=\"mi\">280<\/span> <span class=\"n\">INFO<\/span> <span class=\"n\">sqlalchemy<\/span><span class=\"p\">.<\/span><span class=\"n\">engine<\/span><span class=\"p\">.<\/span><span class=\"n\">base<\/span><span class=\"p\">.<\/span><span class=\"n\">Engine<\/span> <span class=\"n\">UPDATE<\/span> <span class=\"n\">users<\/span> <span class=\"n\">SET<\/span> <span class=\"n\">name<\/span><span class=\"o\">=%<\/span><span class=\"n\">s<\/span><span class=\"p\">,<\/span> <span class=\"n\">version_id<\/span><span class=\"o\">=%<\/span><span class=\"n\">s<\/span> <span class=\"n\">WHERE<\/span> <span class=\"n\">users<\/span><span class=\"p\">.<\/span><span class=\"nb\">id<\/span> <span class=\"o\">=<\/span> <span class=\"o\">%<\/span><span class=\"n\">s<\/span> <span class=\"n\">AND<\/span> <span class=\"n\">users<\/span><span class=\"p\">.<\/span><span class=\"n\">version_id<\/span> <span class=\"o\">=<\/span> <span class=\"o\">%<\/span><span class=\"n\">s<\/span>\r\n<span class=\"mi\">2018<\/span><span class=\"o\">-<\/span><span class=\"mi\">09<\/span><span class=\"o\">-<\/span><span class=\"mi\">11<\/span> <span class=\"mi\">03<\/span><span class=\"p\">:<\/span><span class=\"mi\">34<\/span><span class=\"p\">:<\/span><span class=\"mi\">45<\/span><span class=\"p\">,<\/span><span class=\"mi\">280<\/span> <span class=\"n\">INFO<\/span> <span class=\"n\">sqlalchemy<\/span><span class=\"p\">.<\/span><span class=\"n\">engine<\/span><span class=\"p\">.<\/span><span class=\"n\">base<\/span><span class=\"p\">.<\/span><span class=\"n\">Engine<\/span> <span class=\"p\">(<\/span><span class=\"s\">'test6'<\/span><span class=\"p\">,<\/span> <span class=\"mi\">4<\/span><span class=\"p\">,<\/span> <span class=\"mi\">1<\/span><span class=\"p\">,<\/span> <span class=\"mi\">3<\/span><span class=\"p\">)<\/span>\r\n<span class=\"mi\">2018<\/span><span class=\"o\">-<\/span><span class=\"mi\">09<\/span><span class=\"o\">-<\/span><span class=\"mi\">11<\/span> <span class=\"mi\">03<\/span><span class=\"p\">:<\/span><span class=\"mi\">34<\/span><span class=\"p\">:<\/span><span class=\"mi\">45<\/span><span class=\"p\">,<\/span><span class=\"mi\">281<\/span> <span class=\"n\">INFO<\/span> <span class=\"n\">sqlalchemy<\/span><span class=\"p\">.<\/span><span class=\"n\">engine<\/span><span class=\"p\">.<\/span><span class=\"n\">base<\/span><span class=\"p\">.<\/span><span class=\"n\">Engine<\/span> <span class=\"n\">COMMIT<\/span>\r\n<span class=\"o\">&gt;&gt;&gt;<\/span> \r\n<\/code><\/pre>\n<pre class=\"post-pre\"><code><span class=\"c1\"># \u30b9\u30ec\u30c3\u30c92\r\n## \u30e2\u30c7\u30eb\u30d5\u30a1\u30a4\u30eb\u3068 DB Connector \u306e\u8aad\u307f\u8fbc\u307f\r\n<\/span><span class=\"o\">&gt;&gt;&gt;<\/span> <span class=\"kn\">from<\/span> <span class=\"nn\">setting<\/span> <span class=\"kn\">import<\/span> <span class=\"n\">session<\/span>\r\n<span class=\"o\">&gt;&gt;&gt;<\/span> <span class=\"kn\">from<\/span> <span class=\"nn\">user<\/span> <span class=\"kn\">import<\/span> <span class=\"o\">*<\/span>\r\n\r\n<span class=\"c1\">## User \u3092\u53d6\u5f97\r\n<\/span><span class=\"o\">&gt;&gt;&gt;<\/span> <span class=\"n\">user<\/span> <span class=\"o\">=<\/span> <span class=\"n\">session<\/span><span class=\"p\">.<\/span><span class=\"n\">query<\/span><span class=\"p\">(<\/span><span class=\"n\">User<\/span><span class=\"p\">).<\/span><span class=\"nb\">filter<\/span><span class=\"p\">(<\/span><span class=\"n\">User<\/span><span class=\"p\">.<\/span><span class=\"nb\">id<\/span><span class=\"o\">==<\/span><span class=\"mi\">1<\/span><span class=\"p\">).<\/span><span class=\"n\">first<\/span><span class=\"p\">()<\/span>\r\n<span class=\"mi\">2018<\/span><span class=\"o\">-<\/span><span class=\"mi\">09<\/span><span class=\"o\">-<\/span><span class=\"mi\">11<\/span> <span class=\"mi\">03<\/span><span class=\"p\">:<\/span><span class=\"mi\">33<\/span><span class=\"p\">:<\/span><span class=\"mi\">34<\/span><span class=\"p\">,<\/span><span class=\"mi\">195<\/span> <span class=\"n\">INFO<\/span> <span class=\"n\">sqlalchemy<\/span><span class=\"p\">.<\/span><span class=\"n\">engine<\/span><span class=\"p\">.<\/span><span class=\"n\">base<\/span><span class=\"p\">.<\/span><span class=\"n\">Engine<\/span> <span class=\"n\">SHOW<\/span> <span class=\"n\">VARIABLES<\/span> <span class=\"n\">LIKE<\/span> <span class=\"s\">'sql_mode'<\/span>\r\n<span class=\"mi\">2018<\/span><span class=\"o\">-<\/span><span class=\"mi\">09<\/span><span class=\"o\">-<\/span><span class=\"mi\">11<\/span> <span class=\"mi\">03<\/span><span class=\"p\">:<\/span><span class=\"mi\">33<\/span><span class=\"p\">:<\/span><span class=\"mi\">34<\/span><span class=\"p\">,<\/span><span class=\"mi\">196<\/span> <span class=\"n\">INFO<\/span> <span class=\"n\">sqlalchemy<\/span><span class=\"p\">.<\/span><span class=\"n\">engine<\/span><span class=\"p\">.<\/span><span class=\"n\">base<\/span><span class=\"p\">.<\/span><span class=\"n\">Engine<\/span> <span class=\"p\">()<\/span>\r\n<span class=\"mi\">2018<\/span><span class=\"o\">-<\/span><span class=\"mi\">09<\/span><span class=\"o\">-<\/span><span class=\"mi\">11<\/span> <span class=\"mi\">03<\/span><span class=\"p\">:<\/span><span class=\"mi\">33<\/span><span class=\"p\">:<\/span><span class=\"mi\">34<\/span><span class=\"p\">,<\/span><span class=\"mi\">198<\/span> <span class=\"n\">INFO<\/span> <span class=\"n\">sqlalchemy<\/span><span class=\"p\">.<\/span><span class=\"n\">engine<\/span><span class=\"p\">.<\/span><span class=\"n\">base<\/span><span class=\"p\">.<\/span><span class=\"n\">Engine<\/span> <span class=\"n\">SELECT<\/span> <span class=\"n\">DATABASE<\/span><span class=\"p\">()<\/span>\r\n<span class=\"mi\">2018<\/span><span class=\"o\">-<\/span><span class=\"mi\">09<\/span><span class=\"o\">-<\/span><span class=\"mi\">11<\/span> <span class=\"mi\">03<\/span><span class=\"p\">:<\/span><span class=\"mi\">33<\/span><span class=\"p\">:<\/span><span class=\"mi\">34<\/span><span class=\"p\">,<\/span><span class=\"mi\">198<\/span> <span class=\"n\">INFO<\/span> <span class=\"n\">sqlalchemy<\/span><span class=\"p\">.<\/span><span class=\"n\">engine<\/span><span class=\"p\">.<\/span><span class=\"n\">base<\/span><span class=\"p\">.<\/span><span class=\"n\">Engine<\/span> <span class=\"p\">()<\/span>\r\n<span class=\"mi\">2018<\/span><span class=\"o\">-<\/span><span class=\"mi\">09<\/span><span class=\"o\">-<\/span><span class=\"mi\">11<\/span> <span class=\"mi\">03<\/span><span class=\"p\">:<\/span><span class=\"mi\">33<\/span><span class=\"p\">:<\/span><span class=\"mi\">34<\/span><span class=\"p\">,<\/span><span class=\"mi\">198<\/span> <span class=\"n\">INFO<\/span> <span class=\"n\">sqlalchemy<\/span><span class=\"p\">.<\/span><span class=\"n\">engine<\/span><span class=\"p\">.<\/span><span class=\"n\">base<\/span><span class=\"p\">.<\/span><span class=\"n\">Engine<\/span> <span class=\"n\">show<\/span> <span class=\"n\">collation<\/span> <span class=\"n\">where<\/span> <span class=\"sb\">`Charset`<\/span> <span class=\"o\">=<\/span> <span class=\"s\">'utf8mb4'<\/span> <span class=\"ow\">and<\/span> <span class=\"sb\">`Collation`<\/span> <span class=\"o\">=<\/span> <span class=\"s\">'utf8mb4_bin'<\/span>\r\n<span class=\"mi\">2018<\/span><span class=\"o\">-<\/span><span class=\"mi\">09<\/span><span class=\"o\">-<\/span><span class=\"mi\">11<\/span> <span class=\"mi\">03<\/span><span class=\"p\">:<\/span><span class=\"mi\">33<\/span><span class=\"p\">:<\/span><span class=\"mi\">34<\/span><span class=\"p\">,<\/span><span class=\"mi\">198<\/span> <span class=\"n\">INFO<\/span> <span class=\"n\">sqlalchemy<\/span><span class=\"p\">.<\/span><span class=\"n\">engine<\/span><span class=\"p\">.<\/span><span class=\"n\">base<\/span><span class=\"p\">.<\/span><span class=\"n\">Engine<\/span> <span class=\"p\">()<\/span>\r\n<span class=\"mi\">2018<\/span><span class=\"o\">-<\/span><span class=\"mi\">09<\/span><span class=\"o\">-<\/span><span class=\"mi\">11<\/span> <span class=\"mi\">03<\/span><span class=\"p\">:<\/span><span class=\"mi\">33<\/span><span class=\"p\">:<\/span><span class=\"mi\">34<\/span><span class=\"p\">,<\/span><span class=\"mi\">200<\/span> <span class=\"n\">INFO<\/span> <span class=\"n\">sqlalchemy<\/span><span class=\"p\">.<\/span><span class=\"n\">engine<\/span><span class=\"p\">.<\/span><span class=\"n\">base<\/span><span class=\"p\">.<\/span><span class=\"n\">Engine<\/span> <span class=\"n\">SELECT<\/span> <span class=\"n\">CAST<\/span><span class=\"p\">(<\/span><span class=\"s\">'test plain returns'<\/span> <span class=\"n\">AS<\/span> <span class=\"n\">CHAR<\/span><span class=\"p\">(<\/span><span class=\"mi\">60<\/span><span class=\"p\">))<\/span> <span class=\"n\">AS<\/span> <span class=\"n\">anon_1<\/span>\r\n<span class=\"mi\">2018<\/span><span class=\"o\">-<\/span><span class=\"mi\">09<\/span><span class=\"o\">-<\/span><span class=\"mi\">11<\/span> <span class=\"mi\">03<\/span><span class=\"p\">:<\/span><span class=\"mi\">33<\/span><span class=\"p\">:<\/span><span class=\"mi\">34<\/span><span class=\"p\">,<\/span><span class=\"mi\">200<\/span> <span class=\"n\">INFO<\/span> <span class=\"n\">sqlalchemy<\/span><span class=\"p\">.<\/span><span class=\"n\">engine<\/span><span class=\"p\">.<\/span><span class=\"n\">base<\/span><span class=\"p\">.<\/span><span class=\"n\">Engine<\/span> <span class=\"p\">()<\/span>\r\n<span class=\"mi\">2018<\/span><span class=\"o\">-<\/span><span class=\"mi\">09<\/span><span class=\"o\">-<\/span><span class=\"mi\">11<\/span> <span class=\"mi\">03<\/span><span class=\"p\">:<\/span><span class=\"mi\">33<\/span><span class=\"p\">:<\/span><span class=\"mi\">34<\/span><span class=\"p\">,<\/span><span class=\"mi\">201<\/span> <span class=\"n\">INFO<\/span> <span class=\"n\">sqlalchemy<\/span><span class=\"p\">.<\/span><span class=\"n\">engine<\/span><span class=\"p\">.<\/span><span class=\"n\">base<\/span><span class=\"p\">.<\/span><span class=\"n\">Engine<\/span> <span class=\"n\">SELECT<\/span> <span class=\"n\">CAST<\/span><span class=\"p\">(<\/span><span class=\"s\">'test unicode returns'<\/span> <span class=\"n\">AS<\/span> <span class=\"n\">CHAR<\/span><span class=\"p\">(<\/span><span class=\"mi\">60<\/span><span class=\"p\">))<\/span> <span class=\"n\">AS<\/span> <span class=\"n\">anon_1<\/span>\r\n<span class=\"mi\">2018<\/span><span class=\"o\">-<\/span><span class=\"mi\">09<\/span><span class=\"o\">-<\/span><span class=\"mi\">11<\/span> <span class=\"mi\">03<\/span><span class=\"p\">:<\/span><span class=\"mi\">33<\/span><span class=\"p\">:<\/span><span class=\"mi\">34<\/span><span class=\"p\">,<\/span><span class=\"mi\">201<\/span> <span class=\"n\">INFO<\/span> <span class=\"n\">sqlalchemy<\/span><span class=\"p\">.<\/span><span class=\"n\">engine<\/span><span class=\"p\">.<\/span><span class=\"n\">base<\/span><span class=\"p\">.<\/span><span class=\"n\">Engine<\/span> <span class=\"p\">()<\/span>\r\n<span class=\"mi\">2018<\/span><span class=\"o\">-<\/span><span class=\"mi\">09<\/span><span class=\"o\">-<\/span><span class=\"mi\">11<\/span> <span class=\"mi\">03<\/span><span class=\"p\">:<\/span><span class=\"mi\">33<\/span><span class=\"p\">:<\/span><span class=\"mi\">34<\/span><span class=\"p\">,<\/span><span class=\"mi\">202<\/span> <span class=\"n\">INFO<\/span> <span class=\"n\">sqlalchemy<\/span><span class=\"p\">.<\/span><span class=\"n\">engine<\/span><span class=\"p\">.<\/span><span class=\"n\">base<\/span><span class=\"p\">.<\/span><span class=\"n\">Engine<\/span> <span class=\"n\">SELECT<\/span> <span class=\"n\">CAST<\/span><span class=\"p\">(<\/span><span class=\"s\">'test collated returns'<\/span> <span class=\"n\">AS<\/span> <span class=\"n\">CHAR<\/span> <span class=\"n\">CHARACTER<\/span> <span class=\"n\">SET<\/span> <span class=\"n\">utf8mb4<\/span><span class=\"p\">)<\/span> <span class=\"n\">COLLATE<\/span> <span class=\"n\">utf8mb4_bin<\/span> <span class=\"n\">AS<\/span> <span class=\"n\">anon_1<\/span>\r\n<span class=\"mi\">2018<\/span><span class=\"o\">-<\/span><span class=\"mi\">09<\/span><span class=\"o\">-<\/span><span class=\"mi\">11<\/span> <span class=\"mi\">03<\/span><span class=\"p\">:<\/span><span class=\"mi\">33<\/span><span class=\"p\">:<\/span><span class=\"mi\">34<\/span><span class=\"p\">,<\/span><span class=\"mi\">202<\/span> <span class=\"n\">INFO<\/span> <span class=\"n\">sqlalchemy<\/span><span class=\"p\">.<\/span><span class=\"n\">engine<\/span><span class=\"p\">.<\/span><span class=\"n\">base<\/span><span class=\"p\">.<\/span><span class=\"n\">Engine<\/span> <span class=\"p\">()<\/span>\r\n<span class=\"mi\">2018<\/span><span class=\"o\">-<\/span><span class=\"mi\">09<\/span><span class=\"o\">-<\/span><span class=\"mi\">11<\/span> <span class=\"mi\">03<\/span><span class=\"p\">:<\/span><span class=\"mi\">33<\/span><span class=\"p\">:<\/span><span class=\"mi\">34<\/span><span class=\"p\">,<\/span><span class=\"mi\">202<\/span> <span class=\"n\">INFO<\/span> <span class=\"n\">sqlalchemy<\/span><span class=\"p\">.<\/span><span class=\"n\">engine<\/span><span class=\"p\">.<\/span><span class=\"n\">base<\/span><span class=\"p\">.<\/span><span class=\"n\">Engine<\/span> <span class=\"n\">BEGIN<\/span> <span class=\"p\">(<\/span><span class=\"n\">implicit<\/span><span class=\"p\">)<\/span>\r\n<span class=\"mi\">2018<\/span><span class=\"o\">-<\/span><span class=\"mi\">09<\/span><span class=\"o\">-<\/span><span class=\"mi\">11<\/span> <span class=\"mi\">03<\/span><span class=\"p\">:<\/span><span class=\"mi\">33<\/span><span class=\"p\">:<\/span><span class=\"mi\">34<\/span><span class=\"p\">,<\/span><span class=\"mi\">203<\/span> <span class=\"n\">INFO<\/span> <span class=\"n\">sqlalchemy<\/span><span class=\"p\">.<\/span><span class=\"n\">engine<\/span><span class=\"p\">.<\/span><span class=\"n\">base<\/span><span class=\"p\">.<\/span><span class=\"n\">Engine<\/span> <span class=\"n\">SELECT<\/span> <span class=\"n\">users<\/span><span class=\"p\">.<\/span><span class=\"nb\">id<\/span> <span class=\"n\">AS<\/span> <span class=\"n\">users_id<\/span><span class=\"p\">,<\/span> <span class=\"n\">users<\/span><span class=\"p\">.<\/span><span class=\"n\">name<\/span> <span class=\"n\">AS<\/span> <span class=\"n\">users_name<\/span><span class=\"p\">,<\/span> <span class=\"n\">users<\/span><span class=\"p\">.<\/span><span class=\"n\">version_id<\/span> <span class=\"n\">AS<\/span> <span class=\"n\">users_version_id<\/span> \r\n<span class=\"n\">FROM<\/span> <span class=\"n\">users<\/span> \r\n<span class=\"n\">WHERE<\/span> <span class=\"n\">users<\/span><span class=\"p\">.<\/span><span class=\"nb\">id<\/span> <span class=\"o\">=<\/span> <span class=\"o\">%<\/span><span class=\"n\">s<\/span> \r\n <span class=\"n\">LIMIT<\/span> <span class=\"o\">%<\/span><span class=\"n\">s<\/span>\r\n<span class=\"mi\">2018<\/span><span class=\"o\">-<\/span><span class=\"mi\">09<\/span><span class=\"o\">-<\/span><span class=\"mi\">11<\/span> <span class=\"mi\">03<\/span><span class=\"p\">:<\/span><span class=\"mi\">33<\/span><span class=\"p\">:<\/span><span class=\"mi\">34<\/span><span class=\"p\">,<\/span><span class=\"mi\">203<\/span> <span class=\"n\">INFO<\/span> <span class=\"n\">sqlalchemy<\/span><span class=\"p\">.<\/span><span class=\"n\">engine<\/span><span class=\"p\">.<\/span><span class=\"n\">base<\/span><span class=\"p\">.<\/span><span class=\"n\">Engine<\/span> <span class=\"p\">(<\/span><span class=\"mi\">1<\/span><span class=\"p\">,<\/span> <span class=\"mi\">1<\/span><span class=\"p\">)<\/span>\r\n\r\n<span class=\"c1\">## User \u306e name \u3092 test5 \u306b\u5909\u66f4\u3059\u308b(\u2605\u4f8b\u5916\u767a\u751f)\r\n<\/span><span class=\"o\">&gt;&gt;&gt;<\/span> <span class=\"n\">user<\/span><span class=\"p\">.<\/span><span class=\"n\">name<\/span> <span class=\"o\">=<\/span> <span class=\"s\">'test5'<\/span>\r\n<span class=\"o\">&gt;&gt;&gt;<\/span> <span class=\"n\">session<\/span><span class=\"p\">.<\/span><span class=\"n\">add<\/span><span class=\"p\">(<\/span><span class=\"n\">user<\/span><span class=\"p\">)<\/span>\r\n<span class=\"o\">&gt;&gt;&gt;<\/span> <span class=\"n\">session<\/span><span class=\"p\">.<\/span><span class=\"n\">commit<\/span><span class=\"p\">()<\/span>\r\n<span class=\"mi\">2018<\/span><span class=\"o\">-<\/span><span class=\"mi\">09<\/span><span class=\"o\">-<\/span><span class=\"mi\">11<\/span> <span class=\"mi\">03<\/span><span class=\"p\">:<\/span><span class=\"mi\">35<\/span><span class=\"p\">:<\/span><span class=\"mi\">00<\/span><span class=\"p\">,<\/span><span class=\"mi\">504<\/span> <span class=\"n\">INFO<\/span> <span class=\"n\">sqlalchemy<\/span><span class=\"p\">.<\/span><span class=\"n\">engine<\/span><span class=\"p\">.<\/span><span class=\"n\">base<\/span><span class=\"p\">.<\/span><span class=\"n\">Engine<\/span> <span class=\"n\">UPDATE<\/span> <span class=\"n\">users<\/span> <span class=\"n\">SET<\/span> <span class=\"n\">name<\/span><span class=\"o\">=%<\/span><span class=\"n\">s<\/span><span class=\"p\">,<\/span> <span class=\"n\">version_id<\/span><span class=\"o\">=%<\/span><span class=\"n\">s<\/span> <span class=\"n\">WHERE<\/span> <span class=\"n\">users<\/span><span class=\"p\">.<\/span><span class=\"nb\">id<\/span> <span class=\"o\">=<\/span> <span class=\"o\">%<\/span><span class=\"n\">s<\/span> <span class=\"n\">AND<\/span> <span class=\"n\">users<\/span><span class=\"p\">.<\/span><span class=\"n\">version_id<\/span> <span class=\"o\">=<\/span> <span class=\"o\">%<\/span><span class=\"n\">s<\/span>\r\n<span class=\"mi\">2018<\/span><span class=\"o\">-<\/span><span class=\"mi\">09<\/span><span class=\"o\">-<\/span><span class=\"mi\">11<\/span> <span class=\"mi\">03<\/span><span class=\"p\">:<\/span><span class=\"mi\">35<\/span><span class=\"p\">:<\/span><span class=\"mi\">00<\/span><span class=\"p\">,<\/span><span class=\"mi\">504<\/span> <span class=\"n\">INFO<\/span> <span class=\"n\">sqlalchemy<\/span><span class=\"p\">.<\/span><span class=\"n\">engine<\/span><span class=\"p\">.<\/span><span class=\"n\">base<\/span><span class=\"p\">.<\/span><span class=\"n\">Engine<\/span> <span class=\"p\">(<\/span><span class=\"s\">'test5'<\/span><span class=\"p\">,<\/span> <span class=\"mi\">4<\/span><span class=\"p\">,<\/span> <span class=\"mi\">1<\/span><span class=\"p\">,<\/span> <span class=\"mi\">3<\/span><span class=\"p\">)<\/span>\r\n<span class=\"mi\">2018<\/span><span class=\"o\">-<\/span><span class=\"mi\">09<\/span><span class=\"o\">-<\/span><span class=\"mi\">11<\/span> <span class=\"mi\">03<\/span><span class=\"p\">:<\/span><span class=\"mi\">35<\/span><span class=\"p\">:<\/span><span class=\"mi\">00<\/span><span class=\"p\">,<\/span><span class=\"mi\">504<\/span> <span class=\"n\">INFO<\/span> <span class=\"n\">sqlalchemy<\/span><span class=\"p\">.<\/span><span class=\"n\">engine<\/span><span class=\"p\">.<\/span><span class=\"n\">base<\/span><span class=\"p\">.<\/span><span class=\"n\">Engine<\/span> <span class=\"n\">ROLLBACK<\/span>\r\n<span class=\"n\">Traceback<\/span> <span class=\"p\">(<\/span><span class=\"n\">most<\/span> <span class=\"n\">recent<\/span> <span class=\"n\">call<\/span> <span class=\"n\">last<\/span><span class=\"p\">):<\/span>\r\n  <span class=\"n\">File<\/span> <span class=\"s\">\"&lt;console&gt;\"<\/span><span class=\"p\">,<\/span> <span class=\"n\">line<\/span> <span class=\"mi\">1<\/span><span class=\"p\">,<\/span> <span class=\"ow\">in<\/span> <span class=\"o\">&lt;<\/span><span class=\"n\">module<\/span><span class=\"o\">&gt;<\/span>\r\n  <span class=\"n\">File<\/span> <span class=\"s\">\"\/PATH\/lib\/python3.5\/site-packages\/sqlalchemy\/orm\/session.py\"<\/span><span class=\"p\">,<\/span> <span class=\"n\">line<\/span> <span class=\"mi\">943<\/span><span class=\"p\">,<\/span> <span class=\"ow\">in<\/span> <span class=\"n\">commit<\/span>\r\n    <span class=\"bp\">self<\/span><span class=\"p\">.<\/span><span class=\"n\">transaction<\/span><span class=\"p\">.<\/span><span class=\"n\">commit<\/span><span class=\"p\">()<\/span>\r\n  <span class=\"n\">File<\/span> <span class=\"s\">\"\/PATH\/lib\/python3.5\/site-packages\/sqlalchemy\/orm\/session.py\"<\/span><span class=\"p\">,<\/span> <span class=\"n\">line<\/span> <span class=\"mi\">467<\/span><span class=\"p\">,<\/span> <span class=\"ow\">in<\/span> <span class=\"n\">commit<\/span>\r\n    <span class=\"bp\">self<\/span><span class=\"p\">.<\/span><span class=\"n\">_prepare_impl<\/span><span class=\"p\">()<\/span>\r\n  <span class=\"n\">File<\/span> <span class=\"s\">\"\/PATH\/lib\/python3.5\/site-packages\/sqlalchemy\/orm\/session.py\"<\/span><span class=\"p\">,<\/span> <span class=\"n\">line<\/span> <span class=\"mi\">447<\/span><span class=\"p\">,<\/span> <span class=\"ow\">in<\/span> <span class=\"n\">_prepare_impl<\/span>\r\n    <span class=\"bp\">self<\/span><span class=\"p\">.<\/span><span class=\"n\">session<\/span><span class=\"p\">.<\/span><span class=\"n\">flush<\/span><span class=\"p\">()<\/span>\r\n  <span class=\"n\">File<\/span> <span class=\"s\">\"\/PATH\/lib\/python3.5\/site-packages\/sqlalchemy\/orm\/session.py\"<\/span><span class=\"p\">,<\/span> <span class=\"n\">line<\/span> <span class=\"mi\">2254<\/span><span class=\"p\">,<\/span> <span class=\"ow\">in<\/span> <span class=\"n\">flush<\/span>\r\n    <span class=\"bp\">self<\/span><span class=\"p\">.<\/span><span class=\"n\">_flush<\/span><span class=\"p\">(<\/span><span class=\"n\">objects<\/span><span class=\"p\">)<\/span>\r\n  <span class=\"n\">File<\/span> <span class=\"s\">\"\/PATH\/lib\/python3.5\/site-packages\/sqlalchemy\/orm\/session.py\"<\/span><span class=\"p\">,<\/span> <span class=\"n\">line<\/span> <span class=\"mi\">2380<\/span><span class=\"p\">,<\/span> <span class=\"ow\">in<\/span> <span class=\"n\">_flush<\/span>\r\n    <span class=\"n\">transaction<\/span><span class=\"p\">.<\/span><span class=\"n\">rollback<\/span><span class=\"p\">(<\/span><span class=\"n\">_capture_exception<\/span><span class=\"o\">=<\/span><span class=\"bp\">True<\/span><span class=\"p\">)<\/span>\r\n  <span class=\"n\">File<\/span> <span class=\"s\">\"\/PATH\/lib\/python3.5\/site-packages\/sqlalchemy\/util\/langhelpers.py\"<\/span><span class=\"p\">,<\/span> <span class=\"n\">line<\/span> <span class=\"mi\">66<\/span><span class=\"p\">,<\/span> <span class=\"ow\">in<\/span> <span class=\"n\">__exit__<\/span>\r\n    <span class=\"n\">compat<\/span><span class=\"p\">.<\/span><span class=\"n\">reraise<\/span><span class=\"p\">(<\/span><span class=\"n\">exc_type<\/span><span class=\"p\">,<\/span> <span class=\"n\">exc_value<\/span><span class=\"p\">,<\/span> <span class=\"n\">exc_tb<\/span><span class=\"p\">)<\/span>\r\n  <span class=\"n\">File<\/span> <span class=\"s\">\"\/PATH\/lib\/python3.5\/site-packages\/sqlalchemy\/util\/compat.py\"<\/span><span class=\"p\">,<\/span> <span class=\"n\">line<\/span> <span class=\"mi\">249<\/span><span class=\"p\">,<\/span> <span class=\"ow\">in<\/span> <span class=\"n\">reraise<\/span>\r\n    <span class=\"k\">raise<\/span> <span class=\"n\">value<\/span>\r\n  <span class=\"n\">File<\/span> <span class=\"s\">\"\/PATH\/lib\/python3.5\/site-packages\/sqlalchemy\/orm\/session.py\"<\/span><span class=\"p\">,<\/span> <span class=\"n\">line<\/span> <span class=\"mi\">2344<\/span><span class=\"p\">,<\/span> <span class=\"ow\">in<\/span> <span class=\"n\">_flush<\/span>\r\n    <span class=\"n\">flush_context<\/span><span class=\"p\">.<\/span><span class=\"n\">execute<\/span><span class=\"p\">()<\/span>\r\n  <span class=\"n\">File<\/span> <span class=\"s\">\"\/PATH\/lib\/python3.5\/site-packages\/sqlalchemy\/orm\/unitofwork.py\"<\/span><span class=\"p\">,<\/span> <span class=\"n\">line<\/span> <span class=\"mi\">391<\/span><span class=\"p\">,<\/span> <span class=\"ow\">in<\/span> <span class=\"n\">execute<\/span>\r\n    <span class=\"n\">rec<\/span><span class=\"p\">.<\/span><span class=\"n\">execute<\/span><span class=\"p\">(<\/span><span class=\"bp\">self<\/span><span class=\"p\">)<\/span>\r\n  <span class=\"n\">File<\/span> <span class=\"s\">\"\/PATH\/lib\/python3.5\/site-packages\/sqlalchemy\/orm\/unitofwork.py\"<\/span><span class=\"p\">,<\/span> <span class=\"n\">line<\/span> <span class=\"mi\">556<\/span><span class=\"p\">,<\/span> <span class=\"ow\">in<\/span> <span class=\"n\">execute<\/span>\r\n    <span class=\"n\">uow<\/span>\r\n  <span class=\"n\">File<\/span> <span class=\"s\">\"\/PATH\/lib\/python3.5\/site-packages\/sqlalchemy\/orm\/persistence.py\"<\/span><span class=\"p\">,<\/span> <span class=\"n\">line<\/span> <span class=\"mi\">177<\/span><span class=\"p\">,<\/span> <span class=\"ow\">in<\/span> <span class=\"n\">save_obj<\/span>\r\n    <span class=\"n\">mapper<\/span><span class=\"p\">,<\/span> <span class=\"n\">table<\/span><span class=\"p\">,<\/span> <span class=\"n\">update<\/span><span class=\"p\">)<\/span>\r\n  <span class=\"n\">File<\/span> <span class=\"s\">\"\/PATH\/lib\/python3.5\/site-packages\/sqlalchemy\/orm\/persistence.py\"<\/span><span class=\"p\">,<\/span> <span class=\"n\">line<\/span> <span class=\"mi\">791<\/span><span class=\"p\">,<\/span> <span class=\"ow\">in<\/span> <span class=\"n\">_emit_update_statements<\/span>\r\n    <span class=\"p\">(<\/span><span class=\"n\">table<\/span><span class=\"p\">.<\/span><span class=\"n\">description<\/span><span class=\"p\">,<\/span> <span class=\"nb\">len<\/span><span class=\"p\">(<\/span><span class=\"n\">records<\/span><span class=\"p\">),<\/span> <span class=\"n\">rows<\/span><span class=\"p\">))<\/span>\r\n<span class=\"n\">sqlalchemy<\/span><span class=\"p\">.<\/span><span class=\"n\">orm<\/span><span class=\"p\">.<\/span><span class=\"n\">exc<\/span><span class=\"p\">.<\/span><span class=\"n\">StaleDataError<\/span><span class=\"p\">:<\/span> <span class=\"n\">UPDATE<\/span> <span class=\"n\">statement<\/span> <span class=\"n\">on<\/span> <span class=\"n\">table<\/span> <span class=\"s\">'users'<\/span> <span class=\"n\">expected<\/span> <span class=\"n\">to<\/span> <span class=\"n\">update<\/span> <span class=\"mi\">1<\/span> <span class=\"n\">row<\/span><span class=\"p\">(<\/span><span class=\"n\">s<\/span><span class=\"p\">);<\/span> <span class=\"mi\">0<\/span> <span class=\"n\">were<\/span> <span class=\"n\">matched<\/span><span class=\"p\">.<\/span>\r\n<\/code><\/pre>\n<h2>\u5728O\/R\u6620\u5c04\u5668\u4e2d\u5b9e\u73b0\u4e50\u89c2\u9501\u7684\u5b58\u5728\u4e0e\u5426\u3002<\/h2>\n<p>\u5230\u76ee\u524d\u4e3a\u6b62\uff0c\u6211\u4eec\u5df2\u7ecf\u770b\u5230\u4e86\u4f7f\u7528\u51e0\u4e2a O\/R \u6620\u5c04\u5668\u6765\u5b9e\u73b0\u4e50\u89c2\u9501\u7684\u5177\u4f53\u793a\u4f8b\u3002<\/p>\n<p>\u4ee5\u4e0b\u662f\u5305\u62ec\u5176\u4ed6O\/R\u6620\u5c04\u5668\u5728\u5185\u7684\u4e50\u89c2\u9501\u5b9e\u73b0\u7684\u603b\u7ed3\u3002<\/p>\n<div>\n<div class=\"post-table\">ORM\u540d\u697d\u89b3\u7684\u30ed\u30c3\u30af\u306e\u5b9f\u88c5\u6709\u7121\u767a\u751f\u3059\u308b\u4f8b\u5916\u53c2\u8003\u60c5\u5831GORM\u3007org.springframework.dao.OptimisticLockingFailureException<a href=\"http:\/\/gorm.grails.org\/latest\/hibernate\/manual\/index.html#locking\" target=\"_blank\" rel=\"nofollow noopener\">GORM for Hibernate &gt; Pessimistic and Optimistic Locking<\/a>ActiveRecord\u3007ActiveRecord::StaleObjectError<a href=\"https:\/\/api.rubyonrails.org\/classes\/ActiveRecord\/Locking\/Optimistic.html\" target=\"_blank\" rel=\"nofollow noopener\">Ruby on Rails API &gt; ActiveRecord::Locking::Optimistic<\/a>SQLAlchemy\u3007sqlalchemy.orm.exc.StaleDataError<a href=\"https:\/\/docs.sqlalchemy.org\/en\/latest\/orm\/mapping_api.html?highlight=version_id#sqlalchemy.orm.mapper.params.version_id_col\" target=\"_blank\" rel=\"nofollow noopener\">SQLAlchemy &gt; Class Mapping API<\/a>Hibernate\u3007org.hibernate.StaleObjectStateException<a href=\"http:\/\/www.masatom.in\/pukiwiki\/Hibernate\/%B3%DA%B4%D1%C5%AA%A5%ED%A5%C3%A5%AF%A4%F2%BC%C2%C1%F5%A4%B9%A4%EB\/\" target=\"_blank\" rel=\"nofollow noopener\">Hibernate\/\u697d\u89b3\u7684\u30ed\u30c3\u30af\u3092\u5b9f\u88c5\u3059\u308b<\/a>JPA\u3007javax.persistence.OptimisticLockException<a href=\"https:\/\/docs.oracle.com\/javaee\/7\/api\/javax\/persistence\/OptimisticLockException.html\" target=\"_blank\" rel=\"nofollow noopener\">Java7 API &#8211; Class OptimisticLockException<\/a>Eclipse Link\uff08Toplink Essentials\uff09\u3007javax.persistence.OptimisticLockException\u203bEclipse Link \u306f JPA \u306e\u5b9f\u88c5\u3067\u3042\u308b\u3002<a href=\"https:\/\/stackoverflow.com\/questions\/553263\/what-is-the-difference-between-toplink-essentials-eclipselink\" target=\"_blank\" rel=\"nofollow noopener\">stack overflow &#8211; what-is-the-difference-between-toplink-essentials-eclipselink<\/a>MyBATIS(\u65e7iBATIS)\u00d7-<a href=\"https:\/\/www.nakamuri.info\/mw\/index.php\/MyBatis%E3%81%A7%E8%A1%8C%E3%83%AD%E3%83%83%E3%82%AF%28%E6%82%B2%E8%A6%B3%E3%83%AD%E3%83%83%E3%82%AF%29%E3%82%92%E8%A1%8C%E3%81%86%E3%81%AB%E3%81%AF%EF%BC%9F\" target=\"_blank\" rel=\"nofollow noopener\">MyBatis\u3067\u884c\u30ed\u30c3\u30af(\u60b2\u89b3\u30ed\u30c3\u30af)\u3092\u884c\u3046\u306b\u306f\uff1f<\/a>Django \u306e ORM\u00d7-<br \/>\nSequelize\u3007OptimisticLockError<a href=\"http:\/\/docs.sequelizejs.com\/manual\/tutorial\/models-definition.html#optimistic-locking\" target=\"_blank\" rel=\"nofollow noopener\">Sequelize &gt; Model definition &gt; Optimistic Locking<\/a><\/div>\n<\/div>\n<h1>\u5173\u4e8eNoSQL\u6570\u636e\u5e93\u4e2d\u4e50\u89c2\u9501\u7684\u5b9e\u73b0<\/h1>\n<p>\u5728NoSQL\u4e2d\uff0c\u6ca1\u6709\u4e8b\u52a1\u5904\u7406\u7684\u60c5\u51b5\u4e0b\uff0c\u7ecf\u5e38\u4f7f\u7528\u4e50\u89c2\u9501\u3002<br \/>\n\uff08CAS\uff08Check and Set\uff09\u662fMemcached\u4e2d\u6307\u4ee3\u4e50\u89c2\u9501\u7684\u672f\u8bed\uff09<br \/>\n\u203b\u53c2\u8003\uff1aSlide Share &#8211; db-tech-showcase-mongodbP.44-50 \u9644\u8fd1<\/p>\n<h2>\u5728\u5bf9\u8c61\u5173\u7cfb\u6620\u5c04\uff08O\/R Mapper\uff09\u4e2d\u662f\u5426\u5b9e\u73b0\u4e86\u4e50\u89c2\u9501\u673a\u5236\u3002<\/h2>\n<div>\n<div class=\"post-table\">ORM\u540d\u697d\u89b3\u7684\u30ed\u30c3\u30af\u306e\u5b9f\u88c5\u6709\u7121\u767a\u751f\u3059\u308b\u4f8b\u5916\u53c2\u8003\u60c5\u5831Mongoose\u3007VersionError<a href=\"https:\/\/mongoosejs.com\/docs\/guide.html#versionKey\" target=\"_blank\" rel=\"nofollow noopener\">mongoose &gt; versionKey<\/a><\/div>\n<\/div>\n<h1>\u603b\u7ed3<\/h1>\n<p>\u5728\u672c\u6587\u4e2d\uff0c\u6211\u4eec\u9996\u5148\u6df1\u5165\u63a2\u8ba8\u4e86\u97f3\u4e50\u7684\u4e3b\u9898\uff0c\u5e76\u4ecb\u7ecd\u4e86\u4ea4\u6613\u548c\u5176\u7279\u70b9\u3002<\/p>\n<p>\u63a5\u4e0b\u6765\u4ecb\u7ecd\u4e86\u5b58\u5728\u5927\u91cf\u6570\u636e\u4e0d\u4e00\u81f4\u60c5\u51b5\u7684\u72b6\u6001\uff0c\u5e76\u9700\u8981\u5728\u53ef\u7528\u6027\u548c\u6548\u7387\u4e4b\u95f4\u6743\u8861\u9009\u62e9\u4e8b\u52a1\u7684\u9694\u79bb\u7ea7\u522b\u3002<\/p>\n<p>\u6b64\u5916\uff0c\u6211\u4ecb\u7ecd\u4e86\u4e00\u79cd\u57fa\u4e8e\u4e50\u89c2\u4e3b\u4e49\u601d\u7ef4\u7684\u4e50\u89c2\u9501\u65b9\u6cd5\uff0c\u5e76\u6307\u51fa\u5b83\u5728\u9700\u8981\u5feb\u901f\u8bfb\u53d6\u5904\u7406\u7684\u65e0\u72b6\u6001\u5904\u7406HTTP\u4e2d\u975e\u5e38\u6709\u6548\u3002<\/p>\n<p>\u6700\u540e\uff0c\u6211\u4eec\u4e3e\u4e86\u51e0\u4e2a\u5177\u4f53\u7684\u4f8b\u5b50\u6765\u4ecb\u7ecd\u5982\u4f55\u5229\u7528\u4e50\u89c2\u9501\u5728OR Mapper\u4e2d\u5b9e\u73b0\uff0c\u5e76\u603b\u7ed3\u4e86\u5728OR Mapper\u4e2d\u662f\u5426\u5b9e\u73b0\u4e86\u4e50\u89c2\u9501\u3002<\/p>\n<p>\u5e0c\u671b\u8fd9\u7bc7\u6587\u7ae0\u80fd\u5bf9\u5927\u5bb6\u7406\u89e3\u548c\u590d\u4e60\u8f6f\u4ef6\u4e2d\u91cd\u8981\u7684\u9501\u6709\u6240\u5e2e\u52a9\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5f15\u5165 \u5728\u5e94\u7528\u7a0b\u5e8f\u5f00\u53d1\u8fc7\u7a0b\u4e2d\uff0c\u5bf9\u6570\u636e\u8fdb\u884c\u52a0\u9501\u662f\u4e3a\u4e86\u4fdd\u8bc1\u6570\u636e\u7684\u5b89\u5168\u6027\u800c\u975e\u5e38\u91cd\u8981\u7684\u3002 \u672c\u6587\u5c06\u6df1\u5165\u8ba8\u8bba\u5e94\u7528\u7a0b\u5e8f\u4e2d\u7684\u201c\u9501 [&hellip;]<\/p>\n","protected":false},"author":12,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-50648","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u5728\u5e94\u7528\u7a0b\u5e8f\u5f00\u53d1\u4e2d\uff0c\u6211\u4eec\u8981\u6df1\u5165\u63a2\u8ba8\u91cd\u8981\u7684\u9501\u5b9a\u95ee\u9898\uff0c\u5e76\u4ecb\u7ecd\u5728ORM\u4e2d\u5b9e\u73b0\u4e50\u89c2\u9501\u7684\u793a\u4f8b - Blog - Silicon Cloud<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/zh\/blog\/\u5728\u5e94\u7528\u7a0b\u5e8f\u5f00\u53d1\u4e2d\uff0c\u6211\u4eec\u8981\u6df1\u5165\u63a2\u8ba8\u91cd\u8981\u7684\u9501\u5b9a\u95ee\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u5728\u5e94\u7528\u7a0b\u5e8f\u5f00\u53d1\u4e2d\uff0c\u6211\u4eec\u8981\u6df1\u5165\u63a2\u8ba8\u91cd\u8981\u7684\u9501\u5b9a\u95ee\u9898\uff0c\u5e76\u4ecb\u7ecd\u5728ORM\u4e2d\u5b9e\u73b0\u4e50\u89c2\u9501\u7684\u793a\u4f8b\" \/>\n<meta property=\"og:description\" content=\"\u5f15\u5165 \u5728\u5e94\u7528\u7a0b\u5e8f\u5f00\u53d1\u8fc7\u7a0b\u4e2d\uff0c\u5bf9\u6570\u636e\u8fdb\u884c\u52a0\u9501\u662f\u4e3a\u4e86\u4fdd\u8bc1\u6570\u636e\u7684\u5b89\u5168\u6027\u800c\u975e\u5e38\u91cd\u8981\u7684\u3002 \u672c\u6587\u5c06\u6df1\u5165\u8ba8\u8bba\u5e94\u7528\u7a0b\u5e8f\u4e2d\u7684\u201c\u9501 [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/zh\/blog\/\u5728\u5e94\u7528\u7a0b\u5e8f\u5f00\u53d1\u4e2d\uff0c\u6211\u4eec\u8981\u6df1\u5165\u63a2\u8ba8\u91cd\u8981\u7684\u9501\u5b9a\u95ee\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2023-05-16T02:23:12+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-29T06:52:53+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d92f2913a08637a6e4d21\/58-0.png\" \/>\n<meta name=\"author\" content=\"\u9038, \u79d1\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u9038, \u79d1\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8%e5%ba%94%e7%94%a8%e7%a8%8b%e5%ba%8f%e5%bc%80%e5%8f%91%e4%b8%ad%ef%bc%8c%e6%88%91%e4%bb%ac%e8%a6%81%e6%b7%b1%e5%85%a5%e6%8e%a2%e8%ae%a8%e9%87%8d%e8%a6%81%e7%9a%84%e9%94%81%e5%ae%9a%e9%97%ae\/\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8%e5%ba%94%e7%94%a8%e7%a8%8b%e5%ba%8f%e5%bc%80%e5%8f%91%e4%b8%ad%ef%bc%8c%e6%88%91%e4%bb%ac%e8%a6%81%e6%b7%b1%e5%85%a5%e6%8e%a2%e8%ae%a8%e9%87%8d%e8%a6%81%e7%9a%84%e9%94%81%e5%ae%9a%e9%97%ae\/\",\"name\":\"\u5728\u5e94\u7528\u7a0b\u5e8f\u5f00\u53d1\u4e2d\uff0c\u6211\u4eec\u8981\u6df1\u5165\u63a2\u8ba8\u91cd\u8981\u7684\u9501\u5b9a\u95ee\u9898\uff0c\u5e76\u4ecb\u7ecd\u5728ORM\u4e2d\u5b9e\u73b0\u4e50\u89c2\u9501\u7684\u793a\u4f8b - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\"},\"datePublished\":\"2023-05-16T02:23:12+00:00\",\"dateModified\":\"2024-04-29T06:52:53+00:00\",\"author\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/85c1dae56e6ea1e695c73d33c684d487\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8%e5%ba%94%e7%94%a8%e7%a8%8b%e5%ba%8f%e5%bc%80%e5%8f%91%e4%b8%ad%ef%bc%8c%e6%88%91%e4%bb%ac%e8%a6%81%e6%b7%b1%e5%85%a5%e6%8e%a2%e8%ae%a8%e9%87%8d%e8%a6%81%e7%9a%84%e9%94%81%e5%ae%9a%e9%97%ae\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8%e5%ba%94%e7%94%a8%e7%a8%8b%e5%ba%8f%e5%bc%80%e5%8f%91%e4%b8%ad%ef%bc%8c%e6%88%91%e4%bb%ac%e8%a6%81%e6%b7%b1%e5%85%a5%e6%8e%a2%e8%ae%a8%e9%87%8d%e8%a6%81%e7%9a%84%e9%94%81%e5%ae%9a%e9%97%ae\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8%e5%ba%94%e7%94%a8%e7%a8%8b%e5%ba%8f%e5%bc%80%e5%8f%91%e4%b8%ad%ef%bc%8c%e6%88%91%e4%bb%ac%e8%a6%81%e6%b7%b1%e5%85%a5%e6%8e%a2%e8%ae%a8%e9%87%8d%e8%a6%81%e7%9a%84%e9%94%81%e5%ae%9a%e9%97%ae\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.silicloud.com\/zh\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u5728\u5e94\u7528\u7a0b\u5e8f\u5f00\u53d1\u4e2d\uff0c\u6211\u4eec\u8981\u6df1\u5165\u63a2\u8ba8\u91cd\u8981\u7684\u9501\u5b9a\u95ee\u9898\uff0c\u5e76\u4ecb\u7ecd\u5728ORM\u4e2d\u5b9e\u73b0\u4e50\u89c2\u9501\u7684\u793a\u4f8b\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/\",\"name\":\"Blog - Silicon Cloud\",\"description\":\"\",\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/85c1dae56e6ea1e695c73d33c684d487\",\"name\":\"\u9038, \u79d1\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c94f6d9cbbfbca863fab309840bd690c153c95f8490c290ad2ed54dd693dad16?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c94f6d9cbbfbca863fab309840bd690c153c95f8490c290ad2ed54dd693dad16?s=96&d=mm&r=g\",\"caption\":\"\u9038, \u79d1\"},\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/author\/keyi\/\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8%e5%ba%94%e7%94%a8%e7%a8%8b%e5%ba%8f%e5%bc%80%e5%8f%91%e4%b8%ad%ef%bc%8c%e6%88%91%e4%bb%ac%e8%a6%81%e6%b7%b1%e5%85%a5%e6%8e%a2%e8%ae%a8%e9%87%8d%e8%a6%81%e7%9a%84%e9%94%81%e5%ae%9a%e9%97%ae\/#local-main-organization-logo\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"Blog - Silicon Cloud\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\u5728\u5e94\u7528\u7a0b\u5e8f\u5f00\u53d1\u4e2d\uff0c\u6211\u4eec\u8981\u6df1\u5165\u63a2\u8ba8\u91cd\u8981\u7684\u9501\u5b9a\u95ee\u9898\uff0c\u5e76\u4ecb\u7ecd\u5728ORM\u4e2d\u5b9e\u73b0\u4e50\u89c2\u9501\u7684\u793a\u4f8b - Blog - Silicon Cloud","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/zh\/blog\/\u5728\u5e94\u7528\u7a0b\u5e8f\u5f00\u53d1\u4e2d\uff0c\u6211\u4eec\u8981\u6df1\u5165\u63a2\u8ba8\u91cd\u8981\u7684\u9501\u5b9a\u95ee\/","og_locale":"zh_CN","og_type":"article","og_title":"\u5728\u5e94\u7528\u7a0b\u5e8f\u5f00\u53d1\u4e2d\uff0c\u6211\u4eec\u8981\u6df1\u5165\u63a2\u8ba8\u91cd\u8981\u7684\u9501\u5b9a\u95ee\u9898\uff0c\u5e76\u4ecb\u7ecd\u5728ORM\u4e2d\u5b9e\u73b0\u4e50\u89c2\u9501\u7684\u793a\u4f8b","og_description":"\u5f15\u5165 \u5728\u5e94\u7528\u7a0b\u5e8f\u5f00\u53d1\u8fc7\u7a0b\u4e2d\uff0c\u5bf9\u6570\u636e\u8fdb\u884c\u52a0\u9501\u662f\u4e3a\u4e86\u4fdd\u8bc1\u6570\u636e\u7684\u5b89\u5168\u6027\u800c\u975e\u5e38\u91cd\u8981\u7684\u3002 \u672c\u6587\u5c06\u6df1\u5165\u8ba8\u8bba\u5e94\u7528\u7a0b\u5e8f\u4e2d\u7684\u201c\u9501 [&hellip;]","og_url":"https:\/\/www.silicloud.com\/zh\/blog\/\u5728\u5e94\u7528\u7a0b\u5e8f\u5f00\u53d1\u4e2d\uff0c\u6211\u4eec\u8981\u6df1\u5165\u63a2\u8ba8\u91cd\u8981\u7684\u9501\u5b9a\u95ee\/","og_site_name":"Blog - Silicon Cloud","article_published_time":"2023-05-16T02:23:12+00:00","article_modified_time":"2024-04-29T06:52:53+00:00","og_image":[{"url":"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d92f2913a08637a6e4d21\/58-0.png"}],"author":"\u9038, \u79d1","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u9038, \u79d1","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"7 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8%e5%ba%94%e7%94%a8%e7%a8%8b%e5%ba%8f%e5%bc%80%e5%8f%91%e4%b8%ad%ef%bc%8c%e6%88%91%e4%bb%ac%e8%a6%81%e6%b7%b1%e5%85%a5%e6%8e%a2%e8%ae%a8%e9%87%8d%e8%a6%81%e7%9a%84%e9%94%81%e5%ae%9a%e9%97%ae\/","url":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8%e5%ba%94%e7%94%a8%e7%a8%8b%e5%ba%8f%e5%bc%80%e5%8f%91%e4%b8%ad%ef%bc%8c%e6%88%91%e4%bb%ac%e8%a6%81%e6%b7%b1%e5%85%a5%e6%8e%a2%e8%ae%a8%e9%87%8d%e8%a6%81%e7%9a%84%e9%94%81%e5%ae%9a%e9%97%ae\/","name":"\u5728\u5e94\u7528\u7a0b\u5e8f\u5f00\u53d1\u4e2d\uff0c\u6211\u4eec\u8981\u6df1\u5165\u63a2\u8ba8\u91cd\u8981\u7684\u9501\u5b9a\u95ee\u9898\uff0c\u5e76\u4ecb\u7ecd\u5728ORM\u4e2d\u5b9e\u73b0\u4e50\u89c2\u9501\u7684\u793a\u4f8b - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website"},"datePublished":"2023-05-16T02:23:12+00:00","dateModified":"2024-04-29T06:52:53+00:00","author":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/85c1dae56e6ea1e695c73d33c684d487"},"breadcrumb":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8%e5%ba%94%e7%94%a8%e7%a8%8b%e5%ba%8f%e5%bc%80%e5%8f%91%e4%b8%ad%ef%bc%8c%e6%88%91%e4%bb%ac%e8%a6%81%e6%b7%b1%e5%85%a5%e6%8e%a2%e8%ae%a8%e9%87%8d%e8%a6%81%e7%9a%84%e9%94%81%e5%ae%9a%e9%97%ae\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8%e5%ba%94%e7%94%a8%e7%a8%8b%e5%ba%8f%e5%bc%80%e5%8f%91%e4%b8%ad%ef%bc%8c%e6%88%91%e4%bb%ac%e8%a6%81%e6%b7%b1%e5%85%a5%e6%8e%a2%e8%ae%a8%e9%87%8d%e8%a6%81%e7%9a%84%e9%94%81%e5%ae%9a%e9%97%ae\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8%e5%ba%94%e7%94%a8%e7%a8%8b%e5%ba%8f%e5%bc%80%e5%8f%91%e4%b8%ad%ef%bc%8c%e6%88%91%e4%bb%ac%e8%a6%81%e6%b7%b1%e5%85%a5%e6%8e%a2%e8%ae%a8%e9%87%8d%e8%a6%81%e7%9a%84%e9%94%81%e5%ae%9a%e9%97%ae\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.silicloud.com\/zh\/blog\/"},{"@type":"ListItem","position":2,"name":"\u5728\u5e94\u7528\u7a0b\u5e8f\u5f00\u53d1\u4e2d\uff0c\u6211\u4eec\u8981\u6df1\u5165\u63a2\u8ba8\u91cd\u8981\u7684\u9501\u5b9a\u95ee\u9898\uff0c\u5e76\u4ecb\u7ecd\u5728ORM\u4e2d\u5b9e\u73b0\u4e50\u89c2\u9501\u7684\u793a\u4f8b"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website","url":"https:\/\/www.silicloud.com\/zh\/blog\/","name":"Blog - Silicon Cloud","description":"","inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/85c1dae56e6ea1e695c73d33c684d487","name":"\u9038, \u79d1","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c94f6d9cbbfbca863fab309840bd690c153c95f8490c290ad2ed54dd693dad16?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c94f6d9cbbfbca863fab309840bd690c153c95f8490c290ad2ed54dd693dad16?s=96&d=mm&r=g","caption":"\u9038, \u79d1"},"url":"https:\/\/www.silicloud.com\/zh\/blog\/author\/keyi\/"},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8%e5%ba%94%e7%94%a8%e7%a8%8b%e5%ba%8f%e5%bc%80%e5%8f%91%e4%b8%ad%ef%bc%8c%e6%88%91%e4%bb%ac%e8%a6%81%e6%b7%b1%e5%85%a5%e6%8e%a2%e8%ae%a8%e9%87%8d%e8%a6%81%e7%9a%84%e9%94%81%e5%ae%9a%e9%97%ae\/#local-main-organization-logo","url":"","contentUrl":"","caption":"Blog - Silicon Cloud"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/50648","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/users\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/comments?post=50648"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/50648\/revisions"}],"predecessor-version":[{"id":85935,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/50648\/revisions\/85935"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/media?parent=50648"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/categories?post=50648"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/tags?post=50648"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}