DataFrame client connection errors when trying to insert dataframes

[GurvanKervern]

• InfluxDB version: 1.6.4
• InfluxDB-python version: 5.2.0
• Python version: e.g. 3.8.5
• Operating system version: Ubuntu 20.04 & Debian 10

I am trying to insert a fairly small dataframe in Influxdb (9000 rows, 3 columns besides the timestamp) but I am getting connection errors, which seems to come from the library.

Influxdb is accessible on both servers, locally and remotely. There is no problem connecting with the command line, or even with the library to create a new database and switch to it, so the problem seems to be when inserting dataframes only (I have been able to insert data in line protocol format)

Here are exceptions and traceback :

Traceback (most recent call last): File "/usr/lib/python3/dist-packages/urllib3/connection.py", line 159, in _new_conn (self._dns_host, self.port), self.timeout, **extra_kw) File "/usr/lib/python3/dist-packages/urllib3/util/connection.py", line 57, in create_connection for res in socket.getaddrinfo(host, port, family, socket.SOCK_STREAM): File "/usr/lib/python3.7/socket.py", line 748, in getaddrinfo for res in _socket.getaddrinfo(host, port, family, type, proto, flags): socket.gaierror: [Errno -2] Name or service not known

During handling of the above exception, another exception occurred:

Traceback (most recent call last): File "/usr/lib/python3/dist-packages/urllib3/connectionpool.py", line 600, in urlopen chunked=chunked) File "/usr/lib/python3/dist-packages/urllib3/connectionpool.py", line 354, in _make_request conn.request(method, url, **httplib_request_kw) File "/usr/lib/python3.7/http/client.py", line 1260, in request self._send_request(method, url, body, headers, encode_chunked) File "/usr/lib/python3.7/http/client.py", line 1306, in _send_request self.endheaders(body, encode_chunked=encode_chunked) File "/usr/lib/python3.7/http/client.py", line 1255, in endheaders self._send_output(message_body, encode_chunked=encode_chunked) File "/usr/lib/python3.7/http/client.py", line 1030, in _send_output self.send(msg) File "/usr/lib/python3.7/http/client.py", line 970, in send self.connect() File "/usr/lib/python3/dist-packages/urllib3/connection.py", line 181, in connect conn = self._new_conn() File "/usr/lib/python3/dist-packages/urllib3/connection.py", line 168, in _new_conn self, "Failed to establish a new connection: %s" % e) urllib3.exceptions.NewConnectionError: <urllib3.connection.HTTPConnection object at 0x7f0e3aac56a0>: Failed to establish a new connection: [Errno -2] Name or service not known

During handling of the above exception, another exception occurred:

Traceback (most recent call last): File "/usr/lib/python3/dist-packages/requests/adapters.py", line 449, in send timeout=timeout File "/usr/lib/python3/dist-packages/urllib3/connectionpool.py", line 638, in urlopen _stacktrace=sys.exc_info()[2]) File "/usr/lib/python3/dist-packages/urllib3/util/retry.py", line 398, in increment raise MaxRetryError(_pool, url, error or ResponseError(cause)) urllib3.exceptions.MaxRetryError: HTTPConnectionPool(host='%3cinfluxdb.client.influxdbclient%20object%20at%200x7f0e3deaa1d0%3e', port=8086): Max retries exceeded with url: /write?db=dataframe2 (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0x7f0e3aac56a0>: Failed to establish a new connection: [Errno -2] Name or service not known'))

During handling of the above exception, another exception occurred:

Traceback (most recent call last): File "./testInfluxDf.py", line 23, in df_client.write_points(analyzer.df_dt_indexed_on_time, 'voltages', database='dataframe2') File "/usr/lib/python3/dist-packages/influxdb/_dataframe_client.py", line 138, in write_points protocol=protocol) File "/usr/lib/python3/dist-packages/influxdb/client.py", line 490, in write_points tags=tags, protocol=protocol) File "/usr/lib/python3/dist-packages/influxdb/client.py", line 551, in _write_points protocol=protocol File "/usr/lib/python3/dist-packages/influxdb/client.py", line 327, in write headers=headers File "/usr/lib/python3/dist-packages/influxdb/client.py", line 267, in request timeout=self._timeout File "/usr/lib/python3/dist-packages/requests/sessions.py", line 533, in request resp = self.send(prep, send_kwargs) File "/usr/lib/python3/dist-packages/requests/sessions.py", line 646, in send r = adapter.send(request, kwargs) File "/usr/lib/python3/dist-packages/requests/adapters.py", line 516, in send raise ConnectionError(e, request=request) requests.exceptions.ConnectionError: HTTPConnectionPool(host='%3cinfluxdb.client.influxdbclient%20object%20at%200x7f0e3deaa1d0%3e', port=8086): Max retries exceeded with url: /write?db=dataframe2 (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0x7f0e3aac56a0>: Failed to establish a new connection: [Errno -2] Name or service not known'))

[stephkod]

Hi @GurvanKervern . I have a very similar problem that arises when trying to push a dataframe from within a docker container. When running the script outside of the container everything works fine. When I curling my host from within the container it responds.

Have you found a solution?

[GurvanKervern]

hi @stephkod , I had to use a workaround : I generated line protocol files and inserted those