Skip to content

Instantly share code, notes, and snippets.

@jerrykan
Created August 2, 2016 05:18
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jerrykan/95944b21de45b303523bc3e48f76b207 to your computer and use it in GitHub Desktop.
Save jerrykan/95944b21de45b303523bc3e48f76b207 to your computer and use it in GitHub Desktop.
---- Attempting to restart gogs ----
==> /var/log/gogs/gogs.log <==
2016/08/02 15:14:46 [I] Log Mode: File(Trace)
2016/08/02 15:14:46 [I] Cache Service Enabled
2016/08/02 15:14:46 [I] Session Service Enabled
2016/08/02 15:14:46 [I] Git Version: 2.1.4
==> /var/log/gogs/xorm.log <==
[xorm] [info] 2016/08/02 15:14:46.405516 [sql] SELECT tablename FROM pg_tables WHERE tablename = $1 [args] [version]
[xorm] [info] 2016/08/02 15:14:46.417816 [sql]SELECT column_name FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = $1 AND column_name = $2[version id]
[xorm] [info] 2016/08/02 15:14:46.429258 [sql]SELECT column_name FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = $1 AND column_name = $2[version version]
[xorm] [info] 2016/08/02 15:14:46.434996 [sql] SELECT "id", "version" FROM "version" WHERE "id" = $1 LIMIT 1 [args] [1]
[xorm] [info] 2016/08/02 15:14:46.436522 [sql]SELECT tablename FROM pg_tables WHERE schemaname = $1[public]
[xorm] [info] 2016/08/02 15:14:46.439660 [sql] CREATE TABLE IF NOT EXISTS "user" ("id" SERIAL PRIMARY KEY NOT NULL, "lower_name" VARCHAR(255) NOT NULL, "name" VARCHAR(255) NOT NULL, "full_name" VARCHAR(255) NULL, "email" VARCHAR(255) NOT NULL, "passwd" VARCHAR(255) NOT NULL, "login_type" INTEGER NULL, "login_source" BIGINT NOT NULL DEFAULT 0, "login_name" VARCHAR(255) NULL, "type" INTEGER NULL, "location" VARCHAR(255) NULL, "website" VARCHAR(255) NULL, "rands" VARCHAR(10) NULL, "salt" VARCHAR(10) NULL, "created_unix" BIGINT NULL, "updated_unix" BIGINT NULL, "last_repo_visibility" BOOL NULL, "max_repo_creation" INTEGER NOT NULL DEFAULT -1, "is_active" BOOL NULL, "is_admin" BOOL NULL, "allow_git_hook" BOOL NULL, "allow_import_local" BOOL NULL, "prohibit_login" BOOL NULL, "avatar" VARCHAR(2048) NOT NULL, "avatar_email" VARCHAR(255) NOT NULL, "use_custom_avatar" BOOL NULL, "num_followers" INTEGER NULL, "num_following" INTEGER NOT NULL DEFAULT 0, "num_stars" INTEGER NULL, "num_repos" INTEGER NULL, "description" VARCHAR(255) NULL, "num_teams" INTEGER NULL, "num_members" INTEGER NULL)
[xorm] [info] 2016/08/02 15:14:46.441052 [sql] CREATE UNIQUE INDEX "UQE_user_lower_name" ON "user" ("lower_name")
==> /var/log/gogs/gogs.log <==
2016/08/02 15:14:46 [...s/routers/install.go:71 GlobalInit()] [E] Fail to initialize ORM engine: sync database struct error: pq: relation "UQE_user_lower_name" already exists
---- After Dropping the User Table ----
==> /var/log/gogs/gogs.log <==
2016/08/02 15:17:01 [I] Log Mode: File(Trace)
2016/08/02 15:17:01 [I] Cache Service Enabled
2016/08/02 15:17:01 [I] Session Service Enabled
2016/08/02 15:17:01 [I] Git Version: 2.1.4
==> /var/log/gogs/xorm.log <==
[xorm] [info] 2016/08/02 15:17:01.916774 [sql] SELECT tablename FROM pg_tables WHERE tablename = $1 [args] [version]
[xorm] [info] 2016/08/02 15:17:01.930416 [sql]SELECT column_name FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = $1 AND column_name = $2[version id]
[xorm] [info] 2016/08/02 15:17:01.938854 [sql]SELECT column_name FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = $1 AND column_name = $2[version version]
[xorm] [info] 2016/08/02 15:17:01.943746 [sql] SELECT "id", "version" FROM "version" WHERE "id" = $1 LIMIT 1 [args] [1]
[xorm] [info] 2016/08/02 15:17:01.945449 [sql]SELECT tablename FROM pg_tables WHERE schemaname = $1[public]
[xorm] [info] 2016/08/02 15:17:01.948576 [sql] CREATE TABLE IF NOT EXISTS "user" ("id" SERIAL PRIMARY KEY NOT NULL, "lower_name" VARCHAR(255) NOT NULL, "name" VARCHAR(255) NOT NULL, "full_name" VARCHAR(255) NULL, "email" VARCHAR(255) NOT NULL, "passwd" VARCHAR(255) NOT NULL, "login_type" INTEGER NULL, "login_source" BIGINT NOT NULL DEFAULT 0, "login_name" VARCHAR(255) NULL, "type" INTEGER NULL, "location" VARCHAR(255) NULL, "website" VARCHAR(255) NULL, "rands" VARCHAR(10) NULL, "salt" VARCHAR(10) NULL, "created_unix" BIGINT NULL, "updated_unix" BIGINT NULL, "last_repo_visibility" BOOL NULL, "max_repo_creation" INTEGER NOT NULL DEFAULT -1, "is_active" BOOL NULL, "is_admin" BOOL NULL, "allow_git_hook" BOOL NULL, "allow_import_local" BOOL NULL, "prohibit_login" BOOL NULL, "avatar" VARCHAR(2048) NOT NULL, "avatar_email" VARCHAR(255) NOT NULL, "use_custom_avatar" BOOL NULL, "num_followers" INTEGER NULL, "num_following" INTEGER NOT NULL DEFAULT 0, "num_stars" INTEGER NULL, "num_repos" INTEGER NULL, "description" VARCHAR(255) NULL, "num_teams" INTEGER NULL, "num_members" INTEGER NULL)
[xorm] [info] 2016/08/02 15:17:01.971933 [sql] CREATE UNIQUE INDEX "UQE_user_lower_name" ON "user" ("lower_name")
[xorm] [info] 2016/08/02 15:17:01.975851 [sql] CREATE UNIQUE INDEX "UQE_user_name" ON "user" ("name")
[xorm] [info] 2016/08/02 15:17:01.979586 [sql] CREATE TABLE IF NOT EXISTS "public_key" ("id" SERIAL PRIMARY KEY NOT NULL, "owner_id" BIGINT NOT NULL, "name" VARCHAR(255) NOT NULL, "fingerprint" VARCHAR(255) NOT NULL, "content" TEXT NOT NULL, "mode" INTEGER NOT NULL DEFAULT 2, "type" INTEGER NOT NULL DEFAULT 1, "created_unix" BIGINT NULL, "updated_unix" BIGINT NULL)
[xorm] [info] 2016/08/02 15:17:01.980516 [sql] CREATE INDEX "IDX_public_key_owner_id" ON "public_key" ("owner_id");
==> /var/log/gogs/gogs.log <==
2016/08/02 15:17:01 [...s/routers/install.go:71 GlobalInit()] [E] Fail to initialize ORM engine: sync database struct error: pq: relation "IDX_public_key_owner_id" already exists
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment