Cloudflare Developers•2y ago

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/@[email protected]/node_modules/@miniflare/d1/src/d1js.ts:148:13)
    at D1PreparedStatement.all (/Users/brayden/code/dd/rollcall-cloudflare/node_modules/.pnpm/@[email protected]/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/@[email protected]/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/@[email protected]/node_modules/@miniflare/d1/src/d1js.ts:149:16)
      at D1PreparedStatement.all (/Users/brayden/code/dd/rollcall-cloudflare/node_modules/.pnpm/@[email protected]/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/[email protected]/node_modules/itty-router/dist/itty-router.mjs:1:638)
      at ServiceWorkerGlobalScope.[kDispatchFetch] (/Users/brayden/code/dd/rollcall-cloudflare/node_modules/.pnpm/@[email protected]/node_modules/@miniflare/core/src/standards/event.ts:385:13)

Error: D1_ERROR
    at D1Database._send (/Users/brayden/code/dd/rollcall-cloudflare/node_modules/.pnpm/@[email protected]/node_modules/@miniflare/d1/src/d1js.ts:148:13)
    at D1PreparedStatement.all (/Users/brayden/code/dd/rollcall-cloudflare/node_modules/.pnpm/@[email protected]/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/@[email protected]/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/@[email protected]/node_modules/@miniflare/d1/src/d1js.ts:149:16)
      at D1PreparedStatement.all (/Users/brayden/code/dd/rollcall-cloudflare/node_modules/.pnpm/@[email protected]/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/[email protected]/node_modules/itty-router/dist/itty-router.mjs:1:638)
      at ServiceWorkerGlobalScope.[kDispatchFetch] (/Users/brayden/code/dd/rollcall-cloudflare/node_modules/.pnpm/@[email protected]/node_modules/@miniflare/core/src/standards/event.ts:385:13)

1 Reply

JavaDad•2y ago

Ill open this issue with workers-qb, this is good to know, thank you! cc @massadas

Gaming

Programming

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