Home Assistant Community Add-on: InfluxDB

Same here. I turned off auto-updates for all addons years ago… always prefer to read the notes first in case something is going to bite me. Good advice.

1 Like

Ok but when everybody is waiting, no errors could been found. I’m very happy with speed of solving error. Many thanks to developers.

My influxDB install is having a bit of a problem since upgrade from 3.7.9 to 4.0.1 and is in a continuous crashing cycle.

I was first unable to start the addon - it was complaining about something already running on port 8086. Eventually after a reboot i got past that check. But now i’m just getting a very long stacktrace dumped into the log (see below). If i enable the watchdog, i just get a constant repeat of restarting the addon.

I’ve uninstalled the addon, rebooted and reinstalled to see if that would make any difference - no.

I even restored a partial snapshot from prior to upgrade (3.7.9) in the hope that this would work, but i get very similar symptoms - not sure if the stack trace is the same.

The only two things i can think of left to try are a restore of a full snapshot, and try an older snapshot.

I also can’t seem to find where the addon logs get dumped to, if they may be of any help.

(snippet of stack trace):

	/usr/local/go/src/net/net.go:184 +0x58
net/http.(*connReader).Read(0x15a10d40, 0x1c68e000, 0x1000, 0x1000, 0x1d, 0x2b4a4c8, 0x0)
	/usr/local/go/src/net/http/server.go:785 +0x15c
bufio.(*Reader).fill(0x10c48030)
	/usr/local/go/src/bufio/bufio.go:100 +0x108
bufio.(*Reader).Peek(0x10c48030, 0x4, 0x0, 0x0, 0x0, 0x0, 0x0)
	/usr/local/go/src/bufio/bufio.go:138 +0x38
net/http.(*conn).readRequest(0x4f33560, 0x1eaf2f0, 0x15a10d20, 0x0, 0x0, 0x0)
	/usr/local/go/src/net/http/server.go:962 +0xae8
net/http.(*conn).serve(0x4f33560, 0x1eaf2f0, 0x15a10d20)
	/usr/local/go/src/net/http/server.go:1817 +0x644
created by net/http.(*Server).Serve
	/usr/local/go/src/net/http/server.go:2928 +0x2e4
goroutine 1020 [chan receive, 1 minutes]:
github.com/influxdata/influxdb/services/subscriber.chanWriter.Run(0x62729c0, 0x1e9c570, 0xea45860, 0x4f7b568, 0x4f7b570, 0x4c9b620)
	/go/src/github.com/influxdata/influxdb/services/subscriber/service.go:372 +0x38
github.com/influxdata/influxdb/services/subscriber.(*Service).updateSubs.func1(0x1598d890, 0x62729c0, 0x1e9c570, 0xea45860, 0x4f7b568, 0x4f7b570, 0x4c9b620)
	/go/src/github.com/influxdata/influxdb/services/subscriber/service.go:314 +0x4c
created by github.com/influxdata/influxdb/services/subscriber.(*Service).updateSubs
	/go/src/github.com/influxdata/influxdb/services/subscriber/service.go:312 +0x79c
goroutine 837 [select]:
github.com/influxdata/influxdb/tsdb/engine/tsm1.(*Engine).compact(0x52fc540, 0x754a4e0)
	/go/src/github.com/influxdata/influxdb/tsdb/engine/tsm1/engine.go:2074 +0x1b4
github.com/influxdata/influxdb/tsdb/engine/tsm1.(*Engine).enableLevelCompactions.func1(0x754a4e0, 0x52fc540)
	/go/src/github.com/influxdata/influxdb/tsdb/engine/tsm1/engine.go:426 +0x50
created by github.com/influxdata/influxdb/tsdb/engine/tsm1.(*Engine).enableLevelCompactions
	/go/src/github.com/influxdata/influxdb/tsdb/engine/tsm1/engine.go:426 +0x114
goroutine 1022 [chan receive, 1 minutes]:
github.com/influxdata/influxdb/services/subscriber.chanWriter.Run(0x62729c0, 0x1e9c570, 0xea45860, 0x4f7b568, 0x4f7b570, 0x4c9b620)
	/go/src/github.com/influxdata/influxdb/services/subscriber/service.go:372 +0x38
github.com/influxdata/influxdb/services/subscriber.(*Service).updateSubs.func1(0x1598d890, 0x62729c0, 0x1e9c570, 0xea45860, 0x4f7b568, 0x4f7b570, 0x4c9b620)
	/go/src/github.com/influxdata/influxdb/services/subscriber/service.go:314 +0x4c
created by github.com/influxdata/influxdb/services/subscriber.(*Service).updateSubs
	/go/src/github.com/influxdata/influxdb/services/subscriber/service.go:312 +0x79c
goroutine 1030 [chan receive, 1 minutes]:
github.com/influxdata/influxdb/services/subscriber.chanWriter.Run(0x62729c0, 0x1e9c570, 0xea45860, 0x4f7b568, 0x4f7b570, 0x4c9b620)
	/go/src/github.com/influxdata/influxdb/services/subscriber/service.go:372 +0x38
github.com/influxdata/influxdb/services/subscriber.(*Service).updateSubs.func1(0x1598d890, 0x62729c0, 0x1e9c570, 0xea45860, 0x4f7b568, 0x4f7b570, 0x4c9b620)
	/go/src/github.com/influxdata/influxdb/services/subscriber/service.go:314 +0x4c
created by github.com/influxdata/influxdb/services/subscriber.(*Service).updateSubs
	/go/src/github.com/influxdata/influxdb/services/subscriber/service.go:312 +0x79c
goroutine 1041 [IO wait]:
internal/poll.runtime_pollWait(0xa6bcff10, 0x72, 0x0)
	/usr/local/go/src/runtime/netpoll.go:184 +0x44
internal/poll.(*pollDesc).wait(0x4d32ec4, 0x72, 0x0, 0x0, 0xfcdb7e)
	/usr/local/go/src/internal/poll/fd_poll_runtime.go:87 +0x30
internal/poll.(*pollDesc).waitRead(...)
	/usr/local/go/src/internal/poll/fd_poll_runtime.go:92
internal/poll.(*FD).Accept(0x4d32eb0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0)
	/usr/local/go/src/internal/poll/fd_unix.go:384 +0x1a8
net.(*netFD).accept(0x4d32eb0, 0x2b5c170, 0x0, 0x1)
	/usr/local/go/src/net/fd_unix.go:238 +0x20
net.(*TCPListener).accept(0xc812940, 0x98c4be0, 0x1052b800, 0x4b074)
	/usr/local/go/src/net/tcpsock_posix.go:139 +0x20
net.(*TCPListener).Accept(0xc812940, 0x5ec16d8, 0xc, 0x7b1e540, 0x347188)
	/usr/local/go/src/net/tcpsock.go:261 +0x3c
net/http.(*Server).Serve(0x50b6000, 0x1eacd50, 0xc812940, 0x0, 0x0)
	/usr/local/go/src/net/http/server.go:2896 +0x214
net/http.Serve(...)
	/usr/local/go/src/net/http/server.go:2468
github.com/influxdata/influxdb/services/httpd.(*Service).serve(0x4f54900, 0x1eacd50, 0xc812940)
	/go/src/github.com/influxdata/influxdb/services/httpd/service.go:250 +0x64
github.com/influxdata/influxdb/services/httpd.(*Service).serveTCP(0x4f54900)
	/go/src/github.com/influxdata/influxdb/services/httpd/service.go:238 +0x2c
created by github.com/influxdata/influxdb/services/httpd.(*Service).Open
	/go/src/github.com/influxdata/influxdb/services/httpd/service.go:187 +0x45c
goroutine 1042 [select, 1 minutes]:
github.com/influxdata/influxdb/services/retention.(*Service).run(0x4c9b3e0)
	/go/src/github.com/influxdata/influxdb/services/retention/service.go:78 +0x77c
github.com/influxdata/influxdb/services/retention.(*Service).Open.func1(0x4c9b3e0)
	/go/src/github.com/influxdata/influxdb/services/retention/service.go:51 +0x50
created by github.com/influxdata/influxdb/services/retention.(*Service).Open
	/go/src/github.com/influxdata/influxdb/services/retention/service.go:51 +0x130
goroutine 1043 [select, 1 minutes]:
github.com/influxdata/influxdb/cmd/influxd/run.(*Server).startServerReporting(0x4f6a0a0)
	/go/src/github.com/influxdata/influxdb/cmd/influxd/run/server.go:521 +0xd0
created by github.com/influxdata/influxdb/cmd/influxd/run.(*Server).Open
	/go/src/github.com/influxdata/influxdb/cmd/influxd/run/server.go:466 +0xb8c
goroutine 1044 [select, 1 minutes]:
github.com/influxdata/influxdb/cmd/influxd/run.(*Command).monitorServerErrors(0x4f32300)
	/go/src/github.com/influxdata/influxdb/cmd/influxd/run/command.go:174 +0x134
created by github.com/influxdata/influxdb/cmd/influxd/run.(*Command).Run
	/go/src/github.com/influxdata/influxdb/cmd/influxd/run/command.go:155 +0x8d8
goroutine 1031 [chan receive, 1 minutes]:
github.com/influxdata/influxdb/services/subscriber.chanWriter.Run(0x6272a80, 0x1e9c570, 0xea45890, 0x4f7b568, 0x4f7b570, 0x4c9b620)
	/go/src/github.com/influxdata/influxdb/services/subscriber/service.go:372 +0x38
