ruby-on-rails – 从rails控制台获取“SQLite3 :: CorruptException：数据库磁盘映像格式错误”

概述我正在做Michael Hartl的rails screencast教程,在第7章中,我试图将用户添加到数据库中,以便测试用户显示页面.当我创建一个用户时,它会被一个SQLite3 :: CorruptException回滚：数据库磁盘映像格式错误.对此错误的研究建议停止“后缀”过程,但我没有安装postfix.有任何想法吗？请注意,我是新手,这很可能是我的一个简单错误！谢谢！ 1.9.3p194 我正在做Michael Hartl的rails screencast教程,在第7章中,我试图将用户添加到数据库中,以便测试用户显示页面.当我创建一个用户时,它会被一个sqlite3 :: CorruptException回滚：数据库磁盘映像格式错误.对此错误的研究建议停止“后缀”过程,但我没有安装postfix.有任何想法吗？请注意,我是新手,这很可能是我的一个简单错误！谢谢！

1.9.3p194 :009 > user = User.create(name: "dax",email: "[email protected]",password: "lala",password_confirmation: "lala")(0.1ms)  SAVEPOINT active_record_1User Exists (0.2ms)  SELECT 1 AS one FROM "users" WHERE LOWER("users"."email") = LOWER('[email protected]') liMIT 1sql (0.6ms)  INSERT INTO "users" ("created_at","email","encrypted_password","name","salt","updated_at") VALUES (?,?,?)  [["created_at",Thu,14 Mar 2013 18:29:58     UTC +00:00],["email","[email protected]"],["encrypted_password","68beb4b809ab79efd7fcbd175a58d7938d595f360df82b85f8f73e209abe6327"],["name","dax"],["salt","da4687fa5f380d0b1087810fdccfe96fddd4abab4409c2d96adf7c14f6c4b77b"],["updated_at",14 Mar 2013 18:29:58 UTC +00:00]](0.1ms)  RolLBACK TO SAVEPOINT active_record_1ActiveRecord::StatementInvalID: sqlite3::CorruptException: database disk image is malformed: INSERT INTO "users" ("created_at",?)from /usr/local/rvm/gems/ruby-1.9.3-p194/gems/sqlite3-1.3.7/lib/sqlite3/statement.rb:108:in `step'from /usr/local/rvm/gems/ruby-1.9.3-p194/gems/sqlite3-1.3.7/lib/sqlite3/statement.rb:108:in `block in each'from /usr/local/rvm/gems/ruby-1.9.3-p194/gems/sqlite3-1.3.7/lib/sqlite3/statement.rb:107:in `loop'from /usr/local/rvm/gems/ruby-1.9.3-p194/gems/sqlite3-1.3.7/lib/sqlite3/statement.rb:107:in `each'from /usr/local/rvm/gems/ruby-1.9.3-p194/gems/activerecord-3.2.12/lib/active_record/connection_adapters/sqlite_adapter.rb:263:in `to_a'from /usr/local/rvm/gems/ruby-1.9.3-p194/gems/activerecord-3.2.12/lib/active_record/connection_adapters/sqlite_adapter.rb:263:in `block in exec_query'from /usr/local/rvm/gems/ruby-1.9.3-p194/gems/activerecord-3.2.12/lib/active_record/connection_adapters/abstract_adapter.rb:280:in `block in log'from /usr/local/rvm/gems/ruby-1.9.3-p194/gems/activesupport-3.2.12/lib/active_support/notifications/instrumenter.rb:20:in `instrument'from /usr/local/rvm/gems/ruby-1.9.3-p194/gems/activerecord-3.2.12/lib/active_record/connection_adapters/abstract_adapter.rb:275:in `log'from /usr/local/rvm/gems/ruby-1.9.3-p194/gems/activerecord-3.2.12/lib/active_record/connection_adapters/sqlite_adapter.rb:242:in `exec_query'from /usr/local/rvm/gems/ruby-1.9.3-p194/gems/activerecord-3.2.12/lib/active_record/connection_adapters/abstract/database_statements.rb:63:in `exec_insert'from /usr/local/rvm/gems/ruby-1.9.3-p194/gems/activerecord-3.2.12/lib/active_record/connection_adapters/abstract/database_statements.rb:90:in `insert'from /usr/local/rvm/gems/ruby-1.9.3-p194/gems/activerecord-3.2.12/lib/active_record/connection_adapters/abstract/query_cache.rb:14:in `insert'from /usr/local/rvm/gems/ruby-1.9.3-p194/gems/activerecord-3.2.12/lib/active_record/relation.rb:66:in `insert'from /usr/local/rvm/gems/ruby-1.9.3-p194/gems/activerecord-3.2.12/lib/active_record/persistence.rb:367:in `create'from /usr/local/rvm/gems/ruby-1.9.3-p194/gems/activerecord-3.2.12/lib/active_record/timestamp.rb:58:in `create'... 15 levels...from /usr/local/rvm/gems/ruby-1.9.3-p194/gems/activerecord-3.2.12/lib/active_record/attribute_methods/dirty.rb:22:in `save'from /usr/local/rvm/gems/ruby-1.9.3-p194/gems/activerecord-3.2.12/lib/active_record/transactions.rb:259:in `block (2 levels) in save'from /usr/local/rvm/gems/ruby-1.9.3-p194/gems/activerecord-3.2.12/lib/active_record/transactions.rb:313:in `block in with_transaction_returning_status'from /usr/local/rvm/gems/ruby-1.9.3-p194/gems/activerecord-3.2.12/lib/active_record/connection_adapters/abstract/database_statements.rb:192:in `transaction'from /usr/local/rvm/gems/ruby-1.9.3-p194/gems/activerecord-3.2.12/lib/active_record/transactions.rb:208:in `transaction'from /usr/local/rvm/gems/ruby-1.9.3-p194/gems/activerecord-3.2.12/lib/active_record/transactions.rb:311:in `with_transaction_returning_status'from /usr/local/rvm/gems/ruby-1.9.3-p194/gems/activerecord-3.2.12/lib/active_record/transactions.rb:259:in `block in save'from /usr/local/rvm/gems/ruby-1.9.3-p194/gems/activerecord-3.2.12/lib/active_record/transactions.rb:270:in `rollback_active_record_state!'from /usr/local/rvm/gems/ruby-1.9.3-p194/gems/activerecord-3.2.12/lib/active_record/transactions.rb:258:in `save'from /usr/local/rvm/gems/ruby-1.9.3-p194/gems/activerecord-3.2.12/lib/active_record/persistence.rb:45:in `create'from (irb):9from /usr/local/rvm/gems/ruby-1.9.3-p194/gems/railtIEs-3.2.12/lib/rails/commands/console.rb:47:in `start'from /usr/local/rvm/gems/ruby-1.9.3-p194/gems/railtIEs-3.2.12/lib/rails/commands/console.rb:8:in `start'from /usr/local/rvm/gems/ruby-1.9.3-p194/gems/railtIEs-3.2.12/lib/rails/commands.rb:41:in `<top (required)>'from script/rails:6:in `require'from script/rails:6:in `<main>'1.9.3p194 :010 >`

解决方法 听起来数据库已经损坏了.您可以从头开始使用：

rake db:droprake db:createrake db:migrate

总结

以上是内存溢出为你收集整理的ruby-on-rails – 从rails控制台获取“SQLite3 :: CorruptException：数据库磁盘映像格式错误”全部内容，希望文章能够帮你解决ruby-on-rails – 从rails控制台获取“SQLite3 :: CorruptException：数据库磁盘映像格式错误”所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。