CODEWITHSUNDEEP
lasso-lang
ATP_JD
ATP_JD

Reputation: 1295

Failure in sqlite_session_driver active_tick: Error from SQLite database "lasso_session": 19 constraint failed

I am having a recurring problem with Lasso 9.2.6 where the instance slows to a crawl performance-wise and throws these errors to the log:

Failure in sqlite_session_driver active_tick: Error from SQLite database "lasso_session": 19 constraint failed

Restarting the instance solves the performance problem temporarily, but errors continue to appear.

Any recommendations for cleaning this up or resetting the session database to clear out invalid data?

Upvotes: 0

Views: 75

Answers (1)

Ke.
Ke.

Reputation: 53

Depending on traffic volume or logging volume you may be overloading the sqlite tables. It's hard to say exactly what the cause is without checking, but I'd look at the settings for sessions. Consider setting the sessions to use either memory or the MySQL driver (I recommend a Memory table if using MySQL).

Have a look at the size of the tables and check if any are excessively large. You can just run ls -l /var/lasso/instances/default/SQLiteDBs/ or use a sqlite tool. The logbook and email tables are also likely suspects.

Upvotes: 0

Related Questions