我一直在开发一个小型但有些复杂的Rails应用程序,其中包含多个has_and_belongs_to_many关系。它是开源的,代码在这里。一切工作正常,但是最近我添加了一个新的HABTM关系迁移,一个rspec测试开始失败。Rake:db:migrate正常工作(并且问题在本地工作),只是不在测试中。在运行db:test:load——trace时,我得到以下错误:
:fermi og$ rake db:test:load——trace/Users/og/.rvm/ruby/ruby-1.9.3-head/lib/ruby/1.9.1/yaml.rb:56:in
<top (required)>': It seems your ruby installation is missing psych (for YAML output). To eliminate this warning, please install libyaml and reinstall your ruby. ** Invoke db:test:load (first_time) ** Invoke db:test:purge (first_time) ** Invoke environment (first_time) ** Execute environment ** Invoke db:load_config (first_time) ** Execute db:load_config ** Execute db:test:purge ** Execute db:test:load ** Invoke db:test:load_schema (first_time) ** Invoke db:test:purge ** Execute db:test:load_schema ** Invoke db:schema:load (first_time) ** Invoke environment ** Invoke db:load_config ** Execute db:schema:load rake aborted! SQLite3::SQLException: object name reserved for internal use: sqlite_sp_functions: CREATE TABLE "sqlite_sp_functions" ("name" text, "text" text) /Users/og/.rvm/gems/ruby-1.9.3-head/gems/sqlite3-1.3.7/lib/sqlite3/database.rb:91:in
初始化的/用户/og/.rvm/珠宝/ruby-1.9.3-head/珠宝/sqlite3-1.3.7/lib/sqlite3/database.rb: 91:在new' /Users/og/.rvm/gems/ruby-1.9.3-head/gems/sqlite3-1.3.7/lib/sqlite3/database.rb:91:in
准备的/用户/og/.rvm/珠宝/ruby-1.9.3-head/珠宝/sqlite3-1.3.7/lib/sqlite3/database.rb: 134:在execute' /Users/og/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.9/lib/active_record/connection_adapters/sqlite_adapter.rb:278:in
块在执行中/用户/og/.rvm/珠宝/ruby-1.9.3-head/珠宝/activerecord-3.2.9/lib/active_record/connection_adapters/abstract_adapter。rb:280:inblock in log' /Users/og/.rvm/gems/ruby-1.9.3-head/gems/activesupport-3.2.9/lib/active_support/notifications/instrumenter.rb:20:in
仪器/用户/og/.rvm/珠宝/ruby-1.9.3-head/珠宝/activerecord-3.2.9/lib/active_record/connection_adapters/abstract_adapter。在log' /Users/og/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.9/lib/active_record/connection_adapters/sqlite_adapter.rb:278:in
中执行' '/用户/og/.rvm/珠宝/ruby-1.9.3-head/珠宝/activerecord-3.2.9/lib/active_record/connection_adapters/摘要/schema_statements.rb: 170:在create_table' /Users/og/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.9/lib/active_record/migration.rb:466:in
block in method_missing'/用户/og/.rvm/珠宝/ruby-1.9.3-head/珠宝/activerecord-3.2.9/lib/active_record/迁移。rb:438:inblock in say_with_time' /Users/og/.rvm/rubies/ruby-1.9.3-head/lib/ruby/1.9.1/benchmark.rb:280:in
measure'/用户/og/.rvm/珠宝/ruby-1.9.3-head/珠宝/activerecord-3.2.9/lib/active_record/迁移。b:438:insay_with_time' /Users/og/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.9/lib/active_record/migration.rb:458:in
method_missing'/Users/og/Documents/websites/fermi/db/schema. b:49:inblock in <top (required)>' /Users/og/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.9/lib/active_record/schema.rb:50:in
instance_eval的/用户/og/.rvm/珠宝/ruby-1.9.3-head/珠宝/activerecord-3.2.9/lib/active_record/schema.rb: 50:define' /Users/og/Documents/websites/fermi/db/schema.rb:14:in
"/用户/og/.rvm/珠宝/ruby-1.9.3-head/珠宝/activesupport-3.2.9/lib/active_support/dependencies.rb: 245:在load' /Users/og/.rvm/gems/ruby-1.9.3-head/gems/activesupport-3.2.9/lib/active_support/dependencies.rb:245:in
block in load'/用户/og/.rvm/珠宝/ruby-1.9.3-head/珠宝/activesupport-3.2.9/lib/active_support/dependencies.rb: 236:在load_dependency' /Users/og/.rvm/gems/ruby-1.9.3-head/gems/activesupport-3.2.9/lib/active_support/dependencies.rb:245:in
负载的/用户/og/.rvm/珠宝/ruby-1.9.3-head/珠宝/activerecord-3.2.9/lib/active_record/railties/databases.rake: 388:在block (3 levels) in <top (required)>' /Users/og/.rvm/gems/ruby-1.9.3-head@global/gems/rake-10.0.4/lib/rake/task.rb:246:in
称之为"/用户/og/.rvm/珠宝/ruby-1.9.3-head@global/珠宝/rake-10.0.4/lib/耙/task.rb: 246:在block in execute' /Users/og/.rvm/gems/ruby-1.9.3-head@global/gems/rake-10.0.4/lib/rake/task.rb:241:in
每个的/用户/og/.rvm/珠宝/ruby-1.9.3-head@global/珠宝/rake-10.0.4/lib/耙/task.rb: 241:在execute' /Users/og/.rvm/gems/ruby-1.9.3-head@global/gems/rake-10.0.4/lib/rake/task.rb:184:in
block in invoke_with_call_chain/用户/og/.rvm/红宝石/ruby-1.9.3-head/lib/ruby/1.9.1/monitor.rb: 211:在mon_synchronize' /Users/og/.rvm/gems/ruby-1.9.3-head@global/gems/rake-10.0.4/lib/rake/task.rb:177:in
invoke_with_call_chain"/用户/og/.rvm/珠宝/ruby-1.9.3-head@global/珠宝/rake-10.0.4/lib/耙/task.rb: 170:在invoke' /Users/og/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.9/lib/active_record/railties/databases.rake:499:in
块(3级)在'/用户/og/.rvm/珠宝/ruby-1.9.3-head@global/珠宝/rake-10.0.4/lib/耙/task.rb: 246:在call' /Users/og/.rvm/gems/ruby-1.9.3-head@global/gems/rake-10.0.4/lib/rake/task.rb:246:in
block in execute'/用户/og/.rvm/珠宝/ruby-1.9.3-head@global/珠宝/rake-10.0.4/lib/耙/task.rb: 241:在each' /Users/og/.rvm/gems/ruby-1.9.3-head@global/gems/rake-10.0.4/lib/rake/task.rb:241:in
执行"/用户/og/.rvm/珠宝/ruby-1.9.3-head@global/珠宝/rake-10.0.4/lib/耙/task.rb: 184:在block in invoke_with_call_chain' /Users/og/.rvm/rubies/ruby-1.9.3-head/lib/ruby/1.9.1/monitor.rb:211:in
mon_synchronize"/用户/og/.rvm/珠宝/ruby-1.9.3-head@global/珠宝/rake-10.0.4/lib/耙/task.rb: 177:在invoke_with_call_chain' /Users/og/.rvm/gems/ruby-1.9.3-head@global/gems/rake-10.0.4/lib/rake/task.rb:170:in
调用"/用户/og/.rvm/珠宝/ruby-1.9.3-head/珠宝/activerecord-3.2.9/lib/active_record/railties/databases.rake: 479:在block (3 levels) in <top (required)>' /Users/og/.rvm/gems/ruby-1.9.3-head@global/gems/rake-10.0.4/lib/rake/task.rb:246:in
称之为"/用户/og/.rvm/珠宝/ruby-1.9.3-head@global/珠宝/rake-10.0.4/lib/耙/task.rb: 246:在block in execute' /Users/og/.rvm/gems/ruby-1.9.3-head@global/gems/rake-10.0.4/lib/rake/task.rb:241:in
每个的/用户/og/.rvm/珠宝/ruby-1.9.3-head@global/珠宝/rake-10.0.4/lib/耙/task.rb: 241:在execute' /Users/og/.rvm/gems/ruby-1.9.3-head@global/gems/rake-10.0.4/lib/rake/task.rb:184:in
block in invoke_with_call_chain/用户/og/.rvm/红宝石/ruby-1.9.3-head/lib/ruby/1.9.1/monitor.rb: 211:在mon_synchronize' /Users/og/.rvm/gems/ruby-1.9.3-head@global/gems/rake-10.0.4/lib/rake/task.rb:177:in
invoke_with_call_chain"/用户/og/.rvm/珠宝/ruby-1.9.3-head@global/珠宝/rake-10.0.4/lib/耙/task.rb: 170:在invoke' /Users/og/.rvm/gems/ruby-1.9.3-head@global/gems/rake-10.0.4/lib/rake/application.rb:143:in
invoke_task"/用户/og/.rvm/珠宝/ruby-1.9.3-head@global/珠宝/rake-10.0.4/lib/耙/application.rb: 101:在block (2 levels) in top_level' /Users/og/.rvm/gems/ruby-1.9.3-head@global/gems/rake-10.0.4/lib/rake/application.rb:101:in
每个的/用户/og/.rvm/珠宝/ruby-1.9.3-head@global/珠宝/rake-10.0.4/lib/耙/application.rb: 101:在block in top_level' /Users/og/.rvm/gems/ruby-1.9.3-head@global/gems/rake-10.0.4/lib/rake/application.rb:110:in
run_with_threads"/用户/og/.rvm/珠宝/ruby-1.9.3-head@global/珠宝/rake-10.0.4/lib/耙/application.rb: 95:在top_level' /Users/og/.rvm/gems/ruby-1.9.3-head@global/gems/rake-10.0.4/lib/rake/application.rb:73:in
block in run'/用户/og/.rvm/珠宝/ruby-1.9.3-head@global/珠宝/rake-10.0.4/lib/耙/application.rb: 160:在standard_exception_handling' /Users/og/.rvm/gems/ruby-1.9.3-head@global/gems/rake-10.0.4/lib/rake/application.rb:70:in
运行"/用户/og/.rvm/珠宝/ruby-1.9.3-head@global/珠宝/rake-10.0.4/bin/rake:: 33<top (required)>' /Users/og/.rvm/gems/ruby-1.9.3-head/bin/rake:23:in
load'/Users/og/.rvm/gems/ruby-1.9.3-head/bin/rake:23:in "任务:TOP => db:schema:load
我的模式。Rb文件如下:
# encoding: UTF-8
# This file is auto-generated from the current state of the database. Instead
# of editing this file, please use the migrations feature of Active Record to
# incrementally modify your database, and then regenerate this schema definition.
#
# Note that this schema.rb definition is the authoritative source for your
# database schema. If you need to create the application database on another
# system, you should be using db:schema:load, not running all the migrations
# from scratch. The latter is a flawed and unsustainable approach (the more migrations
# you'll amass, the slower it'll run and the greater likelihood for issues).
#
# It's strongly recommended to check this file into your version control system.
ActiveRecord::Schema.define(:version => 20130519192155) do
create_table "distributions", :force => true do |t|
t.float "mean"
t.float "spread"
t.float "wideness"
t.datetime "created_at", :null => false
t.datetime "updated_at", :null => false
t.integer "operation_id"
t.string "type"
t.string "name"
end
create_table "distributions_models", :id => false, :force => true do |t|
t.integer "distribution_id"
t.integer "model_id"
end
create_table "distributions_operations", :id => false, :force => true do |t|
t.integer "distribution_id"
t.integer "operation_id"
end
create_table "models", :force => true do |t|
t.string "name"
t.datetime "created_at", :null => false
t.datetime "updated_at", :null => false
end
create_table "operations", :force => true do |t|
t.string "operator"
t.datetime "created_at", :null => false
t.datetime "updated_at", :null => false
end
create_table "sqlite_sp_functions", :id => false, :force => true do |t|
t.text "name"
t.text "text"
end
# Could not dump table "sqlite_stat1" because of following StandardError
# Unknown type '' for column 'tbl'
# Could not dump table "sqlite_stat3" because of following StandardError
# Unknown type '' for column 'tbl'
create_table "sqlite_vs_links_names", :id => false, :force => true do |t|
t.text "name"
t.text "alias"
end
create_table "sqlite_vs_properties", :id => false, :force => true do |t|
t.text "parentType"
t.text "parentName"
t.text "propertyName"
t.text "propertyValue"
end
create_table "sqlite_vsp_diagrams", :id => false, :force => true do |t|
t.text "name"
t.text "diadata"
t.text "comment"
t.text "preview"
end
end
任何帮助或信息将不胜感激。我在网上搜索这些错误已经有一段时间了,但在网上发现的很少。
对我有效的是删除schema。Rb,即模式定义文件。
(该文件的第一段注释建议删除它并生成一个新的,而不是编辑它。)
然后运行rake db:migrate
,它执行所有迁移并重新创建模式。rb文件。
我也得到了类似的错误,我不知道。但是当我删除这些代码时,这里是
create_table "sqlite_sp_functions", :id => false, :force => true do |t|
t.text "name"
t.text "text"
end
# Could not dump table "sqlite_stat1" because of following StandardError
# Unknown type '' for column 'tbl'
# Could not dump table "sqlite_stat3" because of following StandardError
# Unknown type '' for column 'tbl'
create_table "sqlite_vs_links_names", :id => false, :force => true do |t|
t.text "name"
t.text "alias"
end
create_table "sqlite_vs_properties", :id => false, :force => true do |t|
t.text "parentType"
t.text "parentName"
t.text "propertyName"
t.text "propertyValue"
end
create_table "sqlite_vsp_diagrams", :id => false, :force => true do |t|
t.text "name"
t.text "diadata"
t.text "comment"
t.text "preview"
end
那么rake test:prepare
可能行得通
在config/application.rb
或config/environments/development.rb
中添加以下配置行:
ActiveRecord::SchemaDumper.ignore_tables = /^sqlite_*/
这将在模式转储期间忽略数据库中所有以"sqlite_"开头的表。