Skip to content
New issue

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

Some errors occured when init DB(初始化数据库时有些错误) #658

Closed
TrumanH opened this issue Sep 2, 2021 · 2 comments
Closed

Comments

@TrumanH
Copy link
Contributor

TrumanH commented Sep 2, 2021

1. 您使用的是哪个版本的Go和系统类型/架构 ?

go version go1.16.4 windows/amd64

2. 您使用的是哪个版本的 Nodejsnpmcnpm ?

仅用server 后端

3. 您使用的是哪个版本的 gin-vue-admin ?

master

4. 可以在master版本中复现此问题吗 ?

可以

5. 您做了什么 ?

从swagger 上初始化数据库
image
虽然执行成功返回200,但后台运行日志中的2处报错令人疑惑,其中

  • D:/projects/gin-vue-admin/server/source/authority_menu.go:16 Error 1146: Table 'gva-main.authority_menu' doesn't exist
    看起来与关于数据库导入视图 DEFINER 错误 #410 同样都是没有注册创建对应表导致。
  • server/source/user_authority.go.go:24 Error 1054: Unknown column 'sys_base_menu_id' in 'field list'
    看起来像是使用了不存在的(旧的)字段。

6. 您期望看到什么 ?

没有那两个报错

7. 您看到了什么 ?

一起正常,数据库都创建成功了,除了有2个令人疑惑的报错:
image
image

8. 错误堆栈或者SQL打印

[github.com/flipped-aurora/gin-vue-admin/server]2021/09/02 - 13:58:18.175       info    D:/projects/gin-vue-admin/server/api/v1/system/sys_initdb.go:52  前往初始化数据库
[GIN] 2021/09/02 - 13:58:18 | 200 |       534.1µs |             ::1 | POST     "/init/checkdb"

2021/09/02 13:58:51 D:/projects/gin-vue-admin/server/service/system/sys_initdb.go:124 SLOW SQL >= 200ms
[324.893ms] [rows:-] SELECT DATABASE()

2021/09/02 13:58:51 D:/projects/gin-vue-admin/server/service/system/sys_initdb.go:124 SLOW SQL >= 200ms
[318.372ms] [rows:-] SELECT count(*) FROM information_schema.tables WHERE table_schema = "gva-main" AND table_name = "sys_authorities" AND table_type = "BASE TABLE"

2021/09/02 13:58:52 D:/projects/gin-vue-admin/server/service/system/sys_initdb.go:124 SLOW SQL >= 200ms
[396.896ms] [rows:0] CREATE TABLE `sys_authorities` (`created_at` datetime NULL,`updated_at` datetime NULL,`deleted_at` datetime NULL,`authority_id` varchar(90) NOT NULL UNIQUE COMMENT "角色ID",`authority_name` varchar(191) COMMENT "角色名",`parent_id` varchar(191) COMMENT "父角色ID",`default_router` varchar(191) DEFAULT "dashboard" COMMENT "默认菜单",PRIMARY KEY (`authority_id`))

2021/09/02 13:58:52 D:/projects/gin-vue-admin/server/service/system/sys_initdb.go:124 SLOW SQL >= 200ms
[317.654ms] [rows:-] SELECT DATABASE()

2021/09/02 13:58:52 D:/projects/gin-vue-admin/server/service/system/sys_initdb.go:124 SLOW SQL >= 200ms
[317.645ms] [rows:-] SELECT count(*) FROM information_schema.tables WHERE table_schema = "gva-main" AND table_name = "sys_users" AND table_type = "BASE TABLE"

