Prisma limit blocking full export of base

Teable Discussions
1

:cross_mark: Base exported failed:
Invalid `prisma.attachmentsTable.findMany()` invocation:

Transaction API error: Transaction already closed: A query cannot be executed on an expired transaction. The timeout for this transaction was 600000 ms, however 632677 ms passed since the start of the transaction. Consider increasing the interactive transaction timeout or doing less work in the transaction.

I also filed a bug for this on Github;

Tuning of PRISMA_TRANSACTION_TIMEOUT in the .env file does not work around this internal limit.

2

For exporting a base, try setting BIG_TRANSACTION_TIMEOUT in your env and restarting the service.

Let me know how it goes.

3

That worked, thank you!

4

Pull request put in a few days ago, I just forgot to add it here too…

7

Thanks for the PR! We’ll take a look. :folded_hands: