InfluxDB hat keine Verbindung mehr

[PerfectAnswer]

Moin zusammen,

ich bin relativ ratlos wegen der InfluxDB.

Seit Monaten schnurrt Sie vor sich hin und plötzlich bleibt der Adapter regelmäßig stehen.

Im Log steht:````
influxdb.0 2017-11-06 17:02:06.375 warn Error on writeSeries: Error: connect ECONNREFUSED 127.0.0.1:8086

Ich habe in der Config schon mit der Speicherzeit und der der Größe der Pakete gespielt, aber die InfluxDB schweigt, bzw. zeigt bei Verbindung das gelbe Lämpchen.

Hat jemand eine Idee wo ich ansetzen kann?

Besten Gruß

Bernd

[Homoran]

Läuft sie trotzdem?

Dann kann es an einem nodejs/linux update gelegen haben.

Gruß

Rainer

[apollon77]

Kannst du per Shell Befehl „influx“ verbinden? Was sagt das InfluxDB logfile wenn du es neu startest?

[PerfectAnswer]

Wenn ich in die Konsole gehe und dort influxd aufrufe, dann läuft der ganze Krempel durch und auch die Lampe springt von Gelb auf grün um.

Wenn ich die Konsole schließe, dann springt die Lampe wieder auf Gelb um. Reproduzierbar also.

Zusätzlich war der IOBroker heute den ganzen Tag nicht erreichbar. Da ich nicht vor Ort bin konnte ich kein hartes Reset durchführen und habe es durch abwarten gelöst.

Besten Gruß

Bernd

[apollon77]

Dann läuft der Prozess nicht

Je nach Betriebssystem musst Du schauen das influxd dauerhaft läuft …

sudo /etc/init.d/influxdb start oder

sudo systemctl start influxdb

oder so

[PerfectAnswer]

systemctl sagt:

influxdb.service loaded active running InfluxDB is an open-source,

iobroker.service loaded active running LSB: starts ioBroker

grafana-server.service loaded active running Grafana instance

funktionierte aber nicht.

Jetzt nach einem Neustart läuft es wieder. Strange….

Ich werde das beobachten.

Danke für die Unterstützung!

[PerfectAnswer]

So,

heute das gleiche wie gestern, influxdb hat sich wieder abgeschossen und ist offline.

Host not available, move all points back in the buffer

in der systemctl steht die influxdb auch nicht mehr drin. Was mache ich denn falsch?

Besten Gruß

Bernd

P.S. Jetzt ist wieder der komplette raspi eingefroren… Hatte ich die letzten Tag auch schon, dass der raspi in freeze geht und dann ein paar Stunden später wieder in idle switcht.

Welche Log Dateien kann ich mir anschauen um den Problem auf die Spur zu kommen und vor allem wo liegen die?? :lol:

[apollon77]

Was steht denn in den System-Logs (also nicht ioBroker logs sondern die vom System bzw InfluxDB) Es muss ja einen grund geben das Sie weg ist!

/var/log/syslog als Beispiel oder wo auch immer dein influxdb logfile liegt.

Andere Frage: Wie gross ist denn die DB und was ist es für ein System wo die InfluxDB drauf läuft? Aus 32bit-Systemen ist bei 2GB Datenbankgröße recht hart schluss!!

[PerfectAnswer]

So,

für die InfluxDB war logging nicht aktiviert, dass habe ich jetzt eingeschaltet.

Im Syslog sieht es nach dem Start so aus:

