Mattias wrote:SQL Logger Debug INSERT INTO device_history_1523305554 ("longstatusstring", "timeleftdays", "timelefthours", "timeleftminutes", "timeleftseconds", "timerstartvalueseconds", "timerstatus", "timerstatus_active", "timerstatus_inactive", "timerstatus_paused") VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s);
SQL Logger Debug (u'inactive', u'0', u'0', u'0', u'0', u'252000', u'inactive', u'False', u'True', u'False')
SQL Logger Debug DELETE FROM device_history_1523305554 WHERE ts < %s;
SQL Logger Debug ('2017-11-17',)
SQL Logger Error exception trying to insert row into table device_history_1523305554 ("timersPester_tidMellanBuskarSprinkler_70h") -- unable to modify table
SQL Logger Error Connection to backend closed
...
SQL Logger Error broken pipe error trying to insert row into table device_history_1888213338 ("timersPester_tidMellanPlantSprinkler_46h")
SQL Logger closing SQL connection
SQL Logger Error exception trying to create table device_history_821779449 ("TP_B-julstjarnor")
SQL Logger Error not connected to database
Mattias wrote:So, if I have Pgadmin open looking at a table - restarts sqllogger - i get a ‘application has lost database connection’ when I refresh pgadmin. Second refresh the table shows up with a new row of device data.
Users browsing this forum: No registered users and 3 guests