Transaction rollback

sessionId = await db.transaction(async (tx) => {
      const [{insertedSessionId}] = await tx
        .insert(session)
        .values({
          auctionid: values.auctionId,
          auctiondate: values.auctionDate,
          sessiondate: values.previewDate,
        })
        .returning({insertedSessionId: session.sessionid});
      await tx.insert(customersession).values({
        sessionid: insertedSessionId,
        customerid: values.customerId,
        isclone: false,
      });
      return insertedSessionId;
    });