[Spacewalk-list] The request exceeds the maximum allowed database size of 4 GB\n

[Michael Mraka]

Gregory Machin wrote:
% Hi.
% 
% I'm reposync-ing 4 repositories and now I'm getting this " (12952,
% 'ORA-12952: The request exceeds the maximum allowed database size of 4
% GB\n', 'insert into rhnPackageCapability (id, name, version) values
% (:id, :name, :version)') " .
% I wouldn't haven't thought that meta data would have consumed 4G already .
% 
% I'm not going to get permission for a Licience for Oracle, how do I
% get this to work ? I did try the Postgresql but couldn't get it to
% install correctly due to issues in the sql install script and missing
% columns in the database ..
% 
% 
% How do I resolve this ?

https://fedorahosted.org/spacewalk/wiki/OracleXeSetup

  Troubleshooting

  If you run out of space in Oracle XE you can try and reclaim some space
  by shrinking your storage: 

  Administration > Storage > Compact Storage in XE webUI
  (http://your.satellite.tld:9055/apex/).

You can also prurge old data (channels and systems).

If nothing above helps you have to wait for upcomming Spacewalk 1.2 which
is going to significantly lower database size consumption. There also will
be improved PostgreSQL version; still not 100% ready but you can expect
decent stability somewhere between alfa and beta version.


Regards,

--
Michael Mráka
Satellite Engineering, Red Hat