GitHub user yang1217 created a discussion: 使用seata 1.8.0官方包在达梦8部署报错

环境: jdk 11、seata 1.8.0、DM8、模式: AT
配置文件 application.yml: 
<img width="1951" height="1381" alt="image" 
src="https://github.com/user-attachments/assets/de29a316-0a4b-4e64-b093-e92fb8d0bd14";
 />

后端日志:
<img width="2059" height="1298" alt="image" 
src="https://github.com/user-attachments/assets/f7c410f2-7f72-47bd-94f3-952d8e2fa2ea";
 />

nacos上
<img width="2217" height="1356" alt="image" 
src="https://github.com/user-attachments/assets/f9e1c86f-8150-4ba7-9179-dd4e510cbe8c";
 />

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) ;





GitHub link: https://github.com/apache/incubator-seata/discussions/7806

----
This is an automatically sent email for [email protected].
To unsubscribe, please send an email to: [email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to