[BUG]: Drizzle can no longer run on Durable Objects

[ezShroom]

Report hasn't been filed before.

• I have verified that the bug I'm about to report hasn't been filed before.

What version of drizzle-orm are you using?

0.44.0

What version of drizzle-kit are you using?

0.31.1

Other packages

No response

Describe the Bug

I upgraded my Cloudflare Worker, which uses Durable Objects, to 0.44.0, at which point migrations would fail (with a Rollback error).

This is common when migrations have been generated in the wrong order, but I had already corrected this and it was still happening.

Migrations into a regular SQLite file using the same generated SQL would work, however.

I instead made a loop to apply the migrations manually, and then on the first query, this error would throw:

✘ [ERROR] Uncaught (in promise) TypeError: cache.strategy is not a function

      at SQLitePreparedQuery
  (file:///Users/a/Documents/folder/node_modules/src/sqlite-core/session.ts:63:22)
      at SQLiteDOPreparedQuery
  (file:///Users/a/Documents/folder/node_modules/src/durable-sqlite/session.ts:115:3)
      at prepareQuery
  (file:///Users/a/Documents/folder/node_modules/src/durable-sqlite/session.ts:52:10)
      at prepareOneTimeQuery
  (file:///Users/a/Documents/folder/node_modules/src/sqlite-core/session.ts:251:15)
      at _prepare
  (file:///Users/a/Documents/folder/node_modules/src/sqlite-core/query-builders/select.ts:913:85)
      at all
  (file:///Users/a/Documents/folder/node_modules/src/sqlite-core/query-builders/select.ts:947:15)
      at execute
  (file:///Users/a/Documents/folder/node_modules/src/sqlite-core/query-builders/select.ts:959:15)
      at then
  (file:///Users/a/Documents/folder/node_modules/src/query-promise.ts:31:15)

Presumably, the new cache module has made it impossible to run any queries on a Durable Object. This error makes it impossible to use.

[AndriiSherman]

fixing it

[AndriiSherman]

fixed locally, preparing the release notes for it and pushing live

[AndriiSherman]

@ezShroom please try 0.44.1

[flashblaze]

I have this DurableObject class

/// <reference types="@cloudflare/workers-types" />
import { DurableObject } from 'cloudflare:workers';
import { type DrizzleSqliteDODatabase, drizzle } from 'drizzle-orm/durable-sqlite';
import { migrate } from 'drizzle-orm/durable-sqlite/migrator';

// @ts-expect-error
import migrations from '../drizzle/migrations/migrations.js';
import type { Env } from './types/hono-env.types';

export class InstaClock extends DurableObject {
  storage: DurableObjectStorage;
  db: DrizzleSqliteDODatabase;

  constructor(ctx: DurableObjectState, env: Env) {
    super(ctx, env);
    this.storage = ctx.storage;
    this.db = drizzle(this.storage, { logger: false });

    ctx.blockConcurrencyWhile(async () => {
      await this.migrate();
    });
  }

  async migrate() {
    try {
      await migrate(this.db, migrations);
    } catch (err) {
      console.log(err);
    }
  }
}

And when I run my migrations, I'm getting this error. I'm on 0.44.1

TransactionRollbackError [DrizzleError]: Rollback
    at _SQLiteDOTransaction.rollback (file:///home/flashblaze/projects/instaclock/node_modules/src/sqlite-core/session.ts:353:9)
    at null.<anonymous> (file:///home/flashblaze/projects/instaclock/node_modules/src/durable-sqlite/migrator.ts:81:7)
    at null.<anonymous> (file:///home/flashblaze/projects/instaclock/node_modules/src/durable-sqlite/session.ts:71:4)
    at SQLiteDOSession.transaction (file:///home/flashblaze/projects/instaclock/node_modules/src/durable-sqlite/session.ts:70:15)
    at DrizzleSqliteDODatabase.transaction (file:///home/flashblaze/projects/instaclock/node_modules/src/sqlite-core/db.ts:593:23)
    at migrate (file:///home/flashblaze/projects/instaclock/node_modules/src/durable-sqlite/migrator.ts:49:5)
    at InstaClock.migrate (file:///home/flashblaze/projects/instaclock/apps/api/src/instaclock.ts:30:13)
    at null.<anonymous> (file:///home/flashblaze/projects/instaclock/apps/api/src/instaclock.ts:24:18) {
  cause: undefined
}

[elginbeloy]

@flashblaze Did you figure TransactionRollbackError [DrizzleError]: Rollback out? I had the exact same error and I fixed it by removing .wrangler/ which stores the SQLite database file. My guess is because the generated CREATE TABLE fails because the table already exists. So effectively removing the existing DB allowed the migrations to run fine (create the table). The question becomes what about already deployed DO workers? For now I added "IF NOT EXISTS" to the migration sql file.

[flashblaze]

@elginbeloy not really. I don't think removing .wrangler would help after deploying to Cloudflare. I'll try the IF NOT EXISTS if I run into this in the future, but I'm removing my DO dependency from my project as of now since it was kind of unnecessary anyways. I'll share an update if I do run into this issue and if I find the solution for the same.