Project

General

Profile

Actions

Bug #11638

closed

[arvados-ws] Label and limit database connections

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

Status:
Resolved
Priority:
Normal
Assigned To:
Category:
API
Target version:
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 open1 closed)

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

Updated by Tom Clegg almost 7 years ago

  • Status changed from New to In Progress
Actions #3

Updated by Lucas Di Pentima almost 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 #4

Updated by Tom Clegg almost 7 years ago

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

Applied in changeset arvados|commit:08e9c6aff46e182b9cd14fab9d42d21b2d7c6902.

Actions

Also available in: Atom PDF