Comment 5 for bug 247227

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

make schema will kill the database connection without notifying the client. It is exactly the same as what will happen if the connection is killed by the stale db connection reaper, and I've seen a few hits go past for the lpnet connections.

So I'm led to suspect that Launchpad is dying silently if the database server connection is killed (and possibly if there is a network drop out, which would be similar). It is supposed to be reconnecting if this happens.

We can test locally using "SELECT usename, procpid from pg_stat_activity" to get the process ids for the connections, and just use unix 'kill' to terminate the process.