On 23 Dec 2019, at 6:19am, Aydin Ozgur Yagmur <[email protected]> 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
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
