Hi all,<div><br></div><div>I've been trying to configure a production instance of spacewalk after testing the system on my test servers for the past week. </div><div><br></div><div>This is a clean install on a clean RHEL5 server, and I have carefully followed all of the installation instructions on the wiki several times to try and get around the error.</div> <div><br></div><div>I'm finding this very reproducible at this stage...</div><div><br></div><div>Process: </div><div><br></div><div>1, Install oraclexe and spacewalk as per the installation instructions.</div><div>2. Create an admin account.</div> <div>3. Create a repository for the RHEL5 base images;</div><div>4. Run:</div><div><br></div><div><div>/usr/bin/spacewalk-repo-sync --channel=rhel5-base --url=http://<server>/apt/redhat/ES5.3/en/x86_64/RPMS.os --type=yum --label='basepackages'</div> <div><br></div><div>to load the base packages from my current yum repository.</div><div><br></div><div>After approx 500 packages I get an error as follows:</div><div><font class="Apple-style-span" face="'times new roman', serif"><br> </font></div><div><div><font class="Apple-style-span" face="'times new roman', serif">ERRORException reported from XXXXXX</font></div><div><font class="Apple-style-span" face="'times new roman', serif">Time: Sun Oct 25 17:40:39 2009</font></div> <div><font class="Apple-style-span" face="'times new roman', serif">Exception type common.rhnException.rhnFault</font></div><div><font class="Apple-style-span" face="'times new roman', serif"><br></font></div> <div><font class="Apple-style-span" face="'times new roman', serif">Exception Handler Information</font></div><div><font class="Apple-style-span" face="'times new roman', serif">Traceback (most recent call last):</font></div> <div><font class="Apple-style-span" face="'times new roman', serif"> File "/usr/share/rhn/satellite_tools/reposync.py", line 142, in import_packages</font></div><div><font class="Apple-style-span" face="'times new roman', serif"> self.associate_package(pack, md5)</font></div> <div><font class="Apple-style-span" face="'times new roman', serif"> File "/usr/share/rhn/satellite_tools/reposync.py", line 199, in associate_package</font></div><div><font class="Apple-style-span" face="'times new roman', serif"> self._importer_run(package, caller, backend)</font></div> <div><font class="Apple-style-span" face="'times new roman', serif"> File "/usr/share/rhn/satellite_tools/reposync.py", line 207, in _importer_run</font></div><div><font class="Apple-style-span" face="'times new roman', serif"> importer.run()</font></div> <div><font class="Apple-style-span" face="'times new roman', serif"> File "/usr/share/rhn/server/importlib/importLib.py", line 628, in run</font></div><div><font class="Apple-style-span" face="'times new roman', serif"> self.submit()</font></div> <div><font class="Apple-style-span" face="'times new roman', serif"> File "/usr/share/rhn/server/importlib/packageImport.py", line 123, in submit</font></div><div><font class="Apple-style-span" face="'times new roman', serif"> affected_channels=self.affected_channel_packages)</font></div> <div><font class="Apple-style-span" face="'times new roman', serif"> File "/usr/share/rhn/server/importlib/backend.py", line 1328, in update_newest_package_cache</font></div><div><font class="Apple-style-span" face="'times new roman', serif"> raise rhnFault(23, str(e[1]), explain=0)</font></div> <div><font class="Apple-style-span" face="'times new roman', serif">rhnFault: (23, 'ORA-00001: unique constraint (SPACEWALK.RHN_CNP_CID_NID_UQ) violated\nORA-06512: at "SPACEWALK.RHN_CHANNEL", line 1131\nORA-06512: at line 1\n', 'Could not update database entry.')</font></div> <div><font class="Apple-style-span" face="'times new roman', serif"><br></font></div></div><div><font class="Apple-style-span" face="'times new roman', serif"><br></font></div><div>Once this occurs any operation to manipulate the DB fails with the same error via the UI and the command line. There are no errors shown in the oracle or tomcat logs, and the following error in the http log at around the same time which may or may not be related given this was also a fresh install:</div> <div><br></div><div><div>[Sun Oct 25 17:28:11 2009] [error] (111)Connection refused: proxy: AJP: attempt to connect to <a href="http://127.0.0.1:8009">127.0.0.1:8009</a> (*) failed</div><div>[Sun Oct 25 17:28:11 2009] [error] proxy: AJP: failed to make connection to backend: localhost</div> <div><br></div><div>In this instance the above error was preceeded by:</div><div><font class="Apple-style-span" face="'times new roman', serif"><br></font></div><div><div><font class="Apple-style-span" face="'times new roman', serif">Exception Handler Information</font></div> <div><font class="Apple-style-span" face="'times new roman', serif">Traceback (most recent call last):</font></div><div><font class="Apple-style-span" face="'times new roman', serif"> File "/usr/share/rhn/satellite_tools/reposync.py", line 142, in import_packages</font></div> <div><font class="Apple-style-span" face="'times new roman', serif"> self.associate_package(pack, md5)</font></div><div><font class="Apple-style-span" face="'times new roman', serif"> File "/usr/share/rhn/satellite_tools/reposync.py", line 199, in associate_package</font></div> <div><font class="Apple-style-span" face="'times new roman', serif"> self._importer_run(package, caller, backend)</font></div><div><font class="Apple-style-span" face="'times new roman', serif"> File "/usr/share/rhn/satellite_tools/reposync.py", line 207, in _importer_run</font></div> <div><font class="Apple-style-span" face="'times new roman', serif"> importer.run()</font></div><div><font class="Apple-style-span" face="'times new roman', serif"> File "/usr/share/rhn/server/importlib/importLib.py", line 628, in run</font></div> <div><font class="Apple-style-span" face="'times new roman', serif"> self.submit()</font></div><div><font class="Apple-style-span" face="'times new roman', serif"> File "/usr/share/rhn/server/importlib/packageImport.py", line 123, in submit</font></div> <div><font class="Apple-style-span" face="'times new roman', serif"> affected_channels=self.affected_channel_packages)</font></div><div><font class="Apple-style-span" face="'times new roman', serif"> File "/usr/share/rhn/server/importlib/backend.py", line 1328, in update_newest_package_cache</font></div> <div><font class="Apple-style-span" face="'times new roman', serif"> raise rhnFault(23, str(e[1]), explain=0)</font></div><div><font class="Apple-style-span" face="'times new roman', serif"> 1131\nORA-06512: at line 1\n', 'Could not update database entry.')</font></div> <div><br></div><div>Any pointers as to how to find and fix this problem would be greatly appreciated.</div><div><br></div><div>J.</div></div><div><br></div></div></div><div><br><div><br>-- <br>The era of procrastination, of half measures of soothing and baffling expedients, of delays, is coming to an end. In it's place we are entering a period of consequences. - Winston Churchill <br> <a href=<a href="http://www.climatecrisis.net/downloads/ecards/preview-glacier1.html">http://www.climatecrisis.net/downloads/ecards/preview-glacier1.html</a>>An Inconvenient Truth</a><br> </div></div>