! ```
Nov 9 15:04:39 ioBroker-RasPi systemd[1]: Starting InfluxDB is an open-source, distributed, time series database... Nov 9 15:04:39 ioBroker-RasPi systemd[1]: Started InfluxDB is an open-source, distributed, time series database. Nov 9 15:04:39 ioBroker-RasPi influxd[9540]: 8888888 .d888 888 8888888b. 888888b. Nov 9 15:04:39 ioBroker-RasPi influxd[9540]: 888 d88P" 888 888 "Y88b 888 "88b Nov 9 15:04:39 ioBroker-RasPi influxd[9540]: 888 888 888 888 888 888 .88P Nov 9 15:04:39 ioBroker-RasPi influxd[9540]: 888 88888b. 888888 888 888 888 888 888 888 888 8888888K. Nov 9 15:04:39 ioBroker-RasPi influxd[9540]: 888 888 "88b 888 888 888 888 Y8bd8P' 888 888 888 "Y88b Nov 9 15:04:39 ioBroker-RasPi influxd[9540]: 888 888 888 888 888 888 888 X88K 888 888 888 888 Nov 9 15:04:39 ioBroker-RasPi influxd[9540]: 888 888 888 888 888 Y88b 888 .d8""8b. 888 .d88P 888 d88P Nov 9 15:04:39 ioBroker-RasPi influxd[9540]: 8888888 888 888 888 888 "Y88888 888 888 8888888P" 8888888P" Nov 9 15:04:39 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:39Z InfluxDB starting, version 1.3.7, branch 1.3, commit 2d474a3089bcfce6b472779be9470a1f0ef3d5e4 Nov 9 15:04:39 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:39Z Go version go1.8.4, GOMAXPROCS set to 4 Nov 9 15:04:39 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:39Z Using configuration at: /etc/influxdb/influxdb.conf Nov 9 15:04:39 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:39Z Using data dir: /var/lib/influxdb/data service=store Nov 9 15:04:39 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:39Z /var/lib/influxdb/data/NOAA_water_database/autogen/2/000000001-000000001.tsm (#0) opened in 6.400296ms engine=tsm1 service=filestore Nov 9 15:04:39 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:39Z reading file /var/lib/influxdb/wal/NOAA_water_database/autogen/2/_00059.wal, size 0 engine=tsm1 service=cacheloader Nov 9 15:04:39 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:39Z /var/lib/influxdb/data/NOAA_water_database/autogen/2 opened in 36.839332ms service=store Nov 9 15:04:39 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:39Z /var/lib/influxdb/data/NOAA_water_database/autogen/4/000000001-000000001.tsm (#0) opened in 8.435708ms engine=tsm1 service=filestore Nov 9 15:04:39 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:39Z reading file /var/lib/influxdb/wal/NOAA_water_database/autogen/4/_00059.wal, size 0 engine=tsm1 service=cacheloader Nov 9 15:04:39 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:39Z /var/lib/influxdb/data/NOAA_water_database/autogen/4 opened in 38.859327ms service=store Nov 9 15:04:39 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:39Z /var/lib/influxdb/data/NOAA_water_database/autogen/5/000000001-000000001.tsm (#0) opened in 10.103359ms engine=tsm1 service=filestore Nov 9 15:04:39 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:39Z reading file /var/lib/influxdb/wal/NOAA_water_database/autogen/5/_00059.wal, size 0 engine=tsm1 service=cacheloader Nov 9 15:04:39 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:39Z /var/lib/influxdb/data/NOAA_water_database/autogen/5 opened in 40.712603ms service=store Nov 9 15:04:39 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:39Z /var/lib/influxdb/data/NOAA_water_database/autogen/3/000000001-000000001.tsm (#0) opened in 11.018669ms engine=tsm1 service=filestore Nov 9 15:04:39 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:39Z reading file /var/lib/influxdb/wal/NOAA_water_database/autogen/3/_00059.wal, size 0 engine=tsm1 service=cacheloader Nov 9 15:04:39 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:39Z /var/lib/influxdb/data/NOAA_water_database/autogen/3 opened in 16.539072ms service=store Nov 9 15:04:39 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:39Z /var/lib/influxdb/data/iobroker/global/98/000000030-000000004.tsm (#0) opened in 7.9905ms engine=tsm1 service=filestore Nov 9 15:04:39 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:39Z reading file /var/lib/influxdb/wal/iobroker/global/98/_00080.wal, size 0 engine=tsm1 service=cacheloader Nov 9 15:04:39 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:39Z /var/lib/influxdb/data/iobroker/global/98 opened in 17.427247ms service=store Nov 9 15:04:39 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:39Z /var/lib/influxdb/data/NOAA_water_database/autogen/6/000000001-000000001.tsm (#0) opened in 10.198151ms engine=tsm1 service=filestore Nov 9 15:04:39 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:39Z reading file /var/lib/influxdb/wal/NOAA_water_database/autogen/6/_00059.wal, size 0 engine=tsm1 service=cacheloader Nov 9 15:04:39 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:39Z /var/lib/influxdb/data/NOAA_water_database/autogen/6 opened in 17.924954ms service=store Nov 9 15:04:39 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:39Z /var/lib/influxdb/data/_internal/monitor/228/000000009-000000002.tsm (#0) opened in 89.309352ms engine=tsm1 service=filestore Nov 9 15:04:39 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:39Z reading file /var/lib/influxdb/wal/_internal/monitor/228/_00044.wal, size 0 engine=tsm1 service=cacheloader Nov 9 15:04:39 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:39Z /var/lib/influxdb/data/_internal/monitor/229/000000009-000000002.tsm (#0) opened in 99.721305ms engine=tsm1 service=filestore Nov 9 15:04:39 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:39Z reading file /var/lib/influxdb/wal/_internal/monitor/229/_00044.wal, size 0 engine=tsm1 service=cacheloader Nov 9 15:04:39 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:39Z /var/lib/influxdb/data/_internal/monitor/228 opened in 148.081128ms service=store Nov 9 15:04:39 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:39Z /var/lib/influxdb/data/_internal/monitor/229 opened in 152.424397ms service=store Nov 9 15:04:39 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:39Z /var/lib/influxdb/data/_internal/monitor/230/000000009-000000002.tsm (#0) opened in 141.075ms engine=tsm1 service=filestore Nov 9 15:04:39 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:39Z /var/lib/influxdb/data/_internal/monitor/231/000000009-000000002.tsm (#0) opened in 136.655115ms engine=tsm1 service=filestore Nov 9 15:04:39 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:39Z reading file /var/lib/influxdb/wal/_internal/monitor/231/_00044.wal, size 0 engine=tsm1 service=cacheloader Nov 9 15:04:39 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:39Z reading file /var/lib/influxdb/wal/_internal/monitor/230/_00044.wal, size 0 engine=tsm1 service=cacheloader Nov 9 15:04:39 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:39Z /var/lib/influxdb/data/_internal/monitor/231 opened in 203.692599ms service=store Nov 9 15:04:39 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:39Z /var/lib/influxdb/data/_internal/monitor/230 opened in 207.859411ms service=store Nov 9 15:04:39 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:39Z /var/lib/influxdb/data/_internal/monitor/233/000000007-000000003.tsm (#0) opened in 71.776898ms engine=tsm1 service=filestore Nov 9 15:04:39 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:39Z /var/lib/influxdb/data/_internal/monitor/232/000000010-000000002.tsm (#0) opened in 91.084088ms engine=tsm1 service=filestore Nov 9 15:04:39 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:39Z reading file /var/lib/influxdb/wal/_internal/monitor/232/_00042.wal, size 0 engine=tsm1 service=cacheloader Nov 9 15:04:39 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:39Z /var/lib/influxdb/data/_internal/monitor/233 opened in 128.698ms service=store Nov 9 15:04:39 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:39Z /var/lib/influxdb/data/_internal/monitor/236/000000005-000000001.tsm (#1) opened in 57.020374ms engine=tsm1 service=filestore Nov 9 15:04:40 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:40Z /var/lib/influxdb/data/_internal/monitor/232 opened in 185.103584ms service=store Nov 9 15:04:40 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:40Z /var/lib/influxdb/data/_internal/monitor/236/000000004-000000003.tsm (#0) opened in 103.191087ms engine=tsm1 service=filestore Nov 9 15:04:40 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:40Z /var/lib/influxdb/data/_internal/monitor/235/000000004-000000003.tsm (#0) opened in 87.569722ms engine=tsm1 service=filestore Nov 9 15:04:40 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:40Z /var/lib/influxdb/data/iobroker/global/106/000000051-000000002.tsm (#0) opened in 42.956764ms engine=tsm1 service=filestore Nov 9 15:04:40 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:40Z reading file /var/lib/influxdb/wal/iobroker/global/106/_00100.wal, size 0 engine=tsm1 service=cacheloader Nov 9 15:04:40 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:40Z /var/lib/influxdb/data/iobroker/global/106 opened in 70.102007ms service=store Nov 9 15:04:40 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:40Z /var/lib/influxdb/data/iobroker/global/114/000000045-000000002.tsm (#0) opened in 9.636225ms engine=tsm1 service=filestore Nov 9 15:04:40 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:40Z reading file /var/lib/influxdb/wal/iobroker/global/114/_00094.wal, size 0 engine=tsm1 service=cacheloader Nov 9 15:04:40 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:40Z /var/lib/influxdb/data/iobroker/global/122/000000020-000000004.tsm (#0) opened in 9.620132ms engine=tsm1 service=filestore Nov 9 15:04:40 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:40Z reading file /var/lib/influxdb/wal/iobroker/global/122/_00071.wal, size 0 engine=tsm1 service=cacheloader Nov 9 15:04:40 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:40Z /var/lib/influxdb/data/iobroker/global/114 opened in 38.212245ms service=store Nov 9 15:04:40 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:40Z /var/lib/influxdb/data/iobroker/global/122 opened in 18.922868ms service=store
! Da ich nicht 100%-ig weiß wonach ich im Syslog konkret suchen soll ist mir u.a. dies hier aufgefallen (Das wiederholt sich unzählige Male, hier also nur gekürzt):
! >! [spoiler]~~[code]~~Nov 9 15:04:40 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:40Z Listening on HTTP:[::]:8086 service=httpd Nov 9 15:04:40 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:40Z Starting retention policy enforcement service with check interval of 30m0s service=retention Nov 9 15:04:40 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:40Z Listening for signals Nov 9 15:04:40 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:40Z Storing statistics in database '_internal' retention policy 'monitor', at interval 10s service=monitor Nov 9 15:04:41 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:41Z beginning full compaction of group 0, 2 TSM files engine=tsm1 Nov 9 15:04:41 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:41Z compacting full group (0) /var/lib/influxdb/data/_internal/monitor/236/000000004-000000003.tsm (#0) engine=tsm1 Nov 9 15:04:41 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:41Z compacting full group (0) /var/lib/influxdb/data/_internal/monitor/236/000000005-000000001.tsm (#1) engine=tsm1 Nov 9 15:04:41 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:41Z aborted full compaction group (0). compaction in progress: open /var/lib/influxdb/data/_internal/monitor/236/000000005-000000002.tsm.tmp: permission denied engine=tsm1 Nov 9 15:04:42 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:42Z beginning full compaction of group 0, 2 TSM files engine=tsm1 Nov 9 15:04:42 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:42Z compacting full group (0) /var/lib/influxdb/data/_internal/monitor/236/000000004-000000003.tsm (#0) engine=tsm1 Nov 9 15:04:42 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:42Z compacting full group (0) /var/lib/influxdb/data/_internal/monitor/236/000000005-000000001.tsm (#1) engine=tsm1 Nov 9 15:04:42 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:42Z aborted full compaction group (0). compaction in progress: open /var/lib/influxdb/data/_internal/monitor/236/000000005-000000002.tsm.tmp: permission denied engine=tsm1 Nov 9 15:04:42 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:42Z Sending usage statistics to usage.influxdata.com Nov 9 15:04:43 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:43Z beginning full compaction of group 0, 2 TSM files engine=tsm1 Nov 9 15:04:43 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:43Z compacting full group (0) /var/lib/influxdb/data/_internal/monitor/236/000000004-000000003.tsm (#0) engine=tsm1 Nov 9 15:04:43 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:43Z compacting full group (0) /var/lib/influxdb/data/_internal/monitor/236/000000005-000000001.tsm (#1) engine=tsm1 Nov 9 15:04:43 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:43Z [b]aborted [/b]full compaction group (0). compaction in progress: open /var/lib/influxdb/data/_internal/monitor/236/000000005-000000002.tsm.tmp: permission denied engine=tsm1 Nov 9 15:04:44 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:44Z beginning full compaction of group 0, 2 TSM files engine=tsm1 Nov 9 15:04:44 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:44Z compacting full group (0) /var/lib/influxdb/data/_internal/monitor/236/000000004-000000003.tsm (#0) engine=tsm1 Nov 9 15:04:44 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:44Z compacting full group (0) /var/lib/influxdb/data/_internal/monitor/236/000000005-000000001.tsm (#1) engine=tsm1 Nov 9 15:04:44 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:44Z [b]aborted[/b] full compaction group (0). compaction in progress: open /var/lib/influxdb/data/_internal/monitor/236/000000005-000000002.tsm.tmp: permission denied engine=tsm1 Nov 9 15:04:45 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:04:45Z beginning full compaction of group 0, 2 TSM files engine=tsm1
! Dann gibt es offensichtlich noch einen 500er Error beim versuch zu schreiben (ebenfalls unzählige Male im Log).
! >! [spoiler]~~[code]~~Nov 9 15:05:41 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:05:41Z write failed for shard 234: engine: error rolling WAL segment: error opening new segment file for wal (2): open /var/lib/influxdb/wal/iobroker/global/234/_00028.wal: permission denied service=write Nov 9 15:05:41 ioBroker-RasPi influxd[9540]: [httpd] 127.0.0.1 - admin [09/Nov/2017:15:05:41 +0100] "POST /write?database=iobroker&db=iobroker&p=%5BREDACTED%5D&precision=ms&u=admin HTTP/1.1" 500 168 "-" "-" 11fda5ab-c557-11e7-8031-000000000000 50658 Nov 9 15:05:41 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:05:41Z write failed for shard 234: engine: error rolling WAL segment: error opening new segment file for wal (2): open /var/lib/influxdb/wal/iobroker/global/234/_00032.wal: permission denied service=write Nov 9 15:05:41 ioBroker-RasPi influxd[9540]: [httpd] 127.0.0.1 - admin [09/Nov/2017:15:05:40 +0100] "POST /write?database=iobroker&db=iobroker&p=%5BREDACTED%5D&precision=ms&u=admin HTTP/1.1" 500 168 "-" "-" 11cac88b-c557-11e7-8019-000000000000 393106 Nov 9 15:05:41 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:05:41Z write failed for shard 234: engine: error rolling WAL segment: error opening new segment file for wal (2): open /var/lib/influxdb/wal/iobroker/global/234/_00033.wal: permission denied service=write Nov 9 15:05:41 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:05:41Z write failed for shard 234: engine: error rolling WAL segment: error opening new segment file for wal (2): open /var/lib/influxdb/wal/iobroker/global/234/_00034.wal: permission denied service=write Nov 9 15:05:41 ioBroker-RasPi influxd[9540]: [httpd] 127.0.0.1 - admin [09/Nov/2017:15:05:41 +0100] "POST /write?database=iobroker&db=iobroker&p=%5BREDACTED%5D&precision=ms&u=admin HTTP/1.1" 500 168 "-" "-" 1200b751-c557-11e7-8032-000000000000 40937 Nov 9 15:05:41 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:05:41Z write failed for shard 234: engine: error rolling WAL segment: error opening new segment file for wal (2): open /var/lib/influxdb/wal/iobroker/global/234/_00036.wal: permission denied service=write Nov 9 15:05:41 ioBroker-RasPi influxd[9540]: [httpd] 127.0.0.1 - admin [09/Nov/2017:15:05:41 +0100] "POST /write?database=iobroker&db=iobroker&p=%5BREDACTED%5D&precision=ms&u=admin HTTP/1.1" 500 168 "-" "-" 11f148d9-c557-11e7-802f-000000000000 156120 Nov 9 15:05:41 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:05:41Z write failed for shard 234: engine: error rolling WAL segment: error opening new segment file for wal (2): open /var/lib/influxdb/wal/iobroker/global/234/_00038.wal: permission denied service=write Nov 9 15:05:41 ioBroker-RasPi influxd[9540]: [httpd] 127.0.0.1 - admin [09/Nov/2017:15:05:41 +0100] "POST /write?database=iobroker&db=iobroker&p=%5BREDACTED%5D&precision=ms&u=admin HTTP/1.1" 500 168 "-" "-" 11ee4d19-c557-11e7-8024-000000000000 179902 Nov 9 15:05:41 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:05:41Z write failed for shard 234: engine: error rolling WAL segment: error opening new segment file for wal (2): open /var/lib/influxdb/wal/iobroker/global/234/_00040.wal: permission denied service=write Nov 9 15:05:41 ioBroker-RasPi influxd[9540]: [httpd] 127.0.0.1 - admin [09/Nov/2017:15:05:41 +0100] "POST /write?database=iobroker&db=iobroker&p=%5BREDACTED%5D&precision=ms&u=admin HTTP/1.1" 500 168 "-" "-" 11eb674d-c557-11e7-801c-000000000000 206948 Nov 9 15:05:41 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:05:41Z write failed for shard 234: engine: error rolling WAL segment: error opening new segment file for wal (2): open /var/lib/influxdb/wal/iobroker/global/234/_00042.wal: permission denied service=write Nov 9 15:05:41 ioBroker-RasPi influxd[9540]: [httpd] 127.0.0.1 - admin [09/Nov/2017:15:05:41 +0100] "POST /write?database=iobroker&db=iobroker&p=%5BREDACTED%5D&precision=ms&u=admin HTTP/1.1" 500 168 "-" "-" 11f12b9c-c557-11e7-802e-000000000000 142818 Nov 9 15:05:41 ioBroker-RasPi influxd[9540]: [httpd] 127.0.0.1 - admin [09/Nov/2017:15:05:41 +0100] "POST /write?database=iobroker&db=iobroker&p=%5BREDACTED%5D&precision=ms&u=admin HTTP/1.1" 500 168 "-" "-" 11ee59ef-c557-11e7-8025-000000000000 193287 Nov 9 15:05:41 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:05:41Z write failed for shard 234: engine: error rolling WAL segment: error opening new segment file for wal (2): open /var/lib/influxdb/wal/iobroker/global/234/_00044.wal: permission denied service=write Nov 9 15:05:41 ioBroker-RasPi influxd[9540]: [httpd] 127.0.0.1 - admin [09/Nov/2017:15:05:41 +0100] "POST /write?database=iobroker&db=iobroker&p=%5BREDACTED%5D&precision=ms&u=admin HTTP/1.1" 500 168 "-" "-" 11ee141c-c557-11e7-801f-000000000000 199318 Nov 9 15:05:41 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:05:41Z write failed for shard 234: engine: error rolling WAL segment: error opening new segment file for wal (2): open /var/lib/influxdb/wal/iobroker/global/234/_00046.wal: permission denied service=write Nov 9 15:05:41 ioBroker-RasPi influxd[9540]: [httpd] 127.0.0.1 - admin [09/Nov/2017:15:05:41 +0100] "POST /write?database=iobroker&db=iobroker&p=%5BREDACTED%5D&precision=ms&u=admin HTTP/1.1" 500 168 "-" "-" 11ee6531-c557-11e7-8027-000000000000 201623 Nov 9 15:05:41 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:05:41Z write failed for shard 234: engine: error rolling WAL segment: error opening new segment file for wal (2): open /var/lib/influxdb/wal/iobroker/global/234/_00047.wal: permission denied service=write Nov 9 15:05:41 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:05:41Z write failed for shard 234: engine: error rolling WAL segment: error opening new segment file for wal (2): open /var/lib/influxdb/wal/iobroker/global/234/_00049.wal: permission denied service=write Nov 9 15:05:41 ioBroker-RasPi influxd[9540]: [httpd] 127.0.0.1 - admin [09/Nov/2017:15:05:41 +0100] "POST /write?database=iobroker&db=iobroker&p=%5BREDACTED%5D&precision=ms&u=admin HTTP/1.1" 500 168 "-" "-" 11ee248e-c557-11e7-8021-000000000000 208597 Nov 9 15:05:41 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:05:41Z write failed for shard 234: engine: error rolling WAL segment: error opening new segment file for wal (2): open /var/lib/influxdb/wal/iobroker/global/234/_00051.wal: permission denied service=write Nov 9 15:05:41 ioBroker-RasPi influxd[9540]: [httpd] 127.0.0.1 - admin [09/Nov/2017:15:05:41 +0100] "POST /write?database=iobroker&db=iobroker&p=%5BREDACTED%5D&precision=ms&u=admin HTTP/1.1" 500 168 "-" "-" 11ee8c7b-c557-11e7-8029-000000000000 210484 Nov 9 15:05:41 ioBroker-RasPi influxd[9540]: [httpd] 127.0.0.1 - admin [09/Nov/2017:15:05:40 +0100] "POST /write?database=iobroker&db=iobroker&p=%5BREDACTED%5D&precision=ms&u=admin HTTP/1.1" 500 168 "-" "-" 11b6f92e-c557-11e7-800a-000000000000 565317 Nov 9 15:05:41 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:05:41Z write failed for shard 234: engine: error rolling WAL segment: error opening new segment file for wal (2): open /var/lib/influxdb/wal/iobroker/global/234/_00053.wal: permission denied service=write
! Permission denied beim Schreiben auch hier:
! >! [spoiler]~~[code]~~Nov 9 15:05:51 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:05:51Z Snapshot for path /var/lib/influxdb/data/iobroker/global/234 written in 119.479µs engine=tsm1 Nov 9 15:05:51 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:05:51Z error writing snapshot: error opening new segment file for wal (1): open /var/lib/influxdb/wal/iobroker/global/234/_00117.wal: permission denied engine=tsm1 Nov 9 15:05:51 ioBroker-RasPi influxd[9540]: [i] 2017-11-09T14:05:51Z write failed for shard 234: engine: error rolling WAL segment: error opening new segment file for wal (2): open /var/lib/influxdb/wal/iobroker/global/234/_00119.wal: permission denied service=write
! Die Log-datei ist 60MB groß. Durch stöbern kome ich vermutlich nicht weiter.
! Helfen die beigefügten Logs?
! Hier noch die Config der InfluxDB, falls es relevant ist.
! >! [spoiler]`[code]### Welcome to the InfluxDB configuration file.
! # The values in this file override the default values used by the system if

