Announcement

Collapse
No announcement yet.

Error in log

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    Error in log

    Every 30 mins I get this error
    (SQLiteFunctions.UpdateUsage) Error: Concurrency violation: the UpdateCommand affected 0 of the expected 1 records.

    Debug below. The GetSensorCorrection looks odd with the one empty entry.

    Thanks,
    Z


    Jul-11 4:22:33 PM JowiHue Debug: (Bridgescan) Start Scan for bridges 7/11/2017 4:22:33 PM
    Jul-11 4:22:18 PM JowiHue Error: (UpdateUsage):Concurrency violation: the UpdateCommand affected 0 of the expected 1 records.
    Jul-11 4:22:17 PM JowiHue Debug: (EnergyProcessThread) Total usage of Lightstrip is now 2959
    Jul-11 4:22:17 PM JowiHue Debug: (EnergyProcessThread) Total usage of Sink Light is now 9585.5
    Jul-11 4:22:17 PM JowiHue Debug: (EnergyProcessThread) Total usage of Shelter Downstairs 8 is now 9230.6
    Jul-11 4:22:17 PM JowiHue Debug: (EnergyProcessThread) Total usage of Shelter Downstairs 7 is now 9266.3
    Jul-11 4:22:17 PM JowiHue Debug: (EnergyProcessThread) Total usage of Shelter Downstairs 9 is now 9231.3
    Jul-11 4:22:17 PM JowiHue Debug: (EnergyProcessThread) Total usage of Shelter Downstairs 12 is now 9355.1
    Jul-11 4:22:17 PM JowiHue Debug: (EnergyProcessThread) Total usage of Shelter Downstairs 11 is now 9214.6
    Jul-11 4:22:17 PM JowiHue Debug: (EnergyProcessThread) Total usage of Shelter Downstairs 10 is now 9233.6
    Jul-11 4:22:17 PM JowiHue Debug: (EnergyProcessThread) Total usage of Shelter Downstairs 5 is now 9211.5
    Jul-11 4:22:17 PM JowiHue Debug: (EnergyProcessThread) Total usage of Shelter Downstais 6 is now 9247.7
    Jul-11 4:22:17 PM JowiHue Debug: (EnergyProcessThread) Total usage of Shelter Downstairs 1 is now 9462.7
    Jul-11 4:22:17 PM JowiHue Debug: (EnergyProcessThread) Total usage of Shelter Downstairs 3 is now 9459
    Jul-11 4:22:17 PM JowiHue Debug: (EnergyProcessThread) Total usage of Shelter Downstairs 7 is now 9414.5
    Jul-11 4:22:17 PM JowiHue Debug: (EnergyProcessThread) Total usage of House Front Porch is now 9098.9
    Jul-11 4:22:16 PM JowiHue Debug: (RefreshDevices) RefreshDevices finished succesfully for bridge ShelterHugh
    Jul-11 4:22:16 PM JowiHue Debug: (RefreshDevices) RefreshDevices finished succesfully for bridge HouseHue
    Jul-11 4:22:16 PM JowiHue Debug: (RefreshWatchTimer) RefreshWatchTimer: Checking for lights and groups, maintenance lifetime usage 7/11/2017 4:22:16 PM
    Jul-11 4:21:18 PM JowiHue Debug: (MainWatchTimer) Checking plugin health 7/11/2017 4:21:18 PM
    Jul-11 4:19:18 PM JowiHue Debug: (MainWatchTimer) Checking plugin health 7/11/2017 4:19:18 PM
    Jul-11 4:18:19 PM JowiHue Debug: (InitialBridgeScenes) starting for 'ShelterHugh'
    Jul-11 4:18:19 PM JowiHue Debug: (GetSensorCorrection) Returning 0 for 00:4A:6F:77:69:48:75:65-3
    Jul-11 4:18:19 PM JowiHue Debug: (GetSensorCorrection) Returning 0 for 00:4A:6F:77:69:48:75:65-1
    Jul-11 4:18:19 PM JowiHue Debug: (GetSensorCorrection) Returning 0 for 00:00:00:00:00:43:9a:2e-f2
    Jul-11 4:18:19 PM JowiHue Debug: (GetSensorCorrection) Returning 0 for
    Jul-11 4:18:19 PM JowiHue Debug: (InititialSensors) starting for 'ShelterHugh'
    Jul-11 4:18:19 PM JowiHue Debug: (InitialRules) starting for 'ShelterHugh'
    Jul-11 4:18:19 PM JowiHue Debug: (InitialGroups) starting for 'ShelterHugh'
    Jul-11 4:18:19 PM JowiHue Debug: (InitialLights) starting for 'ShelterHugh'
    Jul-11 4:18:05 PM JowiHue Debug: (Bridgescan) End search for bridges
    Jul-11 4:17:33 PM JowiHue Debug: (Bridgescan) Start Scan for bridges 7/11/2017 4:17:33 PM
    Jul-11 4:17:18 PM JowiHue Debug: (MainWatchTimer) Checking plugin health 7/11/2017 4:17:18 PM
    Jul-11 4:17:16 PM JowiHue Debug: (InitialBridgeScenes) starting for 'HouseHue'
    Jul-11 4:17:16 PM JowiHue Debug: (GetSensorCorrection) Returning 0 for
    Jul-11 4:17:16 PM JowiHue Debug: (InititialSensors) starting for 'HouseHue'
    Jul-11 4:17:16 PM JowiHue Debug: (InitialRules) starting for 'HouseHue'
    Jul-11 4:17:15 PM JowiHue Debug: (InitialGroups) starting for 'HouseHue'
    Jul-11 4:17:15 PM JowiHue Debug: (InitialLights) starting for 'HouseHue'

    #2
    vasrc,

    Th plugin tries to update the usage tables, but has an issue it seems with one record being updated. I have been working on that issue last year and thought I had caught it. It is not missing commands for the bridge, only the total usage figures for one or more of your lights will be off. Maybe the lightstrip.

    I will try to find how this error starts, but I might end up trying to reset your database....

    Thanks,

    Wim
    -- Wim

    Plugins: JowiHue, RFXCOM, Sonos4, Jon00's Perfmon and Network monitor, EasyTrigger, Pushover 3P, rnbWeather, BLBackup, AK SmartDevice, Pushover, PHLocation, Zwave, GCalseer, SDJ-Health, Device History, BLGData

    1210 devices/features ---- 392 events ----- 40 scripts

    Comment


      #3
      Originally posted by w.vuyk View Post
      vasrc,

      Th plugin tries to update the usage tables, but has an issue it seems with one record being updated. I have been working on that issue last year and thought I had caught it. It is not missing commands for the bridge, only the total usage figures for one or more of your lights will be off. Maybe the lightstrip.

      I will try to find how this error starts, but I might end up trying to reset your database....

      Thanks,

      Wim
      Haven't had any errors in the past several days. Moved BlueIris off to it's own machine, so that significantly lowered the load on the HS3 machine, which may have been part of the problem.

      Z

      Comment

      Working...
      X