Started getting loads of SQL Logger errors

SQL Logger Error exception trying to insert row into table device_history_897987201 ("Chart - Radiator - Molly") -- unable to modify table
SQL Logger Error ERROR: relation "device_history_1244742273" already exists

SQL Logger Error INSERT INTO device_history_897987201 ("onoffstate_ui") VALUES (%s);
SQL Logger Error exception trying to insert row into table device_history_1407373553 ("Chart - Upstairs Temperature 2") -- unable to modify table
SQL Logger Error ERROR: relation "device_history_1481693867" already exists

SQL Logger Error INSERT INTO device_history_1407373553 ("onoffstate_ui", "chartlastupdated") VALUES (%s, %s);
SQL Logger Error exception trying to update table device_history_1087164079 ("Chart Mini - Trend Outdoor Temp") -- unable to modify table
SQL Logger Error ERROR: column "onoffstate_ui" of relation "device_history_1397910361" does not exist at character 40

SQL Logger Error exception trying to insert row into table device_history_1087164079 ("Chart Mini - Trend Outdoor Temp") -- unable to modify table
SQL Logger Error ERROR: column "onoffstate_ui" of relation "device_history_1397910361" does not exist at character 40

SQL Logger Error INSERT INTO device_history_1087164079 ("onoffstate_ui", "chartlastupdated") VALUES (%s, %s);

QL Logger Error exception trying to update table device_history_77232060 ("Sunroom Group") -- unable to modify table
SQL Logger Error ERROR: column "onoffstate_ui" of relation "device_history_1397910361" does not exist at character 40

SQL Logger Error exception trying to insert row into table device_history_77232060 ("Sunroom Group") -- unable to modify table
SQL Logger Error ERROR: column "onoffstate_ui" of relation "device_history_1397910361" does not exist at character 40

SQL Logger Error INSERT INTO device_history_77232060 ("alertmode") VALUES (%s);

052 ("Master Bedroom Group") -- unable to modify table
SQL Logger Error ERROR: column "onoffstate_ui" of relation "device_history_1397910361" does not exist at character 40

SQL Logger Error exception trying to insert row into table device_history_898828052 ("Master Bedroom Group") -- unable to modify table
SQL Logger Error ERROR: column "onoffstate_ui" of relation "device_history_1397910361" does not exist at character 40

SQL Logger Error INSERT INTO device_history_898828052 ("alertmode") VALUES (%s);

The errors are wide, varied and plentiful. They started in the last 24 hours.

Not too sure what to do with this - any suggestions?

Thanks

OK Restarting SQL Logger caused it to run in total vomit mode.

5 SQL Logger creating table variable_history_1957713339 for "BatteryAlertDisplayIndicator"
2019-09-07 12:38:33.140 SQL Logger Error exception trying to insert row into table variable_history_1957713339 ("BatteryAlertDisplayIndicator")
2019-09-07 12:38:33.140 SQL Logger Error ERROR: relation "variable_history_1957713339" already exists

2019-09-07 12:38:33.141 SQL Logger Error INSERT INTO variable_history_1957713339 (value) VALUES (%s);
2019-09-07 12:38:33.147 SQL Logger creating table variable_history_1428770779 for "Cam01Resets"
2019-09-07 12:38:33.152 SQL Logger Error exception trying to insert row into table variable_history_1428770779 ("Cam01Resets")
2019-09-07 12:38:33.152 SQL Logger Error ERROR: relation "variable_history_1428770779" already exists

2019-09-07 12:38:33.153 SQL Logger Error INSERT INTO variable_history_1428770779 (value) VALUES (%s);
2019-09-07 12:38:33.228 SQL Logger creating table variable_history_954990813 for "Cam02Resets"
2019-09-07 12:38:33.233 SQL Logger Error exception trying to insert row into table variable_history_954990813 ("Cam02Resets")
2019-09-07 12:38:33.233 SQL Logger Error ERROR: relation "variable_history_954990813" already exists

2019-09-07 12:38:33.234 SQL Logger Error INSERT INTO variable_history_954990813 (value) VALUES (%s);
2019-09-07 12:38:33.381 SQL Logger creating table variable_history_546307394 for "Cam03Resets"
2019-09-07 12:38:33.388 SQL Logger Error exception trying to insert row into table variable_history_546307394 ("Cam03Resets")
2019-09-07 12:38:33.389 SQL Logger Error ERROR: relation "variable_history_546307394" already exists

2019-09-07 12:38:33.389 SQL Logger Error INSERT INTO variable_history_546307394 (value) VALUES (%s);
2019-09-07 12:38:33.550 SQL Logger creating table variable_history_837898648 for "Cam04Resets"
2019-09-07 12:38:33.556 SQL Logger Error exception trying to insert row into table variable_history_837898648 ("Cam04Resets")
2019-09-07 12:38:33.556 SQL Logger Error ERROR: relation "variable_history_837898648" already exists

2019-09-07 12:38:33.557 SQL Logger Error INSERT INTO variable_history_837898648 (value) VALUES (%s);
2019-09-07 12:38:33.741 SQL Logger creating table variable_history_139577013 for "Cam05Resets"
2019-09-07 12:38:33.748 SQL Logger Error exception trying to insert row into table variable_history_139577013 ("Cam05Resets")
2019-09-07 12:38:33.749 SQL Logger Error ERROR: relation "variable_history_139577013" already exists

2019-09-07 12:38:33.749 SQL Logger Error INSERT INTO variable_history_139577013 (value) VALUES (%s);
2019-09-07 12:38:33.801 Hue Lights received "Luminance - Landing 2 (Hue)" sensor update to 69.5 lux
2019-09-07 12:38:33.889 SQL Logger creating table variable_history_1184661156 for "Cam06Resets"
2019-09-07 12:38:33.895 SQL Logger Error exception trying to insert row into table variable_history_1184661156 ("Cam06Resets")
2019-09-07 12:38:33.895 SQL Logger Error ERROR: relation "variable_history_1184661156" already exists

2019-09-07 12:38:33.896 SQL Logger Error INSERT INTO variable_history_1184661156 (value) VALUES (%s);
2019-09-07 12:38:33.978 SQL Logger creating table variable_history_1312547002 for "CamSyncTime"
2019-09-07 12:38:33.983 SQL Logger Error exception trying to insert row into table variable_history_1312547002 ("CamSyncTime")
2019-09-07 12:38:33.984 SQL Logger Error ERROR: relation "variable_history_1312547002" already exists

2019-09-07 12:38:33.984 SQL Logger Error INSERT INTO variable_history_1312547002 (value) VALUES (%s);
2019-09-07 12:38:34.253 SQL Logger creating table variable_history_336003279 for "CO2"
2019-09-07 12:38:34.259 SQL Logger Error exception trying to insert row into table variable_history_336003279 ("CO2")
2019-09-07 12:38:34.259 SQL Logger Error ERROR: relation "variable_history_336003279" already exists

2019-09-07 12:38:34.260 SQL Logger Error INSERT INTO variable_history_336003279 (value) VALUES (%s);
2019-09-07 12:38:34.294 SQL Logger creating table variable_history_1497703047 for "Computer"
2019-09-07 12:38:34.322 SQL Logger Error exception trying to insert row into table variable_history_1497703047 ("Computer")
2019-09-07 12:38:34.323 SQL Logger Error ERROR: relation "variable_history_1497703047" already exists

2019-09-07 12:38:34.324 SQL Logger Error INSERT INTO variable_history_1497703047 (value) VALUES (%s);
2019-09-07 12:38:34.445 SQL Logger creating table variable_history_63589904 for "CoolingDown"
2019-09-07 12:38:34.450 SQL Logger Error exception trying to insert row into table variable_history_63589904 ("CoolingDown")
2019-09-07 12:38:34.450 SQL Logger Error ERROR: relation "variable_history_63589904" already exists

2019-09-07 12:38:34.451 SQL Logger Error INSERT INTO variable_history_63589904 (value) VALUES (%s);
2019-09-07 12:38:34.504 SQL Logger creating table variable_history_908141670 for "CurrentMeterReading"
2019-09-07 12:38:34.509 SQL Logger Error exception trying to insert row into table variable_history_908141670 ("CurrentMeterReading")
2019-09-07 12:38:34.510 SQL Logger Error ERROR: relation "variable_history_908141670" already exists

2019-09-07 12:38:34.510 SQL Logger Error INSERT INTO variable_history_908141670 (value) VALUES (%s);
2019-09-07 12:38:34.538 SQL Logger creating table variable_history_1636491885 for "CurrentRoom1"
2019-09-07 12:38:34.544 SQL Logger Error exception trying to insert row into table variable_history_1636491885 ("CurrentRoom1")
2019-09-07 12:38:34.544 SQL Logger Error ERROR: relation "variable_history_1636491885" already exists

2019-09-07 12:38:34.544 SQL Logger Error INSERT INTO variable_history_1636491885 (value) VALUES (%s);
2019-09-07 12:38:34.582 SQL Logger creating table variable_history_537888298 for "CurrentRoom2"
2019-09-07 12:38:34.588 SQL Logger Error exception trying to insert row into table variable_history_537888298 ("CurrentRoom2")
2019-09-07 12:38:34.588 SQL Logger Error ERROR: relation "variable_history_537888298" already exists

2019-09-07 12:38:34.588 SQL Logger Error INSERT INTO variable_history_537888298 (value) VALUES (%s);
2019-09-07 12:38:34.596 SQL Logger creating table variable_history_944735064 for "CurrentRoom3"
2019-09-07 12:38:34.602 SQL Logger Error exception trying to insert row into table variable_history_944735064 ("CurrentRoom3")
2019-09-07 12:38:34.603 SQL Logger Error ERROR: relation "variable_history_944735064" already exists

2019-09-07 12:38:34.603 SQL Logger Error INSERT INTO variable_history_944735064 (value) VALUES (%s);
2019-09-07 12:38:34.638 SQL Logger creating table variable_history_136575546 for "CurrentSource"
2019-09-07 12:38:34.644 SQL Logger Error exception trying to insert row into table variable_history_136575546 ("CurrentSource")
2019-09-07 12:38:34.644 SQL Logger Error ERROR: relation "variable_history_136575546" already exists

2019-09-07 12:38:34.644 SQL Logger Error INSERT INTO variable_history_136575546 (value) VALUES (%s);
2019-09-07 12:38:34.651 SQL Logger creating table variable_history_229026559 for "CurrentTemp1"
2019-09-07 12:38:34.657 SQL Logger Error exception trying to insert row into table variable_history_229026559 ("CurrentTemp1")
2019-09-07 12:38:34.657 SQL Logger Error ERROR: relation "variable_history_229026559" already exists

2019-09-07 12:38:34.657 SQL Logger Error INSERT INTO variable_history_229026559 (value) VALUES (%s);
2019-09-07 12:38:34.664 SQL Logger creating table variable_history_1832519281 for "CurrentTemp2"
2019-09-07 12:38:34.671 SQL Logger Error exception trying to insert row into table variable_history_1832519281 ("CurrentTemp2")
2019-09-07 12:38:34.671 SQL Logger Error ERROR: relation "variable_history_1832519281" already exists

2019-09-07 12:38:34.672 SQL Logger Error INSERT INTO variable_history_1832519281 (value) VALUES (%s);
2019-09-07 12:38:34.712 SQL Logger creating table variable_history_1139478666 for "CurrentTemp3"
2019-09-07 12:38:34.718 SQL Logger Error exception trying to insert row into table variable_history_1139478666 ("CurrentTemp3")
2019-09-07 12:38:34.719 SQL Logger Error ERROR: relation "variable_history_1139478666" already exists

2019-09-07 12:38:34.719 SQL Logger Error INSERT INTO variable_history_1139478666 (value) VALUES (%s);
2019-09-07 12:38:34.725 SQL Logger creating table variable_history_342381418 for "CurrentUsage"
2019-09-07 12:38:34.731 SQL Logger Error exception trying to insert row into table variable_history_342381418 ("CurrentUsage")
2019-09-07 12:38:34.731 SQL Logger Error ERROR: relation "variable_history_342381418" already exists

2019-09-07 12:38:34.732 SQL Logger Error INSERT INTO variable_history_342381418 (value) VALUES (%s);
2019-09-07 12:38:34.738 SQL Logger creating table variable_history_19986942 for "DawnHome"
2019-09-07 12:38:34.744 SQL Logger Error exception trying to insert row into table variable_history_19986942 ("DawnHome")
2019-09-07 12:38:34.744 SQL Logger Error ERROR: relation "variable_history_19986942" already exists

2019-09-07 12:38:34.744 SQL Logger Error INSERT INTO variable_history_19986942 (value) VALUES (%s);
2019-09-07 12:38:34.794 SQL Logger creating table variable_history_1321699750 for "DawniPhoneHome"
2019-09-07 12:38:34.799 SQL Logger Error exception trying to insert row into table variable_history_1321699750 ("DawniPhoneHome")
2019-09-07 12:38:34.800 SQL Logger Error ERROR: relation "variable_history_1321699750" already exists

2019-09-07 12:38:34.800 SQL Logger Error INSERT INTO variable_history_1321699750 (value) VALUES (%s);
2019-09-07 12:38:34.807 SQL Logger creating table variable_history_571386628 for "DawnsiPhoneHome"
2019-09-07 12:38:34.813 SQL Logger Error exception trying to insert row into table variable_history_571386628 ("DawnsiPhoneHome")
2019-09-07 12:38:34.813 SQL Logger Error ERROR: relation "variable_history_571386628" already exists

2019-09-07 12:38:34.815 SQL Logger Error INSERT INTO variable_history_571386628 (value) VALUES (%s);
2019-09-07 12:38:34.845 SQL Logger creating table variable_history_164159253 for "Device"
2019-09-07 12:38:34.851 SQL Logger Error exception trying to insert row into table variable_history_164159253 ("Device")
2019-09-07 12:38:34.851 SQL Logger Error ERROR: relation "variable_history_164159253" already exists

2019-09-07 12:38:34.852 SQL Logger Error INSERT INTO variable_history_164159253 (value) VALUES (%s);
2019-09-07 12:38:34.858 SQL Logger creating table variable_history_1432219642 for "DisableAlexa"
2019-09-07 12:38:34.940 SQL Logger Error exception trying to insert row into table variable_history_1432219642 ("DisableAlexa")
2019-09-07 12:38:34.940 SQL Logger Error ERROR: relation "variable_history_1432219642" already exists

2019-09-07 12:38:34.941 SQL Logger Error INSERT INTO variable_history_1432219642 (value) VALUES (%s);
2019-09-07 12:38:34.987 SQL Logger creating table variable_history_1378163756 for "DomoPadCriticalAlert"
2019-09-07 12:38:34.994 SQL Logger Error exception trying to insert row into table variable_history_1378163756 ("DomoPadCriticalAlert")
2019-09-07 12:38:34.995 SQL Logger Error ERROR: relation "variable_history_1378163756" already exists

2019-09-07 12:38:34.995 SQL Logger Error INSERT INTO variable_history_1378163756 (value) VALUES (%s);
2019-09-07 12:38:35.015 SQL Logger creating table variable_history_1421776960 for "doorbelllast"
2019-09-07 12:38:35.023 SQL Logger Error exception trying to insert row into table variable_history_1421776960 ("doorbelllast")
2019-09-07 12:38:35.023 SQL Logger Error ERROR: relation "variable_history_1421776960" already exists

2019-09-07 12:38:35.023 SQL Logger Error INSERT INTO variable_history_1421776960 (value) VALUES (%s);
2019-09-07 12:38:35.032 SQL Logger creating table variable_history_639061416 for "Echo-LXU"
2019-09-07 12:38:35.039 SQL Logger Error exception trying to insert row into table variable_history_639061416 ("Echo-LXU")
2019-09-07 12:38:35.040 SQL Logger Error ERROR: relation "variable_history_639061416" already exists

2019-09-07 12:38:35.040 SQL Logger Error INSERT INTO variable_history_639061416 (value) VALUES (%s);
2019-09-07 12:38:35.077 SQL Logger creating table variable_history_1267641881 for "externalCams"
2019-09-07 12:38:35.090 SQL Logger Error exception trying to insert row into table variable_history_1267641881 ("externalCams")
2019-09-07 12:38:35.090 SQL Logger Error ERROR: relation "variable_history_1267641881" already exists

2019-09-07 12:38:35.090 SQL Logger Error INSERT INTO variable_history_1267641881 (value) VALUES (%s);
2019-09-07 12:38:35.177 SQL Logger creating table variable_history_143480449 for "fade_fast"
2019-09-07 12:38:35.186 SQL Logger Error exception trying to insert row into table variable_history_143480449 ("fade_fast")
2019-09-07 12:38:35.186 SQL Logger Error ERROR: relation "variable_history_143480449" already exists

2019-09-07 12:38:35.186 SQL Logger Error INSERT INTO variable_history_143480449 (value) VALUES (%s);
2019-09-07 12:38:35.197 SQL Logger creating table variable_history_1001323223 for "fade_instant"
2019-09-07 12:38:35.206 SQL Logger Error exception trying to insert row into table variable_history_1001323223 ("fade_instant")
2019-09-07 12:38:35.206 SQL Logger Error ERROR: relation "variable_history_1001323223" already exists

2019-09-07 12:38:35.207 SQL Logger Error INSERT INTO variable_history_1001323223 (value) VALUES (%s);
2019-09-07 12:38:35.224 SQL Logger creating table variable_history_1954490999 for "fade_long"
2019-09-07 12:38:35.242 SQL Logger Error exception trying to insert row into table variable_history_1954490999 ("fade_long")
2019-09-07 12:38:35.243 SQL Logger Error ERROR: relation "variable_history_1954490999" already exists

2019-09-07 12:38:35.243 SQL Logger Error INSERT INTO variable_history_1954490999 (value) VALUES (%s);
2019-09-07 12:38:35.264 SQL Logger creating table variable_history_1003784229 for "fade_slow"
2019-09-07 12:38:35.270 SQL Logger Error exception trying to insert row into table variable_history_1003784229 ("fade_slow")
2019-09-07 12:38:35.271 SQL Logger Error ERROR: relation "variable_history_1003784229" already exists

2019-09-07 12:38:35.271 SQL Logger Error INSERT INTO variable_history_1003784229 (value) VALUES (%s);
2019-09-07 12:38:35.327 SQL Logger creating table variable_history_702152463 for "FingEventDevChangedIndigoId"
2019-09-07 12:38:35.335 SQL Logger Error exception trying to insert row into table variable_history_702152463 ("FingEventDevChangedIndigoId")
2019-09-07 12:38:35.335 SQL Logger Error ERROR: relation "variable_history_702152463" already exists

2019-09-07 12:38:35.336 SQL Logger Error INSERT INTO variable_history_702152463 (value) VALUES (%s);
2019-09-07 12:38:35.344 SQL Logger creating table variable_history_968763990 for "Fireplace"
2019-09-07 12:38:35.353 SQL Logger Error exception trying to insert row into table variable_history_968763990 ("Fireplace")
2019-09-07 12:38:35.354 SQL Logger Error ERROR: relation "variable_history_968763990" already exists

2019-09-07 12:38:35.355 SQL Logger Error INSERT INTO variable_history_968763990 (value) VALUES (%s);
2019-09-07 12:38:35.389 SQL Logger creating table variable_history_780106338 for "FreezerDoorClosed"
2019-09-07 12:38:35.412 SQL Logger Error exception trying to insert row into table variable_history_780106338 ("FreezerDoorClosed")
2019-09-07 12:38:35.412 SQL Logger Error ERROR: relation "variable_history_780106338" already exists

2019-09-07 12:38:35.412 SQL Logger Error INSERT INTO variable_history_780106338 (value) VALUES (%s);
2019-09-07 12:38:35.564 SQL Logger creating table variable_history_106438948 for "FreezerDoorStatus"
2019-09-07 12:38:35.570 SQL Logger Error exception trying to insert row into table variable_history_106438948 ("FreezerDoorStatus")
2019-09-07 12:38:35.570 SQL Logger Error ERROR: relation "variable_history_106438948" already exists

2019-09-07 12:38:35.571 SQL Logger Error INSERT INTO variable_history_106438948 (value) VALUES (%s);
2019-09-07 12:38:35.645 SQL Logger creating table variable_history_959943013 for "FreezerElecIndicator"
2019-09-07 12:38:35.651 SQL Logger Error exception trying to insert row into table variable_history_959943013 ("FreezerElecIndicator")
2019-09-07 12:38:35.651 SQL Logger Error ERROR: relation "variable_history_959943013" already exists

2019-09-07 12:38:35.652 SQL Logger Error INSERT INTO variable_history_959943013 (value) VALUES (%s);
2019-09-07 12:38:35.659 SQL Logger creating table variable_history_1173045346 for "FreezerOpenButtonDefault"
2019-09-07 12:38:35.666 SQL Logger Error exception trying to insert row into table variable_history_1173045346 ("FreezerOpenButtonDefault")
2019-09-07 12:38:35.667 SQL Logger Error ERROR: relation "variable_history_1173045346" already exists

2019-09-07 12:38:35.667 SQL Logger Error INSERT INTO variable_history_1173045346 (value) VALUES (%s);
2019-09-07 12:38:35.788 SQL Logger creating table variable_history_429628348 for "FreezerTargetTemp"
2019-09-07 12:38:35.793 SQL Logger Error exception trying to insert row into table variable_history_429628348 ("FreezerTargetTemp")
2019-09-07 12:38:35.793 SQL Logger Error ERROR: relation "variable_history_429628348" already exists

2019-09-07 12:38:35.794 SQL Logger Error INSERT INTO variable_history_429628348 (value) VALUES (%s);
2019-09-07 12:38:35.836 SQL Logger creating table variable_history_168342514 for "FreezerTempInRange"
2019-09-07 12:38:35.842 SQL Logger Error exception trying to insert row into table variable_history_168342514 ("FreezerTempInRange")
2019-09-07 12:38:35.843 SQL Logger Error ERROR: relation "variable_history_168342514" already exists

2019-09-07 12:38:35.843 SQL Logger Error INSERT INTO variable_history_168342514 (value) VALUES (%s);
2019-09-07 12:38:35.881 SQL Logger creating table variable_history_1452034398 for "FreezerTempStatus"
2019-09-07 12:38:35.887 SQL Logger Error exception trying to insert row into table variable_history_1452034398 ("FreezerTempStatus")
2019-09-07 12:38:35.888 SQL Logger Error ERROR: relation "variable_history_1452034398" already exists

2019-09-07 12:38:35.888 SQL Logger Error INSERT INTO variable_history_1452034398 (value) VALUES (%s);
2019-09-07 12:38:35.927 SQL Logger creating table variable_history_143586066 for "FridgeTargetTemp"
2019-09-07 12:38:35.933 SQL Logger Error exception trying to insert row into table variable_history_143586066 ("FridgeTargetTemp")
2019-09-07 12:38:35.934 SQL Logger Error ERROR: relation "variable_history_143586066" already exists

2019-09-07 12:38:35.934 SQL Logger Error INSERT INTO variable_history_143586066 (value) VALUES (%s);
2019-09-07 12:38:35.985 SQL Logger creating table variable_history_1742815480 for "FridgeTempinRange"
2019-09-07 12:38:35.991 SQL Logger Error exception trying to insert row into table variable_history_1742815480 ("FridgeTempinRange")
2019-09-07 12:38:35.992 SQL Logger Error ERROR: relation "variable_history_1742815480" already exists

2019-09-07 12:38:35.992 SQL Logger Error INSERT INTO variable_history_1742815480 (value) VALUES (%s);
2019-09-07 12:38:36.036 SQL Logger creating table variable_history_108732898 for "FridgeTempStatus"
2019-09-07 12:38:36.042 SQL Logger Error exception trying to insert row into table variable_history_108732898 ("FridgeTempStatus")
2019-09-07 12:38:36.042 SQL Logger Error ERROR: relation "variable_history_108732898" already exists

2019-09-07 12:38:36.042 SQL Logger Error INSERT INTO variable_history_108732898 (value) VALUES (%s);
2019-09-07 12:38:36.048 SQL Logger creating table variable_history_40518742 for "Garage"
2019-09-07 12:38:36.054 SQL Logger Error exception trying to insert row into table variable_history_40518742 ("Garage")
2019-09-07 12:38:36.054 SQL Logger Error ERROR: relation "variable_history_40518742" already exists

2019-09-07 12:38:36.054 SQL Logger Error INSERT INTO variable_history_40518742 (value) VALUES (%s);
2019-09-07 12:38:36.143 SQL Logger creating table variable_history_1830902131 for "GoodnightMode"
2019-09-07 12:38:36.150 SQL Logger Error exception trying to insert row into table variable_history_1830902131 ("GoodnightMode")
2019-09-07 12:38:36.151 SQL Logger Error ERROR: relation "variable_history_1830902131" already exists

2019-09-07 12:38:36.151 SQL Logger Error INSERT INTO variable_history_1830902131 (value) VALUES (%s);
2019-09-07 12:38:36.163 SQL Logger creating table variable_history_688437384 for "GoodNightModeIndicator"
2019-09-07 12:38:36.177 SQL Logger Error exception trying to insert row into table variable_history_688437384 ("GoodNightModeIndicator")
2019-09-07 12:38:36.177 SQL Logger Error ERROR: relation "variable_history_688437384" already exists

2019-09-07 12:38:36.177 SQL Logger Error INSERT INTO variable_history_688437384 (value) VALUES (%s);
2019-09-07 12:38:36.221 SQL Logger creating table variable_history_1185424462 for "GuestMode"
2019-09-07 12:38:36.227 SQL Logger Error exception trying to insert row into table variable_history_1185424462 ("GuestMode")
2019-09-07 12:38:36.227 SQL Logger Error ERROR: relation "variable_history_1185424462" already exists

2019-09-07 12:38:36.228 SQL Logger Error INSERT INTO variable_history_1185424462 (value) VALUES (%s);
2019-09-07 12:38:36.296 SQL Logger creating table variable_history_1453077906 for "GuestModeIndicator"
2019-09-07 12:38:36.302 SQL Logger Error exception trying to insert row into table variable_history_1453077906 ("GuestModeIndicator")
2019-09-07 12:38:36.302 SQL Logger Error ERROR: relation "variable_history_1453077906" already exists

2019-09-07 12:38:36.303 SQL Logger Error INSERT INTO variable_history_1453077906 (value) VALUES (%s);
2019-09-07 12:38:36.320 SQL Logger creating table variable_history_1337710908 for "Harmony"
2019-09-07 12:38:36.325 SQL Logger Error exception trying to insert row into table variable_history_1337710908 ("Harmony")
2019-09-07 12:38:36.326 SQL Logger Error ERROR: relation "variable_history_1337710908" already exists

2019-09-07 12:38:36.326 SQL Logger Error INSERT INTO variable_history_1337710908 (value) VALUES (%s);
2019-09-07 12:38:36.553 SQL Logger creating table variable_history_1250943163 for "HeatingAvailable"
2019-09-07 12:38:36.559 SQL Logger Error exception trying to insert row into table variable_history_1250943163 ("HeatingAvailable")
2019-09-07 12:38:36.559 SQL Logger Error ERROR: relation "variable_history_1250943163" already exists

2019-09-07 12:38:36.559 SQL Logger Error INSERT INTO variable_history_1250943163 (value) VALUES (%s);
2019-09-07 12:38:36.601 SQL Logger creating table variable_history_1701363198 for "HeatingDemand"
2019-09-07 12:38:36.656 SQL Logger Error exception trying to insert row into table variable_history_1701363198 ("HeatingDemand")
2019-09-07 12:38:36.657 SQL Logger Error ERROR: relation "variable_history_1701363198" already exists

2019-09-07 12:38:36.657 SQL Logger Error INSERT INTO variable_history_1701363198 (value) VALUES (%s);
2019-09-07 12:38:36.720 SQL Logger creating table variable_history_563885755 for "HeatingDemandIndicator"
2019-09-07 12:38:36.725 SQL Logger Error exception trying to insert row into table variable_history_563885755 ("HeatingDemandIndicator")
2019-09-07 12:38:36.726 SQL Logger Error ERROR: relation "variable_history_563885755" already exists

2019-09-07 12:38:36.726 SQL Logger Error INSERT INTO variable_history_563885755 (value) VALUES (%s);
2019-09-07 12:38:36.758 SQL Logger creating table variable_history_610174137 for "HeatingIndicatorForGraph"
2019-09-07 12:38:36.763 SQL Logger Error exception trying to insert row into table variable_history_610174137 ("HeatingIndicatorForGraph")
2019-09-07 12:38:36.763 SQL Logger Error ERROR: relation "variable_history_610174137" already exists

2019-09-07 12:38:36.763 SQL Logger Error INSERT INTO variable_history_610174137 (value) VALUES (%s);
2019-09-07 12:38:36.774 SQL Logger creating table variable_history_1129942965 for "HeatingOn"
2019-09-07 12:38:36.779 SQL Logger Error exception trying to insert row into table variable_history_1129942965 ("HeatingOn")
2019-09-07 12:38:36.779 SQL Logger Error ERROR: relation "variable_history_1129942965" already exists

2019-09-07 12:38:36.779 SQL Logger Error INSERT INTO variable_history_1129942965 (value) VALUES (%s);
2019-09-07 12:38:36.865 SQL Logger creating table variable_history_309864273 for "HeatingPeriod"
2019-09-07 12:38:36.871 SQL Logger Error exception trying to insert row into table variable_history_309864273 ("HeatingPeriod")
2019-09-07 12:38:36.872 SQL Logger Error ERROR: relation "variable_history_309864273" already exists

2019-09-07 12:38:36.872 SQL Logger Error INSERT INTO variable_history_309864273 (value) VALUES (%s);
2019-09-07 12:38:36.880 SQL Logger creating table variable_history_1799952505 for "HeatingState"
2019-09-07 12:38:36.886 SQL Logger Error exception trying to insert row into table variable_history_1799952505 ("HeatingState")
2019-09-07 12:38:36.887 SQL Logger Error ERROR: relation "variable_history_1799952505" already exists

