sqlite3.OperationalError: database is locked
妙音
posted @ 2018年6月24日 07:12
in sqlite
, 4170 阅读
- 情景描述
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 的请求。
2020年12月20日 20:13
Hello I am so delighted I located your blog, I really located you by mistake, while I was watching on google for something else, Anyways I am here now and could just like to say thank for a tremendous post and a all round entertaining website. Please do keep up the great work. 먹튀검증사이트
2020年12月20日 21:44
Kerala State Board of Higher Secondary Education Department will be Schedule the Class 11th and 12th Standard Plus One and Plus Two annual Public Examination Dates in March to April every year, Department of School Examination will be Conducted the annual final Examination tests with only New Syllabus to the Malayalam and English Medium STD-1 and STD-2 Students as per the Board Published Textbooks. Now the Board of Higher Secondary Education has released the DHSE VHSE Blue Print of Sample Papers for all of Government and Private College Students to Guessing Examination Pattern from the DHSE Question Paper 2021.
2020年12月27日 00:30
I needed to thank you for this incredible read!! I unquestionably adored each and every piece of it. I have you bookmarked your site to look at the new stuff you post. سایت یلماس بت
2020年12月29日 17:25
Your post is very helpful to get some effective tips to reduce weight properly. You have shared various nice photos of the same. I would like to thank you for sharing these tips. Surely I will try this at home. Keep updating more simple tips like this. crystal meth online
2020年12月29日 17:53
Cool stuff you have got and you keep update all of us. agen idn poker
2021年1月03日 15:58
Thanks for the tips guys. They were all great. I have been having issues with being fat both mentally and physically. Thanks to you guys i have been showing improvements. Do post more. twitch reseller panel
2021年1月11日 13:57
Wow, cool post. I'd like to write like this too - taking time and real hard work to make a great article... but I put things off too much and never seem to get started. Thanks though. 먹튀검증커뮤니티