Thank you very much Simon, it is quite explicative. On Mon, Dec 23, 2019 at 11:38 AM Simon Slavin <slav...@bigfraud.org> wrote:
> 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 > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