2019-09-07 12:38:36.887 SQL Logger Error INSERT INTO variable_history_1799952505 (value) VALUES (%s);
2019-09-07 12:38:36.897 SQL Logger creating table variable_history_1449438158 for "HolidayMode"
2019-09-07 12:38:36.904 SQL Logger Error exception trying to insert row into table variable_history_1449438158 ("HolidayMode")
2019-09-07 12:38:36.904 SQL Logger Error ERROR: relation "variable_history_1449438158" already exists

2019-09-07 12:38:36.905 SQL Logger Error INSERT INTO variable_history_1449438158 (value) VALUES (%s);
2019-09-07 12:38:36.912 SQL Logger creating table variable_history_1230273301 for "HomeDoorBellBattery"
2019-09-07 12:38:36.919 SQL Logger Error exception trying to insert row into table variable_history_1230273301 ("HomeDoorBellBattery")
2019-09-07 12:38:36.919 SQL Logger Error ERROR: relation "variable_history_1230273301" already exists

2019-09-07 12:38:36.920 SQL Logger Error INSERT INTO variable_history_1230273301 (value) VALUES (%s);
2019-09-07 12:38:36.926 SQL Logger creating table variable_history_53440275 for "HomeDoorBellBatteryIndicator"
2019-09-07 12:38:36.932 SQL Logger Error exception trying to insert row into table variable_history_53440275 ("HomeDoorBellBatteryIndicator")
2019-09-07 12:38:36.933 SQL Logger Error ERROR: relation "variable_history_53440275" already exists

2019-09-07 12:38:36.933 SQL Logger Error INSERT INTO variable_history_53440275 (value) VALUES (%s);
2019-09-07 12:38:36.964 SQL Logger creating table variable_history_1762884135 for "HotWaterDisplayIndicator"
2019-09-07 12:38:36.969 SQL Logger Error exception trying to insert row into table variable_history_1762884135 ("HotWaterDisplayIndicator")
2019-09-07 12:38:36.969 SQL Logger Error ERROR: relation "variable_history_1762884135" already exists

2019-09-07 12:38:36.970 SQL Logger Error INSERT INTO variable_history_1762884135 (value) VALUES (%s);
2019-09-07 12:38:36.991 SQL Logger creating table variable_history_250256375 for "HotWaterOn"
2019-09-07 12:38:37.003 SQL Logger Error exception trying to insert row into table variable_history_250256375 ("HotWaterOn")
2019-09-07 12:38:37.003 SQL Logger Error ERROR: relation "variable_history_250256375" already exists

2019-09-07 12:38:37.003 SQL Logger Error INSERT INTO variable_history_250256375 (value) VALUES (%s);
2019-09-07 12:38:37.048 SQL Logger creating table variable_history_1448566190 for "HotWaterOnIndicator"
2019-09-07 12:38:37.053 SQL Logger Error exception trying to insert row into table variable_history_1448566190 ("HotWaterOnIndicator")
2019-09-07 12:38:37.054 SQL Logger Error ERROR: relation "variable_history_1448566190" already exists

2019-09-07 12:38:37.054 SQL Logger Error INSERT INTO variable_history_1448566190 (value) VALUES (%s);
2019-09-07 12:38:37.092 SQL Logger creating table variable_history_1555375954 for "HotWaterTempIndicator"
2019-09-07 12:38:37.098 SQL Logger Error exception trying to insert row into table variable_history_1555375954 ("HotWaterTempIndicator")
2019-09-07 12:38:37.098 SQL Logger Error ERROR: relation "variable_history_1555375954" already exists

2019-09-07 12:38:37.099 SQL Logger Error INSERT INTO variable_history_1555375954 (value) VALUES (%s);
2019-09-07 12:38:37.176 SQL Logger creating table variable_history_1389001099 for "houseMode"
2019-09-07 12:38:37.182 SQL Logger Error exception trying to insert row into table variable_history_1389001099 ("houseMode")
2019-09-07 12:38:37.182 SQL Logger Error ERROR: relation "variable_history_1389001099" already exists

2019-09-07 12:38:37.182 SQL Logger Error INSERT INTO variable_history_1389001099 (value) VALUES (%s);
2019-09-07 12:38:37.210 SQL Logger creating table variable_history_466684372 for "House_Group"
2019-09-07 12:38:37.223 SQL Logger Error exception trying to insert row into table variable_history_466684372 ("House_Group")
2019-09-07 12:38:37.223 SQL Logger Error ERROR: relation "variable_history_466684372" already exists

2019-09-07 12:38:37.223 SQL Logger Error INSERT INTO variable_history_466684372 (value) VALUES (%s);
2019-09-07 12:38:37.267 SQL Logger creating table variable_history_1843605863 for "HumidityIndoor"
2019-09-07 12:38:37.272 SQL Logger Error exception trying to insert row into table variable_history_1843605863 ("HumidityIndoor")
2019-09-07 12:38:37.273 SQL Logger Error ERROR: relation "variable_history_1843605863" already exists

2019-09-07 12:38:37.273 SQL Logger Error INSERT INTO variable_history_1843605863 (value) VALUES (%s);
2019-09-07 12:38:37.381 SQL Logger creating table variable_history_178803367 for "HumidityOutdoor"
2019-09-07 12:38:37.387 SQL Logger Error exception trying to insert row into table variable_history_178803367 ("HumidityOutdoor")
2019-09-07 12:38:37.388 SQL Logger Error ERROR: relation "variable_history_178803367" already exists

2019-09-07 12:38:37.388 SQL Logger Error INSERT INTO variable_history_178803367 (value) VALUES (%s);
2019-09-07 12:38:37.400 SQL Logger creating table variable_history_1378552502 for "INDIGOplotD-Script-Message"
2019-09-07 12:38:37.409 SQL Logger Error exception trying to insert row into table variable_history_1378552502 ("INDIGOplotD-Script-Message")
2019-09-07 12:38:37.409 SQL Logger Error ERROR: relation "variable_history_1378552502" already exists

2019-09-07 12:38:37.409 SQL Logger Error INSERT INTO variable_history_1378552502 (value) VALUES (%s);
2019-09-07 12:38:37.436 SQL Logger creating table variable_history_356132138 for "internalCams"
2019-09-07 12:38:37.442 SQL Logger Error exception trying to insert row into table variable_history_356132138 ("internalCams")
2019-09-07 12:38:37.442 SQL Logger Error ERROR: relation "variable_history_356132138" already exists

2019-09-07 12:38:37.442 SQL Logger Error INSERT INTO variable_history_356132138 (value) VALUES (%s);
2019-09-07 12:38:37.485 SQL Logger creating table variable_history_1656232995 for "InternalCamsOn"
2019-09-07 12:38:37.492 SQL Logger Error exception trying to insert row into table variable_history_1656232995 ("InternalCamsOn")
2019-09-07 12:38:37.492 SQL Logger Error ERROR: relation "variable_history_1656232995" already exists

2019-09-07 12:38:37.493 SQL Logger Error INSERT INTO variable_history_1656232995 (value) VALUES (%s);
2019-09-07 12:38:37.499 SQL Logger creating table variable_history_886838529 for "ipDevice00"
2019-09-07 12:38:37.507 SQL Logger Error exception trying to insert row into table variable_history_886838529 ("ipDevice00")
2019-09-07 12:38:37.507 SQL Logger Error ERROR: relation "variable_history_886838529" already exists

2019-09-07 12:38:37.507 SQL Logger Error INSERT INTO variable_history_886838529 (value) VALUES (%s);
2019-09-07 12:38:37.540 SQL Logger creating table variable_history_1948219525 for "ipDevice01"
2019-09-07 12:38:37.546 SQL Logger Error exception trying to insert row into table variable_history_1948219525 ("ipDevice01")
2019-09-07 12:38:37.546 SQL Logger Error ERROR: relation "variable_history_1948219525" already exists

2019-09-07 12:38:37.546 SQL Logger Error INSERT INTO variable_history_1948219525 (value) VALUES (%s);
2019-09-07 12:38:37.567 SQL Logger creating table variable_history_1757972616 for "ipDevice02"
2019-09-07 12:38:37.573 SQL Logger Error exception trying to insert row into table variable_history_1757972616 ("ipDevice02")
2019-09-07 12:38:37.573 SQL Logger Error ERROR: relation "variable_history_1757972616" already exists

2019-09-07 12:38:37.574 SQL Logger Error INSERT INTO variable_history_1757972616 (value) VALUES (%s);
2019-09-07 12:38:37.591 SQL Logger creating table variable_history_296651570 for "ipDevice03"
2019-09-07 12:38:37.597 SQL Logger Error exception trying to insert row into table variable_history_296651570 ("ipDevice03")
2019-09-07 12:38:37.598 SQL Logger Error ERROR: relation "variable_history_296651570" already exists

2019-09-07 12:38:37.598 SQL Logger Error INSERT INTO variable_history_296651570 (value) VALUES (%s);
2019-09-07 12:38:37.604 SQL Logger creating table variable_history_7937789 for "ipDevice04"
2019-09-07 12:38:37.609 SQL Logger Error exception trying to insert row into table variable_history_7937789 ("ipDevice04")
2019-09-07 12:38:37.610 SQL Logger Error ERROR: relation "variable_history_7937789" already exists

2019-09-07 12:38:37.610 SQL Logger Error INSERT INTO variable_history_7937789 (value) VALUES (%s);
2019-09-07 12:38:37.615 SQL Logger creating table variable_history_1172720259 for "ipDevice05"
2019-09-07 12:38:37.621 SQL Logger Error exception trying to insert row into table variable_history_1172720259 ("ipDevice05")
2019-09-07 12:38:37.622 SQL Logger Error ERROR: relation "variable_history_1172720259" already exists

2019-09-07 12:38:37.622 SQL Logger Error INSERT INTO variable_history_1172720259 (value) VALUES (%s);
2019-09-07 12:38:37.628 SQL Logger creating table variable_history_1345265913 for "ipDevice06"
2019-09-07 12:38:37.634 SQL Logger Error exception trying to insert row into table variable_history_1345265913 ("ipDevice06")
2019-09-07 12:38:37.634 SQL Logger Error ERROR: relation "variable_history_1345265913" already exists

2019-09-07 12:38:37.634 SQL Logger Error INSERT INTO variable_history_1345265913 (value) VALUES (%s);
2019-09-07 12:38:37.640 SQL Logger creating table variable_history_1754077559 for "ipDevice07"
2019-09-07 12:38:37.646 SQL Logger Error exception trying to insert row into table variable_history_1754077559 ("ipDevice07")
2019-09-07 12:38:37.646 SQL Logger Error ERROR: relation "variable_history_1754077559" already exists

2019-09-07 12:38:37.646 SQL Logger Error INSERT INTO variable_history_1754077559 (value) VALUES (%s);
2019-09-07 12:38:37.653 SQL Logger creating table variable_history_492522810 for "ipDevice08"
2019-09-07 12:38:37.658 SQL Logger Error exception trying to insert row into table variable_history_492522810 ("ipDevice08")
2019-09-07 12:38:37.659 SQL Logger Error ERROR: relation "variable_history_492522810" already exists

2019-09-07 12:38:37.659 SQL Logger Error INSERT INTO variable_history_492522810 (value) VALUES (%s);
2019-09-07 12:38:37.666 SQL Logger creating table variable_history_1034264357 for "ipDevice09"
2019-09-07 12:38:37.672 SQL Logger Error exception trying to insert row into table variable_history_1034264357 ("ipDevice09")
2019-09-07 12:38:37.673 SQL Logger Error ERROR: relation "variable_history_1034264357" already exists

2019-09-07 12:38:37.673 SQL Logger Error INSERT INTO variable_history_1034264357 (value) VALUES (%s);
2019-09-07 12:38:37.680 SQL Logger creating table variable_history_225732725 for "ipDevice10"
2019-09-07 12:38:37.686 SQL Logger Error exception trying to insert row into table variable_history_225732725 ("ipDevice10")
2019-09-07 12:38:37.686 SQL Logger Error ERROR: relation "variable_history_225732725" already exists

2019-09-07 12:38:37.687 SQL Logger Error INSERT INTO variable_history_225732725 (value) VALUES (%s);
2019-09-07 12:38:37.693 SQL Logger creating table variable_history_169008627 for "ipDevice11"
2019-09-07 12:38:37.699 SQL Logger Error exception trying to insert row into table variable_history_169008627 ("ipDevice11")
2019-09-07 12:38:37.700 SQL Logger Error ERROR: relation "variable_history_169008627" already exists

2019-09-07 12:38:37.700 SQL Logger Error INSERT INTO variable_history_169008627 (value) VALUES (%s);
2019-09-07 12:38:37.708 SQL Logger creating table variable_history_1132619926 for "ipDevice12"
2019-09-07 12:38:37.714 SQL Logger Error exception trying to insert row into table variable_history_1132619926 ("ipDevice12")
2019-09-07 12:38:37.714 SQL Logger Error ERROR: relation "variable_history_1132619926" already exists

2019-09-07 12:38:37.714 SQL Logger Error INSERT INTO variable_history_1132619926 (value) VALUES (%s);
2019-09-07 12:38:37.736 SQL Logger creating table variable_history_844314133 for "ipDevice13"
2019-09-07 12:38:37.742 SQL Logger Error exception trying to insert row into table variable_history_844314133 ("ipDevice13")
2019-09-07 12:38:37.743 SQL Logger Error ERROR: relation "variable_history_844314133" already exists

2019-09-07 12:38:37.743 SQL Logger Error INSERT INTO variable_history_844314133 (value) VALUES (%s);
2019-09-07 12:38:37.767 SQL Logger creating table variable_history_45349831 for "ipDevice14"
2019-09-07 12:38:37.774 SQL Logger Error exception trying to insert row into table variable_history_45349831 ("ipDevice14")
2019-09-07 12:38:37.774 SQL Logger Error ERROR: relation "variable_history_45349831" already exists

2019-09-07 12:38:37.774 SQL Logger Error INSERT INTO variable_history_45349831 (value) VALUES (%s);
2019-09-07 12:38:37.782 SQL Logger creating table variable_history_1367883025 for "ipDevice15"
2019-09-07 12:38:37.788 SQL Logger Error exception trying to insert row into table variable_history_1367883025 ("ipDevice15")
2019-09-07 12:38:37.788 SQL Logger Error ERROR: relation "variable_history_1367883025" already exists

2019-09-07 12:38:37.789 SQL Logger Error INSERT INTO variable_history_1367883025 (value) VALUES (%s);
2019-09-07 12:38:37.794 SQL Logger creating table variable_history_1864931263 for "ipDevice16"
2019-09-07 12:38:37.800 SQL Logger Error exception trying to insert row into table variable_history_1864931263 ("ipDevice16")
2019-09-07 12:38:37.800 SQL Logger Error ERROR: relation "variable_history_1864931263" already exists

2019-09-07 12:38:37.800 SQL Logger Error INSERT INTO variable_history_1864931263 (value) VALUES (%s);
2019-09-07 12:38:37.806 SQL Logger creating table variable_history_605711188 for "ipDevice17"
2019-09-07 12:38:37.812 SQL Logger Error exception trying to insert row into table variable_history_605711188 ("ipDevice17")
2019-09-07 12:38:37.812 SQL Logger Error ERROR: relation "variable_history_605711188" already exists

2019-09-07 12:38:37.812 SQL Logger Error INSERT INTO variable_history_605711188 (value) VALUES (%s);
2019-09-07 12:38:37.937 SQL Logger creating table variable_history_435654672 for "ipDevice18"
2019-09-07 12:38:37.942 SQL Logger Error exception trying to insert row into table variable_history_435654672 ("ipDevice18")
2019-09-07 12:38:37.943 SQL Logger Error ERROR: relation "variable_history_435654672" already exists

2019-09-07 12:38:37.943 SQL Logger Error INSERT INTO variable_history_435654672 (value) VALUES (%s);
2019-09-07 12:38:37.949 SQL Logger creating table variable_history_66810981 for "ipDevice19"
2019-09-07 12:38:37.955 SQL Logger Error exception trying to insert row into table variable_history_66810981 ("ipDevice19")
2019-09-07 12:38:37.956 SQL Logger Error ERROR: relation "variable_history_66810981" already exists

2019-09-07 12:38:37.956 SQL Logger Error INSERT INTO variable_history_66810981 (value) VALUES (%s);
2019-09-07 12:38:37.980 SQL Logger creating table variable_history_61242576 for "ipDevice20"
2019-09-07 12:38:37.986 SQL Logger Error exception trying to insert row into table variable_history_61242576 ("ipDevice20")
2019-09-07 12:38:37.986 SQL Logger Error ERROR: relation "variable_history_61242576" already exists

2019-09-07 12:38:37.987 SQL Logger Error INSERT INTO variable_history_61242576 (value) VALUES (%s);
2019-09-07 12:38:38.003 SQL Logger creating table variable_history_1503780564 for "ipDevice21"
2019-09-07 12:38:38.010 SQL Logger Error exception trying to insert row into table variable_history_1503780564 ("ipDevice21")
2019-09-07 12:38:38.010 SQL Logger Error ERROR: relation "variable_history_1503780564" already exists

2019-09-07 12:38:38.010 SQL Logger Error INSERT INTO variable_history_1503780564 (value) VALUES (%s);
2019-09-07 12:38:38.016 SQL Logger creating table variable_history_479487486 for "ipDevice22"
2019-09-07 12:38:38.022 SQL Logger Error exception trying to insert row into table variable_history_479487486 ("ipDevice22")
2019-09-07 12:38:38.022 SQL Logger Error ERROR: relation "variable_history_479487486" already exists

2019-09-07 12:38:38.022 SQL Logger Error INSERT INTO variable_history_479487486 (value) VALUES (%s);
2019-09-07 12:38:38.028 SQL Logger creating table variable_history_656253040 for "ipDevice23"
2019-09-07 12:38:38.033 SQL Logger Error exception trying to insert row into table variable_history_656253040 ("ipDevice23")
2019-09-07 12:38:38.033 SQL Logger Error ERROR: relation "variable_history_656253040" already exists

2019-09-07 12:38:38.034 SQL Logger Error INSERT INTO variable_history_656253040 (value) VALUES (%s);
2019-09-07 12:38:38.040 SQL Logger creating table variable_history_233792660 for "ipDevice24"
2019-09-07 12:38:38.045 SQL Logger Error exception trying to insert row into table variable_history_233792660 ("ipDevice24")
2019-09-07 12:38:38.045 SQL Logger Error ERROR: relation "variable_history_233792660" already exists

2019-09-07 12:38:38.045 SQL Logger Error INSERT INTO variable_history_233792660 (value) VALUES (%s);
2019-09-07 12:38:38.051 SQL Logger creating table variable_history_227727951 for "ipDevice25"
2019-09-07 12:38:38.057 SQL Logger Error exception trying to insert row into table variable_history_227727951 ("ipDevice25")
2019-09-07 12:38:38.057 SQL Logger Error ERROR: relation "variable_history_227727951" already exists

2019-09-07 12:38:38.057 SQL Logger Error INSERT INTO variable_history_227727951 (value) VALUES (%s);
2019-09-07 12:38:38.064 SQL Logger creating table variable_history_737161500 for "ipDevice26"
2019-09-07 12:38:38.069 SQL Logger Error exception trying to insert row into table variable_history_737161500 ("ipDevice26")
2019-09-07 12:38:38.070 SQL Logger Error ERROR: relation "variable_history_737161500" already exists

2019-09-07 12:38:38.070 SQL Logger Error INSERT INTO variable_history_737161500 (value) VALUES (%s);
2019-09-07 12:38:38.089 SQL Logger creating table variable_history_1336569311 for "ipDevice27"
2019-09-07 12:38:38.095 SQL Logger Error exception trying to insert row into table variable_history_1336569311 ("ipDevice27")
2019-09-07 12:38:38.095 SQL Logger Error ERROR: relation "variable_history_1336569311" already exists

2019-09-07 12:38:38.096 SQL Logger Error INSERT INTO variable_history_1336569311 (value) VALUES (%s);
2019-09-07 12:38:38.102 SQL Logger creating table variable_history_624491958 for "ipDevice28"
2019-09-07 12:38:38.107 SQL Logger Error exception trying to insert row into table variable_history_624491958 ("ipDevice28")
2019-09-07 12:38:38.108 SQL Logger Error ERROR: relation "variable_history_624491958" already exists

2019-09-07 12:38:38.108 SQL Logger Error INSERT INTO variable_history_624491958 (value) VALUES (%s);
2019-09-07 12:38:38.114 SQL Logger creating table variable_history_216513450 for "ipDevice29"
2019-09-07 12:38:38.119 SQL Logger Error exception trying to insert row into table variable_history_216513450 ("ipDevice29")
2019-09-07 12:38:38.120 SQL Logger Error ERROR: relation "variable_history_216513450" already exists

2019-09-07 12:38:38.120 SQL Logger Error INSERT INTO variable_history_216513450 (value) VALUES (%s);
2019-09-07 12:38:38.126 SQL Logger creating table variable_history_1484224908 for "ipDevice30"
2019-09-07 12:38:38.131 SQL Logger Error exception trying to insert row into table variable_history_1484224908 ("ipDevice30")
2019-09-07 12:38:38.131 SQL Logger Error ERROR: relation "variable_history_1484224908" already exists

2019-09-07 12:38:38.132 SQL Logger Error INSERT INTO variable_history_1484224908 (value) VALUES (%s);
2019-09-07 12:38:38.138 SQL Logger creating table variable_history_25764047 for "ipDevice31"
2019-09-07 12:38:38.143 SQL Logger Error exception trying to insert row into table variable_history_25764047 ("ipDevice31")
2019-09-07 12:38:38.143 SQL Logger Error ERROR: relation "variable_history_25764047" already exists

2019-09-07 12:38:38.144 SQL Logger Error INSERT INTO variable_history_25764047 (value) VALUES (%s);
2019-09-07 12:38:38.149 SQL Logger creating table variable_history_624657656 for "ipDevice32"
2019-09-07 12:38:38.155 SQL Logger Error exception trying to insert row into table variable_history_624657656 ("ipDevice32")
2019-09-07 12:38:38.156 SQL Logger Error ERROR: relation "variable_history_624657656" already exists

2019-09-07 12:38:38.156 SQL Logger Error INSERT INTO variable_history_624657656 (value) VALUES (%s);
2019-09-07 12:38:38.163 SQL Logger creating table variable_history_621524285 for "ipDevice33"
2019-09-07 12:38:38.168 SQL Logger Error exception trying to insert row into table variable_history_621524285 ("ipDevice33")
2019-09-07 12:38:38.168 SQL Logger Error ERROR: relation "variable_history_621524285" already exists

2019-09-07 12:38:38.169 SQL Logger Error INSERT INTO variable_history_621524285 (value) VALUES (%s);
2019-09-07 12:38:38.174 SQL Logger creating table variable_history_1587535722 for "ipDevice34"
2019-09-07 12:38:38.180 SQL Logger Error exception trying to insert row into table variable_history_1587535722 ("ipDevice34")
2019-09-07 12:38:38.180 SQL Logger Error ERROR: relation "variable_history_1587535722" already exists

2019-09-07 12:38:38.180 SQL Logger Error INSERT INTO variable_history_1587535722 (value) VALUES (%s);
2019-09-07 12:38:38.186 SQL Logger creating table variable_history_551866885 for "ipDevice35"
2019-09-07 12:38:38.192 SQL Logger Error exception trying to insert row into table variable_history_551866885 ("ipDevice35")
2019-09-07 12:38:38.192 SQL Logger Error ERROR: relation "variable_history_551866885" already exists

2019-09-07 12:38:38.193 SQL Logger Error INSERT INTO variable_history_551866885 (value) VALUES (%s);
2019-09-07 12:38:38.199 SQL Logger creating table variable_history_1910908849 for "ipDevice36"
2019-09-07 12:38:38.205 SQL Logger Error exception trying to insert row into table variable_history_1910908849 ("ipDevice36")
2019-09-07 12:38:38.206 SQL Logger Error ERROR: relation "variable_history_1910908849" already exists

2019-09-07 12:38:38.206 SQL Logger Error INSERT INTO variable_history_1910908849 (value) VALUES (%s);
2019-09-07 12:38:38.212 SQL Logger creating table variable_history_1244480746 for "ipDevice37"
2019-09-07 12:38:38.218 SQL Logger Error exception trying to insert row into table variable_history_1244480746 ("ipDevice37")
2019-09-07 12:38:38.218 SQL Logger Error ERROR: relation "variable_history_1244480746" already exists

2019-09-07 12:38:38.219 SQL Logger Error INSERT INTO variable_history_1244480746 (value) VALUES (%s);
2019-09-07 12:38:38.245 SQL Logger creating table variable_history_1690397347 for "ipDevice38"
2019-09-07 12:38:38.251 SQL Logger Error exception trying to insert row into table variable_history_1690397347 ("ipDevice38")
2019-09-07 12:38:38.251 SQL Logger Error ERROR: relation "variable_history_1690397347" already exists

2019-09-07 12:38:38.252 SQL Logger Error INSERT INTO variable_history_1690397347 (value) VALUES (%s);
2019-09-07 12:38:38.289 SQL Logger creating table variable_history_1674709447 for "ipDevice39"
2019-09-07 12:38:38.295 SQL Logger Error exception trying to insert row into table variable_history_1674709447 ("ipDevice39")
2019-09-07 12:38:38.295 SQL Logger Error ERROR: relation "variable_history_1674709447" already exists

2019-09-07 12:38:38.296 SQL Logger Error INSERT INTO variable_history_1674709447 (value) VALUES (%s);
2019-09-07 12:38:38.302 SQL Logger creating table variable_history_1457317213 for "ipDevice40"
2019-09-07 12:38:38.308 SQL Logger Error exception trying to insert row into table variable_history_1457317213 ("ipDevice40")
2019-09-07 12:38:38.308 SQL Logger Error ERROR: relation "variable_history_1457317213" already exists

2019-09-07 12:38:38.309 SQL Logger Error INSERT INTO variable_history_1457317213 (value) VALUES (%s);
2019-09-07 12:38:38.315 SQL Logger creating table variable_history_1077688569 for "ipDevice41"
2019-09-07 12:38:38.321 SQL Logger Error exception trying to insert row into table variable_history_1077688569 ("ipDevice41")
2019-09-07 12:38:38.321 SQL Logger Error ERROR: relation "variable_history_1077688569" already exists

2019-09-07 12:38:38.322 SQL Logger Error INSERT INTO variable_history_1077688569 (value) VALUES (%s);
2019-09-07 12:38:38.327 SQL Logger creating table variable_history_1766588053 for "ipDevice42"
2019-09-07 12:38:38.333 SQL Logger Error exception trying to insert row into table variable_history_1766588053 ("ipDevice42")
2019-09-07 12:38:38.334 SQL Logger Error ERROR: relation "variable_history_1766588053" already exists

2019-09-07 12:38:38.334 SQL Logger Error INSERT INTO variable_history_1766588053 (value) VALUES (%s);
2019-09-07 12:38:38.340 SQL Logger creating table variable_history_1936109184 for "ipDevice43"
2019-09-07 12:38:38.346 SQL Logger Error exception trying to insert row into table variable_history_1936109184 ("ipDevice43")
2019-09-07 12:38:38.346 SQL Logger Error ERROR: relation "variable_history_1936109184" already exists

2019-09-07 12:38:38.346 SQL Logger Error INSERT INTO variable_history_1936109184 (value) VALUES (%s);
2019-09-07 12:38:38.352 SQL Logger creating table variable_history_1955974865 for "ipDevice44"
2019-09-07 12:38:38.359 SQL Logger Error exception trying to insert row into table variable_history_1955974865 ("ipDevice44")
2019-09-07 12:38:38.360 SQL Logger Error ERROR: relation "variable_history_1955974865" already exists

2019-09-07 12:38:38.360 SQL Logger Error INSERT INTO variable_history_1955974865 (value) VALUES (%s);
2019-09-07 12:38:38.367 SQL Logger creating table variable_history_191117804 for "ipDevice45"
2019-09-07 12:38:38.374 SQL Logger Error exception trying to insert row into table variable_history_191117804 ("ipDevice45")
2019-09-07 12:38:38.375 SQL Logger Error ERROR: relation "variable_history_191117804" already exists

2019-09-07 12:38:38.375 SQL Logger Error INSERT INTO variable_history_191117804 (value) VALUES (%s);
2019-09-07 12:38:38.386 SQL Logger creating table variable_history_1218011266 for "ipDevice46"
2019-09-07 12:38:38.394 SQL Logger Error exception trying to insert row into table variable_history_1218011266 ("ipDevice46")
2019-09-07 12:38:38.395 SQL Logger Error ERROR: relation "variable_history_1218011266" already exists

2019-09-07 12:38:38.395 SQL Logger Error INSERT INTO variable_history_1218011266 (value) VALUES (%s);
2019-09-07 12:38:38.404 SQL Logger creating table variable_history_10715801 for "ipDevice47"
2019-09-07 12:38:38.411 SQL Logger Error exception trying to insert row into table variable_history_10715801 ("ipDevice47")
2019-09-07 12:38:38.411 SQL Logger Error ERROR: relation "variable_history_10715801" already exists

2019-09-07 12:38:38.412 SQL Logger Error INSERT INTO variable_history_10715801 (value) VALUES (%s);
2019-09-07 12:38:38.433 SQL Logger creating table variable_history_709643727 for "ipDevice48"
2019-09-07 12:38:38.462 SQL Logger Error exception trying to insert row into table variable_history_709643727 ("ipDevice48")
2019-09-07 12:38:38.463 SQL Logger Error ERROR: relation "variable_history_709643727" already exists

2019-09-07 12:38:38.463 SQL Logger Error INSERT INTO variable_history_709643727 (value) VALUES (%s);
2019-09-07 12:38:38.553 SQL Logger creating table variable_history_423339178 for "ipDevice49"
2019-09-07 12:38:38.560 SQL Logger Error exception trying to insert row into table variable_history_423339178 ("ipDevice49")
2019-09-07 12:38:38.560 SQL Logger Error ERROR: relation "variable_history_423339178" already exists

2019-09-07 12:38:38.560 SQL Logger Error INSERT INTO variable_history_423339178 (value) VALUES (%s);
2019-09-07 12:38:38.605 SQL Logger creating table variable_history_490505938 for "ipDevice50"
2019-09-07 12:38:38.610 SQL Logger Error exception trying to insert row into table variable_history_490505938 ("ipDevice50")
2019-09-07 12:38:38.610 SQL Logger Error ERROR: relation "variable_history_490505938" already exists

2019-09-07 12:38:38.610 SQL Logger Error INSERT INTO variable_history_490505938 (value) VALUES (%s);
2019-09-07 12:38:38.660 SQL Logger creating table variable_history_416108400 for "ipDevice51"
2019-09-07 12:38:38.665 SQL Logger Error exception trying to insert row into table variable_history_416108400 ("ipDevice51")
2019-09-07 12:38:38.666 SQL Logger Error ERROR: relation "variable_history_416108400" already exists

2019-09-07 12:38:38.666 SQL Logger Error INSERT INTO variable_history_416108400 (value) VALUES (%s);
2019-09-07 12:38:38.679 SQL Logger creating table variable_history_883783445 for "ipDevice52"
2019-09-07 12:38:38.684 SQL Logger Error exception trying to insert row into table variable_history_883783445 ("ipDevice52")
2019-09-07 12:38:38.684 SQL Logger Error ERROR: relation "variable_history_883783445" already exists

2019-09-07 12:38:38.685 SQL Logger Error INSERT INTO variable_history_883783445 (value) VALUES (%s);
2019-09-07 12:38:38.700 SQL Logger creating table variable_history_1215454043 for "ipDevice53"
2019-09-07 12:38:38.705 SQL Logger Error exception trying to insert row into table variable_history_1215454043 ("ipDevice53")
2019-09-07 12:38:38.706 SQL Logger Error ERROR: relation "variable_history_1215454043" already exists

2019-09-07 12:38:38.706 SQL Logger Error INSERT INTO variable_history_1215454043 (value) VALUES (%s);
2019-09-07 12:38:38.712 SQL Logger creating table variable_history_1819247388 for "ipDevice54"
2019-09-07 12:38:38.717 SQL Logger Error exception trying to insert row into table variable_history_1819247388 ("ipDevice54")
2019-09-07 12:38:38.717 SQL Logger Error ERROR: relation "variable_history_1819247388" already exists

2019-09-07 12:38:38.717 SQL Logger Error INSERT INTO variable_history_1819247388 (value) VALUES (%s);
2019-09-07 12:38:38.723 SQL Logger creating table variable_history_1314684674 for "ipDevice55"
2019-09-07 12:38:38.729 SQL Logger Error exception trying to insert row into table variable_history_1314684674 ("ipDevice55")
2019-09-07 12:38:38.730 SQL Logger Error ERROR: relation "variable_history_1314684674" already exists

2019-09-07 12:38:38.730 SQL Logger Error INSERT INTO variable_history_1314684674 (value) VALUES (%s);
2019-09-07 12:38:38.755 SQL Logger creating table variable_history_1580894036 for "ipDevice56"
2019-09-07 12:38:38.766 SQL Logger Error exception trying to insert row into table variable_history_1580894036 ("ipDevice56")
2019-09-07 12:38:38.766 SQL Logger Error ERROR: relation "variable_history_1580894036" already exists

2019-09-07 12:38:38.767 SQL Logger Error INSERT INTO variable_history_1580894036 (value) VALUES (%s);
2019-09-07 12:38:38.802 SQL Logger creating table variable_history_119260739 for "ipDevice57"
2019-09-07 12:38:38.809 SQL Logger Error exception trying to insert row into table variable_history_119260739 ("ipDevice57")
2019-09-07 12:38:38.810 SQL Logger Error ERROR: relation "variable_history_119260739" already exists

2019-09-07 12:38:38.810 SQL Logger Error INSERT INTO variable_history_119260739 (value) VALUES (%s);
2019-09-07 12:38:38.983 SQL Logger creating table variable_history_1376673866 for "ipDevice58"
2019-09-07 12:38:38.990 SQL Logger Error exception trying to insert row into table variable_history_1376673866 ("ipDevice58")
2019-09-07 12:38:38.991 SQL Logger Error ERROR: relation "variable_history_1376673866" already exists

2019-09-07 12:38:38.991 SQL Logger Error INSERT INTO variable_history_1376673866 (value) VALUES (%s);
2019-09-07 12:38:39.006 SQL Logger creating table variable_history_316425189 for "ipDevice59"
2019-09-07 12:38:39.012 SQL Logger Error exception trying to insert row into table variable_history_316425189 ("ipDevice59")
2019-09-07 12:38:39.012 SQL Logger Error ERROR: relation "variable_history_316425189" already exists

2019-09-07 12:38:39.013 SQL Logger Error INSERT INTO variable_history_316425189 (value) VALUES (%s);
2019-09-07 12:38:39.072 SQL Logger creating table variable_history_1002239838 for "ipDevice60"
2019-09-07 12:38:39.077 SQL Logger Error exception trying to insert row into table variable_history_1002239838 ("ipDevice60")
2019-09-07 12:38:39.077 SQL Logger Error ERROR: relation "variable_history_1002239838" already exists

2019-09-07 12:38:39.078 SQL Logger Error INSERT INTO variable_history_1002239838 (value) VALUES (%s);
2019-09-07 12:38:39.084 SQL Logger creating table variable_history_1257720887 for "ipDevice61"
2019-09-07 12:38:39.090 SQL Logger Error exception trying to insert row into table variable_history_1257720887 ("ipDevice61")
2019-09-07 12:38:39.091 SQL Logger Error ERROR: relation "variable_history_1257720887" already exists

2019-09-07 12:38:39.091 SQL Logger Error INSERT INTO variable_history_1257720887 (value) VALUES (%s);
2019-09-07 12:38:39.100 SQL Logger creating table variable_history_440503767 for "ipDevice62"
2019-09-07 12:38:39.107 SQL Logger Error exception trying to insert row into table variable_history_440503767 ("ipDevice62")
2019-09-07 12:38:39.108 SQL Logger Error ERROR: relation "variable_history_440503767" already exists

2019-09-07 12:38:39.108 SQL Logger Error INSERT INTO variable_history_440503767 (value) VALUES (%s);
2019-09-07 12:38:39.116 SQL Logger creating table variable_history_205535869 for "ipDevice63"
2019-09-07 12:38:39.151 SQL Logger Error exception trying to insert row into table variable_history_205535869 ("ipDevice63")
2019-09-07 12:38:39.151 SQL Logger Error ERROR: relation "variable_history_205535869" already exists

2019-09-07 12:38:39.151 SQL Logger Error INSERT INTO variable_history_205535869 (value) VALUES (%s);
2019-09-07 12:38:39.159 SQL Logger creating table variable_history_1082221639 for "ipDevice64"
2019-09-07 12:38:39.164 SQL Logger Error exception trying to insert row into table variable_history_1082221639 ("ipDevice64")
2019-09-07 12:38:39.165 SQL Logger Error ERROR: relation "variable_history_1082221639" already exists

2019-09-07 12:38:39.165 SQL Logger Error INSERT INTO variable_history_1082221639 (value) VALUES (%s);
2019-09-07 12:38:39.171 SQL Logger creating table variable_history_369632557 for "ipDevice65"
2019-09-07 12:38:39.176 SQL Logger Error exception trying to insert row into table variable_history_369632557 ("ipDevice65")
2019-09-07 12:38:39.177 SQL Logger Error ERROR: relation "variable_history_369632557" already exists

2019-09-07 12:38:39.177 SQL Logger Error INSERT INTO variable_history_369632557 (value) VALUES (%s);
2019-09-07 12:38:39.218 SQL Logger creating table variable_history_33707351 for "ipDevice66"
2019-09-07 12:38:39.223 SQL Logger Error exception trying to insert row into table variable_history_33707351 ("ipDevice66")
2019-09-07 12:38:39.223 SQL Logger Error ERROR: relation "variable_history_33707351" already exists

2019-09-07 12:38:39.224 SQL Logger Error INSERT INTO variable_history_33707351 (value) VALUES (%s);
2019-09-07 12:38:39.290 SQL Logger creating table variable_history_1526003068 for "ipDevice67"
2019-09-07 12:38:39.296 SQL Logger Error exception trying to insert row into table variable_history_1526003068 ("ipDevice67")
2019-09-07 12:38:39.297 SQL Logger Error ERROR: relation "variable_history_1526003068" already exists

2019-09-07 12:38:39.297 SQL Logger Error INSERT INTO variable_history_1526003068 (value) VALUES (%s);
2019-09-07 12:38:39.321 SQL Logger creating table variable_history_985676264 for "ipDevice68"
2019-09-07 12:38:39.327 SQL Logger Error exception trying to insert row into table variable_history_985676264 ("ipDevice68")
2019-09-07 12:38:39.327 SQL Logger Error ERROR: relation "variable_history_985676264" already exists

2019-09-07 12:38:39.327 SQL Logger Error INSERT INTO variable_history_985676264 (value) VALUES (%s);
2019-09-07 12:38:39.370 SQL Logger creating table variable_history_915860551 for "ipDevice69"
2019-09-07 12:38:39.376 SQL Logger Error exception trying to insert row into table variable_history_915860551 ("ipDevice69")
2019-09-07 12:38:39.376 SQL Logger Error ERROR: relation "variable_history_915860551" already exists

2019-09-07 12:38:39.377 SQL Logger Error INSERT INTO variable_history_915860551 (value) VALUES (%s);
2019-09-07 12:38:39.433 SQL Logger creating table variable_history_302702133 for "ipDevice70"
2019-09-07 12:38:39.466 SQL Logger Error exception trying to insert row into table variable_history_302702133 ("ipDevice70")
2019-09-07 12:38:39.483 SQL Logger Error ERROR: relation "variable_history_302702133" already exists

2019-09-07 12:38:39.483 SQL Logger Error INSERT INTO variable_history_302702133 (value) VALUES (%s);
2019-09-07 12:38:39.503 SQL Logger creating table variable_history_1745371758 for "ipDevice71"
2019-09-07 12:38:39.509 SQL Logger Error exception trying to insert row into table variable_history_1745371758 ("ipDevice71")
2019-09-07 12:38:39.509 SQL Logger Error ERROR: relation "variable_history_1745371758" already exists

2019-09-07 12:38:39.510 SQL Logger Error INSERT INTO variable_history_1745371758 (value) VALUES (%s);
2019-09-07 12:38:39.581 SQL Logger creating table variable_history_489341223 for "ipDevice73"
2019-09-07 12:38:39.587 SQL Logger Error exception trying to insert row into table variable_history_489341223 ("ipDevice73")
2019-09-07 12:38:39.587 SQL Logger Error ERROR: relation "variable_history_489341223" already exists

2019-09-07 12:38:39.588 SQL Logger Error INSERT INTO variable_history_489341223 (value) VALUES (%s);
2019-09-07 12:38:39.618 SQL Logger creating table variable_history_66825090 for "ipDevice74"
2019-09-07 12:38:39.624 SQL Logger Error exception trying to insert row into table variable_history_66825090 ("ipDevice74")
2019-09-07 12:38:39.624 SQL Logger Error ERROR: relation "variable_history_66825090" already exists

2019-09-07 12:38:39.625 SQL Logger Error INSERT INTO variable_history_66825090 (value) VALUES (%s);
2019-09-07 12:38:39.630 SQL Logger creating table variable_history_61794312 for "ipDevice75"
2019-09-07 12:38:39.636 SQL Logger Error exception trying to insert row into table variable_history_61794312 ("ipDevice75")
2019-09-07 12:38:39.636 SQL Logger Error ERROR: relation "variable_history_61794312" already exists

2019-09-07 12:38:39.637 SQL Logger Error INSERT INTO variable_history_61794312 (value) VALUES (%s);
2019-09-07 12:38:39.718 SQL Logger creating table variable_history_428253478 for "ipDevice77"
2019-09-07 12:38:39.723 SQL Logger Error exception trying to insert row into table variable_history_428253478 ("ipDevice77")
2019-09-07 12:38:39.724 SQL Logger Error ERROR: relation "variable_history_428253478" already exists

2019-09-07 12:38:39.724 SQL Logger Error INSERT INTO variable_history_428253478 (value) VALUES (%s);
2019-09-07 12:38:39.749 SQL Logger creating table variable_history_1284327799 for "ipDevsLastDevChangedIndigoName"
2019-09-07 12:38:39.755 SQL Logger Error exception trying to insert row into table variable_history_1284327799 ("ipDevsLastDevChangedIndigoName")
2019-09-07 12:38:39.755 SQL Logger Error ERROR: relation "variable_history_1284327799" already exists

2019-09-07 12:38:39.756 SQL Logger Error INSERT INTO variable_history_1284327799 (value) VALUES (%s);
2019-09-07 12:38:39.772 SQL Logger creating table variable_history_205316590 for "ipDevsLastUpdate"
2019-09-07 12:38:39.778 SQL Logger Error exception trying to insert row into table variable_history_205316590 ("ipDevsLastUpdate")
2019-09-07 12:38:39.778 SQL Logger Error ERROR: relation "variable_history_205316590" already exists

2019-09-07 12:38:39.778 SQL Logger Error INSERT INTO variable_history_205316590 (value) VALUES (%s);
2019-09-07 12:38:39.842 SQL Logger creating table variable_history_51852581 for "ipDevsNewDeviceNo"
2019-09-07 12:38:39.847 SQL Logger Error exception trying to insert row into table variable_history_51852581 ("ipDevsNewDeviceNo")
2019-09-07 12:38:39.848 SQL Logger Error ERROR: relation "variable_history_51852581" already exists

2019-09-07 12:38:39.848 SQL Logger Error INSERT INTO variable_history_51852581 (value) VALUES (%s);
2019-09-07 12:38:39.870 SQL Logger creating table variable_history_1785086945 for "ipDevsNewIPNumber"
2019-09-07 12:38:39.875 SQL Logger Error exception trying to insert row into table variable_history_1785086945 ("ipDevsNewIPNumber")
2019-09-07 12:38:39.876 SQL Logger Error ERROR: relation "variable_history_1785086945" already exists

