[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