2021/09/02 13:58:53 D:/projects/gin-vue-admin/server/service/system/sys_initdb.go:124 SLOW SQL >= 200ms
[386.919ms] [rows:0] CREATE TABLE `sys_users` (`id` bigint unsigned AUTO_INCREMENT,`created_at` datetime NULL,`updated_at` datetime NULL,`deleted_at` datetime NULL,`uuid` varchar(191) COMMENT "用户UUID",`username` varchar(191) COMMENT "用户登录名",`password` varchar(191) COMMENT "用 户登录密码",`nick_name` varchar(191) DEFAULT "系统用户" COMMENT "用户昵称",`header_img` varchar(191) DEFAULT "http://qmplusimg.henrongyi.top/head.png" COMMENT "用户头像",`authority_id` varchar(90) DEFAULT "888" COMMENT "用户角色ID",`side_mode` varchar(191) DEFAULT "dark" COMMENT "用 户角色ID",`active_color` varchar(191) DEFAULT "#1890ff" COMMENT "用户角色ID",`base_color` varchar(191) DEFAULT "#fff" COMMENT "用户角色ID",PRIMARY KEY (`id`),INDEX idx_sys_users_deleted_at (`deleted_at`))

2021/09/02 13:58:53 D:/projects/gin-vue-admin/server/service/system/sys_initdb.go:124 SLOW SQL >= 200ms
[320.065ms] [rows:-] SELECT DATABASE()

2021/09/02 13:58:53 D:/projects/gin-vue-admin/server/service/system/sys_initdb.go:124 SLOW SQL >= 200ms
[316.452ms] [rows:-] SELECT count(*) FROM information_schema.tables WHERE table_schema = "gva-main" AND table_name = "sys_user_authority" AND table_type = "BASE TABLE"

2021/09/02 13:58:54 D:/projects/gin-vue-admin/server/service/system/sys_initdb.go:124 SLOW SQL >= 200ms
[365.198ms] [rows:0] CREATE TABLE `sys_user_authority` (`sys_user_id` bigint unsigned,`sys_authority_authority_id` varchar(90) NOT NULL COMMENT "角色ID",PRIMARY KEY (`sys_user_id`,`sys_authority_authority_id`))

2021/09/02 13:58:54 D:/projects/gin-vue-admin/server/service/system/sys_initdb.go:124 SLOW SQL >= 200ms
[321.385ms] [rows:-] SELECT DATABASE()

2021/09/02 13:58:54 D:/projects/gin-vue-admin/server/service/system/sys_initdb.go:124 SLOW SQL >= 200ms
[316.332ms] [rows:-] SELECT count(*) FROM information_schema.tables WHERE table_schema = "gva-main" AND table_name = "sys_base_menus" AND table_type = "BASE TABLE"

2021/09/02 13:58:55 D:/projects/gin-vue-admin/server/service/system/sys_initdb.go:124 SLOW SQL >= 200ms
[379.683ms] [rows:0] CREATE TABLE `sys_base_menus` (`id` bigint unsigned AUTO_INCREMENT,`created_at` datetime NULL,`updated_at` datetime NULL,`deleted_at` datetime NULL,`menu_level` bigint unsigned,`parent_id` varchar(191) COMMENT "父菜单ID",`path` varchar(191) COMMENT "路由path",`name` varchar(191) COMMENT "路由name",`hidden` boolean COMMENT "是否在列表隐藏",`component` varchar(191) COMMENT "对应前端文件路径",`sort` bigint COMMENT "排序标记",`keep_alive` boolean COMMENT "附加属性",`default_menu` boolean COMMENT "附加属性",`title` varchar(191) COMMENT "附加属性",`icon` varchar(191) COMMENT "附加属性",`close_tab` boolean COMMENT "附加属性",PRIMARY KEY (`id`),INDEX idx_sys_base_menus_deleted_at (`deleted_at`))

2021/09/02 13:58:55 D:/projects/gin-vue-admin/server/service/system/sys_initdb.go:124 SLOW SQL >= 200ms
[323.437ms] [rows:-] SELECT DATABASE()

2021/09/02 13:58:55 D:/projects/gin-vue-admin/server/service/system/sys_initdb.go:124 SLOW SQL >= 200ms
[318.146ms] [rows:-] SELECT count(*) FROM information_schema.tables WHERE table_schema = "gva-main" AND table_name = "sys_authority_menus" AND table_type = "BASE TABLE"

