Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

AppEngine and Scylla error when using limit on an interface with small expiry #745

Open
Pavinati opened this issue Dec 6, 2022 · 0 comments
Labels
API This issue or pull request is about API (e.g. unclear API, new API, API change, deprecation) app:appengine_api This issue or pull request is about astarte_appengine_api application bug Something isn't working database This issue or pull request is about database (e.g. schema change, queries, support, etc...)
Milestone

Comments

@Pavinati
Copy link
Collaborator

Pavinati commented Dec 6, 2022

Setup:

  • Interface Object Aggregated with 24 mappings (all strings except a single integer array)
  • Database retention 60s
  • The device publishes a new value every 15-18s

Observed results:

  • GET /value returns all values (max 5 results)
  • GET /value?limit=10 makes AppEngine crash with 500 internal server error. Scylla logs
scylla-0 scylla[691]:  [shard 1] storage_proxy - Exception when communicating with 10.132.0.2: std::runtime_error (Aborting reverse partition read because partition 2f51fc9f-7102-563e-b5d0-9589731832bb:/sol is larger than the maximum safe size of 10485760 for reversible partitions.)
  • GET /value?limit=10&since=X where X is any timestamp, even something like 20 years ago. Astarte returns all results as normal.
@rbino rbino added bug Something isn't working database This issue or pull request is about database (e.g. schema change, queries, support, etc...) API This issue or pull request is about API (e.g. unclear API, new API, API change, deprecation) app:appengine_api This issue or pull request is about astarte_appengine_api application labels Jan 17, 2023
@rbino rbino added this to the v1.2 milestone Jan 17, 2023
@bettio bettio modified the milestones: v1.2, v1.3 Jun 19, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
API This issue or pull request is about API (e.g. unclear API, new API, API change, deprecation) app:appengine_api This issue or pull request is about astarte_appengine_api application bug Something isn't working database This issue or pull request is about database (e.g. schema change, queries, support, etc...)
Projects
Status: No status
Development

No branches or pull requests

3 participants