Hi all, I've been trying to configure a production instance of spacewalk after testing the system on my test servers for the past week. 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. I'm finding this very reproducible at this stage... Process: 1, Install oraclexe and spacewalk as per the installation instructions. 2. Create an admin account. 3. Create a repository for the RHEL5 base images; 4. Run: /usr/bin/spacewalk-repo-sync --channel=rhel5-base --url=http://<server>/apt/redhat/ES5.3/en/x86_64/RPMS.os --type=yum --label='basepackages' to load the base packages from my current yum repository. After approx 500 packages I get an error as follows: ERRORException reported from XXXXXX Time: Sun Oct 25 17:40:39 2009 Exception type common.rhnException.rhnFault Exception Handler Information Traceback (most recent call last): File "/usr/share/rhn/satellite_tools/reposync.py", line 142, in import_packages self.associate_package(pack, md5) File "/usr/share/rhn/satellite_tools/reposync.py", line 199, in associate_package self._importer_run(package, caller, backend) File "/usr/share/rhn/satellite_tools/reposync.py", line 207, in _importer_run importer.run() File "/usr/share/rhn/server/importlib/importLib.py", line 628, in run self.submit() File "/usr/share/rhn/server/importlib/packageImport.py", line 123, in submit affected_channels=self.affected_channel_packages) File "/usr/share/rhn/server/importlib/backend.py", line 1328, in update_newest_package_cache raise rhnFault(23, str(e[1]), explain=0) 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.') 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: [Sun Oct 25 17:28:11 2009] [error] (111)Connection refused: proxy: AJP: attempt to connect to 127.0.0.1:8009 (*) failed [Sun Oct 25 17:28:11 2009] [error] proxy: AJP: failed to make connection to backend: localhost In this instance the above error was preceeded by: Exception Handler Information Traceback (most recent call last): File "/usr/share/rhn/satellite_tools/reposync.py", line 142, in import_packages self.associate_package(pack, md5) File "/usr/share/rhn/satellite_tools/reposync.py", line 199, in associate_package self._importer_run(package, caller, backend) File "/usr/share/rhn/satellite_tools/reposync.py", line 207, in _importer_run importer.run() File "/usr/share/rhn/server/importlib/importLib.py", line 628, in run self.submit() File "/usr/share/rhn/server/importlib/packageImport.py", line 123, in submit affected_channels=self.affected_channel_packages) File "/usr/share/rhn/server/importlib/backend.py", line 1328, in update_newest_package_cache raise rhnFault(23, str(e[1]), explain=0) 1131\nORA-06512: at line 1\n', 'Could not update database entry.') Any pointers as to how to find and fix this problem would be greatly appreciated. J.
The issue seems not to be anymore present in current Spacewalk (0.8). Closing; feel free to reopen if you have any aditional info.