Getting intermittent Internal Server Error 500

[jmadison222]

Been pulling lots of data from your very elegant API, but it gets internal server errors with some frequency.

I have been able to narrow this down to a specific API call for troubleshooting. It is below. But with a success (the first one) and a failure (the second one).

I can run this any number of times, and some will work, and some will not.

Any thoughts on a resolution?

All assistance appreciated.

[ Cloud EMR Nonprod: ~/Projects/3pd/osha ] curl -v -H "X-API-KEY: MASKEDMASKEDMASKEDMASKEDMASKEDMASKED" https://data.dol.gov/get/accident_injury/limit/200/offset/200000

• About to connect() to data.dol.gov port 443 (#0)
• Trying 152.180.11.225...
• Connected to data.dol.gov (152.180.11.225) port 443 (#0)
• Initializing NSS with certpath: sql:/etc/pki/nssdb
• CAfile: /etc/pki/tls/certs/ca-bundle.crt
  CApath: none
• SSL connection using TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
• Server certificate:

•   subject: CN=*.dol.gov,O=United States Department of Labor,L=Washington,ST=District of Columbia,C=US
  

•   start date: Apr 10 00:00:00 2020 GMT
  

•   expire date: May 18 12:00:00 2022 GMT
  

•   common name: *.dol.gov
  

•   issuer: CN=DigiCert SHA2 Secure Server CA,O=DigiCert Inc,C=US
  

GET /get/accident_injury/limit/200/offset/200000 HTTP/1.1
User-Agent: curl/7.29.0
Host: data.dol.gov
Accept: /
X-API-KEY: MASKEDMASKEDMASKEDMASKEDMASKEDMASKED

[ Cloud EMR Nonprod: ~/Projects/3pd/osha ] curl -v -H "X-API-KEY: MASKEDMASKEDMASKEDMASKEDMASKEDMASKED" https://data.dol.gov/get/accident_injury/limit/200/offset/200000

• About to connect() to data.dol.gov port 443 (#0)
• Trying 152.180.11.225...
• Connected to data.dol.gov (152.180.11.225) port 443 (#0)
• Initializing NSS with certpath: sql:/etc/pki/nssdb
• CAfile: /etc/pki/tls/certs/ca-bundle.crt
  CApath: none
• SSL connection using TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
• Server certificate:

•   subject: CN=*.dol.gov,O=United States Department of Labor,L=Washington,ST=District of Columbia,C=US
  

•   start date: Apr 10 00:00:00 2020 GMT
  

•   expire date: May 18 12:00:00 2022 GMT
  

•   common name: *.dol.gov
  

•   issuer: CN=DigiCert SHA2 Secure Server CA,O=DigiCert Inc,C=US
  

GET /get/accident_injury/limit/200/offset/200000 HTTP/1.1
User-Agent: curl/7.29.0
Host: data.dol.gov
Accept: /
X-API-KEY: MASKEDMASKEDMASKEDMASKEDMASKEDMASKED

< HTTP/1.1 500 Internal Server Error
< Date: Sat, 26 Dec 2020 21:36:11 GMT
< Server: Apache
< Strict-Transport-Security: max-age=31536000; includeSubDomains; preload
< Public-Key-Pins: pin-sha256="seWTvXI63/67gotn/IfFXAkOWsTRoZ6XbunlIhhuGfA=" pin-sha256="47DEQpj8HBSa+/TImW+5JCeuQeRkm5NMpJWZG3hSuFU="; max-age=5184000; includeSubDomains
< Expires: Thu, 19 Nov 1981 08:52:00 GMT
< Cache-Control: no-store, no-cache, must-revalidate, post-check=0, pre-check=0
< Pragma: no-cache
< Set-Cookie: csrf_cookie_rest=7e8f80284974a4a46d2da6fd3e75f0f8; expires=Sat, 26-Dec-2020 23:36:11 GMT; Max-Age=7200; path=/;HttpOnly;Secure;HttpOnly;Secure;HttpOnly;Secure
< Set-Cookie: rest_session=bc7d40f1559733fa7d9fbd8f036043d5d6d86d24; path=/; HttpOnly;HttpOnly;Secure;HttpOnly;Secure;HttpOnly;Secure
< X-Frame-Options: deny, SAMEORIGIN
< X-XSS-Protection: 1; mode=block
< X-Content-Type-Options: nosniff
< X-WebKit-CSP: default-src 'self'
< X-Permitted-Cross-Domain-Policies: master-only
< Access-Control-Allow-Origin: *
< Content-Length: 0
< Connection: close
< Content-Type: text/html; charset=UTF-8
<

• Closing connection 0

[johng6]

I don't think anyone works here anymore.