X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id B2FA811F60A2 for ; Wed, 26 Apr 2006 13:09:28 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 45766-04 for ; Wed, 26 Apr 2006 13:09:08 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nz-out-0102.google.com (nz-out-0102.google.com [64.233.162.195]) by postgresql.org (Postfix) with ESMTP id 1429811F6707 for ; Wed, 26 Apr 2006 13:09:07 -0300 (ADT) Received: by nz-out-0102.google.com with SMTP id o1so1333241nzf for ; Wed, 26 Apr 2006 09:09:07 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=nVbbybFU3OgPWPddtKBe3B3uT2EL36E7SJK4j6kD0LgXx5J996Hy5rNtkvBEwnQhb0JNdQXrHGII7g1IT3cEE99Khd5/1ZEOtiU7aM88oE/hNc89UBj0m+6mO6m037zCoVnFnpMq2PrxO4vutCfKV5lVTS2AYOdQZZiM2Mv1OzY= Received: by 10.36.43.1 with SMTP id q1mr1593667nzq; Wed, 26 Apr 2006 09:09:07 -0700 (PDT) Received: by 10.36.128.15 with HTTP; Wed, 26 Apr 2006 09:09:07 -0700 (PDT) Message-ID: <1e71f8880604260909q71a8ed67nf819e19219b8378b@mail.gmail.com> Date: Wed, 26 Apr 2006 16:09:07 +0000 From: "Doug Lochart" To: pgsql-admin@postgresql.org Subject: pgadmin3 and tomcat hangs. MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.217 tagged_above=0 required=5 tests=BAYES_00, SPF_HELO_SOFTFAIL, SPF_SOFTFAIL X-Spam-Level: * X-Archive-Number: 200604/356 X-Sequence-Number: 21525 using (tomcat with a connection pool max=3D20, 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. thanks Doug -- What profits a man if he gains the whole world yet loses his soul?