sgilbertson / sqlite4java

Automatically exported from code.google.com/p/sqlite4java
0 stars 0 forks source link

Disk I/O error - error 3850 #62

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
Please describe the problem
Disk SQL error 3850 Disk I/O error on any read or write to a Network Drive.

The application, libsqlite4java-osx-10.4.jnilib and sqlite data are on the 
remote Network Drive.
Mac 10.9: Connect via SMB to the network drive
Run the program any read gets the error.

I think its in the way libsqlite4java-osx-10.4.jnilib handles disk writing.

Original issue reported on code.google.com by stho...@torcula.com on 30 May 2014 at 10:27

GoogleCodeExporter commented 9 years ago
Thanks for posting info on this. I managed to reproduce this problem. However, 
I don't think it is specific to sqlite4java wrapper.

Is your SMB drive hosted by Windows? There are multiple indications on the 
Internet that it doesn't work. Regardless of the host operating system, using a 
network file system for hosting Sqlite database is not a good idea:

http://sqlite.org/faq.html#q5
http://sqlite.1065341.n5.nabble.com/How-to-make-SQLite-run-safely-on-CIFS-mounte
d-file-system-td37415.html

We will soon upgrade sqlite4java with the latest binaries of SQLite, maybe this 
error will be gone; but the problems with such configuration are expected to 
continue.

Kind regards,
Igor

Original comment by ser...@almworks.com on 15 Jun 2014 at 9:35