PrismaClientInitializationError

[Priyanshu1112]

I am using prisma + supabase in my next.js project and have ran into a problem

{
msg: '\n' +
'Invalid prisma.user.findUnique() invocation:\n' +
'\n' +
'\n' +
'Error querying the database: FATAL: Authentication error, reason: "Authentication query failed: %Postgrex.Error{message: nil, postgres: %{code: :undefined_function, file: \"parse_func.c\", hint: \"No function matches the given name and argument types. You might need to add explicit type casts.\", line: \"629\", message: \"function pgbouncer.get_auth(unknown) does not exist\", pg_code: \"42883\", position: \"15\", routine: \"ParseFuncOrColumn\", severity: \"ERROR\", unknown: \"ERROR\"}, connection_id: 2186132, query: \"SELECT * FROM pgbouncer.get_auth($1)\"}"',
cause: undefined,
name: 'PrismaClientInitializationError'
}

there is no function in pgbouncer called get_auth
and I am also not able to create it due to permission issue

please any aid would be very helpful

[GaryAustin1]

Than function exists an instances normally. Wonder if Prisma wiped the schema during a migration?
So far the only solution I've seen is to contact support.

[GaryAustin1]

https://github.com/orgs/supabase/discussions/30044

[Priyanshu1112]

Thanks gary, I already have reached them out but then received : "Free plan will receive no guaranteed support response" in the response