[Spacewalk-list] Problem with rhntaskorun

[Elizabeth Good]

Hi Robert,

Thank you.  I didn't think there would be a problem running the postgresql backup while spacewalk is up, but I can try seeing what happens if spacewalk is off.

I was suspecting it could possibly be database corruption, but was hoping it would be an easy fix (recreating indexes, etc).  But so far, no dice.

Beth

From: spacewalk-list-bounces at redhat.com [mailto:spacewalk-list-bounces at redhat.com] On Behalf Of Paul Robert Marino
Sent: Friday, October 19, 2012 3:08 PM
To: spacewalk-list at redhat.com
Subject: Re: [Spacewalk-list] Problem with rhntaskorun

well first off if you are doing drops and loads on the database you should turn the services for spacewalk off first however the MVCC should prevent the concurrent delete error you mentioned.
This also sounds more like you have corruption in the database which is probably due to a file system problem, an exclusive lock on a table or column, or possibly a bad PostgreSQL binary but its not a spacewalk issue.


On Fri, Oct 19, 2012 at 2:28 PM, Elizabeth Good <elizabeth.good at duke.edu<mailto:elizabeth.good at duke.edu>> wrote:
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




<http://www.fuqua.duke.edu/>[Description: Rethinking the Boundaries]<http://www.fuqua.duke.edu/><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<tel:%2B1.919.381.7625> | Fax +1.919.660.1904<tel:%2B1.919.660.1904>



_______________________________________________
Spacewalk-list mailing list
Spacewalk-list at redhat.com<mailto:Spacewalk-list at redhat.com>
https://www.redhat.com/mailman/listinfo/spacewalk-list

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