Description of problem: original Post from Greg Kuchyt on Maillist I have a clean Spacewalk setup installed on F12 (x86_64) using Oracle (Enterprise edition) 10.2.0.1.0 (64-bit) as the backend. I've created a channel and when I attempt to add packages via reposync or rhnpush I get the below error for every package attempted to be added. This is in a clean database, on a clean Spacewalk install. I've had Spacewalk working perfectly before, so I have to believe that I'm doing something wrong. Anyone have any ideas as to what is/could be going on here? Thanks in advance for any light anyone can be shed on this. 45/19122 : perl-Time-Duration-1.06-6.fc12-0.noarch ERRORException reported from xxxxxxxx.potsdam.edu Time: Mon Jan 4 15:45:20 2010 Exception type <class 'common.rhnException.rhnFault'> Exception Handler Information Traceback (most recent call last): File "/usr/share/rhn/satellite_tools/reposync.py", line 145, in import_packages self.upload_package(pack, path) File "/usr/share/rhn/satellite_tools/reposync.py", line 170, in upload_package org_id=self.channel['org_id']) File "/usr/share/rhn/server/rhnPackageUpload.py", line 168, in push_package 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 308, in submit transactional=self.transactional) File "/usr/share/rhn/server/importlib/backend.py", line 742, in processPackages transactional=transactional) File "/usr/share/rhn/server/importlib/backend.py", line 1601, in __processObjectCollection__ return self.__doDML(dml) File "/usr/share/rhn/server/importlib/backend.py", line 1709, in __doDML self.__doInsert(dml.insert, dml.tables) File "/usr/share/rhn/server/importlib/backend.py", line 1718, in __doInsert raise rhnFault(54, str(e[1]), explain=0) rhnFault: (54, 'ORA-01861: literal does not match format string\n', '\n Package Upload Failed due to uniqueness constraint violation.\n Make sure the package does not have any duplicate dependencies or\n does not already exists on the server\n ') Version-Release number of selected component (if applicable): spacewalk-backend-tools-0.7.18-1.fc12.noarch How reproducible: every time i start spacewalk-repo-sync Expected results: fix or patch
Bug summary: In Fedora 12 time values from rpm are interpreted as long (not int) which causes they aren't been transofmed into oracle's datetime format.
Fixed in commit ba25dcbb0ba53a0104f1738e60d15cf437835b4f Automatic commit of package [spacewalk-backend] release [0.8.32-1]. commit 74b827fecaa4178bf98ead2df5938859fef5c522 556460 - time values are <long> on F12 and included into spacewalk-backend-0.8.32-1 package.
Running into the same issue here, nice to see that it's already fixed! When will the updated package be available in the updates repository? Or is it already available elsewhere?
(In reply to comment #3) > Running into the same issue here, nice to see that it's already fixed! When > will the updated package be available in the updates repository? Or is it > already available elsewhere? There is a fixed package released in nightly repo. Unfortunately we do not currently plan any update release for 0.7 so please apply manually fix from the commit 74b827fecaa4178bf98ead2df5938859fef5c522 above.
I tried to apply the fix manually. This only partially works, because this specific file is already changed to some degree since the version in release 0.7, so the patch doesn't fully apply. Nevertheless, I was able to apply three of the four changes (the fourth change is in a piece of code that doesn't seem to exist yet in 0.7, if I'm not mistaking). However I keep getting the same results. First I simply scheduled a new sync, which gave the same errors. Then I thought, maybe the error is already in the database, so I deleted the channel and re-created it; but even then reposync gave the same errors. On a side note, I notice that I cannot stop reposync through the spacewalk webinterface, right? I especially noticed that spacewalk also doesn't stop a running reposync when its channel gets deleted... Anyway, I would really like to run spacewalk with a Fedora 12 repository, what is the best way to do this, upgrade to the nightly builds?
Created attachment 386316 [details] This is patch for spacewalk 0.7 Hi Erik, here is a patch backport for spacewalk 0.7. Apply with cd /usr/share/rhn/ patch -p2 <sw7.patch
Spacewalk 0.8 has been released