Incorrect connection reuse on PostgreSQL
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	Anomie
	Mar 23 2020, 4:32 PM

Description

The LoadBalancer tries to avoid reusing foreign PG connections to different PG databases. However, if there are no reusable connections for a foreign connection attempt and at least one PG connection that cannot be reused, it will try to reuse one of the unusable connections anyway and raise an error.

Details

	Subject	Repo	Branch	Lines +/-
	rdbms: fix connection reuse logic in LoadBalancer for postgres (2020 edition)	mediawiki/core	master	+5 -3

Customize query in gerrit

Event Timeline

Anomie created this task.Mar 23 2020, 4:32 PM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptMar 23 2020, 4:32 PM

Change 582838 had a related patch set uploaded (by Anomie; owner: Anomie):
[mediawiki/core@master] rdbms: fix connection reuse logic in LoadBalancer for postgres (2020 edition)

https://gerrit.wikimedia.org/r/582838

gerritbot added a project: Patch-For-Review.Mar 23 2020, 4:33 PM

Anomie moved this task from Inbox to Waiting for Review on the Platform Team Workboards (Clinic Duty Team) board.Mar 23 2020, 4:33 PM

Change 582838 merged by jenkins-bot:
[mediawiki/core@master] rdbms: fix connection reuse logic in LoadBalancer for postgres (2020 edition)

https://gerrit.wikimedia.org/r/582838

ReleaseTaggerBot added a project: MW-1.35-notes (1.35.0-wmf.26; 2020-03-31).Mar 25 2020, 12:00 AM

Maintenance_bot removed a project: Patch-For-Review.Mar 25 2020, 12:10 AM

Anomie closed this task as Resolved.Mar 25 2020, 6:07 PM

Anomie moved this task from Waiting for Review to Done on the Platform Team Workboards (Clinic Duty Team) board.

Aklapper removed a subscriber: Anomie.Oct 16 2020, 5:38 PM