0x2620
/
openmedialibrary
1
0
Fork 0
Code Issues 131 Pull Requests Releases Wiki Activity

Import repeatedly fails with "database locked" error #34

New Issue
Closed
opened 2016-01-04 06:46:22 +00:00 by somebody · 0 comments
somebody commented 2016-01-04 06:46:22 +00:00
Owner
Copy Link
2016-01-04 12:14:56,195:DEBUG:tasks:task failed
Traceback (most recent call last):
> File "/Users/rolux/Library/Application Support/Open Media Library/platform/Darwin/lib/python3.5/site-packages/sqlalchemy/engine/base.py", line 951, in _execute_context
    context)
> File "/Users/rolux/Library/Application Support/Open Media Library/platform/Darwin/lib/python3.5/site-packages/sqlalchemy/engine/default.py", line 436, in do_execute
    cursor.execute(statement, parameters)
sqlite3.OperationalError: database is locked

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

Traceback (most recent call last):
> File "oml/tasks.py", line 34, in run
    item.scan.run_import(data)
> File "oml/item/scan.py", line 180, in run_import
    file = add_file(id, f, prefix_books, f_import)
> File "oml/item/scan.py", line 63, in add_file
    Scrape.get_or_create(item.id)
> File "oml/item/models.py", line 614, in get_or_create
    t.save()
> File "oml/item/models.py", line 619, in save
    state.db.session.commit()
> File "/Users/rolux/Library/Application Support/Open Media Library/platform/Darwin/lib/python3.5/site-packages/sqlalchemy/orm/session.py", line 776, in commit
    self.transaction.commit()
> File "/Users/rolux/Library/Application Support/Open Media Library/platform/Darwin/lib/python3.5/site-packages/sqlalchemy/orm/session.py", line 377, in commit
    self._prepare_impl()
> File "/Users/rolux/Library/Application Support/Open Media Library/platform/Darwin/lib/python3.5/site-packages/sqlalchemy/orm/session.py", line 357, in _prepare_impl
    self.session.flush()
> File "/Users/rolux/Library/Application Support/Open Media Library/platform/Darwin/lib/python3.5/site-packages/sqlalchemy/orm/session.py", line 1919, in flush
    self._flush(objects)
> File "/Users/rolux/Library/Application Support/Open Media Library/platform/Darwin/lib/python3.5/site-packages/sqlalchemy/orm/session.py", line 2037, in _flush
    transaction.rollback(_capture_exception=True)
> File "/Users/rolux/Library/Application Support/Open Media Library/platform/Darwin/lib/python3.5/site-packages/sqlalchemy/util/langhelpers.py", line 60, in *exit*
    compat.reraise(exc_type, exc_value, exc_tb)
> File "/Users/rolux/Library/Application Support/Open Media Library/platform/Darwin/lib/python3.5/site-packages/sqlalchemy/util/compat.py", line 182, in reraise
    raise value
> File "/Users/rolux/Library/Application Support/Open Media Library/platform/Darwin/lib/python3.5/site-packages/sqlalchemy/orm/session.py", line 2001, in _flush
    flush_context.execute()
> File "/Users/rolux/Library/Application Support/Open Media Library/platform/Darwin/lib/python3.5/site-packages/sqlalchemy/orm/unitofwork.py", line 372, in execute
    rec.execute(self)
> File "/Users/rolux/Library/Application Support/Open Media Library/platform/Darwin/lib/python3.5/site-packages/sqlalchemy/orm/unitofwork.py", line 526, in execute
    uow
> File "/Users/rolux/Library/Application Support/Open Media Library/platform/Darwin/lib/python3.5/site-packages/sqlalchemy/orm/persistence.py", line 65, in save_obj
    mapper, table, insert)
> File "/Users/rolux/Library/Application Support/Open Media Library/platform/Darwin/lib/python3.5/site-packages/sqlalchemy/orm/persistence.py", line 570, in _emit_insert_statements
    execute(statement, multiparams)
> File "/Users/rolux/Library/Application Support/Open Media Library/platform/Darwin/lib/python3.5/site-packages/sqlalchemy/engine/base.py", line 729, in execute
    return meth(self, multiparams, params)
> File "/Users/rolux/Library/Application Support/Open Media Library/platform/Darwin/lib/python3.5/site-packages/sqlalchemy/sql/elements.py", line 321, in _execute_on_connection
    return connection._execute_clauseelement(self, multiparams, params)
> File "/Users/rolux/Library/Application Support/Open Media Library/platform/Darwin/lib/python3.5/site-packages/sqlalchemy/engine/base.py", line 826, in _execute_clauseelement
    compiled_sql, distilled_params
> File "/Users/rolux/Library/Application Support/Open Media Library/platform/Darwin/lib/python3.5/site-packages/sqlalchemy/engine/base.py", line 958, in _execute_context
    context)
> File "/Users/rolux/Library/Application Support/Open Media Library/platform/Darwin/lib/python3.5/site-packages/sqlalchemy/engine/base.py", line 1160, in _handle_dbapi_exception
    exc_info
> File "/Users/rolux/Library/Application Support/Open Media Library/platform/Darwin/lib/python3.5/site-packages/sqlalchemy/util/compat.py", line 188, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb, cause=exc_value)
> File "/Users/rolux/Library/Application Support/Open Media Library/platform/Darwin/lib/python3.5/site-packages/sqlalchemy/util/compat.py", line 181, in reraise
    raise value.with_traceback(tb)
> File "/Users/rolux/Library/Application Support/Open Media Library/platform/Darwin/lib/python3.5/site-packages/sqlalchemy/engine/base.py", line 951, in _execute_context
    context)
> File "/Users/rolux/Library/Application Support/Open Media Library/platform/Darwin/lib/python3.5/site-packages/sqlalchemy/engine/default.py", line 436, in do_execute
    cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (OperationalError) database is locked 'INSERT INTO scrape (item_id, added) VALUES (?, ?)' ('SAWMHDHBQYPH6FKNCX4ZDOP5KU7MK77U', '2016-01-04 06:44:49.468835')
``` 2016-01-04 12:14:56,195:DEBUG:tasks:task failed Traceback (most recent call last): > File "/Users/rolux/Library/Application Support/Open Media Library/platform/Darwin/lib/python3.5/site-packages/sqlalchemy/engine/base.py", line 951, in _execute_context context) > File "/Users/rolux/Library/Application Support/Open Media Library/platform/Darwin/lib/python3.5/site-packages/sqlalchemy/engine/default.py", line 436, in do_execute cursor.execute(statement, parameters) sqlite3.OperationalError: database is locked The above exception was the direct cause of the following exception: Traceback (most recent call last): > File "oml/tasks.py", line 34, in run item.scan.run_import(data) > File "oml/item/scan.py", line 180, in run_import file = add_file(id, f, prefix_books, f_import) > File "oml/item/scan.py", line 63, in add_file Scrape.get_or_create(item.id) > File "oml/item/models.py", line 614, in get_or_create t.save() > File "oml/item/models.py", line 619, in save state.db.session.commit() > File "/Users/rolux/Library/Application Support/Open Media Library/platform/Darwin/lib/python3.5/site-packages/sqlalchemy/orm/session.py", line 776, in commit self.transaction.commit() > File "/Users/rolux/Library/Application Support/Open Media Library/platform/Darwin/lib/python3.5/site-packages/sqlalchemy/orm/session.py", line 377, in commit self._prepare_impl() > File "/Users/rolux/Library/Application Support/Open Media Library/platform/Darwin/lib/python3.5/site-packages/sqlalchemy/orm/session.py", line 357, in _prepare_impl self.session.flush() > File "/Users/rolux/Library/Application Support/Open Media Library/platform/Darwin/lib/python3.5/site-packages/sqlalchemy/orm/session.py", line 1919, in flush self._flush(objects) > File "/Users/rolux/Library/Application Support/Open Media Library/platform/Darwin/lib/python3.5/site-packages/sqlalchemy/orm/session.py", line 2037, in _flush transaction.rollback(_capture_exception=True) > File "/Users/rolux/Library/Application Support/Open Media Library/platform/Darwin/lib/python3.5/site-packages/sqlalchemy/util/langhelpers.py", line 60, in *exit* compat.reraise(exc_type, exc_value, exc_tb) > File "/Users/rolux/Library/Application Support/Open Media Library/platform/Darwin/lib/python3.5/site-packages/sqlalchemy/util/compat.py", line 182, in reraise raise value > File "/Users/rolux/Library/Application Support/Open Media Library/platform/Darwin/lib/python3.5/site-packages/sqlalchemy/orm/session.py", line 2001, in _flush flush_context.execute() > File "/Users/rolux/Library/Application Support/Open Media Library/platform/Darwin/lib/python3.5/site-packages/sqlalchemy/orm/unitofwork.py", line 372, in execute rec.execute(self) > File "/Users/rolux/Library/Application Support/Open Media Library/platform/Darwin/lib/python3.5/site-packages/sqlalchemy/orm/unitofwork.py", line 526, in execute uow > File "/Users/rolux/Library/Application Support/Open Media Library/platform/Darwin/lib/python3.5/site-packages/sqlalchemy/orm/persistence.py", line 65, in save_obj mapper, table, insert) > File "/Users/rolux/Library/Application Support/Open Media Library/platform/Darwin/lib/python3.5/site-packages/sqlalchemy/orm/persistence.py", line 570, in _emit_insert_statements execute(statement, multiparams) > File "/Users/rolux/Library/Application Support/Open Media Library/platform/Darwin/lib/python3.5/site-packages/sqlalchemy/engine/base.py", line 729, in execute return meth(self, multiparams, params) > File "/Users/rolux/Library/Application Support/Open Media Library/platform/Darwin/lib/python3.5/site-packages/sqlalchemy/sql/elements.py", line 321, in _execute_on_connection return connection._execute_clauseelement(self, multiparams, params) > File "/Users/rolux/Library/Application Support/Open Media Library/platform/Darwin/lib/python3.5/site-packages/sqlalchemy/engine/base.py", line 826, in _execute_clauseelement compiled_sql, distilled_params > File "/Users/rolux/Library/Application Support/Open Media Library/platform/Darwin/lib/python3.5/site-packages/sqlalchemy/engine/base.py", line 958, in _execute_context context) > File "/Users/rolux/Library/Application Support/Open Media Library/platform/Darwin/lib/python3.5/site-packages/sqlalchemy/engine/base.py", line 1160, in _handle_dbapi_exception exc_info > File "/Users/rolux/Library/Application Support/Open Media Library/platform/Darwin/lib/python3.5/site-packages/sqlalchemy/util/compat.py", line 188, in raise_from_cause reraise(type(exception), exception, tb=exc_tb, cause=exc_value) > File "/Users/rolux/Library/Application Support/Open Media Library/platform/Darwin/lib/python3.5/site-packages/sqlalchemy/util/compat.py", line 181, in reraise raise value.with_traceback(tb) > File "/Users/rolux/Library/Application Support/Open Media Library/platform/Darwin/lib/python3.5/site-packages/sqlalchemy/engine/base.py", line 951, in _execute_context context) > File "/Users/rolux/Library/Application Support/Open Media Library/platform/Darwin/lib/python3.5/site-packages/sqlalchemy/engine/default.py", line 436, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.OperationalError: (OperationalError) database is locked 'INSERT INTO scrape (item_id, added) VALUES (?, ?)' ('SAWMHDHBQYPH6FKNCX4ZDOP5KU7MK77U', '2016-01-04 06:44:49.468835') ```
rlx added the
major
defect
 labels 2016-01-04 06:46:22 +00:00
rlx changed title from Import repeadedly fails with "database locked" error to Import repeatedly fails with "database locked" error 2016-01-04 12:56:44 +00:00
rlx added the
worksforme
 label 2016-01-12 09:08:27 +00:00
rlx closed this issue 2016-01-12 09:08:27 +00:00
rlx added this to the M2 (now) milestone 2016-01-16 05:47:54 +00:00
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
master
Labels
Clear labels   
1.0

   
2.0

   
critical

   
defect

   
duplicate

   
enhancement

   
fixed

   
invalid

   
major

   
minor

   
task

   
trivial

   
wontfix

   
worksforme
No Label
1.0
2.0
critical
defect
duplicate
enhancement
fixed
invalid
major
minor
task
trivial
wontfix
worksforme
Milestone
Clear milestone
No items
No Milestone
M2 (now)
Assignees
Clear assignees
No Assignees
1 Participants
Notifications
Due Date
The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: 0x2620/openmedialibrary#34
No description provided.
Delete Branch "%!s(<nil>)"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?