GamerZero Posts - Answer Overflow

GamerZero

Explore posts from servers

TtRPC TTCTheo's Typesafe Cult DTDrizzle Team

•Created by GamerZero on 7/14/2024 in #help

Stack overflow when trying to insert many values at once

I'm using drizzle with nextjs so the code is chunked into separate bundles by nextjs it seems, but there are mentions of SQL in the stacktrace and i'm not using any ORM other than drizzle in my project. Here's my code:

await db.insert(table).values(largeListOfValues)

await db.insert(table).values(largeListOfValues)

where largeListOfValues.length is around 30000-40000 entries 5 columns each. And the error:

RangeError: Maximum call stack size exceeded
    at /app/.next/server/chunks/662.js:7:27038
    at g.buildQueryFromSourceParams (/app/.next/server/chunks/662.js:7:27141)
    at /app/.next/server/chunks/662.js:7:26566
    at Object.startActiveSpan (/app/.next/server/chunks/662.js:7:32523)
    at g.toQuery (/app/.next/server/chunks/662.js:7:26516)
    at C.sqlToQuery (/app/.next/server/chunks/662.js:7:7089)
    at /app/.next/server/chunks/662.js:1:45521
    at Object.startActiveSpan (/app/.next/server/chunks/662.js:7:32523)
    at QueryPromise._prepare (/app/.next/server/chunks/662.js:1:45439)
    at /app/.next/server/chunks/662.js:1:45671

RangeError: Maximum call stack size exceeded
    at /app/.next/server/chunks/662.js:7:27038
    at g.buildQueryFromSourceParams (/app/.next/server/chunks/662.js:7:27141)
    at /app/.next/server/chunks/662.js:7:26566
    at Object.startActiveSpan (/app/.next/server/chunks/662.js:7:32523)
    at g.toQuery (/app/.next/server/chunks/662.js:7:26516)
    at C.sqlToQuery (/app/.next/server/chunks/662.js:7:7089)
    at /app/.next/server/chunks/662.js:1:45521
    at Object.startActiveSpan (/app/.next/server/chunks/662.js:7:32523)
    at QueryPromise._prepare (/app/.next/server/chunks/662.js:1:45439)
    at /app/.next/server/chunks/662.js:1:45671

4 replies

Gaming

Programming