Errors with transaction
Hi, i've facing a lot of prisma errors with transactions and connection pool.
My environment is:
- PostgreSQL on GCP, connection string parameters: ?connection_limit=50&pool_timeout=20
- Default connection with prisma client.
- 800 connections limit on PostgreSQL
Errors that i'm receveing:
- Invalid
Timed out fetching a new connection from the connection pool. More info: http://pris.ly/d/connection-pool (Current connection pool timeout: 10, connection limit: 3)
- Transaction API error: Transaction already closed: A commit cannot be executed on an expired transaction. The timeout for this transaction was 20000 ms, however 115225 ms passed since the start of the transaction. Consider increasing the interactive transaction timeout or doing less work in the transaction.
My environment is:
- PostgreSQL on GCP, connection string parameters: ?connection_limit=50&pool_timeout=20
- Default connection with prisma client.
- 800 connections limit on PostgreSQL
Errors that i'm receveing:
- Invalid
prisma.machine.findUnique()Timed out fetching a new connection from the connection pool. More info: http://pris.ly/d/connection-pool (Current connection pool timeout: 10, connection limit: 3)
- Transaction API error: Transaction already closed: A commit cannot be executed on an expired transaction. The timeout for this transaction was 20000 ms, however 115225 ms passed since the start of the transaction. Consider increasing the interactive transaction timeout or doing less work in the transaction.
Prisma ORM's query engine creates a connection pool to store and manage database connections.
