Influx DB geht nicht

Einrichtung der openHAB Umgebung und allgemeine Konfigurationsthemen.

Moderatoren: seppy, udo1toni

AndyRPi
Beiträge: 68
Registriert: 3. Jan 2021 11:06
Answers: 0
Wohnort: Wörlitz / Obertshausen

Re: Influx DB geht nicht

Beitrag von AndyRPi »

Lux73 hat geschrieben: 27. Dez 2022 17:48

Code: Alles auswählen

sudo service influxd restart
du bist als eingeschränkter Benutzer unterwegs (ich vergesse das immer weil ich als Benutzer 'root' auf meinen Systemen unterwegs bin)

das 'sudo' davor führt die Befehle als root User durch
Leider nein:
openhabian@openhabian:~ $ sudo service influxd restart
[sudo] password for openhabian:
Job for influxdb.service failed because a timeout was exceeded.
See "systemctl status influxdb.service" and "journalctl -xe" for details.
Openhab 4.0.0 RPi SSD
Homematic CCU3
Phoscon
Shelly
FRITZ!Box
Alexa

Lux73
Beiträge: 71
Registriert: 26. Dez 2019 12:32
Answers: 0
Wohnort: Bielefeld

Re: Influx DB geht nicht

Beitrag von Lux73 »

hast du denn auch bei der Password Abfrage dein aktuelles PW eingetragen und bestätigt?
APU2c4|Debian12.11|OpenHAB4.3.5@Zulu21|mosquitto|hostapd|dnsmasq|zigbee2mqtt / Huawei MediaPad T5|FullyKioskBrowser
Zigbee:CC2652RB|1xCC2530.ROUTER|15xHue|4xIlluminize 5110.40|Danfoss:4xAlly+4xRoomSensor
Aqara:5xMCCGQ11LM/6xWSDCGQ11LM/6xGZCGQ01LM/4xRTCGQ11LM/2xRTCGQ13LM/2xRTCGQ14LM/1xDJT11LM/1xRTCZCGQ11LM/2x WXKG02LM
TuYa:2xTS011F/3xTS0601/1xTS0001|MOES:1xUFO-R11|HEIMAN:1xHS2WD-E
MQTT:Tasmota13.4.0|6xDelock 11826|3xShelly1|3xBlitzwolf SHP8|1xGosund SP112

AndyRPi
Beiträge: 68
Registriert: 3. Jan 2021 11:06
Answers: 0
Wohnort: Wörlitz / Obertshausen

Re: Influx DB geht nicht

Beitrag von AndyRPi »

Lux73 hat geschrieben: 27. Dez 2022 17:52 hast du denn auch bei der Password Abfrage dein aktuelles PW eingetragen und bestätigt?
ja
Openhab 4.0.0 RPi SSD
Homematic CCU3
Phoscon
Shelly
FRITZ!Box
Alexa

AndyRPi
Beiträge: 68
Registriert: 3. Jan 2021 11:06
Answers: 0
Wohnort: Wörlitz / Obertshausen

Re: Influx DB geht nicht

Beitrag von AndyRPi »

journalctl -xe
Dec 27 17:53:48 openhabian influxd-systemd-start.sh[133004]: InfluxDB API unavailable after 1 attempts...
Dec 27 17:53:48 openhabian influxd-systemd-start.sh[133005]: ts=2022-12-27T16:53:48.508561Z lvl=info msg="Using data dir" log_id=0f17vAyl000 service=store path=/var/lib/influxdb/data
Dec 27 17:53:48 openhabian influxd-systemd-start.sh[133005]: ts=2022-12-27T16:53:48.508650Z lvl=info msg="Compaction settings" log_id=0f17vAyl000 service=store max_concurrent_compactions=2 throughput_bytes_per_second=50331648 throughput>
Dec 27 17:53:48 openhabian influxd-systemd-start.sh[133005]: ts=2022-12-27T16:53:48.508692Z lvl=info msg="Open store (start)" log_id=0f17vAyl000 service=store trace_id=0f17vBN0000 op_name=tsdb_open op_event=start
Dec 27 17:53:48 openhabian influxd-systemd-start.sh[133005]: ts=2022-12-27T16:53:48.509154Z lvl=error msg="Unable to open series file" log_id=0f17vAyl000 path=/var/lib/influxdb/data/openhab/_series partition=0 error="invalid series segm>
Dec 27 17:53:48 openhabian influxd-systemd-start.sh[133005]: ts=2022-12-27T16:53:48.509221Z lvl=info msg="Open store (end)" log_id=0f17vAyl000 service=store trace_id=0f17vBN0000 op_name=tsdb_open op_event=end op_elapsed=0.531ms
Dec 27 17:53:48 openhabian influxd-systemd-start.sh[133005]: run: open server: open tsdb store: invalid series segment
Dec 27 17:53:49 openhabian influxd-systemd-start.sh[133004]: InfluxDB API unavailable after 2 attempts...
Dec 27 17:53:50 openhabian influxd-systemd-start.sh[133004]: InfluxDB API unavailable after 3 attempts...
Dec 27 17:53:51 openhabian influxd-systemd-start.sh[133004]: InfluxDB API unavailable after 4 attempts...
Dec 27 17:53:52 openhabian influxd-systemd-start.sh[133004]: InfluxDB API unavailable after 5 attempts...
Dec 27 17:53:53 openhabian influxd-systemd-start.sh[133004]: InfluxDB API unavailable after 6 attempts...
Dec 27 17:53:54 openhabian influxd-systemd-start.sh[133004]: InfluxDB API unavailable after 7 attempts...
Dec 27 17:53:55 openhabian influxd-systemd-start.sh[133004]: InfluxDB API unavailable after 8 attempts...
Dec 27 17:53:56 openhabian influxd-systemd-start.sh[133004]: InfluxDB API unavailable after 9 attempts...
Dec 27 17:53:57 openhabian influxd-systemd-start.sh[133004]: InfluxDB API unavailable after 10 attempts...
Dec 27 17:53:58 openhabian influxd-systemd-start.sh[133004]: InfluxDB API unavailable after 11 attempts...
Dec 27 17:53:59 openhabian influxd-systemd-start.sh[133004]: InfluxDB API unavailable after 12 attempts...
Dec 27 17:54:00 openhabian influxd-systemd-start.sh[133004]: InfluxDB API unavailable after 13 attempts...
Dec 27 17:54:01 openhabian influxd-systemd-start.sh[133004]: InfluxDB API unavailable after 14 attempts...
Dec 27 17:54:02 openhabian influxd-systemd-start.sh[133004]: InfluxDB API unavailable after 15 attempts...
Dec 27 17:54:03 openhabian influxd-systemd-start.sh[133004]: InfluxDB API unavailable after 16 attempts...
Dec 27 17:54:04 openhabian influxd-systemd-start.sh[133004]: InfluxDB API unavailable after 17 attempts...
Dec 27 17:54:06 openhabian influxd-systemd-start.sh[133004]: InfluxDB API unavailable after 18 attempts...
Dec 27 17:54:07 openhabian influxd-systemd-start.sh[133004]: InfluxDB API unavailable after 19 attempts...
Dec 27 17:54:08 openhabian influxd-systemd-start.sh[133004]: InfluxDB API unavailable after 20 attempts...
Dec 27 17:54:09 openhabian influxd-systemd-start.sh[133004]: InfluxDB API unavailable after 21 attempts...
Dec 27 17:54:10 openhabian influxd-systemd-start.sh[133004]: InfluxDB API unavailable after 22 attempts...
Dec 27 17:54:11 openhabian influxd-systemd-start.sh[133004]: InfluxDB API unavailable after 23 attempts...
Dec 27 17:54:12 openhabian influxd-systemd-start.sh[133004]: InfluxDB API unavailable after 24 attempts...
Dec 27 17:54:13 openhabian influxd-systemd-start.sh[133004]: InfluxDB API unavailable after 25 attempts...
Dec 27 17:54:14 openhabian influxd-systemd-start.sh[133004]: InfluxDB API unavailable after 26 attempts...
Dec 27 17:54:15 openhabian influxd-systemd-start.sh[133004]: InfluxDB API unavailable after 27 attempts...
Dec 27 17:54:16 openhabian influxd-systemd-start.sh[133004]: InfluxDB API unavailable after 28 attempts...
Dec 27 17:54:17 openhabian influxd-systemd-start.sh[133004]: InfluxDB API unavailable after 29 attempts...
Dec 27 17:54:18 openhabian influxd-systemd-start.sh[133004]: InfluxDB API unavailable after 30 attempts...
Dec 27 17:54:19 openhabian influxd-systemd-start.sh[133004]: InfluxDB API unavailable after 31 attempts...
Dec 27 17:54:20 openhabian influxd-systemd-start.sh[133004]: InfluxDB API unavailable after 32 attempts...
Dec 27 17:54:21 openhabian influxd-systemd-start.sh[133004]: InfluxDB API unavailable after 33 attempts...
Dec 27 17:54:22 openhabian influxd-systemd-start.sh[133004]: InfluxDB API unavailable after 34 attempts...
Dec 27 17:54:23 openhabian influxd-systemd-start.sh[133004]: InfluxDB API unavailable after 35 attempts...
Dec 27 17:54:24 openhabian influxd-systemd-start.sh[133004]: InfluxDB API unavailable after 36 attempts...
Dec 27 17:54:25 openhabian influxd-systemd-start.sh[133004]: InfluxDB API unavailable after 37 attempts...
Dec 27 17:54:26 openhabian influxd-systemd-start.sh[133004]: InfluxDB API unavailable after 38 attempts...
Dec 27 17:54:27 openhabian influxd-systemd-start.sh[133004]: InfluxDB API unavailable after 39 attempts...
Dec 27 17:54:28 openhabian influxd-systemd-start.sh[133004]: InfluxDB API unavailable after 40 attempts...
Dec 27 17:54:29 openhabian influxd-systemd-start.sh[133004]: InfluxDB API unavailable after 41 attempts...
Dec 27 17:54:30 openhabian influxd-systemd-start.sh[133004]: InfluxDB API unavailable after 42 attempts...
Dec 27 17:54:31 openhabian influxd-systemd-start.sh[133004]: InfluxDB API unavailable after 43 attempts...
Dec 27 17:54:32 openhabian influxd-systemd-start.sh[133004]: InfluxDB API unavailable after 44 attempts...
Dec 27 17:54:33 openhabian influxd-systemd-start.sh[133004]: InfluxDB API unavailable after 45 attempts...
Dec 27 17:54:34 openhabian influxd-systemd-start.sh[133004]: InfluxDB API unavailable after 46 attempts...
Dec 27 17:54:35 openhabian influxd-systemd-start.sh[133004]: InfluxDB API unavailable after 47 attempts...
Dec 27 17:54:37 openhabian influxd-systemd-start.sh[133004]: InfluxDB API unavailable after 48 attempts...
Dec 27 17:54:38 openhabian influxd-systemd-start.sh[133004]: InfluxDB API unavailable after 49 attempts...
Dec 27 17:54:39 openhabian influxd-systemd-start.sh[133004]: InfluxDB API unavailable after 50 attempts...
Dec 27 17:54:40 openhabian influxd-systemd-start.sh[133004]: InfluxDB API unavailable after 51 attempts...
Dec 27 17:54:41 openhabian influxd-systemd-start.sh[133004]: InfluxDB API unavailable after 52 attempts...
Dec 27 17:54:42 openhabian influxd-systemd-start.sh[133004]: InfluxDB API unavailable after 53 attempts...
Dec 27 17:54:43 openhabian influxd-systemd-start.sh[133004]: InfluxDB API unavailable after 54 attempts...
Dec 27 17:54:44 openhabian influxd-systemd-start.sh[133004]: InfluxDB API unavailable after 55 attempts...
Dec 27 17:54:45 openhabian influxd-systemd-start.sh[133004]: InfluxDB API unavailable after 56 attempts...
Openhab 4.0.0 RPi SSD
Homematic CCU3
Phoscon
Shelly
FRITZ!Box
Alexa

Lux73
Beiträge: 71
Registriert: 26. Dez 2019 12:32
Answers: 0
Wohnort: Bielefeld

Re: Influx DB geht nicht

Beitrag von Lux73 »

dann würde ich einen Neustart empfehlen falls dies jetzt möglich ist

ansonsten mit

Code: Alles auswählen

ps aux
den evtl hängenden InfluDB prozess ermitteln und entsprechend killen

geht denn

Code: Alles auswählen

sudo bash
d.h. du bist dann als root eingeloggt?
APU2c4|Debian12.11|OpenHAB4.3.5@Zulu21|mosquitto|hostapd|dnsmasq|zigbee2mqtt / Huawei MediaPad T5|FullyKioskBrowser
Zigbee:CC2652RB|1xCC2530.ROUTER|15xHue|4xIlluminize 5110.40|Danfoss:4xAlly+4xRoomSensor
Aqara:5xMCCGQ11LM/6xWSDCGQ11LM/6xGZCGQ01LM/4xRTCGQ11LM/2xRTCGQ13LM/2xRTCGQ14LM/1xDJT11LM/1xRTCZCGQ11LM/2x WXKG02LM
TuYa:2xTS011F/3xTS0601/1xTS0001|MOES:1xUFO-R11|HEIMAN:1xHS2WD-E
MQTT:Tasmota13.4.0|6xDelock 11826|3xShelly1|3xBlitzwolf SHP8|1xGosund SP112

AndyRPi
Beiträge: 68
Registriert: 3. Jan 2021 11:06
Answers: 0
Wohnort: Wörlitz / Obertshausen

Re: Influx DB geht nicht

Beitrag von AndyRPi »

Ich hab jetzt neu gestartet. Es geht noch immer nicht. Ich hab keine Ahnung wo ich noch nachsehen kann…
Ich bekomme mit Grafana keine Verbindung

Die Fehlermeldungen bleiben die selben


Gesendet von iPad mit Tapatalk
Openhab 4.0.0 RPi SSD
Homematic CCU3
Phoscon
Shelly
FRITZ!Box
Alexa

Lux73
Beiträge: 71
Registriert: 26. Dez 2019 12:32
Answers: 0
Wohnort: Bielefeld

Re: Influx DB geht nicht

Beitrag von Lux73 »

Code: Alles auswählen

service influxd status
läuft der dienst jetzt ordentlich?
APU2c4|Debian12.11|OpenHAB4.3.5@Zulu21|mosquitto|hostapd|dnsmasq|zigbee2mqtt / Huawei MediaPad T5|FullyKioskBrowser
Zigbee:CC2652RB|1xCC2530.ROUTER|15xHue|4xIlluminize 5110.40|Danfoss:4xAlly+4xRoomSensor
Aqara:5xMCCGQ11LM/6xWSDCGQ11LM/6xGZCGQ01LM/4xRTCGQ11LM/2xRTCGQ13LM/2xRTCGQ14LM/1xDJT11LM/1xRTCZCGQ11LM/2x WXKG02LM
TuYa:2xTS011F/3xTS0601/1xTS0001|MOES:1xUFO-R11|HEIMAN:1xHS2WD-E
MQTT:Tasmota13.4.0|6xDelock 11826|3xShelly1|3xBlitzwolf SHP8|1xGosund SP112

AndyRPi
Beiträge: 68
Registriert: 3. Jan 2021 11:06
Answers: 0
Wohnort: Wörlitz / Obertshausen

Re: Influx DB geht nicht

Beitrag von AndyRPi »

Nein


Gesendet von iPad mit Tapatalk
Openhab 4.0.0 RPi SSD
Homematic CCU3
Phoscon
Shelly
FRITZ!Box
Alexa

Lux73
Beiträge: 71
Registriert: 26. Dez 2019 12:32
Answers: 0
Wohnort: Bielefeld

Re: Influx DB geht nicht

Beitrag von Lux73 »

ja dann ist das erstmal dein Hauptproblem!

Grafana kommt er viel später

InfluxDB runterwerfen und nochmal neu installieren
APU2c4|Debian12.11|OpenHAB4.3.5@Zulu21|mosquitto|hostapd|dnsmasq|zigbee2mqtt / Huawei MediaPad T5|FullyKioskBrowser
Zigbee:CC2652RB|1xCC2530.ROUTER|15xHue|4xIlluminize 5110.40|Danfoss:4xAlly+4xRoomSensor
Aqara:5xMCCGQ11LM/6xWSDCGQ11LM/6xGZCGQ01LM/4xRTCGQ11LM/2xRTCGQ13LM/2xRTCGQ14LM/1xDJT11LM/1xRTCZCGQ11LM/2x WXKG02LM
TuYa:2xTS011F/3xTS0601/1xTS0001|MOES:1xUFO-R11|HEIMAN:1xHS2WD-E
MQTT:Tasmota13.4.0|6xDelock 11826|3xShelly1|3xBlitzwolf SHP8|1xGosund SP112

AndyRPi
Beiträge: 68
Registriert: 3. Jan 2021 11:06
Answers: 0
Wohnort: Wörlitz / Obertshausen

Re: Influx DB geht nicht

Beitrag von AndyRPi »

Lux73 hat geschrieben: 27. Dez 2022 18:15 ja dann ist das erstmal dein Hauptproblem!

Grafana kommt er viel später

InfluxDB runterwerfen und nochmal neu installieren
openhabian@openhabian:~ $ service influxd status
● influxdb.service - InfluxDB is an open-source, distributed, time series database
Loaded: loaded (/lib/systemd/system/influxdb.service; enabled; vendor preset: enabled)
Active: activating (start) since Tue 2022-12-27 18:17:29 CET; 33s ago
Docs: https://docs.influxdata.com/influxdb/
Cntrl PID: 9196 (influxd-systemd)
Tasks: 2 (limit: 4531)
CPU: 1.145s
CGroup: /system.slice/influxdb.service
├─9196 /bin/bash -e /usr/lib/influxdb/scripts/influxd-systemd-start.sh
└─9899 sleep 1

Dec 27 18:17:52 openhabian influxd-systemd-start.sh[9196]: InfluxDB API unavailable after 24 attempts...
Dec 27 18:17:53 openhabian influxd-systemd-start.sh[9196]: InfluxDB API unavailable after 25 attempts...
Dec 27 18:17:54 openhabian influxd-systemd-start.sh[9196]: InfluxDB API unavailable after 26 attempts...
Dec 27 18:17:55 openhabian influxd-systemd-start.sh[9196]: InfluxDB API unavailable after 27 attempts...
Dec 27 18:17:56 openhabian influxd-systemd-start.sh[9196]: InfluxDB API unavailable after 28 attempts...
Dec 27 18:17:57 openhabian influxd-systemd-start.sh[9196]: InfluxDB API unavailable after 29 attempts...
Dec 27 18:17:59 openhabian influxd-systemd-start.sh[9196]: InfluxDB API unavailable after 30 attempts...
Dec 27 18:18:00 openhabian influxd-systemd-start.sh[9196]: InfluxDB API unavailable after 31 attempts...
Dec 27 18:18:01 openhabian influxd-systemd-start.sh[9196]: InfluxDB API unavailable after 32 attempts...
Dec 27 18:18:02 openhabian influxd-systemd-start.sh[9196]: InfluxDB API unavailable after 33 attempts...



wie erfe ich influx ruter?
Openhab 4.0.0 RPi SSD
Homematic CCU3
Phoscon
Shelly
FRITZ!Box
Alexa

Antworten