2019-09-07 12:38:39.876 SQL Logger Error INSERT INTO variable_history_1785086945 (value) VALUES (%s);
2019-09-07 12:38:39.924 SQL Logger creating table variable_history_1369116523 for "ipDevsNoOfDevices"
2019-09-07 12:38:39.929 SQL Logger Error exception trying to insert row into table variable_history_1369116523 ("ipDevsNoOfDevices")
2019-09-07 12:38:39.930 SQL Logger Error ERROR: relation "variable_history_1369116523" already exists

2019-09-07 12:38:39.930 SQL Logger Error INSERT INTO variable_history_1369116523 (value) VALUES (%s);
2019-09-07 12:38:40.000 SQL Logger creating table variable_history_1064834649 for "ipDevsOldNewIPNumber"
2019-09-07 12:38:40.015 SQL Logger Error exception trying to insert row into table variable_history_1064834649 ("ipDevsOldNewIPNumber")
2019-09-07 12:38:40.015 SQL Logger Error ERROR: relation "variable_history_1064834649" already exists

2019-09-07 12:38:40.016 SQL Logger Error INSERT INTO variable_history_1064834649 (value) VALUES (%s);
2019-09-07 12:38:40.095 SQL Logger creating table variable_history_23078783 for "isDaylight"
2019-09-07 12:38:40.103 SQL Logger Error exception trying to insert row into table variable_history_23078783 ("isDaylight")
2019-09-07 12:38:40.104 SQL Logger Error ERROR: relation "variable_history_23078783" already exists

2019-09-07 12:38:40.104 SQL Logger Error INSERT INTO variable_history_23078783 (value) VALUES (%s);
2019-09-07 12:38:40.185 SQL Logger creating table variable_history_800098668 for "KichenManOverrideOn"
2019-09-07 12:38:40.218 SQL Logger Error exception trying to insert row into table variable_history_800098668 ("KichenManOverrideOn")
2019-09-07 12:38:40.219 SQL Logger Error ERROR: relation "variable_history_800098668" already exists

2019-09-07 12:38:40.219 SQL Logger Error INSERT INTO variable_history_800098668 (value) VALUES (%s);
2019-09-07 12:38:40.256 SQL Logger creating table variable_history_423611140 for "Kitchen"
2019-09-07 12:38:40.261 SQL Logger Error exception trying to insert row into table variable_history_423611140 ("Kitchen")
2019-09-07 12:38:40.261 SQL Logger Error ERROR: relation "variable_history_423611140" already exists

2019-09-07 12:38:40.262 SQL Logger Error INSERT INTO variable_history_423611140 (value) VALUES (%s);
2019-09-07 12:38:42.459 Z-Wave received "Kitchen Freezer Door Temp Sensor" sensor update to 20.56 °C
2019-09-07 12:38:42.518 SQL Logger creating table variable_history_472339010 for "LastMotionDetected"
2019-09-07 12:38:42.536 SQL Logger Error exception trying to insert row into table variable_history_472339010 ("LastMotionDetected")
2019-09-07 12:38:42.536 SQL Logger Error ERROR: relation "variable_history_472339010" already exists

2019-09-07 12:38:42.537 SQL Logger Error INSERT INTO variable_history_472339010 (value) VALUES (%s);
2019-09-07 12:38:42.806 SQL Logger creating table variable_history_751473395 for "Living_Room_Apple_TV"
2019-09-07 12:38:42.851 SQL Logger Error exception trying to insert row into table variable_history_751473395 ("Living_Room_Apple_TV")
2019-09-07 12:38:42.852 SQL Logger Error ERROR: relation "variable_history_751473395" already exists

2019-09-07 12:38:42.852 SQL Logger Error INSERT INTO variable_history_751473395 (value) VALUES (%s);
2019-09-07 12:38:43.047 SQL Logger creating table variable_history_955319690 for "Lounge"
2019-09-07 12:38:43.054 SQL Logger Error exception trying to insert row into table variable_history_955319690 ("Lounge")
2019-09-07 12:38:43.054 SQL Logger Error ERROR: relation "variable_history_955319690" already exists

2019-09-07 12:38:43.054 SQL Logger Error INSERT INTO variable_history_955319690 (value) VALUES (%s);
2019-09-07 12:38:43.210 SQL Logger creating table variable_history_1347683890 for "Lounge-Back"
2019-09-07 12:38:43.261 SQL Logger Error exception trying to insert row into table variable_history_1347683890 ("Lounge-Back")
2019-09-07 12:38:43.262 SQL Logger Error ERROR: relation "variable_history_1347683890" already exists

2019-09-07 12:38:43.262 SQL Logger Error INSERT INTO variable_history_1347683890 (value) VALUES (%s);
2019-09-07 12:38:43.354 SQL Logger creating table variable_history_841750262 for "LoungeCurrentTitle"
2019-09-07 12:38:43.360 SQL Logger Error exception trying to insert row into table variable_history_841750262 ("LoungeCurrentTitle")
2019-09-07 12:38:43.360 SQL Logger Error ERROR: relation "variable_history_841750262" already exists

2019-09-07 12:38:43.360 SQL Logger Error INSERT INTO variable_history_841750262 (value) VALUES (%s);
2019-09-07 12:38:43.436 SQL Logger creating table variable_history_9532671 for "Lounge_Group"
2019-09-07 12:38:43.442 SQL Logger Error exception trying to insert row into table variable_history_9532671 ("Lounge_Group")
2019-09-07 12:38:43.443 SQL Logger Error ERROR: relation "variable_history_9532671" already exists

2019-09-07 12:38:43.443 SQL Logger Error INSERT INTO variable_history_9532671 (value) VALUES (%s);
2019-09-07 12:38:43.472 SQL Logger creating table variable_history_1463320266 for "Lounge_Speaker"
2019-09-07 12:38:43.479 SQL Logger Error exception trying to insert row into table variable_history_1463320266 ("Lounge_Speaker")
2019-09-07 12:38:43.479 SQL Logger Error ERROR: relation "variable_history_1463320266" already exists

2019-09-07 12:38:43.479 SQL Logger Error INSERT INTO variable_history_1463320266 (value) VALUES (%s);
2019-09-07 12:38:43.499 SQL Logger creating table variable_history_1856915533 for "Master_Bed"
2019-09-07 12:38:43.506 SQL Logger Error exception trying to insert row into table variable_history_1856915533 ("Master_Bed")
2019-09-07 12:38:43.506 SQL Logger Error ERROR: relation "variable_history_1856915533" already exists

2019-09-07 12:38:43.506 SQL Logger Error INSERT INTO variable_history_1856915533 (value) VALUES (%s);
2019-09-07 12:38:43.525 SQL Logger creating table variable_history_1981303989 for "Michael’s_iMac"
2019-09-07 12:38:43.531 SQL Logger Error exception trying to insert row into table variable_history_1981303989 ("Michael’s_iMac")
2019-09-07 12:38:43.531 SQL Logger Error ERROR: relation "variable_history_1981303989" already exists

2019-09-07 12:38:43.532 SQL Logger Error INSERT INTO variable_history_1981303989 (value) VALUES (%s);
2019-09-07 12:38:43.558 SQL Logger creating table variable_history_1274284013 for "Michael’s_Mac_mini_(2)"
2019-09-07 12:38:43.563 SQL Logger Error exception trying to insert row into table variable_history_1274284013 ("Michael’s_Mac_mini_(2)")
2019-09-07 12:38:43.563 SQL Logger Error ERROR: relation "variable_history_1274284013" already exists

2019-09-07 12:38:43.564 SQL Logger Error INSERT INTO variable_history_1274284013 (value) VALUES (%s);
2019-09-07 12:38:43.644 SQL Logger creating table variable_history_423967902 for "Mike's_Mac_mini"
2019-09-07 12:38:43.650 SQL Logger Error exception trying to insert row into table variable_history_423967902 ("Mike's_Mac_mini")
2019-09-07 12:38:43.650 SQL Logger Error ERROR: relation "variable_history_423967902" already exists

2019-09-07 12:38:43.651 SQL Logger Error INSERT INTO variable_history_423967902 (value) VALUES (%s);
2019-09-07 12:38:43.704 SQL Logger creating table variable_history_1363901029 for "Mike's_Mac_Mini"
2019-09-07 12:38:43.710 SQL Logger Error exception trying to insert row into table variable_history_1363901029 ("Mike's_Mac_Mini")
2019-09-07 12:38:43.710 SQL Logger Error ERROR: relation "variable_history_1363901029" already exists

2019-09-07 12:38:43.710 SQL Logger Error INSERT INTO variable_history_1363901029 (value) VALUES (%s);
2019-09-07 12:38:43.764 SQL Logger creating table variable_history_298714117 for "MikeHome"
2019-09-07 12:38:43.769 SQL Logger Error exception trying to insert row into table variable_history_298714117 ("MikeHome")
2019-09-07 12:38:43.770 SQL Logger Error ERROR: relation "variable_history_298714117" already exists

2019-09-07 12:38:43.770 SQL Logger Error INSERT INTO variable_history_298714117 (value) VALUES (%s);
2019-09-07 12:38:43.775 SQL Logger creating table variable_history_340850354 for "Mikes6SiPhonecopyHome"
2019-09-07 12:38:43.781 SQL Logger Error exception trying to insert row into table variable_history_340850354 ("Mikes6SiPhonecopyHome")
2019-09-07 12:38:43.781 SQL Logger Error ERROR: relation "variable_history_340850354" already exists

2019-09-07 12:38:43.781 SQL Logger Error INSERT INTO variable_history_340850354 (value) VALUES (%s);
2019-09-07 12:38:43.813 SQL Logger creating table variable_history_1169768253 for "Mikes6SiPhoneHome"
2019-09-07 12:38:43.818 SQL Logger Error exception trying to insert row into table variable_history_1169768253 ("Mikes6SiPhoneHome")
2019-09-07 12:38:43.819 SQL Logger Error ERROR: relation "variable_history_1169768253" already exists

2019-09-07 12:38:43.819 SQL Logger Error INSERT INTO variable_history_1169768253 (value) VALUES (%s);
2019-09-07 12:38:43.825 SQL Logger creating table variable_history_40361423 for "Minx_TV"
2019-09-07 12:38:43.830 SQL Logger Error exception trying to insert row into table variable_history_40361423 ("Minx_TV")
2019-09-07 12:38:43.831 SQL Logger Error ERROR: relation "variable_history_40361423" already exists

2019-09-07 12:38:43.831 SQL Logger Error INSERT INTO variable_history_40361423 (value) VALUES (%s);
2019-09-07 12:38:43.901 SQL Logger creating table variable_history_1941220526 for "MobileAE"
2019-09-07 12:38:43.907 SQL Logger Error exception trying to insert row into table variable_history_1941220526 ("MobileAE")
2019-09-07 12:38:43.907 SQL Logger Error ERROR: relation "variable_history_1941220526" already exists

2019-09-07 12:38:43.907 SQL Logger Error INSERT INTO variable_history_1941220526 (value) VALUES (%s);
2019-09-07 12:38:43.913 SQL Logger creating table variable_history_1128559793 for "MotionGarageDrive"
2019-09-07 12:38:43.918 SQL Logger Error exception trying to insert row into table variable_history_1128559793 ("MotionGarageDrive")
2019-09-07 12:38:43.919 SQL Logger Error ERROR: relation "variable_history_1128559793" already exists

2019-09-07 12:38:43.919 SQL Logger Error INSERT INTO variable_history_1128559793 (value) VALUES (%s);
2019-09-07 12:38:44.071 SQL Logger creating table variable_history_1934905545 for "OfficeDoorBellBattery"
2019-09-07 12:38:44.077 SQL Logger Error exception trying to insert row into table variable_history_1934905545 ("OfficeDoorBellBattery")
2019-09-07 12:38:44.077 SQL Logger Error ERROR: relation "variable_history_1934905545" already exists

2019-09-07 12:38:44.077 SQL Logger Error INSERT INTO variable_history_1934905545 (value) VALUES (%s);
2019-09-07 12:38:44.084 SQL Logger creating table variable_history_423203315 for "oneAway_1"
2019-09-07 12:38:44.090 SQL Logger Error exception trying to insert row into table variable_history_423203315 ("oneAway_1")
2019-09-07 12:38:44.090 SQL Logger Error ERROR: relation "variable_history_423203315" already exists

2019-09-07 12:38:44.091 SQL Logger Error INSERT INTO variable_history_423203315 (value) VALUES (%s);
2019-09-07 12:38:44.097 SQL Logger creating table variable_history_373203109 for "oneAway_10"
2019-09-07 12:38:44.103 SQL Logger Error exception trying to insert row into table variable_history_373203109 ("oneAway_10")
2019-09-07 12:38:44.103 SQL Logger Error ERROR: relation "variable_history_373203109" already exists

2019-09-07 12:38:44.104 SQL Logger Error INSERT INTO variable_history_373203109 (value) VALUES (%s);
2019-09-07 12:38:44.141 SQL Logger creating table variable_history_1314873387 for "oneAway_11"
2019-09-07 12:38:44.149 SQL Logger Error exception trying to insert row into table variable_history_1314873387 ("oneAway_11")
2019-09-07 12:38:44.149 SQL Logger Error ERROR: relation "variable_history_1314873387" already exists

2019-09-07 12:38:44.149 SQL Logger Error INSERT INTO variable_history_1314873387 (value) VALUES (%s);
2019-09-07 12:38:44.207 SQL Logger creating table variable_history_851049193 for "oneAway_12"
2019-09-07 12:38:44.217 SQL Logger Error exception trying to insert row into table variable_history_851049193 ("oneAway_12")
2019-09-07 12:38:44.217 SQL Logger Error ERROR: relation "variable_history_851049193" already exists

2019-09-07 12:38:44.217 SQL Logger Error INSERT INTO variable_history_851049193 (value) VALUES (%s);
2019-09-07 12:38:44.223 SQL Logger creating table variable_history_1214016071 for "oneAway_2"
2019-09-07 12:38:44.229 SQL Logger Error exception trying to insert row into table variable_history_1214016071 ("oneAway_2")
2019-09-07 12:38:44.229 SQL Logger Error ERROR: relation "variable_history_1214016071" already exists

2019-09-07 12:38:44.229 SQL Logger Error INSERT INTO variable_history_1214016071 (value) VALUES (%s);
2019-09-07 12:38:44.235 SQL Logger creating table variable_history_1443381228 for "oneAway_3"
2019-09-07 12:38:44.240 SQL Logger Error exception trying to insert row into table variable_history_1443381228 ("oneAway_3")
2019-09-07 12:38:44.241 SQL Logger Error ERROR: relation "variable_history_1443381228" already exists

2019-09-07 12:38:44.241 SQL Logger Error INSERT INTO variable_history_1443381228 (value) VALUES (%s);
2019-09-07 12:38:44.247 SQL Logger creating table variable_history_1329081162 for "oneAway_4"
2019-09-07 12:38:44.253 SQL Logger Error exception trying to insert row into table variable_history_1329081162 ("oneAway_4")
2019-09-07 12:38:44.253 SQL Logger Error ERROR: relation "variable_history_1329081162" already exists

