github-starred/gitea-mirror
2
0
Fork 0
mirror of https://github.com/RayLabsHQ/gitea-mirror.git synced 2026-07-23 03:37:04 -05:00
Code Issues 323 Packages Projects Releases 113 Wiki Activity

[GH-ISSUE #312] DrizzleError after update #4502

New Issue
Closed
opened 2026-06-13 07:17:00 -05:00 by GiteaMirror · 4 comments
GiteaMirror commented 2026-06-13 07:17:00 -05:00
Owner
Copy Link
Copy Source

Originally created by @CrazyWolf13 on GitHub (Jun 5, 2026).
Original GitHub issue: https://github.com/RayLabsHQ/gitea-mirror/issues/312

Originally assigned to: @arunavo4 on GitHub.

Hi @arunavo4

Following issue after seemingly successful upgrade on start:

Jun 05 11:20:12 gitea-mirror bun[39685]: 11:20:12 [ERROR] DrizzleError: Failed to run the query '
Jun 05 11:20:12 gitea-mirror bun[39685]: ALTER TABLE `sso_providers` ADD `saml_config` text;'
Jun 05 11:20:12 gitea-mirror bun[39685]:     at run (/opt/gitea-mirror/node_modules/drizzle-orm/sqlite-core/session.js:156:17)
Jun 05 11:20:12 gitea-mirror bun[39685]:     at migrate (/opt/gitea-mirror/node_modules/drizzle-orm/sqlite-core/dialect.js:662:21)
Jun 05 11:20:12 gitea-mirror bun[39685]:     at migrate (/opt/gitea-mirror/node_modules/drizzle-orm/bun-sqlite/migrator.js:4:14)
Jun 05 11:20:12 gitea-mirror bun[39685]:     at runDrizzleMigrations (/opt/gitea-mirror/dist/server/chunks/index_DqMeqg5j.mjs:702:7)
Jun 05 11:20:12 gitea-mirror bun[39685]:     at /opt/gitea-mirror/dist/server/chunks/index_DqMeqg5j.mjs:726:3
Jun 05 11:20:12 gitea-mirror bun[39685]:     at processTicksAndRejections (native:7:39)
Originally created by @CrazyWolf13 on GitHub (Jun 5, 2026). Original GitHub issue: https://github.com/RayLabsHQ/gitea-mirror/issues/312 Originally assigned to: @arunavo4 on GitHub. Hi @arunavo4 Following issue after seemingly successful upgrade on start: ```bash Jun 05 11:20:12 gitea-mirror bun[39685]: 11:20:12 [ERROR] DrizzleError: Failed to run the query ' Jun 05 11:20:12 gitea-mirror bun[39685]: ALTER TABLE `sso_providers` ADD `saml_config` text;' Jun 05 11:20:12 gitea-mirror bun[39685]: at run (/opt/gitea-mirror/node_modules/drizzle-orm/sqlite-core/session.js:156:17) Jun 05 11:20:12 gitea-mirror bun[39685]: at migrate (/opt/gitea-mirror/node_modules/drizzle-orm/sqlite-core/dialect.js:662:21) Jun 05 11:20:12 gitea-mirror bun[39685]: at migrate (/opt/gitea-mirror/node_modules/drizzle-orm/bun-sqlite/migrator.js:4:14) Jun 05 11:20:12 gitea-mirror bun[39685]: at runDrizzleMigrations (/opt/gitea-mirror/dist/server/chunks/index_DqMeqg5j.mjs:702:7) Jun 05 11:20:12 gitea-mirror bun[39685]: at /opt/gitea-mirror/dist/server/chunks/index_DqMeqg5j.mjs:726:3 Jun 05 11:20:12 gitea-mirror bun[39685]: at processTicksAndRejections (native:7:39) ```
GiteaMirror added the bug label 2026-06-13 07:17:00 -05:00
GiteaMirror commented 2026-06-13 07:17:03 -05:00
Author
Owner
Copy Link
Copy Source

@CrazyWolf13 commented on GitHub (Jun 5, 2026):

Full log:

Jun 05 11:15:25 gitea-mirror systemd[1]: Stopped gitea-mirror.service - Gitea Mirror.
Jun 05 11:15:25 gitea-mirror systemd[1]: gitea-mirror.service: Consumed 24min 56.444s CPU time, 1.9G memory peak, 293.2M memory swap peak.
Jun 05 11:17:26 gitea-mirror systemd[1]: Started gitea-mirror.service - Gitea Mirror.
Jun 05 11:17:26 gitea-mirror bun[39685]: 11:17:26 [@astrojs/node] Server listening on
Jun 05 11:17:26 gitea-mirror bun[39685]:   local: https://localhost:4321
Jun 05 11:17:26 gitea-mirror bun[39685]:   network: https://10.10.20.45:4321
Jun 05 11:17:31 gitea-mirror bun[39685]: Successfully connected to SQLite database using Bun's native driver
Jun 05 11:17:31 gitea-mirror bun[39685]:  Checking for pending migrations...
Jun 05 11:17:31 gitea-mirror bun[39685]: ❌ Error running migrations: 151 |   run(query) {
Jun 05 11:17:31 gitea-mirror bun[39685]: 152 |     const staticQuery = this.dialect.sqlToQuery(query);
Jun 05 11:17:31 gitea-mirror bun[39685]: 153 |     try {
Jun 05 11:17:31 gitea-mirror bun[39685]: 154 |       return this.prepareOneTimeQuery(staticQuery, void 0, "run", false).run();
Jun 05 11:17:31 gitea-mirror bun[39685]: 155 |     } catch (err) {
Jun 05 11:17:31 gitea-mirror bun[39685]: 156 |       throw new DrizzleError({ cause: err, message: `Failed to run the query '${staticQuery.sql}'` });
Jun 05 11:17:31 gitea-mirror bun[39685]:                   ^
Jun 05 11:17:31 gitea-mirror bun[39685]: DrizzleError: Failed to run the query '
Jun 05 11:17:31 gitea-mirror bun[39685]: ALTER TABLE `sso_providers` ADD `saml_config` text;'
Jun 05 11:17:31 gitea-mirror bun[39685]:       at run (/opt/gitea-mirror/node_modules/drizzle-orm/sqlite-core/session.js:156:13)
Jun 05 11:17:31 gitea-mirror bun[39685]:       at migrate (/opt/gitea-mirror/node_modules/drizzle-orm/sqlite-core/dialect.js:662:21)
Jun 05 11:17:31 gitea-mirror bun[39685]:       at migrate (/opt/gitea-mirror/node_modules/drizzle-orm/bun-sqlite/migrator.js:4:14)
Jun 05 11:17:31 gitea-mirror bun[39685]:       at runDrizzleMigrations (/opt/gitea-mirror/dist/server/chunks/index_DqMeqg5j.mjs:702:7)
Jun 05 11:17:31 gitea-mirror bun[39685]:       at /opt/gitea-mirror/dist/server/chunks/index_DqMeqg5j.mjs:726:3
Jun 05 11:17:31 gitea-mirror bun[39685]: 15 |   logger;
Jun 05 11:17:31 gitea-mirror bun[39685]: 16 |   exec(query) {
Jun 05 11:17:31 gitea-mirror bun[39685]: 17 |     this.client.exec(query);
Jun 05 11:17:31 gitea-mirror bun[39685]: 18 |   }
Jun 05 11:17:31 gitea-mirror bun[39685]: 19 |   prepareQuery(query, fields, executeMethod, isResponseInArrayMode, customResultMapper) {
Jun 05 11:17:31 gitea-mirror bun[39685]: 20 |     const stmt = this.client.prepare(query.sql);
Jun 05 11:17:31 gitea-mirror bun[39685]:                                   ^
Jun 05 11:17:31 gitea-mirror bun[39685]: SQLiteError: duplicate column name: saml_config
Jun 05 11:17:31 gitea-mirror bun[39685]:       errno: 1,
Jun 05 11:17:31 gitea-mirror bun[39685]:  byteOffset: -1,
Jun 05 11:17:31 gitea-mirror bun[39685]:       at prepare (bun:sqlite:345:37)
Jun 05 11:17:31 gitea-mirror bun[39685]:       at prepareQuery (/opt/gitea-mirror/node_modules/drizzle-orm/bun-sqlite/session.js:20:30)
Jun 05 11:17:31 gitea-mirror bun[39685]:       at run (/opt/gitea-mirror/node_modules/drizzle-orm/sqlite-core/session.js:154:19)
Jun 05 11:17:31 gitea-mirror bun[39685]:       at migrate (/opt/gitea-mirror/node_modules/drizzle-orm/sqlite-core/dialect.js:662:21)
Jun 05 11:17:31 gitea-mirror bun[39685]:       at migrate (/opt/gitea-mirror/node_modules/drizzle-orm/bun-sqlite/migrator.js:4:14)
Jun 05 11:17:31 gitea-mirror bun[39685]:       at runDrizzleMigrations (/opt/gitea-mirror/dist/server/chunks/index_DqMeqg5j.mjs:702:7)
Jun 05 11:17:31 gitea-mirror bun[39685]:       at /opt/gitea-mirror/dist/server/chunks/index_DqMeqg5j.mjs:726:3
Jun 05 11:17:31 gitea-mirror bun[39685]: 11:17:31 [ERROR] DrizzleError: Failed to run the query '
<!-- gh-comment-id:4630034415 --> @CrazyWolf13 commented on GitHub (Jun 5, 2026): Full log: ```bash Jun 05 11:15:25 gitea-mirror systemd[1]: Stopped gitea-mirror.service - Gitea Mirror. Jun 05 11:15:25 gitea-mirror systemd[1]: gitea-mirror.service: Consumed 24min 56.444s CPU time, 1.9G memory peak, 293.2M memory swap peak. Jun 05 11:17:26 gitea-mirror systemd[1]: Started gitea-mirror.service - Gitea Mirror. Jun 05 11:17:26 gitea-mirror bun[39685]: 11:17:26 [@astrojs/node] Server listening on Jun 05 11:17:26 gitea-mirror bun[39685]: local: https://localhost:4321 Jun 05 11:17:26 gitea-mirror bun[39685]: network: https://10.10.20.45:4321 Jun 05 11:17:31 gitea-mirror bun[39685]: Successfully connected to SQLite database using Bun's native driver Jun 05 11:17:31 gitea-mirror bun[39685]:  Checking for pending migrations... Jun 05 11:17:31 gitea-mirror bun[39685]: ❌ Error running migrations: 151 | run(query) { Jun 05 11:17:31 gitea-mirror bun[39685]: 152 | const staticQuery = this.dialect.sqlToQuery(query); Jun 05 11:17:31 gitea-mirror bun[39685]: 153 | try { Jun 05 11:17:31 gitea-mirror bun[39685]: 154 | return this.prepareOneTimeQuery(staticQuery, void 0, "run", false).run(); Jun 05 11:17:31 gitea-mirror bun[39685]: 155 | } catch (err) { Jun 05 11:17:31 gitea-mirror bun[39685]: 156 | throw new DrizzleError({ cause: err, message: `Failed to run the query '${staticQuery.sql}'` }); Jun 05 11:17:31 gitea-mirror bun[39685]: ^ Jun 05 11:17:31 gitea-mirror bun[39685]: DrizzleError: Failed to run the query ' Jun 05 11:17:31 gitea-mirror bun[39685]: ALTER TABLE `sso_providers` ADD `saml_config` text;' Jun 05 11:17:31 gitea-mirror bun[39685]: at run (/opt/gitea-mirror/node_modules/drizzle-orm/sqlite-core/session.js:156:13) Jun 05 11:17:31 gitea-mirror bun[39685]: at migrate (/opt/gitea-mirror/node_modules/drizzle-orm/sqlite-core/dialect.js:662:21) Jun 05 11:17:31 gitea-mirror bun[39685]: at migrate (/opt/gitea-mirror/node_modules/drizzle-orm/bun-sqlite/migrator.js:4:14) Jun 05 11:17:31 gitea-mirror bun[39685]: at runDrizzleMigrations (/opt/gitea-mirror/dist/server/chunks/index_DqMeqg5j.mjs:702:7) Jun 05 11:17:31 gitea-mirror bun[39685]: at /opt/gitea-mirror/dist/server/chunks/index_DqMeqg5j.mjs:726:3 Jun 05 11:17:31 gitea-mirror bun[39685]: 15 | logger; Jun 05 11:17:31 gitea-mirror bun[39685]: 16 | exec(query) { Jun 05 11:17:31 gitea-mirror bun[39685]: 17 | this.client.exec(query); Jun 05 11:17:31 gitea-mirror bun[39685]: 18 | } Jun 05 11:17:31 gitea-mirror bun[39685]: 19 | prepareQuery(query, fields, executeMethod, isResponseInArrayMode, customResultMapper) { Jun 05 11:17:31 gitea-mirror bun[39685]: 20 | const stmt = this.client.prepare(query.sql); Jun 05 11:17:31 gitea-mirror bun[39685]: ^ Jun 05 11:17:31 gitea-mirror bun[39685]: SQLiteError: duplicate column name: saml_config Jun 05 11:17:31 gitea-mirror bun[39685]: errno: 1, Jun 05 11:17:31 gitea-mirror bun[39685]: byteOffset: -1, Jun 05 11:17:31 gitea-mirror bun[39685]: at prepare (bun:sqlite:345:37) Jun 05 11:17:31 gitea-mirror bun[39685]: at prepareQuery (/opt/gitea-mirror/node_modules/drizzle-orm/bun-sqlite/session.js:20:30) Jun 05 11:17:31 gitea-mirror bun[39685]: at run (/opt/gitea-mirror/node_modules/drizzle-orm/sqlite-core/session.js:154:19) Jun 05 11:17:31 gitea-mirror bun[39685]: at migrate (/opt/gitea-mirror/node_modules/drizzle-orm/sqlite-core/dialect.js:662:21) Jun 05 11:17:31 gitea-mirror bun[39685]: at migrate (/opt/gitea-mirror/node_modules/drizzle-orm/bun-sqlite/migrator.js:4:14) Jun 05 11:17:31 gitea-mirror bun[39685]: at runDrizzleMigrations (/opt/gitea-mirror/dist/server/chunks/index_DqMeqg5j.mjs:702:7) Jun 05 11:17:31 gitea-mirror bun[39685]: at /opt/gitea-mirror/dist/server/chunks/index_DqMeqg5j.mjs:726:3 Jun 05 11:17:31 gitea-mirror bun[39685]: 11:17:31 [ERROR] DrizzleError: Failed to run the query ' ```
GiteaMirror commented 2026-06-13 07:17:04 -05:00
Author
Owner
Copy Link
Copy Source

@CrazyWolf13 commented on GitHub (Jun 5, 2026):

thx, fixed!

<!-- gh-comment-id:4631949786 --> @CrazyWolf13 commented on GitHub (Jun 5, 2026): thx, fixed!
GiteaMirror commented 2026-06-13 07:17:04 -05:00
Author
Owner
Copy Link
Copy Source

@arunavo4 commented on GitHub (Jun 5, 2026):

Glad it's sorted, thanks for confirming! 🎉

Shipped in v3.17.1: a pre-migration self-heal step now detects when migration 0013 is pending while saml_config/domain_verified already exist on sso_providers, preserves any SAML config, drops the stranded columns so 0013 can run in full, and restores the data

<!-- gh-comment-id:4632033734 --> @arunavo4 commented on GitHub (Jun 5, 2026): Glad it's sorted, thanks for confirming! 🎉 Shipped in **[v3.17.1](https://github.com/RayLabsHQ/gitea-mirror/releases/tag/v3.17.1)**: a pre-migration self-heal step now detects when migration `0013` is pending while `saml_config`/`domain_verified` already exist on `sso_providers`, preserves any SAML config, drops the stranded columns so `0013` can run in full, and restores the data
GiteaMirror commented 2026-06-13 07:17:05 -05:00
Author
Owner
Copy Link
Copy Source

@CrazyWolf13 commented on GitHub (Jun 5, 2026):

appreciate the quick fix!

<!-- gh-comment-id:4632229068 --> @CrazyWolf13 commented on GitHub (Jun 5, 2026): appreciate the quick fix!
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
bug
documentation
enhancement
help wanted
pull-request
Mirrored from GitHub Pull Request
 question
wontfix
No labels bug
Milestone
No items
No Milestone
Projects
Clear projects
No projects
Assignees
Clear assignees
GiteaMirror ninjasurge (Kaehlen Rog)
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/gitea-mirror#4502