failed migration in #226 #101

New Issue

2026-10-05T01:41:31+02:00

adam commented

2026-10-05 01:41:31 +02:00

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

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 ```

adam closed this issue

2026-10-05 01:41:31 +02:00

adam commented

2026-10-05 01:41:32 +02:00