You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I'm encountering an issue in one of my write-heavy applications when writing into Planetscale (MySQL). I'm getting the error: sql: expected 28556 arguments, got 290700. Interestingly, the inserts work correctly when the number of rows is smaller.
Is there a known issue with scaling up inserts, such as an upper boundary where this breaks?
I'm using bulk insert with tx.NamedExec() and passing in a struct slice (no pointers). The struct has around 15 fields. If anyone has ideas about the root cause (whether it's database/sql, github.com/go-sql-driver/mysql, Planetscale limitations, or a missing MySQL setting), I would appreciate any suggestions.
The text was updated successfully, but these errors were encountered:
Can you post a code sample? A mismatch likely indicates an error in the logic rather than a limit that's being exceeded. I've experienced something similar in Django with a bad JOIN that caused a column mismatch.
I'm encountering an issue in one of my write-heavy applications when writing into Planetscale (MySQL). I'm getting the error: sql: expected 28556 arguments, got 290700. Interestingly, the inserts work correctly when the number of rows is smaller.
Is there a known issue with scaling up inserts, such as an upper boundary where this breaks?
I'm using bulk insert with tx.NamedExec() and passing in a struct slice (no pointers). The struct has around 15 fields. If anyone has ideas about the root cause (whether it's database/sql, github.com/go-sql-driver/mysql, Planetscale limitations, or a missing MySQL setting), I would appreciate any suggestions.
The text was updated successfully, but these errors were encountered: