Can't Work with Queues and D1 in the same project

Queues will not work when running
wrangler dev
as they are only supported with the
--local
command. Unfortunately, D1 does not seem to work correctly locally when using workers-qb as the following error always is thrown when running workers-qb locally but not when running remote.

Error: D1_ERROR
    at D1Database._send (/Users/brayden/code/dd/rollcall-cloudflare/node_modules/.pnpm/@miniflare+d1@2.12.0/node_modules/@miniflare/d1/src/d1js.ts:148:13)
    at D1PreparedStatement.all (/Users/brayden/code/dd/rollcall-cloudflare/node_modules/.pnpm/@miniflare+d1@2.12.0/node_modules/@miniflare/d1/src/d1js.ts:242:7)
    ... 3 lines matching cause stack trace ...
    at Server.<anonymous> (/Users/brayden/code/dd/rollcall-cloudflare/node_modules/.pnpm/@miniflare+http-server@2.12.0/node_modules/@miniflare/http-server/src/index.ts:307:20) {
  [cause]: Error: Error: RangeError: Too many parameter values were provided
      at D1Database._send (/Users/brayden/code/dd/rollcall-cloudflare/node_modules/.pnpm/@miniflare+d1@2.12.0/node_modules/@miniflare/d1/src/d1js.ts:149:16)
      at D1PreparedStatement.all (/Users/brayden/code/dd/rollcall-cloudflare/node_modules/.pnpm/@miniflare+d1@2.12.0/node_modules/@miniflare/d1/src/d1js.ts:242:7)
      at RegisterHandler (/Users/brayden/code/dd/rollcall-cloudflare/src/handlers/registerHandler.ts:29:21)
      at Object.handle (/Users/brayden/code/dd/rollcall-cloudflare/node_modules/.pnpm/itty-router@3.0.11/node_modules/itty-router/dist/itty-router.mjs:1:638)
      at ServiceWorkerGlobalScope.[kDispatchFetch] (/Users/brayden/code/dd/rollcall-cloudflare/node_modules/.pnpm/@miniflare+core@2.12.0/node_modules/@miniflare/core/src/standards/event.ts:385:13)
Was this page helpful?