/
Clearing DB for blacklight apps

Clearing DB for blacklight apps

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:

  1. ssh to railspod

    1. ssh me@railsprod.library.albany.edu

  2. Login as railsuser

    1. sudo -u railsuser bash

  3. Change to an app

    1. cd arclight-UAlbany (or books, espy, etc.)

  4. Run the clear command

    1. rake blacklight:delete_old_searches





Related content

Web Browser - How to clear temporary files or cache
Web Browser - How to clear temporary files or cache
More like this
Exporting from ASpace to ArcLight
Exporting from ASpace to ArcLight
More like this
Overnight Export and Indexing Scripts
Overnight Export and Indexing Scripts
More like this