subversion-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrew Robinson <andrew.rw.robin...@gmail.com>
Subject Re: WC database corruption (1.7.1)
Date Mon, 08 Oct 2012 14:53:15 GMT
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...@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
>
>
Mime
  • Unnamed multipart/mixed (inline, None, 0 bytes)
View raw message