a config option is not specified. The commented out lines are the the configuration

field and the default value used. Uncommentting a line and changing the value

will change the value used at runtime when the process is restarted.

! # Once every 24 hours InfluxDB will report usage data to usage.influxdata.com

The data includes a random ID, os, arch, version, the number of series and other

usage data. No data from user databases is ever transmitted.

Change this option to true to disable reporting.

reporting-disabled = false

! # we'll try to get the hostname automatically, but if it the os returns something

that isn't resolvable by other servers in the cluster, use this option to

manually set the hostname

hostname = "localhost"

! ###

[meta]

Controls the parameters for the Raft consensus group that stores metadata

about the InfluxDB cluster.

! [meta]

Where the metadata/raft database is stored

dir = "/var/lib/influxdb/meta"

! # Automatically create a default retention policy when creating a database.

retention-autocreate = true

! # If log messages are printed for the meta service

logging-enabled = true

! ###

[data]

Controls where the actual shard data for InfluxDB lives and how it is

flushed from the WAL. "dir" may need to be changed to a suitable place

for your system, but the WAL settings are an advanced configuration. The

defaults should work for most systems.

! [data]

The directory where the TSM storage engine stores TSM files.

dir = "/var/lib/influxdb/data"

! # The directory where the TSM storage engine stores WAL files.
wal-dir = "/var/lib/influxdb/wal"
! # Trace logging provides more verbose output around the tsm engine. Turning

