adam/gitea-mirror
1
0 Fork 0
mirror of https://github.com/RayLabsHQ/gitea-mirror.git synced 2026-10-30 22:21:58 +01:00
Code Issues 4 Packages Projects Releases Wiki Activity

DrizzleError after update #132

New Issue
Closed
opened 2026-10-05 01:43:34 +02:00 by adam · 4 comments
adam commented 2026-10-05 01:43:34 +02:00
Owner
Copy link
Copy source

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)
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) ``` <!-- github-sync-id:4595796387 -->
adam closed this issue 2026-10-05 01:43:34 +02:00
adam commented 2026-10-05 01:43:35 +02:00
Author
Owner
Copy link
Copy source

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 '
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 ' ``` <!-- github-comment-id:4630034415 -->
adam commented 2026-10-05 01:43:35 +02:00
Author
Owner
Copy link
Copy source

thx, fixed!

thx, fixed! <!-- github-comment-id:4631949786 -->
adam commented 2026-10-05 01:43:36 +02:00
Author
Owner
Copy link
Copy source

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

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 <!-- github-comment-id:4632033734 -->
adam commented 2026-10-05 01:43:36 +02:00
Author
Owner
Copy link
Copy source

appreciate the quick fix!

appreciate the quick fix! <!-- github-comment-id:4632229068 -->
Sign in to join this conversation.
No Branch/Tag Specified
Labels
No items
No labels
Milestone
No items
No Milestone
Projects
Clear projects
No projects
Assignees
Clear assignees
adam (Adam Wojcieszonek)
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: adam/gitea-mirror#132