Description of problem:

/usr/bin/spacewalk-schema-upgrade returns "Upgrade failed, please see log in [/var/log/spacewalk/schema-upgrade/]".  The file /var/log/spacewalk/schema-upgrade/20090119-074852-to-spacewalk-schema-0.4.log ends as follows:

   4199 SQL> alter TABLE rhnPackage MODIFY (compat number(1));
   4200 alter TABLE rhnPackage MODIFY (compat number(1))
   4201                                *
   4202 ERROR at line 1:       
   4203 ORA-01440: column to be modified must be empty to decrease precision or         scale 
   4204 
   4205 


Version-Release number of selected component (if applicable):

    Spacewalk 0.4


How reproducible:

    Do not know -- probably


Additional info:

This appears towards the end of the script:

   3586 alter TABLE rhnPackage MODIFY (compat number(1));
   3587 show errors
   3588 commit;
   3589         spool /var/log/spacewalk/schema-upgrade/20090119-074852-end.log         append
   3590         whenever sqlerror exit sql.sqlcode
   3591 
   3592         insert into rhnVersionInfo
   3593                 ( label, name_id, evr_id, created, modified )
   3594         values ('schema', lookup_package_name('spacewalk-schema'),
   3595                 lookup_evr(null, '0.4.17' , '1.el5' ),
   3596                 sysdate, sysdate );
   3597         commit;
   3598 quit;

As the remaining SQL code doesn't appear to rely on the rhnPackage table I ran those statements manually.  The column in question is in-use but doesn't seem to be storing anything of value:

SQL> select compat from rhnPackage group by compat;

    COMPAT
----------
	 0

SQL> select count(compat) from rhnPackage;

COUNT(COMPAT)
-------------
	12444

SQL> desc rhnPackage;
 Name					   Null?    Type
 ----------------------------------------- -------- ----------------------------
 ID					   NOT NULL NUMBER
[...]
 PAYLOAD_FORMAT 				    VARCHAR2(32)
 COMPAT 					    NUMBER(38)
 PATH						    VARCHAR2(1000)
[...]
 HEADER_END				   NOT NULL NUMBER