Replies: 1 comment 2 replies
-
|
Network connectivity of the application to the database? |
Beta Was this translation helpful? Give feedback.
2 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
-
环境: jdk 11、seata 1.8.0、DM8、模式: AT

配置文件 application.yml:
后端日志:

nacos上

dm表结构
CREATE TABLE "SZW_SEATA"."branch_table"
(
"branch_id" BIGINT NOT NULL,
"xid" VARCHAR(128 CHAR) NOT NULL,
"transaction_id" BIGINT,
"resource_group_id" VARCHAR(32 CHAR),
"resource_id" VARCHAR(256 CHAR),
"branch_type" VARCHAR(8 CHAR),
"status" TINYINT,
"client_id" VARCHAR(64 CHAR),
"application_data" VARCHAR(2000 CHAR),
"gmt_create" TIMESTAMP(6),
"gmt_modified" TIMESTAMP(6),
CONSTRAINT "branch_table_PRIMARY" NOT CLUSTER PRIMARY KEY("branch_id")) STORAGE(ON "szw_seata", CLUSTERBTR) ;
CREATE OR REPLACE INDEX "SZW_SEATA"."branch_table_idx_xid" ON "SZW_SEATA"."branch_table"("xid" ASC) STORAGE(ON "szw_seata", CLUSTERBTR) ;
CREATE TABLE "SZW_SEATA"."lock_table"
(
"row_key" VARCHAR(128 CHAR) NOT NULL,
"xid" VARCHAR(128 CHAR),
"transaction_id" BIGINT,
"branch_id" BIGINT NOT NULL,
"resource_id" VARCHAR(256 CHAR),
"table_name" VARCHAR(32 CHAR),
"pk" VARCHAR(36 CHAR),
"status" TINYINT DEFAULT 0 NOT NULL,
"gmt_create" TIMESTAMP(0),
"gmt_modified" TIMESTAMP(0),
CONSTRAINT "lock_table_PRIMARY" NOT CLUSTER PRIMARY KEY("row_key")) STORAGE(ON "szw_seata", CLUSTERBTR) ;
CREATE OR REPLACE INDEX "SZW_SEATA"."lock_table_idx_xid_and_branch_id" ON "SZW_SEATA"."lock_table"("xid" ASC,"branch_id" ASC) STORAGE(ON "szw_seata", CLUSTERBTR) ;
CREATE OR REPLACE INDEX "SZW_SEATA"."lock_table_idx_status" ON "SZW_SEATA"."lock_table"("status" ASC) STORAGE(ON "szw_seata", CLUSTERBTR) ;
CREATE OR REPLACE INDEX "SZW_SEATA"."lock_table_idx_branch_id" ON "SZW_SEATA"."lock_table"("branch_id" ASC) STORAGE(ON "szw_seata", CLUSTERBTR) ;
COMMENT ON COLUMN "SZW_SEATA"."lock_table"."status" IS '0:locked ,1:rollbacking';
CREATE TABLE "SZW_SEATA"."global_table"
(
"xid" VARCHAR(128 CHAR) NOT NULL,
"transaction_id" BIGINT,
"status" TINYINT NOT NULL,
"application_id" VARCHAR(32 CHAR),
"transaction_service_group" VARCHAR(32 CHAR),
"transaction_name" VARCHAR(128 CHAR),
"timeout" INT,
"begin_time" BIGINT,
"application_data" VARCHAR(2000 CHAR),
"gmt_create" TIMESTAMP(0),
"gmt_modified" TIMESTAMP(0),
CONSTRAINT "global_table_PRIMARY" NOT CLUSTER PRIMARY KEY("xid")) STORAGE(ON "szw_seata", CLUSTERBTR) ;
CREATE OR REPLACE INDEX "SZW_SEATA"."global_table_idx_transaction_id" ON "SZW_SEATA"."global_table"("transaction_id" ASC) STORAGE(ON "szw_seata", CLUSTERBTR) ;
CREATE OR REPLACE INDEX "SZW_SEATA"."global_table_idx_status_gmt_modified" ON "SZW_SEATA"."global_table"("status" ASC,"gmt_modified" ASC) STORAGE(ON "szw_seata", CLUSTERBTR) ;
CREATE TABLE "SZW_SEATA"."distributed_lock"
(
"lock_key" VARCHAR(20 CHAR) NOT NULL,
"lock_value" VARCHAR(20 CHAR) NOT NULL,
"expire" BIGINT,
CONSTRAINT "distributed_lock_PRIMARY" NOT CLUSTER PRIMARY KEY("lock_key")) STORAGE(ON "szw_seata", CLUSTERBTR) ;
Beta Was this translation helpful? Give feedback.
All reactions