Error using SQL Logger event as a trigger

Posted on
Sun Oct 19, 2014 9:00 pm
hamw offline
Posts: 1082
Joined: Mar 31, 2008

Error using SQL Logger event as a trigger

I have several triggers for event log errors. They require clicking the "Error Event Settings" button on the trigger pane, then specifying the error.

This has worked great but I went to modify one of my triggers, and got this error, which is not corrected by reloading SQLLogger or restarting the computer.

Code: Select all
Oct 19, 2014 10:38:25 PM

********Here is where I clicked "Edit Event Settings"******


  Error (client)                  timeout waiting for plugin response from com.perceptiveautomation.indigoplugin.sql-logger for request UiGetValues2
  Error (client)                  timeout waiting for plugin response from com.perceptiveautomation.indigoplugin.sql-logger for request CallPluginFunc
  Error (client)                  dialogForEventId() caught exception: NSInvalidArgumentException -- *** -[__NSPlaceholderDictionary initWithObjects:forKeys:count:]: attempt to insert nil object from objects[0]


*********Reloaded.  ***********
Oct 19, 2014 10:39:29 PM
  Reloading plugin "SQL Logger 1.1.8"
  Stopping plugin "SQL Logger 1.1.8" (pid 732)
  Received INSTEON                "Thermostat Main Bedrooms" temperature changed to 67.0
  Error                           process (pid 732) failed to quit after polite request -- forcing it to quit now
  Stopped plugin "SQL Logger 1.1.8"
  Starting plugin "SQL Logger 1.1.8" (pid 1966)
  Started plugin "SQL Logger 1.1.8"
  SQL Logger                      connected to /Library/Application Support/Perceptive Automation/Indigo 6/Logs/indigo_history.sqlite
  SQL Logger                      searching for unused device and variable tables
  SQL Logger                      search complete (none found)
  SQL Logger                      updating all device tables


****Click on the "Edit Event Settings" button again....No change even with SQL restart..********

  Error (client)                  timeout waiting for plugin response from com.perceptiveautomation.indigoplugin.sql-logger for request UiGetValues2
  Error (client)                  timeout waiting for plugin response from com.perceptiveautomation.indigoplugin.sql-logger for request CallPluginFunc
  Error (client)                  dialogForEventId() caught exception: NSInvalidArgumentException -- *** -[__NSPlaceholderDictionary initWithObjects:forKeys:count:]: attempt to insert nil object from objects[0]

****Click on the "Edit Event Settings" button again....********

  Error (client)                  timeout waiting for plugin response from com.perceptiveautomation.indigoplugin.sql-logger for request UiGetValues2
  Error (client)                  timeout waiting for plugin response from com.perceptiveautomation.indigoplugin.sql-logger for request CallPluginFunc
  Error (client)                  dialogForEventId() caught exception: NSInvalidArgumentException -- *** -[__NSPlaceholderDictionary initWithObjects:forKeys:count:]: attempt to insert nil object from objects[0]



I am running 10.8.3. I installed IndigoPlot a few weeks back. It has worked well; the errors above were with it disabled. I subsequently reloaded and it reported the following to the Event Log:

Code: Select all
Oct 19, 2014 10:54:46 PM
  Enabling plugin "INDIGOplotD 2.6.1"
  Starting plugin "INDIGOplotD 2.6.1" (pid 2220)
  Started plugin "INDIGOplotD 2.6.1"
  INDIGOplotD                     initializing  ... 2-6-1
  INDIGOplotD                     indigo version found: 6
  INDIGOplotD                      read file /Users/WilliamsEC/Documents/INDIGOPlotD/minute.dat lines: 2304
  INDIGOplotD                      read file /Users/WilliamsEC/Documents/INDIGOPlotD/hour.dat lines: 912
  INDIGOplotD                      read file /Users/WilliamsEC/Documents/INDIGOPlotD/day.dat lines: 390
  INDIGOplotD                      wait for SQL logger to finish start up -- before retrieving SQL data

Oct 19, 2014 10:55:10 PM
  INDIGOplotD                     sql commands launched  2014-10-19 22:55:10.192895  waiting for SQL tasks to end to read data into INDIGOplotD pid=2246
  INDIGOplotD                     initializing  ...2
  INDIGOplotD                     SQL Data arrived       2014-10-19 22:55:21.074403 RFX CrawlSp 3 Game Rm-humidity sql files created
  INDIGOplotD                     Convert2 device/prop from SQL db:  0:00:00.096777 RFX CrawlSp 3 Game Rm-humidity           records read/converted:    1890/   1890 to PLOT format ==== rejected bad..  DateField:     0 ..#ofColumns:     0 ..ValueRange:     0 ..BadNumber:     0 ..sameTimeStamp:     0
  INDIGOplotD                     Convert2 device/prop from SQL db:  0:00:00.207419 RFX CrawlSp 3 Game Rm-humidity           records read/converted:    1890/   1890 to PLOT format ==== rejected bad..  DateField:     0 ..#ofColumns:     0 ..ValueRange:     0 ..BadNumber:     0 ..sameTimeStamp:     0
  INDIGOplotD                     Convert2 device/prop from SQL db:  0:00:00.301236 RFX CrawlSp 3 Game Rm-temperature        records read/converted:    1837/   1837 to PLOT format ==== rejected bad..  DateField:     0 ..#ofColumns:     0 ..ValueRange:     0 ..BadNumber:     0 ..sameTimeStamp:     0
  INDIGOplotD                     SQL Data arrived       2014-10-19 22:55:23.588229 RFX CrawlSp 2 Main House-humidity sql files created
  INDIGOplotD                     Convert2 device/prop from SQL db:  0:00:00.283956 RFX CrawlSp 2 Main House-humidity        records read/converted:    3221/   3221 to PLOT format ==== rejected bad..  DateField:     0 ..#ofColumns:     0 ..ValueRange:     0 ..BadNumber:     0 ..sameTimeStamp:     0
  INDIGOplotD                     Convert2 device/prop from SQL db:  0:00:00.436965 RFX CrawlSp 2 Main House-temperature     records read/converted:    3057/   3057 to PLOT format ==== rejected bad..  DateField:     0 ..#ofColumns:     0 ..ValueRange:     0 ..BadNumber:     0 ..sameTimeStamp:     0
  INDIGOplotD                     SQL Data arrived       2014-10-19 22:55:37.950437 RFX CrawlSp 1 Fam Rm-humidity sql files created
  INDIGOplotD                     Convert2 device/prop from SQL db:  0:00:00.220465 RFX CrawlSp 1 Fam Rm-humidity            records read/converted:    5680/   5680 to PLOT format ==== rejected bad..  DateField:     0 ..#ofColumns:     0 ..ValueRange:     0 ..BadNumber:     0 ..sameTimeStamp:     0
  INDIGOplotD                     Convert2 device/prop from SQL db:  0:00:00.431412 RFX CrawlSp 1 Fam Rm-temperature         records read/converted:    5444/   5444 to PLOT format ==== rejected bad..  DateField:     0 ..#ofColumns:     0 ..ValueRange:     0 ..BadNumber:     0 ..sameTimeStamp:     0
  INDIGOplotD                     SQL import             2014-10-19 22:55:38.525855 ... finished, total number of records imported: 23019



...And it no longer generates a plot:



Oct 19, 2014 10:58:50 PM
WebServer file:/Users/WilliamsEC/Documents/INDIGOPlotD/Temp Hum Game Rm Crawl Space-minute-S1.png load error: <urlopen error [Errno 2] No such file or directory: '/Users/WilliamsEC/Documents/INDIGOPlotD/Temp Hum Game Rm Crawl Space-minute-S1.png'>
WebServer file:/Users/WilliamsEC/Documents/INDIGOPlotD/Temp Hum Game Rm Crawl Space-minute-S1.png load error: <urlopen error [Errno 2] No such file or directory: '/Users/WilliamsEC/Documents/INDIGOPlotD/Temp Hum Game Rm Crawl Space-minute-S1.png'>
WebServer file:/Users/WilliamsEC/Documents/INDIGOPlotD/Temp Hum Game Rm Crawl Space-minute-S1.png load error: <urlopen error [Errno 2] No such file or directory: '/Users/WilliamsEC/Documents/INDIGOPlotD/Temp Hum Game Rm Crawl Space-minute-S1.png'>
WebServer file:/Users/WilliamsEC/Documents/INDIGOPlotD/Temp Hum Game Rm Crawl Space-minute-S1.png load error: <urlopen error [Errno 2] No such file or directory: '/Users/WilliamsEC/Documents/INDIGOPlotD/Temp Hum Game Rm Crawl Space-minute-S1.png'>
WebServer file:/Users/WilliamsEC/Documents/INDIGOPlotD/Temp Hum Game Rm Crawl Space-minute-S1.png load error: <urlopen error [Errno 2] No such file or directory: '/Users/WilliamsEC/Documents/INDIGOPlotD/Temp Hum Game Rm Crawl Space-minute-S1.png'>
WebServer file:/Users/WilliamsEC/Documents/INDIGOPlotD/Temp Hum Game Rm Crawl Space-minute-S1.png load error: <urlopen error [Errno 2] No such file or directory: '/Users/WilliamsEC/Documents/INDIGOPlotD/Temp Hum Game Rm Crawl Space-minute-S1.png'>
WebServer file:/Users/WilliamsEC/Documents/INDIGOPlotD/Temp Hum Game Rm Crawl Space-minute-S1.png load error: <urlopen error [Errno 2] No such file or directory: '/Users/WilliamsEC/Documents/INDIGOPlotD/Temp Hum Game Rm Crawl Space-minute-S1.png'>
WebServer file:/Users/WilliamsEC/Documents/INDIGOPlotD/Temp Hum Game Rm Crawl Space-minute-S1.png load error: <urlopen error [Errno 2] No such file or directory: '/Users/WilliamsEC/Documents/INDIGOPlotD/Temp Hum Game Rm Crawl Space-minute-S1.png'>
WebServer file:/Users/WilliamsEC/Documents/INDIGOPlotD/Temp Hum Game Rm Crawl Space-minute-S1.png load error: <urlopen error [Errno 2] No such file or directory: '/Users/WilliamsEC/Documents/INDIGOPlotD/Temp Hum Game Rm Crawl Space-minute-S1.png'>
WebServer file:/Users/WilliamsEC/Documents/INDIGOPlotD/Temp Hum Game Rm Crawl Space-minute-S1.png load error: <urlopen error [Errno 2] No such file or directory: '/Users/WilliamsEC/Documents/INDIGOPlotD/Temp Hum Game Rm Crawl Space-minute-S1.png'>
WebServer file:/Users/WilliamsEC/Documents/INDIGOPlotD/Temp Hum Game Rm Crawl Space-minute-S1.png load error: <urlopen error [Errno 2] No such file or directory: '/Users/WilliamsEC/Documents/INDIGOPlotD/Temp Hum Game Rm Crawl Space-minute-S1.png'>
WebServer file:/Users/WilliamsEC/Documents/INDIGOPlotD/Temp Hum Game Rm Crawl Space-minute-S1.png load error: <urlopen error [Errno 2] No such file or directory: '/Users/WilliamsEC/Documents/INDIGOPlotD/Temp Hum Game Rm Crawl Space-minute-S1.png'>
WebServer file:/Users/WilliamsEC/Documents/INDIGOPlotD/Temp Hum Game Rm Crawl Space-minute-S1.png load error: <urlopen error [Errno 2] No such file or directory: '/Users/WilliamsEC/Documents/INDIGOPlotD/Temp Hum Game Rm Crawl Space-minute-S1.png'>
WebServer file:/Users/WilliamsEC/Documents/INDIGOPlotD/Temp Hum Game Rm Crawl Space-minute-S1.png load error: <urlopen error [Errno 2] No such file or directory: '/Users/WilliamsEC/Documents/INDIGOPlotD/Temp Hum Game Rm Crawl Space-minute-S1.png'>


Suggestions?

Posted on
Sun Oct 19, 2014 9:36 pm
matt (support) offline
Site Admin
User avatar
Posts: 18458
Joined: Jan 27, 2003
Location: Texas

Re: Error using SQL Logger event as a trigger

How big is the file:

/Library/Application Support/Perceptive Automation/Indigo 6/Logs/indigo_history.sqlite

Image

Posted on
Mon Oct 20, 2014 5:06 am
hamw offline
Posts: 1082
Joined: Mar 31, 2008

Re: Error using SQL Logger event as a trigger

Hmmmm..... 15.23 Gb. If it needs to be smaller, can I set options for a smaller volume size and not lose my data?

Posted on
Mon Oct 20, 2014 7:12 am
matt (support) offline
Site Admin
User avatar
Posts: 18458
Joined: Jan 27, 2003
Location: Texas

Re: Error using SQL Logger event as a trigger

That is pretty huge and likely causing the problem.

Are you running the most recent version of IndigoPlot? I think he has 3.5.2 posted on his forum now.

I'm not sure if the plugin will have a way to prune down the database or if you'll have to start a clean one. Try posting on IndigoPlotD thread to see if he has any suggestions.

Image

Posted on
Mon Oct 20, 2014 7:36 am
kw123 offline
User avatar
Posts: 5599
Joined: May 12, 2013
Location: Dallas, TX

Re: Error using SQL Logger event as a trigger

hamw: yes please download the latest version:

https://www.dropbox.com/s/i32lsiwn3em8e1k/indigoplotD3-5-3.zip?dl=0

It has some improvements in importing SQL ... sometimes the sql database is locked and the read does not work properly.
This one handles that exception and also offers the option to refresh the data on a daily basis to reduce the amount of data imported (use the 2DAY SQL feature in configuration).

I have ~10 months of data and my database is 1.9GB with ~ 100 devices..

How many years of data do you have or how many devices?

You might want to delete some variables or devices your don't need in the database.
I am using SQLIGHTbrowser app http://sourceforge.net/projects/sqlitebrowser/ to do that. It is free and works well.
- make a backup!!
- shut down indigo !!
- open up sqlitebrowser and delete or prune the tables you don't need (you need to know the deviceID / variableID)
- restart indigo


Karl
Last edited by kw123 on Mon Oct 20, 2014 10:40 am, edited 1 time in total.

Posted on
Mon Oct 20, 2014 7:42 am
matt (support) offline
Site Admin
User avatar
Posts: 18458
Joined: Jan 27, 2003
Location: Texas

Re: Error using SQL Logger event as a trigger

Thanks Karl. Some great tips there.

Image

Posted on
Wed Nov 05, 2014 9:49 pm
hamw offline
Posts: 1082
Joined: Mar 31, 2008

Re: Error using SQL Logger event as a trigger

I upgraded IndigoPlot and looked at the DB in SQLbrowser. I only had about 2months of values there, dating back to September. I deleted the entire database, thinking I could make better choices starting off fresh. However, in looking at what came up, part of the issue may be that I have a ton of variables, and so there is a lot to track.


Code: Select all
        "Thermostat Main Bedrooms" temperature changed to 67.0

Nov 5, 2014 10:40:49 PM
  Enabling plugin "SQL Logger 1.1.8"
  Starting plugin "SQL Logger 1.1.8" (pid 85246)
  Started plugin "SQL Logger 1.1.8"
  SQL Logger                      connected to /Library/Application Support/Perceptive Automation/Indigo 6/Logs/indigo_history.sqlite
  SQL Logger                      searching for unused device and variable tables
  SQL Logger                      search complete (none found)
  SQL Logger                      updating all device tables
  SQL Logger                      creating table device_history_300231467 for "01 Pool House Kitchen Sink"
  SQL Logger                      creating table device_history_477630162 for "02 Pool House Bathroom"
  SQL Logger                      creating table device_history_513733078 for "03 Pool House Equipment"
  SQL Logger                      creating table device_history_1161482787 for "04 Washer"
  SQL Logger                      creating table device_history_160196748 for "05 Kitchen Sink"
  SQL Logger                      creating table device_history_1794075932 for "06 Fam Rm Bath"
  SQL Logger                      creating table device_history_1126325720 for "07 Ice Maker Alcoholway"
  SQL Logger                      creating table device_history_1538468927 for "08 Basement Ham's Plumbing"
  SQL Logger                      creating table device_history_784406241 for "09 Sink Game Room"
  SQL Logger                      creating table device_history_753621911 for "10 Marion BR"
  SQL Logger                      creating table device_history_81246598 for "11 Guest BR"
  SQL Logger                      creating table device_history_1657453161 for "12 Hot Water Heaters"
  SQL Logger                      creating table device_history_308749424 for "aGarage Door 1"
  SQL Logger                      creating table device_history_156448696 for "aGarage Door 2"
  SQL Logger                      creating table device_history_900904374 for "aGarage Door 3"
  SQL Logger                      creating table device_history_876381518 for "Alarm Partition 1"
  SQL Logger                      creating table device_history_1488371024 for "Alarm Partition 2"
  SQL Logger                      creating table device_history_852676944 for "Alcoholway Light"
  SQL Logger                      creating table device_history_1973104131 for "Alcoholway O'Head Cabinet Fam Room"
  SQL Logger                      creating table device_history_1992491425 for "Alcoholway O'Head Cabinet LR BackYard Side"
  SQL Logger                      creating table device_history_1715981692 for "Alcoholway O'Head Cabinet LR Street"
  SQL Logger                      creating table device_history_810810329 for "aOutdrAppl Linc 1 Front Left"
  SQL Logger                      creating table device_history_885987786 for "aOutdrAppl Linc 2 Front Lights"
  SQL Logger                      creating table device_history_1447498573 for "aOutdrAppl Linc 3 Garage"
  SQL Logger                      creating table device_history_884610123 for "Appl Linc APExpress Garage Reset"
  SQL Logger                      creating table device_history_733189842 for "Appl Linc APExpress Pool Reset"
  SQL Logger                      creating table device_history_970555640 for "Appl Linc Reboot Daddy's iMac"
  SQL Logger                      creating table device_history_403512947 for "Backyard Big Lts Fam Rm Switch"
  SQL Logger                      creating table device_history_1284228621 for "Backyard Big Lts Passageway Slave"
  SQL Logger                      creating table device_history_1041361854 for "Backyard Carriage Lts DinRm"
  SQL Logger                      creating table device_history_1343402907 for "Backyard OverHead Lt Fam Rm Steps"
  SQL Logger                      creating table device_history_725658264 for "BkFast Table Chand Slave"
  SQL Logger                      creating table device_history_206854723 for "BkFast Table Chandelier Master"
  SQL Logger                      creating table device_history_112980080 for "DR Chand Master"
  SQL Logger                      creating table device_history_1747756010 for "DR Chand Slave Alcoholway"
  SQL Logger                      creating table device_history_296346670 for "Driveway Foyer Entry Light"
  SQL Logger                      creating table device_history_896298244 for "Driveway Path Lights KPL"
  SQL Logger                      creating table device_history_365954615 for "EZFlora 19 BD CC currently dead"
  SQL Logger                      creating table device_history_1810989133 for "EZFlora Front Yard Zones 1-8 "Robustified""
  SQL Logger                      creating table device_history_65235903 for "EZFlora Perennials Back Yard"
  SQL Logger                      creating table device_history_1636308194 for "Fam Rm Daddy's Reading Light"
  SQL Logger                      creating table device_history_385450656 for "Fam Rm Fireplace lights"
  SQL Logger                      creating table device_history_1268412610 for "Fam Rm Foyer"
  SQL Logger                      creating table device_history_1011528476 for "Fam Rm Main Master"
  SQL Logger                      creating table device_history_527931674 for "Fam Rm Main Slave"
  SQL Logger                      creating table device_history_94904997 for "Foyer Chandelier"
  SQL Logger                      creating table device_history_111718794 for "Foyer Chandelier Upstairs Slave"
  SQL Logger                      creating table device_history_351789950 for "Foyer LampLinc 3 "
  SQL Logger                      creating table device_history_1490655981 for "Foyer Steps Downstairs SLAVE"
  SQL Logger                      creating table device_history_726842897 for "Foyer Steps Upstairs MASTER"
  SQL Logger                      creating table device_history_1580045524 for "Front Lights"
  SQL Logger                      creating table device_history_1406464454 for "Game Rm Front FP Lts"
  SQL Logger                      creating table device_history_185774208 for "Game Rm O'Head Sofas"
  SQL Logger                      creating table device_history_350023025 for "Game Rm Pool Lights"
  SQL Logger                      creating table device_history_222153663 for "Game Rm Rear Bar Lts"
  SQL Logger                      creating table device_history_1207486294 for "Game Rm Rear Left"
  SQL Logger                      creating table device_history_612106955 for "Game Rm Rear Right"
  SQL Logger                      creating table device_history_1299810191 for "Game Rm Sidebd Lamps LampLinc 2"
  SQL Logger                      creating table device_history_768554651 for "GamPsgWy Master"
  SQL Logger                      creating table device_history_759874060 for "GamPsgWy Slave LivRmWall Front"
  SQL Logger                      creating table device_history_108390669 for "GamPsgWy Slave LivRmWall Rear"
  SQL Logger                      creating table device_history_1219102874 for "GamPsgWy Table LampLinc 1"
  SQL Logger                      creating table device_history_1092004303 for "Garage Apt Overhead Cans"
  SQL Logger                      creating table device_history_1701372722 for "Garage Apt Steps Lower Master"
  SQL Logger                      creating table device_history_647841793 for "Garage Apt Steps Upstairs Power"
  SQL Logger                      creating table device_history_1879113742 for "Garage Carriage Lights"
  SQL Logger                      creating table device_history_233688539 for "Garage Carriage Lights Slave"
  SQL Logger                      creating table device_history_636269462 for "Garage O'Head Fluorescents"
  SQL Logger                      creating table device_history_734228028 for "Garage Path Lts Slave"
  SQL Logger                      creating table device_history_151491483 for "Google Voice Ham's Phone"
  SQL Logger                      creating table device_history_118865229 for "Google Voice Marion's Phone"
  SQL Logger                      creating table device_history_1440928605 for "iMeter Solo Sump Pump"
  SQL Logger                      creating table device_history_921464579 for "IO Link Doorbell"
  SQL Logger                      creating table device_history_49385482 for "IO Link Freezer Sensor"
  SQL Logger                      creating table device_history_772048342 for "iTunes"
  SQL Logger                      creating table device_history_1119558753 for "Kitchen Bar OverHeads"
  SQL Logger                      creating table device_history_1042435482 for "Kitchen Bar Pendants"
  SQL Logger                      creating table device_history_1352918701 for "Kitchen Cooktop 2 Lights"
  SQL Logger                      creating table device_history_1162152016 for "Kitchen Main 6 Dim"
  SQL Logger                      creating table device_history_1880457140 for "Kitchen Steps Lower Slave"
  SQL Logger                      creating table device_history_1778329203 for "Kitchen Steps Upper Master"
  SQL Logger                      creating table device_history_890103713 for "Kitchen UnderCab Fluor Fridge"
  SQL Logger                      creating table device_history_1581191099 for "Kitchen UnderCab Fluor Sink"
  SQL Logger                      creating table device_history_1499059404 for "Living Rm Lamp LampLinc 4"
  SQL Logger                      creating table device_history_1475741601 for "Living Room PictureLts"
  SQL Logger                      creating table device_history_1370217094 for "Living Room Table Lamp Slave"
  SQL Logger                      creating table device_history_1769139036 for "Living Room Table Lt Master"
  SQL Logger                      creating table device_history_1439974747 for "MBR Bath Daddy Fan Shower"
  SQL Logger                      creating table device_history_1721151901 for "MBR Bedside KPL"
  SQL Logger                      creating table device_history_1197301684 for "MBR Daddy's O'Head Bed Lt"
  SQL Logger                      creating table device_history_750084337 for "MBR Mommy's O'Head Bed Lt"
  SQL Logger                      creating table device_history_997348164 for "MBR Sitting Area O'Heads"
  SQL Logger                      creating table device_history_106191836 for "Moon Lights Back Yard"
  SQL Logger                      creating table device_history_629338258 for "Moon Lights Front Yard"
  SQL Logger                      creating table device_history_1802718286 for "Office"
  SQL Logger                      creating table device_history_1733213442 for "Phidgets 8/8/8"
  SQL Logger                      creating table device_history_23085881 for "Phidgets Relay A House Valve Close"
  SQL Logger                      creating table device_history_92152270 for "Phidgets Relay A House Valve Open"
  SQL Logger                      creating table device_history_1277650443 for "Phidgets Relay B Pool Supply House Valve Close"
  SQL Logger                      creating table device_history_1089098378 for "Phidgets Relay B Pool Supply House Valve Open"
  SQL Logger                      creating table device_history_281607566 for "Phidgets Relay C Pool Supply Sprinkler Valve Actuator"
  SQL Logger                      creating table device_history_474957244 for "Phidgets Relay C Pool Supply Sprinkler Valve Open-- Broken Relay"
  SQL Logger                      creating table device_history_1680788122 for "Phidgets Sensor A House Valve is Closed"
  SQL Logger                      creating table device_history_1529866655 for "Phidgets Sensor A House Valve is Open"
  SQL Logger                      creating table device_history_1532710665 for "Phidgets Sensor B Pool Supply Valve is Closed"
  SQL Logger                      creating table device_history_1540318258 for "Phidgets Sensor B Pool Supply Valve is Open"
  SQL Logger                      creating table device_history_1581369840 for "Phidgets Water Meter 1 House Pulse Counter"
  SQL Logger                      creating table device_history_674593774 for "Phidgets Water Meter 2 Pool Pulse Counter "
  SQL Logger                      creating table device_history_1923648252 for "Phone Emily"
  SQL Logger                      creating table device_history_981317380 for "Phone Ham 5"
  SQL Logger                      creating table device_history_310721117 for "Phone Marion 4s"
  SQL Logger                      creating table device_history_669748673 for "Phone Paige"
  SQL Logger                      creating table device_history_543073059 for "Pool"
  SQL Logger                      creating table device_history_4144896 for "pool bathroom"
  SQL Logger                      creating table device_history_183058684 for "pool dressing room fluorescent"
  SQL Logger                      creating table device_history_954327859 for "pool house kitchen"
  SQL Logger                      creating table device_history_933142021 for "pool outside carriage lights"
  SQL Logger                      creating table device_history_529648763 for "pool outside low level"
  SQL Logger                      creating table device_history_1055284047 for "RFX CrawlSp 1 Fam Rm"
  SQL Logger                      creating table device_history_503075230 for "RFX CrawlSp 2 Main House"
  SQL Logger                      creating table device_history_761629564 for "RFX CrawlSp 3 Game Rm"
  SQL Logger                      creating table device_history_794510541 for "RFX Rain Gauge"
  SQL Logger                      creating table device_history_1684227013 for "RFX TempHum Outside in Weber Base Chnl 3 Extra "
  SQL Logger                      creating table device_history_1495516250 for "Study BookCase Picture Light"
  SQL Logger                      creating table device_history_1282584984 for "Study OH Main"
  SQL Logger                      creating table device_history_987882950 for "Study OH Slave"
  SQL Logger                      creating table device_history_1487473780 for "Study Wall Pics"
  SQL Logger                      creating table device_history_50146681 for "Surge Protectors Basement Main Panel"
  SQL Logger                      creating table device_history_449259657 for "TED 5000"
  SQL Logger                      creating table device_history_1271666732 for "TED Reset"
  SQL Logger                      creating table device_history_601942819 for "Thermo Fam Rm"
  SQL Logger                      creating table device_history_1657737183 for "Thermo FamStudy"
  SQL Logger                      creating table device_history_360767461 for "Thermo Game Rm"
  SQL Logger                      creating table device_history_829356644 for "Thermo Main Bedrooms"
  SQL Logger                      creating table device_history_343648156 for "Thermo MBR"
  SQL Logger                      creating table device_history_1215045977 for "Thermostat Fam Room"
  SQL Logger                      creating table device_history_1404155407 for "Thermostat Fam Study"
  SQL Logger                      creating table device_history_429909040 for "Thermostat GameRm"
  SQL Logger                      creating table device_history_124301033 for "Thermostat Main Bedrooms"
  SQL Logger                      creating table device_history_611898507 for "Thermostat MBR"
  SQL Logger                      creating table device_history_874167453 for "Timer 01 Pool House Kitchen Sink"
  SQL Logger                      creating table device_history_1099572346 for "Timer 02 Pool House Bathroom"
  SQL Logger                      creating table device_history_1614618290 for "Timer 03 Pool House Equipment"
  SQL Logger                      creating table device_history_1620460065 for "Timer 04 Washer"
  SQL Logger                      creating table device_history_755915392 for "Timer 05 Kitchen Sink"
  SQL Logger                      creating table device_history_426660957 for "Timer 06 Fam Rm Bath"
  SQL Logger                      creating table device_history_1629520461 for "Timer 07 Ice Maker Alcoholway"
  SQL Logger                      creating table device_history_92781135 for "Timer 08 Basement Ham's Plumbing"
  SQL Logger                      creating table device_history_355410688 for "Timer 09 Sink Game Room"
  SQL Logger                      creating table device_history_1975402007 for "Timer 10 Marion BR"
  SQL Logger                      creating table device_history_430383766 for "Timer 11 Guest BR"
  SQL Logger                      creating table device_history_1614821386 for "Timer 12 Hot Water Heaters"
  SQL Logger                      creating table device_history_919561710 for "Timer Kitchen Thermo Reset after 20 min"
  SQL Logger                      creating table device_history_600432356 for "Timer Pool Cleaner 1 hour"
  SQL Logger                      creating table device_history_1819616053 for "Timer Pool Fill Sprinkler Water ON then Off after 3 Hr"
  SQL Logger                      creating table device_history_773930573 for "Timer Pool Water Valve Pool Bathroom Water ON"
  SQL Logger                      creating table device_history_420373495 for "Timer RFX CrawlSp 1 Fam Rm"
  SQL Logger                      creating table device_history_50061284 for "Timer RFX CrawlSP 2 Main House"
  SQL Logger                      creating table device_history_585385281 for "Timer RFX CrawlSp 3 Game Rm"
  SQL Logger                      creating table device_history_1382281858 for "Timer RFX Rain Gauge"
  SQL Logger                      creating table device_history_1994240808 for "Timer RFX TempHum Outside in Weber Base"
  SQL Logger                      creating table device_history_964760130 for "UPS Monitor"
  SQL Logger                      creating table device_history_679201448 for "Upstairs Hall Bathroom"
  SQL Logger                      creating table device_history_775789076 for "Vaux Simple Serial Python"
  SQL Logger                      creating table device_history_1722006044 for "Water 1 Dehumid Fam Rm"
  SQL Logger                      creating table device_history_1577090446 for "Water 2 Dehumid Main House"
  SQL Logger                      creating table device_history_1557733041 for "Water 3 Dehumid Game Rm"
  SQL Logger                      creating table device_history_1526995927 for "Water 4 CrawlSp Fan Fam Rm"
  SQL Logger                      creating table device_history_1408299303 for "Water 5 CrawlSp Fan Main House"
  SQL Logger                      creating table device_history_261398975 for "Water 6 CrawlSp Fan Game Room"
  SQL Logger                      creating table device_history_1956903967 for "Water Sensor MBR A/C Pan Email"
  SQL Logger                      creating table device_history_884499983 for "Water Sensors Crawl Space EZIO6"
  SQL Logger                      creating table device_history_976449363 for "Weather NOAA"
  SQL Logger                      creating table device_history_619389088 for "Weather NOAA Plus"
  SQL Logger                      creating table device_history_1794403763 for "z CO2 Detector"
  SQL Logger                      creating table device_history_728556894 for "z Glass Dining Room"
  SQL Logger                      creating table device_history_1369840294 for "z Glass Family Room"
  SQL Logger                      creating table device_history_1218532242 for "z Glass Garage"
  SQL Logger                      creating table device_history_1313561920 for "z Glass Kitchen"
  SQL Logger                      creating table device_history_1535629174 for "z Glass Kitchen Entry"
  SQL Logger                      creating table device_history_1324949481 for "z Glass Kitchen Stairway"
  SQL Logger                      creating table device_history_1707586840 for "z Glass Laundry"
  SQL Logger                      creating table device_history_1360571132 for "z Glass Living Room"
  SQL Logger                      creating table device_history_35472167 for "z Glass Second Floor Foyer"
  SQL Logger                      creating table device_history_20974317 for "z Heat Garage"
  SQL Logger                      creating table device_history_1180279585 for "z Not Used????"
  SQL Logger                      creating table device_history_1389524834 for "z Smoke Heat Detectors Wired"
  SQL Logger                      creating table device_history_1236288933 for "zKids Emily Outlet"
  SQL Logger                      creating table device_history_1995832811 for "Zone Basement Door 16"
  SQL Logger                      creating table device_history_1165931403 for "Zone Basement Motion 11"
  SQL Logger                      creating table device_history_1326652743 for "Zone Dining Door Near Alcoholway 26"
  SQL Logger                      creating table device_history_1158733511 for "Zone Fam Rm Motion 14"
  SQL Logger                      creating table device_history_10944085 for "Zone Front Door 27"
  SQL Logger                      creating table device_history_1853507202 for "Zone Garage Back Door 18"
  SQL Logger                      creating table device_history_1260493491 for "Zone Garage Entry Door 17"
  SQL Logger                      creating table device_history_1542680440 for "Zone Kitchen Door Back 15"
  SQL Logger                      creating table device_history_143131582 for "Zone Kitchen Door Entry 25"
  SQL Logger                      creating table device_history_1002326113 for "Zone Kitchen Motion RF Wireless 38"
  SQL Logger                      creating table device_history_592405221 for "Zone LivRm Motion Back Side 04"
  SQL Logger                      creating table device_history_352440340 for "Zone LivRm Motion Front Side 03"
  SQL Logger                      creating table device_history_672023530 for "Zone Passageway Door 28"
  SQL Logger                      creating table device_history_150974009 for "Zone Passageway Motion 08"
  SQL Logger                      creating table device_history_879330030 for "Zone Upstairs Motion 29"
  SQL Logger                      creating table device_history_1566012282 for "Zone Window Garage Apt Back Wall Far 18"
  SQL Logger                      creating table device_history_38341798 for "Zone Window Garage Apt Back Wall Near 21"
  SQL Logger                      creating table device_history_1867206688 for "Zone Window Garage Apt Side Far 20"
  SQL Logger                      creating table device_history_64450855 for "Zone Window Girls' Master 36"
  SQL Logger                      creating table device_history_1485826164 for "Zone Window Laundry 12"
  SQL Logger                      creating table device_history_294120713 for "Zone Window Master Left 34"
  SQL Logger                      creating table device_history_1352761549 for "Zone Window Master Right 33"
  SQL Logger                      creating table device_history_1707432080 for "Zone Window Office 35"
  SQL Logger                      updating all variable tables
  SQL Logger                      creating table variable_history_859711264 for "AC_dailymins"
  SQL Logger                      creating table variable_history_1326598342 for "AirFoilCurrentSource"
  SQL Logger                      creating table variable_history_1784528319 for "AirFoilIsRunning"
  SQL Logger                      creating table variable_history_1791191013 for "airfoilSpeaker1"
  SQL Logger                      creating table variable_history_1833176892 for "airfoilSpeaker2"
  SQL Logger                      creating table variable_history_740646643 for "airfoilSpeaker3"
  SQL Logger                      creating table variable_history_1635133077 for "airfoilSpeaker4"
  SQL Logger                      creating table variable_history_209756174 for "AirFoilSpeakerComputerConnected"
  SQL Logger                      creating table variable_history_945448439 for "AirFoilSpeakerComputerVolume"
  SQL Logger                      creating table variable_history_100713134 for "AirFoilSpeakerConnected"
  SQL Logger                      creating table variable_history_283639955 for "AirFoilSpeakerDaddysiMaclocalConnected"
  SQL Logger                      creating table variable_history_1622372846 for "AirFoilSpeakerDaddysiMaclocalVolume"
  SQL Logger                      creating table variable_history_65987665 for "AirFoilSpeakerFamilyRoomAppleTVConnected"
  SQL Logger                      creating table variable_history_1048444228 for "AirFoilSpeakerFamilyRoomAppleTVVolume"
  SQL Logger                      creating table variable_history_1959212650 for "AirFoilSpeakerGarageB88D12581C4CConnected"
  SQL Logger                      creating table variable_history_142204046 for "AirFoilSpeakerGarageB88D12581C4CVolume"
  SQL Logger                      creating table variable_history_9141186 for "AirFoilSpeakerGreatRoomAppleTVConnected"
  SQL Logger                      creating table variable_history_1791195526 for "AirFoilSpeakerGreatRoomAppleTVVolume"
  SQL Logger                      creating table variable_history_1046798230 for "AirFoilSpeakerHamWilliamssiPhoneConnected"
  SQL Logger                      creating table variable_history_1922979750 for "AirFoilSpeakerHamWilliamssiPhoneVolume"
  SQL Logger                      creating table variable_history_669010945 for "AirFoilSpeakerMusic44D8846AB6D9Connected"
  SQL Logger                      creating table variable_history_1113345938 for "AirFoilSpeakerMusic44D8846AB6D9Volume"
  SQL Logger                      creating table variable_history_1955695275 for "AirFoilSpeakerpoolcameraConnected"
  SQL Logger                      creating table variable_history_1049663586 for "AirFoilSpeakerpoolcameraVolume"
  SQL Logger                      creating table variable_history_1698432560 for "AirFoilSpeakerVolume"
  SQL Logger                      creating table variable_history_1149672490 for "AirFoilSpeakerWHAMusic28CFE984B9C8Connected"
  SQL Logger                      creating table variable_history_1766826547 for "AirFoilSpeakerWHAMusic28CFE984B9C8Volume"
  SQL Logger                      creating table variable_history_119436261 for "AirFoilSpeakerWholeHouseAudioAirPlayConnected"
  SQL Logger                      creating table variable_history_1874976113 for "AirFoilSpeakerWholeHouseAudioAirPlayVolume"
  SQL Logger                      creating table variable_history_430151707 for "AirParrotConnectionState"
  SQL Logger                      creating table variable_history_1865616060 for "AlarmGarageDisplay"
  SQL Logger                      creating table variable_history_505666111 for "AlarmGarageState"
  SQL Logger                      creating table variable_history_1246154759 for "AlarmGarageStateMiniDisplay"
  SQL Logger                      creating table variable_history_1261184556 for "AlarmHouseDisplay"
  SQL Logger                      creating table variable_history_1400704834 for "AlarmHouseState"
  SQL Logger                      creating table variable_history_1184141937 for "AlarmHouseStateMiniDisplay"
  SQL Logger                      creating table variable_history_146932572 for "AlarmRawOutput"
  SQL Logger                      creating table variable_history_369746083 for "AlarmSendTextOnChange"
  SQL Logger                      creating table variable_history_497542508 for "AlarmSensor"
  SQL Logger                      creating table variable_history_1930518992 for "AlarmSensorRawData"
  SQL Logger                      creating table variable_history_437186134 for "AllPhonesAway"
  SQL Logger                      creating table variable_history_939524173 for "AllPhonesHome"
  SQL Logger                      creating table variable_history_495187841 for "AllPhonesOnVacation"
  SQL Logger                      creating table variable_history_1663281536 for "audio_0_source"
  SQL Logger                      creating table variable_history_1709357089 for "audio_0_source_name"
  SQL Logger                      creating table variable_history_465603820 for "audio_0_volume"
  SQL Logger                      creating table variable_history_1416651045 for "audio_1_source"
  SQL Logger                      creating table variable_history_309867966 for "audio_1_source_name"
  SQL Logger                      creating table variable_history_1208421489 for "audio_1_volume"
  SQL Logger                      creating table variable_history_1051812893 for "audio_2_source"
  SQL Logger                      creating table variable_history_1191925137 for "audio_2_source_name"
  SQL Logger                      creating table variable_history_1191544037 for "audio_2_volume"
  SQL Logger                      creating table variable_history_1974384461 for "audio_3_source"
  SQL Logger                      creating table variable_history_1683834788 for "audio_3_source_name"
  SQL Logger                      creating table variable_history_1789542546 for "audio_3_volume"
  SQL Logger                      creating table variable_history_1423554734 for "audio_4_source"
  SQL Logger                      creating table variable_history_127067344 for "audio_4_source_name"
  SQL Logger                      creating table variable_history_18801472 for "audio_4_volume"
  SQL Logger                      creating table variable_history_724687808 for "audio_5_source"
  SQL Logger                      creating table variable_history_647523638 for "audio_5_source_name"
  SQL Logger                      creating table variable_history_1449262001 for "audio_5_volume"
  SQL Logger                      creating table variable_history_1095316512 for "audio_6_source"
  SQL Logger                      creating table variable_history_426897 for "audio_6_source_name"
  SQL Logger                      creating table variable_history_174966909 for "audio_6_volume"
  SQL Logger                      creating table variable_history_718347542 for "audio_7_source"
  SQL Logger                      creating table variable_history_1071734221 for "audio_7_source_name"
  SQL Logger                      creating table variable_history_1955153019 for "audio_7_volume"
  SQL Logger                      creating table variable_history_1215889050 for "audio_8_source"
  SQL Logger                      creating table variable_history_324954407 for "audio_8_source_name"
  SQL Logger                      creating table variable_history_1738187364 for "audio_8_volume"
  SQL Logger                      creating table variable_history_141689517 for "a_Set_Total_PList_Buttons"
  SQL Logger                      creating table variable_history_688132873 for "BackYardLightsStayON"
  SQL Logger                      creating table variable_history_1269288487 for "BATTV"
  SQL Logger                      creating table variable_history_587144835 for "BCHARGE"
  SQL Logger                      creating table variable_history_990844776 for "Cameras1_Fam_Rm_Patio"
  SQL Logger                      creating table variable_history_145747591 for "Cameras2_Fam_Rm_Walkway"
  SQL Logger                      creating table variable_history_1986844975 for "Cameras3_Side_Entry_Door"
  SQL Logger                      creating table variable_history_1451998115 for "Cameras4_Driveway"
  SQL Logger                      creating table variable_history_862446320 for "Cameras6_Pool"
  SQL Logger                      creating table variable_history_16623819 for "Cameras7_Front_Door"
  SQL Logger                      creating table variable_history_1198846549 for "Cameras9_Game_Rm_Patio"
  SQL Logger                      creating table variable_history_76618747 for "Computer"
  SQL Logger                      creating table variable_history_4005570 for "CurrentAlbum"
  SQL Logger                      creating table variable_history_937597226 for "CurrentArtist"
  SQL Logger                      creating table variable_history_1681104982 for "currentDeviceIndex"
  SQL Logger                      creating table variable_history_1616158744 for "CurrentPlaylist"
  SQL Logger                      creating table variable_history_1787317155 for "CurrentRating"
  SQL Logger                      creating table variable_history_1461385925 for "CurrentSource"
  SQL Logger                      creating table variable_history_1405969431 for "CurrentTrack"
  SQL Logger                      creating table variable_history_515907842 for "DaddysiMac.local"
  SQL Logger                      creating table variable_history_1606586697 for "DaddysiMac.local_(2)"
  SQL Logger                      creating table variable_history_116249207 for "DaddysiMacAlarmON"
  SQL Logger                      creating table variable_history_914058582 for "DATE"
  SQL Logger                      creating table variable_history_128953884 for "day1Period1Line1"
  SQL Logger                      creating table variable_history_1619447007 for "day1Period1Line2"
  SQL Logger                      creating table variable_history_1234869622 for "day1Period1Line3"
  SQL Logger                      creating table variable_history_49368869 for "day1Period1Line4"
  SQL Logger                      creating table variable_history_923882863 for "day1Period1Line5"
  SQL Logger                      creating table variable_history_503927045 for "day1Period1Line6"
  SQL Logger                      creating table variable_history_1239750357 for "day1Period2Line1"
  SQL Logger                      creating table variable_history_158380345 for "day1Period2Line2"
  SQL Logger                      creating table variable_history_771421685 for "day1Period2Line3"
  SQL Logger                      creating table variable_history_1115896211 for "day1Period2Line4"
  SQL Logger                      creating table variable_history_1588556832 for "day1Period2Line5"
  SQL Logger                      creating table variable_history_930387757 for "day1Period2Line6"
  SQL Logger                      creating table variable_history_873189556 for "DehumidifiersOn"
  SQL Logger                      creating table variable_history_364061715 for "Dehum_FamRm_OFFTime"
  SQL Logger                      creating table variable_history_1754698470 for "Dehum_FamRm_OnTime"
  SQL Logger                      creating table variable_history_995333238 for "Dehum_FamRm_RunTime"
  SQL Logger                      creating table variable_history_1741469962 for "Dehum_FamRm_ShutDownTime"
  SQL Logger                      creating table variable_history_1659039123 for "direct_Vaux_Send"
  SQL Logger                      creating table variable_history_67479972 for "direct_Vaux_Send2"
  SQL Logger                      creating table variable_history_858778390 for "Display_iPan_PlayListPreSet"
  SQL Logger                      creating table variable_history_1879014220 for "Display_iTunes_Pandora"
  SQL Logger                      creating table variable_history_39778441 for "Display_iTunes_PlayListPreSet"
  SQL Logger                      creating table variable_history_1217107701 for "Display_iTunes_Radio_or_Playlist"
  SQL Logger                      creating table variable_history_538632913 for "Display_Pandora_PlayListPreSet"
  SQL Logger                      creating table variable_history_137120859 for "Family_Room_Apple_TV"
  SQL Logger                      creating table variable_history_1059021946 for "Fan_dailymins"
  SQL Logger                      creating table variable_history_45307325 for "FMFAllPhonesAway"
  SQL Logger                      creating table variable_history_1890971395 for "FMFAllPhonesHome"
  SQL Logger                      creating table variable_history_636718557 for "FMFAllPhonesOnVacation"
  SQL Logger                      creating table variable_history_754522259 for "FMFiPhoneHam"
  SQL Logger                      creating table variable_history_1785013901 for "FMFiPhoneMarion"
  SQL Logger                      creating table variable_history_1640498683 for "FMFiPhonePaige"
  SQL Logger                      creating table variable_history_32975946 for "forecastZIP"
  SQL Logger                      creating table variable_history_552843942 for "Garage1"
  SQL Logger                      creating table variable_history_545500580 for "Garage2"
  SQL Logger                      creating table variable_history_20364222 for "Garage3"
  SQL Logger                      creating table variable_history_1770515678 for "GarageAutoClose"
  SQL Logger                      creating table variable_history_813316951 for "GarageSendText"
  SQL Logger                      creating table variable_history_894509185 for "Garage_Airport_Online"
  SQL Logger                      creating table variable_history_1652735901 for "Great_Room_Apple_TV"
  SQL Logger                      creating table variable_history_866604971 for "Heating_dailymins"
  SQL Logger                      creating table variable_history_1596654921 for "Home"
  SQL Logger                      creating table variable_history_306104832 for "HomeReadout"
  SQL Logger                      creating table variable_history_229258926 for "houseMode"
  SQL Logger                      creating table variable_history_1895187682 for "iCalSpeak"
  SQL Logger                      creating table variable_history_43725808 for "iMeter_Sump_Pump"
  SQL Logger                      creating table variable_history_650657954 for "INDIGOplotD-Script-Message"
  SQL Logger                      creating table variable_history_1488993978 for "IPan_Button_1"
  SQL Logger                      creating table variable_history_1412449689 for "IPan_Button_10"
  SQL Logger                      creating table variable_history_6957876 for "IPan_Button_13"
  SQL Logger                      creating table variable_history_863790957 for "IPan_Button_2"
  SQL Logger                      creating table variable_history_139608568 for "IPan_Button_3"
  SQL Logger                      creating table variable_history_199967283 for "IPan_Button_4"
  SQL Logger                      creating table variable_history_1132261384 for "IPan_Button_5"
  SQL Logger                      creating table variable_history_670934472 for "IPan_Button_6"
  SQL Logger                      creating table variable_history_1367076000 for "IPan_Button_7"
  SQL Logger                      creating table variable_history_279106556 for "IPan_Button_8"
  SQL Logger                      creating table variable_history_493464682 for "IPan_Button_9"
  SQL Logger                      creating table variable_history_592176023 for "IPan_iTunes_Preset_1"
  SQL Logger                      creating table variable_history_1419155055 for "IPan_iTunes_Preset_10"
  SQL Logger                      creating table variable_history_1516963015 for "IPan_iTunes_Preset_2"
  SQL Logger                      creating table variable_history_979762061 for "IPan_iTunes_Preset_3"
  SQL Logger                      creating table variable_history_594077780 for "IPan_iTunes_Preset_4"
  SQL Logger                      creating table variable_history_438974869 for "IPan_iTunes_Preset_5"
  SQL Logger                      creating table variable_history_1811788599 for "IPan_iTunes_Preset_6"
  SQL Logger                      creating table variable_history_1298715879 for "IPan_iTunes_Preset_7"
  SQL Logger                      creating table variable_history_229219694 for "IPan_iTunes_Preset_8"
  SQL Logger                      creating table variable_history_866341160 for "IPan_iTunes_Preset_9"
  SQL Logger                      creating table variable_history_1899480459 for "IPan_Pandora_Preset_1"
  SQL Logger                      creating table variable_history_327858102 for "IPan_Pandora_Preset_10"
  SQL Logger                      creating table variable_history_575890699 for "IPan_Pandora_Preset_2"
  SQL Logger                      creating table variable_history_1378956542 for "IPan_Pandora_Preset_3"
  SQL Logger                      creating table variable_history_906483778 for "IPan_Pandora_Preset_4"
  SQL Logger                      creating table variable_history_932184334 for "IPan_Pandora_Preset_5"
  SQL Logger                      creating table variable_history_1628176200 for "IPan_Pandora_Preset_6"
  SQL Logger                      creating table variable_history_688594137 for "IPan_Pandora_Preset_7"
  SQL Logger                      creating table variable_history_1806829181 for "IPan_Pandora_Preset_8"
  SQL Logger                      creating table variable_history_1415843327 for "IPan_Pandora_Preset_9"
  SQL Logger                      creating table variable_history_1900854157 for "isDaylight"
  SQL Logger                      creating table variable_history_42972322 for "iTunesIsPlaying"
  SQL Logger                      creating table variable_history_73602093 for "iTunesIsPlaying_Display"
  SQL Logger                      creating table variable_history_383310369 for "iTunesIsRunning"
  SQL Logger                      creating table variable_history_307289316 for "iTunesSetPlaylistChangeStation"
  SQL Logger                      creating table variable_history_1782646496 for "iTunes_CurrentAlbum"
  SQL Logger                      creating table variable_history_130608195 for "iTunes_CurrentArtist"
  SQL Logger                      creating table variable_history_491910650 for "iTunes_CurrentlyPlaying"
  SQL Logger                      creating table variable_history_882058171 for "iTunes_CurrentPlayList"
  SQL Logger                      creating table variable_history_747995525 for "iTunes_CurrentTrack"
  SQL Logger                      creating table variable_history_922572568 for "iTunes_LastPlayList"
  SQL Logger                      creating table variable_history_325896667 for "iTunes_Music_Static_Name_1"
  SQL Logger                      creating table variable_history_778154217 for "iTunes_Music_Static_Name_10"
  SQL Logger                      creating table variable_history_1598554249 for "iTunes_Music_Static_Name_2"
  SQL Logger                      creating table variable_history_677198986 for "iTunes_Music_Static_Name_3"
  SQL Logger                      creating table variable_history_1387176620 for "iTunes_Music_Static_Name_4"
  SQL Logger                      creating table variable_history_1300345205 for "iTunes_Music_Static_Name_5"
  SQL Logger                      creating table variable_history_531327341 for "iTunes_Music_Static_Name_6"
  SQL Logger                      creating table variable_history_1081638364 for "iTunes_Music_Static_Name_7"
  SQL Logger                      creating table variable_history_623807668 for "iTunes_Music_Static_Name_8"
  SQL Logger                      creating table variable_history_597999509 for "iTunes_Volume"
  SQL Logger                      creating table variable_history_118884655 for "LastCheck"
  SQL Logger                      creating table variable_history_483549823 for "LightsBackyard"
  SQL Logger                      creating table variable_history_1355676159 for "LightsDriveway"
  SQL Logger                      creating table variable_history_585952699 for "LightsDrivewayCarriageHse"
  SQL Logger                      creating table variable_history_1685932116 for "LightsFamRm4AllOn"
  SQL Logger                      creating table variable_history_1743571045 for "LightsFamRm5Reading"
  SQL Logger                      creating table variable_history_518352211 for "LightsFamRm6AllOff"
  SQL Logger                      creating table variable_history_30193150 for "LightsFamRm6AllOff_HomePgDisplay"
  SQL Logger                      creating table variable_history_1615287251 for "LightsFamRm7Movie"
  SQL Logger                      creating table variable_history_646745096 for "LightsFamRm8DaddysReadingLt"
  SQL Logger                      creating table variable_history_1451886287 for "LightsFamRm9Cocktails"
  SQL Logger                      creating table variable_history_989866301 for "LightsFamRmSceneDisplay"
  SQL Logger                      creating table variable_history_77625543 for "LightsFamRmScenes"
  SQL Logger                      creating table variable_history_98837075 for "LightsFamRmSumAnswer"
  SQL Logger                      creating table variable_history_73133402 for "LightsGameRm10AllOn"
  SQL Logger                      creating table variable_history_1110300790 for "LightsGameRm11AllOff"
  SQL Logger                      creating table variable_history_772880677 for "LightsGameRm11AllOff_HomePgDisplay"
  SQL Logger                      creating table variable_history_1318954431 for "LightsGameRm12DrinksPool"
  SQL Logger                      creating table variable_history_729371270 for "LightsGameRm14AllDim"
  SQL Logger                      creating table variable_history_1938424722 for "LightsGameRm15MovExit"
  SQL Logger                      creating table variable_history_1771511655 for "LightsGameRm16SptsPty"
  SQL Logger                      creating table variable_history_1470951279 for "LightsGameRm17Cocktails"
  SQL Logger                      creating table variable_history_1365491079 for "LightsGameRmSceneDisplay"
  SQL Logger                      creating table variable_history_1482607107 for "LightsGameRmScenes"
  SQL Logger                      creating table variable_history_847192204 for "LightsGarage"
  SQL Logger                      creating table variable_history_254117786 for "LightsMoonBackYard"
  SQL Logger                      creating table variable_history_95111799 for "LightsMoonFrontYard"
  SQL Logger                      creating table variable_history_128393884 for "LightsPassageway"
  SQL Logger                      creating table variable_history_1795400555 for "LightsPoolHouse"
  SQL Logger                      creating table variable_history_96354276 for "Lights_Driveway_Stay_On"
  SQL Logger                      creating table variable_history_857780849 for "LINEV"
  SQL Logger                      creating table variable_history_708877728 for "LOADPCT"
  SQL Logger                      creating table variable_history_53212099 for "Local_High_Temp"
  SQL Logger                      creating table variable_history_1565063300 for "Local_High_Time"
  SQL Logger                      creating table variable_history_1456666680 for "Local_Low_Temp"
  SQL Logger                      creating table variable_history_1943169734 for "Local_Low_Time"
  SQL Logger                      creating table variable_history_1085640588 for "Modem_Online"
  SQL Logger                      creating table variable_history_910858064 for "Msg10"
  SQL Logger                      creating table variable_history_798950506 for "Msg11"
  SQL Logger                      creating table variable_history_1825089191 for "Msg13"
  SQL Logger                      creating table variable_history_1484254517 for "Msg14"
  SQL Logger                      creating table variable_history_1907766145 for "Msg20"
  SQL Logger                      creating table variable_history_1993898219 for "Msg21"
  SQL Logger                      creating table variable_history_1707621592 for "Msg30"
  SQL Logger                      creating table variable_history_684413059 for "Msg31"
  SQL Logger                      creating table variable_history_402537848 for "Msg32"
  SQL Logger                      creating table variable_history_552463675 for "Msg33"
  SQL Logger                      creating table variable_history_83754847 for "Music_44:D8:84:6A:B6:D9"
  SQL Logger                      creating table variable_history_1299118227 for "NUMXFERS"
  SQL Logger                      creating table variable_history_980375931 for "PandoraBoyIsPlaying"
  SQL Logger                      creating table variable_history_290451461 for "PandoraBoyIsRunning"
  SQL Logger                      creating table variable_history_853155828 for "PandoraBoyPlayerState"
  SQL Logger                      creating table variable_history_676291486 for "PandoraBoyPlayerStateCorrected"
  SQL Logger                      creating table variable_history_518500303 for "PandoraBoyPlayerStateCorrected_Display"
  SQL Logger                      creating table variable_history_1256285332 for "PandorasBoxIsPlaying"
  SQL Logger                      creating table variable_history_461424897 for "PandorasBoxIsRunning"
  SQL Logger                      creating table variable_history_852852967 for "PandorasBoxPlayerState"
  SQL Logger                      creating table variable_history_239151061 for "PandorasBoxPlayerStateCorrected"
  SQL Logger                      creating table variable_history_873495850 for "PandorasBoxPlayerStateCorrected_Display"
  SQL Logger                      creating table variable_history_1419111200 for "PhoneEmilyHome"
  SQL Logger                      creating table variable_history_827357141 for "PhoneHam5Home"
  SQL Logger                      creating table variable_history_410505408 for "PhoneMarion4sHome"
  SQL Logger                      creating table variable_history_1882681654 for "PhonePaigeHome"
  SQL Logger                      creating table variable_history_561051191 for "poolcamera"
  SQL Logger                      creating table variable_history_944027477 for "Pool_Airport_Online"
  SQL Logger                      creating table variable_history_959975013 for "Pool_Aux5"
  SQL Logger                      creating table variable_history_40348818 for "Pool_Heat_Actual_Status"
  SQL Logger                      creating table variable_history_1920760143 for "Pool_Heat_Pool_Status"
  SQL Logger                      creating table variable_history_1990118770 for "Pool_Heat_Schedule"
  SQL Logger                      creating table variable_history_585319771 for "Pool_Heat_Spa_Status"
  SQL Logger                      creating table variable_history_1449093823 for "Pool_Light_Status"
  SQL Logger                      creating table variable_history_994399413 for "Pool_Pump1_ON_TIME"
  SQL Logger                      creating table variable_history_1084630906 for "Pool_Pump2_OFF_TIME"
  SQL Logger                      creating table variable_history_827090057 for "Pool_Pump3_Cleaner_ON_TIME"
  SQL Logger                      creating table variable_history_654456507 for "Pool_Pump4_Cleaner_OFF_TIME"
  SQL Logger                      creating table variable_history_30239094 for "Pool_TempDisplay_Pool"
  SQL Logger                      creating table variable_history_161716163 for "Pool_TempDisplay_Spa"
  SQL Logger                      creating table variable_history_1352903259 for "RadioWakeUpDisplay"
  SQL Logger                      creating table variable_history_1218792971 for "RadioWakeUpEnabled"
  SQL Logger                      creating table variable_history_370629703 for "RadioWakeUpSnooze"
  SQL Logger                      creating table variable_history_1780187110 for "RadioWakeUpSpeech"
  SQL Logger                      creating table variable_history_8253882 for "RecentActivity1"
  SQL Logger                      creating table variable_history_987146814 for "RecentActivity10"
  SQL Logger                      creating table variable_history_1588111270 for "RecentActivity11"
  SQL Logger                      creating table variable_history_813691460 for "RecentActivity12"
  SQL Logger                      creating table variable_history_730025538 for "RecentActivity13"
  SQL Logger                      creating table variable_history_1380531746 for "RecentActivity14"
  SQL Logger                      creating table variable_history_1656960901 for "RecentActivity15"
  SQL Logger                      creating table variable_history_621361076 for "RecentActivity2"
  SQL Logger                      creating table variable_history_1677781156 for "RecentActivity3"
  SQL Logger                      creating table variable_history_1862497340 for "RecentActivity4"
  SQL Logger                      creating table variable_history_295522468 for "RecentActivity5"
  SQL Logger                      creating table variable_history_1483307090 for "RecentActivity6"
  SQL Logger                      creating table variable_history_845327237 for "RecentActivity7"
  SQL Logger                      creating table variable_history_96750205 for "RecentActivity8"
  SQL Logger                      creating table variable_history_590610378 for "RecentActivity9"
  SQL Logger                      creating table variable_history_981918000 for "RFX_Outside_Temp_Obs_Time"
  SQL Logger                      creating table variable_history_687296694 for "RFX_Outside_Temp_Obs_Time_Display"
  SQL Logger                      creating table variable_history_1932325411 for "SetAlltoHomeEnabled"
  SQL Logger                      creating table variable_history_246252004 for "SetAlltoHomeTime"
  SQL Logger                      creating table variable_history_590717204 for "sprinklerDurationMultiplier"
  SQL Logger                      creating table variable_history_1577946177 for "sprinklerson"
  SQL Logger                      creating table variable_history_505956416 for "STATUS"
  SQL Logger                      creating table variable_history_135891695 for "StreamboxIsRunning"
  SQL Logger                      creating table variable_history_1114246977 for "StreamBoxIsRunning"
  SQL Logger                      creating table variable_history_1222717822 for "TED_5000_Calc_Cost"
  SQL Logger                      creating table variable_history_1783630876 for "TED_5000_MTD_Proj"
  SQL Logger                      creating table variable_history_1367893558 for "TED_5000_TimeStamp"
  SQL Logger                      creating table variable_history_1088108063 for "TED_Online"
  SQL Logger                      creating table variable_history_715473946 for "Text1"
  SQL Logger                      creating table variable_history_1709992723 for "Text2"
  SQL Logger                      creating table variable_history_45010450 for "Text3"
  SQL Logger                      creating table variable_history_377589153 for "Text4"
  SQL Logger                      creating table variable_history_499008403 for "Text5"
  SQL Logger                      creating table variable_history_111901133 for "Text6"
  SQL Logger                      creating table variable_history_1835961711 for "Text7"
  SQL Logger                      creating table variable_history_1053840116 for "Text8"
  SQL Logger                      creating table variable_history_5251929 for "Text9"
  SQL Logger                      creating table variable_history_654997978 for "TextToSpeech"
  SQL Logger                      creating table variable_history_990949951 for "Text_10"
  SQL Logger                      creating table variable_history_496594653 for "ThermoFamRmCool"
  SQL Logger                      creating table variable_history_1824654709 for "ThermoFamRmCool_Away"
  SQL Logger                      creating table variable_history_131998700 for "ThermoFamRmHeat"
  SQL Logger                      creating table variable_history_1007217909 for "ThermoFamRmHeat_Away"
  SQL Logger                      creating table variable_history_1320923198 for "ThermoFamRmSetPointCool"
  SQL Logger                      creating table variable_history_99022752 for "ThermoFamRmSetPointHeat"
  SQL Logger                      creating table variable_history_610109211 for "ThermoFamStudyCool"
  SQL Logger                      creating table variable_history_788795855 for "ThermoFamStudyHeat"
  SQL Logger                      creating table variable_history_1043884439 for "ThermoGameRmCool"
  SQL Logger                      creating table variable_history_760405009 for "ThermoGameRmHeat"
  SQL Logger                      creating table variable_history_1253355124 for "ThermoMainBedroomsCool"
  SQL Logger                      creating table variable_history_1438873016 for "ThermoMainBedroomsHeat"
  SQL Logger                      creating table variable_history_51793377 for "ThermoMBRCool"
  SQL Logger                      creating table variable_history_1352990721 for "ThermoMBRHeat"
  SQL Logger                      creating table variable_history_1412174704 for "TIMELEFT"
  SQL Logger                      creating table variable_history_859724029 for "TimerSpklrDuration"
  SQL Logger                      creating table variable_history_306115020 for "TimerSpklrDurationMin"
  SQL Logger                      creating table variable_history_164781782 for "Timer_FamRm_Thermo_On_Off"
  SQL Logger                      creating table variable_history_1362695316 for "Timer_FamRm_Thermo_Time_Remaining"
  SQL Logger                      creating table variable_history_54128723 for "Timer_Pool_Cleaner_Time_Remaining"
  SQL Logger                      creating table variable_history_1448617722 for "VacationLights"
  SQL Logger                      creating table variable_history_838722508 for "vauxCommand_1"
  SQL Logger                      creating table variable_history_137438387 for "vauxCommand_2"
  SQL Logger                      creating table variable_history_1589666058 for "vauxCommand_3"
  SQL Logger                      creating table variable_history_120079851 for "vauxCommand_4"
  SQL Logger                      creating table variable_history_584030519 for "vauxCommand_5"
  SQL Logger                      creating table variable_history_421943471 for "vauxCommand_6"
  SQL Logger                      creating table variable_history_1489557218 for "vauxCommand_7"
  SQL Logger                      creating table variable_history_73024497 for "vauxCommand_8"
  SQL Logger                      creating table variable_history_1925362107 for "vauxResponse"
  SQL Logger                      creating table variable_history_1963098885 for "vauxResponseBassTreble"
  SQL Logger                      creating table variable_history_310132982 for "vauxResponseCombinedOutput"
  SQL Logger                      creating table variable_history_1932988370 for "vauxResponseOutputShort"
  SQL Logger                      creating table variable_history_1890620001 for "vauxSourceName"
  SQL Logger                      creating table variable_history_519871620 for "vauxZoneName"
  SQL Logger                      creating table variable_history_1699344874 for "vauxZoneVolume"
  SQL Logger                      creating table variable_history_1089232056 for "WaterHouseNightLeak"
  SQL Logger                      creating table variable_history_826059095 for "WaterSensorActivatedName"
  SQL Logger                      creating table variable_history_1949188259 for "WaterSensorActivatedTime"
  SQL Logger                      creating table variable_history_408656693 for "WaterUsePool_01_Today"
  SQL Logger                      creating table variable_history_501601441 for "WaterUsePool_02_Yesterday"
  SQL Logger                      creating table variable_history_389268956 for "WaterUsePool_03_ThisWeek"
  SQL Logger                      creating table variable_history_318196911 for "WaterUsePool_04_LastWeek"
  SQL Logger                      creating table variable_history_1293655198 for "WaterUsePool_05_ThisMonth"
  SQL Logger                      creating table variable_history_1885346989 for "WaterUsePool_06_LastMonth"
  SQL Logger                      creating table variable_history_1559457852 for "WaterUsePool_07_StopFlow_1000"
  SQL Logger                      creating table variable_history_1453255218 for "WaterUsePool_Total"
  SQL Logger                      creating table variable_history_1414259172 for "WaterUseTotal"
  SQL Logger                      creating table variable_history_905148819 for "WaterUse_01_Today"
  SQL Logger                      creating table variable_history_1354107158 for "WaterUse_02_Yesterday"
  SQL Logger                      creating table variable_history_63589566 for "WaterUse_03_ThisWeek"
  SQL Logger                      creating table variable_history_1830374714 for "WaterUse_04_LastWeek"
  SQL Logger                      creating table variable_history_590029058 for "WaterUse_05_ThisMonth"
  SQL Logger                      creating table variable_history_174696508 for "WaterUse_06_LastMonth"
  SQL Logger                      creating table variable_history_1256657837 for "WaterUse_07_Jan"
  SQL Logger                      creating table variable_history_1282020040 for "WaterUse_08_Feb"
  SQL Logger                      creating table variable_history_354414613 for "WaterUse_09_Mar"
  SQL Logger                      creating table variable_history_871336451 for "WaterUse_10_Apr"
  SQL Logger                      creating table variable_history_1166240320 for "WaterUse_11_May"
  SQL Logger                      creating table variable_history_584269772 for "WaterUse_12_Jun"
  SQL Logger                      creating table variable_history_1334815005 for "WaterUse_13_July"
  SQL Logger                      creating table variable_history_1794370488 for "WaterUse_14_Aug"
  SQL Logger                      creating table variable_history_786426407 for "WaterUse_15_Sep"
  SQL Logger                      creating table variable_history_1994008790 for "WaterUse_16_Oct"
  SQL Logger                      creating table variable_history_1450287125 for "WaterUse_17_Nov"
  SQL Logger                      creating table variable_history_66101529 for "WaterUse_18_Dec"
  SQL Logger                      creating table variable_history_651670549 for "Water_Test_OFF"
  SQL Logger                      creating table variable_history_1068370211 for "Water_Test_ON"
  SQL Logger                      creating table variable_history_1039644084 for "Water_Test_Pool_House_OFF"
  SQL Logger                      creating table variable_history_1475141270 for "Water_Test_Pool_House_ON"
  SQL Logger                      creating table variable_history_1551982274 for "Water_Test_Pool_House_Success"
  SQL Logger                      creating table variable_history_670950840 for "Water_Test_Pool_House_Success_TimeStamp"
  SQL Logger                      creating table variable_history_723078975 for "Water_Test_Pool_Sprinkler_OFF"
  SQL Logger                      creating table variable_history_192402994 for "Water_Test_Pool_Sprinkler_ON"
  SQL Logger                      creating table variable_history_1153467002 for "Water_Test_Pool_Sprinkler_Success"
  SQL Logger                      creating table variable_history_1242034233 for "Water_Test_Pool_Sprinkler_Success_TimeStamp"
  SQL Logger                      creating table variable_history_1252719677 for "Water_Test_Success"
  SQL Logger                      creating table variable_history_1657243792 for "Water_Test_Success_TimeStamp"
  SQL Logger                      creating table variable_history_1428217227 for "Water_Use_Pool_ON_Intentionally"
  SQL Logger                      creating table variable_history_1741152620 for "Water_Use_Pool_System_Tight"
  SQL Logger                      creating table variable_history_1656160506 for "WeatherHighTemp"
  SQL Logger                      creating table variable_history_295134938 for "WeatherNOAA_Day1Period1TextForecast"
  SQL Logger                      creating table variable_history_1224435501 for "WeatherNOAA_Day1Period2TextForecast"
  SQL Logger                      creating table variable_history_678074835 for "WeatherTemp"
  SQL Logger                      creating table variable_history_586905576 for "WeatherWind"
  SQL Logger                      creating table variable_history_1309818217 for "WeatherWindChill"
  SQL Logger                      creating table variable_history_1854244458 for "WHA_AM_Preset_1"
  SQL Logger                      creating table variable_history_1300345780 for "WHA_AM_Preset_10"
  SQL Logger                      creating table variable_history_1537662708 for "WHA_AM_Preset_11"
  SQL Logger                      creating table variable_history_1451418833 for "WHA_AM_Preset_12"
  SQL Logger                      creating table variable_history_1821646040 for "WHA_AM_Preset_2"
  SQL Logger                      creating table variable_history_1953010582 for "WHA_AM_Preset_3"
  SQL Logger                      creating table variable_history_1130314544 for "WHA_AM_Preset_4"
  SQL Logger                      creating table variable_history_1948712384 for "WHA_AM_Preset_5"
  SQL Logger                      creating table variable_history_1254787935 for "WHA_AM_Preset_6"
  SQL Logger                      creating table variable_history_1741464072 for "WHA_AM_Preset_7"
  SQL Logger                      creating table variable_history_754158912 for "WHA_AM_Preset_8"
  SQL Logger                      creating table variable_history_203326009 for "WHA_AM_Preset_9"
  SQL Logger                      creating table variable_history_448751375 for "WHA_Button_1"
  SQL Logger                      creating table variable_history_1698379253 for "WHA_Button_10"
  SQL Logger                      creating table variable_history_1680011204 for "WHA_Button_11"
  SQL Logger                      creating table variable_history_163653675 for "WHA_Button_12"
  SQL Logger                      creating table variable_history_1429753844 for "WHA_Button_2"
  SQL Logger                      creating table variable_history_802833217 for "WHA_Button_3"
  SQL Logger                      creating table variable_history_301692624 for "WHA_Button_4"
  SQL Logger                      creating table variable_history_1237422216 for "WHA_Button_5"
  SQL Logger                      creating table variable_history_1521179759 for "WHA_Button_6"
  SQL Logger                      creating table variable_history_1373425845 for "WHA_Button_7"
  SQL Logger                      creating table variable_history_828124932 for "WHA_Button_8"
  SQL Logger                      creating table variable_history_589584161 for "WHA_Button_9"
  SQL Logger                      creating table variable_history_43085819 for "WHA_FM_Preset_1"
  SQL Logger                      creating table variable_history_137812252 for "WHA_FM_Preset_10"
  SQL Logger                      creating table variable_history_27345645 for "WHA_FM_Preset_11"
  SQL Logger                      creating table variable_history_81695758 for "WHA_FM_Preset_12"
  SQL Logger                      creating table variable_history_1221632355 for "WHA_FM_Preset_2"
  SQL Logger                      creating table variable_history_39673334 for "WHA_FM_Preset_3"
  SQL Logger                      creating table variable_history_1706366355 for "WHA_FM_Preset_4"
  SQL Logger                      creating table variable_history_783504796 for "WHA_FM_Preset_5"
  SQL Logger                      creating table variable_history_1248093823 for "WHA_FM_Preset_6"
  SQL Logger                      creating table variable_history_975532752 for "WHA_FM_Preset_7"
  SQL Logger                      creating table variable_history_1093371763 for "WHA_FM_Preset_8"
  SQL Logger                      creating table variable_history_292153212 for "WHA_FM_Preset_9"
  SQL Logger                      creating table variable_history_906063656 for "WHA_Music_28:CF:E9:84:B9:C8"
  SQL Logger                      creating table variable_history_1855001353 for "WHA_Radio_AM_FM"
  SQL Logger                      creating table variable_history_851887272 for "WHA_Radio_Display"
  SQL Logger                      creating table variable_history_135860641 for "WHA_Radio_HD_Display"
  SQL Logger                      creating table variable_history_1721554162 for "WHA_Radio_Preset"
  SQL Logger                      creating table variable_history_1527906532 for "Whole_House_Audio_AirPlay"
  SQL Logger                      creating table variable_history_1577365683 for "WLeakPool_1"
  SQL Logger                      creating table variable_history_927448188 for "WLeakPool_60min"
  SQL Logger                      creating table variable_history_523778877 for "WLeakTimePool_01"
  SQL Logger                      creating table variable_history_1104587795 for "WLeakTimePool_02"
  SQL Logger                      creating table variable_history_424043770 for "WLeakTimePool_03"
  SQL Logger                      creating table variable_history_1638936030 for "WLeakTimePool_04"
  SQL Logger                      creating table variable_history_12280567 for "WLeakTimePool_05"
  SQL Logger                      creating table variable_history_71620587 for "WLeakTimePool_06"
  SQL Logger                      creating table variable_history_1625444611 for "WLeakTimePool_07"
  SQL Logger                      creating table variable_history_1410723122 for "WLeakTimePool_08"
  SQL Logger                      creating table variable_history_1683331344 for "WLeakTimePool_09"
  SQL Logger                      creating table variable_history_963252272 for "WLeakTimePool_10"
  SQL Logger                      creating table variable_history_938916113 for "WLeakTimePool_11"
  SQL Logger                      creating table variable_history_53576191 for "WLeakTimePool_12"
  SQL Logger                      creating table variable_history_41376832 for "WLeakTimePool_13"
  SQL Logger                      creating table variable_history_1312250414 for "WLeakTimePool_14"
  SQL Logger                      creating table variable_history_454151688 for "WLeakTimePool_15"
  SQL Logger                      creating table variable_history_135518633 for "WLeakTimePool_16"
  SQL Logger                      creating table variable_history_47284170 for "WLeakTimePool_17"
  SQL Logger                      creating table variable_history_103615809 for "WLeakTimePool_18"
  SQL Logger                      creating table variable_history_1381213195 for "WLeakTimePool_19"
  SQL Logger                      creating table variable_history_456526323 for "WLeakTimePool_20"
  SQL Logger                      creating table variable_history_1039179652 for "WLeakTimePool_21"
  SQL Logger                      creating table variable_history_97125618 for "WLeakTimePool_22"
  SQL Logger                      creating table variable_history_1199867113 for "WLeakTimePool_23"
  SQL Logger                      creating table variable_history_1134370665 for "WLeakTimePool_24"
  SQL Logger                      creating table variable_history_299537487 for "WLeakTime_01"
  SQL Logger                      creating table variable_history_1785216502 for "WLeakTime_02"
  SQL Logger                      creating table variable_history_1880309521 for "WLeakTime_03"
  SQL Logger                      creating table variable_history_544642623 for "WLeakTime_04"
  SQL Logger                      creating table variable_history_1733968109 for "WLeakTime_05"
  SQL Logger                      creating table variable_history_356398203 for "WLeakTime_06"
  SQL Logger                      creating table variable_history_388597515 for "WLeakTime_07"
  SQL Logger                      creating table variable_history_1364416419 for "WLeakTime_08"
  SQL Logger                      creating table variable_history_1479657221 for "WLeakTime_09"
  SQL Logger                      creating table variable_history_68979186 for "WLeakTime_10"
  SQL Logger                      creating table variable_history_1972640916 for "WLeakTime_11"
  SQL Logger                      creating table variable_history_320524265 for "WLeakTime_12"
  SQL Logger                      creating table variable_history_184847925 for "WLeakTime_13"
  SQL Logger                      creating table variable_history_562405500 for "WLeakTime_14"
  SQL Logger                      creating table variable_history_86557131 for "WLeakTime_15"
  SQL Logger                      creating table variable_history_1433883696 for "WLeakTime_16"
  SQL Logger                      creating table variable_history_1346996506 for "WLeakTime_17"
  SQL Logger                      creating table variable_history_466414268 for "WLeakTime_18"
  SQL Logger                      creating table variable_history_1047388002 for "WLeakTime_19"
  SQL Logger                      creating table variable_history_79668888 for "WLeakTime_20"
  SQL Logger                      creating table variable_history_984294073 for "WLeakTime_21"
  SQL Logger                      creating table variable_history_461626470 for "WLeakTime_22"
  SQL Logger                      creating table variable_history_577181376 for "WLeakTime_23"
  SQL Logger                      creating table variable_history_540588854 for "WLeakTime_24"
  SQL Logger                      creating table variable_history_1159365246 for "WLeak_1"
  SQL Logger                      creating table variable_history_1336905790 for "Wunderground_Condition"
  SQL Logger                      creating table variable_history_463448936 for "Wunderground_Day1Conditions"
  SQL Logger                      creating table variable_history_1699782384 for "Wunderground_Day1High"
  SQL Logger                      creating table variable_history_889203527 for "Wunderground_Day1Icon"
  SQL Logger                      creating table variable_history_686417986 for "Wunderground_Day1Low"
  SQL Logger                      creating table variable_history_1185477852 for "Wunderground_Day1Name"
  SQL Logger                      creating table variable_history_1088884023 for "Wunderground_Day1Period1Name"
  SQL Logger                      creating table variable_history_1569599129 for "Wunderground_Day1Period1TextForecast"
  SQL Logger                      creating table variable_history_430956593 for "Wunderground_Day1Period2Name"
  SQL Logger                      creating table variable_history_1495137978 for "Wunderground_Day1Period2TextForecast"
  SQL Logger                      creating table variable_history_1686673610 for "Wunderground_Day2Conditions"
  SQL Logger                      creating table variable_history_28512237 for "Wunderground_Day2High"
  SQL Logger                      creating table variable_history_1337693269 for "Wunderground_Day2Icon"
  SQL Logger                      creating table variable_history_942414626 for "Wunderground_Day2Low"
  SQL Logger                      creating table variable_history_1890988524 for "Wunderground_Day2Name"
  SQL Logger                      creating table variable_history_1678816656 for "Wunderground_Day3Conditions"
  SQL Logger                      creating table variable_history_1489315573 for "Wunderground_Day3High"
  SQL Logger                      creating table variable_history_779605965 for "Wunderground_Day3Icon"
  SQL Logger                      creating table variable_history_197823213 for "Wunderground_Day3Low"
  SQL Logger                      creating table variable_history_260260074 for "Wunderground_Day3Name"
  SQL Logger                      creating table variable_history_90851191 for "Wunderground_Day4Conditions"
  SQL Logger                      creating table variable_history_1809599855 for "Wunderground_Day4High"
  SQL Logger                      creating table variable_history_1244784693 for "Wunderground_Day4Icon"
  SQL Logger                      creating table variable_history_936500328 for "Wunderground_Day4Low"
  SQL Logger                      creating table variable_history_1688568053 for "Wunderground_Day4Name"
  SQL Logger                      creating table variable_history_770201161 for "Wunderground_Day5Conditions"
  SQL Logger                      creating table variable_history_123526140 for "Wunderground_Day5High"
  SQL Logger                      creating table variable_history_1893350795 for "Wunderground_Day5Icon"
  SQL Logger                      creating table variable_history_213589865 for "Wunderground_Day5Low"
  SQL Logger                      creating table variable_history_1932116199 for "Wunderground_Day5Name"
  SQL Logger                      creating table variable_history_1733428481 for "Wunderground_Day6Conditions"
  SQL Logger                      creating table variable_history_192315642 for "Wunderground_Day6High"
  SQL Logger                      creating table variable_history_1687452621 for "Wunderground_Day6Icon"
  SQL Logger                      creating table variable_history_1937634274 for "Wunderground_Day6Low"
  SQL Logger                      creating table variable_history_1302472888 for "Wunderground_Day6Name"
  SQL Logger                      creating table variable_history_1204571537 for "Wunderground_Icon"
  SQL Logger                      creating table variable_history_1418557582 for "Wunderground_Location_City"
  SQL Logger                      creating table variable_history_868101505 for "Wunderground_Location_Display"
  SQL Logger                      creating table variable_history_1437775040 for "Wunderground_Location_Elevation"
  SQL Logger                      creating table variable_history_1007614592 for "Wunderground_Location_Full"
  SQL Logger                      creating table variable_history_1490745839 for "Wunderground_Observation_Time"
  SQL Logger                      creating table variable_history_1950126611 for "Wunderground_Observation_Time_rfc822"
  SQL Logger                      creating table variable_history_146696004 for "Wunderground_Obs_Time_Display"
  SQL Logger                      creating table variable_history_1116289820 for "Wunderground_Precip_1hr_in"
  SQL Logger                      creating table variable_history_1769825655 for "Wunderground_Precip_today_in"
  SQL Logger                      creating table variable_history_985569610 for "Wunderground_Precip_today_string"
  SQL Logger                      creating table variable_history_180160597 for "Wunderground_Pressure_in"
  SQL Logger                      creating table variable_history_1582669486 for "Wunderground_Relative_Humidity"
  SQL Logger                      creating table variable_history_130784198 for "Wunderground_StationID"
  SQL Logger                      creating table variable_history_402283138 for "Wunderground_Temperature_C"
  SQL Logger                      creating table variable_history_156895363 for "Wunderground_Temperature_F"
  SQL Logger                      creating table variable_history_995616871 for "Wunderground_Wind"
  SQL Logger                      creating table variable_history_1609677594 for "Wunder_City_1_APT"
  SQL Logger                      creating table variable_history_1760888784 for "Wunder_City_1_Location_Name"
  SQL Logger                      creating table variable_history_1414511997 for "Wunder_City_1_PWS"
  SQL Logger                      creating table variable_history_361198237 for "Wunder_City_1_ZIP"
  SQL Logger                      creating table variable_history_119343708 for "Wunder_City_2_APT"
  SQL Logger                      creating table variable_history_94545860 for "Wunder_City_2_Location_Name"
  SQL Logger                      creating table variable_history_1050525951 for "Wunder_City_2_PWS"
  SQL Logger                      creating table variable_history_1432733846 for "Wunder_City_2_ZIP"
  SQL Logger                      creating table variable_history_1320421847 for "Wunder_City_3_APT"
  SQL Logger                      creating table variable_history_1435321671 for "Wunder_City_3_Location_Name"
  SQL Logger                      creating table variable_history_155235375 for "Wunder_City_3_PWS"
  SQL Logger                      creating table variable_history_1015069085 for "Wunder_City_3_ZIP"
  SQL Logger                      creating table variable_history_658075953 for "Wunder_City_4_APT"
  SQL Logger                      creating table variable_history_213888568 for "Wunder_City_4_Location_Name"
  SQL Logger                      creating table variable_history_1530532922 for "Wunder_City_4_PWS"
  SQL Logger                      creating table variable_history_233645477 for "Wunder_City_4_ZIP"
  SQL Logger                      creating table variable_history_1092514236 for "Wunder_City_5_APT"
  SQL Logger                      creating table variable_history_1185516357 for "Wunder_City_5_Location_Name"
  SQL Logger                      creating table variable_history_723326702 for "Wunder_City_5_PWS"
  SQL Logger                      creating table variable_history_1104785979 for "Wunder_City_5_ZIP"
  SQL Logger                      creating table variable_history_1613339207 for "Wunder_City_6_APT"
  SQL Logger                      creating table variable_history_608258870 for "Wunder_City_6_Location_Name"
  SQL Logger                      creating table variable_history_426582867 for "Wunder_City_6_PWS"
  SQL Logger                      creating table variable_history_153594156 for "Wunder_City_6_ZIP"
  SQL Logger                      creating table variable_history_868233971 for "Yahoo_actual_condition"
  SQL Logger                      creating table variable_history_483132247 for "Yahoo_actual_temp"
  SQL Logger                      creating table variable_history_370010670 for "Yahoo_today_forecast"
  SQL Logger                      creating table variable_history_1215336907 for "Yahoo_today_max_temp"
  SQL Logger                      creating table variable_history_1599555297 for "Yahoo_today_min_temp"
  SQL Logger                      creating table variable_history_964983176 for "Yahoo_tomorrow_forecast"
  SQL Logger                      creating table variable_history_1768179849 for "Yahoo_tomorrow_max_temp"
  SQL Logger                      creating table variable_history_42681027 for "Yahoo_tomorrow_min_temp"
  SQL Logger                      creating table variable_history_973405336 for "z_iTunes_Playlist_1"
  SQL Logger                      creating table variable_history_673573880 for "z_iTunes_Playlist_2"
  SQL Logger                      creating table variable_history_1078592516 for "z_iTunes_Playlist_3"
  SQL Logger                      creating table variable_history_9928503 for "z_iTunes_Playlist_4"
  SQL Logger                      creating table variable_history_1060801983 for "z_iTunes_Playlist_5"
  SQL Logger                      creating table variable_history_1624508776 for "z_iTunes_Playlist_6"
  SQL Logger                      creating table variable_history_152318352 for "z_iTunes_Playlist_7"
  SQL Logger                      creating table variable_history_1959645203 for "z_iTunes_Playlist_8"
  SQL Logger                      creating table variable_history_899827566 for "z_iTunes_Playlist_9"
  SQL Logger                      creating table variable_history_569464843 for "z_iTunes_Radio_1"
  SQL Logger                      creating table variable_history_52633320 for "z_iTunes_Radio_2"
  SQL Logger                      creating table variable_history_1464885898 for "z_iTunes_Radio_3"
  SQL Logger                      creating table variable_history_13768651 for "z_iTunes_Radio_4"
  SQL Logger                      creating table variable_history_255882932 for "z_iTunes_Radio_5"
  SQL Logger                      creating table variable_history_651440709 for "z_iTunes_Radio_6"
  SQL Logger                      creating table variable_history_1772967526 for "z_iTunes_Radio_7"
  SQL Logger                      creating table variable_history_1962678626 for "z_iTunes_Radio_8"
  SQL Logger                      creating table variable_history_1425988482 for "z_iTunes_Radio_9"
  SQL Logger                      creating table variable_history_751314555 for "z_Pandora_Radio_1"
  SQL Logger                      creating table variable_history_1950150173 for "z_Pandora_Radio_10"
  SQL Logger                      creating table variable_history_1342892255 for "z_Pandora_Radio_2"
  SQL Logger                      creating table variable_history_713893363 for "z_Pandora_Radio_3"
  SQL Logger                      creating table variable_history_1214196419 for "z_Pandora_Radio_4"
  SQL Logger                      creating table variable_history_1453527866 for "z_Pandora_Radio_5"
  SQL Logger                      creating table variable_history_1496247800 for "z_Pandora_Radio_6"
  SQL Logger                      creating table variable_history_6079527 for "z_Pandora_Radio_7"
  SQL Logger                      creating table variable_history_1075154839 for "z_Pandora_Radio_8"
  SQL Logger                      creating table variable_history_1845603984 for "z_Pandora_Radio_9"
  SQL Logger                      creating table variable_history_520457294 for "_Weather_Fetch_Station"
  SQL Logger                      creating table variable_history_1004605254 for "_Wunderground_APT"
  SQL Logger                      creating table variable_history_204645406 for "_Wunderground_PWS_List"
  SQL Logger                      creating table variable_history_1425455732 for "_Wunderground_ZIP"
  SQL Logger                      creating table variable_history_196791660 for "_Wunder_City_Choice"
  SQL Logger                      update complete


