[prev in list] [next in list] [prev in thread] [next in thread]
List: spacewalk-list
Subject: Re: [Spacewalk-list] rhntaskorun issues
From: Andy Ingham <andy.ingham () duke ! edu>
Date: 2012-10-29 18:35:26
Message-ID: 4E133C8BBD4A504E835BDDD9E35A708D858E3B () ex-mbg-05 ! win ! duke ! edu
[Download RAW message or body]
Hello list --
I haven't gotten any responses to my request from last week (below).
I'm also now noticing THESE errors in my Tomcat logs. Any idea why?
Oct 29, 2012 1:46:22 PM org.apache.catalina.loader.WebappClassLoader \
clearReferencesJdbc
SEVERE: A web application registered the JBDC driver [org.postgresql.Driver] but \
failed to unregister it when the web application was stopped. To prevent a memory \
leak, the JDBC Driver has been forcibly unregistered. Oct 29, 2012 1:46:22 PM \
org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: A web application appears to have started a thread named [RHN Message \
Dispatcher] but has failed to stop it. This is very likely to create a memory leak. \
Oct 29, 2012 1:46:22 PM org.apache.catalina.loader.WebappClassLoader \
clearThreadLocalMap
SEVERE: A web application created a ThreadLocal with key of type [null] (value \
[com.redhat.rhn.common.hibernate.ConnectionManager$1@13742ad8]) and a value of type \
[null] (value [null]) but failed to remove it when the web application was stopped. \
To prevent a memory leak, the ThreadLocal has been forcibly removed.
Thanks,
Andy
Andy Ingham
IT Infrastructure
Fuqua School of Business
Duke University
From: Andy Ingham <andy.ingham@duke.edu<mailto:andy.ingham@duke.edu>>
Date: Wednesday, October 24, 2012 12:16 PM
To: "spacewalk-list@redhat.com<mailto:spacewalk-list@redhat.com>" \
<spacewalk-list@redhat.com<mailto:spacewalk-list@redhat.com>>
Subject: Re: [Spacewalk-list] rhntaskorun issues
Folks --
(Beth and I work in the same office)
We believe that we traced the pgsql problem (below) to some iSCSI connection issues. \
Unfortunately, since we did not have a usable database dump, we ended up having to do \
the following:
from the spaceschema database:
truncate table rhntaskorun;
(this was done *without* the cascade option, so only that table was truncated.)
The good news is that we can now do SELECTS from all tables in the database without \
spectacular postgres crashes.
The bad news is that certain spacewalk functions are now broken (not surprisingly, \
due to the deletion of records above).
Specifically:
* going to https://our.spacewalk.server.edu/rhn/admin/SatSchedules.do results in "The \
scheduling service appears down. Please contact your Satellite administrator."
* osa-dispatcher startup results in: Starting osa-dispatcher: RHN 2349 2012/10/24 \
11:14:23 -04:00: ('Error caught:',) RHN 2349 2012/10/24 11:14:23 -04:00: ('Traceback \
(most recent call last):\n File "/usr/share/rhn/osad/jabber_lib.py", line 117, in \
main\n self.setup_config(config)\n File "/usr/share/rhn/osad/osa_dispatcher.py", \
line 112, in setup_config\n rhnSQL.initDB()\n File \
"/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/__init__.py", line 124, in \
initDB\n __init__DB(backend, host, port, username, password, database)\n File \
"/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/__init__.py", line 55, in \
__init__DB\n __DB.connect()\n File \
"/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py", line \
171, in connect\n return self.connect(reconnect=0)\n File \
"/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py", line \
160, in connect\n password=self.password)\nSQLConnectError: (None, None, \
\'spaceschema\', \'Attempting Re-Connect to the database failed\')\n',)
* the rhn_taskomatic_daemon.log shows, among other things: INFO | jvm 1 | \
2012/10/24 11:46:13 | WARNING: java.lang.NoClassDefFoundError: Could not initialize \
class net.sf.cglib.proxy.Enhancer
* the rhn_server_xmlrpc.log shows, among other things: 2012/10/24 11:53:23 -04:00 \
6184 10.148.42.65: server/rhnChannel.guess_channels_for_server('ERROR', 'No available \
channels for (server, org)', (1000010031, 1), '6.3', 'x86_64-redhat-linux')
My questions:
(1) Any chance that a "stock" set of records might be available somewhere for \
re-populating the rhntaskorun table?
(2) Any advice on the other errors noted above? (Assuming they aren't just red \
herrings).
Many thanks in advance.
Andy
Andy Ingham
IT Infrastructure
Fuqua School of Business
Duke University
From: Elizabeth Good <elizabeth.good@duke.edu<mailto:elizabeth.good@duke.edu>>
Reply-To: "spacewalk-list@redhat.com<mailto:spacewalk-list@redhat.com>" \
<spacewalk-list@redhat.com<mailto:spacewalk-list@redhat.com>>
Date: Tuesday, October 23, 2012 9:57 AM
To: "spacewalk-list@redhat.com<mailto:spacewalk-list@redhat.com>" \
<spacewalk-list@redhat.com<mailto:spacewalk-list@redhat.com>>
Subject: [Spacewalk-list] rhntaskorun issues
Hello,
I’m reposting this in the hopes that someone has run across a similar issue with the \
rhntaskorun table. Spacewalk is down when I’ve performed the following actions. As \
far as we can tell it is not a problem with our disks.
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, selecting from the rhntaskorun also causes issues.
All the postgresql processes go down when I do the select or run a pg_dump, with the \
exception of the postmaster and logger processes.
Thanks,
Beth
[Attachment #3 (text/html)]
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: \
after-white-space; color: rgb(0, 0, 0); font-size: 14px; font-family: Calibri, \
sans-serif; "> <div>Hello list --</div>
<div><br>
</div>
<div>I haven't gotten any responses to my request from last week (below).</div>
<div><br>
</div>
<div>I'm also now noticing THESE errors in my Tomcat logs. Any idea why?</div>
<div><br>
</div>
<div>
<div><span class="Apple-tab-span" style="white-space:pre"></span>Oct 29, 2012 1:46:22 \
PM org.apache.catalina.loader.WebappClassLoader clearReferencesJdbc</div> <div><span \
class="Apple-tab-span" style="white-space:pre"></span>SEVERE: A web application \
registered the JBDC driver [org.postgresql.Driver] but failed to unregister it when \
the web application was stopped. To prevent a memory leak, the JDBC Driver has been \
forcibly unregistered.</div> <div><span class="Apple-tab-span" \
style="white-space:pre"></span>Oct 29, 2012 1:46:22 PM \
org.apache.catalina.loader.WebappClassLoader clearReferencesThreads</div> <div><span \
class="Apple-tab-span" style="white-space:pre"></span>SEVERE: A web application \
appears to have started a thread named [RHN Message Dispatcher] but has failed to \
stop it. This is very likely to create a memory leak.</div> <div><span \
class="Apple-tab-span" style="white-space:pre"></span>Oct 29, 2012 1:46:22 PM \
org.apache.catalina.loader.WebappClassLoader clearThreadLocalMap</div> <div><span \
class="Apple-tab-span" style="white-space:pre"></span>SEVERE: A web application \
created a ThreadLocal with key of type [null] (value \
[com.redhat.rhn.common.hibernate.ConnectionManager$1@13742ad8]) and a value of type \
[null] (value [null]) but failed to remove it when the web application was <span \
class="Apple-tab-span" style="white-space:pre"> </span>stopped. To prevent a memory \
leak, the ThreadLocal has been forcibly removed.</div> <div><br>
</div>
<div><br>
</div>
<div>Thanks,</div>
<div>Andy</div>
<div>
<div>
<div>
<div><br>
</div>
<div>Andy Ingham</div>
<div>IT Infrastructure</div>
<div>Fuqua School of Business</div>
<div>Duke University</div>
<div><br>
</div>
</div>
</div>
</div>
<div><br>
</div>
</div>
<div><br>
</div>
<span id="OLK_SRC_BODY_SECTION">
<div style="font-family:Calibri; font-size:11pt; text-align:left; color:black; \
BORDER-BOTTOM: medium none; BORDER-LEFT: medium none; PADDING-BOTTOM: 0in; \
PADDING-LEFT: 0in; PADDING-RIGHT: 0in; BORDER-TOP: #b5c4df 1pt solid; BORDER-RIGHT: \
medium none; PADDING-TOP: 3pt"> <span style="font-weight:bold">From: </span>Andy \
Ingham <<a href="mailto:andy.ingham@duke.edu">andy.ingham@duke.edu</a>><br> \
<span style="font-weight:bold">Date: </span>Wednesday, October 24, 2012 12:16 PM<br> \
<span style="font-weight:bold">To: </span>"<a \
href="mailto:spacewalk-list@redhat.com">spacewalk-list@redhat.com</a>" <<a \
href="mailto:spacewalk-list@redhat.com">spacewalk-list@redhat.com</a>><br> <span \
style="font-weight:bold">Subject: </span>Re: [Spacewalk-list] rhntaskorun issues<br> \
</div> <div><br>
</div>
<div>
<div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: \
after-white-space; color: rgb(0, 0, 0); font-family: Calibri, sans-serif; "> \
<div><span class="Apple-style-span" style="font-size: 15px; ">Folks --</span></div> \
<div><span class="Apple-style-span" style="font-size: 15px;"><br> </span></div>
<div><span class="Apple-style-span" style="font-size: 15px;">(Beth and I work in the \
same office)</span></div> <div><span class="Apple-style-span" style="font-size: \
15px;"><br> </span></div>
<div><span class="Apple-style-span" style="font-size: 15px;">We believe that we \
traced the pgsql problem (below) to some iSCSI connection issues. \
Unfortunately, since we did not have a usable database dump, we ended up having \
to do the following:</span></div> <div><span class="Apple-style-span" \
style="font-size: 15px;"><br> </span></div>
<div>
<p class="MsoNormal" style="margin-top: 0in; margin-right: 0in; margin-left: 0in; \
margin-bottom: 0.0001pt; font-family: Calibri, sans-serif; "> <span \
class="Apple-tab-span" style="white-space:pre"></span>from the spaceschema \
database:<o:p></o:p></p> <p class="MsoNormal" style="margin-top: 0in; margin-right: \
0in; margin-left: 0in; margin-bottom: 0.0001pt; font-family: Calibri, sans-serif; "> \
<o:p> </o:p></p> <p class="MsoNormal" style="margin-top: 0in; margin-right: 0in; \
margin-left: 0in; margin-bottom: 0.0001pt; font-family: Calibri, sans-serif; "> <span \
class="Apple-tab-span" style="white-space:pre"></span>truncate table \
rhntaskorun;<o:p></o:p></p> <p class="MsoNormal" style="margin-top: 0in; \
margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-family: Calibri, \
sans-serif; "> <o:p> </o:p></p>
<p class="MsoNormal" style="margin-top: 0in; margin-right: 0in; margin-left: 0in; \
margin-bottom: 0.0001pt; font-family: Calibri, sans-serif; "> <span \
class="Apple-tab-span" style="white-space: pre; "></span>(this was done *without* the \
cascade option, so only that table was truncated.)</p> <p class="MsoNormal" \
style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; \
font-family: Calibri, sans-serif; "> <br>
</p>
<p class="MsoNormal" style="margin-top: 0in; margin-right: 0in; margin-left: 0in; \
margin-bottom: 0.0001pt; font-family: Calibri, sans-serif; "> The good news is that \
we can now do SELECTS from all tables in the database without spectacular postgres \
crashes.</p> <p class="MsoNormal" style="margin-top: 0in; margin-right: 0in; \
margin-left: 0in; margin-bottom: 0.0001pt; font-family: Calibri, sans-serif; "> <br>
</p>
<p class="MsoNormal" style="margin-top: 0in; margin-right: 0in; margin-left: 0in; \
margin-bottom: 0.0001pt; font-family: Calibri, sans-serif; "> The bad news is that \
certain spacewalk functions are now broken (not surprisingly, due to the deletion of \
records above).</p> <p class="MsoNormal" style="margin-top: 0in; margin-right: 0in; \
margin-left: 0in; margin-bottom: 0.0001pt; font-family: Calibri, sans-serif; "> <br>
</p>
<p class="MsoNormal" style="margin-top: 0in; margin-right: 0in; margin-left: 0in; \
margin-bottom: 0.0001pt; font-family: Calibri, sans-serif; "> Specifically:</p>
<p class="MsoNormal" style="margin-top: 0in; margin-right: 0in; margin-left: 0in; \
margin-bottom: 0.0001pt; font-family: Calibri, sans-serif; "> <br>
</p>
<p class="MsoNormal" style="margin-top: 0in; margin-right: 0in; margin-left: 0in; \
margin-bottom: 0.0001pt; font-family: Calibri, sans-serif; "> <span \
class="Apple-tab-span" style="white-space:pre"></span>* going to <a \
href="https://our.spacewalk.server.edu/rhn/admin/SatSchedules.do">https://our.spacewalk.server.edu/rhn/admin/SatSchedules.do</a> results \
in "The scheduling service appears down. Please contact your Satellite \
administrator."</p> <p class="MsoNormal" style="margin-top: 0in; margin-right: \
0in; margin-left: 0in; margin-bottom: 0.0001pt; font-family: Calibri, sans-serif; "> \
<br> </p>
<p class="MsoNormal" style="margin-top: 0in; margin-right: 0in; margin-left: 0in; \
margin-bottom: 0.0001pt; font-family: Calibri, sans-serif; "> <span \
class="Apple-tab-span" style="white-space:pre"></span>* osa-dispatcher startup \
results in: Starting osa-dispatcher: RHN 2349 2012/10/24 11:14:23 -04:00: \
('Error caught:',)</p> <p class="MsoNormal" style="margin-top: 0in; margin-right: \
0in; margin-left: 0in; margin-bottom: 0.0001pt; font-family: Calibri, sans-serif; "> \
RHN 2349 2012/10/24 11:14:23 -04:00: ('Traceback (most recent call last):\n \
File "/usr/share/rhn/osad/jabber_lib.py", line 117, in main\n \
self.setup_config(config)\n File \
"/usr/share/rhn/osad/osa_dispatcher.py", line 112, in setup_config\n \
rhnSQL.initDB()\n File \
"/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/__init__.py", \
line 124, in initDB\n __init__DB(backend, host, port, username, \
password, database)\n File \
"/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/__init__.py", \
line 55, in __init__DB\n __DB.connect()\n File \
"/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py", \
line 171, in connect\n return self.connect(reconnect=0)\n File \
"/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py",
line 160, in connect\n password=self.password)\nSQLConnectError: \
(None, None, \'spaceschema\', \'Attempting Re-Connect to the database \
failed\')\n',)</p> <p class="MsoNormal" style="margin-top: 0in; margin-right: 0in; \
margin-left: 0in; margin-bottom: 0.0001pt; font-family: Calibri, sans-serif; "> <br>
</p>
<p class="MsoNormal" style="margin-top: 0in; margin-right: 0in; margin-left: 0in; \
margin-bottom: 0.0001pt; font-family: Calibri, sans-serif; "> <span \
class="Apple-tab-span" style="white-space:pre"></span>* \
the rhn_taskomatic_daemon.log shows, among other things: INFO | jvm \
1 | 2012/10/24 11:46:13 | WARNING: java.lang.NoClassDefFoundError: Could \
not initialize class net.sf.cglib.proxy.Enhancer</p> <p class="MsoNormal" \
style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; \
font-family: Calibri, sans-serif; "> <br>
</p>
<p class="MsoNormal" style="margin-top: 0in; margin-right: 0in; margin-left: 0in; \
margin-bottom: 0.0001pt; font-family: Calibri, sans-serif; "> <span \
class="Apple-tab-span" style="white-space:pre"></span>* \
the rhn_server_xmlrpc.log shows, among other things: 2012/10/24 11:53:23 \
-04:00 6184 10.148.42.65: server/rhnChannel.guess_channels_for_server('ERROR', 'No \
available channels for (server, org)', (1000010031, 1), '6.3', \
'x86_64-redhat-linux')</p> <p class="MsoNormal" style="margin-top: 0in; margin-right: \
0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: \
Calibri, sans-serif; "> <o:p></o:p></p>
<p class="MsoNormal" style="margin-top: 0in; margin-right: 0in; margin-left: 0in; \
margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "> \
<o:p> </o:p></p> <p class="MsoNormal" style="margin-top: 0in; margin-right: 0in; \
margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, \
sans-serif; "> <o:p><br>
</o:p></p>
<p class="MsoNormal" style="margin-top: 0in; margin-right: 0in; margin-left: 0in; \
margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "> \
<o:p>My questions:</o:p></p> <p class="MsoNormal" style="margin-top: 0in; \
margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; \
font-family: Calibri, sans-serif; "> <o:p><span class="Apple-tab-span" \
style="white-space:pre"></span>(1) Any chance that a "stock" set of \
records might be available somewhere for re-populating the </o:p>rhntaskorun \
table?</p> <p class="MsoNormal" style="margin-top: 0in; margin-right: 0in; \
margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, \
sans-serif; "> <br>
</p>
<p class="MsoNormal" style="margin-top: 0in; margin-right: 0in; margin-left: 0in; \
margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "> <span \
class="Apple-tab-span" style="white-space:pre"></span>(2) Any advice on the \
other errors noted above? (Assuming they aren't just red herrings).</p> <p \
class="MsoNormal" style="margin-top: 0in; margin-right: 0in; margin-left: 0in; \
margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "> \
<o:p><br> </o:p></p>
<p class="MsoNormal" style="margin-top: 0in; margin-right: 0in; margin-left: 0in; \
margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "> \
<o:p>Many thanks in advance.</o:p></p> <p class="MsoNormal" style="margin-top: 0in; \
margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; \
font-family: Calibri, sans-serif; "> <o:p><br>
</o:p></p>
<p class="MsoNormal" style="margin-top: 0in; margin-right: 0in; margin-left: 0in; \
margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "> \
<o:p>Andy</o:p></p> <p class="MsoNormal" style="margin-top: 0in; margin-right: 0in; \
margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, \
sans-serif; "> <o:p></o:p></p>
<div>
<div>
<div><br>
</div>
<div>Andy Ingham</div>
<div>IT Infrastructure</div>
<div>Fuqua School of Business</div>
<div>Duke University</div>
<div><br>
</div>
</div>
</div>
<p></p>
<p class="MsoNormal" style="margin-top: 0in; margin-right: 0in; margin-left: 0in; \
margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "> \
<o:p><br> </o:p></p>
</div>
<div style="font-size: 14px; "><br>
</div>
<span id="OLK_SRC_BODY_SECTION" style="font-size: 14px; ">
<div style="font-family:Calibri; font-size:11pt; text-align:left; color:black; \
BORDER-BOTTOM: medium none; BORDER-LEFT: medium none; PADDING-BOTTOM: 0in; \
PADDING-LEFT: 0in; PADDING-RIGHT: 0in; BORDER-TOP: #b5c4df 1pt solid; BORDER-RIGHT: \
medium none; PADDING-TOP: 3pt"> <span style="font-weight:bold">From: </span>Elizabeth \
Good <<a href="mailto:elizabeth.good@duke.edu">elizabeth.good@duke.edu</a>><br> \
<span style="font-weight:bold">Reply-To: </span>"<a \
href="mailto:spacewalk-list@redhat.com">spacewalk-list@redhat.com</a>" <<a \
href="mailto:spacewalk-list@redhat.com">spacewalk-list@redhat.com</a>><br> <span \
style="font-weight:bold">Date: </span>Tuesday, October 23, 2012 9:57 AM<br> <span \
style="font-weight:bold">To: </span>"<a \
href="mailto:spacewalk-list@redhat.com">spacewalk-list@redhat.com</a>" <<a \
href="mailto:spacewalk-list@redhat.com">spacewalk-list@redhat.com</a>><br> <span \
style="font-weight:bold">Subject: </span>[Spacewalk-list] rhntaskorun issues<br> \
</div> <div><br>
</div>
<div xmlns:v="urn:schemas-microsoft-com:vml" \
xmlns:o="urn:schemas-microsoft-com:office:office" \
xmlns:w="urn:schemas-microsoft-com:office:word" \
xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" \
xmlns="http://www.w3.org/TR/REC-html40"> <meta name="Generator" content="Microsoft \
Word 14 (filtered medium)"> <style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal">Hello,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I’m reposting this in the hopes that someone has run across a \
similar issue with the rhntaskorun table. Spacewalk is down when I’ve performed \
the following actions. As far as we can tell it is not a problem with our \
disks. <o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">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:<o:p></o:p></p> <p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">pg_dump: Dumping the contents of table "rhntaskorun" \
failed: PQgetCopyData() failed.<o:p></o:p></p> <p class="MsoNormal">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;<o:p></o:p></p> <p \
class="MsoNormal">pg_dump: *** aborted because of error<o:p></o:p></p> <p \
class="MsoNormal"><o:p> </o:p></p> <p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">In addition, selecting from the rhntaskorun also causes \
issues. <o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">All the postgresql processes go down when I do the select or run \
a pg_dump, with the exception of the postmaster and logger processes. <o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thanks,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Beth<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
</div>
</span></div>
</div>
</span>
</body>
</html>
_______________________________________________
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list
--===============6762648831682082826==--
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic