<\/span><\/h2>\n\n\n\n\u5982\u4e0b\u7684\u4e00\u4e2ashell\u811a\u672c\uff0c\u4f20\u51652\u4e2a\u53c2\u6570\uff0c\u5e93\u540d\u548c\u8868\u540d\uff0c\u8fde\u63a5\u6570\u636e\u5e93\u7684\u7528\u6237\u540d\u548c\u5bc6\u7801\uff0c\u9700\u8981\u6839\u636e\u5b9e\u9645\u60c5\u51b5\u505a\u4fee\u6539\u3002\u5176\u4e2d\u7684sign\u662f\u65b9\u4fbf\u67e5\u627e\u54ea\u4e9b\u8868\u505a\u4e86\u5904\u7406\u7684\u4e00\u4e2a\u4e34\u65f6\u8868\u540d\u6807\u5fd7\u3002<\/p>\n\n\n\n
\u5982\u4e0b\u4f8b\u5b50\u6ca1\u6709\u5305\u542b\u5220\u9664\u8001\u8868\u7684\u90e8\u5206\uff0c\u5efa\u8bae\u8fdb\u884c\u4eba\u5de5\u786e\u8ba4\u540e\uff0c\u518d\u5220\u9664\u8001\u8868\uff0c\u907f\u514d\u64cd\u4f5c\u5931\u8bef\u5bfc\u81f4\u6570\u636e\u4e22\u5931<\/span>\u3002<\/p>\n\n\n\n\u8be5\u811a\u672c\u5f00\u59cb\u6e05\u7406\u4e86\u6b8b\u7559\u8868\uff0c\u4e3a\u4e86\u5b89\u5168\uff0c\u9ed8\u8ba4\u662f\u6ce8\u91ca\u6389\u7684\u3002<\/p>\n\n\n\n
[gbase@rh6-1 ~]$ cat gbase_rebuild_table.sh\ndbname=$1\ntablename=$2\nsign='ABCDEFG'\necho --${tablename}--\ngccli -ugbase -pXXXXX -vvv -D${dbname} <<EOF\n-- drop table if exists ${tablename}_${sign}_OLD;\n-- drop table if exists ${tablename}_${sign}_NEW;\nlock table ${tablename} write;\ncreate table ${tablename}_${sign}_NEW like ${tablename};\ninsert into ${tablename}_${sign}_NEW select * from ${tablename};\nrename table ${tablename} to ${tablename}_${sign}_OLD;\nrename table ${tablename}_${sign}_NEW to ${tablename};\nunlock tables;\nEOF\n[gbase@rh6-1 ~]$<\/code><\/pre>\n\n\n\n<\/span>\u6267\u884c\u6548\u679c<\/span><\/h2>\n\n\n\n[gbase@rh6-1 ~]$ sh gbase_rebuild_table.sh testdb t2\n--t2--\n--------------\ndrop table if exists t2_ABCDEFG_OLD\n--------------\n\nQuery OK, 0 rows affected, 3 warnings (Elapsed: 00:00:00.11)\n\n--------------\ndrop table if exists t2_ABCDEFG_NEW\n--------------\n\nQuery OK, 0 rows affected, 3 warnings (Elapsed: 00:00:00.23)\n\n--------------\nlock table t2 write\n--------------\n\nQuery OK, 0 rows affected (Elapsed: 00:00:00.00)\n\n--------------\ncreate table t2_ABCDEFG_NEW like t2\n--------------\n\nQuery OK, 0 rows affected (Elapsed: 00:00:00.39)\n\n--------------\ninsert into t2_ABCDEFG_NEW select * from t2\n--------------\n\nQuery OK, 0 rows affected (Elapsed: 00:00:00.10)\nRecords: 0 Duplicates: 0 Warnings: 0\n\n--------------\nrename table t2 to t2_ABCDEFG_OLD\n--------------\n\nQuery OK, 0 rows affected (Elapsed: 00:00:01.24)\n\n--------------\nrename table t2_ABCDEFG_NEW to t2\n--------------\n\nQuery OK, 0 rows affected (Elapsed: 00:00:00.93)\n\n--------------\nunlock tables\n--------------\n\nQuery OK, 0 rows affected (Elapsed: 00:00:00.00)\n\nBye\n<\/code><\/pre>\n\n\n\n<\/span>\u5bf9\u5176\u5b83\u4e1a\u52a1\u7684\u5f71\u54cd<\/span><\/h2>\n\n\n\n\u7ecf\u6d4b\u8bd5\uff0c\u5728lock\u671f\u95f4\uff0c\u8be5\u8868\u53ef\u4ee5\u7ee7\u7eed\u67e5\u8be2\uff0c\u4f46\u6240\u6709DML,DDL\u5c06\u963b\u585e\uff0c\u76f4\u5230unlock tables. \u4e4b\u540e\u963b\u585e\u7684SQL\u5c06\u7ee7\u7eed\u8fd0\u884c\uff0c\u6216\u8005\u963b\u585e\u8d85\u65f6\u800c\u62a5\u9519\u9000\u51fa\u3002<\/p>\n\n\n\n
\u8fde\u63a5\u65ad\u5f00\uff0c\u9501\u4f1a\u81ea\u52a8\u91ca\u653e\u3002<\/p>\n\n\n\n
\u6301\u6709\u8868\u9501\u7684session\uff0c\u8be5\u8868\u88abrename, \u751a\u81f3drop,\u5e76\u4e0d\u4f1a\u5bfc\u81f4\u9501\u88ab\u91ca\u653e\u3002\u5176\u5b83session\u5982\u679c\u5bf9\u8be5\u8868\u505a\u64cd\u4f5c\uff0c\u4f9d\u7136\u4f1a\u7b49\u5f85\u8868\u9501\u3002<\/p>\n\n\n\n
gbase> create table t2 like t1;\n^CQuery aborted by Ctrl+C\nERROR 1727 (HY000): try to lock in gcluster failed: (GBA-02LO-0002) Failed to lock: [testdb.t2580D5F90-B287-4199-B057-E6FBD44B5BFA] GC_AIS_ERR_EXIST\n<\/code><\/pre>\n\n\n\n<\/p>","protected":false},"excerpt":{"rendered":"
\u5f53\u7531\u4e8e\u67d0\u4e9b\u539f\u56e0\u9700\u8981\u91cd\u5efa\u8868\u65f6\uff0c\u9700\u8981\u9501\u5b9a\u8868\uff0c\u907f\u514d\u8be5\u8868\u5728\u91cd\u5efa\u671f\u95f4\u53c8\u88ab\u66f4\u6539\uff0c\u5bfc\u81f4\u65b0\u8868\u548c\u8001\u8868\u6570\u636e\u4e0d\u4e00\u81f4\u3002\u672c\u6587\u63d0\u4f9b\u4e00\u4e2a\u5e94\u7528\u5c42\u7684\u5b89\u5168\u91cd\u5efa\u65b9\u6848\u3002<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-8310","post","type-post","status-publish","format-standard","hentry","category-gbase8a"],"_links":{"self":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/8310","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=8310"}],"version-history":[{"count":17,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/8310\/revisions"}],"predecessor-version":[{"id":8662,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/8310\/revisions\/8662"}],"wp:attachment":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/media?parent=8310"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/categories?post=8310"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/tags?post=8310"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}