2019-09-07 12:38:44.253 SQL Logger Error INSERT INTO variable_history_1329081162 (value) VALUES (%s);
2019-09-07 12:38:44.259 SQL Logger creating table variable_history_1007329765 for "oneAway_5"
2019-09-07 12:38:44.265 SQL Logger Error exception trying to insert row into table variable_history_1007329765 ("oneAway_5")
2019-09-07 12:38:44.265 SQL Logger Error ERROR: relation "variable_history_1007329765" already exists

2019-09-07 12:38:44.266 SQL Logger Error INSERT INTO variable_history_1007329765 (value) VALUES (%s);
2019-09-07 12:38:44.274 SQL Logger creating table variable_history_1004609989 for "oneAway_6"
2019-09-07 12:38:44.279 SQL Logger Error exception trying to insert row into table variable_history_1004609989 ("oneAway_6")
2019-09-07 12:38:44.280 SQL Logger Error ERROR: relation "variable_history_1004609989" already exists

2019-09-07 12:38:44.280 SQL Logger Error INSERT INTO variable_history_1004609989 (value) VALUES (%s);
2019-09-07 12:38:44.286 SQL Logger creating table variable_history_1177321555 for "oneAway_7"
2019-09-07 12:38:44.291 SQL Logger Error exception trying to insert row into table variable_history_1177321555 ("oneAway_7")
2019-09-07 12:38:44.292 SQL Logger Error ERROR: relation "variable_history_1177321555" already exists

2019-09-07 12:38:44.292 SQL Logger Error INSERT INTO variable_history_1177321555 (value) VALUES (%s);
2019-09-07 12:38:44.297 SQL Logger creating table variable_history_1115318474 for "oneAway_8"
2019-09-07 12:38:44.304 SQL Logger Error exception trying to insert row into table variable_history_1115318474 ("oneAway_8")
2019-09-07 12:38:44.305 SQL Logger Error ERROR: relation "variable_history_1115318474" already exists

2019-09-07 12:38:44.305 SQL Logger Error INSERT INTO variable_history_1115318474 (value) VALUES (%s);
2019-09-07 12:38:44.312 SQL Logger creating table variable_history_1119212397 for "oneAway_9"
2019-09-07 12:38:44.318 SQL Logger Error exception trying to insert row into table variable_history_1119212397 ("oneAway_9")
2019-09-07 12:38:44.318 SQL Logger Error ERROR: relation "variable_history_1119212397" already exists

2019-09-07 12:38:44.318 SQL Logger Error INSERT INTO variable_history_1119212397 (value) VALUES (%s);
2019-09-07 12:38:44.324 SQL Logger creating table variable_history_501252705 for "oneHome_1"
2019-09-07 12:38:44.330 SQL Logger Error exception trying to insert row into table variable_history_501252705 ("oneHome_1")
2019-09-07 12:38:44.330 SQL Logger Error ERROR: relation "variable_history_501252705" already exists

2019-09-07 12:38:44.330 SQL Logger Error INSERT INTO variable_history_501252705 (value) VALUES (%s);
2019-09-07 12:38:44.336 SQL Logger creating table variable_history_1246626053 for "oneHome_10"
2019-09-07 12:38:44.341 SQL Logger Error exception trying to insert row into table variable_history_1246626053 ("oneHome_10")
2019-09-07 12:38:44.341 SQL Logger Error ERROR: relation "variable_history_1246626053" already exists

2019-09-07 12:38:44.342 SQL Logger Error INSERT INTO variable_history_1246626053 (value) VALUES (%s);
2019-09-07 12:38:44.348 SQL Logger creating table variable_history_108031773 for "oneHome_11"
2019-09-07 12:38:44.355 SQL Logger Error exception trying to insert row into table variable_history_108031773 ("oneHome_11")
2019-09-07 12:38:44.355 SQL Logger Error ERROR: relation "variable_history_108031773" already exists

2019-09-07 12:38:44.356 SQL Logger Error INSERT INTO variable_history_108031773 (value) VALUES (%s);
2019-09-07 12:38:44.361 SQL Logger creating table variable_history_1006221893 for "oneHome_12"
2019-09-07 12:38:44.367 SQL Logger Error exception trying to insert row into table variable_history_1006221893 ("oneHome_12")
2019-09-07 12:38:44.367 SQL Logger Error ERROR: relation "variable_history_1006221893" already exists

2019-09-07 12:38:44.367 SQL Logger Error INSERT INTO variable_history_1006221893 (value) VALUES (%s);
2019-09-07 12:38:44.374 SQL Logger creating table variable_history_1466827398 for "oneHome_2"
2019-09-07 12:38:44.381 SQL Logger Error exception trying to insert row into table variable_history_1466827398 ("oneHome_2")
2019-09-07 12:38:44.381 SQL Logger Error ERROR: relation "variable_history_1466827398" already exists

2019-09-07 12:38:44.382 SQL Logger Error INSERT INTO variable_history_1466827398 (value) VALUES (%s);
2019-09-07 12:38:44.483 SQL Logger creating table variable_history_13769288 for "oneHome_3"
2019-09-07 12:38:44.489 SQL Logger Error exception trying to insert row into table variable_history_13769288 ("oneHome_3")
2019-09-07 12:38:44.489 SQL Logger Error ERROR: relation "variable_history_13769288" already exists

2019-09-07 12:38:44.489 SQL Logger Error INSERT INTO variable_history_13769288 (value) VALUES (%s);
2019-09-07 12:38:44.496 SQL Logger creating table variable_history_753116031 for "oneHome_4"
2019-09-07 12:38:44.502 SQL Logger Error exception trying to insert row into table variable_history_753116031 ("oneHome_4")
2019-09-07 12:38:44.502 SQL Logger Error ERROR: relation "variable_history_753116031" already exists

2019-09-07 12:38:44.502 SQL Logger Error INSERT INTO variable_history_753116031 (value) VALUES (%s);
2019-09-07 12:38:44.585 SQL Logger creating table variable_history_212035604 for "oneHome_5"
2019-09-07 12:38:44.591 SQL Logger Error exception trying to insert row into table variable_history_212035604 ("oneHome_5")
2019-09-07 12:38:44.591 SQL Logger Error ERROR: relation "variable_history_212035604" already exists

2019-09-07 12:38:44.592 SQL Logger Error INSERT INTO variable_history_212035604 (value) VALUES (%s);
2019-09-07 12:38:44.609 SQL Logger creating table variable_history_1996709989 for "oneHome_6"
2019-09-07 12:38:44.615 SQL Logger Error exception trying to insert row into table variable_history_1996709989 ("oneHome_6")
2019-09-07 12:38:44.616 SQL Logger Error ERROR: relation "variable_history_1996709989" already exists

2019-09-07 12:38:44.616 SQL Logger Error INSERT INTO variable_history_1996709989 (value) VALUES (%s);
2019-09-07 12:38:44.653 SQL Logger creating table variable_history_1230629590 for "oneHome_7"
2019-09-07 12:38:44.685 SQL Logger Error exception trying to insert row into table variable_history_1230629590 ("oneHome_7")
2019-09-07 12:38:44.685 SQL Logger Error ERROR: relation "variable_history_1230629590" already exists

2019-09-07 12:38:44.685 SQL Logger Error INSERT INTO variable_history_1230629590 (value) VALUES (%s);
2019-09-07 12:38:44.759 SQL Logger creating table variable_history_1451282617 for "oneHome_8"
2019-09-07 12:38:44.764 SQL Logger Error exception trying to insert row into table variable_history_1451282617 ("oneHome_8")
2019-09-07 12:38:44.764 SQL Logger Error ERROR: relation "variable_history_1451282617" already exists

2019-09-07 12:38:44.765 SQL Logger Error INSERT INTO variable_history_1451282617 (value) VALUES (%s);
2019-09-07 12:38:44.786 SQL Logger creating table variable_history_779648340 for "oneHome_9"
2019-09-07 12:38:44.791 SQL Logger Error exception trying to insert row into table variable_history_779648340 ("oneHome_9")
2019-09-07 12:38:44.791 SQL Logger Error ERROR: relation "variable_history_779648340" already exists

2019-09-07 12:38:44.792 SQL Logger Error INSERT INTO variable_history_779648340 (value) VALUES (%s);
2019-09-07 12:38:44.854 SQL Logger creating table variable_history_422668660 for "OnkyoOn"
2019-09-07 12:38:44.860 SQL Logger Error exception trying to insert row into table variable_history_422668660 ("OnkyoOn")
2019-09-07 12:38:44.860 SQL Logger Error ERROR: relation "variable_history_422668660" already exists

2019-09-07 12:38:44.860 SQL Logger Error INSERT INTO variable_history_422668660 (value) VALUES (%s);
2019-09-07 12:38:44.941 SQL Logger creating table variable_history_1986454774 for "Oregon01_temperature_lastHour_Ave"
2019-09-07 12:38:44.957 SQL Logger Error exception trying to insert row into table variable_history_1986454774 ("Oregon01_temperature_lastHour_Ave")
2019-09-07 12:38:44.957 SQL Logger Error ERROR: relation "variable_history_1986454774" already exists

2019-09-07 12:38:44.957 SQL Logger Error INSERT INTO variable_history_1986454774 (value) VALUES (%s);
2019-09-07 12:38:44.964 SQL Logger creating table variable_history_174206583 for "Oregon01_temperature_lastHour_Ave_Count"
2019-09-07 12:38:44.969 SQL Logger Error exception trying to insert row into table variable_history_174206583 ("Oregon01_temperature_lastHour_Ave_Count")
2019-09-07 12:38:44.969 SQL Logger Error ERROR: relation "variable_history_174206583" already exists

2019-09-07 12:38:44.970 SQL Logger Error INSERT INTO variable_history_174206583 (value) VALUES (%s);
2019-09-07 12:38:45.002 SQL Logger creating table variable_history_687589533 for "Oregon01_temperature_lastHour_Max"
2019-09-07 12:38:45.038 SQL Logger Error exception trying to insert row into table variable_history_687589533 ("Oregon01_temperature_lastHour_Max")
2019-09-07 12:38:45.038 SQL Logger Error ERROR: relation "variable_history_687589533" already exists

2019-09-07 12:38:45.038 SQL Logger Error INSERT INTO variable_history_687589533 (value) VALUES (%s);
2019-09-07 12:38:45.123 SQL Logger creating table variable_history_1379294936 for "Oregon01_temperature_lastHour_Max_Date"
2019-09-07 12:38:45.130 SQL Logger Error exception trying to insert row into table variable_history_1379294936 ("Oregon01_temperature_lastHour_Max_Date")
2019-09-07 12:38:45.131 SQL Logger Error ERROR: relation "variable_history_1379294936" already exists

2019-09-07 12:38:45.131 SQL Logger Error INSERT INTO variable_history_1379294936 (value) VALUES (%s);
2019-09-07 12:38:45.146 SQL Logger creating table variable_history_141344396 for "Oregon01_temperature_lastHour_Min"
2019-09-07 12:38:45.155 SQL Logger Error exception trying to insert row into table variable_history_141344396 ("Oregon01_temperature_lastHour_Min")
2019-09-07 12:38:45.155 SQL Logger Error ERROR: relation "variable_history_141344396" already exists

2019-09-07 12:38:45.156 SQL Logger Error INSERT INTO variable_history_141344396 (value) VALUES (%s);
2019-09-07 12:38:45.164 SQL Logger creating table variable_history_1513041213 for "Oregon01_temperature_lastHour_Min_Date"
2019-09-07 12:38:45.173 SQL Logger Error exception trying to insert row into table variable_history_1513041213 ("Oregon01_temperature_lastHour_Min_Date")
2019-09-07 12:38:45.174 SQL Logger Error ERROR: relation "variable_history_1513041213" already exists

2019-09-07 12:38:45.174 SQL Logger Error INSERT INTO variable_history_1513041213 (value) VALUES (%s);
2019-09-07 12:38:45.182 SQL Logger creating table variable_history_60976040 for "Oregon01_temperature_thisDay_Ave"
2019-09-07 12:38:45.190 SQL Logger Error exception trying to insert row into table variable_history_60976040 ("Oregon01_temperature_thisDay_Ave")
2019-09-07 12:38:45.191 SQL Logger Error ERROR: relation "variable_history_60976040" already exists

2019-09-07 12:38:45.191 SQL Logger Error INSERT INTO variable_history_60976040 (value) VALUES (%s);
2019-09-07 12:38:45.200 SQL Logger creating table variable_history_1786081019 for "Oregon01_temperature_thisDay_Ave_Count"
2019-09-07 12:38:45.207 SQL Logger Error exception trying to insert row into table variable_history_1786081019 ("Oregon01_temperature_thisDay_Ave_Count")
2019-09-07 12:38:45.208 SQL Logger Error ERROR: relation "variable_history_1786081019" already exists

2019-09-07 12:38:45.208 SQL Logger Error INSERT INTO variable_history_1786081019 (value) VALUES (%s);
2019-09-07 12:38:45.216 SQL Logger creating table variable_history_1606335490 for "Oregon01_temperature_thisDay_Max"
2019-09-07 12:38:45.225 SQL Logger Error exception trying to insert row into table variable_history_1606335490 ("Oregon01_temperature_thisDay_Max")
2019-09-07 12:38:45.225 SQL Logger Error ERROR: relation "variable_history_1606335490" already exists

2019-09-07 12:38:45.226 SQL Logger Error INSERT INTO variable_history_1606335490 (value) VALUES (%s);
2019-09-07 12:38:45.259 SQL Logger creating table variable_history_1411240890 for "Oregon01_temperature_thisDay_Max_Date"
2019-09-07 12:38:45.265 SQL Logger Error exception trying to insert row into table variable_history_1411240890 ("Oregon01_temperature_thisDay_Max_Date")
2019-09-07 12:38:45.266 SQL Logger Error ERROR: relation "variable_history_1411240890" already exists

2019-09-07 12:38:45.266 SQL Logger Error INSERT INTO variable_history_1411240890 (value) VALUES (%s);
2019-09-07 12:38:45.274 SQL Logger creating table variable_history_1960024302 for "Oregon01_temperature_thisDay_Min"
2019-09-07 12:38:45.280 SQL Logger Error exception trying to insert row into table variable_history_1960024302 ("Oregon01_temperature_thisDay_Min")
2019-09-07 12:38:45.280 SQL Logger Error ERROR: relation "variable_history_1960024302" already exists

2019-09-07 12:38:45.281 SQL Logger Error INSERT INTO variable_history_1960024302 (value) VALUES (%s);
2019-09-07 12:38:45.289 SQL Logger creating table variable_history_1598863273 for "Oregon01_temperature_thisDay_Min_Date"
2019-09-07 12:38:45.295 SQL Logger Error exception trying to insert row into table variable_history_1598863273 ("Oregon01_temperature_thisDay_Min_Date")
2019-09-07 12:38:45.296 SQL Logger Error ERROR: relation "variable_history_1598863273" already exists

