openhabforum.de


https://openhabforum.de/

Influxdb 1.8.2 liefert nur sporadisch Werte

https://openhabforum.de/viewtopic.php?t=8408

Seite 1 von 1

Influxdb 1.8.2 liefert nur sporadisch Werte

Verfasst: 25. Aug 2023 17:51
von zinnik
Hallo ich habe ein Problem mit meiner Influx bemerkt habe ich das jetzt mit dem umstieg auf openhab 4

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
logs aus der influx

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
und noch ein paar Sreenshots
Screenshot (365).png
Screenshot (366).png
Screenshot (367).png
Alle Zeiten sind UTC+02:00
Seite 1 von 1

Powered by phpBB® Forum Software © phpBB Limited

Deutsche Übersetzung durch phpBB.de