github.com/influxdata/influxdb/services/subscriber.(*Service).updateSubs.func1(0x1598d890, 0x6272a80, 0x1e9c570, 0xea45890, 0x4f7b568, 0x4f7b570, 0x4c9b620)
	/go/src/github.com/influxdata/influxdb/services/subscriber/service.go:314 +0x4c
created by github.com/influxdata/influxdb/services/subscriber.(*Service).updateSubs
	/go/src/github.com/influxdata/influxdb/services/subscriber/service.go:312 +0x79c
goroutine 1032 [chan receive, 1 minutes]:
github.com/influxdata/influxdb/services/subscriber.chanWriter.Run(0x6272a80, 0x1e9c570, 0xea45890, 0x4f7b568, 0x4f7b570, 0x4c9b620)
	/go/src/github.com/influxdata/influxdb/services/subscriber/service.go:372 +0x38
github.com/influxdata/influxdb/services/subscriber.(*Service).updateSubs.func1(0x1598d890, 0x6272a80, 0x1e9c570, 0xea45890, 0x4f7b568, 0x4f7b570, 0x4c9b620)
	/go/src/github.com/influxdata/influxdb/services/subscriber/service.go:314 +0x4c
created by github.com/influxdata/influxdb/services/subscriber.(*Service).updateSubs
	/go/src/github.com/influxdata/influxdb/services/subscriber/service.go:312 +0x79c
goroutine 1033 [chan receive, 1 minutes]:
github.com/influxdata/influxdb/services/subscriber.chanWriter.Run(0x6272a80, 0x1e9c570, 0xea45890, 0x4f7b568, 0x4f7b570, 0x4c9b620)
	/go/src/github.com/influxdata/influxdb/services/subscriber/service.go:372 +0x38
github.com/influxdata/influxdb/services/subscriber.(*Service).updateSubs.func1(0x1598d890, 0x6272a80, 0x1e9c570, 0xea45890, 0x4f7b568, 0x4f7b570, 0x4c9b620)
	/go/src/github.com/influxdata/influxdb/services/subscriber/service.go:314 +0x4c
created by github.com/influxdata/influxdb/services/subscriber.(*Service).updateSubs
	/go/src/github.com/influxdata/influxdb/services/subscriber/service.go:312 +0x79c
goroutine 1034 [chan receive, 1 minutes]:
github.com/influxdata/influxdb/services/subscriber.chanWriter.Run(0x6272a80, 0x1e9c570, 0xea45890, 0x4f7b568, 0x4f7b570, 0x4c9b620)
	/go/src/github.com/influxdata/influxdb/services/subscriber/service.go:372 +0x38
github.com/influxdata/influxdb/services/subscriber.(*Service).updateSubs.func1(0x1598d890, 0x6272a80, 0x1e9c570, 0xea45890, 0x4f7b568, 0x4f7b570, 0x4c9b620)
	/go/src/github.com/influxdata/influxdb/services/subscriber/service.go:314 +0x4c
created by github.com/influxdata/influxdb/services/subscriber.(*Service).updateSubs
	/go/src/github.com/influxdata/influxdb/services/subscriber/service.go:312 +0x79c
goroutine 1035 [chan receive, 1 minutes]:
github.com/influxdata/influxdb/services/subscriber.chanWriter.Run(0x6272a80, 0x1e9c570, 0xea45890, 0x4f7b568, 0x4f7b570, 0x4c9b620)
	/go/src/github.com/influxdata/influxdb/services/subscriber/service.go:372 +0x38
github.com/influxdata/influxdb/services/subscriber.(*Service).updateSubs.func1(0x1598d890, 0x6272a80, 0x1e9c570, 0xea45890, 0x4f7b568, 0x4f7b570, 0x4c9b620)
	/go/src/github.com/influxdata/influxdb/services/subscriber/service.go:314 +0x4c
created by github.com/influxdata/influxdb/services/subscriber.(*Service).updateSubs
	/go/src/github.com/influxdata/influxdb/services/subscriber/service.go:312 +0x79c
goroutine 1036 [chan receive, 1 minutes]:
github.com/influxdata/influxdb/services/subscriber.chanWriter.Run(0x6272a80, 0x1e9c570, 0xea45890, 0x4f7b568, 0x4f7b570, 0x4c9b620)
	/go/src/github.com/influxdata/influxdb/services/subscriber/service.go:372 +0x38
github.com/influxdata/influxdb/services/subscriber.(*Service).updateSubs.func1(0x1598d890, 0x6272a80, 0x1e9c570, 0xea45890, 0x4f7b568, 0x4f7b570, 0x4c9b620)
	/go/src/github.com/influxdata/influxdb/services/subscriber/service.go:314 +0x4c
created by github.com/influxdata/influxdb/services/subscriber.(*Service).updateSubs
	/go/src/github.com/influxdata/influxdb/services/subscriber/service.go:312 +0x79c
