TiTiler Search Registration returning Internal Server Error 500

[rohansaw]

Note: This repository contains a reference implementation; as such, bugs in deployment or usage of this project in other environments besides the Microsoft Planetary Computer have no guarantees of support. See SUPPORT.md for more information.

Describe the bug
I am using the Planetary Computer data API to visualize Sentinel-2 Data. When I register my search, I have seen a few cases where a 500 Internal Server Error is thrown sometimes, however not always...

It seems to be related to doing multiple requests. As I am trying to visualize data at 24 different timepoints I am doing 24 registration requests.

When I am doing a single requests (see example below), this typically works fine. However, once i do multiple this causes a 500 to be thrown. This also happens if I do the same request a few times in a row.

To reproduce
POST-Request to https://planetarycomputer.microsoft.com/api/data/v1/mosaic/register

body:

{"bbox":[0.17578125,5.834616165610059,1.7138671875000002,10.31491928581316],"filter":{"op":"and","args":[{"op":"anyinteracts","args":[{"property":"datetime"},{"interval":["20210301","20210308"]}]},{"op":"<=","args":[{"property":"eo:cloud_cover"},70]},{"op":"=","args":[{"property":"collection"},"sentinel-2-l2a"]}]},"metadata":{"type":"mosaic","maxzoom":24,"minzoom":0,"pixel_selection":"median"},"filterLang":"cql2-json","collections":["sentinel-2-l2a"]}

If not throwing a 500 error yet, hit enter a few times in a row and it will likely throw the error.

Edit: Sometimes it also throws a 504 Gateway Time-out.

Expected behavior
Return the expected data from the endpoint.

[vincentsarago]

I can confirm.

To me this feels like a PgSTAC issue, there might be something going on with the searches table

cc @bitnerd

[lukesdm]

We're also having trouble accessing Sentinel-2 (at least) data - simple get requests are failing.
https://planetarycomputer.microsoft.com/api/stac/v1/collections/sentinel-2-l2a works
https://planetarycomputer.microsoft.com/api/stac/v1/collections/sentinel-2-l2a/items doesn't.

[TaylorCorbett]

Apologies for the disruption. Overnight the Planetary Computer saw a significant increase in STAC API request volume which resulted in timeouts for many users.

We’ve since updated firewall and database configurations to mitigate the issue and minimize further disruptions. The Planetary Computer’s APIs appear to be functioning normally now, but if you encounter any additional issues, please let us know.