Description of problem:

Customer requested a bug report

Deadlock while registering system

UPDATE RHNPRIVATECHANNELFAMILY SET CURRENT_MEMBERS = ( RHN_CHANNEL.CHANNEL_FAMILY_CURRENT_MEMBERS(:B1 , :B2 )), FVE_CURRENT_MEMBERS = ( RHN_CHANNEL.CFAM_CURR_FVE_MEMBERS(:B1 , :B2 )) WHERE ORG_ID = :B2 AND CHANNEL_FAMILY_ID = :B1

was blocking

SELECT CREATED FROM RHNPRIVATECHANNELFAMILY WHERE CHANNEL_FAMILY_ID = :B2 AND ORG_ID = :B1 FOR UPDATE SELECT CREATED FROM RHNPRIVATECHANNELFAMILY WHERE CHANNEL_FAMILY_ID = :B2 AND ORG_ID = :B1 FOR UPDATE

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


How reproducible:
100%

Steps to Reproduce:
1. on satellite 5.7 try to register host 
2.
3.

Actual results:

deadlock

Expected results:

server registered

Additional info:

workaround is to run a cron job hourly



BEGIN
  SYS.DBMS_STATS.GATHER_TABLE_STATS (OwnName => 'RHN' ,TabName  => 'RHNCHANNELFAMILY'             ,Estimate_Percent  => NULL ,Method_Opt => 'FOR ALL COLUMNS SIZE 1' ,Degree => 4 ,Cascade => TRUE ,No_Invalidate  => FALSE);
  SYS.DBMS_STATS.GATHER_TABLE_STATS (OwnName => 'RHN' ,TabName  => 'RHNCHANNELFAMILYMEMBERS'      ,Estimate_Percent  => NULL ,Method_Opt => 'FOR ALL COLUMNS SIZE 1' ,Degree => 4 ,Cascade => TRUE ,No_Invalidate  => FALSE);
  SYS.DBMS_STATS.GATHER_TABLE_STATS (OwnName => 'RHN' ,TabName  => 'RHNCHANNELFAMILYVIRTSUBLEVEL' ,Estimate_Percent  => NULL ,Method_Opt => 'FOR ALL COLUMNS SIZE 1' ,Degree => 4 ,Cascade => TRUE ,No_Invalidate  => FALSE); 
  SYS.DBMS_STATS.GATHER_TABLE_STATS (OwnName => 'RHN' ,TabName  => 'RHNPRIVATECHANNELFAMILY'      ,Estimate_Percent  => NULL ,Method_Opt => 'FOR ALL COLUMNS SIZE 1' ,Degree => 4 ,Cascade => TRUE ,No_Invalidate  => FALSE); 
  SYS.DBMS_STATS.GATHER_TABLE_STATS (OwnName => 'RHN' ,TabName  => 'RHNSERVER'                    ,Estimate_Percent  => NULL ,Method_Opt => 'FOR ALL COLUMNS SIZE 1' ,Degree => 4 ,Cascade => TRUE ,No_Invalidate  => FALSE); 
  SYS.DBMS_STATS.GATHER_TABLE_STATS (OwnName => 'RHN' ,TabName  => 'RHNSERVERCHANNEL'             ,Estimate_Percent  => NULL ,Method_Opt => 'FOR ALL COLUMNS SIZE 1' ,Degree => 4 ,Cascade => TRUE ,No_Invalidate  => FALSE); 
  SYS.DBMS_STATS.GATHER_TABLE_STATS (OwnName => 'RHN' ,TabName  => 'RHNSERVERGROUP'               ,Estimate_Percent  => NULL ,Method_Opt => 'FOR ALL COLUMNS SIZE 1' ,Degree => 4 ,Cascade => TRUE ,No_Invalidate  => FALSE); 
  SYS.DBMS_STATS.GATHER_TABLE_STATS (OwnName => 'RHN' ,TabName  => 'RHNSERVERGROUPMEMBERS'        ,Estimate_Percent  => NULL ,Method_Opt => 'FOR ALL COLUMNS SIZE 1' ,Degree => 4 ,Cascade => TRUE ,No_Invalidate  => FALSE); 
  SYS.DBMS_STATS.GATHER_TABLE_STATS (OwnName => 'RHN' ,TabName  => 'RHNSERVERGROUPTYPE'           ,Estimate_Percent  => NULL ,Method_Opt => 'FOR ALL COLUMNS SIZE 1' ,Degree => 4 ,Cascade => TRUE ,No_Invalidate  => FALSE); 
  SYS.DBMS_STATS.GATHER_TABLE_STATS (OwnName => 'RHN' ,TabName  => 'RHNSGTYPEVIRTSUBLEVEL'        ,Estimate_Percent  => NULL ,Method_Opt => 'FOR ALL COLUMNS SIZE 1' ,Degree => 4 ,Cascade => TRUE ,No_Invalidate  => FALSE); 
  SYS.DBMS_STATS.GATHER_TABLE_STATS (OwnName => 'RHN' ,TabName  => 'RHNVIRTUALINSTANCE'           ,Estimate_Percent  => NULL ,Method_Opt => 'FOR ALL COLUMNS SIZE 1' ,Degree => 4 ,Cascade => TRUE ,No_Invalidate  => FALSE); 
END;