InfluxDb Python errors

Configuration
1

After settings op InfluxDb i keep ketting the following error in my home-assistant.log

2017-12-20 12:53:38 ERROR (Thread-9) [homeassistant.core] Error doing job: Future exception was never retrieved
Traceback (most recent call last):
File “/home/pi/homeassistant/lib/python3.4/site-packages/urllib3/connectionpool.py”, line 387, in _make_request
six.raise_from(e, None)
File “”, line 2, in raise_from
File “/home/pi/homeassistant/lib/python3.4/site-packages/urllib3/connectionpool.py”, line 383, in _make_request
httplib_response = conn.getresponse()
File “/usr/lib/python3.4/http/client.py”, line 1172, in getresponse
response.begin()
File “/usr/lib/python3.4/http/client.py”, line 351, in begin
version, status, reason = self._read_status()
File “/usr/lib/python3.4/http/client.py”, line 313, in _read_status
line = str(self.fp.readline(_MAXLINE + 1), “iso-8859-1”)
File “/usr/lib/python3.4/socket.py”, line 371, in readinto
return self._sock.recv_into(b)
socket.timeout: timed out

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File “/home/pi/homeassistant/lib/python3.4/site-packages/requests/adapters.py”, line 440, in send
timeout=timeout
File “/home/pi/homeassistant/lib/python3.4/site-packages/urllib3/connectionpool.py”, line 639, in urlopen
_stacktrace=sys.exc_info()[2])
File “/home/pi/homeassistant/lib/python3.4/site-packages/urllib3/util/retry.py”, line 357, in increment
raise six.reraise(type(error), error, _stacktrace)
File “/home/pi/homeassistant/lib/python3.4/site-packages/urllib3/packages/six.py”, line 686, in reraise
raise value
File “/home/pi/homeassistant/lib/python3.4/site-packages/urllib3/connectionpool.py”, line 601, in urlopen
chunked=chunked)
File “/home/pi/homeassistant/lib/python3.4/site-packages/urllib3/connectionpool.py”, line 389, in _make_request
self._raise_timeout(err=e, url=url, timeout_value=read_timeout)
File “/home/pi/homeassistant/lib/python3.4/site-packages/urllib3/connectionpool.py”, line 309, in _raise_timeout
raise ReadTimeoutError(self, url, “Read timed out. (read timeout=%s)” % timeout_value)
urllib3.exceptions.ReadTimeoutError: HTTPConnectionPool(host=‘127.0.0.1’, port=8086): Read timed out. (read timeout=5)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File “/usr/lib/python3.4/concurrent/futures/thread.py”, line 54, in run
result = self.fn(*self.args, **self.kwargs)
File “/home/pi/homeassistant/lib/python3.4/site-packages/homeassistant/components/influxdb.py”, line 225, in influx_event_listener
_write_data(json_body)
File “/home/pi/homeassistant/lib/python3.4/site-packages/homeassistant/components/influxdb.py”, line 312, in wrapper
scheduled()
File “/home/pi/homeassistant/lib/python3.4/site-packages/homeassistant/components/influxdb.py”, line 287, in scheduled
method(*args, **kwargs)
File “/home/pi/homeassistant/lib/python3.4/site-packages/homeassistant/components/influxdb.py”, line 231, in _write_data
influx.write_points(json_body)
File “/home/pi/homeassistant/lib/python3.4/site-packages/influxdb/client.py”, line 456, in write_points
tags=tags, protocol=protocol)
File “/home/pi/homeassistant/lib/python3.4/site-packages/influxdb/client.py”, line 506, in _write_points
protocol=protocol
File “/home/pi/homeassistant/lib/python3.4/site-packages/influxdb/client.py”, line 302, in write
headers=headers
File “/home/pi/homeassistant/lib/python3.4/site-packages/influxdb/client.py”, line 247, in request
timeout=self._timeout
File “/home/pi/homeassistant/lib/python3.4/site-packages/requests/sessions.py”, line 508, in request
resp = self.send(prep, **send_kwargs)
File “/home/pi/homeassistant/lib/python3.4/site-packages/requests/sessions.py”, line 618, in send
r = adapter.send(request, **kwargs)
File “/home/pi/homeassistant/lib/python3.4/site-packages/requests/adapters.py”, line 521, in send
raise ReadTimeout(e, request=request)
requests.exceptions.ReadTimeout: HTTPConnectionPool(host=‘127.0.0.1’, port=8086): Read timed out. (read timeout=5)
2017-12-20 12:54:05 ERROR (Thread-2) [homeassistant.core] Error doing job: Future exception was never retrieved
Traceback (most recent call last):
File “/home/pi/homeassistant/lib/python3.4/site-packages/urllib3/connectionpool.py”, line 387, in _make_request
six.raise_from(e, None)
File “”, line 2, in raise_from
File “/home/pi/homeassistant/lib/python3.4/site-packages/urllib3/connectionpool.py”, line 383, in _make_request
httplib_response = conn.getresponse()
File “/usr/lib/python3.4/http/client.py”, line 1172, in getresponse
response.begin()
File “/usr/lib/python3.4/http/client.py”, line 351, in begin
version, status, reason = self._read_status()
File “/usr/lib/python3.4/http/client.py”, line 313, in _read_status
line = str(self.fp.readline(_MAXLINE + 1), “iso-8859-1”)
File “/usr/lib/python3.4/socket.py”, line 371, in readinto
return self._sock.recv_into(b)
socket.timeout: timed out

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File “/home/pi/homeassistant/lib/python3.4/site-packages/requests/adapters.py”, line 440, in send
timeout=timeout
File “/home/pi/homeassistant/lib/python3.4/site-packages/urllib3/connectionpool.py”, line 639, in urlopen
_stacktrace=sys.exc_info()[2])
File “/home/pi/homeassistant/lib/python3.4/site-packages/urllib3/util/retry.py”, line 357, in increment
raise six.reraise(type(error), error, _stacktrace)
File “/home/pi/homeassistant/lib/python3.4/site-packages/urllib3/packages/six.py”, line 686, in reraise
raise value
File “/home/pi/homeassistant/lib/python3.4/site-packages/urllib3/connectionpool.py”, line 601, in urlopen
chunked=chunked)
File “/home/pi/homeassistant/lib/python3.4/site-packages/urllib3/connectionpool.py”, line 389, in _make_request
self._raise_timeout(err=e, url=url, timeout_value=read_timeout)
File “/home/pi/homeassistant/lib/python3.4/site-packages/urllib3/connectionpool.py”, line 309, in _raise_timeout
raise ReadTimeoutError(self, url, “Read timed out. (read timeout=%s)” % timeout_value)
urllib3.exceptions.ReadTimeoutError: HTTPConnectionPool(host=‘127.0.0.1’, port=8086): Read timed out. (read timeout=5)

setup the following in configuration.yaml:

influxdb:
  host: 127.0.0.1
  exclude:
   entities:
   - sensor.energy_consumption
   - sensor.power_consumption
   - sensor.pvoutput
2

This is the default Influxdb port, so your influxdb is not ready to receive data. Check that it is running and data is being sent to it.

Is the message happening continuously, or just occasionally?

3

Errors are returning a lot, each couple of minutes the errors are in the log. Can telnet 8086 perfect. Some data is perfect in the DB, some data not. Did exclude some sensors already, but does not solve the errors.

4

Seems to be the issue with the PVOutput component. Recreated the home_assistant InfluxDB without the PVOutput sensors and errors seems te be gone. Will test it from now on

5

What is PV output component?

6
7

Migraties from influxdb to mysql. No errors any more.