influxdb2 integration fails with panda error

[bvormwald]

The problem

I cannot add the integration for influxdb to homeassistant. I have a separate influxdb server (v2) and want to log the homeassistant data there. After editing the configuration.yaml, I fail reloading the configuration due to an 'exception in importing homeassistant.components.influxdb'. I attach my configuration.yaml as well as the detailed error messages from the log. there seems to be a problem with panda.

What version of Home Assistant Core has the issue?

core-2023.10.3

What was the last working version of Home Assistant Core?

No response

What type of installation are you running?

Home Assistant OS

Integration causing the issue

influxdb

Link to integration documentation on our website

https://www.home-assistant.io/integrations/influxdb

Diagnostics information

No response

Example YAML snippet

# Loads default set of integrations. Do not remove.
default_config:

# Load frontend themes from the themes folder
frontend:
  themes: !include_dir_merge_named themes

automation: !include automations.yaml
script: !include scripts.yaml
scene: !include scenes.yaml

influxdb:
  api_version: 2
  ssl: false
  host: XXXXXXXX
  port: 8086
  token: XXXXXXXX
  organization: XXXXXXXX
  bucket: homeassistant
  tags:
    source: HA
  tags_attributes:
    - friendly_name
  default_measurement: units

Anything in the logs that might be useful for us?

Logger: homeassistant.loader
Source: loader.py:818
First occurred: 12:44:46 AM (7 occurrences)
Last logged: 12:54:06 AM

Unexpected exception importing component homeassistant.components.influxdb
Traceback (most recent call last):
  File "/usr/src/homeassistant/homeassistant/loader.py", line 818, in get_component
    ComponentProtocol, importlib.import_module(self.pkg_path)
                       ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/importlib/__init__.py", line 126, in import_module
    return _bootstrap._gcd_import(name[level:], package, level)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "<frozen importlib._bootstrap>", line 1204, in _gcd_import
  File "<frozen importlib._bootstrap>", line 1176, in _find_and_load
  File "<frozen importlib._bootstrap>", line 1147, in _find_and_load_unlocked
  File "<frozen importlib._bootstrap>", line 690, in _load_unlocked
  File "<frozen importlib._bootstrap_external>", line 940, in exec_module
  File "<frozen importlib._bootstrap>", line 241, in _call_with_frames_removed
  File "/usr/src/homeassistant/homeassistant/components/influxdb/__init__.py", line 14, in <module>
    from influxdb import InfluxDBClient, exceptions
  File "/usr/local/lib/python3.11/site-packages/influxdb/__init__.py", line 10, in <module>
    from .dataframe_client import DataFrameClient
  File "/usr/local/lib/python3.11/site-packages/influxdb/dataframe_client.py", line 12, in <module>
    import pandas
  File "/usr/local/lib/python3.11/site-packages/pandas/__init__.py", line 46, in <module>
    from pandas.core.api import (
  File "/usr/local/lib/python3.11/site-packages/pandas/core/api.py", line 1, in <module>
    from pandas._libs import (
  File "/usr/local/lib/python3.11/site-packages/pandas/_libs/__init__.py", line 18, in <module>
    from pandas._libs.interval import Interval
  File "interval.pyx", line 1, in init pandas._libs.interval
  File "hashtable.pyx", line 1, in init pandas._libs.hashtable
  File "missing.pyx", line 42, in init pandas._libs.missing
AttributeError: partially initialized module 'pandas' has no attribute '_pandas_datetime_CAPI' (most likely due to a circular import)


Logger: homeassistant.components.homeassistant
Source: components/homeassistant/__init__.py:325
Integration: Home Assistant Core Integration (documentation, issues)
First occurred: 12:40:54 AM (4 occurrences)
Last logged: 1:10:53 AM

The system cannot reload because the configuration is not valid: Component error: influxdb - Exception importing homeassistant.components.influxdb

Additional information

No response

[home-assistant[bot]]

Hey there @mdegat01, mind taking a look at this issue as it has been labeled with an integration (influxdb) you are listed as a code owner for? Thanks!

Code owner commands

Code owners of influxdb can trigger bot actions by commenting:

• @home-assistant close Closes the issue.
• @home-assistant rename Awesome new title Renames the issue.
• @home-assistant reopen Reopen the issue.
• @home-assistant unassign influxdb Removes the current integration label and assignees on the issue, add the integration domain after the command.

_{^{(message by CodeOwnersMention)}}

---

influxdb documentation influxdb source _{^{(message by IssueLinks)}}

[issue-triage-workflows[bot]]

There hasn't been any activity on this issue recently. Due to the high number of incoming GitHub notifications, we have to clean some of the old issues, as many of them have already been resolved with the latest updates. Please make sure to update to the latest Home Assistant version and check if that solves the issue. Let us know if that works for you by adding a comment 👍 This issue has now been marked as stale and will be closed if no further activity occurs. Thank you for your contributions.