Troubleshooting SQLite

This article contains some troubleshooting steps you can take if you are getting errors from Lasso's embedded SQLite database.

SQLite Database Locked

If you restore Lasso from a backup or copy a Lasso installation from one machine to another then the SQLite databases which Lasso requires can have the wrong permissions or be locked. The following steps can help you determine if you are encountering this issue and resolve it.

Check the permissions on the SQLiteDBs folder in the main Lasso Professional 8 folder and in each of the LassoSites folders. On Mac OS X you can do the following commands in the terminal.

ls -l ~lasso/SQLiteDBs
ls -l ~lasso/LassoSites/*/SQLiteDBs

 

This is what I see. The essential thing is that the "lasso" user owns these files and that he has "read/write" access.

Example:~ johndoe$ ls -l ~lasso/SQLiteDBs
total 4512
-rw-rw----  1 lasso  admin  2227200 Mar 19 12:08 LDML8_Reference
-rw-rw----  1 lasso  admin     2048 Mar  3 11:03 lasso_admin
-rw-rw----  1 lasso  admin    58368 Mar 20 11:07 lasso_global
-rw-rw----  1 lasso  admin    14336 Mar 20 11:06 lasso_site_0
Example:~ johndoe$ ls -l ~lasso/LassoSites/*/SQLiteDBs
total 4536
-rw-rw----  1 lasso  admin  2227200 Mar 20 11:06 LDML8_Reference
-rw-r--r--  1 lasso  admin     2048 Mar  3 11:04 lasso_admin
-rw-r--r--  1 lasso  admin    48128 Mar 20 11:08 lasso_internal
-rw-r--r--  1 lasso  admin    20480 Mar 21 06:00 lasso_site_1
-rw-r--r--  1 root   admin    17408 Mar  6 11:46 lasso_site_x

 

If you see something different you can reset the permission using these commands.

sudo chown ~lasso/SQLiteDBs
sudo chown ~lasso/LassoSites/*/SQLiteDBs
sudo chmod -R o+rw ~lasso/SQLiteDBs
sudo chmod -R o+rw ~lasso/LassoSites/*/SQLiteDBs

 

And then restart Lasso Service using

sudo lasso8ctl restart

 

One other thing to check is to stop Lasso and then check to see if any Lasso8Service processes are dangling.

sudo lasso8ctl stop
ps aux | grep lasso

 

If you see any Lasso8Service processes then restart your machine. That seems to be the only effective way to clear them out if lasso8ctl can't stop them.

Author: Fletcher Sandbeck
Created: 21 Mar 2010
Last Modified: 16 Mar 2011