7.0.0-beta.11 for pg 版本 启动报错

[pangerl]

Question and Steps to reproduce

使用docker启动compose-postgres，nightingale启动报错，其他服务启动正常。

Relevant logs and configurations

runner.vm_limits: (soft=unlimited, hard=unlimited)
[2024-06-20 13:35:02.074121594 +0800 CST m=+0.012106919] Waiting for host: postgres:5432
[2024-06-20 13:35:02.074914291 +0800 CST m=+0.012899625] Host is ready: postgres:5432
[2024-06-20 13:35:02.074928337 +0800 CST m=+0.012913651] Waiting for host: redis:6379
[2024-06-20 13:35:02.07539098 +0800 CST m=+0.013376335] Host is ready: redis:6379
2024-06-20 13:35:02.608495 ERROR ormx/ormx.go:67 /home/runner/work/nightingale/nightingale/models/migrate/migrate.go:72 ERROR: cannot cast type boolean to bigint (SQLSTATE 42846)
[0.184ms] [rows:0] ALTER TABLE "configs" ALTER COLUMN "external" TYPE bigint USING "external"::bigint
2024-06-20 13:35:02.608517 ERROR migrate/migrate.go:74 failed to migrate table: ERROR: cannot cast type boolean to bigint (SQLSTATE 42846)
2024-06-20 13:35:02.640807 ERROR ormx/ormx.go:67 /home/runner/work/nightingale/nightingale/models/migrate/migrate.go:72 ERROR: cannot cast type smallint to boolean (SQLSTATE 42846)
[0.139ms] [rows:0] ALTER TABLE "datasource" ALTER COLUMN "is_default" TYPE boolean USING "is_default"::boolean
2024-06-20 13:35:02.640821 ERROR migrate/migrate.go:74 failed to migrate table: ERROR: cannot cast type smallint to boolean (SQLSTATE 42846)
2024-06-20 13:35:02.688592 ERROR ormx/ormx.go:67 /home/runner/work/nightingale/nightingale/models/migrate/migrate.go:72 ERROR: syntax error at or near "ENCODING" (SQLSTATE 42601)
[0.126ms] [rows:0] CREATE TABLE "board_busigroup" ("busi_group_id" bigint NOT NULL DEFAULT 0,"board_id" bigint NOT NULL DEFAULT 0)ENCODING='UTF8'
2024-06-20 13:35:02.688611 ERROR migrate/migrate.go:74 failed to migrate table: ERROR: syntax error at or near "ENCODING" (SQLSTATE 42601)
2024-06-20 13:35:02.925930 ERROR ormx/ormx.go:67 /home/runner/work/nightingale/nightingale/models/migrate/migrate.go:72 ERROR: syntax error at or near "ENCODING" (SQLSTATE 42601)
[0.116ms] [rows:0] CREATE TABLE "builtin_components" ("id" bigserial,"ident" varchar(191) NOT NULL,"logo" varchar(191) NOT NULL,"readme" text NOT NULL,"created_at" bigint NOT NULL DEFAULT 0,"created_by" varchar(191) NOT NULL DEFAULT '',"updated_at" bigint NOT NULL DEFAULT 0,"updated_by" varchar(191) NOT NULL DEFAULT '',PRIMARY KEY ("id"))ENCODING='UTF8'
2024-06-20 13:35:02.925950 ERROR migrate/migrate.go:74 failed to migrate table: ERROR: syntax error at or near "ENCODING" (SQLSTATE 42601)
2024-06-20 13:35:02.926430 ERROR ormx/ormx.go:67 /home/runner/work/nightingale/nightingale/models/migrate/migrate.go:72 ERROR: syntax error at or near "ENCODING" (SQLSTATE 42601)
[0.116ms] [rows:0] CREATE TABLE "builtin_payloads" ("id" bigserial,"type" varchar(191) NOT NULL,"component" varchar(191) NOT NULL,"cate" varchar(191) NOT NULL,"name" varchar(191) NOT NULL,"tags" varchar(191) NOT NULL DEFAULT '',"content" longtext NOT NULL,"uuid" bigint NOT NULL,"created_at" bigint NOT NULL DEFAULT 0,"created_by" varchar(191) NOT NULL DEFAULT '',"updated_at" bigint NOT NULL DEFAULT 0,"updated_by" varchar(191) NOT NULL DEFAULT '',PRIMARY KEY ("id"))ENCODING='UTF8'
2024-06-20 13:35:02.926445 ERROR migrate/migrate.go:74 failed to migrate table: ERROR: syntax error at or near "ENCODING" (SQLSTATE 42601)
2024-06-20 13:35:02.938209 ERROR ormx/ormx.go:67 /home/runner/work/nightingale/nightingale/models/user.go:273 sql: Scan error on column index 9, name "maintainer": converting driver.Value type bool ("false") to a int: invalid syntax
[0.406ms] [rows:1] SELECT * FROM "users" WHERE username='root'
failed to query user root: sql: Scan error on column index 9, name "maintainer": converting driver.Value type bool ("false") to a int: invalid syntax
runner.cwd: /app

Version

夜莺版本：n9e-v7.0.0-beta.11-linux-amd64 操作系统：CentOS Linux release 7.8

[710leo]

我们处理下

[710leo]

感谢反馈，beta.12 版本已修复，可以下载下最新版本