Announcement

Collapse
No announcement yet.

3.1.0.3 - issues with 'Purge' and 'Clean Orphaned' event actions (Windows)

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

    3.1.0.3 - issues with 'Purge' and 'Clean Orphaned' event actions (Windows)

    HomeSeer Version: HS3 Pro Edition 3.0.0.548
    Operating System: Microsoft Windows Embedded Standard - Work Station

    Upgraded to 3.1.0.3 yesterday. Today noted that the nightly purge of records older than 365 days had thrown an error.

    Code:
     [TABLE="class: log_table_row, width: 970"]
    [TR]
    [TD="class: LogDateShort LogDateTime1, bgcolor: #ffffff, align: left"][SIZE=13px][FONT=Courier-New][COLOR=#000000]Oct-10 03:00:35[/COLOR][/FONT][/SIZE][/TD]
     			[TD="class: LogPri1, bgcolor: #ffffff, align: left"] [/TD]
     			[TD="class: LogType1, bgcolor: #ffffff, colspan: 3, align: left"][SIZE=12px][FONT=Courier-New][COLOR=#000000]Device History[/COLOR][/FONT][/SIZE][/TD]
     			[TD="class: LogEntry1, bgcolor: #ffffff, colspan: 8, align: left"][SIZE=12px][FONT=Courier-New][COLOR=#000000]Device History recording resumed.[/COLOR][/FONT][/SIZE][/TD]
     		[/TR]
    [/TABLE]
    [TABLE="class: log_table_row, width: 970"]
    [TR]
    [TD="class: LogDateShort LogDateTime0, bgcolor: #ffffff, align: left"][SIZE=13px][FONT=Courier-New][COLOR=#000000]Oct-10 03:00:35[/COLOR][/FONT][/SIZE][/TD]
     			[TD="class: LogPri0, bgcolor: #ffffff, align: left"] [/TD]
     			[TD="class: LogType0, bgcolor: #ffffff, colspan: 3, align: left"][SIZE=12px][FONT=Courier-New][COLOR=#000000]Device History[/COLOR][/FONT][/SIZE][/TD]
     			[TD="class: LogEntry0, bgcolor: #ffffff, colspan: 8, align: left"][SIZE=12px][FONT=Courier-New][COLOR=#000000]Successfully inserted 0 queued changes.[/COLOR][/FONT][/SIZE][/TD]
     		[/TR]
    [/TABLE]
    [TABLE="class: log_table_row, width: 970"]
    [TR]
    [TD="class: LogDateShort LogDateTime1, bgcolor: #ffffff, align: left"][SIZE=13px][FONT=Courier-New][COLOR=#FF0000]Oct-10 03:00:30[/COLOR][/FONT][/SIZE][/TD]
     			[TD="class: LogPri1, bgcolor: #ffffff, align: left"] [/TD]
     			[TD="class: LogType1, bgcolor: #ffffff, colspan: 3, align: left"][SIZE=12px][FONT=Courier-New][COLOR=#FF0000]Error[/COLOR][/FONT][/SIZE][/TD]
     			[TD="class: LogEntry1, bgcolor: #ffffff, colspan: 8, align: left"][SIZE=12px][FONT=Courier-New][COLOR=#FF0000]Calling HSEvent in plugin Device History, Instance :Object reference not set to an instance of an object.[/COLOR][/FONT][/SIZE][/TD]
     		[/TR]
    [/TABLE]
    [TABLE="class: log_table_row, width: 970"]
    [TR]
    [TD="class: LogDateShort LogDateTime0, bgcolor: #ffffff, align: left"][SIZE=13px][FONT=Courier-New][COLOR=#FF0000]Oct-10 03:00:30[/COLOR][/FONT][/SIZE][/TD]
     			[TD="class: LogPri0, bgcolor: #ffffff, align: left"] [/TD]
     			[TD="class: LogType0, bgcolor: #ffffff, colspan: 3, align: left"][SIZE=12px][FONT=Courier-New][COLOR=#FF0000]Error[/COLOR][/FONT][/SIZE][/TD]
     			[TD="class: LogEntry0, bgcolor: #ffffff, colspan: 8, align: left"][SIZE=12px][FONT=Courier-New][COLOR=#FF0000]Event Sysadmin Backup - daily plugin action failed:Object reference not set to an instance of an object.[/COLOR][/FONT][/SIZE][/TD]
     		[/TR]
    [/TABLE]
    [TABLE="class: log_table_row, width: 970"]
    [TR]
    [TD="class: LogDateShort LogDateTime1, bgcolor: #ffffff, align: left"][SIZE=13px][FONT=Courier-New][COLOR=#000000]Oct-10 03:00:00[/COLOR][/FONT][/SIZE][/TD]
     			[TD="class: LogPri1, bgcolor: #ffffff, align: left"] [/TD]
     			[TD="class: LogType1, bgcolor: #ffffff, colspan: 3, align: left"][SIZE=12px][FONT=Courier-New][COLOR=#000000]Device History[/COLOR][/FONT][/SIZE][/TD]
     			[TD="class: LogEntry1, bgcolor: #ffffff, colspan: 8, align: left"][SIZE=12px][FONT=Courier-New][COLOR=#000000]Purging device history prior to 10/11/2019 3:00:00 AM for all devices[/COLOR][/FONT][/SIZE][/TD]
     		[/TR]
    [/TABLE]
    [TABLE="class: log_table_row, width: 970"]
    [TR]
    [TD="class: LogDateShort LogDateTime0, bgcolor: #ffffff, align: left"][SIZE=13px][FONT=Courier-New][COLOR=#000000]Oct-10 03:00:00[/COLOR][/FONT][/SIZE][/TD]
     			[TD="class: LogPri0, bgcolor: #ffffff, align: left"] [/TD]
     			[TD="class: LogType0, bgcolor: #ffffff, colspan: 3, align: left"][SIZE=12px][FONT=Courier-New][COLOR=#000000]Device History[/COLOR][/FONT][/SIZE][/TD]
     			[TD="class: LogEntry0, bgcolor: #ffffff, colspan: 8, align: left"][SIZE=12px][FONT=Courier-New][COLOR=#000000]Device History recording paused.[/COLOR][/FONT][/SIZE][/TD]
     		[/TR]
    [/TABLE]
    This is repeatable.

    I also tried 'Clean Orphaned Device History' and it throws a similar error.

    Code:
     [TABLE="class: log_table_row, width: 970"]
    [TR]
    [TD="class: LogDateShort LogDateTime1, bgcolor: #ffffff, align: left"][SIZE=13px][FONT=Courier-New][COLOR=#000000]Oct-10 23:18:48[/COLOR][/FONT][/SIZE][/TD]
     			[TD="class: LogPri1, bgcolor: #ffffff, align: left"] [/TD]
     			[TD="class: LogType1, bgcolor: #ffffff, colspan: 3, align: left"][SIZE=12px][FONT=Courier-New][COLOR=#000000]Device History[/COLOR][/FONT][/SIZE][/TD]
     			[TD="class: LogEntry1, bgcolor: #ffffff, colspan: 8, align: left"][SIZE=12px][FONT=Courier-New][COLOR=#000000]Device History recording resumed.[/COLOR][/FONT][/SIZE][/TD]
     		[/TR]
    [/TABLE]
    [TABLE="class: log_table_row, width: 970"]
    [TR]
    [TD="class: LogDateShort LogDateTime0, bgcolor: #ffffff, align: left"][SIZE=13px][FONT=Courier-New][COLOR=#000000]Oct-10 23:18:48[/COLOR][/FONT][/SIZE][/TD]
     			[TD="class: LogPri0, bgcolor: #ffffff, align: left"] [/TD]
     			[TD="class: LogType0, bgcolor: #ffffff, colspan: 3, align: left"][SIZE=12px][FONT=Courier-New][COLOR=#000000]Device History[/COLOR][/FONT][/SIZE][/TD]
     			[TD="class: LogEntry0, bgcolor: #ffffff, colspan: 8, align: left"][SIZE=12px][FONT=Courier-New][COLOR=#000000]Successfully inserted 0 queued changes.[/COLOR][/FONT][/SIZE][/TD]
     		[/TR]
    [/TABLE]
    [TABLE="class: log_table_row, width: 970"]
    [TR]
    [TD="class: LogDateShort LogDateTime1, bgcolor: #ffffff, align: left"][SIZE=13px][FONT=Courier-New][COLOR=#D58000]Oct-10 23:18:46[/COLOR][/FONT][/SIZE][/TD]
     			[TD="class: LogPri1, bgcolor: #ffffff, align: left"] [/TD]
     			[TD="class: LogType1, bgcolor: #ffffff, colspan: 3, align: left"][SIZE=12px][FONT=Courier-New][COLOR=#D58000]Warning[/COLOR][/FONT][/SIZE][/TD]
     			[TD="class: LogEntry1, bgcolor: #ffffff, colspan: 8, align: left"][SIZE=12px][FONT=Courier-New][COLOR=#D58000]Plugin Device History is not responding but it is still running, not restarting yet.[/COLOR][/FONT][/SIZE][/TD]
     		[/TR]
    [/TABLE]
    [TABLE="class: log_table_row, width: 970"]
    [TR]
    [TD="class: LogDateShort LogDateTime0, bgcolor: #ffffff, align: left"][SIZE=13px][FONT=Courier-New][COLOR=#FF0000]Oct-10 23:18:39[/COLOR][/FONT][/SIZE][/TD]
     			[TD="class: LogPri0, bgcolor: #ffffff, align: left"] [/TD]
     			[TD="class: LogType0, bgcolor: #ffffff, colspan: 3, align: left"][SIZE=12px][FONT=Courier-New][COLOR=#FF0000]Error[/COLOR][/FONT][/SIZE][/TD]
     			[TD="class: LogEntry0, bgcolor: #ffffff, colspan: 8, align: left"][SIZE=12px][FONT=Courier-New][COLOR=#FF0000]Calling HSEvent in plugin Device History, Instance :Object reference not set to an instance of an object.[/COLOR][/FONT][/SIZE][/TD]
     		[/TR]
    [/TABLE]
    [TABLE="class: log_table_row, width: 970"]
    [TR]
    [TD="class: LogDateShort LogDateTime1, bgcolor: #ffffff, align: left"][SIZE=13px][FONT=Courier-New][COLOR=#FF0000]Oct-10 23:18:38[/COLOR][/FONT][/SIZE][/TD]
     			[TD="class: LogPri1, bgcolor: #ffffff, align: left"] [/TD]
     			[TD="class: LogType1, bgcolor: #ffffff, colspan: 3, align: left"][SIZE=12px][FONT=Courier-New][COLOR=#FF0000]Error[/COLOR][/FONT][/SIZE][/TD]
     			[TD="class: LogEntry1, bgcolor: #ffffff, colspan: 8, align: left"][SIZE=12px][FONT=Courier-New][COLOR=#FF0000]Event Sandbox Device History Test plugin action failed:Object reference not set to an instance of an object.[/COLOR][/FONT][/SIZE][/TD]
     		[/TR]
    [/TABLE]
    [TABLE="class: log_table_row, width: 970"]
    [TR]
    [TD="class: LogDateShort LogDateTime0, bgcolor: #ffffff, align: left"][SIZE=13px][FONT=Courier-New][COLOR=#000000]Oct-10 23:18:08[/COLOR][/FONT][/SIZE][/TD]
     			[TD="class: LogPri0, bgcolor: #ffffff, align: left"] [/TD]
     			[TD="class: LogType0, bgcolor: #ffffff, colspan: 3, align: left"][SIZE=12px][FONT=Courier-New][COLOR=#000000]Device History[/COLOR][/FONT][/SIZE][/TD]
     			[TD="class: LogEntry0, bgcolor: #ffffff, colspan: 8, align: left"][SIZE=12px][FONT=Courier-New][COLOR=#000000]Device History recording paused.[/COLOR][/FONT][/SIZE][/TD]
     		[/TR]
    [/TABLE]
    [TABLE="class: log_table_row, width: 970"]
    [TR]
    [TD="class: LogDateShort LogDateTime1, bgcolor: #ffffff, align: left"][SIZE=13px][FONT=Courier-New][COLOR=#000000]Oct-10 23:18:08[/COLOR][/FONT][/SIZE][/TD]
     			[TD="class: LogPri1, bgcolor: #ffffff, align: left"] [/TD]
     			[TD="class: LogType1, bgcolor: #ffffff, colspan: 3, align: left"][SIZE=12px][FONT=Courier-New][COLOR=#000000]Device History[/COLOR][/FONT][/SIZE][/TD]
     			[TD="class: LogEntry1, bgcolor: #ffffff, colspan: 8, align: left"][SIZE=12px][FONT=Courier-New][COLOR=#000000]Cleaning out orphaned device history[/COLOR][/FONT][/SIZE][/TD]
     		[/TR]
    [/TABLE]

    #2
    Oops, not good: appears that everything prior to today has been purged

    Follow up:
    This issue was induced by a test I ran. I created a new event with the 'Purge' action. Upon instantiation of the action, it appears as in the first image. Note the number of days doesn't appear. When the action is expanded, the field is populated with 365 - however it's necessary to click in that field and submit for it to appear when collapsed.

    When the action is run with the field blank, it purges everything older that the current day. Might be a good idea to do nothing if that field is unpopulated.

    I restored from the 3AM backup, so it's now missing the data from 3am 10/10 until about 12am 10/11 when I recovered the database. The data (overlapping) from 12am 10/10 to just before 12am 10/11 exists in a separate file which I probably could merge in if I were enterprising enough

    It appears that in spite of the errors appearing in the log, the purge operation did run correctly. In the recovered database, there are no record earlier that 10/19/2019 3AM, which matches what the log entry says it was going to do.


    Attached Files

    Comment


      #3
      Yes, I noticed that samething.

      I changed it to 364 days.

      M
      iCore5 Win 10 Pro x64 SSD

      HS3 Pro Edition 3.0.0.435 Windows

      BLOccupied:,Device History:,Yamaha:,UltraMon3:,mcsXap:,Restart:,UltraNetatmo3:, UltraM1G3:,Ultra1Wire3:,BLBackup:,Harmony Hub:,DoorBird:,UltraECM3:,Nanoleaf 3P:,UltraRachio3:,Z-Wave:,SDJ-Health:,BLGarbage:,Blue-Iris:,Chromecast:,Pushover 3P:,EasyTrigger:

      Comment


        #4
        Yikes! I'll have a new version out shortly!

        Comment

        Working...
        X