[Spacewalk-list] spacewalk-repo-sync errors

Mon Oct 25 12:42:13 UTC 2010

Problem fixed (nightly builds), but now getting the following for some isolated packages: 

Exception reported from remchuck5lt.li-sec.state.pa.us 
Time: Mon Oct 25 08:39:35 2010 
Exception type spacewalk.server.rhnSQL.sql_base.SQLError 
Exception while handling function server.apacheUploadServer._wrapper 
Request object information: 
URI: /PACKAGE-PUSH 
Remote Host: 127.0.0.1 
Server Name: remchuck5lt.li-sec.state.pa.us:0 
Headers passed in: 
Accept-Encoding: identity 
Content-Length: 372578 
Content-Type: application/x-rpm 
Host: localhost 
User-Agent: rhnpush 
X-RHN-Upload-Auth-Session: 88x1974c623ba21d62a0041fe2ca210a084 
X-RHN-Upload-File-Checksum: 28aee4609a4cd96bf9f35e8bd7a3a8bc 
X-RHN-Upload-File-Checksum-Type: md5 
X-RHN-Upload-File-MD5sum: 28aee4609a4cd96bf9f35e8bd7a3a8bc 
X-RHN-Upload-Force: 1 
X-RHN-Upload-Package-Arch: i386 
X-RHN-Upload-Package-Name: pacemaker-libs 
X-RHN-Upload-Package-Release: 6.1.el5 
X-RHN-Upload-Package-Version: 1.0.8 
X-RHN-Upload-Packaging: rpm 

Exception Handler Information 
Traceback (most recent call last): 
File "/usr/lib/python2.4/site-packages/spacewalk/server/apacheUploadServer.py", line 102, in _wrapper 
ret = function(req) 
File "/usr/share/rhn/upload_server/handlers/package_push/package_push.py", line 134, in handler 
relative_path=self.rel_package_path, org_id=self.org_id) 
File "/usr/lib/python2.4/site-packages/spacewalk/server/rhnPackageUpload.py", line 180, in push_package 
importer.run() 
File "/usr/lib/python2.4/site-packages/spacewalk/server/importlib/importLib.py", line 648, in run 
self.fix() 
File "/usr/lib/python2.4/site-packages/spacewalk/server/importlib/packageImport.py", line 301, in fix 
self.backend.processChangeLog(self.changelog_data) 
File "/usr/lib/python2.4/site-packages/spacewalk/server/importlib/backend.py", line 154, in processChangeLog 
h.executemany(id=toinsert[0], name=toinsert[1], time=toinsert[2], text=toinsert[3]) 
File "/usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/sql_base.py", line 175, in executemany 
return apply(self._execute_wrapper, (self._executemany, ) + p, kw) 
File "/usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/driver_cx_Oracle.py", line 118, in _execute_wrapper 
raise apply(sql_base.SQLError, ret) 
SQLError: (12899, 'ORA-12899: value too large for column "SPACEWALK"."RHNPACKAGECHANGELOGDATA"."TEXT" (actual: 3001, maximum: 3000)\n', 'insert into 
rhnPackageChangeLogData (id, name, time, text) values (:id, :name, :time, :text)') 

----- Original Message ----- 
From: "Jan Pazdziora" <jpazdziora at redhat.com> 
To: spacewalk-list at redhat.com 
Sent: Monday, October 25, 2010 5:34:40 AM 
Subject: Re: [Spacewalk-list] spacewalk-repo-sync errors 

On Fri, Oct 22, 2010 at 04:14:15PM -0700, DD W wrote: 
> 
> I just finished installing spacewalk 1.1 on a CentOS 5.5 system running with kernel 2.6.18-194.el5 early this week. Oracle-XE is the Database Engine. When I run spacewalk-repo-sync for the base I immediately receive the errors shown in the attached file. I received similar errors for the Updates channel also. The only package successfully downloaded so far is kdebase-3.5.4-20.el5.centos.i386.rpm found in the packages directory /var/cache/rhn/reposync/*base*/packages. Disabling selinux did not make any difference. 

Actually, I assume yours is not 1.1 but Spacewalk nightly. 

> I referenced the installation document https://fedorahosted.org/spacewalk/wiki/HowToInstall during the installation. I do not find anything when I use google to search for spacewalk-repo-sync and ORA-01460 or ORA-01003. The UI appears to be working correctly for both Oracle and Spacewalk. I was able to successfully create the channels and distribution entries. 
> 
> Any suggestions relative to this problem are gratefully appreciated. 
> 
> -D 
> 

> Repo http://mirror.centos.org/centos/5/os/i386/ has 2599 packages. 
> 1/2595 : libgcj-devel-4.1.2-48.el5-0.i386 
> (1460, 'ORA-01460: unimplemented or unreasonable conversion requested\n', 'select id from rhnPackageChangeLogData where name = :name and time = :time and text = :text') 

Please apply the following patch 

http://git.fedorahosted.org/git/?p=spacewalk.git;a=commitdiff;h=2c5621e6478f1b4433eb41ac3692f36d80ed5a77 

It will be in spacewalk-backend in Spacewalk nightly later today. 

Yours, 

-- 
Jan Pazdziora 
Principal Software Engineer, Satellite Engineering, Red Hat 

_______________________________________________ 
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/20101025/edb6a074/attachment.htm>