"Database is locked" when performing operation in Arcadia UI

If you are using sqlite as the arcadia visualization server metadata, from time to time you might observe a “database locked” error as shown below:

image

Solution
For any production deployment of Arcadia with high user concurrency we highly recommend using a proper load balanced RDBMS like mysql or oracle as the metastore DB for the visualization server.
Sqlite is known to have a low threshold for request concurrency before a lockout is experience.

Refer to these docs to configure visualization with RDBMS like mysql:
http://documentation.arcadiadata.com/4.5.0.0/#pages/topics/install-enterprise-as-multi-process.html
http://documentation.arcadiadata.com/4.5.0.0/#pages/topics/install-enterprise-cm-multi-process.html

1 Like