Re: subversion sqlite.c bug

Андрей Нагих <andrnag_at_yandex.ru> writes:

> I get this error while commiting to local fsfs svn repository.
>
> In file
> 'D:\Development\SVN\Releases\TortoiseSVN-1.7.4\ext\subversion\subversion\libsvn_subr\sqlite.c'
> line 187: assertion failed (stmt_idx < db->nbr_statements)
>
> May be the reason that I sync repository folder with Dropbox (I knew
> it's bad now)

It's probably the db/rep-cache.db file that is corrupt. Running

   sqlite3 db/rep-cache.db "pragma integrity_check"

may confirm this. Since it is only a cache you can remove the the
rep-cache.db file and a new empty cache will get created. That should
recover the repository. You may want to disable the use of rep-cache.db
(see rep-sharing in in db/fsfs.conf) if some non-sqlite-aware process is
writing to the repository.

-- 
Philip