[Spacewalk-list] question about upgrade 0.4 - 0.5 : Oracle schema upgrade failure

Michiel van Es michiele at info.nl
Tue May 12 12:23:31 UTC 2009


That did the trick! :)
Thanks!

I have only an error with jabber..I know there is a bug with Jabberd 2.2
but I still got the 2.0 version:


[root at devmx01 ~]# rpm -qa | grep jabber
jabberd-2.0s10-3.42.el5
jabberpy-0.5-0.17.el5
jabberd-selinux-1.4.0-6.el5



May 12 14:20:07 devmx01 jabberd/c2s[1335]: starting up
May 12 14:20:07 devmx01 jabberd/c2s[1335]: couldn't open
/var/lib/jabberd/pid/c2s.pid for writing: No such file or directory
May 12 14:20:07 devmx01 jabberd/c2s[1335]: db: couldn't open
environment: No such file or directory
May 12 14:20:07 devmx01 jabberd/c2s[1335]: failed to initialise auth
module 'db'
May 12 14:20:07 devmx01 jabberd/sm[1333]: starting up
May 12 14:20:07 devmx01 jabberd/sm[1333]: id: devmx01.buro.info.nl
May 12 14:20:07 devmx01 jabberd/sm[1333]: couldn't open
/var/lib/jabberd/pid/sm.pid for writing: No such file or directory
May 12 14:20:07 devmx01 jabberd/sm[1333]: db: couldn't open environment:
No such file or directory
May 12 14:20:07 devmx01 jabberd/sm[1333]: initialisation of storage
driver 'db' failed
May 12 14:20:07 devmx01 jabberd/sm[1333]: failed to initialise one or
more storage drivers, aborting
May 12 14:20:07 devmx01 jabberd/router[1331]: starting up
May 12 14:20:07 devmx01 jabberd/router[1331]: process id is 1331,
written to /var/run/jabberd/router.pid
May 12 14:20:07 devmx01 jabberd/resolver[1332]: starting up
May 12 14:20:07 devmx01 jabberd/router[1331]: loaded user table (1 users)
May 12 14:20:07 devmx01 jabberd/router[1331]: [0.0.0.0, port=5347]
listening for incoming connections
May 12 14:20:07 devmx01 jabberd/resolver[1332]: process id is 1332,
written to /var/run/jabberd/resolver.pid
May 12 14:20:07 devmx01 jabberd/router[1331]: shutting down
May 12 14:20:07 devmx01 jabberd/resolver[1332]: attempting connection to
router at 127.0.0.1, port=5347
May 12 14:20:07 devmx01 jabberd/resolver[1332]: shutting down
May 12 14:20:07 devmx01 jabberd/s2s[1334]: starting up (interval=3,
queue=60, keepalive=0, idle=86400)
May 12 14:20:07 devmx01 jabberd/s2s[1334]: couldn't open
/var/lib/jabberd/pid/s2s.pid for writing: No such file or directory
May 12 14:20:07 devmx01 jabberd/s2s[1334]: attempting connection to
router at 127.0.0.1, port=5347
May 12 14:20:07 devmx01 jabberd/s2s[1334]: shutting down


What can be wrong?

Kind regards,

Michiel

Milan Zazrivec wrote:
> On Tuesday 12 May 2009 13:45:15 Michiel van Es wrote:
>> The upgrade logfile from 0.3-0.4 (a couple of months old):
> [...]
>> SQL> alter TABLE rhnPackage MODIFY (compat number(1));
>> alter TABLE rhnPackage MODIFY (compat number(1))
>>                                *
>> ERROR at line 1:
>> ORA-01440: column to be modified must be empty to decrease precision or
>> scale
> 
> Please look into 20090119-165316-script.sql somewhere at the very
> end of the file, there should be an insert statement like this:
> 
> insert into rhnVersionInfo
>         ( label, name_id, evr_id, created, modified )
> ...
> commit;
> 
> Connect to your spacewalk database via sqlplus and run this whole insert
> + commit statement manually.
> 
> Given that you have manually updated rhnPackage table, this is one final
> step you have to do to make it look like a "successful" upgrade :-)
> 
> -Milan
> 
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 260 bytes
Desc: OpenPGP digital signature
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20090512/b27040a8/attachment.sig>


More information about the Spacewalk-list mailing list