On 23 Dec 2019, at 6:19am, Aydin Ozgur Yagmur <ayagmu...@gmail.com> wrote:
> I have been using sqlite database in linux by mounting. > Nearly all times it works well. But when testing with customer, I encounter > "No such column" error. SQLite does not support accessing the database drive across a network. No network file systems seem to implement file locking correctly, and if file locking doesn't work correctly, SQLite cannot function correctly. You may find errors like the one you reported, where commands fail to execute correctly. You may also find that your database has been corrupted, but this happens less often. It can be very difficult to track down the locking errors which make SQLite fail. Sometimes a setup will work perfectly, but then occasionally fail after a reboot. Then another reboot may appear to fix the problem. We have not found /any/ method of mounting a drive over a network, for any operating system, which we can recommend. If the database you are using has important data, I suggest you run PRAGMA integrity_check to make sure that the database is not corrupt. If you don't actually need that database, please delete it and start again with a blank database or a backup. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users