2021/09/02 13:58:56 D:/projects/gin-vue-admin/server/service/system/sys_initdb.go:124 SLOW SQL >= 200ms
[362.288ms] [rows:0] CREATE TABLE `sys_authority_menus` (`sys_base_menu_id` bigint unsigned,`sys_authority_authority_id` varchar(90) NOT NULL COMMENT "角色ID",PRIMARY KEY (`sys_base_menu_id`,`sys_authority_authority_id`))

2021/09/02 13:58:56 D:/projects/gin-vue-admin/server/service/system/sys_initdb.go:124 SLOW SQL >= 200ms
[312.848ms] [rows:-] SELECT DATABASE()

2021/09/02 13:58:56 D:/projects/gin-vue-admin/server/service/system/sys_initdb.go:124 SLOW SQL >= 200ms
[314.466ms] [rows:-] SELECT count(*) FROM information_schema.tables WHERE table_schema = "gva-main" AND table_name = "sys_data_authority_id" AND table_type = "BASE TABLE"

2021/09/02 13:58:57 D:/projects/gin-vue-admin/server/service/system/sys_initdb.go:124 SLOW SQL >= 200ms
[360.021ms] [rows:0] CREATE TABLE `sys_data_authority_id` (`sys_authority_authority_id` varchar(90) NOT NULL COMMENT "角色ID",`data_authority_id_authority_id` varchar(90) NOT NULL COMMENT "角色ID",PRIMARY KEY (`sys_authority_authority_id`,`data_authority_id_authority_id`))

2021/09/02 13:58:57 D:/projects/gin-vue-admin/server/service/system/sys_initdb.go:124 SLOW SQL >= 200ms
[310.029ms] [rows:-] SELECT DATABASE()

2021/09/02 13:58:57 D:/projects/gin-vue-admin/server/service/system/sys_initdb.go:124 SLOW SQL >= 200ms
[314.636ms] [rows:-] SELECT count(*) FROM information_schema.tables WHERE table_schema = "gva-main" AND table_name = "sys_apis" AND table_type = "BASE TABLE"

2021/09/02 13:58:58 D:/projects/gin-vue-admin/server/service/system/sys_initdb.go:124 SLOW SQL >= 200ms
[382.129ms] [rows:0] CREATE TABLE `sys_apis` (`id` bigint unsigned AUTO_INCREMENT,`created_at` datetime NULL,`updated_at` datetime NULL,`deleted_at` datetime NULL,`path` varchar(191) COMMENT "api路径",`description` varchar(191) COMMENT "api中文描述",`api_group` varchar(191) COMMENT "api组",`method` varchar(191) DEFAULT "POST" COMMENT "方法",PRIMARY KEY (`id`),INDEX idx_sys_apis_deleted_at (`deleted_at`))

2021/09/02 13:58:58 D:/projects/gin-vue-admin/server/service/system/sys_initdb.go:124 SLOW SQL >= 200ms
[314.014ms] [rows:-] SELECT DATABASE()

2021/09/02 13:58:58 D:/projects/gin-vue-admin/server/service/system/sys_initdb.go:124 SLOW SQL >= 200ms
[314.787ms] [rows:-] SELECT count(*) FROM information_schema.tables WHERE table_schema = "gva-main" AND table_name = "sys_base_menu_parameters" AND table_type = "BASE TABLE"

2021/09/02 13:58:59 D:/projects/gin-vue-admin/server/service/system/sys_initdb.go:124 SLOW SQL >= 200ms
[370.236ms] [rows:0] CREATE TABLE `sys_base_menu_parameters` (`id` bigint unsigned AUTO_INCREMENT,`created_at` datetime NULL,`updated_at` datetime NULL,`deleted_at` datetime NULL,`sys_base_menu_id` bigint unsigned,`type` varchar(191) COMMENT "地址栏携带参数为params还是query",`key` varchar(191) COMMENT "地址栏携带参数的key",`value` varchar(191) COMMENT "地址栏携带参数的值",PRIMARY KEY (`id`),INDEX idx_sys_base_menu_parameters_deleted_at (`deleted_at`))

