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

[kwerdna19]

trafficstars

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]

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

[taine-145]

Have the same issue, any solutions as of yet?

[nachaos]

same issue here

[haaawk]

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 [email protected]

[taine-145]

Sure will pop you a mail

On Sat, 20 Jul 2024 at 14:36, Piotr Jastrzębski @.***> wrote:

I believe this is related to #735 https://github.com/tursodatabase/turso-cli/issues/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 https://github.com/nachaos @taine-145 https://github.com/taine-145 would you be willing to share the sql files that cause the issue for you? I can be here or privately to @.***

— Reply to this email directly, view it on GitHub https://github.com/tursodatabase/turso-cli/issues/839#issuecomment-2241139504, or unsubscribe https://github.com/notifications/unsubscribe-auth/AF5SFX7NW5WJUYE7ULPJ6IDZNJKWTAVCNFSM6AAAAABGAJKXR2VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDENBRGEZTSNJQGQ . You are receiving this because you were mentioned.Message ID: @.***>

[haaawk]

Sure will pop you a mail

Thanks @taine-145

[nachaos]

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

[haaawk]

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

[nachaos]

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

[haaawk]

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.