Transaction operations are not executing sequentially when using PrismaPlanetScale adapter

I've been working on upgrading our Prisma to v6 and leveraging some of the new features like driver adapters, specifically the

PrismaPlanetScale

PrismaPlanetScale

adapter. After starting to use the

PrismaPlanetScale

PrismaPlanetScale

adapter, I am getting an error when trying to execute multiple related operations in a transaction. For example, the following transaction errors:

await prisma.$transaction([
  prisma.user.create({ data: { id, ... } }),
  prisma.user.update({ where: { id }, data: { ... } })
])

await prisma.$transaction([
  prisma.user.create({ data: { id, ... } }),
  prisma.user.update({ where: { id }, data: { ... } })
])

The error is

An operation failed because it depends on one or more records that were required but not found. No record was found for an update.

An operation failed because it depends on one or more records that were required but not found. No record was found for an update.

Prisma•8mo ago•

2 replies

I've been working on upgrading our Prisma to v6 and leveraging some of the new features like driver adapters, specifically the

PrismaPlanetScale

PrismaPlanetScale

adapter. After starting to use the

PrismaPlanetScale

PrismaPlanetScale

adapter, I am getting an error when trying to execute multiple related operations in a transaction. For example, the following transaction errors:

await prisma.$transaction([
  prisma.user.create({ data: { id, ... } }),
  prisma.user.update({ where: { id }, data: { ... } })
])

await prisma.$transaction([
  prisma.user.create({ data: { id, ... } }),
  prisma.user.update({ where: { id }, data: { ... } })
])

The error is

An operation failed because it depends on one or more records that were required but not found. No record was found for an update.

An operation failed because it depends on one or more records that were required but not found. No record was found for an update.