2021/09/02 13:58:59 D:/projects/gin-vue-admin/server/service/system/sys_initdb.go:124 SLOW SQL >= 200ms
[313.668ms] [rows:-] SELECT DATABASE()

2021/09/02 13:58:59 D:/projects/gin-vue-admin/server/service/system/sys_initdb.go:124 SLOW SQL >= 200ms
[314.764ms] [rows:-] SELECT count(*) FROM information_schema.tables WHERE table_schema = "gva-main" AND table_name = "jwt_blacklists" AND table_type = "BASE TABLE"

2021/09/02 13:59:00 D:/projects/gin-vue-admin/server/service/system/sys_initdb.go:124 SLOW SQL >= 200ms
[369.809ms] [rows:0] CREATE TABLE `jwt_blacklists` (`id` bigint unsigned AUTO_INCREMENT,`created_at` datetime NULL,`updated_at` datetime NULL,`deleted_at` datetime NULL,`jwt` text COMMENT "jwt",PRIMARY KEY (`id`),INDEX idx_jwt_blacklists_deleted_at (`deleted_at`))

2021/09/02 13:59:00 D:/projects/gin-vue-admin/server/service/system/sys_initdb.go:124 SLOW SQL >= 200ms
[319.459ms] [rows:-] SELECT DATABASE()

2021/09/02 13:59:00 D:/projects/gin-vue-admin/server/service/system/sys_initdb.go:124 SLOW SQL >= 200ms
[317.389ms] [rows:-] SELECT count(*) FROM information_schema.tables WHERE table_schema = "gva-main" AND table_name = "sys_dictionaries" AND table_type = "BASE TABLE"

2021/09/02 13:59:01 D:/projects/gin-vue-admin/server/service/system/sys_initdb.go:124 SLOW SQL >= 200ms
[384.449ms] [rows:0] CREATE TABLE `sys_dictionaries` (`id` bigint unsigned AUTO_INCREMENT,`created_at` datetime NULL,`updated_at` datetime NULL,`deleted_at` datetime NULL,`name` varchar(191) COMMENT "字典名(中)",`type` varchar(191) COMMENT "字典名(英)",`status` boolean COMMENT " 状态",`desc` varchar(191) COMMENT "描述",PRIMARY KEY (`id`),INDEX idx_sys_dictionaries_deleted_at (`deleted_at`))

2021/09/02 13:59:01 D:/projects/gin-vue-admin/server/service/system/sys_initdb.go:124 SLOW SQL >= 200ms
[315.970ms] [rows:-] SELECT DATABASE()

2021/09/02 13:59:01 D:/projects/gin-vue-admin/server/service/system/sys_initdb.go:124 SLOW SQL >= 200ms
[316.365ms] [rows:-] SELECT count(*) FROM information_schema.tables WHERE table_schema = "gva-main" AND table_name = "sys_dictionary_details" AND table_type = "BASE TABLE"

2021/09/02 13:59:02 D:/projects/gin-vue-admin/server/service/system/sys_initdb.go:124 SLOW SQL >= 200ms
[391.933ms] [rows:0] CREATE TABLE `sys_dictionary_details` (`id` bigint unsigned AUTO_INCREMENT,`created_at` datetime NULL,`updated_at` datetime NULL,`deleted_at` datetime NULL,`label` varchar(191) COMMENT "展示值",`value` bigint COMMENT "字典值",`status` boolean COMMENT "启用状态",`sort` bigint COMMENT "排序标记",`sys_dictionary_id` bigint unsigned COMMENT "关联标记",PRIMARY KEY (`id`),INDEX idx_sys_dictionary_details_deleted_at (`deleted_at`))

