Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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.)

...

  1. Run the clear command
    1. rake

...

    1. blacklight:delete_old_searches