welter on Warpcast

Content pfp

0 reply

0 recast

3 reactions

welter pfp

⚠️ 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

22 replies

12 recasts

32 reactions

christopher pfp

are you releasing the connections back to the pool?

1 reply

0 recast

0 reaction

TobyJaguar pfp

did you get this sorted?

1 reply

0 recast

0 reaction

Start🔥Base pfp

Can't use it anymore 😓

1 reply

0 recast

0 reaction

TobyJaguar pfp

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

Drew Volpe pfp

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

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

jcdenton.cast pfp

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

jtgi - mostly offline 23 -> 05 pfp

jtgi - mostly offline 23 -> 05

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

Tony D’Addeo pfp

probably downstream of bots hitting your servers applying an global rate limiting?

0 reply

0 recast

0 reaction

agusti 🐘🔵 pfp

agusti 🐘🔵

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

kevin pfp

guessing rate limits - would try caching the results and limiting how often you connect to the pool

0 reply

0 recast

0 reaction

Joshua Hyde pfp

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

Garland Elijah pfp

@garlandelijah1

Oh my gosh 🥺

0 reply

0 recast

0 reaction

🎀 benna 🎀🎩 pfp

🎀 benna 🎀🎩

btw, since you asked on the website: i just really like checking how my activity and follower-count has been increasing over the past few days! trying to active the active badge hehe, but also just sort of feels gamified seeing the stats ahaha

0 reply

0 recast

0 reaction

TOM🎩 pfp

There are many interesting communities, not as cumbersome as X. Here I became a KOL

0 reply

0 recast

0 reaction

TOM🎩 pfp

There are many interesting communities, not as cumbersome as X. Here I became a KOL

0 reply

0 recast

0 reaction

TOM🎩 pfp

There are many interesting communities, not as cumbersome as X. Here I became a KOL

0 reply

0 recast

0 reaction

Chris Biele ⌐◨-◨ 🎩 pfp

Chris Biele ⌐◨-◨ 🎩

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

Holand🎩 pfp

0 reply

0 recast

0 reaction