2021/09/02 13:59:02 D:/projects/gin-vue-admin/server/service/system/sys_initdb.go:124 SLOW SQL >= 200ms
[311.081ms] [rows:-] SELECT DATABASE()

2021/09/02 13:59:02 D:/projects/gin-vue-admin/server/service/system/sys_initdb.go:124 SLOW SQL >= 200ms
[317.947ms] [rows:-] SELECT count(*) FROM information_schema.tables WHERE table_schema = "gva-main" AND table_name = "exa_file_upload_and_downloads" AND table_type = "BASE TABLE"

2021/09/02 13:59:03 D:/projects/gin-vue-admin/server/service/system/sys_initdb.go:124 SLOW SQL >= 200ms
[381.864ms] [rows:0] CREATE TABLE `exa_file_upload_and_downloads` (`id` bigint unsigned AUTO_INCREMENT,`created_at` datetime NULL,`updated_at` datetime NULL,`deleted_at` datetime NULL,`name` varchar(191) COMMENT "文件名",`url` varchar(191) COMMENT "文件地址",`tag` varchar(191) COMMENT "文件标签",`key` varchar(191) COMMENT "编号",PRIMARY KEY (`id`),INDEX idx_exa_file_upload_and_downloads_deleted_at (`deleted_at`))

2021/09/02 13:59:03 D:/projects/gin-vue-admin/server/service/system/sys_initdb.go:124 SLOW SQL >= 200ms
[309.930ms] [rows:-] SELECT DATABASE()

2021/09/02 13:59:03 D:/projects/gin-vue-admin/server/service/system/sys_initdb.go:124 SLOW SQL >= 200ms
[316.976ms] [rows:-] SELECT count(*) FROM information_schema.tables WHERE table_schema = "gva-main" AND table_name = "exa_files" AND table_type = "BASE TABLE"

2021/09/02 13:59:04 D:/projects/gin-vue-admin/server/service/system/sys_initdb.go:124 SLOW SQL >= 200ms
[381.960ms] [rows:0] CREATE TABLE `exa_files` (`id` bigint unsigned AUTO_INCREMENT,`created_at` datetime NULL,`updated_at` datetime NULL,`deleted_at` datetime NULL,`file_name` varchar(191),`file_md5` varchar(191),`file_path` varchar(191),`chunk_total` bigint,`is_finish` boolean,PRIMARY KEY (`id`),INDEX idx_exa_files_deleted_at (`deleted_at`))

2021/09/02 13:59:04 D:/projects/gin-vue-admin/server/service/system/sys_initdb.go:124 SLOW SQL >= 200ms
[319.729ms] [rows:-] SELECT DATABASE()

2021/09/02 13:59:04 D:/projects/gin-vue-admin/server/service/system/sys_initdb.go:124 SLOW SQL >= 200ms
[316.274ms] [rows:-] SELECT count(*) FROM information_schema.tables WHERE table_schema = "gva-main" AND table_name = "exa_file_chunks" AND table_type = "BASE TABLE"

2021/09/02 13:59:05 D:/projects/gin-vue-admin/server/service/system/sys_initdb.go:124 SLOW SQL >= 200ms
[383.978ms] [rows:0] CREATE TABLE `exa_file_chunks` (`id` bigint unsigned AUTO_INCREMENT,`created_at` datetime NULL,`updated_at` datetime NULL,`deleted_at` datetime NULL,`exa_file_id` bigint unsigned,`file_chunk_number` bigint,`file_chunk_path` varchar(191),PRIMARY KEY (`id`),INDEX idx_exa_file_chunks_deleted_at (`deleted_at`))

2021/09/02 13:59:05 D:/projects/gin-vue-admin/server/service/system/sys_initdb.go:124 SLOW SQL >= 200ms
[321.383ms] [rows:-] SELECT DATABASE()

2021/09/02 13:59:05 D:/projects/gin-vue-admin/server/service/system/sys_initdb.go:124 SLOW SQL >= 200ms
[315.140ms] [rows:-] SELECT count(*) FROM information_schema.tables WHERE table_schema = "gva-main" AND table_name = "exa_customers" AND table_type = "BASE TABLE"