this on can provide more useful output for debugging tsm engine issues.

trace-logging-enabled = true

! # Whether queries should be logged before execution. Very useful for troubleshooting, but will

log any sensitive data contained within a query.

query-log-enabled = true

! # Settings for the TSM engine
! # CacheMaxMemorySize is the maximum size a shard's cache can

reach before it starts rejecting writes.

cache-max-memory-size = 1048576000

! # CacheSnapshotMemorySize is the size at which the engine will

snapshot the cache and write it to a TSM file, freeing up memory

cache-snapshot-memory-size = 26214400

! # CacheSnapshotWriteColdDuration is the length of time at

which the engine will snapshot the cache and write it to

a new TSM file if the shard hasn't received writes or deletes

cache-snapshot-write-cold-duration = "10m"

! # CompactFullWriteColdDuration is the duration at which the engine

will compact all TSM files in a shard if it hasn't received a

write or delete

compact-full-write-cold-duration = "4h"

! # The maximum series allowed per database before writes are dropped. This limit can prevent

high cardinality issues at the database level. This limit can be disabled by setting it to

0.

max-series-per-database = 1000000

! # The maximum number of tag values per tag that are allowed before writes are dropped. This limit

can prevent high cardinality tag values from being written to a measurement. This limit can be

disabled by setting it to 0.

max-values-per-tag = 100000

! ###

[coordinator]

Controls the clustering service configuration.

! [coordinator]

The default time a write request will wait until a "timeout" error is returned to the caller.

write-timeout = "10s"

! # The maximum number of concurrent queries allowed to be executing at one time. If a query is

executed and exceeds this limit, an error is returned to the caller. This limit can be disabled

by setting it to 0.

max-concurrent-queries = 0

! # The maximum time a query will is allowed to execute before being killed by the system. This limit

can help prevent run away queries. Setting the value to 0 disables the limit.

query-timeout = "0s"

! # The the time threshold when a query will be logged as a slow query. This limit can be set to help

discover slow or resource intensive queries. Setting the value to 0 disables the slow query logging.

log-queries-after = "0s"

! # The maximum number of points a SELECT can process. A value of 0 will make the maximum

point count unlimited.

max-select-point = 0

! # The maximum number of series a SELECT can run. A value of 0 will make the maximum series

count unlimited.

! # The maximum number of series a SELECT can run. A value of zero will make the maximum series

count unlimited.

max-select-series = 0

! # The maxium number of group by time bucket a SELECt can create. A value of zero will max the maximum

number of buckets unlimited.

max-select-buckets = 0

! ###

[retention]

Controls the enforcement of retention policies for evicting old data.

