[Spacewalk-list] Problem with rhntaskorun

[Paul Robert Marino]

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>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****
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> **[image: Description: Rethinking the Boundaries]<http://www.fuqua.duke.edu/>
> ***Elizabeth Good <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
>
>
> ****
>
> ** **
>
> _______________________________________________
> Spacewalk-list mailing list
> 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/58bd05e3/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.jpg
Type: image/jpeg
Size: 3923 bytes
Desc: not available
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20121019/58bd05e3/attachment.jpg>