。。。我不知道是不是bug我不太会用go貌似是数据库初始化有问题？ - Githubissues

DokiDoki1103 / tikuAdapter

大学生网课题库接口适配器：将不同的题库整合为一个API接口。

MIT License

230 stars 22 forks source link

。。。我不知道是不是bug我不太会用go貌似是数据库初始化有问题？ #36

Closed guowang23333 closed 2 months ago

guowang23333 commented 2 months ago

E:\1w\tikuAdapter-main>tikuAdapter.exe [SYS] 2024/08/06 - 23:46:42 | 无法读取配置文件: Config File "config" Not Found in "[E:\1w\tikuAdapter-main]",将以默认配置启动

2024/08/06 23:46:42 [32m/home/runner/go/pkg/mod/github.com/glebarez/sqlite@v1.10.0/migrator.go:32 [0m[33m[0.005ms] [34;1m[rows:-][0m SELECT count(*) FROM sqlite_master WHERE type='table' AND name="tiku"

2024/08/06 23:46:42 [32m/home/runner/go/pkg/mod/github.com/glebarez/sqlite@v1.10.0/migrator.go:103 [0m[33m[0.511ms] [34;1m[rows:2][0m SELECT sql FROM sqlite_master WHERE type IN ("table","index") AND tbl_name = "tiku" AND sql IS NOT NULL order by type = "table" desc

2024/08/06 23:46:42 [32m/home/runner/go/pkg/mod/github.com/glebarez/sqlite@v1.10.0/migrator.go:111 [0m[33m[0.000ms] [34;1m[rows:-][0m SELECT * FROM tiku LIMIT 1

2024/08/06 23:46:42 [32m/home/runner/go/pkg/mod/github.com/glebarez/sqlite@v1.10.0/migrator.go:20 [0m[33m[0.000ms] [34;1m[rows:1][0m PRAGMA foreign_keys

2024/08/06 23:46:42 [32m/home/runner/go/pkg/mod/github.com/glebarez/sqlite@v1.10.0/migrator.go:344 [0m[33m[0.000ms] [34;1m[rows:-][0m SELECT sql FROM sqlite_master WHERE type = "table" AND tbl_name = "tiku" AND name = "tiku"

2024/08/06 23:46:42 [32m/home/runner/go/pkg/mod/github.com/glebarez/sqlite@v1.10.0/migrator.go:389 [0m[33m[1.037ms] [34;1m[rows:0][0m CREATE TABLE tiku__temp (id int(11),question longtext NOT NULL,type int(11) NOT NULL,options longtext NOT NULL,answer longtext NOT NULL,plat int(11) NOT NULL,hash char(32) NOT NULL,course_name varchar(255),extra text,PRIMARY KEY (id))

2024/08/06 23:46:42 [32m/home/runner/go/pkg/mod/github.com/glebarez/sqlite@v1.10.0/migrator.go:399 [0m[33m[0.000ms] [34;1m[rows:0][0m INSERT INTO tiku__temp(id,question,type,options,answer,plat,hash,course_name,extra) SELECT id,question,type,options,answer,plat,hash,course_name,extra FROM tiku

2024/08/06 23:46:42 [32m/home/runner/go/pkg/mod/github.com/glebarez/sqlite@v1.10.0/migrator.go:399 [0m[33m[0.000ms] [34;1m[rows:0][0m DROP TABLE tiku

2024/08/06 23:46:42 [32m/home/runner/go/pkg/mod/github.com/glebarez/sqlite@v1.10.0/migrator.go:399 [0m[33m[0.000ms] [34;1m[rows:0][0m ALTER TABLE tiku__temp RENAME TO tiku

2024/08/06 23:46:42 [32m/home/runner/go/pkg/mod/github.com/glebarez/sqlite@v1.10.0/migrator.go:20 [0m[33m[0.508ms] [34;1m[rows:1][0m PRAGMA foreign_keys

2024/08/06 23:46:42 [32m/home/runner/go/pkg/mod/github.com/glebarez/sqlite@v1.10.0/migrator.go:344 [0m[33m[0.000ms] [34;1m[rows:-][0m SELECT sql FROM sqlite_master WHERE type = "table" AND tbl_name = "tiku" AND name = "tiku"

2024/08/06 23:46:42 [32m/home/runner/go/pkg/mod/github.com/glebarez/sqlite@v1.10.0/migrator.go:389 [0m[33m[0.510ms] [34;1m[rows:0][0m CREATE TABLE tiku__temp (id int(11),question longtext NOT NULL,type int(11) NOT NULL,options longtext NOT NULL,answer longtext NOT NULL,plat int(11) NOT NULL,hash char(32) NOT NULL,course_name varchar(255),extra text,PRIMARY KEY (id))

2024/08/06 23:46:42 [32m/home/runner/go/pkg/mod/github.com/glebarez/sqlite@v1.10.0/migrator.go:399 [0m[33m[0.000ms] [34;1m[rows:0][0m INSERT INTO tiku__temp(id,question,type,options,answer,plat,hash,course_name,extra) SELECT id,question,type,options,answer,plat,hash,course_name,extra FROM tiku

2024/08/06 23:46:42 [32m/home/runner/go/pkg/mod/github.com/glebarez/sqlite@v1.10.0/migrator.go:399 [0m[33m[0.513ms] [34;1m[rows:0][0m DROP TABLE tiku

2024/08/06 23:46:42 [32m/home/runner/go/pkg/mod/github.com/glebarez/sqlite@v1.10.0/migrator.go:399 [0m[33m[0.000ms] [34;1m[rows:0][0m ALTER TABLE tiku__temp RENAME TO tiku

2024/08/06 23:46:42 [32m/home/runner/go/pkg/mod/github.com/glebarez/sqlite@v1.10.0/migrator.go:20 [0m[33m[0.000ms] [34;1m[rows:1][0m PRAGMA foreign_keys

2024/08/06 23:46:42 [32m/home/runner/go/pkg/mod/github.com/glebarez/sqlite@v1.10.0/migrator.go:344 [0m[33m[0.000ms] [34;1m[rows:-][0m SELECT sql FROM sqlite_master WHERE type = "table" AND tbl_name = "tiku" AND name = "tiku"

2024/08/06 23:46:42 [32m/home/runner/go/pkg/mod/github.com/glebarez/sqlite@v1.10.0/migrator.go:389 [0m[33m[0.512ms] [34;1m[rows:0][0m CREATE TABLE tiku__temp (id int(11),question longtext NOT NULL,type int(11) NOT NULL,options longtext NOT NULL,answer longtext NOT NULL,plat int(11) NOT NULL,hash char(32) NOT NULL,course_name varchar(255),extra text,PRIMARY KEY (id))

2024/08/06 23:46:42 [32m/home/runner/go/pkg/mod/github.com/glebarez/sqlite@v1.10.0/migrator.go:399 [0m[33m[0.000ms] [34;1m[rows:0][0m INSERT INTO tiku__temp(id,question,type,options,answer,plat,hash,course_name,extra) SELECT id,question,type,options,answer,plat,hash,course_name,extra FROM tiku

2024/08/06 23:46:42 [32m/home/runner/go/pkg/mod/github.com/glebarez/sqlite@v1.10.0/migrator.go:399 [0m[33m[0.510ms] [34;1m[rows:0][0m DROP TABLE tiku

2024/08/06 23:46:42 [32m/home/runner/go/pkg/mod/github.com/glebarez/sqlite@v1.10.0/migrator.go:399 [0m[33m[0.000ms] [34;1m[rows:0][0m ALTER TABLE tiku__temp RENAME TO tiku

2024/08/06 23:46:42 [32m/home/runner/go/pkg/mod/github.com/glebarez/sqlite@v1.10.0/migrator.go:287 [0m[33m[0.000ms] [34;1m[rows:-][0m SELECT count(*) FROM sqlite_master WHERE type = "index" AND tbl_name = "tiku" AND name = "hash_index"

2024/08/06 23:46:42 [32m/home/runner/go/pkg/mod/github.com/glebarez/sqlite@v1.10.0/migrator.go:268 [0m[33m[1.994ms] [34;1m[rows:0][0m CREATE UNIQUE INDEX hash_index ON tiku(hash)

2024/08/06 23:46:42 [32m/home/runner/go/pkg/mod/github.com/glebarez/sqlite@v1.10.0/migrator.go:32 [0m[33m[0.000ms] [34;1m[rows:-][0m SELECT count(*) FROM sqlite_master WHERE type='table' AND name="users"

2024/08/06 23:46:42 [32m/home/runner/go/pkg/mod/github.com/glebarez/sqlite@v1.10.0/migrator.go:103 [0m[33m[0.000ms] [34;1m[rows:1][0m SELECT sql FROM sqlite_master WHERE type IN ("table","index") AND tbl_name = "users" AND sql IS NOT NULL order by type = "table" desc

2024/08/06 23:46:42 [32m/home/runner/go/pkg/mod/github.com/glebarez/sqlite@v1.10.0/migrator.go:111 [0m[33m[0.000ms] [34;1m[rows:-][0m SELECT * FROM users LIMIT 1

2024/08/06 23:46:42 [32m/home/runner/go/pkg/mod/github.com/glebarez/sqlite@v1.10.0/migrator.go:20 [0m[33m[0.000ms] [34;1m[rows:1][0m PRAGMA foreign_keys

2024/08/06 23:46:42 [32m/home/runner/go/pkg/mod/github.com/glebarez/sqlite@v1.10.0/migrator.go:344 [0m[33m[0.000ms] [34;1m[rows:-][0m SELECT sql FROM sqlite_master WHERE type = "table" AND tbl_name = "users" AND name = "users"

2024/08/06 23:46:42 [32m/home/runner/go/pkg/mod/github.com/glebarez/sqlite@v1.10.0/migrator.go:389 [0m[33m[0.582ms] [34;1m[rows:0][0m CREATE TABLE users__temp (id int(11),username varchar(255),password varchar(255),perms varchar(255),parent_id int(11),nickname varchar(255),PRIMARY KEY (id))

2024/08/06 23:46:42 [32m/home/runner/go/pkg/mod/github.com/glebarez/sqlite@v1.10.0/migrator.go:399 [0m[33m[0.000ms] [34;1m[rows:1][0m INSERT INTO users__temp(id,username,password,perms,parent_id,nickname) SELECT id,username,password,perms,parent_id,nickname FROM users

2024/08/06 23:46:42 [32m/home/runner/go/pkg/mod/github.com/glebarez/sqlite@v1.10.0/migrator.go:399 [0m[33m[0.514ms] [34;1m[rows:1][0m DROP TABLE users

2024/08/06 23:46:42 [32m/home/runner/go/pkg/mod/github.com/glebarez/sqlite@v1.10.0/migrator.go:399 [0m[33m[0.000ms] [34;1m[rows:1][0m ALTER TABLE users__temp RENAME TO users

2024/08/06 23:46:42 [32m/home/runner/go/pkg/mod/github.com/glebarez/sqlite@v1.10.0/migrator.go:20 [0m[33m[0.000ms] [34;1m[rows:1][0m PRAGMA foreign_keys

2024/08/06 23:46:42 [32m/home/runner/go/pkg/mod/github.com/glebarez/sqlite@v1.10.0/migrator.go:344 [0m[33m[0.000ms] [34;1m[rows:-][0m SELECT sql FROM sqlite_master WHERE type = "table" AND tbl_name = "users" AND name = "users"

2024/08/06 23:46:42 [32m/home/runner/go/pkg/mod/github.com/glebarez/sqlite@v1.10.0/migrator.go:389 [0m[33m[0.000ms] [34;1m[rows:1][0m CREATE TABLE users__temp (id int(11),username varchar(255),password varchar(255),perms varchar(255),parent_id int(11),nickname varchar(255),PRIMARY KEY (id))

2024/08/06 23:46:42 [32m/home/runner/go/pkg/mod/github.com/glebarez/sqlite@v1.10.0/migrator.go:399 [0m[33m[0.000ms] [34;1m[rows:1][0m INSERT INTO users__temp(id,username,password,perms,parent_id,nickname) SELECT id,username,password,perms,parent_id,nickname FROM users

2024/08/06 23:46:42 [32m/home/runner/go/pkg/mod/github.com/glebarez/sqlite@v1.10.0/migrator.go:399 [0m[33m[0.000ms] [34;1m[rows:1][0m DROP TABLE users

2024/08/06 23:46:42 [32m/home/runner/go/pkg/mod/github.com/glebarez/sqlite@v1.10.0/migrator.go:399 [0m[33m[0.510ms] [34;1m[rows:1][0m ALTER TABLE users__temp RENAME TO users

2024/08/06 23:46:42 [32m/home/runner/go/pkg/mod/github.com/glebarez/sqlite@v1.10.0/migrator.go:32 [0m[33m[0.000ms] [34;1m[rows:-][0m SELECT count(*) FROM sqlite_master WHERE type='table' AND name="logs"

2024/08/06 23:46:42 [32m/home/runner/go/pkg/mod/github.com/glebarez/sqlite@v1.10.0/migrator.go:103 [0m[33m[0.000ms] [34;1m[rows:1][0m SELECT sql FROM sqlite_master WHERE type IN ("table","index") AND tbl_name = "logs" AND sql IS NOT NULL order by type = "table" desc

2024/08/06 23:46:42 [32m/home/runner/go/pkg/mod/github.com/glebarez/sqlite@v1.10.0/migrator.go:111 [0m[33m[0.000ms] [34;1m[rows:-][0m SELECT * FROM logs LIMIT 1

2024/08/06 23:46:42 [32m/home/runner/go/pkg/mod/github.com/glebarez/sqlite@v1.10.0/migrator.go:20 [0m[33m[0.000ms] [34;1m[rows:1][0m PRAGMA foreign_keys

2024/08/06 23:46:42 [32m/home/runner/go/pkg/mod/github.com/glebarez/sqlite@v1.10.0/migrator.go:344 [0m[33m[0.000ms] [34;1m[rows:-][0m SELECT sql FROM sqlite_master WHERE type = "table" AND tbl_name = "logs" AND name = "logs"

2024/08/06 23:46:42 [32m/home/runner/go/pkg/mod/github.com/glebarez/sqlite@v1.10.0/migrator.go:389 [0m[33m[0.508ms] [34;1m[rows:1][0m CREATE TABLE logs__temp (id int(11),qid int(11) NOT NULL,old_answer longtext NOT NULL,new_answer longtext NOT NULL,user_id int(11) NOT NULL,create_time datetime NOT NULL,action tinyint(4) NOT NULL,PRIMARY KEY (id))

2024/08/06 23:46:42 [32m/home/runner/go/pkg/mod/github.com/glebarez/sqlite@v1.10.0/migrator.go:399 [0m[33m[0.000ms] [34;1m[rows:0][0m INSERT INTO logs__temp(id,qid,old_answer,new_answer,user_id,create_time,action) SELECT id,qid,old_answer,new_answer,user_id,create_time,action FROM logs

2024/08/06 23:46:42 [32m/home/runner/go/pkg/mod/github.com/glebarez/sqlite@v1.10.0/migrator.go:399 [0m[33m[0.504ms] [34;1m[rows:0][0m DROP TABLE logs

2024/08/06 23:46:42 [32m/home/runner/go/pkg/mod/github.com/glebarez/sqlite@v1.10.0/migrator.go:399 [0m[33m[0.000ms] [34;1m[rows:0][0m ALTER TABLE logs__temp RENAME TO logs

2024/08/06 23:46:42 [32m/home/runner/go/pkg/mod/github.com/glebarez/sqlite@v1.10.0/migrator.go:20 [0m[33m[0.000ms] [34;1m[rows:1][0m PRAGMA foreign_keys

2024/08/06 23:46:42 [32m/home/runner/go/pkg/mod/github.com/glebarez/sqlite@v1.10.0/migrator.go:344 [0m[33m[0.000ms] [34;1m[rows:-][0m SELECT sql FROM sqlite_master WHERE type = "table" AND tbl_name = "logs" AND name = "logs"

2024/08/06 23:46:42 [32m/home/runner/go/pkg/mod/github.com/glebarez/sqlite@v1.10.0/migrator.go:389 [0m[33m[0.000ms] [34;1m[rows:0][0m CREATE TABLE logs__temp (id int(11),qid int(11) NOT NULL,old_answer longtext NOT NULL,new_answer longtext NOT NULL,user_id int(11) NOT NULL,create_time datetime NOT NULL,action tinyint(4) NOT NULL,PRIMARY KEY (id))

2024/08/06 23:46:42 [32m/home/runner/go/pkg/mod/github.com/glebarez/sqlite@v1.10.0/migrator.go:399 [0m[33m[0.000ms] [34;1m[rows:0][0m INSERT INTO logs__temp(id,qid,old_answer,new_answer,user_id,create_time,action) SELECT id,qid,old_answer,new_answer,user_id,create_time,action FROM logs

2024/08/06 23:46:42 [32m/home/runner/go/pkg/mod/github.com/glebarez/sqlite@v1.10.0/migrator.go:399 [0m[33m[0.000ms] [34;1m[rows:0][0m DROP TABLE logs

2024/08/06 23:46:42 [32m/home/runner/go/pkg/mod/github.com/glebarez/sqlite@v1.10.0/migrator.go:399 [0m[33m[0.508ms] [34;1m[rows:0][0m ALTER TABLE logs__temp RENAME TO logs

2024/08/06 23:46:42 [32m/home/runner/go/pkg/mod/github.com/glebarez/sqlite@v1.10.0/migrator.go:20 [0m[33m[0.000ms] [34;1m[rows:1][0m PRAGMA foreign_keys

2024/08/06 23:46:42 [32m/home/runner/go/pkg/mod/github.com/glebarez/sqlite@v1.10.0/migrator.go:344 [0m[33m[0.000ms] [34;1m[rows:-][0m SELECT sql FROM sqlite_master WHERE type = "table" AND tbl_name = "logs" AND name = "logs"

2024/08/06 23:46:42 [32m/home/runner/go/pkg/mod/github.com/glebarez/sqlite@v1.10.0/migrator.go:389 [0m[33m[0.574ms] [34;1m[rows:0][0m CREATE TABLE logs__temp (id int(11),qid int(11) NOT NULL,old_answer longtext NOT NULL,new_answer longtext NOT NULL,user_id int(11) NOT NULL,create_time datetime NOT NULL,action tinyint(4) NOT NULL,PRIMARY KEY (id))

2024/08/06 23:46:42 [32m/home/runner/go/pkg/mod/github.com/glebarez/sqlite@v1.10.0/migrator.go:399 [0m[33m[0.000ms] [34;1m[rows:0][0m INSERT INTO logs__temp(id,qid,old_answer,new_answer,user_id,create_time,action) SELECT id,qid,old_answer,new_answer,user_id,create_time,action FROM logs

2024/08/06 23:46:42 [32m/home/runner/go/pkg/mod/github.com/glebarez/sqlite@v1.10.0/migrator.go:399 [0m[33m[0.000ms] [34;1m[rows:0][0m DROP TABLE logs

2024/08/06 23:46:42 [32m/home/runner/go/pkg/mod/github.com/glebarez/sqlite@v1.10.0/migrator.go:399 [0m[33m[0.509ms] [34;1m[rows:0][0m ALTER TABLE logs__temp RENAME TO logs

2024/08/06 23:46:42 [32m/home/runner/go/pkg/mod/github.com/glebarez/sqlite@v1.10.0/migrator.go:20 [0m[33m[0.000ms] [34;1m[rows:1][0m PRAGMA foreign_keys

2024/08/06 23:46:42 [32m/home/runner/go/pkg/mod/github.com/glebarez/sqlite@v1.10.0/migrator.go:344 [0m[33m[0.000ms] [34;1m[rows:-][0m SELECT sql FROM sqlite_master WHERE type = "table" AND tbl_name = "logs" AND name = "logs"

2024/08/06 23:46:42 [32m/home/runner/go/pkg/mod/github.com/glebarez/sqlite@v1.10.0/migrator.go:389 [0m[33m[0.509ms] [34;1m[rows:0][0m CREATE TABLE logs__temp (id int(11),qid int(11) NOT NULL,old_answer longtext NOT NULL,new_answer longtext NOT NULL,user_id int(11) NOT NULL,create_time datetime NOT NULL,action tinyint(4) NOT NULL,PRIMARY KEY (id))

2024/08/06 23:46:42 [32m/home/runner/go/pkg/mod/github.com/glebarez/sqlite@v1.10.0/migrator.go:399 [0m[33m[0.000ms] [34;1m[rows:0][0m INSERT INTO logs__temp(id,qid,old_answer,new_answer,user_id,create_time,action) SELECT id,qid,old_answer,new_answer,user_id,create_time,action FROM logs

2024/08/06 23:46:42 [32m/home/runner/go/pkg/mod/github.com/glebarez/sqlite@v1.10.0/migrator.go:399 [0m[33m[0.503ms] [34;1m[rows:0][0m DROP TABLE logs

2024/08/06 23:46:42 [32m/home/runner/go/pkg/mod/github.com/glebarez/sqlite@v1.10.0/migrator.go:399 [0m[33m[0.000ms] [34;1m[rows:0][0m ALTER TABLE logs__temp RENAME TO logs

2024/08/06 23:46:42 [31;1m/home/runner/work/tikuAdapter/tikuAdapter/internal/dao/users.gen.go:268 [35;1mconstraint failed: UNIQUE constraint failed: users.id (1555) [0m[33m[0.000ms] [34;1m[rows:0][0m INSERT INTO users (username,password,perms,parent_id,nickname,id) VALUES ("admin","123456","",0,"管理员",1) RETURNING id [FATAL] 2024/08/06 - 23:46:42 | [bucket name len is between [3-63],now is 0]

guowang23333 commented 2 months ago

替换到beta12解决问题，可能是beta13 数据库有问题？我不太了解我是在无数据库的情况下创建的

DokiDoki1103 commented 2 months ago

[FATAL] 2024/08/06 - 23:46:42 | [bucket name len is between [3-63],now is 0] 阿里云配置有误则启动失败，应该没配置的情况下不加载oss，我来修复

DokiDoki1103 commented 2 months ago

fix: https://github.com/DokiDoki1103/tikuAdapter/releases/tag/v0.1.0-beta.16