[BUG] On update to the latest image "Error: migrate: do migrate: Sync2: Unknown col created_unix seq 0, in index created_unix of table language_stat, columns []" #5112

Closed
opened 2025-11-02 06:14:52 -06:00 by GiteaMirror · 1 comment
Owner

Originally created by @toni-moreno on GitHub (Mar 25, 2020).

  • Gitea version (or commit ref):

NEW Image

            "Labels": {
                "maintainer": "maintainers@gitea.io",
                "org.label-schema.build-date": "2020-03-22T15:36:01Z",
                "org.label-schema.schema-version": "1.0",
                "org.label-schema.vcs-ref": "c61b902538e8e4b2bb83136f190e044a6bbcdd9b",
                "org.label-schema.vcs-url": "https://github.com/go-gitea/gitea.git"
            }

OLD Image

            "Labels": {
                "maintainer": "maintainers@gitea.io",
                "org.label-schema.build-date": "2020-02-06T18:35:11Z",
                "org.label-schema.schema-version": "1.0",
                "org.label-schema.vcs-ref": "727fc42db7d992566deab6e3acbf6ffe4b890dea",
                "org.label-schema.vcs-url": "https://github.com/go-gitea/gitea.git"
            }
  • Operating system:
    docker image
  • Database (use [x]):
    • PostgreSQL
    • MySQL
    • MSSQL
    • SQLite
  • Can you reproduce the bug at https://try.gitea.io:
    • Yes (provide example URL)
    • No
    • Not relevant
  • Log gist:

Description

After updated latest image version , my gitea service has crashed with these logs.

2020/03/25 07:59:14 ...dules/setting/log.go:276:newLogService() [I] Gitea Log Mode: File(File:info)
2020/03/25 07:59:14 ...les/setting/cache.go:70:newCacheService() [I] Cache Service Enabled
2020/03/25 07:59:14 ...les/setting/cache.go:81:newCacheService() [I] Last Commit Cache Service Enabled
2020/03/25 07:59:14 ...s/setting/session.go:63:newSessionService() [I] Session Service Enabled
2020/03/25 07:59:14 routers/init.go:60:initDBEngine() [I] Beginning ORM engine initialization.
2020/03/25 07:59:14 routers/init.go:67:initDBEngine() [I] ORM engine initialization attempt #1/10...
2020/03/25 07:59:14 ...rm/session_schema.go:25:Ping() [I] PING DATABASE postgres
2020/03/25 07:59:14 ...m.io/xorm/core/db.go:150:QueryContext() [I] [SQL] SELECT tablename FROM pg_tables WHERE tablename = $1 [version] - 13.178438ms
2020/03/25 07:59:14 ...m.io/xorm/core/db.go:150:QueryContext() [I] [SQL] SELECT column_name FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = $1 AND column_name = $2 [version id] - 8.764803ms
2020/03/25 07:59:14 ...m.io/xorm/core/db.go:150:QueryContext() [I] [SQL] SELECT column_name FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = $1 AND column_name = $2 [version version] - 3.777694ms
2020/03/25 07:59:14 ...m.io/xorm/core/db.go:150:QueryContext() [I] [SQL] SELECT "id", "version" FROM "version" WHERE "id"=$1 LIMIT 1 [1] - 913.372µs
2020/03/25 07:59:14 ...ations/migrations.go:236:Migrate() [I] Migration[127]: add repository code language statistics
2020/03/25 07:59:14 ...m.io/xorm/core/db.go:150:QueryContext() [I] [SQL] SELECT tablename FROM pg_tables [] - 746.746µs
2020/03/25 07:59:14 ...m.io/xorm/core/db.go:273:ExecContext() [I] [SQL] CREATE TABLE IF NOT EXISTS "language_stat" ("id" BIGSERIAL PRIMARY KEY  NOT NULL, "repo_id" BIGINT NOT NULL, "commit_id" VARCHAR(255) NULL, "is_primary" BOOL NULL, "language" VARCHAR(30) NOT NULL, "percentage" NUMERIC(5,2) DEFAULT 0 NOT NULL, "created_unix" BIGINT NULL) [] - 76.738638ms
2020/03/25 07:59:14 ...m.io/xorm/core/db.go:273:ExecContext() [I] [SQL] CREATE UNIQUE INDEX "UQE_language_stat_s" ON "language_stat" ("repo_id","language") [] - 22.543543ms
2020/03/25 07:59:14 ...m.io/xorm/core/db.go:273:ExecContext() [I] [SQL] CREATE INDEX "IDX_language_stat_repo_id" ON "language_stat" ("repo_id") [] - 18.309462ms
2020/03/25 07:59:14 ...m.io/xorm/core/db.go:273:ExecContext() [I] [SQL] CREATE INDEX "IDX_language_stat_language" ON "language_stat" ("language") [] - 19.146147ms
2020/03/25 07:59:14 ...m.io/xorm/core/db.go:273:ExecContext() [I] [SQL] CREATE INDEX "IDX_language_stat_created_unix" ON "language_stat" ("created_unix") [] - 21.395815ms
2020/03/25 07:59:14 ...m.io/xorm/core/db.go:150:QueryContext() [I] [SQL] SELECT tablename FROM pg_tables [] - 861.162µs
2020/03/25 07:59:14 ...m.io/xorm/core/db.go:150:QueryContext() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length,
            CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
            CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
        FROM pg_attribute f
            JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
            LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
            LEFT JOIN pg_namespace n ON n.oid = c.relnamespace            LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
            LEFT JOIN pg_class AS g ON p.confrelid = g.oid
            LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
        WHERE n.nspname= $1 AND c.relkind = 'r'::char AND c.relname = $2 AND s.table_schema = $3 AND f.attnum > 0 ORDER BY f.attnum; [ repo_indexer_status ] - 10.113924ms
2020/03/25 07:59:14 ...m.io/xorm/core/db.go:150:QueryContext() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 [repo_indexer_status] - 2.196999ms
2020/03/25 07:59:14 routers/init.go:73:initDBEngine() [E] ORM engine initialization attempt #1/10 failed. Error: migrate: do migrate: Sync2: Unknown col repo_id seq 0, in index repo_id of table repo_indexer_status, columns []
2020/03/25 07:59:14 routers/init.go:74:initDBEngine() [I] Backing off for 3 seconds
2020/03/25 07:59:17 routers/init.go:67:initDBEngine() [I] ORM engine initialization attempt #2/10...
2020/03/25 07:59:17 ...rm/session_schema.go:25:Ping() [I] PING DATABASE postgres
2020/03/25 07:59:17 ...m.io/xorm/core/db.go:150:QueryContext() [I] [SQL] SELECT tablename FROM pg_tables WHERE tablename = $1 [version] - 3.480826ms
2020/03/25 07:59:17 ...m.io/xorm/core/db.go:150:QueryContext() [I] [SQL] SELECT column_name FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = $1 AND column_name = $2 [version id] - 12.05967ms
2020/03/25 07:59:17 ...m.io/xorm/core/db.go:150:QueryContext() [I] [SQL] SELECT column_name FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = $1 AND column_name = $2 [version version] - 5.510619ms
2020/03/25 07:59:17 ...m.io/xorm/core/db.go:150:QueryContext() [I] [SQL] SELECT "id", "version" FROM "version" WHERE "id"=$1 LIMIT 1 [1] - 1.152566ms
2020/03/25 07:59:17 ...ations/migrations.go:236:Migrate() [I] Migration[127]: add repository code language statistics
2020/03/25 07:59:17 ...m.io/xorm/core/db.go:150:QueryContext() [I] [SQL] SELECT tablename FROM pg_tables [] - 975.784µs
2020/03/25 07:59:17 ...m.io/xorm/core/db.go:150:QueryContext() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length,
            CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
            CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
        FROM pg_attribute f
            JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
            LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
            LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
            LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
            LEFT JOIN pg_class AS g ON p.confrelid = g.oid
            LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
        WHERE n.nspname= $1 AND c.relkind = 'r'::char AND c.relname = $2 AND s.table_schema = $3 AND f.attnum > 0 ORDER BY f.attnum; [ language_stat ] - 13.010777ms
2020/03/25 07:59:17 ...m.io/xorm/core/db.go:150:QueryContext() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 [language_stat] - 3.328053ms
            LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
            LEFT JOIN pg_class AS g ON p.confrelid = g.oid
            LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
        WHERE n.nspname= $1 AND c.relkind = 'r'::char AND c.relname = $2 AND s.table_schema = $3 AND f.attnum > 0 ORDER BY f.attnum; [ repo_indexer_status ] - 10.113924ms
