Mavericks ruby on rails SQLite3 issue

Question

I already have an application on my local OS and I update the OS to Mavericks. Something wrong happens! After I start rails s, the error is like: SQLite3::IOException: disk I/O error: PRAGMA table_info("users")

By the way, I am using cancan in my local env.

Can somebody help me about that?

Answer 1

This happened to me when I upgraded to OSX Mavericks. My database appeared to be corrupted, with an error very similar to yours. Dropping and rebuilding solved the problem.

In Rails, easily accomplished with:

rake db:drop db:create db:migrate db:seed

or to combine the last 3:

rake db:drop db:setup