Skip to Content.
Sympa Menu

grouper-users - RE: [grouper-users] Question re recurring connections to the grouperdb

Subject: Grouper Users - Open Discussion List

List archive

RE: [grouper-users] Question re recurring connections to the grouperdb


Chronological Thread 
  • From: Chris Hyzer <>
  • To: Keith Hazelton <>, "" <>
  • Subject: RE: [grouper-users] Question re recurring connections to the grouperdb
  • Date: Fri, 25 Jan 2013 16:20:29 +0000
  • Accept-language: en-US

Tomcat(s), loader, gsh is all I can think of...

Thanks,
Chris

-----Original Message-----
From:


[mailto:]
On Behalf Of Keith Hazelton
Sent: Friday, January 25, 2013 11:13 AM
To:

Subject: [grouper-users] Question re recurring connections to the grouperdb

I've been cloning instances of Grouper from one host to another with success.

One task is to drop the Grouper database (grouperdb in Postgres), then
re-create and reload it.

The Grouper Tomcat instance is shut down. Grouper Loader is not running.

When I drop the connections in preparation to drop the database, new
connections keep being spontaneously made.

----------
postgres=# psql
select pg_terminate_backend(procpid) from pg_stat_activity where datname =
'grouperdb';
----------------------
t
t
(2 rows)

- I have to repeat the above select statement sometimes twice or more until
following drop command succeeds

postgres=# drop database grouperdb;
DROP DATABASE
----------

I'm not sure what process is generating new connections. The 3CPO connection
manager? Is there a way to stop whatever it is?

Thanks in advance, --Keith




Archive powered by MHonArc 2.6.16.

Top of Page