Can't use `redis 4.6.0` without connection pool leakage in worker

[birkjernstrom]

Active Redis connections 2023-07-19 (CET)

What happened

• Upgraded dependencies today in server: Use githubkit 0.10.6 + update dependencies #870
• Redis was bumped from 4.5.5 to 4.6.0
• Quickly ran into ConnectionError: max number of clients reached from polar.worker.create_pool
• Our worker went down. Rolled back + increased our Redis connection limit to 1k (Render) at the same time (not necessary once the rollback was completed).
• Tried deploying 4.6.0 again after lunch. Definition of insanity... But in my defence, initial deploy occurred during 1) our cron execution + 2) few large repositories triggering syncs. So I thought it might have been a timing issue.
• Deployed server: Use fixed version of redis (4.5.5) #872 and saw a drop in active connections to normal levels

Actions

• Fixed the version to 4.5.5 now
• Creating this issue to ensure we look into it more closely before upgrading redis (not a priority today)

[birkjernstrom]

Should note: Thanks to Redis (server) and arq, despite our worker being down for ~10m our queue kept building and once the worker was online again it powered through them all (short-term CPU spike)

[frankie567]

Since you mentioned this issue in #868, I was curious to see what was going on 🙃 Not sure if it's the source of this specific problem but the following function is problematic IMO:

polar/server/polar/worker.py

Lines 77 to 83 in 8e9ebe3

	async def enqueue_job(name: str, *args: Any, **kwargs: Any) -> Job | None:
	ctx = ExecutionContext.current()
	kwargs["polar_context"] = PolarWorkerContext(
	is_during_installation=ctx.is_during_installation,
	)
	redis = await create_pool()
	return await redis.enqueue_job(name, *args, **kwargs)

A pool is created each time we call enqueue_job. So we might end up with leaking connection pools. A global connection pool should be opened/closed during the lifetime of the FastAPI app (the new Lifespan context is quite elegant for this kind of use-case) and passed to the function.

---

Maybe a coincidence but, in 4.6.0, they released the following fix redis/redis-py/pull/2755 which removes the __del__ destructors. Maybe it was saving us from leaking pools when the GC was passing?

[birkjernstrom]

(Need to watch a mythbuster episode again soon – it was ages ago)

Completely agree. It's definitely a problematic (erroneous) implementation. I remember writing it in connection with switching to Arq from Celery a few months ago and that it was a quick hack at the time to get things up and running. Intent was definitely to create a global connection pool 🤦

No, it almost certainly must have been what saved us up until the 4.6.0 upgrade and thereby allowed this implementation to linger due to no noticeable issues. Fortunate. Unfortunate in that it prevented detection sooner 😊 But glad we can fix it now. Thanks for the help @frankie567 🙏 I'll look at this tomorrow in combination with the other bug you found – you're on a streak 😍