Skip to content

[BUG]: Stack overflow when trying to insert many values at once #2628

@etareduction

Description

@etareduction

What version of drizzle-orm are you using?

0.31.4

What version of drizzle-kit are you using?

0.22.8

Describe the Bug

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)

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

Expected behavior

Expected drizzle to correctly construct query string and send it to postgres

Environment & setup

Nextjs app, both development and production.

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions