Skip to content

DB errors when using Prisma2 with pgBouncer connection pools #556

@iherger

Description

@iherger

I am trying out pgBouncer connection pools (transaction mode) on managed Postgresql on DigitalOcean.

I am getting errors similar to:

[GraphQL error]: Message: Error in Photonselect,user: 
Error: Reason: Error in connector: Error querying the database: db error: ERROR: prepared statement "s667" already exists

This occurs only with connection pooling, not with direct db connections.

The errors occur under the following conditions:

  • with versions[email protected] as well as latest alpha
  • with deployments of the GraphQL server both on zeit-now and locally
  • with Prisma2 starter project (GraphQL starter), when running yarn seed

Easiest way to reproduce:

  • set up a managed postgresql db on DigitalOcean
  • prisma2 init simple typescript GraphQL starter
  • run yarn seed

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions