[Spacewalk-list] Problem with rhntaskorun

[Elizabeth Good]

Hello,

We are on spacewalk 1.7, postgresql 8.4.13.  We have not been able to get a good pg_dump, as the postgresql backup stops at the rhntaskorun table:

pg_dump: Dumping the contents of table "rhntaskorun" failed: PQgetCopyData() failed.
pg_dump: Error message from server: pg_dump: The command was: COPY public.rhntaskorun (id, template_id, schedule_id, org_id, start_time, end_time, std_output_path, std_error_path, status, created, modified) TO stdout;
pg_dump: *** aborted because of error

In addition, if I try to do a select from the rhntaskorun table, there is a SEG fault and postgres does a restart:

spaceschema=# select status from rhntaskorun;
The connection to the server was lost. Attempting reset: Failed.
!> \

One of things I've tried to do is drop and recreate the rhntaskorun primary key.  I can delete it, but when I try to recreate it, I receive the following error:


spaceschema=# ALTER TABLE rhntaskorun ADD CONSTRAINT rhn_tasko_run_id_pk PRIMARY KEY (id);
NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "rhn_tasko_run_id_pk" for table "rhntaskorun"
ERROR:  concurrent delete in progress

I imagine this has something to do with the qrtz triggers, but not exactly sure what.


Any help would be much appreciated.


Thanks,
Beth




[Description: Rethinking the Boundaries]<http://www.fuqua.duke.edu/>Elizabeth Good<mailto:elizabeth.good at duke.edu>
Database Administrator (Oracle, SQL Server, PostgreSQL, MySQL)
Duke University's Fuqua School of Business<http://www.fuqua.duke.edu/>
100 Fuqua Drive, Box 90120, Durham, NC 27708-0120 USA
Tel +1.919.381.7625 | Fax +1.919.660.1904



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20121019/ef7df7a4/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.gif
Type: image/gif
Size: 1690 bytes
Desc: image001.gif
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20121019/ef7df7a4/attachment.gif>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.jpg
Type: image/jpeg
Size: 3923 bytes
Desc: image002.jpg
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20121019/ef7df7a4/attachment.jpg>