Monitoring Probes gives a error deadlock message (ORA-00060) RHNSAT.RHN_SYNCH_PROBE_STATE

Issue

• Monitoring probes are not working and deadlock errors appearing in taskomatic logs

  taskomatic logs:
  
  INFO   | jvm 1    | 2010/10/28 15:16:03 | 2010-10-28 15:16:03,743 [DefaultQuartzScheduler_Worker-9] ERROR com.redhat.rhn.task
  omatic.task.SynchProbeState - Error during probe state sync
  INFO   | jvm 1    | 2010/10/28 15:16:03 | com.redhat.rhn.common.db.WrappedSQLException: ORA-00060: deadlock detected while wa
  iting for resource
  INFO   | jvm 1    | 2010/10/28 15:16:03 | ORA-06512: at "RHNSAT.RHN_SYNCH_PROBE_STATE", line 4
  INFO   | jvm 1    | 2010/10/28 15:16:03 | ORA-06512: at line 1
  
  
  
  /var/log/nocpulse logs:
  
  
  
  2010-10-27 22:49:41  Unable to read alert from file /var/tmp/01_1272378077_015499_002 at /usr/lib/perl5/vendor_perl/5.8.5/NOCpulse/Notif/AlertFile.pm line 31.
  2010-10-27 22:49:41  Unable to retrieve alert from_file /var/tmp/01_1272370744_005130_005 at NOCpulse::Notif::AlertFile :: /usr/lib/perl5/vendor_perl/5.8.5/NOCpulse/No
  tif/AlertFile.pm :: 25 can't open /var/tmp/01_1272370744_005130_005: No such file or directory at /usr/lib/perl5/vendor_perl/5.8.5/NOCpulse/Notif/Alert.pm line 52
  2010-10-27 22:49:41  Unable to read alert from file /var/tmp/01_1272370744_005130_005 at /usr/lib/perl5/vendor_perl/5.8.5/NOCpulse/Notif/AlertFile.pm line 31.
  2010-10-27 22:49:41  Unable to retrieve alert from_file /var/tmp/01_1272372264_029832_013 at NOCpulse::Notif::AlertFile :: /usr/lib/perl5/vendor_perl/5.8.5/NOCpulse/No
  tif/AlertFile.pm :: 25 can't open /var/tmp/01_1272372264_029832_013: No such file or directory at /usr/lib/perl5/vendor_perl/5.8.5/NOCpulse/Notif/Alert.pm line 52