Support Center > Search Results > SecureKnowledge Details
"monitord[PID]: SQL error: columns time_stamp, sensor_name are not unique rc=19" error in /var/log/messages Technical Level
Symptoms
  • The following errors appear repeatedly in /var/log/messages file:
    monitord[PID]: AddDataSQL: insertion failed, sensor name=[      ], timestamp=[YYYY-MM-DD HH:MM:SS]
    monitord[PID]: SQL error: columns time_stamp, sensor_name are not unique rc=19
    
Cause

On Open Server, hardware sensor names are all empty (whitespaces) - thus, duplicate entries appear in the SQL database of sensor data.


Solution
Note: To view this solution you need to Sign In .