3 replies

Transaction rollback error catching

I'm using drizzle with TRPC and want my api to give detailed reasons for a rollback. However

tx.rollback()

tx.rollback()

throws a

TransactionRollbackError

TransactionRollbackError

, which means the TRPC error is never thrown (i think). This means the client sees an error with message "Rollback", which isn't super descriptive.

await db.transaction(async (tx) => {
  ...some logic
  if (logicFails) {
    tx.rollback();
    throw new TRPCError({ code: "CONFLICT", message: "Detailed reason..." });
  }
});

await db.transaction(async (tx) => {
  ...some logic
  if (logicFails) {
    tx.rollback();
    throw new TRPCError({ code: "CONFLICT", message: "Detailed reason..." });
  }
});

Is it safe to catch the drizzle error inside of the transaction and throw a TRPC one instead? Im guessing so but just wanted to check.

await db.transaction(async (tx) => {
  ...some logic
  if (logicFails) {
    try {
      tx.rollback();
    } catch (e) { };
    throw new TRPCError({ code: "CONFLICT", message: "Detailed reason..." });
  }
});

await db.transaction(async (tx) => {
  ...some logic
  if (logicFails) {
    try {
      tx.rollback();
    } catch (e) { };
    throw new TRPCError({ code: "CONFLICT", message: "Detailed reason..." });
  }
});

Drizzle Team•3y ago•

3 replies

IceAge2OnDVD

Transaction rollback error catching

I'm using drizzle with TRPC and want my api to give detailed reasons for a rollback. However

tx.rollback()

tx.rollback()

throws a

TransactionRollbackError

TransactionRollbackError

, which means the TRPC error is never thrown (i think). This means the client sees an error with message "Rollback", which isn't super descriptive.

await db.transaction(async (tx) => {
  ...some logic
  if (logicFails) {
    tx.rollback();
    throw new TRPCError({ code: "CONFLICT", message: "Detailed reason..." });
  }
});

await db.transaction(async (tx) => {
  ...some logic
  if (logicFails) {
    tx.rollback();
    throw new TRPCError({ code: "CONFLICT", message: "Detailed reason..." });
  }
});

Is it safe to catch the drizzle error inside of the transaction and throw a TRPC one instead? Im guessing so but just wanted to check.

await db.transaction(async (tx) => {
  ...some logic
  if (logicFails) {
    try {
      tx.rollback();
    } catch (e) { };
    throw new TRPCError({ code: "CONFLICT", message: "Detailed reason..." });
  }
});

await db.transaction(async (tx) => {
  ...some logic
  if (logicFails) {
    try {
      tx.rollback();
    } catch (e) { };
    throw new TRPCError({ code: "CONFLICT", message: "Detailed reason..." });
  }
});

Transaction rollback error catching

Similar Threads

Transaction rollback error catching

Similar Threads

Similar Threads

Similar Threads