No connection timeout makes transaction timeout unreliable

Bug #949740 reported by Stuart Bishop
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Launchpad itself
Invalid
Low
Unassigned
Storm
Confirmed
Medium
Unassigned

Bug Description

A PostgreSQL connection attempt can hang indefinitely. This is often undesirable, eg. when you are using a TimeoutTracer to guarantee that transactions complete within a fixed time, or if you just don't want a script to be able to hang indefinitely because a connection pool is full.

PostgreSQL 7.4+ supports a 'connect_timeout' option in the libpq connection string. We need a way for this to be set. It may make sense to have this setting changed automatically from the PostgreSQLTimeoutTracer.

Revision history for this message
Stuart Bishop (stub) wrote :

Launchpad needs this, per Bug #947193

Changed in storm:
status: New → Triaged
importance: Undecided → Low
status: Triaged → New
status: New → Confirmed
importance: Low → Medium
Changed in launchpad:
status: New → Triaged
importance: Undecided → Low
Revision history for this message
Stuart Bishop (stub) wrote :

For Launchpad, this can already be specified in the launchpad-lazr.conf file

Changed in launchpad:
status: Triaged → Invalid
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.