Error in Query
I get some errors due to the prepared statement in my code using prisma and the new supabase bouncer:
This is my connection string:
Error occurred during query execution:
ConnectorError(ConnectorError { user_facing_error: None, kind: QueryError(Error { kind: Db, cause: Some(DbError { severity: "ERROR", parsed_severity: Some(Error), code: SqlState(E42P05), message: "prepared statement \"s1\" already exists", detail: None, hint: None, position: None, where_: None, schema: None, table: None, column: None, datatype: None, constraint: None, file: Some("prepare.c"), line: Some(412), routine: Some("StorePreparedStatement") }) }), transient: false })
at pn.handleRequestError (C:\Users\Leonardo\Desktop\discord-dashboard-backend-next\node_modules\@prisma\client\runtime\library.js:176:6649)
at pn.handleAndLogRequestError (C:\Users\Leonardo\Desktop\discord-dashboard-backend-next\node_modules\@prisma\client\runtime\library.js:176:5907)
at pn.request (C:\Users\Leonardo\Desktop\discord-dashboard-backend-next\node_modules\@prisma\client\runtime\library.js:176:5786)
at PrismaService._request (C:\Users\Leonardo\Desktop\discord-dashboard-backend-next\node_modules\@prisma\client\runtime\library.js:179:10484)
at UserController.getUser (C:\Users\Leonardo\Desktop\discord-dashboard-backend-next\src\api\controllers\user.controller.ts:27:16)
at C:\Users\Leonardo\Desktop\discord-dashboard-backend-next\node_modules\@nestjs\core\router\router-execution-context.js:46:28
at C:\Users\Leonardo\Desktop\discord-dashboard-backend-next\node_modules\@nestjs\core\router\router-proxy.js:9:17Error occurred during query execution:
ConnectorError(ConnectorError { user_facing_error: None, kind: QueryError(Error { kind: Db, cause: Some(DbError { severity: "ERROR", parsed_severity: Some(Error), code: SqlState(E42P05), message: "prepared statement \"s1\" already exists", detail: None, hint: None, position: None, where_: None, schema: None, table: None, column: None, datatype: None, constraint: None, file: Some("prepare.c"), line: Some(412), routine: Some("StorePreparedStatement") }) }), transient: false })
at pn.handleRequestError (C:\Users\Leonardo\Desktop\discord-dashboard-backend-next\node_modules\@prisma\client\runtime\library.js:176:6649)
at pn.handleAndLogRequestError (C:\Users\Leonardo\Desktop\discord-dashboard-backend-next\node_modules\@prisma\client\runtime\library.js:176:5907)
at pn.request (C:\Users\Leonardo\Desktop\discord-dashboard-backend-next\node_modules\@prisma\client\runtime\library.js:176:5786)
at PrismaService._request (C:\Users\Leonardo\Desktop\discord-dashboard-backend-next\node_modules\@prisma\client\runtime\library.js:179:10484)
at UserController.getUser (C:\Users\Leonardo\Desktop\discord-dashboard-backend-next\src\api\controllers\user.controller.ts:27:16)
at C:\Users\Leonardo\Desktop\discord-dashboard-backend-next\node_modules\@nestjs\core\router\router-execution-context.js:46:28
at C:\Users\Leonardo\Desktop\discord-dashboard-backend-next\node_modules\@nestjs\core\router\router-proxy.js:9:17This is my connection string:
postgres://postgres.dbaddress:dbpassword@aws-0-us-east-1.pooler.supabase.com:6543/postgrespostgres://postgres.dbaddress:dbpassword@aws-0-us-east-1.pooler.supabase.com:6543/postgres
