sqlite3 ModuleNotFoundError

[changliu-wk]

I am using auto-instrumentation, every time my container started to run, it has this log.

Traceback (most recent call last):
  File "/usr/local/lib/python3.9/site-packages/opentelemetry/instrumentation/auto_instrumentation/sitecustomize.py", line 122, in initialize
    _load_instrumentors(distro)
  File "/usr/local/lib/python3.9/site-packages/opentelemetry/instrumentation/auto_instrumentation/sitecustomize.py", line 88, in _load_instrumentors
    raise exc
  File "/usr/local/lib/python3.9/site-packages/opentelemetry/instrumentation/auto_instrumentation/sitecustomize.py", line 84, in _load_instrumentors
    distro.load_instrumentor(entry_point, skip_dep_check=True)
  File "/usr/local/lib/python3.9/site-packages/opentelemetry/instrumentation/distro.py", line 62, in load_instrumentor
    instrumentor: BaseInstrumentor = entry_point.load()
  File "/usr/local/lib/python3.9/site-packages/pkg_resources/__init__.py", line 2468, in load
    return self.resolve()
  File "/usr/local/lib/python3.9/site-packages/pkg_resources/__init__.py", line 2474, in resolve
    module = __import__(self.module_name, fromlist=['__name__'], level=0)
  File "/usr/local/lib/python3.9/site-packages/opentelemetry/instrumentation/sqlite3/__init__.py", line 42, in <module>
    import sqlite3
  File "/usr/local/lib/python3.9/sqlite3/__init__.py", line 57, in <module>
    from sqlite3.dbapi2 import *
  File "/usr/local/lib/python3.9/sqlite3/dbapi2.py", line 27, in <module>
    from _sqlite3 import *
ModuleNotFoundError: No module named '_sqlite3'

My understanding is the agent thought we are using sqlite3, so it will call opentelemetry-instrumentation-sqlite3/init.py, but in fact we didn't use it.

Is this a bug from otel Python auto-instrument?

[srikanthccv]

My understanding is the agent thought we are using sqlite3, so it will call opentelemetry-instrumentation-sqlite3/init.py, but in fact we didn't use it.

There is a list of instrumentation libraries that get installed by default. And the remaining instrumentations are conditionally installed by auto instrumentation based on the available third-party libraries in your env for which we have the instrumentation (eg flask).

Is this a bug from otel Python auto-instrument?

The assumption was that sqlite3 would be available. It looks like, in some cases, the sqlite-devel must be installed. We could update the auto instrumentation to catch the import errors.