Re: [sqlite] Network share & disk I/O error

2018-07-12 Thread Robert M. Münch
On 12 Jul 2018, at 19:11, Richard Hipp wrote: > When network filesystems do not follow the usual semantics of a > filesystem, it can cause problems. > > That said, Firefox and Chrome have for many years stored lots of stuff > in SQLite database files in the users home directory, which is often a

Re: [sqlite] Network share & disk I/O error

2018-07-12 Thread Stephen Chrzanowski
With Richards comment, the only additional thing I'd weigh in on is what your remote file server is doing with the physical file. Virus scanners can interfere with the usual operation of your program, and can cause certain things to happen. Because the OS you're running your software on is told

Re: [sqlite] Network share & disk I/O error

2018-07-12 Thread Richard Hipp
On 7/12/18, Robert M. Münch wrote: > > We now saw two crash reports with „Database disk I/O error“ when a > transaction was closed with „END“. Is this a known problem when having > sqlite files on a network share? > When network filesystems do not follow the usual semantics of a filesystem, it

[sqlite] Network share & disk I/O error

2018-07-12 Thread Robert M. Münch
Hi, Context: Users of our app can define a working directory where sqlite files are stored. This can be a network share. The files are only used by one user at the time. We now saw two crash reports with „Database disk I/O error“ when a transaction was closed with „END“. Is this a known