<\/span><\/h2>\n\n\n\n\u90a3\u4e48\u5f53\u591a\u4e2asession\u540c\u65f6\u64cd\u4f5c\u4e00\u4e2a\u8868\u65f6\uff0c\u6216\u8005\u4f60\u5728\u4e00\u4e2asession\u91cc\u5bf9\u8868\u505a\u4e86\u591a\u6b21DML\u7b49\u64cd\u4f5c\uff0c\u5c31\u4f1a\u62a5\u8fd9\u7c7b\u9519\u8bef\u4e86\u3002 \u8bf7\u5173\u95ed\u4e8b\u52a1\u529f\u80fd\u3002<\/p>\n\n\n\n
(GBA-02LO-0002) Can't lock file(already exists).<\/code><\/pre>\n\n\n\ngbase> set autocommit=0;\nQuery OK, 0 rows affected (Elapsed: 00:00:00.01)\n\ngbase> select * from t1;\n+------+-------+-------+\n| id | value | birth |\n+------+-------+-------+\n| 1 | 234 | NULL |\n| 2 | 567 | NULL |\n| 3 | 888 | NULL |\n| 4 | 999 | NULL |\n+------+-------+-------+\n4 rows in set (Elapsed: 00:00:00.00)\n\ngbase> update t1 set birth=now();\nQuery OK, 4 rows affected (Elapsed: 00:00:00.03)\nRows matched: 4 Changed: 4 Warnings: 0\n\ngbase> update t1 set birth=now();\nERROR 1709 (HY000): [10.0.2.107:5050](GBA-02AD-0005)Failed to query in gnode:\nDETAIL: Can't lock table: testdb.t1 (errno: 1)\nSQL: \/*::ffff:10.0.2.107_243_35_2020-09-04_19:03:40*\/ UPDATE `testdb`.`t1_n1` `testdb.t1` SET `testdb.t1`.`birth` = to_date('2020-09-04 19:03:40', 'YYYY-MM-DD HH24:MI:SS');\ngbase>\n<\/code><\/pre>\n\n\n\n<\/span>\u53c2\u6570<\/span><\/h2>\n\n\n\ngcluster_lock_timeout<\/p>\n\n\n\n
\u96c6\u7fa4\u5c42\u53c2\u6570\uff0c\u4e00\u4e2adml\u7b49\u8bed\u53e5\u8fd0\u884c\u524d\u8981\u83b7\u5f97\u96c6\u7fa4\u5bf9\u76ee\u6807\u8868\u7684\u9501\u3002<\/p>\n\n\n\n
<\/span>\u9ed8\u8ba4\u503c<\/span><\/h2>\n\n\n\n\u4e3a0\uff0c\u8868\u793a\u4e00\u76f4\u7b49\u5f85\u76f4\u5230\u83b7\u5f97\u9501\u3002<\/p>\n\n\n\n
\u5355\u4f4d\u4e3a\u79d2\u3002\u652f\u6301session\u7ea7\u53d8\u91cf<\/p>\n\n\n\n
<\/span>\u6837\u4f8b<\/span><\/h2>\n\n\n\nset gcluster_lock_timeout=5<\/p>\n\n\n\n
insert into t1 select * from b<\/p>\n\n\n\n
\u5982\u679c\u8d85\u8fc75\u79d2\u6ca1\u6709\u83b7\u5f97\u9501\uff0c\u5219\u62a5\u9519\u663e\u793a\u65e0\u6cd5\u83b7\u5f97\u9501\u7684\u9519\u8bef\u4fe1\u606f<\/p>\n\n\n\n
<\/span>\u62a5\u9519\u4fe1\u606f\u7c7b\u4f3c\uff1a<\/span><\/h2>\n\n\n\nERROR 1727 (HY000): try to lock in gcluster failed: (GBA-02LO-0002) Failed to lock: [testdb.t1580D5F90-B287-4199-B057-E6FBD44B5BFA] GC_AIS_ERR_TIMEOUT<\/p>\n","protected":false},"excerpt":{"rendered":"
\u5357\u5927\u901a\u7528GBase 8a\u6570\u636e\u5e93\u96c6\u7fa4\u5185\u90e8\uff0c\u901a\u8fc7\u9501\u673a\u5236\u6765\u5b9e\u73b0\u8d44\u6e90\u7684\u5e76\u884c\u64cd\u4f5c\uff0c\u5176\u7b49\u5f85\u8d85\u65f6\u53c2\u6570\u901a\u8fc7gcluster_lock_timeout\u8bbe\u7f6e\uff0c\u9ed8\u8ba4\u662f0\u4e00\u76f4\u7b49\u5f85\u3002<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6,54],"tags":[51,17],"class_list":{"0":"post-488","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"hentry","6":"category-gbase8a","8":"tag-51","9":"tag-17"},"_links":{"self":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/488","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/comments?post=488"}],"version-history":[{"count":9,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/488\/revisions"}],"predecessor-version":[{"id":5269,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/488\/revisions\/5269"}],"wp:attachment":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/media?parent=488"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/categories?post=488"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/tags?post=488"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}