[BUG] - Importing consolidated.csv fails with 500 error

[ngAlexander9]

Describe the bug

When attempting to import consolidated.csv using Import PVs, the PVs are parsed, but import fails. No rows are added.

Expected behavior

Import succeeds, newly imported PVs populate table after a Javascript popup message of successful import.

Steps to Reproduce

1. Clone react-squirrel and react-squirrel-backend.
2. Set up .env, run docker compose up --build -d to get backend to running state with empty db
3. pnpm dev to get frontend to running state
4. In Import PVs, select consolidated.csv. 36k rows load in after some time.
5. Click Import 36k PVs, 500 error code returned.

Possible solution (optional)

It's probably the duplicate key handling, not the size of the file. Smaller files pass, even a truncated (first 5.7k rows) file worked.

My platform

No response

Additional context

No response