[Spacewalk-list] deleting packages

[Marcus Moeller]

Dear David,

>> we got now about 60.000 packages in no channel (due to deletion of old
>> Fedora releases). It is not possible to delete them, neither via gui
>> nor via api (which stucks during
>> channel.software.listPackagesWithoutChannel either with a 502 Proxy
>> Error, a connection timeout or a 500 Internal Server Error). Any idea
>> how to get rid of these packages?

> When deleting old releases I find I have to do them bit by bit rather
> than all at once. I've encountered two errors caused by trying to
> delete large numbers of packages all at once and leading to a 500
> error. Never seen a 502 in this situation though. The errors are

The problem is that even one Fedora channel contains so many of
packages (12'000+ ) that the limit seems to be exceed.

> 1) Oracle's UNDO tablespace is exhausted. Give it some more, this

I guess 500GB UNDO tablespace should be enough :?

>   doesn't count to your 4Gb limit
> 2) The delete process itself takes too long to run, and causes a
>   timeout. This is the situation where deleting in small batches may
>   help.

Deleting packages in 25 steps might take a long time if you have about 60'000 :/

-- 
Greets
Marcus