goroutine 1037 [chan receive, 1 minutes]:
github.com/influxdata/influxdb/services/subscriber.chanWriter.Run(0x6272a80, 0x1e9c570, 0xea45890, 0x4f7b568, 0x4f7b570, 0x4c9b620)
	/go/src/github.com/influxdata/influxdb/services/subscriber/service.go:372 +0x38
github.com/influxdata/influxdb/services/subscriber.(*Service).updateSubs.func1(0x1598d890, 0x6272a80, 0x1e9c570, 0xea45890, 0x4f7b568, 0x4f7b570, 0x4c9b620)
	/go/src/github.com/influxdata/influxdb/services/subscriber/service.go:314 +0x4c
created by github.com/influxdata/influxdb/services/subscriber.(*Service).updateSubs
	/go/src/github.com/influxdata/influxdb/services/subscriber/service.go:312 +0x79c
goroutine 1038 [chan receive, 1 minutes]:
github.com/influxdata/influxdb/services/subscriber.chanWriter.Run(0x6272a80, 0x1e9c570, 0xea45890, 0x4f7b568, 0x4f7b570, 0x4c9b620)
	/go/src/github.com/influxdata/influxdb/services/subscriber/service.go:372 +0x38
github.com/influxdata/influxdb/services/subscriber.(*Service).updateSubs.func1(0x1598d890, 0x6272a80, 0x1e9c570, 0xea45890, 0x4f7b568, 0x4f7b570, 0x4c9b620)
	/go/src/github.com/influxdata/influxdb/services/subscriber/service.go:314 +0x4c
created by github.com/influxdata/influxdb/services/subscriber.(*Service).updateSubs
	/go/src/github.com/influxdata/influxdb/services/subscriber/service.go:312 +0x79c
goroutine 1039 [chan receive]:
github.com/influxdata/influxdb/services/subscriber.chanWriter.Run(0x6272a80, 0x1e9c570, 0xea45890, 0x4f7b568, 0x4f7b570, 0x4c9b620)
	/go/src/github.com/influxdata/influxdb/services/subscriber/service.go:372 +0x38
github.com/influxdata/influxdb/services/subscriber.(*Service).updateSubs.func1(0x1598d890, 0x6272a80, 0x1e9c570, 0xea45890, 0x4f7b568, 0x4f7b570, 0x4c9b620)
	/go/src/github.com/influxdata/influxdb/services/subscriber/service.go:314 +0x4c
created by github.com/influxdata/influxdb/services/subscriber.(*Service).updateSubs
	/go/src/github.com/influxdata/influxdb/services/subscriber/service.go:312 +0x79c
goroutine 1040 [chan receive]:
github.com/influxdata/influxdb/services/subscriber.chanWriter.Run(0x6272a80, 0x1e9c570, 0xea45890, 0x4f7b568, 0x4f7b570, 0x4c9b620)
	/go/src/github.com/influxdata/influxdb/services/subscriber/service.go:372 +0x38
github.com/influxdata/influxdb/services/subscriber.(*Service).updateSubs.func1(0x1598d890, 0x6272a80, 0x1e9c570, 0xea45890, 0x4f7b568, 0x4f7b570, 0x4c9b620)
	/go/src/github.com/influxdata/influxdb/services/subscriber/service.go:314 +0x4c
created by github.com/influxdata/influxdb/services/subscriber.(*Service).updateSubs
	/go/src/github.com/influxdata/influxdb/services/subscriber/service.go:312 +0x79c
goroutine 1057 [chan receive]:
github.com/influxdata/influxdb/services/subscriber.chanWriter.Run(0x6272a80, 0x1e9c570, 0xea45890, 0x4f7b568, 0x4f7b570, 0x4c9b620)
	/go/src/github.com/influxdata/influxdb/services/subscriber/service.go:372 +0x38
github.com/influxdata/influxdb/services/subscriber.(*Service).updateSubs.func1(0x1598d890, 0x6272a80, 0x1e9c570, 0xea45890, 0x4f7b568, 0x4f7b570, 0x4c9b620)
	/go/src/github.com/influxdata/influxdb/services/subscriber/service.go:314 +0x4c
created by github.com/influxdata/influxdb/services/subscriber.(*Service).updateSubs
	/go/src/github.com/influxdata/influxdb/services/subscriber/service.go:312 +0x79c
goroutine 1058 [chan receive]:
github.com/influxdata/influxdb/services/subscriber.chanWriter.Run(0x6272a80, 0x1e9c570, 0xea45890, 0x4f7b568, 0x4f7b570, 0x4c9b620)
	/go/src/github.com/influxdata/influxdb/services/subscriber/service.go:372 +0x38
github.com/influxdata/influxdb/services/subscriber.(*Service).updateSubs.func1(0x1598d890, 0x6272a80, 0x1e9c570, 0xea45890, 0x4f7b568, 0x4f7b570, 0x4c9b620)
	/go/src/github.com/influxdata/influxdb/services/subscriber/service.go:314 +0x4c
created by github.com/influxdata/influxdb/services/subscriber.(*Service).updateSubs
	/go/src/github.com/influxdata/influxdb/services/subscriber/service.go:312 +0x79c
goroutine 1059 [chan receive]:
github.com/influxdata/influxdb/services/subscriber.chanWriter.Run(0x6272a80, 0x1e9c570, 0xea45890, 0x4f7b568, 0x4f7b570, 0x4c9b620)
	/go/src/github.com/influxdata/influxdb/services/subscriber/service.go:372 +0x38
github.com/influxdata/influxdb/services/subscriber.(*Service).updateSubs.func1(0x1598d890, 0x6272a80, 0x1e9c570, 0xea45890, 0x4f7b568, 0x4f7b570, 0x4c9b620)
	/go/src/github.com/influxdata/influxdb/services/subscriber/service.go:314 +0x4c
created by github.com/influxdata/influxdb/services/subscriber.(*Service).updateSubs
	/go/src/github.com/influxdata/influxdb/services/subscriber/service.go:312 +0x79c
goroutine 1060 [chan receive]:
github.com/influxdata/influxdb/services/subscriber.chanWriter.Run(0x6272a80, 0x1e9c570, 0xea45890, 0x4f7b568, 0x4f7b570, 0x4c9b620)
	/go/src/github.com/influxdata/influxdb/services/subscriber/service.go:372 +0x38
github.com/influxdata/influxdb/services/subscriber.(*Service).updateSubs.func1(0x1598d890, 0x6272a80, 0x1e9c570, 0xea45890, 0x4f7b568, 0x4f7b570, 0x4c9b620)
	/go/src/github.com/influxdata/influxdb/services/subscriber/service.go:314 +0x4c
created by github.com/influxdata/influxdb/services/subscriber.(*Service).updateSubs
	/go/src/github.com/influxdata/influxdb/services/subscriber/service.go:312 +0x79c
goroutine 1061 [chan receive]:
github.com/influxdata/influxdb/services/subscriber.chanWriter.Run(0x6272a80, 0x1e9c570, 0xea45890, 0x4f7b568, 0x4f7b570, 0x4c9b620)
	/go/src/github.com/influxdata/influxdb/services/subscriber/service.go:372 +0x38
github.com/influxdata/influxdb/services/subscriber.(*Service).updateSubs.func1(0x1598d890, 0x6272a80, 0x1e9c570, 0xea45890, 0x4f7b568, 0x4f7b570, 0x4c9b620)
	/go/src/github.com/influxdata/influxdb/services/subscriber/service.go:314 +0x4c
created by github.com/influxdata/influxdb/services/subscriber.(*Service).updateSubs
	/go/src/github.com/influxdata/influxdb/services/subscriber/service.go:312 +0x79c
goroutine 1062 [chan receive]:
github.com/influxdata/influxdb/services/subscriber.chanWriter.Run(0x6272a80, 0x1e9c570, 0xea45890, 0x4f7b568, 0x4f7b570, 0x4c9b620)
	/go/src/github.com/influxdata/influxdb/services/subscriber/service.go:372 +0x38
github.com/influxdata/influxdb/services/subscriber.(*Service).updateSubs.func1(0x1598d890, 0x6272a80, 0x1e9c570, 0xea45890, 0x4f7b568, 0x4f7b570, 0x4c9b620)
	/go/src/github.com/influxdata/influxdb/services/subscriber/service.go:314 +0x4c
created by github.com/influxdata/influxdb/services/subscriber.(*Service).updateSubs
	/go/src/github.com/influxdata/influxdb/services/subscriber/service.go:312 +0x79c
goroutine 1063 [chan receive]:
github.com/influxdata/influxdb/services/subscriber.chanWriter.Run(0x6272a80, 0x1e9c570, 0xea45890, 0x4f7b568, 0x4f7b570, 0x4c9b620)
	/go/src/github.com/influxdata/influxdb/services/subscriber/service.go:372 +0x38
github.com/influxdata/influxdb/services/subscriber.(*Service).updateSubs.func1(0x1598d890, 0x6272a80, 0x1e9c570, 0xea45890, 0x4f7b568, 0x4f7b570, 0x4c9b620)
	/go/src/github.com/influxdata/influxdb/services/subscriber/service.go:314 +0x4c
created by github.com/influxdata/influxdb/services/subscriber.(*Service).updateSubs
	/go/src/github.com/influxdata/influxdb/services/subscriber/service.go:312 +0x79c
goroutine 1064 [chan receive]:
github.com/influxdata/influxdb/services/subscriber.chanWriter.Run(0x6272a80, 0x1e9c570, 0xea45890, 0x4f7b568, 0x4f7b570, 0x4c9b620)
	/go/src/github.com/influxdata/influxdb/services/subscriber/service.go:372 +0x38
