Averages endpoint returns error 500, when using temporal as parameter #321
Assignees
Labels
bug
Something isn't working
Comments
|
Hi @MauriceHeinze Thanks for reporting this issue. We'll take a look and try to get this resolved. |
caparker
added a commit
that referenced
this issue
Jan 9, 2024
The averages endpoint was passing a config value but unassigned and it was therefor being passed as the timeout value. I added a check in the db to make sure we are protected from that as well as updated the averages endpoint to explicitly name the config argument.
Merged
russbiggs
added a commit
that referenced
this issue
Jan 9, 2024
--------- Co-authored-by: Christian Parker <c.andrew.parker@gmail.com> * Bad timeout value passed to db class (#321) The averages endpoint was passing a config value but unassigned and it was therefor being passed as the timeout value. I added a check in the db to make sure we are protected from that as well as updated the averages endpoint to explicitly name the config argument. fixes #321 --------- Co-authored-by: Christian Parker <c.andrew.parker@gmail.com>
|
@MauriceHeinze This issue should be resolved in today's release. |
caparker
added a commit
that referenced
this issue
Jun 4, 2024
* hot-fix resolve auth issues * add redis in startup event hook * Release 20230927 (#291) * Added ability to increase the working memory for a given endpoint (#282) resolves #281 * Added ability to increase the working memory for a given endpoint resolves #281 * update staging deploy to deploy on release branches (#284) * Added timer (#280) * included order_by in v1 and v2 measurements (#263) Co-authored-by: Gabriel Fosse <kraken+majesticio@users.noreply.github.com> * manufacturers resource (#273) * manufacturers resource resolves #252 --------- Co-authored-by: Gabriel Fosse <kraken+majesticio@users.noreply.github.com> * Adding `v3/instruments` resource (#271) * instruments resource resolves #270 --------- Co-authored-by: Gabriel Fosse <kraken+majesticio@users.noreply.github.com> * Added timer * Added owner router --------- Co-authored-by: Gabriel Fosse <67290377+majesticio@users.noreply.github.com> Co-authored-by: Gabriel Fosse <kraken+majesticio@users.noreply.github.com> Co-authored-by: Russ Biggs <russbiggs@gmail.com> * Add sort and order by query params to v3 endpoints (#285) * order by classes * refactor query builder to handle sort and order by statements * add sort and order by to v3 endpoints resolves #163 --------- Co-authored-by: Gabriel Fosse <kraken+majesticio@users.noreply.github.com> * Feature/working memory query 281 (#287) * Moved the tr.start out of if block Fixes bug #286 --------- Co-authored-by: Christian Parker <c.andrew.parker@gmail.com> * fix missing start variable and return empty string for order (#288) * Remove count fields (#289) * removed count fields --------- Co-authored-by: Gabriel Fosse <kraken+majesticio@users.noreply.github.com> * fix failing unit test (#292) * rate limiter logging fix (#293) * remove summary count fields from v3 countries (#294) * removed locations_count from instruments.py query --------- Co-authored-by: Christian Parker <c.andrew.parker@gmail.com> Co-authored-by: Gabriel Fosse <67290377+majesticio@users.noreply.github.com> Co-authored-by: Gabriel Fosse <kraken+majesticio@users.noreply.github.com> * revert to old startup and shutdown events (#296) * add redis client to app state (#299) * fixed parameters query param for locations, countries, and providers (#306) (#308) * fixed parameters query param for locations, countries and providers * Made requested changes to implement ParametersQuery --------- Co-authored-by: Gabriel Fosse <67290377+majesticio@users.noreply.github.com> Co-authored-by: Gabriel Fosse <kraken+majesticio@users.noreply.github.com> * add tiles parameter query (#310) * Update test_v3_queries.py file to use the array overlap operator instead of the equality operator. (#312) Co-authored-by: Gabriel Fosse <kraken+majesticio@users.noreply.github.com> * Fix/statement timeout (#316) * Fix/v2 measurements source (#314) * fix v2 measurements to query measurements table instead of hourly * realias to match query params * measurements geom fix * Added sensors_id to speed up sorting * update statement_timeout to milliseconds --------- Co-authored-by: Russ Biggs <russbiggs@gmail.com> * set statement_timeout default config value --------- Co-authored-by: Christian Parker <c.andrew.parker@gmail.com> * Release 20231222 (#318) * Fix/v2 measurements source (#314) * fix v2 measurements to query measurements table instead of hourly * realias to match query params * measurements geom fix * Added sensors_id to speed up sorting * update statement_timeout to milliseconds --------- Co-authored-by: Russ Biggs <russbiggs@gmail.com> * ratelimit headers (#315) * ratelimit headers * dynamic ratelimt-policy values * Added wait_for method (#317) --------- Co-authored-by: Christian Parker <c.andrew.parker@gmail.com> * Release 20240104 (#320) * Fix/v2 measurements source (#314) * fix v2 measurements to query measurements table instead of hourly * realias to match query params * measurements geom fix * Added sensors_id to speed up sorting * update statement_timeout to milliseconds --------- Co-authored-by: Russ Biggs <russbiggs@gmail.com> * ratelimit headers (#315) * ratelimit headers * dynamic ratelimt-policy values * Fix/statement timeout (#316) * Fix/v2 measurements source (#314) * fix v2 measurements to query measurements table instead of hourly * realias to match query params * measurements geom fix * Added sensors_id to speed up sorting * update statement_timeout to milliseconds --------- Co-authored-by: Russ Biggs <russbiggs@gmail.com> * set statement_timeout default config value --------- Co-authored-by: Christian Parker <c.andrew.parker@gmail.com> * Added wait_for method (#317) * update default date for date_form --------- Co-authored-by: Christian Parker <c.andrew.parker@gmail.com> * Release 20240109 (#324) * add hint to 408 timeout error (#322) * Fix/bad timeout value (#323) --------- Co-authored-by: Christian Parker <c.andrew.parker@gmail.com> * Bad timeout value passed to db class (#321) The averages endpoint was passing a config value but unassigned and it was therefor being passed as the timeout value. I added a check in the db to make sure we are protected from that as well as updated the averages endpoint to explicitly name the config argument. fixes #321 --------- Co-authored-by: Christian Parker <c.andrew.parker@gmail.com> --------- Co-authored-by: Christian Parker <c.andrew.parker@gmail.com> * Readme redis update (#327) * readme updates * readme typo * Release 20240207 (#331) * Feature/ratelimiter update (#330) * updated request_is_limited algorithm * Strip out numbers from paths This is so we can better aggregate by path in cloudwatch --------- Co-authored-by: Christian Parker <c.andrew.parker@gmail.com> * update key setting for ratelimiting * Release 20240210 (#334) * Provide numeric value for dates for easier analysis later (#332) * Feature/ratelimiter update (#330) * updated request_is_limited algorithm * Strip out numbers from paths This is so we can better aggregate by path in cloudwatch * Provide numeric value for dates for easier analysis later --------- Co-authored-by: Russ Biggs <russbiggs@gmail.com> * Sensors by location (#297) * Added ability to increase the working memory for a given endpoint (#282) resolves #281 * Added ability to increase the working memory for a given endpoint resolves #281 * update staging deploy to deploy on release branches (#284) * Added timer (#280) * included order_by in v1 and v2 measurements (#263) Co-authored-by: Gabriel Fosse <kraken+majesticio@users.noreply.github.com> * manufacturers resource (#273) * manufacturers resource resolves #252 --------- Co-authored-by: Gabriel Fosse <kraken+majesticio@users.noreply.github.com> * Adding `v3/instruments` resource (#271) * instruments resource resolves #270 --------- Co-authored-by: Gabriel Fosse <kraken+majesticio@users.noreply.github.com> * Added timer * Added owner router --------- Co-authored-by: Gabriel Fosse <67290377+majesticio@users.noreply.github.com> Co-authored-by: Gabriel Fosse <kraken+majesticio@users.noreply.github.com> Co-authored-by: Russ Biggs <russbiggs@gmail.com> * Add sort and order by query params to v3 endpoints (#285) * order by classes * refactor query builder to handle sort and order by statements * add sort and order by to v3 endpoints resolves #163 --------- Co-authored-by: Gabriel Fosse <kraken+majesticio@users.noreply.github.com> * Feature/working memory query 281 (#287) * Moved the tr.start out of if block Fixes bug #286 --------- Co-authored-by: Christian Parker <c.andrew.parker@gmail.com> * fix missing start variable and return empty string for order (#288) * Remove count fields (#289) * removed count fields --------- Co-authored-by: Gabriel Fosse <kraken+majesticio@users.noreply.github.com> * fix failing unit test (#292) * rate limiter logging fix (#293) * location sensors query * location sensors path query * Cleaned up the sensors endpoints Rewrote the queries to speed them up a litte and added the measurements method * Removed old method that I had renamed --------- Co-authored-by: Christian Parker <c.andrew.parker@gmail.com> Co-authored-by: Russ Biggs <russbiggs@gmail.com> Co-authored-by: Gabriel Fosse <kraken+majesticio@users.noreply.github.com> * add deprecation warning (#333) * upgrdate to actions/checkout@v4 --------- Co-authored-by: Christian Parker <c.andrew.parker@gmail.com> Co-authored-by: Gabriel Fosse <67290377+majesticio@users.noreply.github.com> Co-authored-by: Gabriel Fosse <kraken+majesticio@users.noreply.github.com> * Release 20240214 (#338) * Feature/merge trends and measurements (#336) * Fix/statement timeout (#316) * Fix/v2 measurements source (#314) * fix v2 measurements to query measurements table instead of hourly * realias to match query params * measurements geom fix * Added sensors_id to speed up sorting * update statement_timeout to milliseconds --------- Co-authored-by: Russ Biggs <russbiggs@gmail.com> * set statement_timeout default config value --------- Co-authored-by: Christian Parker <c.andrew.parker@gmail.com> * Release 20231222 (#318) * Fix/v2 measurements source (#314) * fix v2 measurements to query measurements table instead of hourly * realias to match query params * measurements geom fix * Added sensors_id to speed up sorting * update statement_timeout to milliseconds --------- Co-authored-by: Russ Biggs <russbiggs@gmail.com> * ratelimit headers (#315) * ratelimit headers * dynamic ratelimt-policy values * Added wait_for method (#317) --------- Co-authored-by: Christian Parker <c.andrew.parker@gmail.com> * Added the trends methods (dow, hod, moy) to the measurements --------- Co-authored-by: Russ Biggs <russbiggs@gmail.com> * Feature/add license to location (#337) * Fix/statement timeout (#316) * Fix/v2 measurements source (#314) * fix v2 measurements to query measurements table instead of hourly * realias to match query params * measurements geom fix * Added sensors_id to speed up sorting * update statement_timeout to milliseconds --------- Co-authored-by: Russ Biggs <russbiggs@gmail.com> * set statement_timeout default config value --------- Co-authored-by: Christian Parker <c.andrew.parker@gmail.com> * Release 20231222 (#318) * Fix/v2 measurements source (#314) * fix v2 measurements to query measurements table instead of hourly * realias to match query params * measurements geom fix * Added sensors_id to speed up sorting * update statement_timeout to milliseconds --------- Co-authored-by: Russ Biggs <russbiggs@gmail.com> * ratelimit headers (#315) * ratelimit headers * dynamic ratelimt-policy values * Added wait_for method (#317) --------- Co-authored-by: Christian Parker <c.andrew.parker@gmail.com> * Added the licsense list object to the locations --------- Co-authored-by: Russ Biggs <russbiggs@gmail.com> --------- Co-authored-by: Christian Parker <c.andrew.parker@gmail.com> * Release 20240220 (#343) * Feature/auth api (#340) * auth api updates * password reset (#341) * Feature/password email (#342) * password reset * password email * Feature/merge trends and measurements (#339) * Fix/statement timeout (#316) * Fix/v2 measurements source (#314) * fix v2 measurements to query measurements table instead of hourly * realias to match query params * measurements geom fix * Added sensors_id to speed up sorting * update statement_timeout to milliseconds --------- Co-authored-by: Russ Biggs <russbiggs@gmail.com> * set statement_timeout default config value --------- Co-authored-by: Christian Parker <c.andrew.parker@gmail.com> * Release 20231222 (#318) * Fix/v2 measurements source (#314) * fix v2 measurements to query measurements table instead of hourly * realias to match query params * measurements geom fix * Added sensors_id to speed up sorting * update statement_timeout to milliseconds --------- Co-authored-by: Russ Biggs <russbiggs@gmail.com> * ratelimit headers (#315) * ratelimit headers * dynamic ratelimt-policy values * Added wait_for method (#317) --------- Co-authored-by: Christian Parker <c.andrew.parker@gmail.com> * Added the trends methods (dow, hod, moy) to the measurements * Updated the trends and raw methods Added better period calculating for both * Added validation check for dates Still has error related to serializing a datetime object * Added work around for the value error + datetime issue Also fixed syntax errors in the bbox validation --------- Co-authored-by: Russ Biggs <russbiggs@gmail.com> * add placeholder for explorer_api_key --------- Co-authored-by: Christian Parker <c.andrew.parker@gmail.com> * Removed casting of datetime objects * Added summary back * Updated to use new `as_timestamptz` functions * update prod ratelimiting * v3 auth updates * Restrict access to purpleair until we can remove data * Changed tests to fit api * add token register endpoint (#345) (#346) * Allow the latest value to be empty (#351) Fixes #349 --------- Co-authored-by: Russ Biggs <russbiggs@gmail.com> Co-authored-by: Gabriel Fosse <67290377+majesticio@users.noreply.github.com> Co-authored-by: Gabriel Fosse <kraken+majesticio@users.noreply.github.com>
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Hi,
the following query leads to an error 500: https://api.openaq.org/v2/averages?temporal=year&date_to=2024-01-09&date_from=2023-01-09&locations_id=3162&spatial=location.
Error message I get back:
{
"detail": "'<=' not supported between instances of 'dict' and 'int'"
}
This error occurs only as long as I'm using the temporal parameter. Also tested on your API discovery page, but same issue here.
Hope this can be fixed and looking forward to hearing from you.
Best,
Maurice
The text was updated successfully, but these errors were encountered: