#Importing single table from prod to empty dev table errors

3 messages · Page 1 of 1 (latest)

rustic forge
#

Hello!
I am importing table A from prod to my dev. In dev environment, I have no data in the table A.
However, I get these errors when I run:
Run 1: npx convex import --table tableA path/documents.jsonl (the jsonl was exporting from prod)
Error 1: New table tableA has IDs that conflict with existing table logs
Run 2: npx convex import --table tableA path/documents.jsonl --append
Error 2: _id q575jxdgmxzqz75c7j9hsdsnb173e9gj cannot be imported into 'tableA' because its IDs have a different format

There's no schema change between the 2 tables. How do I resolve this?
Best,

ember cliffBOT
#

Thanks for posting in #1088161997662724167.
Reminder: If you have a Convex Pro account, use the Convex Dashboard to file support tickets.

    - Provide context: What are you trying to achieve, what is the end-user interaction, what are you seeing? (full error message, command output, etc.)
    - Use [search.convex.dev](https://search.convex.dev) to search Docs, Stack, and Discord all at once.
    - Additionally, you can post your questions in the Convex Community's #1228095053885476985 channel to receive a response from AI.
    - Avoid tagging staff unless specifically instructed.

    Thank you!
patent valve
#

yeah this is tricky. the script is trying to be robust to concurrent changes. just because the tables "logs" (in run 1) and "tableA" (in run 2) are empty now, there's no guarantee they will stay empty by the time the import completes. and if they get new documents, then the IDs will have conflicts.

for these cases we recommend doing a single import that overwrites both "tableA" and "logs". can you import a zip file that contains both tables?