Tag Archives: sqlite3.OperationalError: database is locked

sqlite3.OperationalError: database is locked

Why can’t you grab tickets when you travel on holiday?Reveal the key technology of 12306 how to ensure the ticket is not oversold>>>

Scenario description

Windows code file, set as a shared directory, mount to Linux. Error running Python manage.py migrate

Error report

[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

reason

sqlite3 gives smb lock buffer

solution

sudo mount -t cifs //192.168.1.121/coacs /opt/coacs -o username=username,password=password,vers=1.0,nobrl

nobrl indicates that the request for byte range lock is not sent to the service.

“Life jewelry 37492.”

http://v.youku.com/v_show/id_XMzYxMzA4NDY2MA

Life jewelry 37492; hundreds of sounding flavors

100 pounds.

https://pan.baidu.com/s/1rs5k7RTB9DxgdCuG-mSzog 9lf1 password