2020/03/25 07:59:14 ...m.io/xorm/core/db.go:150:QueryContext() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 [repo_indexer_status] - 2.196999ms
2020/03/25 07:59:14 routers/init.go:73:initDBEngine() [E] ORM engine initialization attempt #1/10 failed. Error: migrate: do migrate: Sync2: Unknown col repo_id seq 0, in index repo_id of table repo_indexer_status, columns []
2020/03/25 07:59:14 routers/init.go:74:initDBEngine() [I] Backing off for 3 seconds
2020/03/25 07:59:17 routers/init.go:67:initDBEngine() [I] ORM engine initialization attempt #2/10...
2020/03/25 07:59:17 ...rm/session_schema.go:25:Ping() [I] PING DATABASE postgres
2020/03/25 07:59:17 ...m.io/xorm/core/db.go:150:QueryContext() [I] [SQL] SELECT tablename FROM pg_tables WHERE tablename = $1 [version] - 3.480826ms
2020/03/25 07:59:17 ...m.io/xorm/core/db.go:150:QueryContext() [I] [SQL] SELECT column_name FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = $1 AND column_name = $2 [version id] - 12.05967ms
2020/03/25 07:59:17 ...m.io/xorm/core/db.go:150:QueryContext() [I] [SQL] SELECT column_name FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = $1 AND column_name = $2 [version version] - 5.510619ms
2020/03/25 07:59:17 ...m.io/xorm/core/db.go:150:QueryContext() [I] [SQL] SELECT "id", "version" FROM "version" WHERE "id"=$1 LIMIT 1 [1] - 1.152566ms
2020/03/25 07:59:17 ...ations/migrations.go:236:Migrate() [I] Migration[127]: add repository code language statistics
2020/03/25 07:59:17 ...m.io/xorm/core/db.go:150:QueryContext() [I] [SQL] SELECT tablename FROM pg_tables [] - 975.784µs
2020/03/25 07:59:17 ...m.io/xorm/core/db.go:150:QueryContext() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length,
            CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
            CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
        FROM pg_attribute f
            JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
            LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
            LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
            LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
            LEFT JOIN pg_class AS g ON p.confrelid = g.oid
            LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
        WHERE n.nspname= $1 AND c.relkind = 'r'::char AND c.relname = $2 AND s.table_schema = $3 AND f.attnum > 0 ORDER BY f.attnum; [ language_stat ] - 13.010777ms
