Repository navigation
unnecessary excessive DB calls? #764
Description
** Please make sure you read the contribution guide and file the issues in the rigth place. **
Contribution guide.
Describe the bug
We ran an ADK agent over 3500 objects and that took our database down.
Looking at queries it seems this query is causing it:
UPDATE app_states SET state=$1::JSONB, update_time=now() WHERE app_states.app_name = $2
I don't ever see a case that we actually want state for apps yet this is causing huge load on the DB. Also I don't have any state with prefix app: so I was not expecting this DB all at all.
To Reproduce
N/A
Expected behavior
N/A
Screenshots
Desktop (please complete the following information):
N/A
Additional context
N//a
Activity
seanzhou1023 commentedon May 19, 2025
@mohammad-passage thanks for reporting the issue. Are you able to provide some agent codes and sample user queries that we can reproduce ?
mohammad-passage commentedon May 19, 2025
Our code has no app: state so I guess any random agent has same issue that creates an empty app state and suffers from hot key update at scale.
DeanChensj commentedon May 28, 2025
Thanks for raising this issue. It will be fixed when d83ee1a is included in next release.