Debian12下启动Jupyter Notebook遇pysqlite2缺失及sqlite3导入错误

环境与操作步骤 #

• 系统：Debian 12
• 操作流程：
  1. 在~/.venv目录下通过virtualenv创建虚拟环境
  2. 执行pip install jupyter安装Jupyter Notebook

启动Jupyter Notebook时的报错信息 #

(.venv) marcelaar@marcel:~$ jupyter notebook
Traceback (most recent call last):
  File "/home/marcelaar/.venv/lib/python3.11/site-packages/jupyter_server/services/sessions/sessionmanager.py", line 14, in <module>
    import sqlite3
  File "/usr/lib/python3.11/sqlite3/__init__.py", line 57, in <module>
    from sqlite3.dbapi2 import *
  File "/usr/lib/python3.11/sqlite3/dbapi2.py", line 27, in <module>
    from _sqlite3 import *
ImportError: /usr/lib/python3.11/lib-dynload/_sqlite3.cpython-311-x86_64-linux-gnu.so: undefined symbol: sqlite3_enable_load_extension

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/home/marcelaar/.venv/bin/jupyter-notebook", line 5, in <module>
    from notebook.app import main
  File "/home/marcelaar/.venv/lib/python3.11/site-packages/notebook/app.py", line 17, in <module>
    from jupyter_server.serverapp import flags
  File "/home/marcelaar/.venv/lib/python3.11/site-packages/jupyter_server/serverapp.py", line 107, in <module>
    from jupyter_server.gateway.managers import (
  File "/home/marcelaar/.venv/lib/python3.11/site-packages/jupyter_server/gateway/managers.py", line 33, in <module>
    from ..services.sessions.sessionmanager import SessionManager
  File "/home/marcelaar/.venv/lib/python3.11/site-packages/jupyter_server/services/sessions/sessionmanager.py", line 17, in <module>
    from pysqlite2 import dbapi2 as sqlite3  # type:ignore[no-redef]
    ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
ModuleNotFoundError: No module named 'pysqlite2'

尝试安装pysqlite2时的报错 #

ERROR: Could not find a version that satisfies the requirement pysqlite2 (from versions: none)
ERROR: No matching distribution found for pysqlite2

虚拟环境中手动导入sqlite3的报错 #

Python 3.11.2 (main, Mar 13 2023, 12:18:29) [GCC 12.2.0] on linux
Type "help", "copyright", "credits" or "license" for more information.
>>> import sqlite3
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "/usr/lib/python3.11/sqlite3/__init__.py", line 57, in <module>
    from sqlite3.dbapi2 import *
  File "/usr/lib/python3.11/sqlite3/dbapi2.py", line 27, in <module>
    from _sqlite3 import *
ImportError: /usr/lib/python3.11/lib-dynload/_sqlite3.cpython-311-x86_64-linux-gnu.so: undefined symbol: sqlite3_enable_load_extension
>>> 

需要解决上述问题，顺利启动Jupyter Notebook。

内容的提问来源于stack exchange，提问作者Marcel Alejandro Angulo Rosale