..
created by github.com/influxdata/influxdb/services/subscriber.(*Service).updateSubs
	/go/src/github.com/influxdata/influxdb/services/subscriber/service.go:312 +0x79c
goroutine 1112 [chan receive]:
github.com/influxdata/influxdb/services/subscriber.chanWriter.Run(0x5883e00, 0x1e9c570, 0x101a3f50, 0x4770428, 0x4770430, 0x453f0b0)
	/go/src/github.com/influxdata/influxdb/services/subscriber/service.go:372 +0x38
github.com/influxdata/influxdb/services/subscriber.(*Service).updateSubs.func1(0xa0133d0, 0x5883e00, 0x1e9c570, 0x101a3f50, 0x4770428, 0x4770430, 0x453f0b0)
	/go/src/github.com/influxdata/influxdb/services/subscriber/service.go:314 +0x4c
created by github.com/influxdata/influxdb/services/subscriber.(*Service).updateSubs
	/go/src/github.com/influxdata/influxdb/services/subscriber/service.go:312 +0x79c
goroutine 1346 [runnable]:
github.com/influxdata/influxdb/tsdb/engine/tsm1.FloatArrayEncodeAll(0xbebf2000, 0x3e7, 0xe00, 0xbe4e0e60, 0x15, 0x20, 0x7000, 0x1, 0x1, 0x6b80d60, ...)
	/go/src/github.com/influxdata/influxdb/tsdb/engine/tsm1/batch_float.go:54 +0x13b0
github.com/influxdata/influxdb/tsdb/engine/tsm1.EncodeFloatArrayBlock(0x1b921514, 0x0, 0x0, 0x0, 0x10ebdfc, 0x0, 0x52bab4, 0x4e0fc963, 0x52bb10)
	/go/src/github.com/influxdata/influxdb/tsdb/engine/tsm1/encoding.gen.go:468 +0x50
github.com/influxdata/influxdb/tsdb/engine/tsm1.(*tsmBatchKeyIterator).chunkFloat(0xa9f6320, 0x0, 0x0, 0x0, 0x165843b0, 0x0, 0xc8cc8)
	/go/src/github.com/influxdata/influxdb/tsdb/engine/tsm1/compact.gen.go:1221 +0xd0
github.com/influxdata/influxdb/tsdb/engine/tsm1.(*tsmBatchKeyIterator).combineFloat(0xa9f6320, 0x13352201, 0x25, 0x13352240, 0x2)
	/go/src/github.com/influxdata/influxdb/tsdb/engine/tsm1/compact.gen.go:1133 +0x850
github.com/influxdata/influxdb/tsdb/engine/tsm1.(*tsmBatchKeyIterator).mergeFloat(0xa9f6320)
	/go/src/github.com/influxdata/influxdb/tsdb/engine/tsm1/compact.gen.go:1059 +0x24c
github.com/influxdata/influxdb/tsdb/engine/tsm1.(*tsmBatchKeyIterator).merge(0xa9f6320)
	/go/src/github.com/influxdata/influxdb/tsdb/engine/tsm1/compact.go:1848 +0x34
github.com/influxdata/influxdb/tsdb/engine/tsm1.(*tsmBatchKeyIterator).Next(0xa9f6320, 0x10e0e79)
	/go/src/github.com/influxdata/influxdb/tsdb/engine/tsm1/compact.go:1708 +0x10ec
github.com/influxdata/influxdb/tsdb/engine/tsm1.(*Compactor).write(0x452b140, 0x18467b80, 0x43, 0x1eb2698, 0xa9f6320, 0xaa99601, 0x0, 0x0)
	/go/src/github.com/influxdata/influxdb/tsdb/engine/tsm1/compact.go:1141 +0x150
github.com/influxdata/influxdb/tsdb/engine/tsm1.(*Compactor).writeNewFiles(0x452b140, 0x49, 0x2, 0xf685400, 0x5, 0x8, 0x1eb2698, 0xa9f6320, 0x1, 0x1eb2698, ...)
	/go/src/github.com/influxdata/influxdb/tsdb/engine/tsm1/compact.go:1045 +0x11c
github.com/influxdata/influxdb/tsdb/engine/tsm1.(*Compactor).compact(0x452b140, 0xf685400, 0xf685400, 0x5, 0x8, 0x0, 0x0, 0x0, 0x0, 0x0)
	/go/src/github.com/influxdata/influxdb/tsdb/engine/tsm1/compact.go:953 +0x4a0
github.com/influxdata/influxdb/tsdb/engine/tsm1.(*Compactor).CompactFull(0x452b140, 0xf685400, 0x5, 0x8, 0x0, 0x0, 0x0, 0x0, 0x0)
	/go/src/github.com/influxdata/influxdb/tsdb/engine/tsm1/compact.go:971 +0x110
