When trying to re-index new records, it locks up. As a result I now can't sign out any books. How can this be fixed?
Export the database, then reinstall the application and after you've backed up, delete everything related to this application.
Download and install it again, and perform the import and re-index new records.