Content pfp
Content
@
0 reply
0 recast
2 reactions
welter pfp
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
jtgi pfp
jtgi
@jtgi
They’re lambdas, you can’t use normal connection pooling because you have no persistent instance to hold connections. You need to switch to a managed Postgres provider: vercel postgres, supabase, or planetscale. https://vercel.com/guides/connection-pooling-with-serverless-functions
1 reply
0 recast
1 reaction
christopher pfp
christopher
@christopher
are you releasing the connections back to the pool?
1 reply
0 recast
0 reaction
Joshua Hyde pfp
Joshua Hyde
@jrh3k5.eth
Do you have a link to the schema definition, as well as some example queries in the GitHub repo that are timing out? I know you've said that you've added indexes, but I've seen Postgres databases chug along just fine until they cross a threshold where the schema design crumbles underneath the weight of the data.
0 reply
0 recast
0 reaction
Tony D’Addeo pfp
Tony D’Addeo
@deodad
probably downstream of bots hitting your servers applying an global rate limiting?
0 reply
0 recast
0 reaction
kevin pfp
kevin
@kevinoconnell
guessing rate limits - would try caching the results and limiting how often you connect to the pool
0 reply
0 recast
0 reaction
Drew Volpe pfp
Drew Volpe
@drew
This sounds like the max connections in the pool have been hit. What is max_client_conn in PgBouncer set to? Likely need to increase it.
1 reply
0 recast
0 reaction
Rafi pfp
Rafi
@rafi
See what dominates in `SELECT * FROM pg_stat_activity` and look for leaks and inefficients in related code. Happy to help you out in scanning the code for such issues :)
1 reply
0 recast
0 reaction
TobyJaguar pfp
TobyJaguar
@tobyjaguar
did you get this sorted?
1 reply
0 recast
0 reaction
Start🔥Base pfp
Start🔥Base
@starbase
Can't use it anymore 😓
1 reply
0 recast
0 reaction
TobyJaguar pfp
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
jcdenton.cast pfp
jcdenton.cast
@jc
Start by ratelimiting queries to the db, adjusting the ratelimit until queries get too slow? https://en.wikipedia.org/wiki/Thundering_herd_problem
0 reply
0 recast
2 reactions
agusti 🐘 pfp
agusti 🐘
@bleu.eth
bro u should enable dm's to send u feedback as u ask on the website. i use to check my past activity (really like the cast graph) also to check my follower stats and gather how I'm doing w my content etc
1 reply
0 recast
0 reaction
Chris Biele ⌐◨-◨ 🎩 pfp
Chris Biele ⌐◨-◨ 🎩
@nfthinker
Hope you are able to fix, although it’s obviously a challenge to keep running! I use the site to check unfollowers. So many people follow and then unfollow quickly after I follow them back. They’re obviously farming, so not worth my attention or engagement.
0 reply
0 recast
0 reaction
non 🐹 pfp
non 🐹
@non07777.eth
I check my active rate at FarcasterUserStats.com. That is very important for me to benefit from the airdrop.Thank you.
0 reply
0 recast
0 reaction
Pablofb pfp
Pablofb
@pablofb
I hope you can solve it. Your service is excellent. I discovered your web thanks to @joobid.eth
0 reply
0 recast
0 reaction
rickacrane 🎩Ⓜ️🎭 pfp
rickacrane 🎩Ⓜ️🎭
@thepapercrane
Does this mean I dont get my hard earned badge!!?? 😅
0 reply
0 recast
0 reaction