Core: Setup failed for recorder: libmariadbclient.so.18: cannot open shared object file

[marc-romu]

Home Assistant release with the issue:
0.96.5

Last working Home Assistant release (if known):
Older version of HA worked with Raspbian 9 (Stretch)

Operating environment (Hass.io/Docker/Windows/etc.):
Raspberry Pi 3 with Raspbian 10 (Buster). HA is running in a Python 3.7.4 virtual environment.

Component/platform:
recorder

Description of problem:
recorder component fails to initialize with this error:

ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: libmariadbclient.so.18: cannot open shared object file: No such file or directory (retrying in 3 seconds)

ERROR (MainThread) [homeassistant.setup] Setup failed for recorder: Integration failed to initialize.

Problem-relevant configuration.yaml entries:

recorder:
  db_url: mysql://user:[email protected]/database?charset=utf8
  purge_keep_days: 365
  purge_interval: 7
  include:
    domains:
      - [...]
    entities:
      - [...]

Traceback:
I firstly upgraded HA to the last version (0.96.5). Then, I upgraded my Rapsbian 9 to Rapsbian 10 following this instructions: https://www.maketecheasier.com/upgrade-raspberry-pi-raspbian-buster/. After that, everything worked fine except recorder component that fails to initialize with this error:

ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: libmariadbclient.so.18: cannot open shared object file: No such file or directory (retrying in 3 seconds)

This is the full log:

2019-07-31 11:28:23 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: libmariadbclient.so.18: cannot open shared object file: No such file or directory (retrying in 3 seconds)
2019-07-31 11:28:26 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: libmariadbclient.so.18: cannot open shared object file: No such file or directory (retrying in 3 seconds)
2019-07-31 11:28:29 WARNING (MainThread) [homeassistant.setup] Setup of recorder is taking over 10 seconds.
2019-07-31 11:28:29 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: libmariadbclient.so.18: cannot open shared object file: No such file or directory (retrying in 3 seconds)
2019-07-31 11:28:32 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: libmariadbclient.so.18: cannot open shared object file: No such file or directory (retrying in 3 seconds)
2019-07-31 11:28:35 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: libmariadbclient.so.18: cannot open shared object file: No such file or directory (retrying in 3 seconds)
2019-07-31 11:28:38 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: libmariadbclient.so.18: cannot open shared object file: No such file or directory (retrying in 3 seconds)
2019-07-31 11:28:41 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: libmariadbclient.so.18: cannot open shared object file: No such file or directory (retrying in 3 seconds)
2019-07-31 11:28:44 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: libmariadbclient.so.18: cannot open shared object file: No such file or directory (retrying in 3 seconds)
2019-07-31 11:28:48 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: libmariadbclient.so.18: cannot open shared object file: No such file or directory (retrying in 3 seconds)
2019-07-31 11:28:48 ERROR (MainThread) [homeassistant.setup] Setup failed for recorder: Integration failed to initialize.
2019-07-31 11:28:52 ERROR (MainThread) [homeassistant.setup] Unable to set up dependencies of history. Setup failed for dependencies: recorder
2019-07-31 11:28:52 ERROR (MainThread) [homeassistant.setup] Setup failed for history: Could not set up all dependencies.
2019-07-31 11:28:52 ERROR (MainThread) [homeassistant.setup] Unable to set up dependencies of history_graph. Setup failed for dependencies: history
2019-07-31 11:28:52 ERROR (MainThread) [homeassistant.setup] Setup failed for history_graph: Could not set up all dependencies.
2019-07-31 11:28:53 ERROR (MainThread) [homeassistant.setup] Unable to set up dependencies of logbook. Setup failed for dependencies: recorder
2019-07-31 11:28:53 ERROR (MainThread) [homeassistant.setup] Setup failed for logbook: Could not set up all dependencies.

I checked whether file libmariadbclient.so.18 existed with sudo find -iname libmariadbclient* and this was the output:

/usr/lib/arm-linux-gnueabihf/libmariadbclient.a
/usr/lib/arm-linux-gnueabihf/libmariadbclient.so
/usr/share/doc/libmariadbclient-dev
/var/lib/dpkg/info/libmariadbclient-dev:armhf.md5sums
/var/lib/dpkg/info/libmariadbclient-dev:armhf.list
/var/cache/apt/archives/libmariadbclient-dev_10.1.38-0+deb9u1_armhf.deb
/var/cache/apt/archives/libmariadbclient-dev_1%3a10.3.15-1_armhf.deb
/var/cache/apt/archives/libmariadbclient18_10.1.38-0+deb9u1_armhf.deb

File does not exist.

I tried to reinstall "libmariadbclient18" with sudo apt-get reinstall libmariadbclient18 and I got this message:

Package libmariadbclient18 is not available, but is referred to by another package.
This may mean that the package is missing, has been obsoleted, or is only available from another source
However the following packages replace it:
   libmariadb3

E: Package 'libmariadbclient18' has no installation candidate

Package libmariadb3 is already installed and upgraded to the latest version (10.3.15) and service mariadb is enabled. If I connect to my database via command line it works fine.

Any idea how to solve it? Thanks!

[u8915055]

I ran into the same problem. I am no guru here but tried the thing that seemed obvious to me. I created a symbolic link using the following in /usr/lib/arm-linux-gnueabihf/

sudo ln -s libmariadbclient.so libmariadbclient.so.18

Everything seems to be working now. Tables are being populated. Not sure if this has longer term negative effects but it got me up and running.

[marc-romu]

It works! Thank you very much!!
Maybe during Rapsbian upgrade this link got broken.