[GH-ISSUE #228] failed migration in #226 #1973

New Issue

2026-05-03T02:54:09-05:00

GiteaMirror commented

2026-05-03 02:54:09 -05:00

Originally created by @kapdon on GitHub (Mar 15, 2026).
Original GitHub issue: https://github.com/RayLabsHQ/gitea-mirror/issues/228

Originally assigned to: @arunavo4 on GitHub.

migration has failed on this update.

3749 | const staticQuery = this.dialect.sqlToQuery(query);
3750 | try {
3751 | return this.prepareOneTimeQuery(staticQuery, undefined, "run", false).run();
3752 | throw new DrizzleError({ cause: err, message: Failed to run the query '${staticQuery.sql}' });
^
DrizzleError: Failed to run the query 'ALTER TABLE repositories ADD imported_at integer DEFAULT (unixepoch()) NOT NULL;'
at run (/app/dist/scripts/repair-mirrored-repos.js:3752:13)
at migrate (/app/dist/scripts/repair-mirrored-repos.js:2726:24)
at migrate (/app/dist/scripts/repair-mirrored-repos.js:3985:21)
at runDrizzleMigrations (/app/dist/scripts/repair-mirrored-repos.js:18054:14)
at /app/dist/scripts/repair-mirrored-repos.js:18078:23
at loadAndEvaluateModule (2:1)
133 | return this.#raw.values();
134 | }
135 | #rawNoArgs() {
136 | return this.#raw.raw();
137 | }
138 | return this.#raw.run(internalFieldTuple), createChangesObject();
^
SQLiteError: Cannot add a column with non-constant default

Originally created by @kapdon on GitHub (Mar 15, 2026). Original GitHub issue: https://github.com/RayLabsHQ/gitea-mirror/issues/228 Originally assigned to: @arunavo4 on GitHub. migration has failed on this update. ``` 3749 | const staticQuery = this.dialect.sqlToQuery(query); 3750 | try { 3751 | return this.prepareOneTimeQuery(staticQuery, undefined, "run", false).run(); 3752 | throw new DrizzleError({ cause: err, message: Failed to run the query '${staticQuery.sql}' }); ^ DrizzleError: Failed to run the query 'ALTER TABLE repositories ADD imported_at integer DEFAULT (unixepoch()) NOT NULL;' at run (/app/dist/scripts/repair-mirrored-repos.js:3752:13) at migrate (/app/dist/scripts/repair-mirrored-repos.js:2726:24) at migrate (/app/dist/scripts/repair-mirrored-repos.js:3985:21) at runDrizzleMigrations (/app/dist/scripts/repair-mirrored-repos.js:18054:14) at /app/dist/scripts/repair-mirrored-repos.js:18078:23 at loadAndEvaluateModule (2:1) 133 | return this.#raw.values(); 134 | } 135 | #rawNoArgs() { 136 | return this.#raw.raw(); 137 | } 138 | return this.#raw.run(internalFieldTuple), createChangesObject(); ^ SQLiteError: Cannot add a column with non-constant default ```

GiteaMirror added the bug label 2026-05-03 02:54:09 -05:00

GiteaMirror closed this issue

2026-05-03 02:54:10 -05:00

GiteaMirror commented

2026-05-03 02:54:11 -05:00