[BUG]: Transaction Rollback throws TransactionRollbackError

[iabdulhannan]

What version of drizzle-orm are you using?

0.27.2

What version of drizzle-kit are you using?

0.19.13

Describe the Bug

await conn.transaction(async (tx) => { try { some query fails and throws an Exception } catch (e) { tx.rollback() } })

Output:
TransactionRollbackError [DrizzleError]: Rollback
at PostgresJsTransaction.rollback (webpack-internal:///(rsc)/./node_modules/drizzle-orm/session-2062e9e6.mjs:432:15)
at eval (webpack-internal:///(rsc)/./src/app/api/projectManager/initializeProject/route.ts:53:38)
at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
at async scope (webpack-internal:///(rsc)/./node_modules/postgres/src/index.js:208:26)
at async Function.begin (webpack-internal:///(rsc)/./node_modules/postgres/src/index.js:198:20)
at async POST (webpack-internal:///(rsc)/./src/app/api/projectManager/initializeProject/route.ts:30:21)
at async /Users/abdulhannan/Work/Personal/FUI/cdre/node_modules/next/dist/compiled/next-server/app-route.runtime.dev.js:6:61466

Expected behavior

Transaction must be rolled back

Environment & setup

"next": "latest",
"drizzle-orm": "^0.27.2",
"drizzle-kit": "^0.19.13",
"postgres": "^3.3.5",

[dankochetov]

tx.rollback() throws a TransactionRollbackError by design, you can catch and ignore it. Though it makes me think it might make sense to not throw an error if you rollback manually.

[iabdulhannan]

@dankochetov tx.rollback() is also not undoing the changes made to database inside transaction.

[Angelelz]

@dankochetov tx.rollback() is also not undoing the changes made to database inside transaction.

That would be a bug. Can you put together a reproduction repo to investigate?

[iabdulhannan]

Hey! @dankochetov Thank you for your time and attention. I solved the issue while creating a reproduction repo. Turns out there was some problem with the way I used it. However, it would be good idea to not throw an Exception on Rollback. Instead, a simple message would be good.

[nonua]

Hi @iabdulhannan, could you please explain how this was fixed? I have the same issue you are describing where rollback does not undo the changes I made. Please see this discussion

[iabdulhannan]

Hi @nonua
Sorry I was away for some days and couldn't get to you in time. I just noticed your mention in this issue, and I'm glad to hear that your issue has been resolved. If you have any more questions or need assistance with anything else in the future, please don't hesitate to reach out.