Anyway, I reloaded IndigoPlot and still got this error.

Code: Select all
Nov 5, 2014 10:41:27 PM
  Enabling plugin "INDIGOplotD 3.5.3"
  Starting plugin "INDIGOplotD 3.5.3" (pid 85253)
  Started plugin "INDIGOplotD 3.5.3"
  INDIGOplotD                     initializing  ... 3-5-3
  INDIGOplotD                     indigo version found: 6
  INDIGOplotD                      read file /Users/WilliamsEC/Documents/INDIGOplotD/data/minute.dat lines: 2304  ok
  INDIGOplotD                      read file /Users/WilliamsEC/Documents/INDIGOplotD/data/hour.dat lines: 912  ok
  INDIGOplotD                      read file /Users/WilliamsEC/Documents/INDIGOplotD/data/day.dat lines: 390  ok
  INDIGOplotD Error               ------------------------------------
  INDIGOplotD Error               redolineDataSource device/state/measurement is listed twice in index, remove last i1:1 i2:2 devNo:1 stateNo:1  points to humidity
  INDIGOplotD Error               ------------------------------------
  INDIGOplotD Error               Error in plugin execution startup:

Traceback (most recent call last):
  File "plugin.py", line 500, in startup
  File "plugin.py", line 4774, in redolineDataSource
  File "plugin.py", line 4991, in removeColumnFromIndexes
<type 'exceptions.IndexError'>: list assignment index out of range

  INDIGOplotD                     initialized
  INDIGOplotD Error               Error in plugin execution runConcurrentThread:

Traceback (most recent call last):
  File "plugin.py", line 5164, in runConcurrentThread
  File "plugin.py", line 1140, in createPy
<type 'exceptions.IndexError'>: list index out of range

  INDIGOplotD Error               plugin runConcurrentThread function returned or failed (will attempt again in 10 seconds)
  INDIGOplotD                     initialized
  INDIGOplotD Error               Error in plugin execution runConcurrentThread:

Traceback (most recent call last):
  File "plugin.py", line 5164, in runConcurrentThread
  File "plugin.py", line 1140, in createPy
<type 'exceptions.IndexError'>: list index out of range

  INDIGOplotD Error               plugin runConcurrentThread function returned or failed (will attempt again in 10 seconds)
  INDIGOplotD                     initialized
  INDIGOplotD Error               Error in plugin execution runConcurrentThread:

Traceback (most recent call last):
  File "plugin.py", line 5164, in runConcurrentThread
  File "plugin.py", line 1140, in createPy
<type 'exceptions.IndexError'>: list index out of range

  INDIGOplotD Error               plugin runConcurrentThread function returned or failed (will attempt again in 10 seconds)
  Error                           script error: Can’t make characters 12 thru -1 of "" into type text. (-1700)
  INDIGOplotD                     initialized
  INDIGOplotD Error               Error in plugin execution runConcurrentThread:

Traceback (most recent call last):
  File "plugin.py", line 5164, in runConcurrentThread
  File "plugin.py", line 1140, in createPy
<type 'exceptions.IndexError'>: list index out of range

  INDIGOplotD Error               plugin runConcurrentThread function returned or failed (will attempt again in 10 seconds)
  INDIGOplotD                     initialized
  INDIGOplotD Error               Error in plugin execution runConcurrentThread:

Traceback (most recent call last):
  File "plugin.py", line 5164, in runConcurrentThread
  File "plugin.py", line 1140, in createPy
<type 'exceptions.IndexError'>: list index out of range

  INDIGOplotD Error               plugin runConcurrentThread function returned or failed (will attempt again in 10 seconds)

Posted on
Thu Nov 06, 2014 10:36 am
kw123 offline
User avatar
Posts: 5599
Joined: May 12, 2013
Location: Dallas, TX

Re: Error using SQL Logger event as a trigger

you also need to reset indigoplotD data. If your database was screwy it might get confused.


1. disable indigoplotd, delete all indigoplotd devices
2. stop indigo & indigo server
3. delete indiplotd plugin prefs file in the indigo directory : /Library/Application Support/Perceptive Automation/Indigo 6/Preferences/Indigo Server Settings.indiPref
4. restart indigo
5. enable indigoplotd

Thats the max reset I know to do.

will check the error code this weekend when I am back home

Karl

Posted on
Thu Nov 06, 2014 11:11 am
kw123 offline
User avatar
Posts: 5599
Joined: May 12, 2013
Location: Dallas, TX

Re: Error using SQL Logger event as a trigger

on your database: could you look at the old database (I hope you just renamed it).

With only 2 months of data it should be very difficult to create 20 GByte of data.
Assume a single entry is 20 bytes. That would be equivalent to 10^9 changes in your DB in 2 months.
1 day has 70,000 seconds, so 2 months would be 4.2 Million seconds. That's a very rough estimate, but should give an idea on the number of possible entries.

In summary 20GByte would be equivalent to 250 entries per second!! That on its own would keep INDIGO really busy just filling the DB

With the tool I mentioned, you can look at the database : the entries and the size for each variable/ device entry.
It would be good to understand if there is a single variable or device that triggers the number of entries..

Again with my 100+ devices etc I am still at 2GByte after 10 months


Karl

Posted on
Thu Nov 06, 2014 11:55 am
kw123 offline
User avatar
Posts: 5599
Joined: May 12, 2013
Location: Dallas, TX

Re: Error using SQL Logger event as a trigger

HAMW,
checked the code ...
that error was fixed in v 3.5.7: see: http://forums.indigodomo.com/viewtopic.php?f=134&t=12754

Karl

Page 1 of 1

Who is online

Users browsing this forum: No registered users and 1 guest