[Spacewalk-list] Deadlock while publishing errata

[Maxime VEROONE]

Hi,

I have recently reorganized my systems/channels layout which led to "bigger" channels (highest has ~200 systems subscribed)
Since then, my nightly errata update using CEFS randomly fails while publishing errata due to a deadlock issue.

Browsing postgresql logs shows this :
2015-08-24 07:16:04.973 CEST ERROR:  deadlock detected
2015-08-24 07:16:04.973 CEST DETAIL:  Process 14035 waits for ShareLock on transaction 28449435; blocked by process 13058.
        Process 13058 waits for ShareLock on transaction 28449406; blocked by process 14035.
        Process 14035: UPDATE rhnTaskQueue
                        SET earliest = $1
                        WHERE task_data = $2
        Process 13058: select * from rhn_channel.update_needed_cache($1) as result

This seem to be a different bug than https://bugzilla.redhat.com/show_bug.cgi?id=1234604 and affiliates, which concerns rhn_>server<.update_needed_cache()
>From what I see, although not being a code expert, the only thing that executes the first query is the method channelSoftware.scheduleErrataCacheUpdate(org,channel,delay), so my guess would be that something deadlocks with itself...

Is it possible that I have some sort of corruption, or should I file a bug to redhat ?
(Unless this bug has already been filed, but I failed to find something similar)

Code sources :
Rhn_channel.update_needed_cache(channel_id) : https://github.com/spacewalkproject/spacewalk/blob/c4fd15d05a781cc65c5be4b6e1f1623facd5e7d1/schema/spacewalk/oracle/packages/rhn_channel.pkb
Queue_server(server_id, immediate) : https://github.com/spacewalkproject/spacewalk/blob/7ba700f07acebfac6612e9a6cf2dcf942a4e1ecc/schema/spacewalk/oracle/procs/queue_server.sql
channelSoftwareHandler.java :
https://github.com/spacewalkproject/spacewalk/blob/219911a2727090ac775fc0156e24867626df49be/java/code/src/com/redhat/rhn/frontend/xmlrpc/channel/software/ChannelSoftwareHandler.java

Thanks,
Maxime Veroone
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20150824/74200c2c/attachment.htm>