Authentication error when using connection pooling
I'm trying to use connection pooling with NodeJS, using Prisma.
However, while the default connection works fine, when I try to use pooling I get the following error:
Here are my connection strings:
Am I missing something?
There is this log on logs/pooler:
However, while the default connection works fine, when I try to use pooling I get the following error:
Error in connector: Error querying the database: FATAL: Authentication errorError in connector: Error querying the database: FATAL: Authentication errorHere are my connection strings:
DATABASE_URI="postgres://postgres:[PASSWORD]@db.[ID].supabase.co:5432/postgres"
POOL_DATABASE_URI="postgres://postgres.[ID]:[PASSWORD]@aws-0-eu-central-1.pooler.supabase.com:6543/postgres"DATABASE_URI="postgres://postgres:[PASSWORD]@db.[ID].supabase.co:5432/postgres"
POOL_DATABASE_URI="postgres://postgres.[ID]:[PASSWORD]@aws-0-eu-central-1.pooler.supabase.com:6543/postgres"Am I missing something?
There is this log on logs/pooler:
Authentication auth_secrets error: "Authentication query failed: %DBConnection.ConnectionError{message: \"connection not available and request was dropped from queue after 2000ms. This means requests are coming in and your connection pool cannot serve them fast enough. You can address this by:\\n\\n 1. Ensuring your database is available and that you can connect to it\\n 2. Tracking down slow queries and making sure they are running fast enough\\n 3. Increasing the pool_size (although this increases resource consumption)\\n 4. Allowing requests to wait longer by increasing :queue_target and :queue_interval\\n\\nSee DBConnection.start_link/2 for more information\\n\", severity: :error, reason: :queue_timeout}"Authentication auth_secrets error: "Authentication query failed: %DBConnection.ConnectionError{message: \"connection not available and request was dropped from queue after 2000ms. This means requests are coming in and your connection pool cannot serve them fast enough. You can address this by:\\n\\n 1. Ensuring your database is available and that you can connect to it\\n 2. Tracking down slow queries and making sure they are running fast enough\\n 3. Increasing the pool_size (although this increases resource consumption)\\n 4. Allowing requests to wait longer by increasing :queue_target and :queue_interval\\n\\nSee DBConnection.start_link/2 for more information\\n\", severity: :error, reason: :queue_timeout}"