pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Craig Russell <craig@airdigitalnetwork.com>
To: pgsql-admin@postgresql.org
Subject: unable to add or delete from table
Date: Fri, 03 Nov 2006 13:40:44 -0500
Message-ID: <454B8D2C.30802@airdigitalnetwork.com> (raw)

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




view thread (3+ messages)  latest in thread

Message-ID: <454B8D2C.30802@airdigitalnetwork.com>
Permalink:  ../454B8D2C.30802@airdigitalnetwork.com/
Also on:    postgresql.org/message-id/454B8D2C.30802@airdigitalnetwork.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: craig@airdigitalnetwork.com
  Subject: Re: unable to add or delete from table
  In-Reply-To: <454B8D2C.30802@airdigitalnetwork.com>
  References: <454B8D2C.30802@airdigitalnetwork.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox