What to do if you get a SQLite3 :: BusyException: database is locked error

This is a workaround that was taken when a new table was created and rails db: migrate was executed during Rails learning, but it was not reflected in the DB (DB Browser for SQlite).

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

I entered this command with rails consoloe and it was fixed.

https://qiita.com/shun_study_p/items/fbb4cb2d4c392063c9a9

I referred to the article at the above URL.

Recommended Posts

What to do if you get a SQLite3 :: BusyException: database is locked error
What to do if you get a gcc error in Docker
What to do if you get a DISPLAY error in gym.render ()
What to do if you get a java.io.IOException in GlassFish
What to do if you get a wrong number of arguments error in binding.pry
What to do if you get a port error when docker-compose up on Mac
What to do if you get an "A server is already running." Error when you try to start the rails server
What to do if you get a "Cannot Pull Container Error" when starting ECS ​​Fargate
What to do if you get a "302" error in your controller unit test code in Rails
What to do if you get a groovy warning in Thymeleaf Layout
What to do if you get an error during rails db: reset
What to do if you get an uninitialized constant Likes Controller error
What to do if you get an error when you hit Heroku logs
What to do if you get a MiniMagick vulnerability alert on GitHub
What to do if you get a "Mysql2 :: Error: Operand should contain 1 column (s)" error in Rails
What to do if you get a JNI shared library error when trying to build in Eclipse
What to do if you accidentally create a model
What to do if you get the error message unrecognized selector send to instance "***"
What to do if you get an error on heroku rake db: migrate
What to do if mysql2 gets a bundle install error
What to do if you get a NoClassDefFoundError when trying to run eclipse on Java9
What to do if you get the error Couldn't find Item without an ID
What to do if you get an error saying "Please enter a valid value" when getting with Rails datetime_field
[Rails] What to do if you can't get an error message with the errors method
What to do if you get angry with OpenSSL with pyenv install
What to do if you install Ubuntu
What to do if you get an error saying "Could not find a JavaScript runtime." When starting rails server
[Solution] What to do if you get a Docker error'ERROR: Cannot connect to the Docker daemon at unix: ///var/run/docker.sock. Is the docker daemon running?'
What to do if you get an error in Basic authentication during Rails test code
[Rails] What to do if you can't get parameters with form_with
ActiveRecord :: StatementInvalid: SQLite3 :: BusyException: database is locked
What to do if you get an [An HTTP request took too long to complete.] Error in Docker.
What to do if you push incorrect information
What to do if you get an error with bundle install by entering gem'bcrypt' in your Gemfile
What to do if you get Application with name appName is already registered. When you try to start GlassFish
What to do if Operation not permitted is displayed when you execute a command in the terminal
What to do if you get the error Too long with no output (exceeded 10m0s) on CircleCI
What to do when you want to delete a migration file that is "NO FILE"
What to do if you get Could not locate Gemfile or .bundle / directory
What to do if you get angry if you don't have nokogiri while installing wp2txt
What to do if you get To install the missing version, run `gem install bundler: 2.1.4`
What to do when a null byte error occurs
What to do if an ActionController :: UnknownFormat error occurs
What to do if you get a javax.net.ssl.SSLHandshakeException: Remote host closed connection during handshake in the IBM JDK
What to do if you get Could not save master table to file after importing a project in Eclipse
What to do if you can't get the text of an element in Selenium
[Rails] What to do if you get an error saying "Could not find a JavaScript runtime." When executing the rails s command on Catalina
[Java] What to do if you get an error in Eclipse saying "Not allowed at source level below 1.X"
What to do if you get an Argument Error: wrong number of arguments (given 2, expected 0) in your RSpec test
What to do if audio is not available on discordrb
What to do if FacesMessage is set but not displayed
# What to do if you accidentally do rails db: migrate: drop
What to do if you can't use the rails command
What to do if you switch Java versions on Windows 7 and get Error: Registry key'Software \ JavaSoft \ Java Runtime Environment'\ CurrentVersion' has value '1.8', but '1.7' is required.
What to do if you don't see the test code error message in the terminal console
What to do if a SAX Parser error occurs when using Liferay 7 / DXP on AWS
How to make a jar with old Hadoop (hadoop-core-0.20.2-cdh3u6) in Gradle: (What to do if you get Could not expand ZIP ..)
[Maven] What to do if you are asked to incorporate a jar that is not in the remote repository into the war
<Dot installation> What to do if you cannot proceed due to an error when building a development environment for Rails learning.
What to do if you select a JRE in Eclipse and get "The selected JRE does not support the current compliance level 11"
[Ubuntu 20.04] What to do if the external monitor is not recognized