duck
PPrisma
•Created by duck on 9/18/2024 in #help-and-questions
RawSQL Caching support
Will Prisma Accelerate ever support caching for complete rawSQL?
Is there pros and cons of this?
3 replies
PPrisma
•Created by duck on 8/18/2024 in #help-and-questions
Inconsistency in not generating prepared statements when using Prisma Accelerate
Hello,
I am connecting to our Supabase Supavisor Transactional Connection Pooler using the appropriate connection url ending with pgbouncer true, connection limit 1.
My backend is hosted using Cloudflare Workers serverless using hono.js and REST api.
I am experiencing inconsistences when using Prisma to call our database, requiring refresh of our supabase database around every 24 hours to solve the issue. The issue occurs intermitenntly throughougt the day (every 200 or so requests maybe 1 error), but after 24 hours, the whole thing breaks completely and will not work until the database server restart is performed. The error can also be solved after refreshing about like 40 times, it will work again for a few tries, then will break again.
It seems like others have experienced this issue. I am posting this after refreshing our server so i can't provide images of error just yet, but the errors are all "prepared statement already exists" with a number that grows.
Thanks for the help, very appreciated
Jason
Edit:
An alternate thread with the same issue https://discord.com/channels/937751382725886062/1270035810791723039/1270035810791723039
5 replies