[GCP] [K8s] [Agent Memory] Google cloud SQL PGSQL connection leakage #3843
Closed
wlhong-allo
started this conversation in
General
Replies: 1 comment
-
Just updated to latest repo and found the bug is fixed~ thanks |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
i have a setup on GCP K8s with PGSQL on Google Cloud SQL, i figured that there are a query keep eating the connections until it maxed out the connection limit, below is the query that sits on the connection for over 24 hours and idle status:
INSERT INTO checkpoints (thread_id, checkpoint_id, parent_id, checkpoint, metadata) VALUES ($1, $2, $3, $4, $5) ON CONFLICT (thread_id, checkpoint_id) DO UPDATE SET checkpoint = EXCLUDED.checkpoint, metadata = EXCLUDED.metadata
Does anyone has idea?
and are there anyway to setup connection pool?
Thanks,
WL
Beta Was this translation helpful? Give feedback.
All reactions