Bug 1063821

+++ This bug was initially created as a clone of Bug #1020965 +++

Description of problem:
after moving a set of 537 systems from one custom channel with
no errata to another custom channel with no errata, deadlocks
are raised and database space consumption raises exponentially

Version-Release number of selected component (if applicable):
Spacewalk 2.0

How reproducible:
At random

Steps to Reproduce:
1. sync in a custom channel, importing it from an external repository
2. change a set of systems from one channel to the other

Actual results:
Three types of deadlock show:
......................................
CEST ERROR:  deadlock detected
CEST DETAIL:  Process 24953 waits for ShareLock on transaction 37577; blocked by process 27459.
        Process 27459 waits for ShareLock on transaction 37227; blocked by process 24953.
        Process 24953: select * from rhn_channel.update_needed_cache($1) as result
        Process 27459: select * from rhn_channel.update_needed_cache($1) as result
......................................
CEST ERROR:  deadlock detected
CEST DETAIL:  Process 5455 waits for ShareLock on transaction 44101; blocked by process 27458.
        Process 27458 waits for ShareLock on transaction 43490; blocked by process 5455.
        Process 5455: select * from rhn_channel.subscribe_server($1, $2, 1, $3) as result
        Process 27458: select * from rhn_channel.update_needed_cache($1) as result
CEST HINT:  See server log for query details.
CEST CONTEXT:  SQL statement "UPDATE rhnServer SET channels_changed = current_timestamp WHERE id =  $1 "
        PL/pgSQL function "subscribe_server" line 95 at SQL statement
......................................
CEST ERROR:  deadlock detected
CEST DETAIL:  Process 22496 waits for ShareLock on transaction 50017; blocked by process 22509.
        Process 22509 waits for ShareLock on transaction 50004; blocked by process 22496.
        Process 22496: select * from rhn_channel.update_needed_cache($1) as result
        Process 22509: select * from rhn_channel.unsubscribe_server($1, $2) as result
CEST HINT:  See server log for query details.
CEST CONTEXT:  SQL statement "SELECT 1 FROM ONLY "public"."rhnserver" x WHERE "id" OPERATOR(pg_catalog.=) $1 FOR SHARE OF x"
        SQL statement "insert into rhnServerNeededCache (server_id, errata_id, package_id) (select distinct sp.server_id, x.errata_id, p.id FROM (SELECT sp_sp.server_id, sp_sp.name_id, sp_sp.package_arch_id, max(sp_pe.evr) AS max_evr FROM rhnServerPackage sp_sp join rhnPackageEvr sp_pe ON sp_pe.id = sp_sp.evr_id GROUP BY sp_sp.server_id, sp_sp.name_id, sp_sp.package_arch_id) sp join rhnPackage p ON p.name_id = sp.name_id join rhnPackageEvr pe ON pe.id = p.evr_id AND sp.max_evr < pe.evr join rhnPackageUpgradeArchCompat puac ON puac.package_arch_id = sp.package_arch_id AND puac.package_upgrade_arch_id = p.package_arch_id join rhnServerChannel sc ON sc.server_id = sp.server_id join rhnChannelPackage cp ON cp.package_id = p.id AND cp.channel_id = sc.channel_id left join (SELECT ep.errata_id, ce.channel_id, ep.package_id FROM rhnChannelErrata ce join rhnErrataPackage ep ON ep.errata_id = ce.errata_id join rhnServerChannel sc_sc ON sc_sc.channel_id = ce.channel_id WHERE sc_sc.server_id =  $1 ) x ON x.channel_id = sc.channel_id AND x.package_id = cp.package_id where sp.server_id =  $1 )"
......................................

Expected results:
no deadlocks

Additional info:
N/A