Description of problem: deadlock occuring when satellite syncs starts to link the packages to channels. appears to be colliding when a system is engaging in a server snapshot. Will include the following tracebacks. Satellite is in a secure environment so still gathering data. schema is latest at satellite-schema-5.7.0.27-1.el6sat.noarch postgresql log below ------ 2017-04-19 10:38:34.868 MDT DETAIL: Process 11077 waits for ShareLock on transaction 79341667; blocked by process 10549. Process 10549 waits for ShareLock on transaction 79341638; blocked by process 11077. Process 11077: SELECT rhn_channel.refresh_newest_package(461, 'satsync.linkPackagesToChannels', NULL) Process 10549: SELECT rhn_server.snapshot_server(1000013026, 'Package profile changed') 2017-04-19 10:38:34.869 MDT HINT: See server log for query details. 2017-04-19 10:38:34.869 MDT CONTEXT: SQL statement "update rhnChannel set last_modified = greatest(current_timestamp, last_modified + interval '1 second') where id = channel_id_in" PL/pgSQL function rhn_channel.refresh_newest_package(numeric,character varying,numeric) line 21 at SQL statement 2017-04-19 10:38:34.869 MDT STATEMENT: SELECT rhn_channel.refresh_newest_package(461, 'satsync.linkPackagesToChannels', NULL) Process 11077 waits for ShareLock on transaction 79341667; blocked by process 10549. Process 10549: SELECT rhn_server.snapshot_server(1000013026, 'Package profile changed' -- Process 11077: SELECT rhn_channel.refresh_newest_package(461, 'satsync.linkPackagesToChannels', NULL) Process 10549: SELECT rhn_server.snapshot_server(1000013026, 'Package profile changed') -- the following bz might be related, https://bugzilla.redhat.com/show_bug.cgi?id=1406929
Since the problem described in this bug report should be resolved in a recent advisory, it has been closed with a resolution of ERRATA. For information on the advisory, and where to find the updated files, follow the link below. If the solution does not work for you, open a new bug report. https://access.redhat.com/errata/RHBA-2017:3445