2021/09/02 13:59:06 D:/projects/gin-vue-admin/server/service/system/sys_initdb.go:124 SLOW SQL >= 200ms
[382.118ms] [rows:0] CREATE TABLE `exa_customers` (`id` bigint unsigned AUTO_INCREMENT,`created_at` datetime NULL,`updated_at` datetime NULL,`deleted_at` datetime NULL,`customer_name` varchar(191) COMMENT "客户名",`customer_phone_data` varchar(191) COMMENT "客户手机号",`sys_user_id` bigint unsigned COMMENT "管理ID",`sys_user_authority_id` varchar(191) COMMENT "管理角色ID",PRIMARY KEY (`id`),INDEX idx_exa_customers_deleted_at (`deleted_at`))

2021/09/02 13:59:06 D:/projects/gin-vue-admin/server/service/system/sys_initdb.go:124 SLOW SQL >= 200ms
[320.857ms] [rows:-] SELECT DATABASE()

2021/09/02 13:59:06 D:/projects/gin-vue-admin/server/service/system/sys_initdb.go:124 SLOW SQL >= 200ms
[317.920ms] [rows:-] SELECT count(*) FROM information_schema.tables WHERE table_schema = "gva-main" AND table_name = "sys_operation_records" AND table_type = "BASE TABLE"

2021/09/02 13:59:07 D:/projects/gin-vue-admin/server/service/system/sys_initdb.go:124 SLOW SQL >= 200ms
[395.976ms] [rows:0] CREATE TABLE `sys_operation_records` (`id` bigint unsigned AUTO_INCREMENT,`created_at` datetime NULL,`updated_at` datetime NULL,`deleted_at` datetime NULL,`ip` varchar(191) COMMENT "请求ip",`method` varchar(191) COMMENT "请求方法",`path` varchar(191) COMMENT "请 求路径",`status` bigint COMMENT "请求状态",`latency` bigint COMMENT "延迟",`agent` varchar(191) COMMENT "代理",`error_message` varchar(191) COMMENT "错误信息",`body` longtext COMMENT "请求Body",`resp` longtext COMMENT "响应Body",`user_id` bigint unsigned COMMENT "用户id",PRIMARY KEY (`id`),INDEX idx_sys_operation_records_deleted_at (`deleted_at`))

2021/09/02 13:59:07 D:/projects/gin-vue-admin/server/service/system/sys_initdb.go:124 SLOW SQL >= 200ms
[323.553ms] [rows:-] SELECT DATABASE()

2021/09/02 13:59:08 D:/projects/gin-vue-admin/server/service/system/sys_initdb.go:124 SLOW SQL >= 200ms
[312.718ms] [rows:-] SELECT count(*) FROM information_schema.tables WHERE table_schema = "gva-main" AND table_name = "sys_auto_code_histories" AND table_type = "BASE TABLE"

2021/09/02 13:59:08 D:/projects/gin-vue-admin/server/service/system/sys_initdb.go:124 SLOW SQL >= 200ms
[380.994ms] [rows:0] CREATE TABLE `sys_auto_code_histories` (`id` bigint unsigned AUTO_INCREMENT,`created_at` datetime NULL,`updated_at` datetime NULL,`deleted_at` datetime NULL,`table_name` varchar(191),`request_meta` text,`auto_code_path` text,`injection_meta` text,`struct_name` varchar(191),`struct_cn_name` varchar(191),`api_ids` varchar(191),`flag` bigint,PRIMARY KEY (`id`),INDEX idx_sys_auto_code_histories_deleted_at (`deleted_at`))

[Mysql] --> sys_users 表初始数据成功!

[Mysql] --> sys_apis 表初始数据成功!

