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

Michiel van Es michiele at info.nl
Tue May 12 11:43:34 UTC 2009



Milan Zazrivec wrote:
> On Tuesday 12 May 2009 13:34:15 Milan Zazrivec wrote:
>> On Tuesday 12 May 2009 13:25:49 Michiel van Es wrote:
>>> Hi,
>>>
>>> I am running Oracle XE on a diffirent server then the spacewalk server.
>>> When I run the oracle schema upgrade script, I get:
>>>
>>> [root at devmx01 tmp]# /usr/bin/spacewalk-schema-upgrade
>>> Unknown schema name [no rows selected] found.
>>>
>>> I am following the https://fedorahosted.org/spacewalk/wiki/HowToUpgrade
>>> manual.
>>>
>>> What am I doing wrong?
>> The problem here is that the previous schema upgrade (something -> 0.4)
>> probably failed.
> 
> ... in which case you should have a log from the upgrade somewhere in
> /var/log/spacewalk/schema-upgrade/
> 
> If that's your case, can you please post the failed part here ...
> 
> Thanks
> -Milan
> 

Well I had the bug on https://bugzilla.redhat.com/show_bug.cgi?id=480618
and manually fixed it.

Hmm there is no logfile written in /var/log/spacewalk/schema-upgrade:

[root at devmx01 tmp]# cd /var/log/spacewalk/schema-upgrade/
[root at devmx01 schema-upgrade]# ls
20081010-123642-begin.log                    20081114-142217-end.log
20081010-123642-end.log                      20081114-142217-script.sql
20081010-123642-script.sql
20081114-142217-to-spacewalk-schema-0.3.log
20081010-123642-to-spacewalk-schema-0.2.log  20090119-165316-begin.log
20081114-140312-begin.log                    20090119-165316-script.sql
20081114-140312-script.sql
20090119-165316-to-spacewalk-schema-0.4.log
20081114-142217-begin.log
[root at devmx01 schema-upgrade]# ls -rot
total 1188
-rw-r--r-- 1 root 376515 Oct 10  2008 20081010-123642-script.sql
-rw-r--r-- 1 root    332 Oct 10  2008 20081010-123642-begin.log
-rw-r--r-- 1 root 476432 Oct 10  2008
20081010-123642-to-spacewalk-schema-0.2.log
-rw-r--r-- 1 root    334 Oct 10  2008 20081010-123642-end.log
-rw-r--r-- 1 root   4678 Nov 14 14:03 20081114-140312-script.sql
-rw-r--r-- 1 root    277 Nov 14 14:03 20081114-140312-begin.log
-rw-r--r-- 1 root   4678 Nov 14 14:22 20081114-142217-script.sql
-rw-r--r-- 1 root    332 Nov 14 14:22 20081114-142217-begin.log
-rw-r--r-- 1 root   8232 Nov 14 14:22
20081114-142217-to-spacewalk-schema-0.3.log
-rw-r--r-- 1 root    334 Nov 14 14:22 20081114-142217-end.log
-rw-r--r-- 1 root 127915 Jan 19 16:53 20090119-165316-script.sql
-rw-r--r-- 1 root    381 Jan 19 16:53 20090119-165316-begin.log
-rw-r--r-- 1 root 157806 Jan 19 16:53
20090119-165316-to-spacewalk-schema-0.4.log

What can be done now?

Kind regards,

Michiel

> _______________________________________________
> 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/2d1bea5f/attachment.sig>


More information about the Spacewalk-list mailing list