Received: from localhost (uranus.hub.org [200.46.204.60]) by postgresql.org (Postfix) with ESMTP id 2A5749FB276 for ; Fri, 3 Nov 2006 14:47:36 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.60]) (amavisd-new, port 10024) with ESMTP id 89838-04 for ; Fri, 3 Nov 2006 14:47:32 -0400 (AST) X-Greylist: delayed 00:06:40.196228 by SQLgrey- Received: from mailhost.airdigitalnetwork.com (unknown [64.192.34.10]) by postgresql.org (Postfix) with ESMTP id B225E9F9F0E for ; Fri, 3 Nov 2006 14:47:31 -0400 (AST) Received: (qmail 726 invoked by uid 1010); 3 Nov 2006 14:13:33 -0500 Received: from 64.192.35.61 by mailhost (envelope-from , uid 1008) with qmail-scanner-1.25-st-qms (clamdscan: 0.83/705. spamassassin: 3.0.2. perlscan: 1.25-st-qms. Clear:RC:0(64.192.35.61):SA:0(-1.5/5.0):. Processed in 0.678933 secs); 03 Nov 2006 19:13:33 -0000 X-Antivirus-airdigitalnetwork.com-Mail-From: craig@airdigitalnetwork.com via mailhost X-Antivirus-airdigitalnetwork.com: 1.25-st-qms (Clear:RC:0(64.192.35.61):SA:0(-1.5/5.0):. Processed in 0.678933 secs Process 715) Received: from 64-192-35-61.wcg.net (HELO ?192.168.1.100?) (craig@airdigitalnetwork.com@64.192.35.61) by mailhost.airdigitalnetwork.com with RC4-MD5 encrypted SMTP; 3 Nov 2006 14:13:32 -0500 Message-ID: <454B8D2C.30802@airdigitalnetwork.com> Date: Fri, 03 Nov 2006 13:40:44 -0500 From: Craig Russell Reply-To: craig@airdigitalnetwork.com User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: unable to add or delete from table Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.136 tagged_above=0 required=5 tests=BAYES_50, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200611/17 X-Sequence-Number: 23544 I'm using a postgresql database as the back end for opennms. Everything was running fine until I had to do some tuning a few weeks ago (basically deleting old nodes, unmanaging interfaces, etc.) I did all of this via the web ui that comes with opennms. However, I discovered a couple of days ago that I am no longer able to add or delete nodes. It appears that the node table is locked and nothing I have tried has allowed me to modify this table. I have been able to work with the other tables in the database just not the node table. I am certainly not a sql expert but everything I have tried to date has failed. The command that I am running to delete a node from the command line is as follows: delete from node where nodeid=19; This command just hangs at the command line and a ctrl-c jumps me out of it. All that appears to be logged is a "query cancelled by user". I have tried reindexing the table, running a vacuum on the table and the database, all to no avail. I am able to run similar commands on other tables to delete unwanted rows. Any ideas on what I am missing here? Thanks, Craig Russell