2021/09/02 13:59:09 D:/projects/gin-vue-admin/server/source/authority_menu.go:16 Error 1146: Table 'gva-main.authority_menu' doesn't exist
[320.310ms] [rows:0] SELECT * FROM `authority_menu` WHERE `authority_menu`.`deleted_at` IS NULL

2021/09/02 13:59:09 D:/projects/gin-vue-admin/server/source/authority_menu.go:20 SLOW SQL >= 200ms
[333.518ms] [rows:0] CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `authority_menu` AS select `sys_base_menus`.`id` AS `id`,`sys_base_menus`.`created_at` AS `created_at`, `sys_base_menus`.`updated_at` AS `updated_at`, `sys_base_menus`.`deleted_at` AS `deleted_at`, `sys_base_menus`.`menu_level` AS `menu_level`,`sys_base_menus`.`parent_id` AS `parent_id`,`sys_base_menus`.`path` AS `path`,`sys_base_menus`.`name` AS `name`,`sys_base_menus`.`hidden` AS `hidden`,`sys_base_menus`.`component` AS `component`, `sys_base_menus`.`title`  AS `title`,`sys_base_menus`.`icon` AS `icon`,`sys_base_menus`.`sort` AS `sort`,`sys_authority_menus`.`sys_authority_authority_id` AS `authority_id`,`sys_authority_menus`.`sys_base_menu_id` AS `menu_id`,`sys_base_menus`.`keep_alive` AS `keep_alive`,`sys_base_menus`.`close_tab` AS `close_tab`,`sys_base_menus`.`default_menu` AS `default_menu` from (`sys_authority_menus` join `sys_base_menus` on ((`sys_authority_menus`.`sys_base_menu_id` = `sys_base_menus`.`id`)))

[Mysql] --> authority_menu 视图创建成功!

[Mysql] --> sys_authorities 表初始数据成功!

[Mysql] --> sys_authority_menus 表初始数据成功!

2021/09/02 13:59:10 D:/projects/gin-vue-admin/server/source/casbin.go:177 SLOW SQL >= 200ms
[322.983ms] [rows:-] SELECT DATABASE()

2021/09/02 13:59:11 D:/projects/gin-vue-admin/server/source/casbin.go:177 SLOW SQL >= 200ms
[310.365ms] [rows:-] SELECT count(*) FROM information_schema.tables WHERE table_schema = "gva-main" AND table_name = "casbin_rule" AND table_type = "BASE TABLE"

2021/09/02 13:59:11 D:/projects/gin-vue-admin/server/source/casbin.go:177 SLOW SQL >= 200ms
[377.199ms] [rows:0] CREATE TABLE `casbin_rule` (`p_type` varchar(100),`v0` varchar(100),`v1` varchar(100),`v2` varchar(100),`v3` varchar(100),`v4` varchar(100),`v5` varchar(100))

[Mysql] --> casbin_rule 表初始数据成功!

[Mysql] --> sys_data_authority_id 表初始数据成功!

[Mysql] --> sys_dictionaries 表初始数据成功!

[Mysql] --> sys_dictionary_details 表初始数据成功!

[Mysql] --> exa_file_upload_and_downloads 表初始数据成功!

[Mysql] --> sys_base_menus 表初始数据成功!

2021/09/02 13:59:13 D:/projects/gin-vue-admin/server/source/user_authority.go.go:24 Error 1054: Unknown column 'sys_base_menu_id' in 'field list'
[4.067ms] [rows:0] SELECT `sys_authority_authority_id`,`sys_base_menu_id` FROM `sys_user_authority` WHERE sys_user_id IN (1, 2)

[Mysql] --> sys_user_authority 表初始数据成功!
config file changed: config.yaml
[GIN] 2021/09/02 - 13:59:13 | 200 |   23.4700754s |             ::1 | POST     "/init/initdb"
config file changed: config.yaml
@TrumanH
Copy link
Contributor Author

TrumanH commented Sep 2, 2021

@piexlmax PLS take a look when you have time, thanks!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants
@TrumanH and others