! [retention]

Determines whether retention policy enforcment enabled.

enabled = true

! # The interval of time when retention policy enforcement checks run.

check-interval = "30m"

! ###

[shard-precreation]

Controls the precreation of shards, so they are available before data arrives.

Only shards that, after creation, will have both a start- and end-time in the

future, will ever be created. Shards are never precreated that would be wholly

or partially in the past.

! [shard-precreation]

Determines whether shard pre-creation service is enabled.

enabled = true

! # The interval of time when the check to pre-create new shards runs.

check-interval = "10m"

! # The default period ahead of the endtime of a shard group that its successor

group is created.

advance-period = "30m"

! ###

Controls the system self-monitoring, statistics and diagnostics.

The internal database for monitoring data is created automatically if

if it does not already exist. The target retention within this database

is called 'monitor' and is also created with a retention period of 7 days

and a replication factor of 1, if it does not exist. In all cases the

this retention policy is configured as the default for the database.

! [monitor]

Whether to record statistics internally.

#store-enabled = true

! # The destination database for recorded statistics
#store-database = "_internal"
! # The interval at which to record statistics
#store-interval = "10s"
! ###

[admin]

Controls the availability of the built-in, web-based admin interface. If HTTPS is

enabled for the admin interface, HTTPS must also be enabled on the [http] service.

NOTE: This interface is deprecated as of 1.1.0 and will be removed in a future release.

! [admin]

Determines whether the admin service is enabled.

enabled = true

! # The default bind address used by the admin service.
bind-address = ":8083"
! # Whether the admin service should use HTTPS.

https-enabled = false

! # The SSL certificate used when HTTPS is enabled.

https-certificate = "/etc/ssl/influxdb.pem"

! ###

[http]

Controls how the HTTP endpoints are configured. These are the primary

mechanism for getting data into and out of InfluxDB.

! [http]

Determines whether HTTP endpoint is enabled.

enabled = true

! # The bind address used by the HTTP service.
bind-address = ":8086"
! # Determines whether HTTP authentication is enabled.

auth-enabled = false

! # The default realm sent back when issuing a basic auth challenge.

realm = "InfluxDB"

! # Determines whether HTTP request logging is enable.d

log-enabled = true

! # Determines whether detailed write logging is enabled.

write-tracing = false

! # Determines whether the pprof endpoint is enabled. This endpoint is used for

troubleshooting and monitoring.

pprof-enabled = true

! # Determines whether HTTPS is enabled.

https-enabled = false

! # The SSL certificate to use when HTTPS is enabled.

https-certificate = "/etc/ssl/influxdb.pem"

! # Use a separate private key location.

https-private-key = ""

! # The JWT auth shared secret to validate requests using JSON web tokens.

shared-sercret = ""

! # The default chunk size for result sets that should be chunked.

max-row-limit = 0

! # The maximum number of HTTP connections that may be open at once. New connections that

would exceed this limit are dropped. Setting this value to 0 disables the limit.

max-connection-limit = 0

! # Enable http service over unix domain socket

unix-socket-enabled = false

! # The path of the unix domain socket.

bind-socket = "/var/run/influxdb.sock"

! ###

[subscriber]

Controls the subscriptions, which can be used to fork a copy of all data

received by the InfluxDB host.

! [subscriber]

Determines whether the subscriber service is enabled.

enabled = true

! # The default timeout for HTTP writes to subscribers.

http-timeout = "30s"

! # Allows insecure HTTPS connections to subscribers. This is useful when testing with self-

signed certificates.

insecure-skip-verify = false

! # The path to the PEM encoded CA certs file. If the empty string, the default system certs will be used

ca-certs = ""

! # The number of writer goroutines processing the write channel.

write-concurrency = 40

! # The number of in-flight writes buffered in the write channel.

write-buffer-size = 1000

! ###

[[graphite]]

Controls one or many listeners for Graphite data.

! [[graphite]]

Determines whether the graphite endpoint is enabled.

enabled = false

database = "graphite"

retention-policy = ""

bind-address = ":2003"

protocol = "tcp"

consistency-level = "one"

! # These next lines control how batching works. You should have this enabled

otherwise you could get dropped metrics or poor performance. Batching

will buffer points in memory if you have many coming in.

! # Flush if this many points get buffered

batch-size = 5000

! # number of batches that may be pending in memory

batch-pending = 10

! # Flush at least this often even if we haven't hit buffer limit

batch-timeout = "1s"

! # UDP Read buffer size, 0 means OS default. UDP listener will fail if set above OS max.

udp-read-buffer = 0

! ### This string joins multiple matching 'measurement' values providing more control over the final measurement name.

separator = "."

! ### Default tags that will be added to all metrics. These can be overridden at the template level

or by tags extracted from metric

tags = ["region=us-east", "zone=1c"]

! ### Each template line requires a template pattern. It can have an optional

filter before the template and separated by spaces. It can also have optional extra

tags following the template. Multiple tags should be separated by commas and no spaces

similar to the line protocol format. There can be only one default template.

templates = [

"*.app env.service.resource.measurement",

# Default template

"server.*",

]

! ###

[collectd]

Controls one or many listeners for collectd data.

! [[collectd]]

enabled = false

bind-address = ":25826"

database = "collectd"

retention-policy = ""

The collectd service supports either scanning a directory for multiple types

db files, or specifying a single db file.

typesdb = "/usr/local/share/collectd"

security-level = "none"

auth-file = "/etc/collectd/auth_file"

! # These next lines control how batching works. You should have this enabled

otherwise you could get dropped metrics or poor performance. Batching

will buffer points in memory if you have many coming in.

! # Flush if this many points get buffered

batch-size = 5000

! # Number of batches that may be pending in memory

batch-pending = 10

! # Flush at least this often even if we haven't hit buffer limit

batch-timeout = "10s"

! # UDP Read buffer size, 0 means OS default. UDP listener will fail if set above OS max.

read-buffer = 0

! ###

[opentsdb]

Controls one or many listeners for OpenTSDB data.

! [[opentsdb]]

enabled = false

bind-address = ":4242"

database = "opentsdb"

retention-policy = ""

consistency-level = "one"

tls-enabled = false

certificate= "/etc/ssl/influxdb.pem"

! # Log an error for every malformed point.

log-point-errors = true

! # These next lines control how batching works. You should have this enabled

otherwise you could get dropped metrics or poor performance. Only points

metrics received over the telnet protocol undergo batching.

! # Flush if this many points get buffered

batch-size = 1000

! # Number of batches that may be pending in memory

batch-pending = 5

! # Flush at least this often even if we haven't hit buffer limit

batch-timeout = "1s"

! ###

[[udp]]

Controls the listeners for InfluxDB line protocol data via UDP.

! [[udp]]

enabled = false

bind-address = ":8089"

database = "udp"

retention-policy = ""

! # These next lines control how batching works. You should have this enabled

otherwise you could get dropped metrics or poor performance. Batching

will buffer points in memory if you have many coming in.

! # Flush if this many points get buffered

batch-size = 5000

! # Number of batches that may be pending in memory

batch-pending = 10

! # Will flush at least this often even if we haven't hit buffer limit

batch-timeout = "1s"

! # UDP Read buffer size, 0 means OS default. UDP listener will fail if set above OS max.

read-buffer = 0

! ###

[continuous_queries]

Controls how continuous queries are run within InfluxDB.

! [continuous_queries]

Determiens whether the continuous query service is enabled.

enabled = true

! # Controls whether queries are logged when executed by the CQ service.

log-enabled = true

! # interval for how often continuous queries will be checked if they need to run

run-interval = "1s"

! [/code]`[/spoiler]
! Besten Gruß
! Bernd[/i][/i][/i][/code][/spoiler][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i][/code][/spoiler][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i][/code][/spoiler][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i]

[apollon77]

Passen denn die Ownerships der Verzeichnisse zu dem User unter dem influxd als Prozess läuft ? Meistens User influxdb …

Wenn der Prozess einmal anders gestartet wurde (und du hattest weiter oben geschrieben das du mal "influxd" einfach gestartet hast) gehören pot. einige Files dem falschen User. Das musst Du jetzt reparieren.

[PerfectAnswer]

Nein, die passten nicht.

Ich habe das jetzt alles wieder auf den influxDB User zurück gebogen und nun sind die Log auch wieder übersichtlicher!

Danke schon mal für diesen goldenen Tipp :))

Ich lasse das jetzt mal laufen und hoffe das ich beim nächsten freeze dann etwas aussagekräftigeres im Log habe.

Besten Gruß

Bernd

[PerfectAnswer]

Kann mir jemand sagen wo ich im Config File einstellen kann das die InfluxDB logging durchführt?

Der Ordner /var/log/influxdb/ ist jedenfalls leer…

[apollon77]

/var/log/syslog ?

[PerfectAnswer]

Syslog hatte ich ja schon weiter oben unterm Spoiler gezeigt, da komme ich auch ran.

Es ist aber mittlerweile so, dass ich nicht mal mehr auf den Raspi drauf komme.

Werde ihn die Tage mal direkt an einen Rechner und eine Tastatur hängen um zu schauen was da eigentlich passiert.

Zumindest hoffe ich das ich während des Startvorgangs irgendwo zwischenfunken kann :?

Danke für die Hilfe bis hierher.