sqlite3.OperationalError: database is locked

最新推荐文章于 2024-10-27 10:27:13 发布

whatday

最新推荐文章于 2024-10-27 10:27:13 发布

阅读量5.3k

点赞数 1

本文描述了在Windows上设置共享目录并将其mount到Linux系统中运行Python代码时遇到的SQLite3与SMB锁冲突问题。通过设置nobr选项避免了服务器上的byterangelock请求，解决了databaseislocked的错误。

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

情景描述

windows上代码文件，设置为共享目录，mount到linux使用。运行python manage.py migrate，出现错误

报错

[root@localhost sqlalchemy]# python manage.py db migrate
/root/py_env/coacs/lib/python3.6/site-packages/flask_sqlalchemy/__init__.py:794: FSADeprecationWarning: SQLALCHEMY_TRACK_MODIFICATIONS adds significant overhead and will be disabled by default in the future.  Set it to True or False to suppress this warning.
  'SQLALCHEMY_TRACK_MODIFICATIONS adds significant overhead and '
INFO  [alembic.runtime.migration] Context impl SQLiteImpl.
INFO  [alembic.runtime.migration] Will assume non-transactional DDL.
Traceback (most recent call last):
  File "/root/py_env/coacs/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
    context)
  File "/root/py_env/coacs/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 508, in do_execute
    cursor.execute(statement, parameters)
sqlite3.OperationalError: database is locked

原因

sqlite3与smb的lock冲突

解决

mount -t cifs //192.168.1.121/coacs /opt/coacs -o username=username,password=password,nobrl
nobrl 表示不向服务器发送对 byte range lock 的请求。