为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:dm8
【操作系统】:centos7
【CPU】:
【问题描述】*:
启动达梦数据库服务,执行一条大sql的时候,服务会崩溃。
建表语句:
CREATE TABLE "product_v3"."t_menu_auth"
(
"f_id" BIGINT IDENTITY(2917201551306767, 1) NOT NULL,
"f_menu_id" BIGINT NOT NULL,
"f_authority_id" BIGINT DEFAULT '0' NOT NULL,
"f_authority_code" VARCHAR(255) NOT NULL,
"f_order" INT DEFAULT '0',
"f_auth_type" VARCHAR(10) DEFAULT NULL,
"f_create_time" DATETIME(0) DEFAULT NULL,
"f_timestamp" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP NOT NULL,
"f_version" VARCHAR(255) DEFAULT '1.0' NOT NULL,
"f_deleted" TINYINT DEFAULT '0' NOT NULL,
"f_tenant_id" BIGINT DEFAULT NULL,
NOT CLUSTER PRIMARY KEY("f_id")) STORAGE(ON "MAIN", CLUSTERBTR) ;
COMMENT ON COLUMN "product_v3"."t_menu_auth"."f_auth_type" IS '权限类型:menu/page';
COMMENT ON COLUMN "product_v3"."t_menu_auth"."f_order" IS '排序序号';
COMMENT ON COLUMN "product_v3"."t_menu_auth"."f_tenant_id" IS '租户ID';
CREATE INDEX "t_menu_auth_f_menu_id" ON "product_v3"."t_menu_auth"("f_menu_id" ASC) STORAGE(ON "MAIN", CLUSTERBTR) ;
CREATE INDEX "t_menu_auth_f_authority_code" ON "product_v3"."t_menu_auth"("f_authority_code" ASC) STORAGE(ON "MAIN", CLUSTERBTR) ;
CREATE INDEX "t_menu_auth_idx_authority_id" ON "product_v3"."t_menu_auth"("f_authority_id" ASC) STORAGE(ON "MAIN", CLUSTERBTR) ;
执行的sql语句:
sql.zip