Opened 4 years ago

Last modified 4 years ago

#31373 closed Bug

Django 3.x / uwsgi is leaking connections — at Version 5

Reported by: Marcin Nowak Owned by: nobody
Component: Database layer (models, ORM) Version: 3.0
Severity: Release blocker Keywords:
Cc: Andrew Godwin, Simon Charette Triage Stage: Accepted
Has patch: no Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: no UI/UX: no

Description (last modified by Marcin Nowak)

Project upgraded from 2.x to 3.0.4 is leaking PostgreSQL database connections.
ATOMIC_REQUESTS=False, AUTOCOMMIT=True, CONN_MAX_AGE=0
UWSGi threads are enabled (--enable-threads)
Python 3.8.1 and 3.7.3

After few hours all posgtress connections are used (too many connections error).
pg_stat_activity is reporting idle connections with part of queries visible.

I would try to deliver more details later.


Facts:

  • setting up CONN_MAX_AGE > 0 does not help
  • CONN_MAX_AGE = 30, starting runserver and making many calls with ab -c 10 -n 100 http://127.0.0.1:8000/ uses all available connections and ends with error 500 (due to no available connections)
  • CONN_MAX_AGE = 30, starting runserver --nothreading and making calls with ab -c 100 -n 100 http://127.0.0.1:8000/ works fine


CONN_MAX_AGE=30 + runserver + ab scenario is reproducible on clean install. View must call database.
CONN_MAX_AGE=0 + runserver + ab -> cannot reproduce.

Change History (7)

comment:1 by Marcin Nowak, 4 years ago

Description: modified (diff)

comment:2 by Marcin Nowak, 4 years ago

Description: modified (diff)

comment:3 by Marcin Nowak, 4 years ago

Description: modified (diff)

comment:4 by Marcin Nowak, 4 years ago

Description: modified (diff)

comment:5 by Marcin Nowak, 4 years ago

Description: modified (diff)
Note: See TracTickets for help on using tickets.
Back to Top