tursodatabase/turso-cli

"error code 502" when loading from dump with `turso db shell somedb < dump.sql`

kwerdna19 opened this issue · 10 comments

kwerdna19 commented

Hello,

I have a relatively large dump file (about 240MB) and am having trouble executing it on my turso instance with the command turso db shell somedb < dump.sql as (mentioned in the docs here)

The command connects for a second, and then outputs the entire dump file and at the bottom has what looks like a cut-off error message:

...
CREATE UNIQUE INDEX "List_name_key" ON "List"("name");
COMMIT;

error code 502:
andrew@Macbook Desktop %

Not sure Im running up against some limitations here but maybe seeing the full error message would help?

Rather not post the dump here but let me know and I can try to make a generic repro.

Thanks!

haaawk commented

Hi @kwerdna19 Would you be willing to share the dump privately? Any reproducer would do really. Thanks

taine-145 commented

Have the same issue, any solutions as of yet?

nachaos commented

same issue here

haaawk commented

I believe this is related to #735. While I'm fixing the other issue this one might get fixed as well. Will let you know once a new version of CLI with a fix is released.

In the meantime, @nachaos @taine-145 would you be willing to share the sql files that cause the issue for you? I can be here or privately to piotr@turso.tech

taine-145 commented
haaawk commented

Sure will pop you a mail

Thanks @taine-145

nachaos commented

@haaawk I've jut sent the email, thanks for your help 💯

  • 👍1
haaawk commented

turso cli v0.96.3 version has the improvements in that front

  • 🚀1
nachaos commented

Awesome @haaawk! Thank you for the quick response and taking care of this 💯

haaawk commented

You're welcome @nachaos. Let me know if you hit any other problems. If your dump is very big you might see some errors due to transaction taking too long but we will deal with it if you experience the problem.