Ruby: SQLite3::BusyException: database is locked:

by

For anyone else encountering this issue with SQLite locking in development when a Rails console is open, try this:

Just run the following:

ActiveRecord::Base.connection.execute("BEGIN TRANSACTION; END;")

For me anyway, it appears to clear any transaction that the console was holding onto and frees up the database.

This is especially a problem for me when running delayed_job, which seems to fail at closing the transaction quite often.

More Related Contents:

  1. Boolean Validation
  2. cannot load such file — sqlite3/sqlite3_native (LoadError) on ruby on rails
  3. Deploying RoR app to Heroku with SQLite 3 fails
  4. How do I install sqlite3 for Ruby on Windows?
  5. Generic Ruby solution for SQLite3 “LIKE” or PostgreSQL “ILIKE”?
  6. How to sort text in sqlite3 with specified locale?
  7. Clean way to find ActiveRecord objects by id in the order specified
  8. Change from SQLite to PostgreSQL in a fresh Rails project
  9. Rails 3 SQLite3 Boolean false
  10. Heroku deployment failed because of sqlite3 gem error
  11. Cannot add a NOT NULL column with default value NULL in Sqlite3
  12. HEROKU – cannot run git push heroku master [duplicate]
  13. GroupingError: ERROR: column must appear in the GROUP BY clause or be used in an aggregate function
  14. Pushing Rails with SQLite3 to Heroku fails [duplicate]
  15. Why can’t I install the SQLite gem?
  16. sqlite3 gem fails to install
  17. Errors of pushing rails app to Heroku error occurred while installing sqlite3, and Bundler cannot continue [duplicate]
  18. Rails ExecJS::ProgramError in Pages#home?
  19. Rails: How to reference images in CSS within Rails 4
  20. Is there a clean way to avoid calling a method on nil in a nested params hash? [duplicate]
  21. Ruby 2.4 and Rails 4 stack level too deep (SystemStackError)
  22. Is there documentation for the Rails column types?
  23. Validation for URL/Domain using Regex? (Rails)
  24. Form Submit button only works after reload
  25. Why use “self” to access ActiveRecord/Rails model properties?
  26. How to specify a prefix when uploading to S3 using activestorage’s direct upload?
  27. How do I extract Rails view helpers into a gem?
  28. Is puma the ONLY multi-threaded rails 4 http server?
  29. Rails devise: user_signed_in? not working
  30. Rails Object Relationships and JSON Rendering

Leave a Comment