2020/03/25 07:59:17 ...m.io/xorm/core/db.go:150:QueryContext() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 [language_stat] - 3.328053ms
Originally created by @toni-moreno on GitHub (Mar 25, 2020). - Gitea version (or commit ref): __NEW Image__ ``` "Labels": { "maintainer": "maintainers@gitea.io", "org.label-schema.build-date": "2020-03-22T15:36:01Z", "org.label-schema.schema-version": "1.0", "org.label-schema.vcs-ref": "c61b902538e8e4b2bb83136f190e044a6bbcdd9b", "org.label-schema.vcs-url": "https://github.com/go-gitea/gitea.git" } ``` __OLD Image__ ``` "Labels": { "maintainer": "maintainers@gitea.io", "org.label-schema.build-date": "2020-02-06T18:35:11Z", "org.label-schema.schema-version": "1.0", "org.label-schema.vcs-ref": "727fc42db7d992566deab6e3acbf6ffe4b890dea", "org.label-schema.vcs-url": "https://github.com/go-gitea/gitea.git" } ``` - Operating system: docker image - Database (use `[x]`): - [X] PostgreSQL - [ ] MySQL - [ ] MSSQL - [ ] SQLite - Can you reproduce the bug at https://try.gitea.io: - [ ] Yes (provide example URL) - [ ] No - [X] Not relevant - Log gist: ## Description After updated latest image version , my gitea service has crashed with these logs. ``` 2020/03/25 07:59:14 ...dules/setting/log.go:276:newLogService() [I] Gitea Log Mode: File(File:info) 2020/03/25 07:59:14 ...les/setting/cache.go:70:newCacheService() [I] Cache Service Enabled 2020/03/25 07:59:14 ...les/setting/cache.go:81:newCacheService() [I] Last Commit Cache Service Enabled 2020/03/25 07:59:14 ...s/setting/session.go:63:newSessionService() [I] Session Service Enabled 2020/03/25 07:59:14 routers/init.go:60:initDBEngine() [I] Beginning ORM engine initialization. 2020/03/25 07:59:14 routers/init.go:67:initDBEngine() [I] ORM engine initialization attempt #1/10... 2020/03/25 07:59:14 ...rm/session_schema.go:25:Ping() [I] PING DATABASE postgres 2020/03/25 07:59:14 ...m.io/xorm/core/db.go:150:QueryContext() [I] [SQL] SELECT tablename FROM pg_tables WHERE tablename = $1 [version] - 13.178438ms 2020/03/25 07:59:14 ...m.io/xorm/core/db.go:150:QueryContext() [I] [SQL] SELECT column_name FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = $1 AND column_name = $2 [version id] - 8.764803ms 2020/03/25 07:59:14 ...m.io/xorm/core/db.go:150:QueryContext() [I] [SQL] SELECT column_name FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = $1 AND column_name = $2 [version version] - 3.777694ms 2020/03/25 07:59:14 ...m.io/xorm/core/db.go:150:QueryContext() [I] [SQL] SELECT "id", "version" FROM "version" WHERE "id"=$1 LIMIT 1 [1] - 913.372µs 2020/03/25 07:59:14 ...ations/migrations.go:236:Migrate() [I] Migration[127]: add repository code language statistics 2020/03/25 07:59:14 ...m.io/xorm/core/db.go:150:QueryContext() [I] [SQL] SELECT tablename FROM pg_tables [] - 746.746µs 2020/03/25 07:59:14 ...m.io/xorm/core/db.go:273:ExecContext() [I] [SQL] CREATE TABLE IF NOT EXISTS "language_stat" ("id" BIGSERIAL PRIMARY KEY NOT NULL, "repo_id" BIGINT NOT NULL, "commit_id" VARCHAR(255) NULL, "is_primary" BOOL NULL, "language" VARCHAR(30) NOT NULL, "percentage" NUMERIC(5,2) DEFAULT 0 NOT NULL, "created_unix" BIGINT NULL) [] - 76.738638ms 2020/03/25 07:59:14 ...m.io/xorm/core/db.go:273:ExecContext() [I] [SQL] CREATE UNIQUE INDEX "UQE_language_stat_s" ON "language_stat" ("repo_id","language") [] - 22.543543ms 2020/03/25 07:59:14 ...m.io/xorm/core/db.go:273:ExecContext() [I] [SQL] CREATE INDEX "IDX_language_stat_repo_id" ON "language_stat" ("repo_id") [] - 18.309462ms 2020/03/25 07:59:14 ...m.io/xorm/core/db.go:273:ExecContext() [I] [SQL] CREATE INDEX "IDX_language_stat_language" ON "language_stat" ("language") [] - 19.146147ms 2020/03/25 07:59:14 ...m.io/xorm/core/db.go:273:ExecContext() [I] [SQL] CREATE INDEX "IDX_language_stat_created_unix" ON "language_stat" ("created_unix") [] - 21.395815ms 2020/03/25 07:59:14 ...m.io/xorm/core/db.go:150:QueryContext() [I] [SQL] SELECT tablename FROM pg_tables [] - 861.162µs 2020/03/25 07:59:14 ...m.io/xorm/core/db.go:150:QueryContext() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey, CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey FROM pg_attribute f JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum LEFT JOIN pg_namespace n ON n.oid = c.relnamespace LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey) LEFT JOIN pg_class AS g ON p.confrelid = g.oid LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name WHERE n.nspname= $1 AND c.relkind = 'r'::char AND c.relname = $2 AND s.table_schema = $3 AND f.attnum > 0 ORDER BY f.attnum; [ repo_indexer_status ] - 10.113924ms 2020/03/25 07:59:14 ...m.io/xorm/core/db.go:150:QueryContext() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 [repo_indexer_status] - 2.196999ms 2020/03/25 07:59:14 routers/init.go:73:initDBEngine() [E] ORM engine initialization attempt #1/10 failed. Error: migrate: do migrate: Sync2: Unknown col repo_id seq 0, in index repo_id of table repo_indexer_status, columns [] 2020/03/25 07:59:14 routers/init.go:74:initDBEngine() [I] Backing off for 3 seconds 2020/03/25 07:59:17 routers/init.go:67:initDBEngine() [I] ORM engine initialization attempt #2/10... 2020/03/25 07:59:17 ...rm/session_schema.go:25:Ping() [I] PING DATABASE postgres 2020/03/25 07:59:17 ...m.io/xorm/core/db.go:150:QueryContext() [I] [SQL] SELECT tablename FROM pg_tables WHERE tablename = $1 [version] - 3.480826ms 2020/03/25 07:59:17 ...m.io/xorm/core/db.go:150:QueryContext() [I] [SQL] SELECT column_name FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = $1 AND column_name = $2 [version id] - 12.05967ms 2020/03/25 07:59:17 ...m.io/xorm/core/db.go:150:QueryContext() [I] [SQL] SELECT column_name FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = $1 AND column_name = $2 [version version] - 5.510619ms 2020/03/25 07:59:17 ...m.io/xorm/core/db.go:150:QueryContext() [I] [SQL] SELECT "id", "version" FROM "version" WHERE "id"=$1 LIMIT 1 [1] - 1.152566ms 2020/03/25 07:59:17 ...ations/migrations.go:236:Migrate() [I] Migration[127]: add repository code language statistics 2020/03/25 07:59:17 ...m.io/xorm/core/db.go:150:QueryContext() [I] [SQL] SELECT tablename FROM pg_tables [] - 975.784µs 2020/03/25 07:59:17 ...m.io/xorm/core/db.go:150:QueryContext() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey, CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey FROM pg_attribute f JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum LEFT JOIN pg_namespace n ON n.oid = c.relnamespace LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey) LEFT JOIN pg_class AS g ON p.confrelid = g.oid LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name WHERE n.nspname= $1 AND c.relkind = 'r'::char AND c.relname = $2 AND s.table_schema = $3 AND f.attnum > 0 ORDER BY f.attnum; [ language_stat ] - 13.010777ms 2020/03/25 07:59:17 ...m.io/xorm/core/db.go:150:QueryContext() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 [language_stat] - 3.328053ms LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey) LEFT JOIN pg_class AS g ON p.confrelid = g.oid LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name WHERE n.nspname= $1 AND c.relkind = 'r'::char AND c.relname = $2 AND s.table_schema = $3 AND f.attnum > 0 ORDER BY f.attnum; [ repo_indexer_status ] - 10.113924ms 2020/03/25 07:59:14 ...m.io/xorm/core/db.go:150:QueryContext() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 [repo_indexer_status] - 2.196999ms 2020/03/25 07:59:14 routers/init.go:73:initDBEngine() [E] ORM engine initialization attempt #1/10 failed. Error: migrate: do migrate: Sync2: Unknown col repo_id seq 0, in index repo_id of table repo_indexer_status, columns [] 2020/03/25 07:59:14 routers/init.go:74:initDBEngine() [I] Backing off for 3 seconds 2020/03/25 07:59:17 routers/init.go:67:initDBEngine() [I] ORM engine initialization attempt #2/10... 2020/03/25 07:59:17 ...rm/session_schema.go:25:Ping() [I] PING DATABASE postgres 2020/03/25 07:59:17 ...m.io/xorm/core/db.go:150:QueryContext() [I] [SQL] SELECT tablename FROM pg_tables WHERE tablename = $1 [version] - 3.480826ms 2020/03/25 07:59:17 ...m.io/xorm/core/db.go:150:QueryContext() [I] [SQL] SELECT column_name FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = $1 AND column_name = $2 [version id] - 12.05967ms 2020/03/25 07:59:17 ...m.io/xorm/core/db.go:150:QueryContext() [I] [SQL] SELECT column_name FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = $1 AND column_name = $2 [version version] - 5.510619ms 2020/03/25 07:59:17 ...m.io/xorm/core/db.go:150:QueryContext() [I] [SQL] SELECT "id", "version" FROM "version" WHERE "id"=$1 LIMIT 1 [1] - 1.152566ms 2020/03/25 07:59:17 ...ations/migrations.go:236:Migrate() [I] Migration[127]: add repository code language statistics 2020/03/25 07:59:17 ...m.io/xorm/core/db.go:150:QueryContext() [I] [SQL] SELECT tablename FROM pg_tables [] - 975.784µs 2020/03/25 07:59:17 ...m.io/xorm/core/db.go:150:QueryContext() [I] [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey, CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey FROM pg_attribute f JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum LEFT JOIN pg_namespace n ON n.oid = c.relnamespace LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey) LEFT JOIN pg_class AS g ON p.confrelid = g.oid LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name WHERE n.nspname= $1 AND c.relkind = 'r'::char AND c.relname = $2 AND s.table_schema = $3 AND f.attnum > 0 ORDER BY f.attnum; [ language_stat ] - 13.010777ms 2020/03/25 07:59:17 ...m.io/xorm/core/db.go:150:QueryContext() [I] [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 [language_stat] - 3.328053ms ```
Author
Owner

@lunny commented on GitHub (Mar 25, 2020):

duplicated with #10802

@lunny commented on GitHub (Mar 25, 2020): duplicated with #10802
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/gitea#5112