Bug 485127

Summary: RFE to increase column size for rhnSourceRPM
Product: [Community] Spacewalk Reporter: Jeff Ortel <jortel>
Component: ServerAssignee: Jeff Ortel <jortel>
Status: CLOSED CURRENTRELEASE QA Contact: Jesus M. Rodriguez <jesusr>
Severity: medium Docs Contact:
Priority: medium    
Version: 0.4CC: bperkins, tao, xdmoon
Target Milestone: ---   
Target Release: ---   
Hardware: All   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: 480024 Environment:
Last Closed: 2009-09-17 07:10:15 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On:    
Bug Blocks: 456553    

Description Jeff Ortel 2009-02-11 18:43:24 UTC
Exception Handler Information
Traceback (most recent call last):
 <snip>
   self.backend.lookupSourceRPMs(self.sourceRPMs)
 File "/usr/share/rhn/server/importlib/backend.py", line 377, in
lookupSourceRPMs
   self.__processHash('rhnSourceRPM', 'name', hash)
 File "/usr/share/rhn/server/importlib/backend.py", line 953, in
__processHash
   h.executemany(id=ids, value=values)
 File "/usr/share/rhn/server/rhnSQL/int_oracle.py", line 103, in
executemany
   return apply(self._execute_wrapper, (self._executemany, ) + p, kw)
 File "/usr/share/rhn/server/rhnSQL/int_oracle.py", line 132, in
_execute_wrapper
   raise apply(sql_base.SQLError, ret)
SQLError: (1401, 'ORA-01401: inserted value too large for columnn',
'insert into rhnSourceRPM (id, name) values (:id, :value)')

The sql table looks as such:

SQL> desc rhnSourceRPM
Name                                      Null?    Type
----------------------------------------- --------
ID                                        NOT NULL NUMBER
NAME                                      NOT NULL VARCHAR2(128)

Please increase the maximum values for this and other tables in RHN that
deal with RPM names.


How reproducible:

Always.

Steps to Reproduce:
1. rhn_push a package with a name larger then 128 characters.
2.
3.
  
Actual results:

Raises exception ^^


Expected results:

Should just work.


Additional info:

Comment 1 Jeff Ortel 2009-02-11 18:56:54 UTC
Increased the 'name' column in rhnSourceRPM and rhnPackageName tables to 256.  Not knowing how much larger this needs to be, I just doubled it.

git commit: 95c6226..f5c803d

Comment 2 Shannon Hughes 2009-02-20 20:47:56 UTC
*** Bug 480252 has been marked as a duplicate of this bug. ***

Comment 7 Jesus M. Rodriguez 2009-04-14 14:13:02 UTC
Spacewalk 0.5 released.

Comment 8 Miroslav Suchý 2009-09-17 07:10:15 UTC
Spacewalk 0.5 has been released for long time ago.