[Spacewalk-list] Error during schema upgrade

[Frey, Evan]

here's the sql its executing when that error pops up
SQL> declare

2 md5_id number;

3 min_pid number;

4 max_pid number;

5 lmin number;

6 lmax number;

7 begin

8 select id

9 into md5_id

10 from rhnChecksumType

11 where label = 'md5';

12

13 select min(package_id), max(package_id)

14 into min_pid, max_pid

15 from rhnPackageFile;

16

17 lmin := min_pid;

18 lmax := lmin + 99999;

19 while lmin < max_pid loop

20 insert into rhnChecksum (id, checksum_type_id, checksum)

21 (select rhnChecksum_seq.nextval, md5_id, csum

22 from (select distinct md5 as csum

23 from rhnPackageFile

24 where package_id between lmin and lmax

25 and md5 is not null

26 minus

27 select checksum as csum

28 from rhnChecksum

29 where checksum_type_id = md5_id));

30 commit;

31 update rhnPackageFile p

32 set checksum_id = (select id

33 from rhnChecksum c

34 where checksum_type_id = md5_id

35 and p.md5 = c.checksum)

36 where package_id between lmin and lmax

37 and md5 is not null;

38 commit;

39 lmin := lmax + 1;

40 lmax := lmin + 99999;

41 end loop;

42 end;

43 /

declare

*


________________________________

From: spacewalk-list-bounces at redhat.com
[mailto:spacewalk-list-bounces at redhat.com] On Behalf Of Frey, Evan
Sent: Tuesday, February 16, 2010 8:33 AM
To: spacewalk-list at redhat.com
Subject: [Spacewalk-list] Error during schema upgrade


I am trying to upgrade from .7 to .8 and during the schema upgrade I get the
following:

ERROR at line 1:

ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDO'

ORA-06512: at line 31

________________________________

CONFIDENTIAL: This e-mail, including its contents and attachments, if any,
are confidential. It is neither an offer to buy or sell, nor a solicitation
of an offer to buy or sell, any securities or any related financial
instruments mentioned in it. If you are not the named recipient please notify
the sender and immediately delete it. You may not disseminate, distribute, or
forward this e-mail message or disclose its contents to anybody else. Unless
otherwise indicated, copyright and any other intellectual property rights in
its contents are the sole property of Mizuho Securities USA Inc. 

E-mail transmission cannot be guaranteed to be secure or error-free. The
sender therefore does not accept liability for any errors or omissions in the
contents of this message which arise as a result of e-mail transmission. If
verification is required please request a hard-copy version.

Although we routinely screen for viruses, addressees should check this e-mail
and any attachments for viruses. We make no representation or warranty as to
the absence of viruses in this e-mail or any attachments. Please note that to
ensure regulatory compliance and for the protection of our customers and
business, we may monitor and read e-mails sent to and from our server(s). 

________________________________



CONFIDENTIAL: This e-mail, including its contents and attachments,
if any, are confidential. It is neither an offer to buy or sell,
nor a solicitation of an offer to buy or sell, any securities or
any related financial instruments mentioned in it. If you are not
the named recipient please notify the sender and immediately delete
it. You may not disseminate, distribute, or forward this e-mail
message or disclose its contents to anybody else. Unless otherwise
indicated, copyright and any other intellectual property rights in
its contents are the sole property of Mizuho Securities USA Inc.
     E-mail transmission cannot be guaranteed to be secure or
error-free. The sender therefore does not accept liability for any
errors or omissions in the contents of this message which arise as
a result of e-mail transmission.  If verification is required
please request a hard-copy version.
     Although we routinely screen for viruses, addressees should
check this e-mail and any attachments for viruses. We make no
representation or warranty as to the absence of viruses in this
e-mail or any attachments. Please note that to ensure regulatory
compliance and for the protection of our customers and business, we
may monitor and read e-mails sent to and from our server(s).
#####################################################################################
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20100216/3e861403/attachment.htm>