[Spacewalk-list] Deadlock while publishing errata

[Maxime VEROONE]

On 25/08/2015 08:46, Silvio Moioli wrote :
>On 24/08/2015 09:44, Maxime VEROONE wrote:
>> 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…
>
>Well, rhn_channel.update_needed_cache() indirectly calls rhn_server.update_needed_cache() so the fix mentioned in the bug report might very well help in your case.
>
>I guess your only options are to wait until Spacewalk 2.4, to try out the nightly builds or to apply the patch manually to your database schema.

Indeed , I made the rhn_channel.update_needed_cache async by replacing the call to rhn_server.update_needed_cache) to a queue_server() call 
as suggested in the commits, and it seem to resolve the issue, while we wait for release 2.4

Thanks for your inputs,

Maxime Veroone