github.com/influxdata/influxdb/tsdb/engine/tsm1.(*compactionStrategy).compactGroup(0xf685440)
	/go/src/github.com/influxdata/influxdb/tsdb/engine/tsm1/engine.go:2259 +0xf64
github.com/influxdata/influxdb/tsdb/engine/tsm1.(*compactionStrategy).Apply(0xf685440)
	/go/src/github.com/influxdata/influxdb/tsdb/engine/tsm1/engine.go:2236 +0x2c
github.com/influxdata/influxdb/tsdb/engine/tsm1.(*Engine).compactFull.func1(0xa95cce0, 0x45ca300, 0xf685440)
	/go/src/github.com/influxdata/influxdb/tsdb/engine/tsm1/engine.go:2205 +0xc4
created by github.com/influxdata/influxdb/tsdb/engine/tsm1.(*Engine).compactFull
	/go/src/github.com/influxdata/influxdb/tsdb/engine/tsm1/engine.go:2201 +0xd0
goroutine 1322 [IO wait]:
internal/poll.runtime_pollWait(0xa6b5d080, 0x72, 0xffffffff)
	/usr/local/go/src/runtime/netpoll.go:184 +0x44
internal/poll.(*pollDesc).wait(0xcf70564, 0x72, 0x1000, 0x1000, 0xffffffff)
	/usr/local/go/src/internal/poll/fd_poll_runtime.go:87 +0x30
internal/poll.(*pollDesc).waitRead(...)
	/usr/local/go/src/internal/poll/fd_poll_runtime.go:92
internal/poll.(*FD).Read(0xcf70550, 0x7490000, 0x1000, 0x1000, 0x0, 0x0, 0x0)
	/usr/local/go/src/internal/poll/fd_unix.go:169 +0x178
net.(*netFD).Read(0xcf70550, 0x7490000, 0x1000, 0x1000, 0x48b3c01, 0x0, 0x33e21c)
	/usr/local/go/src/net/fd_unix.go:202 +0x38
net.(*conn).Read(0xcc36ee8, 0x7490000, 0x1000, 0x1000, 0x0, 0x0, 0x0)
	/usr/local/go/src/net/net.go:184 +0x58
net/http.(*connReader).Read(0x7fa2820, 0x7490000, 0x1000, 0x1000, 0x8, 0x2b4a4c8, 0x0)
	/usr/local/go/src/net/http/server.go:785 +0x15c
bufio.(*Reader).fill(0xcef8f30)
	/usr/local/go/src/bufio/bufio.go:100 +0x108
bufio.(*Reader).Peek(0xcef8f30, 0x4, 0x0, 0x0, 0x0, 0x0, 0x0)
	/usr/local/go/src/bufio/bufio.go:138 +0x38
net/http.(*conn).readRequest(0xaa22000, 0x1eaf2f0, 0x7fa2800, 0x0, 0x0, 0x0)
	/usr/local/go/src/net/http/server.go:962 +0xae8
net/http.(*conn).serve(0xaa22000, 0x1eaf2f0, 0x7fa2800)
	/usr/local/go/src/net/http/server.go:1817 +0x644
created by net/http.(*Server).Serve
	/usr/local/go/src/net/http/server.go:2928 +0x2e4
goroutine 1113 [IO wait]:
internal/poll.runtime_pollWait(0xa6b5d104, 0x72, 0xffffffff)
	/usr/local/go/src/runtime/netpoll.go:184 +0x44
internal/poll.(*pollDesc).wait(0x45ac1a4, 0x72, 0x1000, 0x1000, 0xffffffff)
	/usr/local/go/src/internal/poll/fd_poll_runtime.go:87 +0x30
internal/poll.(*pollDesc).waitRead(...)
	/usr/local/go/src/internal/poll/fd_poll_runtime.go:92
internal/poll.(*FD).Read(0x45ac190, 0x14639000, 0x1000, 0x1000, 0x0, 0x0, 0x0)
	/usr/local/go/src/internal/poll/fd_unix.go:169 +0x178
net.(*netFD).Read(0x45ac190, 0x14639000, 0x1000, 0x1000, 0xaa4bc01, 0x0, 0x33e21c)
	/usr/local/go/src/net/fd_unix.go:202 +0x38
net.(*conn).Read(0xe858840, 0x14639000, 0x1000, 0x1000, 0x0, 0x0, 0x0)
	/usr/local/go/src/net/net.go:184 +0x58
net/http.(*connReader).Read(0x48e0ce0, 0x14639000, 0x1000, 0x1000, 0x7, 0x2b4a4c8, 0x0)
	/usr/local/go/src/net/http/server.go:785 +0x15c
bufio.(*Reader).fill(0xcf74000)
	/usr/local/go/src/bufio/bufio.go:100 +0x108
