sqlite3.OperationalError: database is locked

2018年6月24日 07:12

  • 情景描述
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冲突
 
  • 解决
sudo mount -t cifs //192.168.10.12/coacs /opt/coacs -o username=wyq,password=sprite,vers=1.0,nobrl
 
nobrl 表示不向服务器发送对 byte range lock 的请求。
 
《寿康宝鉴》有声书
寿康宝鉴百话有声书(mp3)

 

评论(7) 阅读(4090)

sqlite客户端sqliteman

2015年5月06日 11:29

sqliteman是sqlite数据库的图形化管理工具

  • 安装
sudo yum install sqliteman
  • 启动
sqliteman

 

评论(1) 阅读(2448)