<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META content="text/html; charset=us-ascii" http-equiv=Content-Type> <META name=GENERATOR content="MSHTML 8.00.6001.18828"></HEAD> <BODY> <DIV dir=ltr align=left>here's the sql its executing when that error pops up</DIV> <DIV dir=ltr align=left> 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 *</DIV> <DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left> <HR tabIndex=-1> From: spacewalk-list-bounces@redhat.com [mailto:spacewalk-list-bounces@redhat.com] On Behalf Of Frey, Evan Sent: Tuesday, February 16, 2010 8:33 AM To: spacewalk-list@redhat.com Subject: [Spacewalk-list] Error during schema upgrade </DIV> <DIV></DIV> <DIV>I am trying to upgrade from .7 to .8 and during the schema upgrade I get the following:</DIV> <DIV> ERROR at line 1: ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDO' ORA-06512: at line 31</DIV> <HR> 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). <HR> <DIV></DIV></BODY></HTML> <HTML><BODY><hr>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). <hr></div></BODY></HTML>