vorab alles läuft in getrennten >Dockern auf Qnap
Openhab
Influx
Grafana
Wenn ich die standart percistense in oh auff rrd4j stelle erhalte ich vollständige diagramme somit denke ich das es nicht an oh liegt.
Grafana funktioniert auch weil ich da noch eine Datenbank solaranzeige habe für mein PV system.
Es muss irgendwas an influx sein zb gestern wurden werte bis 2.05 Uhr geschrieben dann nicht mehr.
Wenn ich den Openhab Server neustarte dann funktioniert es wieder für einige stunden irgendwann schreibt die influx keine werte mehr
Speziell geht es mir um das ReloadAllFromGateway.
Dieses item wird per Rule aller 5 Mintuen ausgelösst dazu habe ich ein Chart in Grafana
hier noch meine influxdb.persist
Code: Alles auswählen
Strategies {
every10Seconds : "0/10 * * * * ?"
everyMinute : "0 * * * * ?"
every15Minutes : "*/15 * * * *"
everyHour : "0 0 * * * ?"
everyDay : "0 0 0 * * ?"
every2Minutes : "0 */2 * ? * *"
}
Items {
* : strategy = everyChange, restoreOnStartup
group* : strategy = everyChange, restoreOnStartup //persist all direct members of the group 'group'
//item : strategy = everyChange, everyUpdate, everyHour // persist the item 'item'
//otherItem // no strategy set, so use default strategy for item 'otherItem'
Solarpanel_Betrieb : strategy = everyChange, restoreOnStartup
Solarpanel_Ertrag_Tag : strategy = everyMinute, restoreOnStartup
Solarpanel_PowerConsumption : strategy = every10Seconds, restoreOnStartup
Solarpanel_Temperature : strategy = everyChange, restoreOnStartup
shellyplugsQNAP192168155_Leistung : strategy = everyChange, restoreOnStartup
ReloadAllFromGateway : strategy = everyChange, restoreOnStartup
HausanschlussStrom_Power : strategy = everyChange, restoreOnStartup
Code: Alles auswählen
2023-08-25T15:35:54.790544Z info Opened file {"log_id": "0jsLF6rl000", "engine": "tsm1", "service": "filestore", "path": "/var/lib/influxdb/data/_internal/monitor/705/000000016-000000002.tsm", "id": 1, "duration": "1.398ms"}
2023-08-25T15:35:54.795651Z info Opened file {"log_id": "0jsLF6rl000", "engine": "tsm1", "service": "filestore", "path": "/var/lib/influxdb/data/_internal/monitor/705/000000008-000000002.tsm", "id": 0, "duration": "8.792ms"}
2023-08-25T15:35:54.795968Z info Reading file {"log_id": "0jsLF6rl000", "engine": "tsm1", "service": "cacheloader", "path": "/var/lib/influxdb/wal/_internal/monitor/705/_00096.wal", "size": 1698125}
2023-08-25T15:35:54.869502Z info Opened shard {"log_id": "0jsLF6rl000", "service": "store", "trace_id": "0jsLF7N0000", "op_name": "tsdb_open", "index_version": "inmem", "path": "/var/lib/influxdb/data/OpenHAB3_DB/autogen/76", "duration": "220.779ms"}
2023-08-25T15:35:54.889678Z info Opened file {"log_id": "0jsLF6rl000", "engine": "tsm1", "service": "filestore", "path": "/var/lib/influxdb/data/_internal/monitor/697/000000029-000000002.tsm", "id": 0, "duration": "18.371ms"}
2023-08-25T15:35:54.891235Z info Opened shard {"log_id": "0jsLF6rl000", "service": "store", "trace_id": "0jsLF7N0000", "op_name": "tsdb_open", "index_version": "inmem", "path": "/var/lib/influxdb/data/OpenHAB3_DB/autogen/92", "duration": "194.489ms"}
2023-08-25T15:35:54.894653Z info Opened shard {"log_id": "0jsLF6rl000", "service": "store", "trace_id": "0jsLF7N0000", "op_name": "tsdb_open", "index_version": "inmem", "path": "/var/lib/influxdb/data/OpenHAB3_DB/autogen/84", "duration": "198.642ms"}
2023-08-25T15:35:54.983249Z info Opened file {"log_id": "0jsLF6rl000", "engine": "tsm1", "service": "filestore", "path": "/var/lib/influxdb/data/_internal/monitor/698/000000029-000000002.tsm", "id": 0, "duration": "45.577ms"}
2023-08-25T15:35:54.986925Z info Opened file {"log_id": "0jsLF6rl000", "engine": "tsm1", "service": "filestore", "path": "/var/lib/influxdb/data/_internal/monitor/699/000000029-000000002.tsm", "id": 0, "duration": "61.239ms"}
2023-08-25T15:35:55.075361Z info Opened shard {"log_id": "0jsLF6rl000", "service": "store", "trace_id": "0jsLF7N0000", "op_name": "tsdb_open", "index_version": "inmem", "path": "/var/lib/influxdb/data/_internal/monitor/699", "duration": "153.315ms"}
2023-08-25T15:35:55.103174Z info Opened file {"log_id": "0jsLF6rl000", "engine": "tsm1", "service": "filestore", "path": "/var/lib/influxdb/data/_internal/monitor/701/000000030-000000002.tsm", "id": 0, "duration": "24.647ms"}
2023-08-25T15:35:55.186954Z info Opened shard {"log_id": "0jsLF6rl000", "service": "store", "trace_id": "0jsLF7N0000", "op_name": "tsdb_open", "index_version": "inmem", "path": "/var/lib/influxdb/data/_internal/monitor/697", "duration": "317.257ms"}
2023-08-25T15:35:55.188315Z info Opened shard {"log_id": "0jsLF6rl000", "service": "store", "trace_id": "0jsLF7N0000", "op_name": "tsdb_open", "index_version": "inmem", "path": "/var/lib/influxdb/data/_internal/monitor/698", "duration": "274.078ms"}
2023-08-25T15:35:55.204081Z info Opened file {"log_id": "0jsLF6rl000", "engine": "tsm1", "service": "filestore", "path": "/var/lib/influxdb/data/_internal/monitor/702/000000030-000000002.tsm", "id": 0, "duration": "13.634ms"}
2023-08-25T15:35:55.212007Z info Opened file {"log_id": "0jsLF6rl000", "engine": "tsm1", "service": "filestore", "path": "/var/lib/influxdb/data/_internal/monitor/704/000000031-000000002.tsm", "id": 0, "duration": "22.322ms"}
2023-08-25T15:35:55.227471Z info Opened shard {"log_id": "0jsLF6rl000", "service": "store", "trace_id": "0jsLF7N0000", "op_name": "tsdb_open", "index_version": "inmem", "path": "/var/lib/influxdb/data/_internal/monitor/701", "duration": "150.639ms"}
2023-08-25T15:35:55.271335Z info Opened file {"log_id": "0jsLF6rl000", "engine": "tsm1", "service": "filestore", "path": "/var/lib/influxdb/data/_internal/monitor/703/000000030-000000002.tsm", "id": 0, "duration": "34.039ms"}
2023-08-25T15:35:55.309655Z info Opened shard {"log_id": "0jsLF6rl000", "service": "store", "trace_id": "0jsLF7N0000", "op_name": "tsdb_open", "index_version": "inmem", "path": "/var/lib/influxdb/data/_internal/monitor/704", "duration": "122.173ms"}
2023-08-25T15:35:55.309818Z info Opened shard {"log_id": "0jsLF6rl000", "service": "store", "trace_id": "0jsLF7N0000", "op_name": "tsdb_open", "index_version": "inmem", "path": "/var/lib/influxdb/data/_internal/monitor/702", "duration": "121.385ms"}
2023-08-25T15:35:55.350661Z info Opened shard {"log_id": "0jsLF6rl000", "service": "store", "trace_id": "0jsLF7N0000", "op_name": "tsdb_open", "index_version": "inmem", "path": "/var/lib/influxdb/data/_internal/monitor/703", "duration": "122.992ms"}
2023-08-25T15:35:55.432453Z info Opened shard {"log_id": "0jsLF6rl000", "service": "store", "trace_id": "0jsLF7N0000", "op_name": "tsdb_open", "index_version": "inmem", "path": "/var/lib/influxdb/data/_internal/monitor/705", "duration": "647.361ms"}
2023-08-25T15:35:55.438706Z info Open store (end) {"log_id": "0jsLF6rl000", "service": "store", "trace_id": "0jsLF7N0000", "op_name": "tsdb_open", "op_event": "end", "op_elapsed": "4562.642ms"}
2023-08-25T15:35:55.438814Z info Opened service {"log_id": "0jsLF6rl000", "service": "subscriber"}
2023-08-25T15:35:55.438838Z info Starting monitor service {"log_id": "0jsLF6rl000", "service": "monitor"}
2023-08-25T15:35:55.438859Z info Registered diagnostics client {"log_id": "0jsLF6rl000", "service": "monitor", "name": "build"}
2023-08-25T15:35:55.439043Z info Registered diagnostics client {"log_id": "0jsLF6rl000", "service": "monitor", "name": "runtime"}
2023-08-25T15:35:55.439064Z info Registered diagnostics client {"log_id": "0jsLF6rl000", "service": "monitor", "name": "network"}
2023-08-25T15:35:55.439092Z info Registered diagnostics client {"log_id": "0jsLF6rl000", "service": "monitor", "name": "system"}
2023-08-25T15:35:55.439133Z info Starting precreation service {"log_id": "0jsLF6rl000", "service": "shard-precreation", "check_interval": "10m", "advance_period": "30m"}
2023-08-25T15:35:55.439153Z info Starting snapshot service {"log_id": "0jsLF6rl000", "service": "snapshot"}
2023-08-25T15:35:55.439174Z info Starting continuous query service {"log_id": "0jsLF6rl000", "service": "continuous_querier"}
2023-08-25T15:35:55.439191Z info Starting HTTP service {"log_id": "0jsLF6rl000", "service": "httpd", "authentication": true}
2023-08-25T15:35:55.439230Z info Storing statistics {"log_id": "0jsLF6rl000", "service": "monitor", "db_instance": "_internal", "db_rp": "monitor", "interval": "10s"}
2023-08-25T15:35:55.439256Z info opened HTTP access log {"log_id": "0jsLF6rl000", "service": "httpd", "path": "stderr"}
2023-08-25T15:35:55.439343Z info Auth is enabled but shared-secret is blank. BearerAuthentication is disabled. {"log_id": "0jsLF6rl000", "service": "httpd"}
2023-08-25T15:35:55.439539Z info Listening on HTTP {"log_id": "0jsLF6rl000", "service": "httpd", "addr": "[::]:8086", "https": false}
2023-08-25T15:35:55.439577Z info Starting retention policy enforcement service {"log_id": "0jsLF6rl000", "service": "retention", "check_interval": "30m"}
2023-08-25T15:35:55.439666Z info Listening for signals {"log_id": "0jsLF6rl000"}
2023-08-25T15:35:55.458442Z info Sending usage statistics to usage.influxdata.com {"log_id": "0jsLF6rl000"}
2023-08-25T15:36:03.264584Z info Executing query {"log_id": "0jsLF6rl000", "service": "query", "query": "SELECT value FROM OpenHAB3_DB.autogen.HausanschlussStromHZG_Power WHERE time >= now() - 1d AND time <= now()"}
[httpd] 192.168.1.211, 192.168.1.211,192.168.1.91 - grafana [25/Aug/2023:15:36:03 +0000] "GET /query?db=OpenHAB3_DB&epoch=ms&q=SELECT+%22value%22+FROM+%22HausanschlussStromHZG_Power%22+WHERE+time+%3E%3D+now%28%29+-+24h+and+time+%3C%3D+now%28%29 HTTP/1.1" 200 57 "-" "Grafana/8.3.3" 195b3d7c-435d-11ee-8002-0242c15cb777 116770
2023-08-25T15:36:03.276560Z info Executing query {"log_id": "0jsLF6rl000", "service": "query", "query": "SELECT mean(value) FROM OpenHAB3_DB.autogen.Solarpanel_Ertrag_Tag WHERE time >= now() - 1d AND time <= now() GROUP BY time(2m)"}
[httpd] 192.168.1.211, 192.168.1.211,192.168.1.91 - grafana [25/Aug/2023:15:36:03 +0000] "GET /query?db=OpenHAB3_DB&epoch=ms&q=SELECT+mean%28%22value%22%29+FROM+%22Solarpanel_Ertrag_Tag%22+WHERE+time+%3E%3D+now%28%29+-+24h+and+time+%3C%3D+now%28%29+GROUP+BY+time%282m%29+fill%28null%29 HTTP/1.1" 200 3120 "-" "Grafana/8.3.3" 195c1c61-435d-11ee-8004-0242c15cb777 127840
2023-08-25T15:36:03.290475Z info Executing query {"log_id": "0jsLF6rl000", "service": "query", "query": "SELECT value FROM OpenHAB3_DB.autogen.ReloadAllFromGateway WHERE time >= now() - 1d AND time <= now()"}
[httpd] 192.168.1.211, 192.168.1.211,192.168.1.91 - grafana [25/Aug/2023:15:36:03 +0000] "GET /query?db=OpenHAB3_DB&epoch=ms&q=SELECT+%22value%22+FROM+%22ReloadAllFromGateway%22+WHERE+time+%3E%3D+now%28%29+-+24h+and+time+%3C%3D+now%28%29 HTTP/1.1" 200 914 "-" "Grafana/8.3.3" 195b3790-435d-11ee-8001-0242c15cb777 143573
2023-08-25T15:36:03.307964Z info Executing query {"log_id": "0jsLF6rl000", "service": "query", "query": "SELECT last(value) FROM OpenHAB3_DB.autogen.BMW530dxDrive_Tachostand WHERE time >= 1690299366989ms AND time <= now() GROUP BY time(1h)"}
[httpd] 192.168.1.211, 192.168.1.211,192.168.1.91 - grafana [25/Aug/2023:15:36:03 +0000] "GET /query?db=OpenHAB3_DB&epoch=ms&q=SELECT+last%28%22value%22%29+FROM+%22BMW530dxDrive_Tachostand%22+WHERE+time+%3E%3D+1690299366989ms+and+time+%3C%3D+now%28%29+GROUP+BY+time%281h%29 HTTP/1.1" 200 2514 "-" "Grafana/8.3.3" 195b5876-435d-11ee-8003-0242c15cb777 162642
2023-08-25T15:36:03.371674Z info Executing query {"log_id": "0jsLF6rl000", "service": "query", "query": "SELECT last(value) FROM OpenHAB3_DB.autogen.Solarpanel_PowerConsumption WHERE time >= now() - 1d AND time <= now() GROUP BY time(10s)"}
[httpd] 192.168.1.211, 192.168.1.211,192.168.1.91 - grafana [25/Aug/2023:15:36:03 +0000] "GET /query?db=OpenHAB3_DB&epoch=ms&q=SELECT+last%28%22value%22%29+FROM+%22Solarpanel_PowerConsumption%22+WHERE+time+%3E%3D+now%28%29+-+24h+and+time+%3C%3D+now%28%29+GROUP+BY+time%2810s%29+fill%28null%29 HTTP/1.1" 200 25937 "-" "Grafana/8.3.3" 196b8857-435d-11ee-8005-0242c15cb777 174340
2023-08-25T15:36:03.442497Z info Executing query {"log_id": "0jsLF6rl000", "service": "query", "query": "SELECT last(value) FROM OpenHAB3_DB.autogen.shellyplugsQNAP192168155_Leistung WHERE time >= now() - 1d AND time <= now() GROUP BY time(2m)"}
2023-08-25T15:36:03.443638Z info Executing query {"log_id": "0jsLF6rl000", "service": "query", "query": "SELECT mean(value) FROM OpenHAB3_DB.autogen.shellyplugsQNAP192168155_Leistung WHERE time >= now() - 1d AND time <= now() GROUP BY time(2m)"}
2023-08-25T15:36:03.446717Z info Executing query {"log_id": "0jsLF6rl000", "service": "query", "query": "SELECT last(value) FROM OpenHAB3_DB.autogen.HausanschlussStromBezugEinspeisung_1_IEC_ENERGY_COUNTER WHERE time >= now() - 1d AND time <= now() GROUP BY time(2m)"}
2023-08-25T15:36:03.448519Z info Executing query {"log_id": "0jsLF6rl000", "service": "query", "query": "SELECT last(value) FROM OpenHAB3_DB.autogen.GATEWAYEXTRAS_StromZaehlerstand WHERE time >= now() - 1d AND time <= now() GROUP BY time(2m)"}
2023-08-25T15:36:03.449003Z info Executing query {"log_id": "0jsLF6rl000", "service": "query", "query": "SELECT mean(value) FROM OpenHAB3_DB.autogen.EnergieGefrierschrank_Power WHERE time >= now() - 1d AND time <= now() GROUP BY time(2m)"}
[httpd] 192.168.1.211, 192.168.1.211,192.168.1.91 - grafana [25/Aug/2023:15:36:03 +0000] "GET /query?db=OpenHAB3_DB&epoch=ms&q=SELECT+last%28%22value%22%29+FROM+%22HausanschlussStromBezugEinspeisung_1_IEC_ENERGY_COUNTER%22+WHERE+time+%3E%3D+now%28%29+-+24h+and+time+%3C%3D+now%28%29+GROUP+BY+time%282m%29+fill%28null%29%3BSELECT+last%28%22value%22%29+FROM+%22GATEWAYEXTRAS_StromZaehlerstand%22+WHERE+time+%3E%3D+now%28%29+-+24h+and+time+%3C%3D+now%28%29+GROUP+BY+time%282m%29+fill%28null%29 HTTP/1.1" 200 2087 "-" "Grafana/8.3.3" 1988888a-435d-11ee-8008-0242c15cb777 6505
[httpd] 192.168.1.211, 192.168.1.211,192.168.1.91 - grafana [25/Aug/2023:15:36:03 +0000] "GET /query?db=OpenHAB3_DB&epoch=ms&q=SELECT+mean%28%22value%22%29+FROM+%22shellyplugsQNAP192168155_Leistung%22+WHERE+time+%3E%3D+now%28%29+-+24h+and+time+%3C%3D+now%28%29+GROUP+BY+time%282m%29+fill%28null%29 HTTP/1.1" 200 3372 "-" "Grafana/8.3.3" 1988126e-435d-11ee-8007-0242c15cb777 10996
2023-08-25T15:36:03.459385Z info Executing query {"log_id": "0jsLF6rl000", "service": "query", "query": "SELECT mean(value) FROM OpenHAB3_DB.autogen.Solarpanel_PowerConsumption WHERE time >= now() - 1d AND time <= now() GROUP BY time(2m)"}
[httpd] 192.168.1.211, 192.168.1.211,192.168.1.91 - grafana [25/Aug/2023:15:36:03 +0000] "GET /query?db=OpenHAB3_DB&epoch=ms&q=SELECT+last%28%22value%22%29+FROM+%22shellyplugsQNAP192168155_Leistung%22+WHERE+time+%3E%3D+now%28%29+-+24h+and+time+%3C%3D+now%28%29+GROUP+BY+time%282m%29+fill%28null%29%3BSELECT+mean%28%22value%22%29+FROM+%22EnergieGefrierschrank_Power%22+WHERE+time+%3E%3D+now%28%29+-+24h+and+time+%3C%3D+now%28%29+GROUP+BY+time%282m%29+fill%28null%29%3BSELECT+mean%28%22value%22%29+FROM+%22Solarpanel_PowerConsumption%22+WHERE+time+%3E%3D+now%28%29+-+24h+and+time+%3C%3D+now%28%29+GROUP+BY+time%282m%29+fill%28null%29 HTTP/1.1" 200 5544 "-" "Grafana/8.3.3" 1987dd91-435d-11ee-8006-0242c15cb777 29232
2023-08-25T15:48:18.196836Z info Executing query {"log_id": "0jsLF6rl000", "service": "query", "query": "SELECT value::field, item::tag FROM OpenHAB3_DB.autogen.Solarpanel_PowerConsumption WHERE time >= '2023-08-24T22:00:00Z' ORDER BY time ASC"}
[httpd] 192.168.1.90 - admin [25/Aug/2023:15:48:18 +0000] "GET /query?db=OpenHAB3_DB&epoch=ms&q=SELECT+%22value%22%3A%3Afield%2C%22item%22%3A%3Atag+FROM+%22autogen%22.%22Solarpanel_PowerConsumption%22+WHERE+time+%3E%3D+%272023-08-24T22%3A00%3A00Z%27+ORDER+BY+time+ASC%3B HTTP/1.1" 200 1246 "-" "okhttp/3.14.9" cf688266-435e-11ee-8009-0242c15cb777 122614
2023-08-25T15:48:18.210914Z info Executing query {"log_id": "0jsLF6rl000", "service": "query", "query": "SELECT value::field, item::tag FROM OpenHAB3_DB.autogen.Solarpanel_PowerConsumption WHERE time <= '2023-08-24T22:00:00Z' ORDER BY time DESC LIMIT 1"}
[httpd] 192.168.1.90 - admin [25/Aug/2023:15:48:18 +0000] "GET /query?db=OpenHAB3_DB&epoch=ms&q=SELECT+%22value%22%3A%3Afield%2C%22item%22%3A%3Atag+FROM+%22autogen%22.%22Solarpanel_PowerConsumption%22+WHERE+time+%3C%3D+%272023-08-24T22%3A00%3A00Z%27+ORDER+BY+time+DESC+LIMIT+1%3B HTTP/1.1" 200 149 "-" "okhttp/3.14.9" cf7cac29-435e-11ee-800a-0242c15cb777 10434
2023-08-25T15:48:25.164326Z info Executing query {"log_id": "0jsLF6rl000", "service": "query", "query": "SELECT value::field, item::tag FROM OpenHAB3_DB.autogen.ReloadAllFromGateway WHERE time >= '2023-08-24T15:48:28.961Z' AND time <= '2023-08-25T15:48:28.960Z' ORDER BY time ASC"}
[httpd] 192.168.1.90 - admin [25/Aug/2023:15:48:25 +0000] "GET /query?db=OpenHAB3_DB&epoch=ms&q=SELECT+%22value%22%3A%3Afield%2C%22item%22%3A%3Atag+FROM+%22autogen%22.%22ReloadAllFromGateway%22+WHERE+time+%3E%3D+%272023-08-24T15%3A48%3A28.961Z%27+AND+time+%3C%3D+%272023-08-25T15%3A48%3A28.960Z%27+ORDER+BY+time+ASC%3B HTTP/1.1" 200 996 "-" "okhttp/3.14.9" d3a1a0a0-435e-11ee-800b-0242c15cb777 3195
2023-08-25T15:48:28.096095Z info Executing query {"log_id": "0jsLF6rl000", "service": "query", "query": "SELECT value::field, item::tag FROM OpenHAB3_DB.autogen.Solarpanel_PowerConsumption WHERE time >= '2023-08-24T22:00:00Z' ORDER BY time ASC"}
[httpd] 192.168.1.90 - admin [25/Aug/2023:15:48:28 +0000] "GET /query?db=OpenHAB3_DB&epoch=ms&q=SELECT+%22value%22%3A%3Afield%2C%22item%22%3A%3Atag+FROM+%22autogen%22.%22Solarpanel_PowerConsumption%22+WHERE+time+%3E%3D+%272023-08-24T22%3A00%3A00Z%27+ORDER+BY+time+ASC%3B HTTP/1.1" 200 1246 "-" "okhttp/3.14.9" d560f2aa-435e-11ee-800c-0242c15cb777 5695
2023-08-25T15:48:28.110120Z info Executing query {"log_id": "0jsLF6rl000", "service": "query", "query": "SELECT value::field, item::tag FROM OpenHAB3_DB.autogen.Solarpanel_PowerConsumption WHERE time <= '2023-08-24T22:00:00Z' ORDER BY time DESC LIMIT 1"}
[httpd] 192.168.1.90 - admin [25/Aug/2023:15:48:28 +0000] "GET /query?db=OpenHAB3_DB&epoch=ms&q=SELECT+%22value%22%3A%3Afield%2C%22item%22%3A%3Atag+FROM+%22autogen%22.%22Solarpanel_PowerConsumption%22+WHERE+time+%3C%3D+%272023-08-24T22%3A00%3A00Z%27+ORDER+BY+time+DESC+LIMIT+1%3B HTTP/1.1" 200 149 "-" "okhttp/3.14.9" d5632cd5-435e-11ee-800d-0242c15cb777 7234
2023-08-25T15:48:38.137267Z info Executing query {"log_id": "0jsLF6rl000", "service": "query", "query": "SELECT value::field, item::tag FROM OpenHAB3_DB.autogen.Solarpanel_PowerConsumption WHERE time >= '2023-08-24T22:00:00Z' ORDER BY time ASC"}
[httpd] 192.168.1.90 - admin [25/Aug/2023:15:48:38 +0000] "GET /query?db=OpenHAB3_DB&epoch=ms&q=SELECT+%22value%22%3A%3Afield%2C%22item%22%3A%3Atag+FROM+%22autogen%22.%22Solarpanel_PowerConsumption%22+WHERE+time+%3E%3D+%272023-08-24T22%3A00%3A00Z%27+ORDER+BY+time+ASC%3B HTTP/1.1" 200 1246 "-" "okhttp/3.14.9" db5d26d5-435e-11ee-800e-0242c15cb777 3901
2023-08-25T15:48:38.152384Z info Executing query {"log_id": "0jsLF6rl000", "service": "query", "query": "SELECT value::field, item::tag FROM OpenHAB3_DB.autogen.Solarpanel_PowerConsumption WHERE time <= '2023-08-24T22:00:00Z' ORDER BY time DESC LIMIT 1"}
[httpd] 192.168.1.90 - admin [25/Aug/2023:15:48:38 +0000] "GET /query?db=OpenHAB3_DB&epoch=ms&q=SELECT+%22value%22%3A%3Afield%2C%22item%22%3A%3Atag+FROM+%22autogen%22.%22Solarpanel_PowerConsumption%22+WHERE+time+%3C%3D+%272023-08-24T22%3A00%3A00Z%27+ORDER+BY+time+DESC+LIMIT+1%3B HTTP/1.1" 200 149 "-" "okhttp/3.14.9" db5f7608-435e-11ee-800f-0242c15cb777 8457
2023-08-25T15:48:48.163375Z info Executing query {"log_id": "0jsLF6rl000", "service": "query", "query": "SELECT value::field, item::tag FROM OpenHAB3_DB.autogen.Solarpanel_PowerConsumption WHERE time >= '2023-08-24T22:00:00Z' ORDER BY time ASC"}
[httpd] 192.168.1.90 - admin [25/Aug/2023:15:48:48 +0000] "GET /query?db=OpenHAB3_DB&epoch=ms&q=SELECT+%22value%22%3A%3Afield%2C%22item%22%3A%3Atag+FROM+%22autogen%22.%22Solarpanel_PowerConsumption%22+WHERE+time+%3E%3D+%272023-08-24T22%3A00%3A00Z%27+ORDER+BY+time+ASC%3B HTTP/1.1" 200 1246 "-" "okhttp/3.14.9" e15701fb-435e-11ee-8010-0242c15cb777 4118
2023-08-25T15:48:48.175967Z info Executing query {"log_id": "0jsLF6rl000", "service": "query", "query": "SELECT value::field, item::tag FROM OpenHAB3_DB.autogen.Solarpanel_PowerConsumption WHERE time <= '2023-08-24T22:00:00Z' ORDER BY time DESC LIMIT 1"}
[httpd] 192.168.1.90 - admin [25/Aug/2023:15:48:48 +0000] "GET /query?db=OpenHAB3_DB&epoch=ms&q=SELECT+%22value%22%3A%3Afield%2C%22item%22%3A%3Atag+FROM+%22autogen%22.%22Solarpanel_PowerConsumption%22+WHERE+time+%3C%3D+%272023-08-24T22%3A00%3A00Z%27+ORDER+BY+time+DESC+LIMIT+1%3B HTTP/1.1" 200 149 "-" "okhttp/3.14.9" e158f918-435e-11ee-8011-0242c15cb777 8224
2023-08-25T15:48:58.216884Z info Executing query {"log_id": "0jsLF6rl000", "service": "query", "query": "SELECT value::field, item::tag FROM OpenHAB3_DB.autogen.Solarpanel_PowerConsumption WHERE time >= '2023-08-24T22:00:00Z' ORDER BY time ASC"}
[httpd] 192.168.1.90 - admin [25/Aug/2023:15:48:58 +0000] "GET /query?db=OpenHAB3_DB&epoch=ms&q=SELECT+%22value%22%3A%3Afield%2C%22item%22%3A%3Atag+FROM+%22autogen%22.%22Solarpanel_PowerConsumption%22+WHERE+time+%3E%3D+%272023-08-24T22%3A00%3A00Z%27+ORDER+BY+time+ASC%3B HTTP/1.1" 200 1246 "-" "okhttp/3.14.9" e75518c1-435e-11ee-8012-0242c15cb777 3736
2023-08-25T15:48:58.229827Z info Executing query {"log_id": "0jsLF6rl000", "service": "query", "query": "SELECT value::field, item::tag FROM OpenHAB3_DB.autogen.Solarpanel_PowerConsumption WHERE time <= '2023-08-24T22:00:00Z' ORDER BY time DESC LIMIT 1"}
[httpd] 192.168.1.90 - admin [25/Aug/2023:15:48:58 +0000] "GET /query?db=OpenHAB3_DB&epoch=ms&q=SELECT+%22value%22%3A%3Afield%2C%22item%22%3A%3Atag+FROM+%22autogen%22.%22Solarpanel_PowerConsumption%22+WHERE+time+%3C%3D+%272023-08-24T22%3A00%3A00Z%27+ORDER+BY+time+DESC+LIMIT+1%3B HTTP/1.1" 200 149 "-" "okhttp/3.14.9" e757109b-435e-11ee-8013-0242c15cb777 8149
2023-08-25T15:49:08.240883Z info Executing query {"log_id": "0jsLF6rl000", "service": "query", "query": "SELECT value::field, item::tag FROM OpenHAB3_DB.autogen.Solarpanel_PowerConsumption WHERE time >= '2023-08-24T22:00:00Z' ORDER BY time ASC"}
[httpd] 192.168.1.90 - admin [25/Aug/2023:15:49:08 +0000] "GET /query?db=OpenHAB3_DB&epoch=ms&q=SELECT+%22value%22%3A%3Afield%2C%22item%22%3A%3Atag+FROM+%22autogen%22.%22Solarpanel_PowerConsumption%22+WHERE+time+%3E%3D+%272023-08-24T22%3A00%3A00Z%27+ORDER+BY+time+ASC%3B HTTP/1.1" 200 1246 "-" "okhttp/3.14.9" ed4e69b7-435e-11ee-8014-0242c15cb777 8672
2023-08-25T15:49:08.257457Z info Executing query {"log_id": "0jsLF6rl000", "service": "query", "query": "SELECT value::field, item::tag FROM OpenHAB3_DB.autogen.Solarpanel_PowerConsumption WHERE time <= '2023-08-24T22:00:00Z' ORDER BY time DESC LIMIT 1"}
[httpd] 192.168.1.90 - admin [25/Aug/2023:15:49:08 +0000] "GET /query?db=OpenHAB3_DB&epoch=ms&q=SELECT+%22value%22%3A%3Afield%2C%22item%22%3A%3Atag+FROM+%22autogen%22.%22Solarpanel_PowerConsumption%22+WHERE+time+%3C%3D+%272023-08-24T22%3A00%3A00Z%27+ORDER+BY+time+DESC+LIMIT+1%3B HTTP/1.1" 200 149 "-" "okhttp/3.14.9" ed512a54-435e-11ee-8015-0242c15cb777 8737
2023-08-25T15:49:18.256358Z info Executing query {"log_id": "0jsLF6rl000", "service": "query", "query": "SELECT value::field, item::tag FROM OpenHAB3_DB.autogen.Solarpanel_PowerConsumption WHERE time >= '2023-08-24T22:00:00Z' ORDER BY time ASC"}
[httpd] 192.168.1.90 - admin [25/Aug/2023:15:49:18 +0000] "GET /query?db=OpenHAB3_DB&epoch=ms&q=SELECT+%22value%22%3A%3Afield%2C%22item%22%3A%3Atag+FROM+%22autogen%22.%22Solarpanel_PowerConsumption%22+WHERE+time+%3E%3D+%272023-08-24T22%3A00%3A00Z%27+ORDER+BY+time+ASC%3B HTTP/1.1" 200 1246 "-" "okhttp/3.14.9" f346daaf-435e-11ee-8016-0242c15cb777 4067
2023-08-25T15:49:18.271397Z info Executing query {"log_id": "0jsLF6rl000", "service": "query", "query": "SELECT value::field, item::tag FROM OpenHAB3_DB.autogen.Solarpanel_PowerConsumption WHERE time <= '2023-08-24T22:00:00Z' ORDER BY time DESC LIMIT 1"}
[httpd] 192.168.1.90 - admin [25/Aug/2023:15:49:18 +0000] "GET /query?db=OpenHAB3_DB&epoch=ms&q=SELECT+%22value%22%3A%3Afield%2C%22item%22%3A%3Atag+FROM+%22autogen%22.%22Solarpanel_PowerConsumption%22+WHERE+time+%3C%3D+%272023-08-24T22%3A00%3A00Z%27+ORDER+BY+time+DESC+LIMIT+1%3B HTTP/1.1" 200 149 "-" "okhttp/3.14.9" f3492d08-435e-11ee-8017-0242c15cb777 8142
2023-08-25T15:49:28.281517Z info Executing query {"log_id": "0jsLF6rl000", "service": "query", "query": "SELECT value::field, item::tag FROM OpenHAB3_DB.autogen.Solarpanel_PowerConsumption WHERE time >= '2023-08-24T22:00:00Z' ORDER BY time ASC"}
[httpd] 192.168.1.90 - admin [25/Aug/2023:15:49:28 +0000] "GET /query?db=OpenHAB3_DB&epoch=ms&q=SELECT+%22value%22%3A%3Afield%2C%22item%22%3A%3Atag+FROM+%22autogen%22.%22Solarpanel_PowerConsumption%22+WHERE+time+%3E%3D+%272023-08-24T22%3A00%3A00Z%27+ORDER+BY+time+ASC%3B HTTP/1.1" 200 1246 "-" "okhttp/3.14.9" f94097a1-435e-11ee-8018-0242c15cb777 6392
2023-08-25T15:49:28.297381Z info Executing query {"log_id": "0jsLF6rl000", "service": "query", "query": "SELECT value::field, item::tag FROM OpenHAB3_DB.autogen.Solarpanel_PowerConsumption WHERE time <= '2023-08-24T22:00:00Z' ORDER BY time DESC LIMIT 1"}
[httpd] 192.168.1.90 - admin [25/Aug/2023:15:49:28 +0000] "GET /query?db=OpenHAB3_DB&epoch=ms&q=SELECT+%22value%22%3A%3Afield%2C%22item%22%3A%3Atag+FROM+%22autogen%22.%22Solarpanel_PowerConsumption%22+WHERE+time+%3C%3D+%272023-08-24T22%3A00%3A00Z%27+ORDER+BY+time+DESC+LIMIT+1%3B HTTP/1.1" 200 149 "-" "okhttp/3.14.9" f942fb9c-435e-11ee-8019-0242c15cb777 9734
2023-08-25T15:49:38.307343Z info Executing query {"log_id": "0jsLF6rl000", "service": "query", "query": "SELECT value::field, item::tag FROM OpenHAB3_DB.autogen.Solarpanel_PowerConsumption WHERE time >= '2023-08-24T22:00:00Z' ORDER BY time ASC"}
[httpd] 192.168.1.90 - admin [25/Aug/2023:15:49:38 +0000] "GET /query?db=OpenHAB3_DB&epoch=ms&q=SELECT+%22value%22%3A%3Afield%2C%22item%22%3A%3Atag+FROM+%22autogen%22.%22Solarpanel_PowerConsumption%22+WHERE+time+%3E%3D+%272023-08-24T22%3A00%3A00Z%27+ORDER+BY+time+ASC%3B HTTP/1.1" 200 1246 "-" "okhttp/3.14.9" ff3a66f4-435e-11ee-801a-0242c15cb777 4919
2023-08-25T15:49:38.324995Z info Executing query {"log_id": "0jsLF6rl000", "service": "query", "query": "SELECT value::field, item::tag FROM OpenHAB3_DB.autogen.Solarpanel_PowerConsumption WHERE time <= '2023-08-24T22:00:00Z' ORDER BY time DESC LIMIT 1"}
[httpd] 192.168.1.90 - admin [25/Aug/2023:15:49:38 +0000] "GET /query?db=OpenHAB3_DB&epoch=ms&q=SELECT+%22value%22%3A%3Afield%2C%22item%22%3A%3Atag+FROM+%22autogen%22.%22Solarpanel_PowerConsumption%22+WHERE+time+%3C%3D+%272023-08-24T22%3A00%3A00Z%27+ORDER+BY+time+DESC+LIMIT+1%3B HTTP/1.1" 200 149 "-" "okhttp/3.14.9" ff3d1b78-435e-11ee-801b-0242c15cb777 10282
2023-08-25T15:49:48.336030Z info Executing query {"log_id": "0jsLF6rl000", "service": "query", "query": "SELECT value::field, item::tag FROM OpenHAB3_DB.autogen.Solarpanel_PowerConsumption WHERE time >= '2023-08-24T22:00:00Z' ORDER BY time ASC"}
[httpd] 192.168.1.90 - admin [25/Aug/2023:15:49:48 +0000] "GET /query?db=OpenHAB3_DB&epoch=ms&q=SELECT+%22value%22%3A%3Afield%2C%22item%22%3A%3Atag+FROM+%22autogen%22.%22Solarpanel_PowerConsumption%22+WHERE+time+%3E%3D+%272023-08-24T22%3A00%3A00Z%27+ORDER+BY+time+ASC%3B HTTP/1.1" 200 1246 "-" "okhttp/3.14.9" 0534a383-435f-11ee-801c-0242c15cb777 6179
2023-08-25T15:49:48.351483Z info Executing query {"log_id": "0jsLF6rl000", "service": "query", "query": "SELECT value::field, item::tag FROM OpenHAB3_DB.autogen.Solarpanel_PowerConsumption WHERE time <= '2023-08-24T22:00:00Z' ORDER BY time DESC LIMIT 1"}
[httpd] 192.168.1.90 - admin [25/Aug/2023:15:49:48 +0000] "GET /query?db=OpenHAB3_DB&epoch=ms&q=SELECT+%22value%22%3A%3Afield%2C%22item%22%3A%3Atag+FROM+%22autogen%22.%22Solarpanel_PowerConsumption%22+WHERE+time+%3C%3D+%272023-08-24T22%3A00%3A00Z%27+ORDER+BY+time+DESC+LIMIT+1%3B HTTP/1.1" 200 149 "-" "okhttp/3.14.9" 053705e0-435f-11ee-801d-0242c15cb777 10095