Drizzle TeamDT
Drizzle Team•2y ago
goofysystem

Error performing migration: LibsqlError: SQLITE_UNKNOWN: SQLite error: cannot rollback

I've already tried downgrading to drizzle kit v0.19 as advised in https://discord.com/channels/933071162680958986/933071163184283651/1204583958679912488
Migration works locally with sqld instance but fails when run against the remote turso database. 
Error performing migration:  LibsqlError: SQLITE_UNKNOWN: SQLite error: cannot rollback - no transaction is active
    at mapHranaError (file:///home/runner/work/utc/utc/node_modules/.pnpm/@libsql+client@0.3.1/node_modules/@libsql/client/lib-esm/hrana.js:286:16)
    at file:///home/runner/work/utc/utc/node_modules/.pnpm/@libsql+client@0.3.1/node_modules/@libsql/client/lib-esm/hrana.js:170:37
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async HttpTransaction.rollback (file:///home/runner/work/utc/utc/node_modules/.pnpm/@libsql+client@0.3.1/node_modules/@libsql/client/lib-esm/hrana.js:172:13)
    at LibSQLSession.transaction (/home/runner/work/utc/utc/node_modules/.pnpm/drizzle-orm@0.29.2_@cloudflare+workers-types@4.20231010.0_@libsql+client@0.3.1_@types+react@1_3cr644gqxuhfs2c75frekmndw4/node_modules/src/libsql/session.ts:90:4)
    at SQLiteAsyncDialect.migrate (/home/runner/work/utc/utc/node_modules/.pnpm/drizzle-orm@0.29.2_@cloudflare+workers-types@4.20231010.0_@libsql+client@0.3.1_@types+react@1_3cr644gqxuhfs2c75frekmndw4/node_modules/src/sqlite-core/dialect.ts:772:3)
    at main (/home/runner/work/utc/utc/infra/db/tournament/src/migrate.ts:14:9) {
  code: 'SQLITE_UNKNOWN',
  [cause]: [ResponseError: SQLite error: cannot rollback - no transaction is active] {
    code: 'SQLITE_UNKNOWN',
    proto: {
      message: 'SQLite error: cannot rollback - no transaction is active',
      code: 'SQLITE_UNKNOWN'
    }
  }
}
 ELIFECYCLE  Command failed with exit code 1.
error: Recipe `migrate` failed on line 19 with exit code 1
Was this page helpful?