quaint icon indicating copy to clipboard operation
quaint copied to clipboard

Discard Connection after aborted Transaction

Open do4gr opened this issue 5 years ago • 1 comments

Here we introduced a transaction around DDL operations in order to abort invalid enum migrations. https://github.com/prisma/prisma-engines/pull/1016

When the transaction fails without an explicit rollback being submitted next, the following statement will reuse the same connection and error. See here: https://stackoverflow.com/questions/10399727/psqlexception-current-transaction-is-aborted-commands-ignored-until-end-of-tra

We should look into how Quaint could handle this case.

do4gr avatar Aug 13 '20 13:08 do4gr

I think I'm hitting this very problem right now. I thought either the PooledConnection or the transaction would be handled with Drop ?

Any idea how to guarantee a correct cleanup?

docteurklein avatar Dec 03 '22 16:12 docteurklein