bufio.(*Reader).Peek(0xcf74000, 0x4, 0x0, 0x0, 0x0, 0x0, 0x0)
	/usr/local/go/src/bufio/bufio.go:138 +0x38
net/http.(*conn).readRequest(0x10910c00, 0x1eaf2f0, 0x48e0cc0, 0x0, 0x0, 0x0)
	/usr/local/go/src/net/http/server.go:962 +0xae8
net/http.(*conn).serve(0x10910c00, 0x1eaf2f0, 0x48e0cc0)
	/usr/local/go/src/net/http/server.go:1817 +0x644
created by net/http.(*Server).Serve
	/usr/local/go/src/net/http/server.go:2928 +0x2e4
[cont-finish.d] executing container finish scripts...
[cont-finish.d] 99-message.sh: executing... 
[cont-finish.d] 99-message.sh: exited 0.
[cont-finish.d] done.
[s6-finish] waiting for services.
[s6-finish] sending all processes the TERM signal.

Same pb here :frowning:

Hi Frenck.
I see this is been asked before, but is it possible to enable collectd for influxd.
I still running a influxd on my old server, but it’s dying and the only reason i keep it alive is for my influxd +collectd instance.

I have several openwrt access points and other devices logging data to influxd through collectd.

Would be nice if i could use the influxd from ha os.

Thanks,

Stefan

1 Like

I’m a bit confused :slight_smile:

In the docs it says :
There is currently support for the following device types within Home Assistant:

  • Sensors

And at the same time it adds pretty much everything to influxdb if you don’t exclude.

As far as I can se, there is also no values/data added to other things than sensors.

So If I get it right, If I would like to get some data on for example when a light is turned on/off I would have to first make a sensor to log it i influxdb?

If that is the case, why are entities from other domains than sensors added at all by default?

Edit, found how to find values of other entities than sensors. The right query solved it…

But still curious about the docs stating it supports sensors.

Can someone tell me if i backup the InfluxdB to a snapshot while running. Will that corrupt the database (like MariaDB) or will this be no problem?

As far as I can tell, all snapshots are taken at file level. That is not ideal for any live database with its mechanisms for locks, commits, rollbacks, etc. So I’m not surprised that you experienced failures when creating or restoring your backup. I don’t see why this would be any better for InfluxDB.

If you have access to the docker image, then you could deploy native backup tools like mysqldump. Alas, with a supervised installation I only know of a manual backup via the phpMyAdmin add-on. Hoping someone knows how to automate that.

What I do now is make backups with Nextcloud Backup Add-on.
Inside the Add-on you can select what add-on you want stop before the backup
When backup is done, it start the addons again.

Would be ok as well I guess?

That’s not ideal, either. Assuming your MariaDB holds the HA data, then you essentially pause the entire system between stop and start of that add-on.

If you add InfluxDB, don’t you in effect have a live backup of your important state data? What are the chances that both DBs fail to restore from a snapshot?

Do you have more information on this add-on? Link to repository maybe?

What I found is backup the databases with his command:

docker exec -it addon_a0d7b954_influxdb influxd backup -portable -db dsmr_reader /opt/data
docker exec -it addon_a0d7b954_influxdb influxd backup -portable -db glances /opt/data
docker exec -it addon_a0d7b954_influxdb influxd backup -portable -db homeassistant /opt/data
docker exec -it addon_a0d7b954_influxdb influxd backup -portable -db _internal /opt/data

docker cp addon_a0d7b954_influxdb:/opt/data/ ./

This will backup my 4 database and the last command copy the backup to my local location.
Now I doesn’t have to backup the InfluxDB into a snapshot.

Now have to find the right way how to restore when needed.

OK, so I can setup a bucket and use flux QL? And use that in Grafana Add On?

I’d like to be able to use timeshift() function. Because something simple as multiple bars next to each other isn’t even possible in an easy way with these (way too) advanced tools…

Something like this:

1 Like

How would I import and export data to/from this InfluxDB instance? I have a backup which I need to restore and would normally do this from the command line, but in this case I don’t know how to access it.

1 Like

Hi,

quite new on Home Assistant… I understood that Add-ons can be installed “easily” only if running Hassio / Supervisor. I’m running Home Assistant Core on raspberry, is there a way to install InfluxDB manually?

Thanks

Hi! I have a device that can sends data to influxdb, using 2.xx api as I understand. i need to fill fields in device UI such as URL, Token, ORG and bucket.
Can I set up Homeassistant so it can receive data from device?
Please help with that if it possible.

Did you find out?

How would I get “inside the add-on container”?
I have this installation " Home Assistant Operating System" of the page Installation - Home Assistant

No. Ended up running Influx alongside OH on a separate virtual machine.

You have to execute a shell from inside the docker container. For instance: docker exec -it <mycontainer> bash.