Notes and Restrictions
Notes and restrictions that must be considered when using SQLite®.
- SQLite® can only be used in combination with NextGen Archiver (NGA).
- NGA can be used in a RAIMA or SQLite® project. However, SQLite® can only be used with NGA and not with HDB / RDB Archiving.
- You can switch from RAIMA to SQLite® but not back.
- The managers that require configurations (e.g. drivers) are not shut down when they attempt to connect to a data manager that is in mirroring mode. The managers wait until the mirroring mode has ended.
Using network mounted drive CIFS (Samba share) with SQLite
According to the official documentation, using SQLite over a network mounted file system is neither recommended nor tested. In particular, the synchronization and locking reliability of network file systems is questionable. The CIFS file system is not fully compatible with the SQLite locking mechanism. In WAL mode, most operations should work, but some operations on the DB require an exclusive lock, which is a problem in this case.
Workaround: When mounting a CIFS (Samba) network drive to access an SQLite
database, it is necessary to connect the disk with the nobrl
(No
Byte-Range Locking) option. This can be done using the following command:
sudo mount -t cifs -o nobrl,username=z004cknf,password=***** //host.docker.internal/SharedF /home/winccoa/winccoaproj
nobrl
option only hides the problem. The
main issue is that SQLite officially doesn't support network file systems. In the
worst case, the database can get corrupted.Sources: