We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
通过docker的方式部署到云服务器，安全组已经开放了10824端口，但是访问ip:10824无法访问，通过netstat命令也没监听到10824端口的服务，docker的日志如下：
l ... 2024-12-25 08:22:43.850 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 1: CREATE TABLE IF NOT EXISTS jdbc_driver ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键', gmt_create datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', gmt_modified datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间', db_type varchar(32) NOT NULL COMMENT 'db类型', jdbc_driver varchar(512) DEFAULT NULL COMMENT 'jar包', jdbc_driver_class varchar(512) DEFAULT NULL COMMENT 'driver class类', PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='自定义驱动表' 2024-12-25 08:22:43.851 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 11: create INDEX idx_db_type on jdbc_driver(db_type) 2024-12-25 08:22:43.851 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 12: ALTER TABLE data_source ADD COLUMN driver_config varchar(1024) NULL COMMENT 'driver_config配置' 2024-12-25 08:22:43.851 DEBUG 1 --- [ task-1] o.f.core.internal.command.DbMigrate .32 : | Starting migration of schema "PUBLIC" to version "1.0.7 - 自定义驱动" ... 2024-12-25 08:22:43.852 INFO 1 --- [ task-1] o.f.core.internal.command.DbMigrate .35 : | Migrating schema "PUBLIC" to version "1.0.7 - 自定义驱动" 2024-12-25 08:22:43.852 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: CREATE TABLE IF NOT EXISTS jdbc_driver ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键', gmt_create datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', gmt_modified datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间', db_type varchar(32) NOT NULL COMMENT 'db类型', jdbc_driver varchar(512) DEFAULT NULL COMMENT 'jar包', jdbc_driver_class varchar(512) DEFAULT NULL COMMENT 'driver class类', PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='自定义驱动表' 2024-12-25 08:22:43.866 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected 2024-12-25 08:22:43.866 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: create INDEX idx_db_type on jdbc_driver(db_type) 2024-12-25 08:22:43.867 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected 2024-12-25 08:22:43.867 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: ALTER TABLE data_source ADD COLUMN driver_config varchar(1024) NULL COMMENT 'driver_config配置' 2024-12-25 08:22:43.872 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected 2024-12-25 08:22:43.872 DEBUG 1 --- [ task-1] o.f.core.internal.command.DbMigrate .32 : | Successfully completed migration of schema "PUBLIC" to version "1.0.7 - 自定义驱动" 2024-12-25 08:22:43.874 DEBUG 1 --- [ task-1] o.f.c.i.s.JdbcTableSchemaHistory .32 : | Schema History table "PUBLIC"."flyway_schema_history" successfully updated to reflect changes 2024-12-25 08:22:43.876 DEBUG 1 --- [ task-1] o.flywaydb.core.internal.parser.Parser .32 : | Parsing V1_0_8__操作保存类型.sql ... 2024-12-25 08:22:43.878 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 1: ALTER TABLE operation_saved ADD COLUMN operation_type varchar(1024) NULL COMMENT '操作类型' 2024-12-25 08:22:43.878 DEBUG 1 --- [ task-1] o.f.core.internal.command.DbMigrate .32 : | Starting migration of schema "PUBLIC" to version "1.0.8 - 操作保存类型" ... 2024-12-25 08:22:43.878 INFO 1 --- [ task-1] o.f.core.internal.command.DbMigrate .35 : | Migrating schema "PUBLIC" to version "1.0.8 - 操作保存类型" 2024-12-25 08:22:43.879 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: ALTER TABLE operation_saved ADD COLUMN operation_type varchar(1024) NULL COMMENT '操作类型' 2024-12-25 08:22:43.883 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected 2024-12-25 08:22:43.883 DEBUG 1 --- [ task-1] o.f.core.internal.command.DbMigrate .32 : | Successfully completed migration of schema "PUBLIC" to version "1.0.8 - 操作保存类型" 2024-12-25 08:22:43.884 DEBUG 1 --- [ task-1] o.f.c.i.s.JdbcTableSchemaHistory .32 : | Schema History table "PUBLIC"."flyway_schema_history" successfully updated to reflect changes 2024-12-25 08:22:43.887 DEBUG 1 --- [ task-1] o.flywaydb.core.internal.parser.Parser .32 : | Parsing V2_1_0__支持环境、用户权限.sql ... 2024-12-25 08:22:43.897 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 1: CREATE TABLE IF NOT EXISTS environment ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键', gmt_create datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', gmt_modified datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间', create_user_id bigint(20) unsigned NOT NULL COMMENT '创建人用户id', modified_user_id bigint(20) unsigned NOT NULL COMMENT '修改人用户id', name varchar(128) DEFAULT NOT NULL COMMENT '环境名称', short_name varchar(128) DEFAULT NULL COMMENT '环境缩写', color varchar(32) DEFAULT NULL COMMENT '颜色', PRIMARY KEY (id) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COMMENT ='数据库连接环境' 2024-12-25 08:22:43.898 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 16: INSERT INTO environment (id, create_user_id, modified_user_id, name, short_name, color) VALUES (1, 1, 1, 'Release Environment', 'RELEASE', 'RED') 2024-12-25 08:22:43.898 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 19: INSERT INTO environment (id, create_user_id, modified_user_id, name, short_name, color) VALUES (2, 1, 1, 'Test Environment', 'TEST', 'GREEN') 2024-12-25 08:22:43.898 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 23: ALTER TABLE data_source ADD COLUMN environment_id bigint(20) unsigned NOT NULL DEFAULT 2 COMMENT '环境id' 2024-12-25 08:22:43.899 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 26: ALTER TABLE data_source modify COLUMN user_id bigint(20) unsigned NOT NULL DEFAULT 1 COMMENT '用户id' 2024-12-25 08:22:43.899 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 29: ALTER TABLE data_source ADD COLUMN kind varchar(32) NOT NULL DEFAULT 'PRIVATE' COMMENT '连接类型' 2024-12-25 08:22:43.899 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 32: update data_source set user_id= 1 2024-12-25 08:22:43.899 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 35: ALTER TABLE dbhub_user ADD COLUMN role_code varchar(32) DEFAULT NULL COMMENT '角色编码' 2024-12-25 08:22:43.900 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 38: ALTER TABLE dbhub_user ADD status varchar(32) NOT NULL DEFAULT 'VALID' COMMENT '用户状态' 2024-12-25 08:22:43.900 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 41: ALTER TABLE dbhub_user ADD create_user_id bigint(20) unsigned NOT NULL DEFAULT 1 COMMENT '创建人用户id' 2024-12-25 08:22:43.900 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 44: ALTER TABLE dbhub_user ADD modified_user_id bigint(20) unsigned NOT NULL DEFAULT 1 COMMENT '修改人用户id' 2024-12-25 08:22:43.900 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 47: update dbhub_user set role_code= 'DESKTOP',user_name='_desktop_default_user_name',password='_desktop_default_user_name',nick_name='Desktop User' where id = 1 2024-12-25 08:22:43.901 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 50: INSERT INTO DBHUB_USER (USER_NAME, PASSWORD, NICK_NAME, EMAIL, ROLE_CODE) VALUES ('chat2db', 'chat2db', 'Administrator', null, 'ADMIN') 2024-12-25 08:22:43.901 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 52: create UNIQUE INDEX uk_user_user_name on dbhub_user (user_name) 2024-12-25 08:22:43.902 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 55: CREATE TABLE IF NOT EXISTS team ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键', gmt_create datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', gmt_modified datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间', create_user_id bigint(20) unsigned NOT NULL COMMENT '创建人用户id', modified_user_id bigint(20) unsigned NOT NULL COMMENT '修改人用户id', code varchar(128) DEFAULT NOT NULL COMMENT '团队编码', name varchar(512) DEFAULT NULL COMMENT '团队名称', status varchar(32) NOT NULL DEFAULT 'VALID' COMMENT '团队状态', description text DEFAULT NULL COMMENT '团队描述', PRIMARY KEY (id) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COMMENT ='团队' 2024-12-25 08:22:43.902 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 71: create UNIQUE INDEX uk_team_code on team (code) 2024-12-25 08:22:43.903 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 74: CREATE TABLE IF NOT EXISTS team_user ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键', gmt_create datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', gmt_modified datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间', create_user_id bigint(20) unsigned NOT NULL COMMENT '创建人用户id', modified_user_id bigint(20) unsigned NOT NULL COMMENT '修改人用户id', team_id bigint(20) unsigned NOT NULL COMMENT '团队id', user_id bigint(20) unsigned NOT NULL COMMENT '用户id', PRIMARY KEY (id) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COMMENT ='用户团队表' 2024-12-25 08:22:43.903 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 88: create INDEX idx_team_user_team_id on team_user (team_id) 2024-12-25 08:22:43.903 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 89: create INDEX idx_team_user_user_id on team_user (user_id) 2024-12-25 08:22:43.904 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 90: create UNIQUE INDEX uk_team_user on team_user (team_id,user_id) 2024-12-25 08:22:43.904 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 92: CREATE TABLE IF NOT EXISTS data_source_access ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键', gmt_create datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', gmt_modified datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间', create_user_id bigint(20) unsigned NOT NULL COMMENT '创建人用户id', modified_user_id bigint(20) unsigned NOT NULL COMMENT '修改人用户id', data_source_id bigint(20) unsigned NOT NULL COMMENT '数据源id', access_object_type varchar(32) NOT NULL COMMENT '授权类型', access_object_id bigint(20) unsigned NOT NULL COMMENT '授权id,根据类型区分是用户还是团队', PRIMARY KEY (id) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COMMENT ='数据源授权' 2024-12-25 08:22:43.904 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 107: create INDEX idx_data_source_access_data_source_id on data_source_access (data_source_id) 2024-12-25 08:22:43.905 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 108: create INDEX idx_data_source_access_access_object_id on data_source_access (access_object_type, access_object_id) 2024-12-25 08:22:43.905 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 109: create UNIQUE INDEX uk_data_source_access on data_source_access (data_source_id,access_object_type, access_object_id) 2024-12-25 08:22:43.905 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 111: ALTER TABLE operation_saved modify COLUMN user_id bigint(20) unsigned NOT NULL DEFAULT 1 COMMENT '用户id' 2024-12-25 08:22:43.905 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 114: update operation_saved set user_id= 1 2024-12-25 08:22:43.905 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 117: ALTER TABLE operation_log modify COLUMN user_id bigint(20) unsigned NOT NULL DEFAULT 1 COMMENT '用户id' 2024-12-25 08:22:43.906 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 120: update operation_log set user_id= 1 2024-12-25 08:22:43.906 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 123: ALTER TABLE dashboard modify user_id bigint(20) unsigned NOT NULL DEFAULT 1 COMMENT '用户id' 2024-12-25 08:22:43.913 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 125: update dashboard set user_id= 1 2024-12-25 08:22:43.913 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 129: ALTER TABLE chart modify user_id bigint(20) unsigned NOT NULL DEFAULT 1 COMMENT '用户id' 2024-12-25 08:22:43.914 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 131: update chart set user_id= 1 2024-12-25 08:22:43.914 DEBUG 1 --- [ task-1] o.f.core.internal.command.DbMigrate .32 : | Starting migration of schema "PUBLIC" to version "2.1.0 - 支持环境、用户权限" ... 2024-12-25 08:22:43.914 INFO 1 --- [ task-1] o.f.core.internal.command.DbMigrate .35 : | Migrating schema "PUBLIC" to version "2.1.0 - 支持环境、用户权限" 2024-12-25 08:22:43.914 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: CREATE TABLE IF NOT EXISTS environment ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键', gmt_create datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', gmt_modified datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间', create_user_id bigint(20) unsigned NOT NULL COMMENT '创建人用户id', modified_user_id bigint(20) unsigned NOT NULL COMMENT '修改人用户id', name varchar(128) DEFAULT NOT NULL COMMENT '环境名称', short_name varchar(128) DEFAULT NULL COMMENT '环境缩写', color varchar(32) DEFAULT NULL COMMENT '颜色', PRIMARY KEY (id) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COMMENT ='数据库连接环境' 2024-12-25 08:22:43.916 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected 2024-12-25 08:22:43.916 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: INSERT INTO environment (id, create_user_id, modified_user_id, name, short_name, color) VALUES (1, 1, 1, 'Release Environment', 'RELEASE', 'RED') 2024-12-25 08:22:43.917 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 1 row affected 2024-12-25 08:22:43.917 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: INSERT INTO environment (id, create_user_id, modified_user_id, name, short_name, color) VALUES (2, 1, 1, 'Test Environment', 'TEST', 'GREEN') 2024-12-25 08:22:43.918 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 1 row affected 2024-12-25 08:22:43.918 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: ALTER TABLE data_source ADD COLUMN environment_id bigint(20) unsigned NOT NULL DEFAULT 2 COMMENT '环境id' 2024-12-25 08:22:43.926 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected 2024-12-25 08:22:43.927 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: ALTER TABLE data_source modify COLUMN user_id bigint(20) unsigned NOT NULL DEFAULT 1 COMMENT '用户id' 2024-12-25 08:22:43.949 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected 2024-12-25 08:22:43.949 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: ALTER TABLE data_source ADD COLUMN kind varchar(32) NOT NULL DEFAULT 'PRIVATE' COMMENT '连接类型' 2024-12-25 08:22:43.954 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected 2024-12-25 08:22:43.954 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: update data_source set user_id= 1 2024-12-25 08:22:43.957 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 1 row affected 2024-12-25 08:22:43.957 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: ALTER TABLE dbhub_user ADD COLUMN role_code varchar(32) DEFAULT NULL COMMENT '角色编码' 2024-12-25 08:22:43.961 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected 2024-12-25 08:22:43.961 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: ALTER TABLE dbhub_user ADD status varchar(32) NOT NULL DEFAULT 'VALID' COMMENT '用户状态' 2024-12-25 08:22:43.965 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected 2024-12-25 08:22:43.965 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: ALTER TABLE dbhub_user ADD create_user_id bigint(20) unsigned NOT NULL DEFAULT 1 COMMENT '创建人用户id' 2024-12-25 08:22:43.970 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected 2024-12-25 08:22:43.970 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: ALTER TABLE dbhub_user ADD modified_user_id bigint(20) unsigned NOT NULL DEFAULT 1 COMMENT '修改人用户id' 2024-12-25 08:22:43.972 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected 2024-12-25 08:22:43.972 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: update dbhub_user set role_code= 'DESKTOP',user_name='_desktop_default_user_name',password='_desktop_default_user_name',nick_name='Desktop User' where id = 1 2024-12-25 08:22:43.973 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 1 row affected 2024-12-25 08:22:43.973 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: INSERT INTO DBHUB_USER (USER_NAME, PASSWORD, NICK_NAME, EMAIL, ROLE_CODE) VALUES ('chat2db', 'chat2db', 'Administrator', null, 'ADMIN') 2024-12-25 08:22:43.973 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 1 row affected 2024-12-25 08:22:43.973 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: create UNIQUE INDEX uk_user_user_name on dbhub_user (user_name) 2024-12-25 08:22:43.984 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected 2024-12-25 08:22:43.984 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: CREATE TABLE IF NOT EXISTS team ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键', gmt_create datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', gmt_modified datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间', create_user_id bigint(20) unsigned NOT NULL COMMENT '创建人用户id', modified_user_id bigint(20) unsigned NOT NULL COMMENT '修改人用户id', code varchar(128) DEFAULT NOT NULL COMMENT '团队编码', name varchar(512) DEFAULT NULL COMMENT '团队名称', status varchar(32) NOT NULL DEFAULT 'VALID' COMMENT '团队状态', description text DEFAULT NULL COMMENT '团队描述', PRIMARY KEY (id) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COMMENT ='团队' 2024-12-25 08:22:43.985 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected 2024-12-25 08:22:43.986 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: create UNIQUE INDEX uk_team_code on team (code) 2024-12-25 08:22:43.987 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected 2024-12-25 08:22:43.987 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: CREATE TABLE IF NOT EXISTS team_user ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键', gmt_create datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', gmt_modified datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间', create_user_id bigint(20) unsigned NOT NULL COMMENT '创建人用户id', modified_user_id bigint(20) unsigned NOT NULL COMMENT '修改人用户id', team_id bigint(20) unsigned NOT NULL COMMENT '团队id', user_id bigint(20) unsigned NOT NULL COMMENT '用户id', PRIMARY KEY (id) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COMMENT ='用户团队表' 2024-12-25 08:22:43.988 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected 2024-12-25 08:22:43.988 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: create INDEX idx_team_user_team_id on team_user (team_id) 2024-12-25 08:22:43.989 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected 2024-12-25 08:22:43.989 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: create INDEX idx_team_user_user_id on team_user (user_id) 2024-12-25 08:22:43.990 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected 2024-12-25 08:22:43.990 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: create UNIQUE INDEX uk_team_user on team_user (team_id,user_id) 2024-12-25 08:22:43.991 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected 2024-12-25 08:22:43.991 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: CREATE TABLE IF NOT EXISTS data_source_access ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键', gmt_create datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', gmt_modified datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间', create_user_id bigint(20) unsigned NOT NULL COMMENT '创建人用户id', modified_user_id bigint(20) unsigned NOT NULL COMMENT '修改人用户id', data_source_id bigint(20) unsigned NOT NULL COMMENT '数据源id', access_object_type varchar(32) NOT NULL COMMENT '授权类型', access_object_id bigint(20) unsigned NOT NULL COMMENT '授权id,根据类型区分是用户还是团队', PRIMARY KEY (id) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COMMENT ='数据源授权' 2024-12-25 08:22:43.992 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected 2024-12-25 08:22:43.992 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: create INDEX idx_data_source_access_data_source_id on data_source_access (data_source_id) 2024-12-25 08:22:43.993 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected 2024-12-25 08:22:43.993 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: create INDEX idx_data_source_access_access_object_id on data_source_access (access_object_type, access_object_id) 2024-12-25 08:22:43.994 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected 2024-12-25 08:22:43.994 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: create UNIQUE INDEX uk_data_source_access on data_source_access (data_source_id,access_object_type, access_object_id) 2024-12-25 08:22:43.994 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected 2024-12-25 08:22:43.994 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: ALTER TABLE operation_saved modify COLUMN user_id bigint(20) unsigned NOT NULL DEFAULT 1 COMMENT '用户id' 2024-12-25 08:22:43.997 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected 2024-12-25 08:22:43.998 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: update operation_saved set user_id= 1 2024-12-25 08:22:43.998 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected 2024-12-25 08:22:43.998 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: ALTER TABLE operation_log modify COLUMN user_id bigint(20) unsigned NOT NULL DEFAULT 1 COMMENT '用户id' 2024-12-25 08:22:44.000 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected 2024-12-25 08:22:44.001 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: update operation_log set user_id= 1 2024-12-25 08:22:44.001 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected 2024-12-25 08:22:44.001 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: ALTER TABLE dashboard modify user_id bigint(20) unsigned NOT NULL DEFAULT 1 COMMENT '用户id' 2024-12-25 08:22:44.004 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected 2024-12-25 08:22:44.004 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: update dashboard set user_id= 1 2024-12-25 08:22:44.004 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 1 row affected 2024-12-25 08:22:44.005 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: ALTER TABLE chart modify user_id bigint(20) unsigned NOT NULL DEFAULT 1 COMMENT '用户id' 2024-12-25 08:22:44.008 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected 2024-12-25 08:22:44.008 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: update chart set user_id= 1 2024-12-25 08:22:44.009 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 3 rows affected 2024-12-25 08:22:44.009 DEBUG 1 --- [ task-1] o.f.core.internal.command.DbMigrate .32 : | Successfully completed migration of schema "PUBLIC" to version "2.1.0 - 支持环境、用户权限" 2024-12-25 08:22:44.010 DEBUG 1 --- [ task-1] o.f.c.i.s.JdbcTableSchemaHistory .32 : | Schema History table "PUBLIC"."flyway_schema_history" successfully updated to reflect changes 2024-12-25 08:22:44.012 DEBUG 1 --- [ task-1] o.flywaydb.core.internal.parser.Parser .32 : | Parsing V2_1_1__TableCache.sql ... 2024-12-25 08:22:44.014 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 1: CREATE TABLE IF NOT EXISTS table_cache_version ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键', gmt_create datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', gmt_modified datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间', data_source_id bigint(20) unsigned NOT NULL COMMENT '数据源连接ID', database_name varchar(256) DEFAULT NULL COMMENT 'db名称', schema_name varchar(256) DEFAULT NULL COMMENT 'schema名称', key varchar(256) DEFAULT NULL COMMENT '唯一索引', version bigint(20) unsigned NOT NULL COMMENT '版本', table_count bigint(20) unsigned NOT NULL COMMENT '表数量', status varchar(256) DEFAULT NULL COMMENT '状态', PRIMARY KEY (id) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='table cache version' 2024-12-25 08:22:44.014 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 15: create INDEX idx_table_cache_version_data_source_id on table_cache_version(data_source_id) 2024-12-25 08:22:44.015 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 16: create UNIQUE INDEX uk_table_cache_version_key on table_cache_version(key) 2024-12-25 08:22:44.015 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 18: CREATE TABLE IF NOT EXISTS table_cache ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键', gmt_create datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', gmt_modified datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间', data_source_id bigint(20) unsigned NOT NULL COMMENT '数据源连接ID', database_name varchar(256) DEFAULT NULL COMMENT 'db名称', schema_name varchar(256) DEFAULT NULL COMMENT 'schema名称', table_name varchar(256) DEFAULT NULL COMMENT 'table名称', key varchar(256) DEFAULT NULL COMMENT '唯一索引', version bigint(20) unsigned NOT NULL COMMENT '版本', columns varchar(2048) DEFAULT NULL COMMENT '表字段', extend_info varchar(2048) NULL COMMENT '自定义扩展字段json', PRIMARY KEY (id) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='table cache' 2024-12-25 08:22:44.016 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 33: create INDEX idx_table_cache_data_source_id on table_cache(data_source_id) 2024-12-25 08:22:44.016 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 34: create INDEX idx_table_cache_key_version on table_cache(key,version) 2024-12-25 08:22:44.016 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 35: create INDEX idx_table_cache_key_table_name on table_cache(key,table_name) 2024-12-25 08:22:44.016 DEBUG 1 --- [ task-1] o.f.core.internal.command.DbMigrate .32 : | Starting migration of schema "PUBLIC" to version "2.1.1 - TableCache" ... 2024-12-25 08:22:44.016 INFO 1 --- [ task-1] o.f.core.internal.command.DbMigrate .35 : | Migrating schema "PUBLIC" to version "2.1.1 - TableCache" 2024-12-25 08:22:44.017 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: CREATE TABLE IF NOT EXISTS table_cache_version ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键', gmt_create datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', gmt_modified datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间', data_source_id bigint(20) unsigned NOT NULL COMMENT '数据源连接ID', database_name varchar(256) DEFAULT NULL COMMENT 'db名称', schema_name varchar(256) DEFAULT NULL COMMENT 'schema名称', key varchar(256) DEFAULT NULL COMMENT '唯一索引', version bigint(20) unsigned NOT NULL COMMENT '版本', table_count bigint(20) unsigned NOT NULL COMMENT '表数量', status varchar(256) DEFAULT NULL COMMENT '状态', PRIMARY KEY (id) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='table cache version' 2024-12-25 08:22:44.018 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected 2024-12-25 08:22:44.018 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: create INDEX idx_table_cache_version_data_source_id on table_cache_version(data_source_id) 2024-12-25 08:22:44.019 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected 2024-12-25 08:22:44.019 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: create UNIQUE INDEX uk_table_cache_version_key on table_cache_version(key) 2024-12-25 08:22:44.020 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected 2024-12-25 08:22:44.020 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: CREATE TABLE IF NOT EXISTS table_cache ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键', gmt_create datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', gmt_modified datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间', data_source_id bigint(20) unsigned NOT NULL COMMENT '数据源连接ID', database_name varchar(256) DEFAULT NULL COMMENT 'db名称', schema_name varchar(256) DEFAULT NULL COMMENT 'schema名称', table_name varchar(256) DEFAULT NULL COMMENT 'table名称', key varchar(256) DEFAULT NULL COMMENT '唯一索引', version bigint(20) unsigned NOT NULL COMMENT '版本', columns varchar(2048) DEFAULT NULL COMMENT '表字段', extend_info varchar(2048) NULL COMMENT '自定义扩展字段json', PRIMARY KEY (id) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='table cache' 2024-12-25 08:22:44.021 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected 2024-12-25 08:22:44.021 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: create INDEX idx_table_cache_data_source_id on table_cache(data_source_id) 2024-12-25 08:22:44.022 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected 2024-12-25 08:22:44.022 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: create INDEX idx_table_cache_key_version on table_cache(key,version) 2024-12-25 08:22:44.022 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected 2024-12-25 08:22:44.023 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: create INDEX idx_table_cache_key_table_name on table_cache(key,table_name) 2024-12-25 08:22:44.023 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected 2024-12-25 08:22:44.023 DEBUG 1 --- [ task-1] o.f.core.internal.command.DbMigrate .32 : | Successfully completed migration of schema "PUBLIC" to version "2.1.1 - TableCache" 2024-12-25 08:22:44.025 DEBUG 1 --- [ task-1] o.f.c.i.s.JdbcTableSchemaHistory .32 : | Schema History table "PUBLIC"."flyway_schema_history" successfully updated to reflect changes 2024-12-25 08:22:44.026 DEBUG 1 --- [ task-1] o.flywaydb.core.internal.parser.Parser .32 : | Parsing V2_1_2__OPERATION.sql ... 2024-12-25 08:22:44.027 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 1: ALTER TABLE operation_log ADD COLUMN status varchar(20) DEFAULT 'success' COMMENT '状态' 2024-12-25 08:22:44.028 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 3: ALTER TABLE operation_log ADD COLUMN operation_rows bigint(20) unsigned COMMENT '操作行数' 2024-12-25 08:22:44.028 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 5: ALTER TABLE operation_log ADD COLUMN use_time bigint(20) unsigned COMMENT '使用时长' 2024-12-25 08:22:44.028 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 7: ALTER TABLE operation_log ADD COLUMN extend_info varchar(1024) COMMENT '扩展信息' 2024-12-25 08:22:44.028 DEBUG 1 --- [ task-1] o.f.core.internal.command.DbMigrate .32 : | Starting migration of schema "PUBLIC" to version "2.1.2 - OPERATION" ... 2024-12-25 08:22:44.029 INFO 1 --- [ task-1] o.f.core.internal.command.DbMigrate .35 : | Migrating schema "PUBLIC" to version "2.1.2 - OPERATION" 2024-12-25 08:22:44.030 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: ALTER TABLE operation_log ADD COLUMN status varchar(20) DEFAULT 'success' COMMENT '状态' 2024-12-25 08:22:44.032 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected 2024-12-25 08:22:44.033 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: ALTER TABLE operation_log ADD COLUMN operation_rows bigint(20) unsigned COMMENT '操作行数' 2024-12-25 08:22:44.035 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected 2024-12-25 08:22:44.035 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: ALTER TABLE operation_log ADD COLUMN use_time bigint(20) unsigned COMMENT '使用时长' 2024-12-25 08:22:44.038 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected 2024-12-25 08:22:44.038 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: ALTER TABLE operation_log ADD COLUMN extend_info varchar(1024) COMMENT '扩展信息' 2024-12-25 08:22:44.041 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected 2024-12-25 08:22:44.042 DEBUG 1 --- [ task-1] o.f.core.internal.command.DbMigrate .32 : | Successfully completed migration of schema "PUBLIC" to version "2.1.2 - OPERATION" 2024-12-25 08:22:44.043 DEBUG 1 --- [ task-1] o.f.c.i.s.JdbcTableSchemaHistory .32 : | Schema History table "PUBLIC"."flyway_schema_history" successfully updated to reflect changes 2024-12-25 08:22:44.045 DEBUG 1 --- [ task-1] o.flywaydb.core.internal.parser.Parser .32 : | Parsing V2_1_4__OPERATION.sql ... 2024-12-25 08:22:44.046 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 1: ALTER TABLE operation_log ADD COLUMN schema_name varchar(256) COMMENT 'schema名称' 2024-12-25 08:22:44.046 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 3: create INDEX idx_op_data_source_id on operation_log(data_source_id) 2024-12-25 08:22:44.046 DEBUG 1 --- [ task-1] o.f.core.internal.command.DbMigrate .32 : | Starting migration of schema "PUBLIC" to version "2.1.4 - OPERATION" ... 2024-12-25 08:22:44.047 INFO 1 --- [ task-1] o.f.core.internal.command.DbMigrate .35 : | Migrating schema "PUBLIC" to version "2.1.4 - OPERATION" 2024-12-25 08:22:44.047 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: ALTER TABLE operation_log ADD COLUMN schema_name varchar(256) COMMENT 'schema名称' 2024-12-25 08:22:44.050 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected 2024-12-25 08:22:44.050 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: create INDEX idx_op_data_source_id on operation_log(data_source_id) 2024-12-25 08:22:44.050 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected 2024-12-25 08:22:44.050 DEBUG 1 --- [ task-1] o.f.core.internal.command.DbMigrate .32 : | Successfully completed migration of schema "PUBLIC" to version "2.1.4 - OPERATION" 2024-12-25 08:22:44.052 DEBUG 1 --- [ task-1] o.f.c.i.s.JdbcTableSchemaHistory .32 : | Schema History table "PUBLIC"."flyway_schema_history" successfully updated to reflect changes 2024-12-25 08:22:44.054 DEBUG 1 --- [ task-1] o.flywaydb.core.internal.parser.Parser .32 : | Parsing V2_1_5__TableVector.sql ... 2024-12-25 08:22:44.055 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 1: CREATE TABLE IF NOT EXISTS table_vector_mapping ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键', api_key varchar(128) DEFAULT NULL COMMENT 'api key', data_source_id bigint(20) unsigned DEFAULT NULL COMMENT '数据源连接ID', database text DEFAULT NULL COMMENT '数据库名称', schema text DEFAULT NULL COMMENT 'schema名称', status varchar(4) DEFAULT NULL COMMENT '向量保存状态', PRIMARY KEY (id) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='milvus映射表保存记录' 2024-12-25 08:22:44.056 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 12: create INDEX idx_api_key on table_vector_mapping(api_key) 2024-12-25 08:22:44.056 DEBUG 1 --- [ task-1] o.f.core.internal.command.DbMigrate .32 : | Starting migration of schema "PUBLIC" to version "2.1.5 - TableVector" ... 2024-12-25 08:22:44.056 INFO 1 --- [ task-1] o.f.core.internal.command.DbMigrate .35 : | Migrating schema "PUBLIC" to version "2.1.5 - TableVector" 2024-12-25 08:22:44.056 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: CREATE TABLE IF NOT EXISTS table_vector_mapping ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键', api_key varchar(128) DEFAULT NULL COMMENT 'api key', data_source_id bigint(20) unsigned DEFAULT NULL COMMENT '数据源连接ID', database text DEFAULT NULL COMMENT '数据库名称', schema text DEFAULT NULL COMMENT 'schema名称', status varchar(4) DEFAULT NULL COMMENT '向量保存状态', PRIMARY KEY (id) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='milvus映射表保存记录' 2024-12-25 08:22:44.057 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected 2024-12-25 08:22:44.057 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: create INDEX idx_api_key on table_vector_mapping(api_key) 2024-12-25 08:22:44.058 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected 2024-12-25 08:22:44.058 DEBUG 1 --- [ task-1] o.f.core.internal.command.DbMigrate .32 : | Successfully completed migration of schema "PUBLIC" to version "2.1.5 - TableVector" 2024-12-25 08:22:44.059 DEBUG 1 --- [ task-1] o.f.c.i.s.JdbcTableSchemaHistory .32 : | Schema History table "PUBLIC"."flyway_schema_history" successfully updated to reflect changes 2024-12-25 08:22:44.061 DEBUG 1 --- [ task-1] o.flywaydb.core.internal.parser.Parser .32 : | Parsing V2_1_6__TableVectorUpdate.sql ... 2024-12-25 08:22:44.062 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 1: ALTER TABLE table_vector_mapping ALTER COLUMN status VARCHAR(64) 2024-12-25 08:22:44.062 DEBUG 1 --- [ task-1] o.f.core.internal.command.DbMigrate .32 : | Starting migration of schema "PUBLIC" to version "2.1.6 - TableVectorUpdate" ... 2024-12-25 08:22:44.062 INFO 1 --- [ task-1] o.f.core.internal.command.DbMigrate .35 : | Migrating schema "PUBLIC" to version "2.1.6 - TableVectorUpdate" 2024-12-25 08:22:44.063 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: ALTER TABLE table_vector_mapping ALTER COLUMN status VARCHAR(64) 2024-12-25 08:22:44.066 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected 2024-12-25 08:22:44.066 DEBUG 1 --- [ task-1] o.f.core.internal.command.DbMigrate .32 : | Successfully completed migration of schema "PUBLIC" to version "2.1.6 - TableVectorUpdate" 2024-12-25 08:22:44.067 DEBUG 1 --- [ task-1] o.f.c.i.s.JdbcTableSchemaHistory .32 : | Schema History table "PUBLIC"."flyway_schema_history" successfully updated to reflect changes 2024-12-25 08:22:44.068 DEBUG 1 --- [ task-1] o.flywaydb.core.internal.parser.Parser .32 : | Parsing V2_1_7__DATASOURCE.sql ... 2024-12-25 08:22:44.069 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 1: ALTER TABLE data_source ADD COLUMN service_name varchar(128) NULL COMMENT '服务名' 2024-12-25 08:22:44.070 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 2: ALTER TABLE data_source ADD COLUMN service_type varchar(128) NULL COMMENT '服务类型' 2024-12-25 08:22:44.070 DEBUG 1 --- [ task-1] o.f.core.internal.command.DbMigrate .32 : | Starting migration of schema "PUBLIC" to version "2.1.7 - DATASOURCE" ... 2024-12-25 08:22:44.070 INFO 1 --- [ task-1] o.f.core.internal.command.DbMigrate .35 : | Migrating schema "PUBLIC" to version "2.1.7 - DATASOURCE" 2024-12-25 08:22:44.070 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: ALTER TABLE data_source ADD COLUMN service_name varchar(128) NULL COMMENT '服务名' 2024-12-25 08:22:44.074 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected 2024-12-25 08:22:44.074 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: ALTER TABLE data_source ADD COLUMN service_type varchar(128) NULL COMMENT '服务类型' 2024-12-25 08:22:44.077 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected 2024-12-25 08:22:44.077 DEBUG 1 --- [ task-1] o.f.core.internal.command.DbMigrate .32 : | Successfully completed migration of schema "PUBLIC" to version "2.1.7 - DATASOURCE" 2024-12-25 08:22:44.078 DEBUG 1 --- [ task-1] o.f.c.i.s.JdbcTableSchemaHistory .32 : | Schema History table "PUBLIC"."flyway_schema_history" successfully updated to reflect changes 2024-12-25 08:22:44.080 DEBUG 1 --- [ task-1] o.flywaydb.core.internal.parser.Parser .32 : | Parsing V2_1_8__Chart.sql ... 2024-12-25 08:22:44.080 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 1: ALTER TABLE chart ADD COLUMN schema_name varchar(128) NULL COMMENT 'schemaName' 2024-12-25 08:22:44.081 DEBUG 1 --- [ task-1] o.f.core.internal.command.DbMigrate .32 : | Starting migration of schema "PUBLIC" to version "2.1.8 - Chart" ... 2024-12-25 08:22:44.081 INFO 1 --- [ task-1] o.f.core.internal.command.DbMigrate .35 : | Migrating schema "PUBLIC" to version "2.1.8 - Chart" 2024-12-25 08:22:44.081 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: ALTER TABLE chart ADD COLUMN schema_name varchar(128) NULL COMMENT 'schemaName' 2024-12-25 08:22:44.084 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected 2024-12-25 08:22:44.084 DEBUG 1 --- [ task-1] o.f.core.internal.command.DbMigrate .32 : | Successfully completed migration of schema "PUBLIC" to version "2.1.8 - Chart" 2024-12-25 08:22:44.085 DEBUG 1 --- [ task-1] o.f.c.i.s.JdbcTableSchemaHistory .32 : | Schema History table "PUBLIC"."flyway_schema_history" successfully updated to reflect changes 2024-12-25 08:22:44.087 DEBUG 1 --- [ task-1] o.flywaydb.core.internal.parser.Parser .32 : | Parsing V2_1_9__task.sql ... 2024-12-25 08:22:44.088 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 1: CREATE TABLE IF NOT EXISTS task ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键', gmt_create datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', gmt_modified datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间', data_source_id bigint(20) unsigned NULL COMMENT '数据源连接ID', database_name varchar(128) DEFAULT NULL COMMENT 'db名称', schema_name varchar(128) DEFAULT NULL COMMENT 'schema名称', table_name varchar(128) DEFAULT NULL COMMENT 'table_name', deleted varchar(10) DEFAULT NULL COMMENT '是否被删除,y表示删除,n表示未删除', user_id bigint(20) unsigned NOT NULL DEFAULT 0 COMMENT '用户id', task_type varchar(128) DEFAULT NULL COMMENT 'task type, such as: DOWNLOAD_DATA, UPLOAD_TABLE_DATA, DOWNLOAD_TABLE_STRUCTURE, UPLOAD_TABLE_STRUCTURE,', task_status varchar(128) DEFAULT NULL COMMENT 'task status', task_progress varchar(128) DEFAULT NULL COMMENT 'task progress', task_name varchar(128) DEFAULT NULL COMMENT 'task name', content blob DEFAULT NULL COMMENT 'task content', download_url varchar(512) DEFAULT NULL COMMENT 'down load url', PRIMARY KEY (id) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='TASK TABLE' 2024-12-25 08:22:44.089 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 20: create INDEX idx_task_user_id on task(user_id) 2024-12-25 08:22:44.089 DEBUG 1 --- [ task-1] o.f.core.internal.command.DbMigrate .32 : | Starting migration of schema "PUBLIC" to version "2.1.9 - task" ... 2024-12-25 08:22:44.089 INFO 1 --- [ task-1] o.f.core.internal.command.DbMigrate .35 : | Migrating schema "PUBLIC" to version "2.1.9 - task" 2024-12-25 08:22:44.089 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: CREATE TABLE IF NOT EXISTS task ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键', gmt_create datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', gmt_modified datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间', data_source_id bigint(20) unsigned NULL COMMENT '数据源连接ID', database_name varchar(128) DEFAULT NULL COMMENT 'db名称', schema_name varchar(128) DEFAULT NULL COMMENT 'schema名称', table_name varchar(128) DEFAULT NULL COMMENT 'table_name', deleted varchar(10) DEFAULT NULL COMMENT '是否被删除,y表示删除,n表示未删除', user_id bigint(20) unsigned NOT NULL DEFAULT 0 COMMENT '用户id', task_type varchar(128) DEFAULT NULL COMMENT 'task type, such as: DOWNLOAD_DATA, UPLOAD_TABLE_DATA, DOWNLOAD_TABLE_STRUCTURE, UPLOAD_TABLE_STRUCTURE,', task_status varchar(128) DEFAULT NULL COMMENT 'task status', task_progress varchar(128) DEFAULT NULL COMMENT 'task progress', task_name varchar(128) DEFAULT NULL COMMENT 'task name', content blob DEFAULT NULL COMMENT 'task content', download_url varchar(512) DEFAULT NULL COMMENT 'down load url', PRIMARY KEY (id) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='TASK TABLE' 2024-12-25 08:22:44.091 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected 2024-12-25 08:22:44.091 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: create INDEX idx_task_user_id on task(user_id) 2024-12-25 08:22:44.091 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected 2024-12-25 08:22:44.091 DEBUG 1 --- [ task-1] o.f.core.internal.command.DbMigrate .32 : | Successfully completed migration of schema "PUBLIC" to version "2.1.9 - task" 2024-12-25 08:22:44.092 DEBUG 1 --- [ task-1] o.f.c.i.s.JdbcTableSchemaHistory .32 : | Schema History table "PUBLIC"."flyway_schema_history" successfully updated to reflect changes 2024-12-25 08:22:44.094 DEBUG 1 --- [ task-1] o.flywaydb.core.internal.parser.Parser .32 : | Parsing V2_1_10__REMOVEdEMO.sql ... 2024-12-25 08:22:44.094 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 1: delete from DATA_SOURCE where ALIAS ='[email protected]' 2024-12-25 08:22:44.094 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 3: delete from DASHBOARD where id =ID 2024-12-25 08:22:44.094 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 5: delete from CHART where id<=3 2024-12-25 08:22:44.095 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 7: delete from DASHBOARD_CHART_RELATION where CHART_ID<=3 2024-12-25 08:22:44.095 DEBUG 1 --- [ task-1] o.f.core.internal.command.DbMigrate .32 : | Starting migration of schema "PUBLIC" to version "2.1.10 - REMOVEdEMO" ... 2024-12-25 08:22:44.095 INFO 1 --- [ task-1] o.f.core.internal.command.DbMigrate .35 : | Migrating schema "PUBLIC" to version "2.1.10 - REMOVEdEMO" 2024-12-25 08:22:44.095 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: delete from DATA_SOURCE where ALIAS ='[email protected]' 2024-12-25 08:22:44.096 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 1 row affected 2024-12-25 08:22:44.096 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: delete from DASHBOARD where id =ID 2024-12-25 08:22:44.096 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 1 row affected 2024-12-25 08:22:44.097 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: delete from CHART where id<=3 2024-12-25 08:22:44.097 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 3 rows affected 2024-12-25 08:22:44.097 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: delete from DASHBOARD_CHART_RELATION where CHART_ID<=3 2024-12-25 08:22:44.097 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 3 rows affected 2024-12-25 08:22:44.097 DEBUG 1 --- [ task-1] o.f.core.internal.command.DbMigrate .32 : | Successfully completed migration of schema "PUBLIC" to version "2.1.10 - REMOVEdEMO" 2024-12-25 08:22:44.098 DEBUG 1 --- [ task-1] o.f.c.i.s.JdbcTableSchemaHistory .32 : | Schema History table "PUBLIC"."flyway_schema_history" successfully updated to reflect changes 2024-12-25 08:22:44.099 INFO 1 --- [ task-1] o.f.core.internal.command.DbMigrate .35 : | Successfully applied 18 migrations to schema "PUBLIC", now at version v2.1.10 (execution time 00:00.441s) 2024-12-25 08:22:44.105 DEBUG 1 --- [ task-1] org.flywaydb.core.FlywayExecutor .32 : | Memory usage: 49 of 226M 2024-12-25 08:22:44.105 INFO 1 --- [ task-1] a.c.s.tools.common.util.ConfigUtils .104 : | set config:{"jwtSecretKey":"32de412ac8214f99a01d4eb073b6a117","systemUuid":"8fec1b71f5b04ba5ac7ce381a8a7a8f1"}
jdbc_driver
id
gmt_create
gmt_modified
db_type
jdbc_driver_class
data_source
driver_config
operation_saved
operation_type
environment
create_user_id
modified_user_id
name
short_name
color
environment_id
user_id
kind
dbhub_user
role_code
status
team
code
description
team_user
team_id
data_source_access
data_source_id
access_object_type
access_object_id
operation_log
dashboard
chart
table_cache_version
database_name
schema_name
key
version
table_count
table_cache
table_name
columns
extend_info
operation_rows
use_time
table_vector_mapping
api_key
database
schema
service_name
service_type
task
deleted
task_type
task_status
task_progress
task_name
content
download_url
The text was updated successfully, but these errors were encountered:
No branches or pull requests
通过docker的方式部署到云服务器，安全组已经开放了10824端口，但是访问ip:10824无法访问，通过netstat命令也没监听到10824端口的服务，docker的日志如下：
l ...
2024-12-25 08:22:43.850 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 1: CREATE TABLE IF NOT EXISTS
jdbc_driver(idbigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',gmt_createdatetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',gmt_modifieddatetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',db_typevarchar(32) NOT NULL COMMENT 'db类型',jdbc_drivervarchar(512) DEFAULT NULL COMMENT 'jar包',jdbc_driver_classvarchar(512) DEFAULT NULL COMMENT 'driver class类',PRIMARY KEY (
id)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='自定义驱动表'
2024-12-25 08:22:43.851 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 11: create INDEX idx_db_type on jdbc_driver(db_type)
2024-12-25 08:22:43.851 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 12: ALTER TABLE
data_sourceADD COLUMNdriver_configvarchar(1024) NULL COMMENT 'driver_config配置'2024-12-25 08:22:43.851 DEBUG 1 --- [ task-1] o.f.core.internal.command.DbMigrate .32 : | Starting migration of schema "PUBLIC" to version "1.0.7 - 自定义驱动" ...
2024-12-25 08:22:43.852 INFO 1 --- [ task-1] o.f.core.internal.command.DbMigrate .35 : | Migrating schema "PUBLIC" to version "1.0.7 - 自定义驱动"
2024-12-25 08:22:43.852 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: CREATE TABLE IF NOT EXISTS
jdbc_driver(idbigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',gmt_createdatetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',gmt_modifieddatetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',db_typevarchar(32) NOT NULL COMMENT 'db类型',jdbc_drivervarchar(512) DEFAULT NULL COMMENT 'jar包',jdbc_driver_classvarchar(512) DEFAULT NULL COMMENT 'driver class类',PRIMARY KEY (
id)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='自定义驱动表'
2024-12-25 08:22:43.866 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected
2024-12-25 08:22:43.866 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: create INDEX idx_db_type on jdbc_driver(db_type)
2024-12-25 08:22:43.867 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected
2024-12-25 08:22:43.867 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: ALTER TABLE
data_sourceADD COLUMNdriver_configvarchar(1024) NULL COMMENT 'driver_config配置'2024-12-25 08:22:43.872 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected
2024-12-25 08:22:43.872 DEBUG 1 --- [ task-1] o.f.core.internal.command.DbMigrate .32 : | Successfully completed migration of schema "PUBLIC" to version "1.0.7 - 自定义驱动"
2024-12-25 08:22:43.874 DEBUG 1 --- [ task-1] o.f.c.i.s.JdbcTableSchemaHistory .32 : | Schema History table "PUBLIC"."flyway_schema_history" successfully updated to reflect changes
2024-12-25 08:22:43.876 DEBUG 1 --- [ task-1] o.flywaydb.core.internal.parser.Parser .32 : | Parsing V1_0_8__操作保存类型.sql ...
2024-12-25 08:22:43.878 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 1: ALTER TABLE
operation_savedADD COLUMNoperation_typevarchar(1024) NULL COMMENT '操作类型'2024-12-25 08:22:43.878 DEBUG 1 --- [ task-1] o.f.core.internal.command.DbMigrate .32 : | Starting migration of schema "PUBLIC" to version "1.0.8 - 操作保存类型" ...
2024-12-25 08:22:43.878 INFO 1 --- [ task-1] o.f.core.internal.command.DbMigrate .35 : | Migrating schema "PUBLIC" to version "1.0.8 - 操作保存类型"
2024-12-25 08:22:43.879 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: ALTER TABLE
operation_savedADD COLUMNoperation_typevarchar(1024) NULL COMMENT '操作类型'2024-12-25 08:22:43.883 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected
2024-12-25 08:22:43.883 DEBUG 1 --- [ task-1] o.f.core.internal.command.DbMigrate .32 : | Successfully completed migration of schema "PUBLIC" to version "1.0.8 - 操作保存类型"
2024-12-25 08:22:43.884 DEBUG 1 --- [ task-1] o.f.c.i.s.JdbcTableSchemaHistory .32 : | Schema History table "PUBLIC"."flyway_schema_history" successfully updated to reflect changes
2024-12-25 08:22:43.887 DEBUG 1 --- [ task-1] o.flywaydb.core.internal.parser.Parser .32 : | Parsing V2_1_0__支持环境、用户权限.sql ...
2024-12-25 08:22:43.897 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 1: CREATE TABLE IF NOT EXISTS
environment(
idbigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',gmt_createdatetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',gmt_modifieddatetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',create_user_idbigint(20) unsigned NOT NULL COMMENT '创建人用户id',modified_user_idbigint(20) unsigned NOT NULL COMMENT '修改人用户id',namevarchar(128) DEFAULT NOT NULL COMMENT '环境名称',short_namevarchar(128) DEFAULT NULL COMMENT '环境缩写',colorvarchar(32) DEFAULT NULL COMMENT '颜色',PRIMARY KEY (
id)) ENGINE = InnoDB
DEFAULT CHARSET = utf8mb4 COMMENT ='数据库连接环境'
2024-12-25 08:22:43.898 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 16: INSERT INTO
environment(
id,create_user_id,modified_user_id,name,short_name,color)VALUES (1, 1, 1, 'Release Environment', 'RELEASE', 'RED')
2024-12-25 08:22:43.898 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 19: INSERT INTO
environment(
id,create_user_id,modified_user_id,name,short_name,color)VALUES (2, 1, 1, 'Test Environment', 'TEST', 'GREEN')
2024-12-25 08:22:43.898 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 23: ALTER TABLE
data_sourceADD COLUMN
environment_idbigint(20) unsigned NOT NULL DEFAULT 2 COMMENT '环境id'2024-12-25 08:22:43.899 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 26: ALTER TABLE
data_sourcemodify COLUMN
user_idbigint(20) unsigned NOT NULL DEFAULT 1 COMMENT '用户id'2024-12-25 08:22:43.899 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 29: ALTER TABLE
data_sourceADD COLUMN
kindvarchar(32) NOT NULL DEFAULT 'PRIVATE' COMMENT '连接类型'2024-12-25 08:22:43.899 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 32: update data_source
set user_id= 1
2024-12-25 08:22:43.899 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 35: ALTER TABLE
dbhub_userADD COLUMN
role_codevarchar(32) DEFAULT NULL COMMENT '角色编码'2024-12-25 08:22:43.900 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 38: ALTER TABLE
dbhub_userADD
statusvarchar(32) NOT NULL DEFAULT 'VALID' COMMENT '用户状态'2024-12-25 08:22:43.900 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 41: ALTER TABLE
dbhub_userADD
create_user_idbigint(20) unsigned NOT NULL DEFAULT 1 COMMENT '创建人用户id'2024-12-25 08:22:43.900 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 44: ALTER TABLE
dbhub_userADD
modified_user_idbigint(20) unsigned NOT NULL DEFAULT 1 COMMENT '修改人用户id'2024-12-25 08:22:43.900 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 47: update dbhub_user
set role_code= 'DESKTOP',user_name='_desktop_default_user_name',password='_desktop_default_user_name',nick_name='Desktop User'
where id = 1
2024-12-25 08:22:43.901 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 50: INSERT INTO DBHUB_USER (USER_NAME, PASSWORD, NICK_NAME, EMAIL, ROLE_CODE) VALUES ('chat2db', 'chat2db', 'Administrator', null, 'ADMIN')
2024-12-25 08:22:43.901 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 52: create UNIQUE INDEX uk_user_user_name on dbhub_user (user_name)
2024-12-25 08:22:43.902 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 55: CREATE TABLE IF NOT EXISTS
team(
idbigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',gmt_createdatetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',gmt_modifieddatetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',create_user_idbigint(20) unsigned NOT NULL COMMENT '创建人用户id',modified_user_idbigint(20) unsigned NOT NULL COMMENT '修改人用户id',codevarchar(128) DEFAULT NOT NULL COMMENT '团队编码',namevarchar(512) DEFAULT NULL COMMENT '团队名称',statusvarchar(32) NOT NULL DEFAULT 'VALID' COMMENT '团队状态',descriptiontext DEFAULT NULL COMMENT '团队描述',PRIMARY KEY (
id)) ENGINE = InnoDB
DEFAULT CHARSET = utf8mb4 COMMENT ='团队'
2024-12-25 08:22:43.902 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 71: create UNIQUE INDEX uk_team_code on team (code)
2024-12-25 08:22:43.903 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 74: CREATE TABLE IF NOT EXISTS
team_user(
idbigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',gmt_createdatetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',gmt_modifieddatetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',create_user_idbigint(20) unsigned NOT NULL COMMENT '创建人用户id',modified_user_idbigint(20) unsigned NOT NULL COMMENT '修改人用户id',team_idbigint(20) unsigned NOT NULL COMMENT '团队id',user_idbigint(20) unsigned NOT NULL COMMENT '用户id',PRIMARY KEY (
id)) ENGINE = InnoDB
DEFAULT CHARSET = utf8mb4 COMMENT ='用户团队表'
2024-12-25 08:22:43.903 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 88: create INDEX idx_team_user_team_id on team_user (
team_id)2024-12-25 08:22:43.903 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 89: create INDEX idx_team_user_user_id on team_user (
user_id)2024-12-25 08:22:43.904 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 90: create UNIQUE INDEX uk_team_user on team_user (
team_id,user_id)2024-12-25 08:22:43.904 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 92: CREATE TABLE IF NOT EXISTS
data_source_access(
idbigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',gmt_createdatetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',gmt_modifieddatetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',create_user_idbigint(20) unsigned NOT NULL COMMENT '创建人用户id',modified_user_idbigint(20) unsigned NOT NULL COMMENT '修改人用户id',data_source_idbigint(20) unsigned NOT NULL COMMENT '数据源id',access_object_typevarchar(32) NOT NULL COMMENT '授权类型',access_object_idbigint(20) unsigned NOT NULL COMMENT '授权id,根据类型区分是用户还是团队',PRIMARY KEY (
id)) ENGINE = InnoDB
DEFAULT CHARSET = utf8mb4 COMMENT ='数据源授权'
2024-12-25 08:22:43.904 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 107: create INDEX idx_data_source_access_data_source_id on data_source_access (
data_source_id)2024-12-25 08:22:43.905 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 108: create INDEX idx_data_source_access_access_object_id on data_source_access (
access_object_type,access_object_id)2024-12-25 08:22:43.905 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 109: create UNIQUE INDEX uk_data_source_access on data_source_access (
data_source_id,access_object_type,access_object_id)2024-12-25 08:22:43.905 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 111: ALTER TABLE
operation_savedmodify COLUMN
user_idbigint(20) unsigned NOT NULL DEFAULT 1 COMMENT '用户id'2024-12-25 08:22:43.905 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 114: update operation_saved
set user_id= 1
2024-12-25 08:22:43.905 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 117: ALTER TABLE
operation_logmodify COLUMN
user_idbigint(20) unsigned NOT NULL DEFAULT 1 COMMENT '用户id'2024-12-25 08:22:43.906 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 120: update operation_log
set user_id= 1
2024-12-25 08:22:43.906 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 123: ALTER TABLE
dashboardmodify
user_idbigint(20) unsigned NOT NULL DEFAULT 1 COMMENT '用户id'2024-12-25 08:22:43.913 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 125: update dashboard
set user_id= 1
2024-12-25 08:22:43.913 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 129: ALTER TABLE
chartmodify
user_idbigint(20) unsigned NOT NULL DEFAULT 1 COMMENT '用户id'2024-12-25 08:22:43.914 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 131: update chart
set user_id= 1
2024-12-25 08:22:43.914 DEBUG 1 --- [ task-1] o.f.core.internal.command.DbMigrate .32 : | Starting migration of schema "PUBLIC" to version "2.1.0 - 支持环境、用户权限" ...
2024-12-25 08:22:43.914 INFO 1 --- [ task-1] o.f.core.internal.command.DbMigrate .35 : | Migrating schema "PUBLIC" to version "2.1.0 - 支持环境、用户权限"
2024-12-25 08:22:43.914 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: CREATE TABLE IF NOT EXISTS
environment(
idbigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',gmt_createdatetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',gmt_modifieddatetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',create_user_idbigint(20) unsigned NOT NULL COMMENT '创建人用户id',modified_user_idbigint(20) unsigned NOT NULL COMMENT '修改人用户id',namevarchar(128) DEFAULT NOT NULL COMMENT '环境名称',short_namevarchar(128) DEFAULT NULL COMMENT '环境缩写',colorvarchar(32) DEFAULT NULL COMMENT '颜色',PRIMARY KEY (
id)) ENGINE = InnoDB
DEFAULT CHARSET = utf8mb4 COMMENT ='数据库连接环境'
2024-12-25 08:22:43.916 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected
2024-12-25 08:22:43.916 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: INSERT INTO
environment(
id,create_user_id,modified_user_id,name,short_name,color)VALUES (1, 1, 1, 'Release Environment', 'RELEASE', 'RED')
2024-12-25 08:22:43.917 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 1 row affected
2024-12-25 08:22:43.917 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: INSERT INTO
environment(
id,create_user_id,modified_user_id,name,short_name,color)VALUES (2, 1, 1, 'Test Environment', 'TEST', 'GREEN')
2024-12-25 08:22:43.918 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 1 row affected
2024-12-25 08:22:43.918 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: ALTER TABLE
data_sourceADD COLUMN
environment_idbigint(20) unsigned NOT NULL DEFAULT 2 COMMENT '环境id'2024-12-25 08:22:43.926 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected
2024-12-25 08:22:43.927 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: ALTER TABLE
data_sourcemodify COLUMN
user_idbigint(20) unsigned NOT NULL DEFAULT 1 COMMENT '用户id'2024-12-25 08:22:43.949 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected
2024-12-25 08:22:43.949 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: ALTER TABLE
data_sourceADD COLUMN
kindvarchar(32) NOT NULL DEFAULT 'PRIVATE' COMMENT '连接类型'2024-12-25 08:22:43.954 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected
2024-12-25 08:22:43.954 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: update data_source
set user_id= 1
2024-12-25 08:22:43.957 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 1 row affected
2024-12-25 08:22:43.957 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: ALTER TABLE
dbhub_userADD COLUMN
role_codevarchar(32) DEFAULT NULL COMMENT '角色编码'2024-12-25 08:22:43.961 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected
2024-12-25 08:22:43.961 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: ALTER TABLE
dbhub_userADD
statusvarchar(32) NOT NULL DEFAULT 'VALID' COMMENT '用户状态'2024-12-25 08:22:43.965 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected
2024-12-25 08:22:43.965 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: ALTER TABLE
dbhub_userADD
create_user_idbigint(20) unsigned NOT NULL DEFAULT 1 COMMENT '创建人用户id'2024-12-25 08:22:43.970 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected
2024-12-25 08:22:43.970 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: ALTER TABLE
dbhub_userADD
modified_user_idbigint(20) unsigned NOT NULL DEFAULT 1 COMMENT '修改人用户id'2024-12-25 08:22:43.972 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected
2024-12-25 08:22:43.972 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: update dbhub_user
set role_code= 'DESKTOP',user_name='_desktop_default_user_name',password='_desktop_default_user_name',nick_name='Desktop User'
where id = 1
2024-12-25 08:22:43.973 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 1 row affected
2024-12-25 08:22:43.973 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: INSERT INTO DBHUB_USER (USER_NAME, PASSWORD, NICK_NAME, EMAIL, ROLE_CODE) VALUES ('chat2db', 'chat2db', 'Administrator', null, 'ADMIN')
2024-12-25 08:22:43.973 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 1 row affected
2024-12-25 08:22:43.973 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: create UNIQUE INDEX uk_user_user_name on dbhub_user (user_name)
2024-12-25 08:22:43.984 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected
2024-12-25 08:22:43.984 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: CREATE TABLE IF NOT EXISTS
team(
idbigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',gmt_createdatetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',gmt_modifieddatetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',create_user_idbigint(20) unsigned NOT NULL COMMENT '创建人用户id',modified_user_idbigint(20) unsigned NOT NULL COMMENT '修改人用户id',codevarchar(128) DEFAULT NOT NULL COMMENT '团队编码',namevarchar(512) DEFAULT NULL COMMENT '团队名称',statusvarchar(32) NOT NULL DEFAULT 'VALID' COMMENT '团队状态',descriptiontext DEFAULT NULL COMMENT '团队描述',PRIMARY KEY (
id)) ENGINE = InnoDB
DEFAULT CHARSET = utf8mb4 COMMENT ='团队'
2024-12-25 08:22:43.985 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected
2024-12-25 08:22:43.986 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: create UNIQUE INDEX uk_team_code on team (code)
2024-12-25 08:22:43.987 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected
2024-12-25 08:22:43.987 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: CREATE TABLE IF NOT EXISTS
team_user(
idbigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',gmt_createdatetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',gmt_modifieddatetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',create_user_idbigint(20) unsigned NOT NULL COMMENT '创建人用户id',modified_user_idbigint(20) unsigned NOT NULL COMMENT '修改人用户id',team_idbigint(20) unsigned NOT NULL COMMENT '团队id',user_idbigint(20) unsigned NOT NULL COMMENT '用户id',PRIMARY KEY (
id)) ENGINE = InnoDB
DEFAULT CHARSET = utf8mb4 COMMENT ='用户团队表'
2024-12-25 08:22:43.988 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected
2024-12-25 08:22:43.988 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: create INDEX idx_team_user_team_id on team_user (
team_id)2024-12-25 08:22:43.989 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected
2024-12-25 08:22:43.989 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: create INDEX idx_team_user_user_id on team_user (
user_id)2024-12-25 08:22:43.990 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected
2024-12-25 08:22:43.990 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: create UNIQUE INDEX uk_team_user on team_user (
team_id,user_id)2024-12-25 08:22:43.991 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected
2024-12-25 08:22:43.991 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: CREATE TABLE IF NOT EXISTS
data_source_access(
idbigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',gmt_createdatetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',gmt_modifieddatetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',create_user_idbigint(20) unsigned NOT NULL COMMENT '创建人用户id',modified_user_idbigint(20) unsigned NOT NULL COMMENT '修改人用户id',data_source_idbigint(20) unsigned NOT NULL COMMENT '数据源id',access_object_typevarchar(32) NOT NULL COMMENT '授权类型',access_object_idbigint(20) unsigned NOT NULL COMMENT '授权id,根据类型区分是用户还是团队',PRIMARY KEY (
id)) ENGINE = InnoDB
DEFAULT CHARSET = utf8mb4 COMMENT ='数据源授权'
2024-12-25 08:22:43.992 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected
2024-12-25 08:22:43.992 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: create INDEX idx_data_source_access_data_source_id on data_source_access (
data_source_id)2024-12-25 08:22:43.993 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected
2024-12-25 08:22:43.993 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: create INDEX idx_data_source_access_access_object_id on data_source_access (
access_object_type,access_object_id)2024-12-25 08:22:43.994 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected
2024-12-25 08:22:43.994 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: create UNIQUE INDEX uk_data_source_access on data_source_access (
data_source_id,access_object_type,access_object_id)2024-12-25 08:22:43.994 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected
2024-12-25 08:22:43.994 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: ALTER TABLE
operation_savedmodify COLUMN
user_idbigint(20) unsigned NOT NULL DEFAULT 1 COMMENT '用户id'2024-12-25 08:22:43.997 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected
2024-12-25 08:22:43.998 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: update operation_saved
set user_id= 1
2024-12-25 08:22:43.998 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected
2024-12-25 08:22:43.998 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: ALTER TABLE
operation_logmodify COLUMN
user_idbigint(20) unsigned NOT NULL DEFAULT 1 COMMENT '用户id'2024-12-25 08:22:44.000 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected
2024-12-25 08:22:44.001 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: update operation_log
set user_id= 1
2024-12-25 08:22:44.001 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected
2024-12-25 08:22:44.001 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: ALTER TABLE
dashboardmodify
user_idbigint(20) unsigned NOT NULL DEFAULT 1 COMMENT '用户id'2024-12-25 08:22:44.004 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected
2024-12-25 08:22:44.004 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: update dashboard
set user_id= 1
2024-12-25 08:22:44.004 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 1 row affected
2024-12-25 08:22:44.005 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: ALTER TABLE
chartmodify
user_idbigint(20) unsigned NOT NULL DEFAULT 1 COMMENT '用户id'2024-12-25 08:22:44.008 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected
2024-12-25 08:22:44.008 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: update chart
set user_id= 1
2024-12-25 08:22:44.009 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 3 rows affected
2024-12-25 08:22:44.009 DEBUG 1 --- [ task-1] o.f.core.internal.command.DbMigrate .32 : | Successfully completed migration of schema "PUBLIC" to version "2.1.0 - 支持环境、用户权限"
2024-12-25 08:22:44.010 DEBUG 1 --- [ task-1] o.f.c.i.s.JdbcTableSchemaHistory .32 : | Schema History table "PUBLIC"."flyway_schema_history" successfully updated to reflect changes
2024-12-25 08:22:44.012 DEBUG 1 --- [ task-1] o.flywaydb.core.internal.parser.Parser .32 : | Parsing V2_1_1__TableCache.sql ...
2024-12-25 08:22:44.014 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 1: CREATE TABLE IF NOT EXISTS
table_cache_version(idbigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',gmt_createdatetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',gmt_modifieddatetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',data_source_idbigint(20) unsigned NOT NULL COMMENT '数据源连接ID',database_namevarchar(256) DEFAULT NULL COMMENT 'db名称',schema_namevarchar(256) DEFAULT NULL COMMENT 'schema名称',keyvarchar(256) DEFAULT NULL COMMENT '唯一索引',versionbigint(20) unsigned NOT NULL COMMENT '版本',table_countbigint(20) unsigned NOT NULL COMMENT '表数量',statusvarchar(256) DEFAULT NULL COMMENT '状态',PRIMARY KEY (
id)) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='table cache version'
2024-12-25 08:22:44.014 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 15: create INDEX idx_table_cache_version_data_source_id on table_cache_version(
data_source_id)2024-12-25 08:22:44.015 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 16: create UNIQUE INDEX uk_table_cache_version_key on table_cache_version(
key)2024-12-25 08:22:44.015 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 18: CREATE TABLE IF NOT EXISTS
table_cache(idbigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',gmt_createdatetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',gmt_modifieddatetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',data_source_idbigint(20) unsigned NOT NULL COMMENT '数据源连接ID',database_namevarchar(256) DEFAULT NULL COMMENT 'db名称',schema_namevarchar(256) DEFAULT NULL COMMENT 'schema名称',table_namevarchar(256) DEFAULT NULL COMMENT 'table名称',keyvarchar(256) DEFAULT NULL COMMENT '唯一索引',versionbigint(20) unsigned NOT NULL COMMENT '版本',columnsvarchar(2048) DEFAULT NULL COMMENT '表字段',extend_infovarchar(2048) NULL COMMENT '自定义扩展字段json',PRIMARY KEY (
id)) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='table cache'
2024-12-25 08:22:44.016 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 33: create INDEX idx_table_cache_data_source_id on table_cache(
data_source_id)2024-12-25 08:22:44.016 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 34: create INDEX idx_table_cache_key_version on table_cache(
key,version)2024-12-25 08:22:44.016 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 35: create INDEX idx_table_cache_key_table_name on table_cache(
key,table_name)2024-12-25 08:22:44.016 DEBUG 1 --- [ task-1] o.f.core.internal.command.DbMigrate .32 : | Starting migration of schema "PUBLIC" to version "2.1.1 - TableCache" ...
2024-12-25 08:22:44.016 INFO 1 --- [ task-1] o.f.core.internal.command.DbMigrate .35 : | Migrating schema "PUBLIC" to version "2.1.1 - TableCache"
2024-12-25 08:22:44.017 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: CREATE TABLE IF NOT EXISTS
table_cache_version(idbigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',gmt_createdatetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',gmt_modifieddatetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',data_source_idbigint(20) unsigned NOT NULL COMMENT '数据源连接ID',database_namevarchar(256) DEFAULT NULL COMMENT 'db名称',schema_namevarchar(256) DEFAULT NULL COMMENT 'schema名称',keyvarchar(256) DEFAULT NULL COMMENT '唯一索引',versionbigint(20) unsigned NOT NULL COMMENT '版本',table_countbigint(20) unsigned NOT NULL COMMENT '表数量',statusvarchar(256) DEFAULT NULL COMMENT '状态',PRIMARY KEY (
id)) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='table cache version'
2024-12-25 08:22:44.018 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected
2024-12-25 08:22:44.018 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: create INDEX idx_table_cache_version_data_source_id on table_cache_version(
data_source_id)2024-12-25 08:22:44.019 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected
2024-12-25 08:22:44.019 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: create UNIQUE INDEX uk_table_cache_version_key on table_cache_version(
key)2024-12-25 08:22:44.020 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected
2024-12-25 08:22:44.020 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: CREATE TABLE IF NOT EXISTS
table_cache(idbigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',gmt_createdatetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',gmt_modifieddatetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',data_source_idbigint(20) unsigned NOT NULL COMMENT '数据源连接ID',database_namevarchar(256) DEFAULT NULL COMMENT 'db名称',schema_namevarchar(256) DEFAULT NULL COMMENT 'schema名称',table_namevarchar(256) DEFAULT NULL COMMENT 'table名称',keyvarchar(256) DEFAULT NULL COMMENT '唯一索引',versionbigint(20) unsigned NOT NULL COMMENT '版本',columnsvarchar(2048) DEFAULT NULL COMMENT '表字段',extend_infovarchar(2048) NULL COMMENT '自定义扩展字段json',PRIMARY KEY (
id)) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='table cache'
2024-12-25 08:22:44.021 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected
2024-12-25 08:22:44.021 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: create INDEX idx_table_cache_data_source_id on table_cache(
data_source_id)2024-12-25 08:22:44.022 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected
2024-12-25 08:22:44.022 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: create INDEX idx_table_cache_key_version on table_cache(
key,version)2024-12-25 08:22:44.022 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected
2024-12-25 08:22:44.023 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: create INDEX idx_table_cache_key_table_name on table_cache(
key,table_name)2024-12-25 08:22:44.023 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected
2024-12-25 08:22:44.023 DEBUG 1 --- [ task-1] o.f.core.internal.command.DbMigrate .32 : | Successfully completed migration of schema "PUBLIC" to version "2.1.1 - TableCache"
2024-12-25 08:22:44.025 DEBUG 1 --- [ task-1] o.f.c.i.s.JdbcTableSchemaHistory .32 : | Schema History table "PUBLIC"."flyway_schema_history" successfully updated to reflect changes
2024-12-25 08:22:44.026 DEBUG 1 --- [ task-1] o.flywaydb.core.internal.parser.Parser .32 : | Parsing V2_1_2__OPERATION.sql ...
2024-12-25 08:22:44.027 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 1: ALTER TABLE
operation_logADD COLUMN
statusvarchar(20) DEFAULT 'success' COMMENT '状态'2024-12-25 08:22:44.028 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 3: ALTER TABLE
operation_logADD COLUMN
operation_rowsbigint(20) unsigned COMMENT '操作行数'2024-12-25 08:22:44.028 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 5: ALTER TABLE
operation_logADD COLUMN
use_timebigint(20) unsigned COMMENT '使用时长'2024-12-25 08:22:44.028 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 7: ALTER TABLE
operation_logADD COLUMN
extend_infovarchar(1024) COMMENT '扩展信息'2024-12-25 08:22:44.028 DEBUG 1 --- [ task-1] o.f.core.internal.command.DbMigrate .32 : | Starting migration of schema "PUBLIC" to version "2.1.2 - OPERATION" ...
2024-12-25 08:22:44.029 INFO 1 --- [ task-1] o.f.core.internal.command.DbMigrate .35 : | Migrating schema "PUBLIC" to version "2.1.2 - OPERATION"
2024-12-25 08:22:44.030 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: ALTER TABLE
operation_logADD COLUMN
statusvarchar(20) DEFAULT 'success' COMMENT '状态'2024-12-25 08:22:44.032 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected
2024-12-25 08:22:44.033 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: ALTER TABLE
operation_logADD COLUMN
operation_rowsbigint(20) unsigned COMMENT '操作行数'2024-12-25 08:22:44.035 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected
2024-12-25 08:22:44.035 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: ALTER TABLE
operation_logADD COLUMN
use_timebigint(20) unsigned COMMENT '使用时长'2024-12-25 08:22:44.038 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected
2024-12-25 08:22:44.038 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: ALTER TABLE
operation_logADD COLUMN
extend_infovarchar(1024) COMMENT '扩展信息'2024-12-25 08:22:44.041 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected
2024-12-25 08:22:44.042 DEBUG 1 --- [ task-1] o.f.core.internal.command.DbMigrate .32 : | Successfully completed migration of schema "PUBLIC" to version "2.1.2 - OPERATION"
2024-12-25 08:22:44.043 DEBUG 1 --- [ task-1] o.f.c.i.s.JdbcTableSchemaHistory .32 : | Schema History table "PUBLIC"."flyway_schema_history" successfully updated to reflect changes
2024-12-25 08:22:44.045 DEBUG 1 --- [ task-1] o.flywaydb.core.internal.parser.Parser .32 : | Parsing V2_1_4__OPERATION.sql ...
2024-12-25 08:22:44.046 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 1: ALTER TABLE
operation_logADD COLUMN
schema_namevarchar(256) COMMENT 'schema名称'2024-12-25 08:22:44.046 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 3: create INDEX idx_op_data_source_id on operation_log(data_source_id)
2024-12-25 08:22:44.046 DEBUG 1 --- [ task-1] o.f.core.internal.command.DbMigrate .32 : | Starting migration of schema "PUBLIC" to version "2.1.4 - OPERATION" ...
2024-12-25 08:22:44.047 INFO 1 --- [ task-1] o.f.core.internal.command.DbMigrate .35 : | Migrating schema "PUBLIC" to version "2.1.4 - OPERATION"
2024-12-25 08:22:44.047 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: ALTER TABLE
operation_logADD COLUMN
schema_namevarchar(256) COMMENT 'schema名称'2024-12-25 08:22:44.050 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected
2024-12-25 08:22:44.050 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: create INDEX idx_op_data_source_id on operation_log(data_source_id)
2024-12-25 08:22:44.050 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected
2024-12-25 08:22:44.050 DEBUG 1 --- [ task-1] o.f.core.internal.command.DbMigrate .32 : | Successfully completed migration of schema "PUBLIC" to version "2.1.4 - OPERATION"
2024-12-25 08:22:44.052 DEBUG 1 --- [ task-1] o.f.c.i.s.JdbcTableSchemaHistory .32 : | Schema History table "PUBLIC"."flyway_schema_history" successfully updated to reflect changes
2024-12-25 08:22:44.054 DEBUG 1 --- [ task-1] o.flywaydb.core.internal.parser.Parser .32 : | Parsing V2_1_5__TableVector.sql ...
2024-12-25 08:22:44.055 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 1: CREATE TABLE IF NOT EXISTS
table_vector_mapping(idbigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',api_keyvarchar(128) DEFAULT NULL COMMENT 'api key',data_source_idbigint(20) unsigned DEFAULT NULL COMMENT '数据源连接ID',databasetext DEFAULT NULL COMMENT '数据库名称',schematext DEFAULT NULL COMMENT 'schema名称',statusvarchar(4) DEFAULT NULL COMMENT '向量保存状态',PRIMARY KEY (
id)) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='milvus映射表保存记录'
2024-12-25 08:22:44.056 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 12: create INDEX idx_api_key on table_vector_mapping(api_key)
2024-12-25 08:22:44.056 DEBUG 1 --- [ task-1] o.f.core.internal.command.DbMigrate .32 : | Starting migration of schema "PUBLIC" to version "2.1.5 - TableVector" ...
2024-12-25 08:22:44.056 INFO 1 --- [ task-1] o.f.core.internal.command.DbMigrate .35 : | Migrating schema "PUBLIC" to version "2.1.5 - TableVector"
2024-12-25 08:22:44.056 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: CREATE TABLE IF NOT EXISTS
table_vector_mapping(idbigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',api_keyvarchar(128) DEFAULT NULL COMMENT 'api key',data_source_idbigint(20) unsigned DEFAULT NULL COMMENT '数据源连接ID',databasetext DEFAULT NULL COMMENT '数据库名称',schematext DEFAULT NULL COMMENT 'schema名称',statusvarchar(4) DEFAULT NULL COMMENT '向量保存状态',PRIMARY KEY (
id)) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='milvus映射表保存记录'
2024-12-25 08:22:44.057 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected
2024-12-25 08:22:44.057 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: create INDEX idx_api_key on table_vector_mapping(api_key)
2024-12-25 08:22:44.058 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected
2024-12-25 08:22:44.058 DEBUG 1 --- [ task-1] o.f.core.internal.command.DbMigrate .32 : | Successfully completed migration of schema "PUBLIC" to version "2.1.5 - TableVector"
2024-12-25 08:22:44.059 DEBUG 1 --- [ task-1] o.f.c.i.s.JdbcTableSchemaHistory .32 : | Schema History table "PUBLIC"."flyway_schema_history" successfully updated to reflect changes
2024-12-25 08:22:44.061 DEBUG 1 --- [ task-1] o.flywaydb.core.internal.parser.Parser .32 : | Parsing V2_1_6__TableVectorUpdate.sql ...
2024-12-25 08:22:44.062 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 1: ALTER TABLE table_vector_mapping ALTER COLUMN status VARCHAR(64)
2024-12-25 08:22:44.062 DEBUG 1 --- [ task-1] o.f.core.internal.command.DbMigrate .32 : | Starting migration of schema "PUBLIC" to version "2.1.6 - TableVectorUpdate" ...
2024-12-25 08:22:44.062 INFO 1 --- [ task-1] o.f.core.internal.command.DbMigrate .35 : | Migrating schema "PUBLIC" to version "2.1.6 - TableVectorUpdate"
2024-12-25 08:22:44.063 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: ALTER TABLE table_vector_mapping ALTER COLUMN status VARCHAR(64)
2024-12-25 08:22:44.066 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected
2024-12-25 08:22:44.066 DEBUG 1 --- [ task-1] o.f.core.internal.command.DbMigrate .32 : | Successfully completed migration of schema "PUBLIC" to version "2.1.6 - TableVectorUpdate"
2024-12-25 08:22:44.067 DEBUG 1 --- [ task-1] o.f.c.i.s.JdbcTableSchemaHistory .32 : | Schema History table "PUBLIC"."flyway_schema_history" successfully updated to reflect changes
2024-12-25 08:22:44.068 DEBUG 1 --- [ task-1] o.flywaydb.core.internal.parser.Parser .32 : | Parsing V2_1_7__DATASOURCE.sql ...
2024-12-25 08:22:44.069 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 1: ALTER TABLE
data_sourceADD COLUMNservice_namevarchar(128) NULL COMMENT '服务名'2024-12-25 08:22:44.070 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 2: ALTER TABLE
data_sourceADD COLUMNservice_typevarchar(128) NULL COMMENT '服务类型'2024-12-25 08:22:44.070 DEBUG 1 --- [ task-1] o.f.core.internal.command.DbMigrate .32 : | Starting migration of schema "PUBLIC" to version "2.1.7 - DATASOURCE" ...
2024-12-25 08:22:44.070 INFO 1 --- [ task-1] o.f.core.internal.command.DbMigrate .35 : | Migrating schema "PUBLIC" to version "2.1.7 - DATASOURCE"
2024-12-25 08:22:44.070 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: ALTER TABLE
data_sourceADD COLUMNservice_namevarchar(128) NULL COMMENT '服务名'2024-12-25 08:22:44.074 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected
2024-12-25 08:22:44.074 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: ALTER TABLE
data_sourceADD COLUMNservice_typevarchar(128) NULL COMMENT '服务类型'2024-12-25 08:22:44.077 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected
2024-12-25 08:22:44.077 DEBUG 1 --- [ task-1] o.f.core.internal.command.DbMigrate .32 : | Successfully completed migration of schema "PUBLIC" to version "2.1.7 - DATASOURCE"
2024-12-25 08:22:44.078 DEBUG 1 --- [ task-1] o.f.c.i.s.JdbcTableSchemaHistory .32 : | Schema History table "PUBLIC"."flyway_schema_history" successfully updated to reflect changes
2024-12-25 08:22:44.080 DEBUG 1 --- [ task-1] o.flywaydb.core.internal.parser.Parser .32 : | Parsing V2_1_8__Chart.sql ...
2024-12-25 08:22:44.080 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 1: ALTER TABLE
chartADD COLUMNschema_namevarchar(128) NULL COMMENT 'schemaName'2024-12-25 08:22:44.081 DEBUG 1 --- [ task-1] o.f.core.internal.command.DbMigrate .32 : | Starting migration of schema "PUBLIC" to version "2.1.8 - Chart" ...
2024-12-25 08:22:44.081 INFO 1 --- [ task-1] o.f.core.internal.command.DbMigrate .35 : | Migrating schema "PUBLIC" to version "2.1.8 - Chart"
2024-12-25 08:22:44.081 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: ALTER TABLE
chartADD COLUMNschema_namevarchar(128) NULL COMMENT 'schemaName'2024-12-25 08:22:44.084 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected
2024-12-25 08:22:44.084 DEBUG 1 --- [ task-1] o.f.core.internal.command.DbMigrate .32 : | Successfully completed migration of schema "PUBLIC" to version "2.1.8 - Chart"
2024-12-25 08:22:44.085 DEBUG 1 --- [ task-1] o.f.c.i.s.JdbcTableSchemaHistory .32 : | Schema History table "PUBLIC"."flyway_schema_history" successfully updated to reflect changes
2024-12-25 08:22:44.087 DEBUG 1 --- [ task-1] o.flywaydb.core.internal.parser.Parser .32 : | Parsing V2_1_9__task.sql ...
2024-12-25 08:22:44.088 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 1: CREATE TABLE IF NOT EXISTS
task(idbigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',gmt_createdatetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',gmt_modifieddatetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',data_source_idbigint(20) unsigned NULL COMMENT '数据源连接ID',database_namevarchar(128) DEFAULT NULL COMMENT 'db名称',schema_namevarchar(128) DEFAULT NULL COMMENT 'schema名称',table_namevarchar(128) DEFAULT NULL COMMENT 'table_name',deletedvarchar(10) DEFAULT NULL COMMENT '是否被删除,y表示删除,n表示未删除',user_idbigint(20) unsigned NOT NULL DEFAULT 0 COMMENT '用户id',task_typevarchar(128) DEFAULT NULL COMMENT 'task type, such as: DOWNLOAD_DATA, UPLOAD_TABLE_DATA, DOWNLOAD_TABLE_STRUCTURE, UPLOAD_TABLE_STRUCTURE,',task_statusvarchar(128) DEFAULT NULL COMMENT 'task status',task_progressvarchar(128) DEFAULT NULL COMMENT 'task progress',task_namevarchar(128) DEFAULT NULL COMMENT 'task name',contentblob DEFAULT NULL COMMENT 'task content',download_urlvarchar(512) DEFAULT NULL COMMENT 'down load url',PRIMARY KEY (
id)) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='TASK TABLE'
2024-12-25 08:22:44.089 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 20: create INDEX idx_task_user_id on task(user_id)
2024-12-25 08:22:44.089 DEBUG 1 --- [ task-1] o.f.core.internal.command.DbMigrate .32 : | Starting migration of schema "PUBLIC" to version "2.1.9 - task" ...
2024-12-25 08:22:44.089 INFO 1 --- [ task-1] o.f.core.internal.command.DbMigrate .35 : | Migrating schema "PUBLIC" to version "2.1.9 - task"
2024-12-25 08:22:44.089 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: CREATE TABLE IF NOT EXISTS
task(idbigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',gmt_createdatetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',gmt_modifieddatetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',data_source_idbigint(20) unsigned NULL COMMENT '数据源连接ID',database_namevarchar(128) DEFAULT NULL COMMENT 'db名称',schema_namevarchar(128) DEFAULT NULL COMMENT 'schema名称',table_namevarchar(128) DEFAULT NULL COMMENT 'table_name',deletedvarchar(10) DEFAULT NULL COMMENT '是否被删除,y表示删除,n表示未删除',user_idbigint(20) unsigned NOT NULL DEFAULT 0 COMMENT '用户id',task_typevarchar(128) DEFAULT NULL COMMENT 'task type, such as: DOWNLOAD_DATA, UPLOAD_TABLE_DATA, DOWNLOAD_TABLE_STRUCTURE, UPLOAD_TABLE_STRUCTURE,',task_statusvarchar(128) DEFAULT NULL COMMENT 'task status',task_progressvarchar(128) DEFAULT NULL COMMENT 'task progress',task_namevarchar(128) DEFAULT NULL COMMENT 'task name',contentblob DEFAULT NULL COMMENT 'task content',download_urlvarchar(512) DEFAULT NULL COMMENT 'down load url',PRIMARY KEY (
id)) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='TASK TABLE'
2024-12-25 08:22:44.091 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected
2024-12-25 08:22:44.091 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: create INDEX idx_task_user_id on task(user_id)
2024-12-25 08:22:44.091 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 0 rows affected
2024-12-25 08:22:44.091 DEBUG 1 --- [ task-1] o.f.core.internal.command.DbMigrate .32 : | Successfully completed migration of schema "PUBLIC" to version "2.1.9 - task"
2024-12-25 08:22:44.092 DEBUG 1 --- [ task-1] o.f.c.i.s.JdbcTableSchemaHistory .32 : | Schema History table "PUBLIC"."flyway_schema_history" successfully updated to reflect changes
2024-12-25 08:22:44.094 DEBUG 1 --- [ task-1] o.flywaydb.core.internal.parser.Parser .32 : | Parsing V2_1_10__REMOVEdEMO.sql ...
2024-12-25 08:22:44.094 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 1: delete from DATA_SOURCE where ALIAS ='[email protected]'
2024-12-25 08:22:44.094 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 3: delete from DASHBOARD where id =ID
2024-12-25 08:22:44.094 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 5: delete from CHART where id<=3
2024-12-25 08:22:44.095 DEBUG 1 --- [ task-1] o.f.c.i.sqlscript.ParserSqlScript .32 : | Found statement at line 7: delete from DASHBOARD_CHART_RELATION where CHART_ID<=3
2024-12-25 08:22:44.095 DEBUG 1 --- [ task-1] o.f.core.internal.command.DbMigrate .32 : | Starting migration of schema "PUBLIC" to version "2.1.10 - REMOVEdEMO" ...
2024-12-25 08:22:44.095 INFO 1 --- [ task-1] o.f.core.internal.command.DbMigrate .35 : | Migrating schema "PUBLIC" to version "2.1.10 - REMOVEdEMO"
2024-12-25 08:22:44.095 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: delete from DATA_SOURCE where ALIAS ='[email protected]'
2024-12-25 08:22:44.096 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 1 row affected
2024-12-25 08:22:44.096 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: delete from DASHBOARD where id =ID
2024-12-25 08:22:44.096 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 1 row affected
2024-12-25 08:22:44.097 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: delete from CHART where id<=3
2024-12-25 08:22:44.097 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 3 rows affected
2024-12-25 08:22:44.097 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | Executing SQL: delete from DASHBOARD_CHART_RELATION where CHART_ID<=3
2024-12-25 08:22:44.097 DEBUG 1 --- [ task-1] o.f.c.i.s.DefaultSqlScriptExecutor .32 : | 3 rows affected
2024-12-25 08:22:44.097 DEBUG 1 --- [ task-1] o.f.core.internal.command.DbMigrate .32 : | Successfully completed migration of schema "PUBLIC" to version "2.1.10 - REMOVEdEMO"
2024-12-25 08:22:44.098 DEBUG 1 --- [ task-1] o.f.c.i.s.JdbcTableSchemaHistory .32 : | Schema History table "PUBLIC"."flyway_schema_history" successfully updated to reflect changes
2024-12-25 08:22:44.099 INFO 1 --- [ task-1] o.f.core.internal.command.DbMigrate .35 : | Successfully applied 18 migrations to schema "PUBLIC", now at version v2.1.10 (execution time 00:00.441s)
2024-12-25 08:22:44.105 DEBUG 1 --- [ task-1] org.flywaydb.core.FlywayExecutor .32 : | Memory usage: 49 of 226M
2024-12-25 08:22:44.105 INFO 1 --- [ task-1] a.c.s.tools.common.util.ConfigUtils .104 : | set config:{"jwtSecretKey":"32de412ac8214f99a01d4eb073b6a117","systemUuid":"8fec1b71f5b04ba5ac7ce381a8a7a8f1"}
The text was updated successfully, but these errors were encountered: