I know this is an old thread, but I see this error quite often with SVN
1.7. I am using Cornerstone 2.7.7 which uses SVN 1.7.5 internally. I get
corrupted working copies about once a month which of course ruins the
working copy and is very difficult to recover from in terms of wasted time.
I never had issues like this with SVN 1.6 and earlier. Not sure if it is
Cornerstone that is the issue, but it is bad that there are no safeguards
like transactional support to ensure that the database is never corrupted.
sqlite3 .svn/wc.db "pragma integrity_check"
*** in database main ***
Page 24268: btreeInitPage() returns error code 11
On tree page 6985 cell 3: Child page depth differs
On tree page 6985 cell 4: Child page depth differs
Error: database disk image is malformed
On Tuesday, November 15, 2011 10:39:56 AM UTC-7, Philip Martin wrote:
>
> Neil Bird <ne..._at_jibbyjobby.co.uk <javascript:>> writes:
>
> >> Copy NODES_COPY into NODES:
> >> sqlite3 .svn/wc.db "insert into NODES select * from NODES_COPY"
> >
> > Oops. “Error: database disk image is malformed”.
> >
> > Which is a bit odd, since we copied NODES to NODES_COPY OK, and have
> > since re-created NODES!
>
> Odd indeed. Some sort of lazy, copy-on-write copy perhaps? I think
> that means that the corruption extends beyond the indices into the nodes
> table, and that makes it very hard to recover.
>
> --
> Philip
>
>
Received on 2012-10-08 16:59:55 CEST