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.