How to fix error: django.db.utils.NotSupportedError: URIs not supported

最新推荐文章于 2025-05-07 10:06:03 发布

mezhuangzhuang

最新推荐文章于 2025-05-07 10:06:03 发布

阅读量4.6k

点赞数 3

CC 4.0 BY-SA版权

分类专栏：服务器端

本文链接：https://blog.youkuaiyun.com/zhuangmezhuang/article/details/82776272

服务器端专栏收录该内容

6 篇文章

订阅专栏

本文详细记录了一个在使用Django框架时遇到的SQLite3数据库启动异常问题及其解决方案。问题表现为启动时出现NotSupportedError错误，通过修改源代码中的uri参数设置，成功解决了该问题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

这个问题呢，很操蛋，半个下午都在弄这个花里胡哨的问题，国内的博客，没看到有正面解决问题的，写的东西也不全，话都是一半一半的说。

看了一部分帖子，给了大概的想法，下面让我们来看一下这个问题的回答和具体的代码。

一、question：

 The above exception was the direct cause of the following exception:

  Traceback (most recent call last):
  File "/tech/poc/env/lib/python3.5/site-packages/django/utils/autoreload.py", line 228, in wrapper
    fn(*args, **kwargs)
  File "/tech/poc/env/lib/python3.5/site-packages/django/core/management/commands/runserver.py", line 128, in inner_run
    self.check_migrations()
  File "/tech/poc/env/lib/python3.5/site-packages/django/core/management/base.py", line 422, in check_migrations
    executor = MigrationExecutor(connections[DEFAULT_DB_ALIAS])
  File "/tech/poc/env/lib/python3.5/site-packages/django/db/migrations/executor.py", line 20, in __init__
    self.loader = MigrationLoader(self.connection)
  File "/tech/poc/env/lib/python3.5/site-packages/django/db/migrations/loader.py", line 52, in __init__
    self.build_graph()
  File "/tech/poc/env/lib/python3.5/site-packages/django/db/migrations/loader.py", line 209, in build_graph
    self.applied_migrations = recorder.applied_migrations()
  File "/tech/poc/env/lib/python3.5/site-packages/django/db/migrations/recorder.py", line 65, in applied_migrations
    self.ensure_schema()
  File "/tech/poc/env/lib/python3.5/site-packages/django/db/migrations/recorder.py", line 52, in ensure_schema
    if self.Migration._meta.db_table in self.connection.introspection.table_names(self.connection.cursor()):
  File "/tech/poc/env/lib/python3.5/site-packages/django/db/backends/base/base.py", line 254, in cursor
    return self._cursor()
  File "/tech/poc/env/lib/python3.5/site-packages/django/db/backends/base/base.py", line 229, in _cursor
    self.ensure_connection()
  File "/tech/poc/env/lib/python3.5/site-packages/django/db/backends/base/base.py", line 213, in ensure_connection
    self.connect()
  File "/tech/poc/env/lib/python3.5/site-packages/django/db/utils.py", line 94, in __exit__
    six.reraise(dj_exc_type, dj_exc_value, traceback)
  File "/tech/poc/env/lib/python3.5/site-packages/django/utils/six.py", line 685, in reraise
    raise value.with_traceback(tb)
  File "/tech/poc/env/lib/python3.5/site-packages/django/db/backends/base/base.py", line 213, in ensure_connection
    self.connect()
  File "/tech/poc/env/lib/python3.5/site-packages/django/db/backends/base/base.py", line 189, in connect
    self.connection = self.get_new_connection(conn_params)
  File "/tech/poc/env/lib/python3.5/site-packages/django/db/backends/sqlite3/base.py", line 198, in get_new_connection
    conn = Database.connect(**conn_params)
django.db.utils.NotSupportedError: URIs not supported

二、answer：I have the same problem, it's broke on my machine, but all my co-workers don't get the bug. I debugged in django's code, and found that in django.db.backends.sqlite3.base on about line 194 it sets uri True. If i comment that out, it works.

这个answer没有直面说解决方法，说了问题的出现在哪里，就是在这个base.py的大概194行左右，有个True。这里出了问题。

但是并没有告诉你怎么修改这里的代码。

三、solution：原因分析，这是sqlite3版本3.7的通病，安装3.8的就可以，这里我采用修改源码的方式，直接打开。

"/home/python3/lib/python3.6/site-packages/django/db/backends/sqlite3/base.py"这个文件，修改修改大概198行，通过搜索uri查找。

# between multiple threads. The safe-guarding will be handled at a
        # higher level by the `BaseDatabaseWrapper.allow_thread_sharing`
        # property. This is necessary as the shareability is disabled by
        # default in pysqlite and it cannot be changed once a connection is
        # opened.
        if 'check_same_thread' in kwargs and kwargs['check_same_thread']:
            warnings.warn(
                'The `check_same_thread` option was provided and set to '
                'True. It will be overridden with False. Use the '
                '`DatabaseWrapper.allow_thread_sharing` property instead '
                'for controlling thread shareability.',
                RuntimeWarning
            )
        kwargs.update({'check_same_thread': False})
        if self.features.can_share_in_memory_db:
            kwargs.update({'uri': False})  #这里原来是True，修改为False就可以了
        return kwargs

把上面的uri对应True修改为False就ok了。