Error P6004 -Query did not produce a result within the maximum allowed execution time of 10 seconds
I've only been getting these errors today and it's a relatively small query of 100 rows.
Example request id: 936ecc459e75ced6 or 936e844f69c34595.
Would someone from the Prisma team be able to investigate these request IDs and see if the timeout is due to maybe connection pools or something else?
3 Replies
You decided to hold for human wisdom. We'll chime in soon! Meanwhile,
#ask-ai is there if you need a quick second opinion.Hey Jon 👋
Thank you for sharing the request id.
This happened in Production environment of Project named "SS Azure", right?
I see a few P6004 errors that occurred yesterday.
How was the database load when this error occured? Did you had an increase in traffic?
I see there has been no errors in last 24 hours, so it looks like there was some sporadic issue
The database load remained CPU and memory under 50% the entire time, and there wasn't any difference in traffic compared to a normal day.
@Nurul (Prisma) Is there any further detail you have available in terms of debugging logs? I can't seem much on the portal. I know a timeout could be because there is a lack of connection pools avaialble but I'm unsure how to check that