$ bundle exec rake db:reset command raising couldn't drop db/development.sqlite3

Question

I tried to run $ bundle exec rake db:reset and found the following on console

Couldn't drop db/development.sqlite3 : #<Errno::EACCES: Permission denied - c:/sample_app/db/development.sqlite3>
db/development.sqlite3 already exists
-- create_table("users", {:force=>true})
   -> 0.3940s
-- add_index("users", ["email"], {:name=>"index_users_on_email", :unique=>true})

   -> 0.1280s
-- initialize_schema_migrations_table()
   -> 0.0010s
-- assume_migrated_upto_version(20120419034627, ["c:/sample_app/db/migrate
"])
   -> 0.0040s

How can I solve it?

Edit I was following a tutorial and it tells me to run the above command to delete all the data from the database safely. And I am also using admin account.

Check this out. This will be helpful http://stackoverflow.com/questions/4116067/rails-how-to-recreate-the-database — naren, Apr 24 '12 at 02:06
Thanks for the information but, they are talking about the commands but I have the command which is outputting the above error message — WowBow, Apr 24 '12 at 02:47

htanata · Accepted Answer · 2013-10-14T20:03:16.670

42

When you do db:reset, it's running db:drop and db:setup in sequence. Your error message indicates that db/development.sqlite couldn't be deleted.

If you're on Windows, maybe you need to stop your Rails server and console. Otherwise, figure out what's preventing the file from being deleted. It could be permission problem. A reboot may solve the problem too.

edited Oct 14 '13 at 20:03

answered Apr 24 '12 at 04:29

htanata

36,666
8
50
57

2

I restarted everything that uses rails resource and everything is fine now. – WowBow Apr 24 '12 at 04:40
3

Had the same problem, stopping the rails server was all I needed to do. Thanks! – Shawn Jun 14 '12 at 18:45
this answer is correct! I had the same problem and stopping the server for awhile make the command works. – muhnizar Jul 18 '14 at 23:09

score 1 · Answer 2 · answered Aug 09 '13 at 01:51

1

I know this is an old post, but I just had this problem (continued sqlite3 issues with Windows), and while rebooting, shutting the command line, and stopping the server didn't work, I did manage to solve it by actually running each of the commands htanta mentioned above sequentially: 1. bundle exec rake db:drop 2. bundle exec rake db:create 3. bundle exec rake db:migrate

If db:reset is only these commands anyway, I don't understand why it doesn't work but the individual commands do?

answered Aug 09 '13 at 01:51

grist

103
1
9

see my comment above. try `db:migrate:reset` to run all of those commands. – David T Oct 14 '13 at 15:40
Thank you, @grist. Breaking up the commands worked when nothing else would. – Jaime Apr 21 '14 at 12:47

score 1 · Answer 3 · answered Apr 13 '14 at 20:57

Have been trying to resolve the same issue. Stopping Rails Server on Windows didn't help, but restarting the whole environment did the trick, bundle exec rake db:reset went through, but be sure not to start your server before that as it will call the same error. Continue with

$ bundle exec rake db:reset
$ bundle exec rake db:populate
$ bundle exec rake test:prepare

and start Rails Server after that.

score 0 · Answer 4 · answered Feb 09 '15 at 09:55

0

Another possible answer is that you have a database file open. Close those files and stop your server, and it should work.

answered Feb 09 '15 at 09:55

Harm van der Vegt

1
1

score -1 · Answer 5 · answered Feb 18 '15 at 06:47

-1

For Dropping entire database just give rake db:setup it drops and again creates the database for you

answered Feb 18 '15 at 06:47

user3886802

19
1

$ bundle exec rake db:reset command raising couldn't drop db/development.sqlite3

5 Answers5

Linked