From owner-freebsd-stable Tue Jun 18 17:35:24 2002 Delivered-To: freebsd-stable@freebsd.org Received: from exstaff9.city.unisa.edu.au (exstaff9.city.unisa.edu.au [130.220.84.77]) by hub.freebsd.org (Postfix) with ESMTP id 5630F37B400 for ; Tue, 18 Jun 2002 17:35:13 -0700 (PDT) Received: by exstaff9.city.unisa.edu.au with Internet Mail Service (5.5.2655.55) id ; Wed, 19 Jun 2002 10:05:11 +0930 Message-ID: From: Jarrod Sayers To: "'stable@freebsd.org'" Cc: "'buga@lemis.com'" Subject: PostgreSQL 7.2 hanging CPU Date: Wed, 19 Jun 2002 10:05:10 +0930 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2655.55) Content-Type: text/plain Sender: owner-freebsd-stable@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG On a system running 4.6-R with all its packages upgraded by portupgrade there appears to be a problem with PostgreSQL. A monitoring program is started up when the machine boots which monitors machines on our network and uses PostgreSQL to keep all its data. The problem is, is that the load on the machine slowly grows (see http://dogbert.magill.unisa.edu.au/admin/mrtg/load.html) until the machine is rebooted manually - at which stage the load begins around 0.70. If I reinstall PostgreSQL, re init the db and restore the data, the load sits at 0.01 but after a few hours, its back to hanging the CPU. PID USERNAME PRI NICE SIZE RES STATE TIME WCPU CPU COMMAND 8366 pgsql 64 0 6112K 3956K RUN 0:27 94.40% 69.97% postgres dogbert> uname -a FreeBSD dogbert.magill.unisa.edu.au 4.6-RELEASE FreeBSD 4.6-RELEASE #14: Mon Jun 10 12:03:12 CST 2002 sayersjm@dogbert.magill.unisa.edu.au:/usr/src/sys/compile/DOGBERT i386 dogbert> ls -1 /var/db/pkg | grep postgres postgresql-7.2.1_1 dogbert> Any ideas on what causes it and how to fix it? Cheers, Jarrod Sayers Information Technology Services Unit University of South Australia, Mawson Lakes Campus. Phone: +61 8 8302 3133 http://people.unisa.edu.au/jarrod.sayers To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-stable" in the body of the message