Database timeout error | Community
Skip to main content

Database timeout error

  • February 17, 2022
  • 4 replies
  • 0 views
A

Hi!

We are building integration for Zendesk and we face an error trying to List Ticket Comments (https://developer.zendesk.com/api-reference/ticketing/tickets/ticket_comments/#list-comments).

Error is not constant and we don't see any dependencies.
For example, on our staging infrastructure we are unable to get any comments via API.
One our developer does not have any issues accessing from local machine, but other - have it.

Response got from API call: 
{"error":{"message":"Database timeout error","title":"DatabaseError"}}

      4 replies

      C
      Hi Aliaksei,
       
      Can you share the HTTP status code you're receiving with this error response?  Also, are there long response times (30-60 sec) on requests that receive this error?
       
      Best,
      A
      • alexey11
      • Author
      • February 28, 2022

      Hi @christopher53,

      We got 503 status code and response got after 15 seconds (we have our client timeout at 60 seconds).

      Maybe it could be related to pagination, here params we used:
      "page[after]": "eyJvIjoiLWNyZWF0ZWRfYXQsLWlkIiwidiI6IlpLUjFDbUlBQUFBQWFUVW9mcURWQVFBQSJ9"

      "page[size]": "3"

      "sort": "-created_at"

      "sort_by": "created_at"

      "sort_order": "desc"

       

      I think we can provide a full request payload if you need to.

      C
      Thanks for the context.  I've created a ticket for this issue so that we can examine some details specific to your account.  I'll reach out to you with an update through the ticket.
       
      Best,
      I
      • Info19
      • March 1, 2022

      Hi!

      I can confirm that user requested this ticket has all rights to discuss issues within this account.

      Terms & ConditionsCookie settingsAccessibility statement