On 11 Jan 2016 1:30 PM, Bernardo Sulzbach wrote: >> What have folks here done to avoid the race condition originally described? >> I?ve seen some documentation of SQLite and hard links but > > Your message appears to be truncated.
Oops! Nothing earth-shattering ? I meant to put ?but didn?t think the avisos about links quite sounded like my situation?. > > What if you move the hard link creation part to right after the commit? The problem is that we didn?t actually see the corruption in internal testing and have never recreated it ourselves ? so, I have no way of knowing now whether anything really fixes the issue. We actually did implement out solution like that originally; the problem was that we were doing data import also prior to the hard-link creation, so for DBs with lots of data we were crashing servers. I didn?t consider, though, that schema creation might be more error-prone than importing data? Interesting. -FG
