Bug 485127 - RFE to increase column size for rhnSourceRPM
Summary: RFE to increase column size for rhnSourceRPM
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Spacewalk
Classification: Community
Component: Server
Version: 0.4
Hardware: All
OS: Linux
medium
medium
Target Milestone: ---
Assignee: Jeff Ortel
QA Contact: Jesus M. Rodriguez
URL:
Whiteboard:
Depends On:
Blocks: space05
TreeView+ depends on / blocked
 
Reported: 2009-02-11 18:43 UTC by Jeff Ortel
Modified: 2009-09-17 07:10 UTC (History)
3 users (show)

Fixed In Version:
Clone Of: 480024
Environment:
Last Closed: 2009-09-17 07:10:15 UTC
Embargoed:


Attachments (Terms of Use)

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.


Note You need to log in before you can comment on or make changes to this bug.