Improve error message for when status db is locked

[aleprovencio]

Hello, lately I can't successfully vdirsyncer sync my calendars because of a
database is locked error. Synchronization works fine with android's davdroid which talks with the same server.

Your vdirsyncer version: 0.16.4
If applicable, which server software (and which version) you're using: Nextcloud 13
Your Python version: 3.6.4
Your operating system: Arch linux
Relevant debug output:

Syncing my_calendars/jucy
debug:   File "/usr/lib/python3.6/site-packages/vdirsyncer/cli/tasks.py", line 63, in sync_collection
debug:     collection.name) as status:
debug:   File "/usr/lib/python3.6/contextlib.py", line 81, in __enter__
debug:     return next(self.gen)
debug:   File "/usr/lib/python3.6/site-packages/vdirsyncer/cli/utils.py", line 227, in manage_sync_status
debug:     status = SqliteStatus(path)
debug:   File "/usr/lib/python3.6/site-packages/vdirsyncer/sync/status.py", line 119, in __init__
debug:     self._update_schema()
debug:   File "/usr/lib/python3.6/site-packages/vdirsyncer/sync/status.py", line 127, in _update_schema
debug:     with _exclusive_transaction(self._c) as c:
debug:   File "/usr/lib/python3.6/contextlib.py", line 81, in __enter__
debug:     return next(self.gen)
debug:   File "/usr/lib/python3.6/site-packages/vdirsyncer/sync/status.py", line 13, in _exclusive_transaction
debug:     c = conn.execute('BEGIN EXCLUSIVE TRANSACTION')
Syncing my_calendars/personal
debug:   File "/usr/lib/python3.6/site-packages/vdirsyncer/cli/tasks.py", line 63, in sync_collection
debug:     collection.name) as status:
debug:   File "/usr/lib/python3.6/contextlib.py", line 81, in __enter__
debug:     return next(self.gen)
debug:   File "/usr/lib/python3.6/site-packages/vdirsyncer/cli/utils.py", line 227, in manage_sync_status
debug:     status = SqliteStatus(path)
debug:   File "/usr/lib/python3.6/site-packages/vdirsyncer/sync/status.py", line 119, in __init__
debug:     self._update_schema()
debug:   File "/usr/lib/python3.6/site-packages/vdirsyncer/sync/status.py", line 127, in _update_schema
debug:     with _exclusive_transaction(self._c) as c:
debug:   File "/usr/lib/python3.6/contextlib.py", line 81, in __enter__
debug:     return next(self.gen)
debug:   File "/usr/lib/python3.6/site-packages/vdirsyncer/sync/status.py", line 13, in _exclusive_transaction
debug:     c = conn.execute('BEGIN EXCLUSIVE TRANSACTION')

[aleprovencio]

Not happening anymore, don't know why.
Sorry about the noise.

[untitaker]

Need to improve error message, reopening as reminder for follow-up issue. If you experience this again, you need to delete a special file in your status directory. I can't think of the exact name at the moment. Sorry for the slow response.

[christf]

I have this as well. which file should I delete?

[untitaker]

Sorry, I can't remember. Please check this page: https://sqlite.org/tempfiles.html Otherwise please give me a listing of the status dir and I can tell you.

…

On 22 February 2018 22:00:53 GMT+01:00, Christof Schulze ***@***.***> wrote: I have this as well. which file should I delete? -- You are receiving this because you modified the open/close state. Reply to this email directly or view it on GitHub: #720 (comment)

-- Sent from my Android device with K-9 Mail. Please excuse my brevity.

[untitaker]

I think I found the name, the filename ends with `journal`. Delete all files with that suffix (make sure no vdirsyncer process runs) and you should be fine.

…

On Thu, Feb 22, 2018 at 01:00:53PM -0800, Christof Schulze wrote: I have this as well. which file should I delete? -- You are receiving this because you modified the open/close state. Reply to this email directly or view it on GitHub: #720 (comment)

[christf]

@untitaker thank you - I did that
cd .vdirsyncer
find . -type f -name "*-journal" -exec rm {} ;
and it worked.

[bepolymathe]

@untitaker Same problem but it change nothing delete *-journal file in the status dir

[j605]

I have the same error but there are no -journal files in the status directory. For the three tasks that fail I get

debug:   File "/usr/lib/python3.7/site-packages/vdirsyncer/cli/tasks.py", line 63, in sync_collection
debug:     collection.name) as status:
debug:   File "/usr/lib/python3.7/contextlib.py", line 112, in __enter__
debug:     return next(self.gen)
debug:   File "/usr/lib/python3.7/site-packages/vdirsyncer/cli/utils.py", line 227, in manage_sync_status
debug:     status = SqliteStatus(path)
debug:   File "/usr/lib/python3.7/site-packages/vdirsyncer/sync/status.py", line 119, in __init__
debug:     self._update_schema()
debug:   File "/usr/lib/python3.7/site-packages/vdirsyncer/sync/status.py", line 127, in _update_schema
debug:     with _exclusive_transaction(self._c) as c:
debug:   File "/usr/lib/python3.7/contextlib.py", line 112, in __enter__
debug:     return next(self.gen)
debug:   File "/usr/lib/python3.7/site-packages/vdirsyncer/sync/status.py", line 13, in _exclusive_transaction
debug:     c = conn.execute('BEGIN EXCLUSIVE TRANSACTION')
error: 3 out of 11 tasks failed.

Any idea what can be done? I only have .collections and .items in the status directory.

Edit: Used https://stackoverflow.com/a/3481134. I had to kill a stray vdirsyncer process.

[doug-letough]

Same here after a connection loss.
Removing all items files did the trick:

find ./ -type f -name "*.items*" -exec rm {} \;

[surajsharma]

I had to kill a stray vdirsyncer process.

this did it for me

[dchersey]

same here ... ps -ef | grep vdir showed the process and kill -9 (pid) did the deed