All of our Blacklight apps except Hyrax (arclight, history, books, espy) just use an SQlite database. Blacklight only uses this so users can see their search history and apparently for the "Next" and "Previous" links. So the db/production.sqlite files are usually small, but they can fill up over time.
These are the likely culprits:
/var/www/arclight-UAlbany/db/production.sqlite3
/var/www/books/db/production.sqlite3
/var/www/demo/db/production.sqlite3
/var/www/espy/db/production.sqlite3
/var/www/history/db/production.sqlite3
There is a command to clean old data from the database. Here are the steps:
- ssh to railspod
ssh me@railsprod.library.albany.edu
- Login as railsuser
sudo -u railsuser bash
- Change to an app
cd arclight-UAlbany
(or books, espy, etc.)
...
- Run the clear command
rake
...
blacklight:delete_old_searches