1. I have a 2+ GB repo which I committed to today, to reach rev 357
2. I then attempted to use a SQL database in the checkout, which turned
   out to be corrupt. When importing in MariaDB, it complained about a
   null char in the database
3. The database was last committed at r335. I know it hasn't changed
   since r335, and 'svn log' shows r335 as the last commit, two months
   ago. I have imported the database on several occasions since then,
   without problems, when building a VM
4. I then checked out the entire project at r335 to find out if the
   database has changed. If I do a standard diff of the database in
   r357 and r335 /they are different/. They are the same size, but the
   r357 version contains binary non-printing data, which is why MariaDB
   doesn't like it
5. After the r357 checkin today, I modified one text file. I deleted
   this, and did an 'svn update' at the top level, to get a clean r357
6. In the current checkout, 'svn status' shows no modifications. If I
   run 'svn diff -r335 my-database.sql' /this reports no differences/.
   So, svn thinks the new and old databases are identical, but the
   plain diff clearly shows they are different
 7.  I then did a new complete checkout of the entire project at r357.
   /The database in this new checkout is correct/ - it's identical to
   the r335 version
8. The repo looks good - 'svnadmin dump' doesn't complain, anyway
9. db/fs-type says fsfs
10. Both the checkout and the repo are on the same machine, using
   WebDAV, version 1.14.1 (r1886195), Ubuntu 22.04
11. There are some changes in the .svn directory between the "current"
   r357 and the just-checked-out r357
12. This is a WordPress database. 'file' reports it as UTF-8 text, and
   'wc -L' reports a maximum line length of 693319 characters. It
   doesn't have an svn:mime-type property.

*Conclusion: it's possible that a checkout can be corrupted in a way that bypasses detection by svn itself*. Is this a reasonable conclusion, or have I missed something? Is there a maximum line length limit for a "text" file?

Reply via email to