search

USDA / USDA-APIs

Do you have feedback, ideas, or questions for USDA APIs? Use this repository's Issue Tracker to join the discussion.
www.usda.gov/developer
107 stars 16 forks source link

11-11-2020 . whole day problems with access to fdc via web and API #109

Closed ish-1313 closed 3 years ago

ish-1313 commented 3 years ago

Hi,

today we experience various problems with access to database via api or browser . timeouts, product not found, error during search, bad gateway etc

may be there is some information about estimated time of restoring normal access

tia ish image

ish-1313 commented 3 years ago

calling foods/search

<!DOCTYPE html>\n<html>\n<head>\n<title>Error</title>\n<style>\n body {\n width: 35em;\n margin: 0 auto;\n font-family: Tahoma, Verdana, Arial, sans-serif;\n }\n</style>\n</head>\n<body>\n<h1>An error occurred.</h1>\n<p>Sorry, the page you are looking for is currently unavailable.<br/>\nPlease try again later.</p>\n<p>If you are the system administrator of this resource then you should check\nthe error log for details.</p>\n<p><em>Faithfully yours, nginx.</em></p>\n</body>\n</html>\n

hphungnal commented 3 years ago

@ish-1313 Please try again now. There was a hiccup on one of the servers but it should be resolved now.

ish-1313 commented 3 years ago

@ish-1313 Please try again now. There was a hiccup on one of the servers but it should be resolved now.

seems better .. but some search results returns error on product details loading (never see such errors before today ) few samples

image image image

hphungnal commented 3 years ago

@ish-1313 Apologies for the inconvenience. We had tried to optimize some DB caching and that unfortunately had a side effect on these foods (and some others) not being fetched correctly. The updates have been reverted for now so it should be all good again. I checked all 3 of these foods you pasted and they are working now.

ish-1313 commented 3 years ago

thank you :) dealing with this i understood that search data is enough for me :) closing