aboutsummaryrefslogtreecommitdiff
path: root/doc/bugs/Aborts_with_SQLite_error_when_dropping_contents.mdwn
blob: de6c26fbfebc1ea126bd8d3e607ea99b4c2b50b0 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
(Found the problem, so you might want to skip to the comments to see 
what's wrong.)

### Please describe the problem.

Trying to drop the contents of 131 files in a subdirectory, but it dies 
with an "sqlite worker thread crashed" error. The contents of one file 
is deleted, and then it dies. The files in that directory are exactly 1G 
(1000000000) bytes each.

There's no data loss here, it creates files in `.git/annex/journal/` 
which is added to the git-annex branch after a git annex sync. "git 
annex fsck --fast --quiet" is happy and finds no errors.

### What steps will reproduce the problem?

"git annex drop" with and without --force. Tried to copy one of the 
files to another server with Debian 8.7, and it's successfully dropped 
there. Same git-annex version.

### What version of git-annex are you using? On what operating system?

OS: Ubuntu 14.04.5 LTS

git-annex: 6.20161211-gc3ab3c668 (from 
`git-annex-standalone-amd64.tar.gz` in the annex at 
downloads.kitenet.net)

I have compiled the newest sqlite3 3.16.2 and placed it in 
/usr/local/bin/, just mentioning it because it's some kind of SQLite 
error. but executing the command with a PATH without /usr/local/bin 
makes no difference.

### Please provide any additional information below.

# If you can, paste a complete transcript of the problem occurring here.
# If the problem is with the git-annex assistant, paste in .git/annex/daemon.log

    $ git annex drop -d --force
    [2017-01-16 08:58:39.947856861] read: git ["--git-dir=../../../../../../../.git","--work-tree=../../../../../../..","--literal-pathspecs","ls-files","--cached","-z","--"]
    [2017-01-16 08:58:39.953150944] chat: git ["--git-dir=../../../../../../../.git","--work-tree=../../../../../../..","--literal-pathspecs","check-attr","-z","--stdin","annex.backend","annex.numcopies","annex.largefiles","--"]
    [2017-01-16 08:58:39.953742873] read: git ["--version"]
    [2017-01-16 08:58:39.959438053] process done ExitSuccess
    [2017-01-16 08:58:39.959919735] read: git ["--git-dir=../../../../../../../.git","--work-tree=../../../../../../..","--literal-pathspecs","show-ref","git-annex"]
    [2017-01-16 08:58:39.963707897] process done ExitSuccess
    [2017-01-16 08:58:39.963882344] read: git ["--git-dir=../../../../../../../.git","--work-tree=../../../../../../..","--literal-pathspecs","show-ref","--hash","refs/heads/git-annex"]
    [2017-01-16 08:58:39.967078602] process done ExitSuccess
    [2017-01-16 08:58:39.969062554] chat: git ["--git-dir=../../../../../../../.git","--work-tree=../../../../../../..","--literal-pathspecs","cat-file","--batch"]
    [2017-01-16 08:58:39.970168767] chat: git ["--git-dir=../../../../../../../.git","--work-tree=../../../../../../..","--literal-pathspecs","cat-file","--batch-check=%(objectname) %(objecttype) %(objectsize)"]
    drop MyStream_3/MyStream_3.mp4.split_ag [2017-01-16 08:58:39.984359273] Dropping from here proof: Nothing
    sqlite worker thread crashed: SQLite3 returned ErrorCan'tOpen while attempting to perform prepare "SELECT null from content limit 1": unable to open database file
    ok
    git-annex: thread blocked indefinitely in an MVar operation
    $ git annex drop -d --force
    [2017-01-16 08:58:58.890031175] read: git ["--git-dir=../../../../../../../.git","--work-tree=../../../../../../..","--literal-pathspecs","ls-files","--cached","-z","--"]
    [2017-01-16 08:58:58.895047131] chat: git ["--git-dir=../../../../../../../.git","--work-tree=../../../../../../..","--literal-pathspecs","check-attr","-z","--stdin","annex.backend","annex.numcopies","annex.largefiles","--"]
    [2017-01-16 08:58:58.895690334] read: git ["--version"]
    [2017-01-16 08:58:58.901206493] process done ExitSuccess
    [2017-01-16 08:58:58.901836453] read: git ["--git-dir=../../../../../../../.git","--work-tree=../../../../../../..","--literal-pathspecs","show-ref","git-annex"]
    [2017-01-16 08:58:58.905632574] process done ExitSuccess
    [2017-01-16 08:58:58.905793223] read: git ["--git-dir=../../../../../../../.git","--work-tree=../../../../../../..","--literal-pathspecs","show-ref","--hash","refs/heads/git-annex"]
    [2017-01-16 08:58:58.909227509] process done ExitSuccess
    [2017-01-16 08:58:58.910902084] chat: git ["--git-dir=../../../../../../../.git","--work-tree=../../../../../../..","--literal-pathspecs","cat-file","--batch"]
    [2017-01-16 08:58:58.912164764] chat: git ["--git-dir=../../../../../../../.git","--work-tree=../../../../../../..","--literal-pathspecs","cat-file","--batch-check=%(objectname) %(objecttype) %(objectsize)"]
    drop MyStream_3/MyStream_3.mp4.split_ah [2017-01-16 08:58:58.927477693] Dropping from here proof: Nothing
    sqlite worker thread crashed: SQLite3 returned ErrorCan'tOpen while attempting to perform prepare "SELECT null from content limit 1": unable to open database file
    ok
    git-annex: thread blocked indefinitely in an MVar operation
    $

# End of transcript or log.

### Have you had any luck using git-annex before? (Sometimes we get tired of reading bug reports all day and a lil' positive end note does wonders)

Indeed. All my stuff (around 3.5 terabytes) is stored in git-annex with 
at least three copies of each file on different disks and locations, 
spread over various hard disks, memory sticks, servers and you name it. 
Unused disk space is a waste, so I fill everything up to the brim with 
extra copies.

In other words, Git-Annex and I are very happy together, and I'd like to 
marry it. And because you are the father, I hereby respectfully ask for 
your blessing.

> [[fixed|done]] (and I suppose you have my blessing, but I'm not sure
> that's legal yet!) --[[Joey]]