using (tomcat with a connection pool max=20, postgres with max
connections set to 100)
Sometimes we will look into the database using pgadmin3 and will want
to add a column to a table. The webapp is NOT in use at the time (its
running and has 5 connections in the pool) but no one is logged in and
no one is actively using the connections. When I click OK to change
the table it will hang. When I bounce tomcat pgadmin3 returns and has
completed its job.
What causes this hang?
Also when I shutdown postgres I often have to shutdown with -m fast
because the shutdown would wait forever. Again the web app is running
but no activity is on the connections. When tomcat is bounced the
shutdown would proceed.
These are not show stopper issues but i am wondering if whatever is
causing the pgadmin to freeze could be causing our web app to
experience SocketTimeout exceptions once or twice a month. When these
exceptions occur (specified in another post on this list) we are NOT
doing any maintenance or even viewing the database through any
external tools. The last one occured at 11:30pm whan a user tried to
access the system.
What profits a man if he gains the whole world yet loses his soul?
pgsql-admin by date
|Next:||From: Jerry Sievers||Date: 2006-04-26 16:39:26|
|Subject: Postmaster log perms and line suffix|
|Previous:||From: Doug Lochart||Date: 2006-04-26 15:44:41|
|Subject: Socket Timeouts and fatal errors (please help)|