0 Replies Latest reply on Sep 12, 2012 2:47 PM by Elias Ross

    Unique contraint saving measurement data

    Elias Ross Master

      I've been seeing this periodically in RHQ 4.2

       

      2012-09-12 17:28:49,822 INFO  [org.rhq.enterprise.server.measurement.MeasurementServerServiceImpl] Performance: measurement merge [143] timing (10007)ms
      2012-09-12 17:28:57,467 WARN  [org.rhq.enterprise.server.measurement.MeasurementDataManagerBean] Failure saving measurement numeric data:
      java.sql.BatchUpdateException:ORA-00001: unique constraint (RHQ.RHQ_MEAS_DATA_NUM_R06_ID_T_PK) violated
      [SQLException=ORA-00001: unique constraint (RHQ.RHQ_MEAS_DATA_NUM_R06_ID_T_PK) violated
       -> ORA-00001: unique constraint (RHQ.RHQ_MEAS_DATA_NUM_R06_ID_T_PK) violated
      (error-code=1,sql-state=23000)]
      2012-09-12 17:28:58,342 WARN  [org.rhq.enterprise.server.measurement.MeasurementDataManagerBean] Failure saving measurement trait data:
      java.sql.BatchUpdateException:ORA-00001: unique constraint (RHQ.RHQ_MEAS_DATA_TRAIT_ID_TIME_PK) violated
      [SQLException=ORA-00001: unique constraint (RHQ.RHQ_MEAS_DATA_TRAIT_ID_TIME_PK) violated
       -> ORA-00001: unique constraint (RHQ.RHQ_MEAS_DATA_TRAIT_ID_TIME_PK) violated
      (error-code=1,sql-state=23000)]
      2012-09-12 17:28:59,472 INFO  [org.rhq.enterprise.server.measurement.MeasurementServerServiceImpl] Performance: measurement merge [689] timing (37774)ms
      

       

      I'm not sure if I should be alarmed or do something about it, or if it's harmless or not.

       

      Is there some issue with my resources, possibly? I have two servers running.