Project

General

Profile

Actions
Copy link

Bug #11638

closed

[arvados-ws] Label and limit database connections

Added by Tom Clegg over 7 years ago. Updated over 7 years ago.

Status:
Resolved
Priority:
Normal
Assigned To:
Tom Clegg
Category:
API
Target version:
2017-05-10 sprint
Story points:
-

Description

arvados-ws appears to open too many Postgres connections, eventually reaching the Postgres server limit and preventing API server from connecting.

Also, connections are hard to identify in pg_stat_activity because arvados-ws does not set the application_name parameter.

Subtasks 1 (0 open — 1 closed)

Task #11640: Review 11638-limit-connsResolvedTom Clegg05/08/2017Actions
Actions
Copy link
 #1

Updated by Tom Clegg over 7 years ago

  • Status changed from New to In Progress
Actions
Copy link
 #2

Updated by Tom Clegg over 7 years ago

Actions
Copy link
 #3

Updated by Lucas Di Pentima over 7 years ago

Just a small detail: Would it be useful if a warning message is logged when the PostgresPool is set to <= 0?
The rest LGTM.

Actions
Copy link
 #4

Updated by Tom Clegg over 7 years ago

  • Status changed from In Progress to Resolved
  • % Done changed from 0 to 100

Applied in changeset arvados|commit:08e9c6aff46e182b9cd14fab9d42d21b2d7c6902.

Actions
Copy link

Also available in: Atom PDF