Content
@
0 reply
0 recast
2 reactions
welter
@fun
⚠️ FarcasterUserStats.com is down i really need help, this is frustrating ‼️ postgres db connection limit maxed, i have a pool in place, not sure if that actually works or not sql queries to the db should be less than 1-2s max, but now they're going over 15s timing out
18 replies
12 recasts
28 reactions
TobyJaguar
@tobyjaguar
so the issue is the connections, not the query timeouts? As already stated, how are connections being released? Does each query open a new connection, and does that connection get released after the query? Kind of need to know the setup
1 reply
0 recast
0 reaction
welter
@fun
simplified version of what im doing, feel free to correct me if i'm wrong import { pool } from '../db' const client = await pool.connect(); const response = await pool.query(`query here`); client.release()
1 reply
0 recast
0 reaction
TobyJaguar
@tobyjaguar
kind of tough not to know the infra, I am mostly on aws infra these days. Clearly the above is not working 🤣 , or it may be correct but isn't working with your infra. Can you verify that the connections are in fact being released? I will just be asking annoying questions at this point
1 reply
0 recast
0 reaction
welter
@fun
if you are able to look over how im pooling connections and see whats going on that would be amazing https://github.com/mattwelter/farcaster-user-stats
2 replies
0 recast
1 reaction
welter
@fun
the pool host is pointed to a railway instance using this repo https://github.com/mattwelter/PgBouncer
0 reply
0 recast
0 reaction
