User Tools

Site Tools


electronrt:userguide:userguide

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Last revisionBoth sides next revision
electronrt:userguide:userguide [2022/08/26 19:15] – [General] dpatenaudeelectronrt:userguide:userguide [2022/08/26 19:35] – [General] dpatenaude
Line 105: Line 105:
   * If the application is set to use a [[electronrt:instructions_for_use:instructions_for_use#patient_database_file_storage|network patient directory]] shared with multiple users there may be a risk for 'database is locked' errors. This is due to the application using SQLite as it's database engine, which does not robustly support concurrent database users and reading/writing. While normal usage between one or two users may not pose a problem with this, having a significant number of users simultaneously accessing the network database or the following scenarios can cause the database to lock and throw this error:   * If the application is set to use a [[electronrt:instructions_for_use:instructions_for_use#patient_database_file_storage|network patient directory]] shared with multiple users there may be a risk for 'database is locked' errors. This is due to the application using SQLite as it's database engine, which does not robustly support concurrent database users and reading/writing. While normal usage between one or two users may not pose a problem with this, having a significant number of users simultaneously accessing the network database or the following scenarios can cause the database to lock and throw this error:
     * The application crashes or a network connection is interrupted during a SQL commit that allows the 'unlock' step to be missed OR     * The application crashes or a network connection is interrupted during a SQL commit that allows the 'unlock' step to be missed OR
-    * The file is locked due to other network usage (e.g.: the file is in use by an external service such as an Antivirus scan, backup, etc)+    * The file is locked due to other network usage (e.g.: the file is in use by an external service such as an Antivirus scan, backup, etc) OR
     * Multiple simultaneous users are attempting to read/write to the database at the same time     * Multiple simultaneous users are attempting to read/write to the database at the same time
   * If you receive the error "database is locked" you'll have to wait and try again once the database is unlocked   * If you receive the error "database is locked" you'll have to wait and try again once the database is unlocked
electronrt/userguide/userguide.txt · Last modified: 2023/03/09 20:59 by dpatenaude