2019-09-07 12:38:45.296 SQL Logger Error INSERT INTO variable_history_1598863273 (value) VALUES (%s);
2019-09-07 12:38:45.303 SQL Logger creating table variable_history_386046080 for "Oregon01_temperature_thisHour_Ave"
2019-09-07 12:38:45.313 SQL Logger Error exception trying to insert row into table variable_history_386046080 ("Oregon01_temperature_thisHour_Ave")
2019-09-07 12:38:45.313 SQL Logger Error ERROR: relation "variable_history_386046080" already exists

2019-09-07 12:38:45.314 SQL Logger Error INSERT INTO variable_history_386046080 (value) VALUES (%s);
2019-09-07 12:38:45.321 SQL Logger creating table variable_history_1627497646 for "Oregon01_temperature_thisHour_Ave_Count"
2019-09-07 12:38:45.327 SQL Logger Error exception trying to insert row into table variable_history_1627497646 ("Oregon01_temperature_thisHour_Ave_Count")
2019-09-07 12:38:45.327 SQL Logger Error ERROR: relation "variable_history_1627497646" already exists

2019-09-07 12:38:45.328 SQL Logger Error INSERT INTO variable_history_1627497646 (value) VALUES (%s);
2019-09-07 12:38:45.372 SQL Logger creating table variable_history_1830677205 for "Oregon01_temperature_thisHour_Max"
2019-09-07 12:38:45.381 SQL Logger Error exception trying to insert row into table variable_history_1830677205 ("Oregon01_temperature_thisHour_Max")
2019-09-07 12:38:45.381 SQL Logger Error ERROR: relation "variable_history_1830677205" already exists

2019-09-07 12:38:45.382 SQL Logger Error INSERT INTO variable_history_1830677205 (value) VALUES (%s);
2019-09-07 12:38:45.391 SQL Logger creating table variable_history_427938330 for "Oregon01_temperature_thisHour_Max_Date"
2019-09-07 12:38:45.400 SQL Logger Error exception trying to insert row into table variable_history_427938330 ("Oregon01_temperature_thisHour_Max_Date")
2019-09-07 12:38:45.400 SQL Logger Error ERROR: relation "variable_history_427938330" already exists

2019-09-07 12:38:45.401 SQL Logger Error INSERT INTO variable_history_427938330 (value) VALUES (%s);
2019-09-07 12:38:45.411 SQL Logger creating table variable_history_1543375277 for "Oregon01_temperature_thisHour_Min"
2019-09-07 12:38:45.417 SQL Logger Error exception trying to insert row into table variable_history_1543375277 ("Oregon01_temperature_thisHour_Min")
2019-09-07 12:38:45.417 SQL Logger Error ERROR: relation "variable_history_1543375277" already exists

2019-09-07 12:38:45.418 SQL Logger Error INSERT INTO variable_history_1543375277 (value) VALUES (%s);
2019-09-07 12:38:45.425 SQL Logger creating table variable_history_1721201335 for "Oregon01_temperature_thisHour_Min_Date"
2019-09-07 12:38:45.499 SQL Logger Error exception trying to insert row into table variable_history_1721201335 ("Oregon01_temperature_thisHour_Min_Date")
2019-09-07 12:38:45.500 SQL Logger Error ERROR: relation "variable_history_1721201335" already exists

2019-09-07 12:38:45.500 SQL Logger Error INSERT INTO variable_history_1721201335 (value) VALUES (%s);
2019-09-07 12:38:45.574 SQL Logger creating table variable_history_1974755080 for "Oregon01_temperature_thisWeek_Ave"
2019-09-07 12:38:45.579 SQL Logger Error exception trying to insert row into table variable_history_1974755080 ("Oregon01_temperature_thisWeek_Ave")
2019-09-07 12:38:45.580 SQL Logger Error ERROR: relation "variable_history_1974755080" already exists

2019-09-07 12:38:45.580 SQL Logger Error INSERT INTO variable_history_1974755080 (value) VALUES (%s);
2019-09-07 12:38:45.597 SQL Logger creating table variable_history_1089141585 for "Oregon01_temperature_thisWeek_Ave_Count"
2019-09-07 12:38:45.604 SQL Logger Error exception trying to insert row into table variable_history_1089141585 ("Oregon01_temperature_thisWeek_Ave_Count")
2019-09-07 12:38:45.604 SQL Logger Error ERROR: relation "variable_history_1089141585" already exists

2019-09-07 12:38:45.604 SQL Logger Error INSERT INTO variable_history_1089141585 (value) VALUES (%s);
2019-09-07 12:38:45.611 SQL Logger creating table variable_history_1010152593 for "Oregon01_temperature_thisWeek_Max"
2019-09-07 12:38:45.622 SQL Logger Error exception trying to insert row into table variable_history_1010152593 ("Oregon01_temperature_thisWeek_Max")
2019-09-07 12:38:45.622 SQL Logger Error ERROR: relation "variable_history_1010152593" already exists

2019-09-07 12:38:45.623 SQL Logger Error INSERT INTO variable_history_1010152593 (value) VALUES (%s);
2019-09-07 12:38:45.645 SQL Logger creating table variable_history_1139017010 for "Oregon01_temperature_thisWeek_Max_Date"
2019-09-07 12:38:45.651 SQL Logger Error exception trying to insert row into table variable_history_1139017010 ("Oregon01_temperature_thisWeek_Max_Date")
2019-09-07 12:38:45.652 SQL Logger Error ERROR: relation "variable_history_1139017010" already exists

2019-09-07 12:38:45.652 SQL Logger Error INSERT INTO variable_history_1139017010 (value) VALUES (%s);
2019-09-07 12:38:45.659 SQL Logger creating table variable_history_91612225 for "Oregon01_temperature_thisWeek_Min"
2019-09-07 12:38:45.665 SQL Logger Error exception trying to insert row into table variable_history_91612225 ("Oregon01_temperature_thisWeek_Min")
2019-09-07 12:38:45.665 SQL Logger Error ERROR: relation "variable_history_91612225" already exists

2019-09-07 12:38:45.665 SQL Logger Error INSERT INTO variable_history_91612225 (value) VALUES (%s);
2019-09-07 12:38:45.673 SQL Logger creating table variable_history_1926426954 for "Oregon01_temperature_thisWeek_Min_Date"
2019-09-07 12:38:45.679 SQL Logger Error exception trying to insert row into table variable_history_1926426954 ("Oregon01_temperature_thisWeek_Min_Date")
2019-09-07 12:38:45.679 SQL Logger Error ERROR: relation "variable_history_1926426954" already exists

2019-09-07 12:38:45.679 SQL Logger Error INSERT INTO variable_history_1926426954 (value) VALUES (%s);
2019-09-07 12:38:45.721 SQL Logger creating table variable_history_1448535945 for "Oregon_01_temperature_lastHour_Ave"
2019-09-07 12:38:45.727 SQL Logger Error exception trying to insert row into table variable_history_1448535945 ("Oregon_01_temperature_lastHour_Ave")
2019-09-07 12:38:45.727 SQL Logger Error ERROR: relation "variable_history_1448535945" already exists

2019-09-07 12:38:45.728 SQL Logger Error INSERT INTO variable_history_1448535945 (value) VALUES (%s);
2019-09-07 12:38:45.770 SQL Logger creating table variable_history_895949122 for "Oregon_01_temperature_lastHour_Ave_Count"
2019-09-07 12:38:45.775 SQL Logger Error exception trying to insert row into table variable_history_895949122 ("Oregon_01_temperature_lastHour_Ave_Count")
2019-09-07 12:38:45.776 SQL Logger Error ERROR: relation "variable_history_895949122" already exists

As an example of the thousands of errors now occurring.

I'll reboot Mac to see if that settles things down

Reboot did not help.

Well I guess it is a quick way to fill up a disk

SQL Logger Error INSERT INTO variable_history_56241564 (value) VALUES (%s);
SQL Logger creating table variable_history_663617641 for "Watching"
SQL Logger Error exception trying to insert row into table variable_history_663617641 ("Watching")
SQL Logger Error ERROR: relation "variable_history_663617641" already exists

Seems to be a common issue seems to be trying to create a table that already existing

I know nothing about SQL Servers so have not idea what to do about this.

I moved to a Postgre after SQLite had issues and postgre was more stable?

Seems to have settled down to these sort of errors now.

SQL Logger Error exception trying to update table device_history_1977687963 ("Temp: Dining Room (Hue)") -- unable to modify table
SQL Logger Error ERROR: column "temperaturef" of relation "device_history_1977687963" does not exist at character 40

SQL Logger Error exception trying to insert row into table device_history_1977687963 ("Temp: Dining Room (Hue)") -- unable to modify table
SQL Logger Error ERROR: column "temperaturec_ui" of relation "device_history_1977687963" does not exist at character 40

SQL Logger Error INSERT INTO device_history_1977687963 ("temperaturef", "temperaturef_ui") VALUES (%s, %s);

[matt (support)]

Looks like your database has maybe gotten into a bad state. What happens if in the SQL Logger plugin you change the database name (ex: from indigo_history to indigo_history2)? That will obviously cause any other plugins (graphing?) to not pick up new device/variable changes, but I'm curious if that makes all the errors go away. If it does then we at least know the problem is specific to the original database.

Ok incremented DB name by adding a 2 on the end

It is creating tables and adding columns so far without error

Looks like the fist one corrupted somehow - no crashes/reboots this machine runs for months,,

Thanks that seems to have fixed it.

Unwound switch to Postgres. Much more stable running for >2 years now > 30 gbytes
No problems


SQLite is a simple file any bad write or reboot will kill it.

It is very simple to install. If your know how it takes 3 minutes incl download:

Find/ download Postgres app on web

Run installer

Switch indigo from SQLite to postgres in logger menu.




Sent from my iPhone using Tapatalk

I am/was running Postgres

there is one problem when the DB is very large and indigo wants to change a device state prop from eg int too real.
then it is busy and indigo can't update:

1. disable logger in indigo menu
2. wait 3 minutes until all changes complete
3. restart logger in indigo menu

Karl

ps this is my request to be able to stop a plugin from with a script wait and restart it .. requested for > 2 years now

[jay (support)]

ps this is my request to be able to stop a plugin from with a script wait and restart it .. requested for > 2 years now

And, as we've described before, this is a security issue and won't be changed. Also as we've said before, if you really need that much data and have that much churn, then you likely need to look for a more high-volume solution.

[jay (support)]

I am/was running Postgres

Did you try to repair the Postgres db? I think there are tools out there...

And, as we've described before, this is a security issue and won't be changed.

.. I know, no Alzheimer yet

.. is there a way to stop the indigo server from the command line besides "kill .. pid"

this stops the app, but not the server

Code: Select all

osascript -e 'quit app "Indigo 7.3"'

This seems to be fine to start:

Code: Select all

"/Library/Application Support/Perceptive Automation/Indigo 7.3/IndigoPluginHost.app/Contents/MacOS/IndigoPluginHost" -i &
open 'Indigo 7.3.app'


.. is there a way to stop the indigo server from the command line besides "kill .. pid"

New in 7.something:

Code: Select all

Kraken:~ jkeenan$ ls -l /usr/local/bin/in*
lrwxr-xr-x  1 root  admin  45 Apr 17 09:00 /usr/local/bin/indigo-clean-and-zip-plugin -> /usr/local/indigo/indigo-clean-and-zip-plugin
lrwxr-xr-x  1 root  admin  29 Apr 17 09:00 /usr/local/bin/indigo-host -> /usr/local/indigo/indigo-host
lrwxr-xr-x  1 root  admin  39 Apr 17 09:00 /usr/local/bin/indigo-restart-plugin -> /usr/local/indigo/indigo-restart-plugin
lrwxr-xr-x  1 root  admin  30 Apr 17 09:00 /usr/local/bin/indigo-start -> /usr/local/indigo/indigo-start
lrwxr-xr-x  1 root  admin  29 Apr 17 09:00 /usr/local/bin/indigo-stop -> /usr/local/indigo/indigo-stop

Kraken:~ jkeenan$ ls -l /usr/local/indigo/
total 72
-rwxrwx---  1 root  admin  4534 May 10 18:06 indigo-clean-and-zip-plugin
-rwxrwx---  1 root  admin  5511 May 10 18:06 indigo-host
-rwxrwx---  1 root  admin  6269 May 10 18:06 indigo-restart-plugin
-rwxrwx---  1 root  admin  2484 May 10 18:06 indigo-start
-rwxrwx---  1 root  admin  5195 May 10 18:06 indigo-stop



in a terminal that seems to work when starting shell from within indigo I get an error:
"Failed to get owner of "

here the script:

Code: Select all

import os
indigoV = "7.3"

cmd =  "#!/bin/bash\n"
cmd +=  "echo 'step1'  >> '/users/karlwachs/log'\n"
cmd +=  "/usr/bin/osascript -e 'quit app \"Indigo "+indigoV+"\"' >> 'users/karlwachs/log' \n"
cmd +=  "echo 'step2'  >> '/users/karlwachs/log'\n"
cmd += "/bin/sleep 2\n"
cmd +=  "echo 'step3'  >> '/users/karlwachs/log'\n"
cmd += "/usr/local/indigo/indigo-stop >> '/users/karlwachs/log' \n"
cmd +=  "echo 'step4'  >> '/users/karlwachs/log'\n"
cmd += "/bin/sleep 30\n"
cmd +=  "echo 'step5'  >> '/users/karlwachs/log'\n"
cmd += "/usr/local/indigo/indigo-start >> '/users/karlwachs/log' \n"
cmd +=  "echo 'step6'  >> '/users/karlwachs/log'\n"
cmd += "/bin/sleep 2\n"
cmd +=  "echo 'step7'  >> '/users/karlwachs/log'\n"
cmd += "open 'Indigo "+indigoV+".app' >> '/users/karlwachs/log' \n"
cmd +=  "echo 'step8'  >> '/users/karlwachs/log'\n"
f=open("/tmp/restartIndigo.sh","w")
f.write(cmd)
f.close()
f=open("/tmp/restartIndigo2.sh","w")
f.write("#!/bin/bash\n/tmp/restartIndigo.sh &\n")
f.close()
indigo.server.log("/tmp/restartIndigo2.sh &  --> "+cmd )
os.system("chmod +x /tmp/restartIndigo.sh")
os.system("chmod +x /tmp/restartIndigo2.sh")
os.system("/tmp/restartIndigo2.sh &")


the script calls a script that does a batch call to a script to have it one step away from indigo, so that the indigo script can finish before the actual script is finished

the log file output is:

Code: Select all

step1
step2
step3
Failed to get owner of  <<<<----- errors
IndigoServer_d.app was not running
IndigoWebServer was not running
IndigoSqlClient was not running
step4
step5
Failed to get owner of <<<----- errors
step6
step7
step8


it stops the indigo client, but does not stop the server.
does it have to run as su?


Karl

[matt (support)]

You can view the source of the indigo-stop script to see where it is failing:

Code: Select all

   if [ -z "$LAUNCHCTL_USER" ]
   then
      echo "Failed to get owner of $HOME"
      return 0
   fi

So the problem is when os.system executes the script the shell $HOME variable isn't set. You could try setting it to your user home directory before you call the stop script? I think that might get it working...