PG :: DuplicateTable：错误 [英] PG::DuplicateTable: ERROR

问题描述

当我运行rake db：migrate时，得到以下输出：

When I run rake db:migrate I get following output:

== 20141219011612 CreatePost：迁移======= ==============================
-create_table（ posts）耙中止！ StandardError：发生错误，此错误和所有后续迁移均被取消：
== 20141219011612帖子：迁移========================= =============
-create_table（ posts）耙中止了！ StandardError：发生错误，此错误和所有后续迁移被取消：

== 20141219011612 CreatePost: migrating ======================================= -- create_table("posts") rake aborted! StandardError: An error has occurred, this and all later migrations canceled: == 20141219011612 Postposts: migrating ======================================= -- create_table("posts") rake aborted! StandardError: An error has occurred, this and all later migrations canceled:

PG :: DuplicateTable：错误：关系帖子已存在：CREATE
TABLE posts（ id串行主键， post文本， release_date
时间戳， created_at时间戳， updated_at时间戳）
/home/admin/.rvm/gems/ruby- 2.1.5 / gems / activerecord-4.1.8 / lib / active_record / connection_adapters / postgresql / database_statements.rb：128：in
async_exec'
/home/admin/.rvm /gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/connection_adapters/postgresql/database_statements.rb:128：在
中执行'
/home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/connection_adapters/abstract_adapter.rb:373:in 中的日志'
/home/admin/.rvm/gems/ruby-2.1.5/gems/activesupport-4.1.8/lib/active_support/notifications/instrumenter.rb:20：在
中工具'
/home/admin/.rvm/gems/ruby-2.1.5/gems/activer ecord-4.1.8 / lib / active_record / connection_adapters / abstract_adapter.rb：367：in log'
/home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord -4.1.8 / lib / active_record / connection_adapters / postgresql / database_statements.rb：127：在
执行'
/home/admin/.rvm/gems/ruby-2.1 .5 / gems / activerecord-4.1.8 / lib / active_record / connection_adapters / abstract / schema_statements.rb：205：in
create_table'
/home/admin/.rvm/ gems / ruby​​-2.1.5 / gems / activerecord-4.1.8 / lib / active_record / migration.rb：649：在method_missing'
的
块中
/ home / admin /.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:621：在say_with_time'
中的
块中/ home / admin / .rvm / gems / ruby​​-2.1.5 / gems / activerecord-4.1.8 / lib / active_record / migration.rb：621：in
say_with_time'
/home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:641:in
method_missing'
/ home / admin / Desktop / postr / db / mi grate / 20141219011612_post_posts.rb：3：in
up'
/home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/ lib / active_record / migration.rb：598：in
exec_migration'
/home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8 /lib/active_record/migration.rb:579：在
的
块中（$ 2 $）
/home/admin/.rvm/gems/ruby-2.1.5 /gems/activerecord-4.1.8/lib/active_record/migration.rb:578：在
块中进行迁移'
/home/admin/.rvm/gems/ruby- 2.1.5 / gems / activerecord-4.1.8 / lib / active_record / connection_adapters / abstract / connection_pool.rb：294：在
with_connection'
/ home / admin /中。 rvm / gems / ruby​​-2.1.5 / gems / activerecord-4.1.8 / lib / active_record / migration.rb：577：in
migrate'
/ home / admin / .rvm / gems / ruby​​-2.1.5 / gems / activerecord-4.1.8 / lib / active_record / migration.rb：752：in
migrate'
/ home /管理员/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:991:in
b锁定execute_migration_in_transaction'
/home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:1037:in
ddl_transaction中的代码块
/home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/connection_adapters/abstract/database_statements.rb:201：在
块中$'
/home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/connection_adapters/abstract /database_statements.rb:209:in
within_new_transaction'
/home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib /active_record/connection_adapters/abstract/database_statements.rb:201:in
transaction'
/home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord- 4.1.8 / lib / active_record / transactions.rb：208：in transaction'
/home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1。 8 / lib / active_record / migration.rb：1037：在
ddl_transaction'
/home/admin/.rvm/gems/ruby-2中。 1.5 / gems / activerecord-4.1.8 / lib / active_record / migration.rb：990：在
execute_migration_in_transaction'
/home/admin/.rvm/gems/ruby- 2.1.5 / gems / activerecord-4.1.8 / lib / active_record / migration.rb：952：在
块中进行迁移'
/home/admin/.rvm/gems /ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:948:in
每个'
/home/admin/.rvm /gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:948:in
migrate'
/ home / admin /。 rvm / gems / ruby​​-2.1.5 / gems / activerecord-4.1.8 / lib / active_record / migration.rb：807：in
up'
/ home / admin /.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:785:in
migrate'
/ home / admin / .rvm / gems / ruby​​-2.1.5 / gems / activerecord-4.1.8 / lib / active_record / railties / databases.rake：34：在
块中（2级）在'ActiveRecord :: StatementInvalid中：
PG :: DuplicateTable：错误：关系帖子已经存在：CREATE
表格 posts（ id串行主键， post文本， release_date
时间戳， created_at时间戳， updated_at时间戳）
/home/admin/.rvm/gems/ ruby-2.1.5 / gems / activerecord-4.1.8 / lib / active_record / connection_adapters / postgresql / database_statements.rb：128：in
async_exec'
/ home / admin / .rvm / gems / ruby​​-2.1.5 / gems / activerecord-4.1.8 / lib / active_record / connection_adapters / postgresql / database_statements.rb：128：在
中执行'
/home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/connection_adapters/abstract_adapter.rb:373:in 中的日志块
/home/admin/.rvm/gems/ruby-2.1.5/gems/activesupport-4.1.8/lib/active_support/notifications/instrumenter.rb:20:
instrument'
/home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/connection_adapters/abstract_adapter.rb:367:in log'
/home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/conne ction_adapters / postgresql / database_statements.rb：127：in
执行'
/home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1。 8 / lib / active_record / connection_adapters / abstract / schema_statements.rb：205：in
create_table'
/home/admin/.rvm/gems/ruby-2.1.5/gems /activerecord-4.1.8/lib/active_record/migration.rb:649：在method_missing'
中的
块中/home/admin/.rvm/gems/ruby-2.1 .5 / gems / activerecord-4.1.8 / lib / active_record / migration.rb：621：在say_with_time中的
块中
/home/admin/.rvm/gems/ ruby-2.1.5 / gems / activerecord-4.1.8 / lib / active_record / migration.rb：621：in
say_with_time'
/home/admin/.rvm/ gems / ruby​​-2.1.5 / gems / activerecord-4.1.8 / lib / active_record / migration.rb：641：in
method_missing'
/ home / admin / Desktop / postr / db / migrate / 20141219011612_post_posts.rb：3：在
up'
/home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord- 4.1.8 / lib / active_record / migration.rb：598：在
ex中ec_migration'
/home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:579:
在迁移中阻止（2个级别）
/home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:578:in
迁移区块
/home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/connection_adapters/abstract/connection_pool .rb：294：在
with_connection'
/home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record中/migration.rb:577：在
migrate'
/home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/ active_record / migration.rb：752：在
中迁移
/home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/ lib / active_record / migration.rb：991：在execute_migration_in_transaction中的
块中
/home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1 .8 / lib / active_record / migration.rb：1037：在ddl_tra中的
块中nsaction'
/home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/connection_adapters/abstract/database_statements.rb:201：在
交易中的区块
/home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/connection_adapters/abstract/database_statements.rb:209 ：in
within_new_transaction'
/home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/connection_adapters/abstract /database_statements.rb:201:in
transaction'
/home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/ active_record / transactions.rb：208：in transaction'
/home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/ migration.rb：1037：in
ddl_transaction'
/home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record /migration.rb:990：in
execute_migration_in_transaction'
/home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1 .8 / lib / active_record / migration.rb：952：在
块中进行迁移'
/home/admin/.rvm/gems/ruby-2.1.5/gems/ activerecord-4.1.8 / lib / active_record / migration.rb：948：in
每个'
/home/admin/.rvm/gems/ruby-2.1.5/ gems / activerecord-4.1.8 / lib / active_record / migration.rb：948：in
migrate'
/home/admin/.rvm/gems/ruby-2.1.5 /gems/activerecord-4.1.8/lib/active_record/migration.rb:807：在
up'
中/home/admin/.rvm/gems/ruby-2.1 .5 / gems / activerecord-4.1.8 / lib / active_record / migration.rb：785：在
migrate'
/home/admin/.rvm/gems/ruby- 2.1.5 / gems / activerecord-4.1.8 / lib / active_record / railties / databases.rake：34：在PG :: DuplicateTable中的
块（2个级别）中：错误：
关系帖子已经存在
/home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/connection_adapters/postgresql/database_statements.rb： 128：in
async_exec'
/home/admin/.rvm/gems/ruby-2.1.5/gems/activereco rd-4.1.8 / lib / active_record / connection_adapters / postgresql / database_statements.rb：128：在
中执行'
/home/admin/.rvm/gems/ ruby-2.1.5 / gems / activerecord-4.1.8 / lib / active_record / connection_adapters / abstract_adapter.rb：373：in 阻止登录'
/home/admin/.rvm/gems /ruby-2.1.5/gems/activesupport-4.1.8/lib/active_support/notifications/instrumenter.rb:20:in
instrument'
/ home / admin / .rvm / gems / ruby​​-2.1.5 / gems / activerecord-4.1.8 / lib / active_record / connection_adapters / abstract_adapter.rb：367：in log'
/ home / admin /。 rvm / gems / ruby​​-2.1.5 / gems / activerecord-4.1.8 / lib / active_record / connection_adapters / postgresql / database_statements.rb：127：在
执行'
/home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/connection_adapters/abstract/schema_statements.rb:205：在
create_table中'
/home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:649:in
method_missing'中的块
/home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:621:
中在say_with_time中阻止
/home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:621:in
say_with_time'
/home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:641：在
method_missing'中
/home/admin/Desktop/postr/db/migrate/20141219011612_post_posts.rb:3：在
up'
/home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:598:in
exec_migration '
/home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:579：在
迁移中的块（2个级别）
/home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:578:in
迁移区块
/home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/li b / active_record / connection_adapters / abstract / connection_pool.rb：294：在
with_connection'
/home/admin/.rvm/gems/ruby-2.1.5/gems/ activerecord-4.1.8 / lib / active_record / migration.rb：577：in
migrate'
/home/admin/.rvm/gems/ruby-2.1.5/gems /activerecord-4.1.8/lib/active_record/migration.rb:752:in
migrate'
/home/admin/.rvm/gems/ruby-2.1.5 /gems/activerecord-4.1.8/lib/active_record/migration.rb:991：在execute_migration_in_transaction中的
块中
/home/admin/.rvm/gems/ruby- 2.1.5 / gems / activerecord-4.1.8 / lib / active_record / migration.rb：1037：在ddl_transaction中的
块中
/home/admin/.rvm/ gems / ruby​​-2.1.5 / gems / activerecord-4.1.8 / lib / active_record / connection_adapters / abstract / database_statements.rb：201：
交易中的
/ home / admin / .rvm / gems / ruby​​-2.1.5 / gems / activerecord-4.1.8 / lib / active_record / connection_adapters / abstract / database_statements.rb：209：in
within_new_transa '
/home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/connection_adapters/abstract/database_statements.rb:201:in
transaction'
/home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/transactions.rb:208:in transaction'
/home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:1037:in
ddl_transaction'
/home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:990:in
execute_migration_in_transaction'
/home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:952:in
迁移中的块'
/home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:948:in
每个'
/home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:948 ：在
中迁移'
/home/admin/.rvm/gems/ruby-2.1.5/ gems / activerecord-4.1.8 / lib / active_record / migration.rb：807：在
up'
/home/admin/.rvm/gems/ruby-2.1中。 5 / gems / activerecord-4.1.8 / lib / active_record / migration.rb：785：在
migrate'
/home/admin/.rvm/gems/ruby-2.1中.5 / gems / activerecord-4.1.8 / lib / active_record / railties / databases.rake：34：任务：TOP => db：migrate中的
块（2个级别） （请通过使用--trace运行任务来查看
的完整跟踪信息）

PG::DuplicateTable: ERROR: relation "posts" already exists : CREATE TABLE "posts" ("id" serial primary key, "post" text, "release_date" timestamp, "created_at" timestamp, "updated_at" timestamp) /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/connection_adapters/postgresql/database_statements.rb:128:in async_exec' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/connection_adapters/postgresql/database_statements.rb:128:in block in execute' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/connection_adapters/abstract_adapter.rb:373:in block in log' /home/admin/.rvm/gems/ruby-2.1.5/gems/activesupport-4.1.8/lib/active_support/notifications/instrumenter.rb:20:in instrument' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/connection_adapters/abstract_adapter.rb:367:in log' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/connection_adapters/postgresql/database_statements.rb:127:in execute' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/connection_adapters/abstract/schema_statements.rb:205:in create_table' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:649:in block in method_missing' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:621:in block in say_with_time' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:621:in say_with_time' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:641:in method_missing' /home/admin/Desktop/postr/db/migrate/20141219011612_post_posts.rb:3:in up' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:598:in exec_migration' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:579:in block (2 levels) in migrate' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:578:in block in migrate' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:294:in with_connection' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:577:in migrate' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:752:in migrate' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:991:in block in execute_migration_in_transaction' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:1037:in block in ddl_transaction' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/connection_adapters/abstract/database_statements.rb:201:in block in transaction' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/connection_adapters/abstract/database_statements.rb:209:in within_new_transaction' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/connection_adapters/abstract/database_statements.rb:201:in transaction' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/transactions.rb:208:intransaction' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:1037:in ddl_transaction' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:990:in execute_migration_in_transaction' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:952:in block in migrate' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:948:in each' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:948:in migrate' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:807:in up' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:785:in migrate' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/railties/databases.rake:34:in block (2 levels) in ' ActiveRecord::StatementInvalid: PG::DuplicateTable: ERROR: relation "posts" already exists : CREATE TABLE "posts" ("id" serial primary key, "post" text, "release_date" timestamp, "created_at" timestamp, "updated_at" timestamp) /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/connection_adapters/postgresql/database_statements.rb:128:in async_exec' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/connection_adapters/postgresql/database_statements.rb:128:in block in execute' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/connection_adapters/abstract_adapter.rb:373:in block in log' /home/admin/.rvm/gems/ruby-2.1.5/gems/activesupport-4.1.8/lib/active_support/notifications/instrumenter.rb:20:in instrument' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/connection_adapters/abstract_adapter.rb:367:in log' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/connection_adapters/postgresql/database_statements.rb:127:in execute' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/connection_adapters/abstract/schema_statements.rb:205:in create_table' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:649:in block in method_missing' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:621:in block in say_with_time' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:621:in say_with_time' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:641:in method_missing' /home/admin/Desktop/postr/db/migrate/20141219011612_post_posts.rb:3:in up' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:598:in exec_migration' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:579:in block (2 levels) in migrate' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:578:in block in migrate' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:294:in with_connection' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:577:in migrate' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:752:in migrate' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:991:in block in execute_migration_in_transaction' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:1037:in block in ddl_transaction' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/connection_adapters/abstract/database_statements.rb:201:in block in transaction' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/connection_adapters/abstract/database_statements.rb:209:in within_new_transaction' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/connection_adapters/abstract/database_statements.rb:201:in transaction' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/transactions.rb:208:intransaction' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:1037:in ddl_transaction' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:990:in execute_migration_in_transaction' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:952:in block in migrate' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:948:in each' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:948:in migrate' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:807:in up' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:785:in migrate' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/railties/databases.rake:34:in block (2 levels) in ' PG::DuplicateTable: ERROR: relation "posts" already exists /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/connection_adapters/postgresql/database_statements.rb:128:in async_exec' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/connection_adapters/postgresql/database_statements.rb:128:in block in execute' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/connection_adapters/abstract_adapter.rb:373:in block in log' /home/admin/.rvm/gems/ruby-2.1.5/gems/activesupport-4.1.8/lib/active_support/notifications/instrumenter.rb:20:in instrument' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/connection_adapters/abstract_adapter.rb:367:in log' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/connection_adapters/postgresql/database_statements.rb:127:in execute' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/connection_adapters/abstract/schema_statements.rb:205:in create_table' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:649:in block in method_missing' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:621:in block in say_with_time' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:621:in say_with_time' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:641:in method_missing' /home/admin/Desktop/postr/db/migrate/20141219011612_post_posts.rb:3:in up' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:598:in exec_migration' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:579:in block (2 levels) in migrate' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:578:in block in migrate' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:294:in with_connection' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:577:in migrate' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:752:in migrate' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:991:in block in execute_migration_in_transaction' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:1037:in block in ddl_transaction' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/connection_adapters/abstract/database_statements.rb:201:in block in transaction' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/connection_adapters/abstract/database_statements.rb:209:in within_new_transaction' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/connection_adapters/abstract/database_statements.rb:201:in transaction' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/transactions.rb:208:intransaction' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:1037:in ddl_transaction' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:990:in execute_migration_in_transaction' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:952:in block in migrate' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:948:in each' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:948:in migrate' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:807:in up' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/migration.rb:785:in migrate' /home/admin/.rvm/gems/ruby-2.1.5/gems/activerecord-4.1.8/lib/active_record/railties/databases.rake:34:in block (2 levels) in ' Tasks: TOP => db:migrate (See full trace by running task with --trace)

我不理解这是怎么可能的，因为在方案文件中，我没有发布表。

I don't understund how this is possible, bescause In scheme file I don't have post table.

推荐答案

不知何故，您最终在自己的表中创建了一个名为 posts的表数据库。也许是从先前的迁移中删除的而没有回滚？如果您不关心数据库中的任何数据，则可以运行

Somehow, you ended up with a table named 'posts' in your database. Perhaps from a prior migration that you deleted without rolling back? If you don't care about any of your data in the database, you can run

rake db:drop db:create db:migrate

使您的开发数据库与当前迁移保持一致。

to bring your development database inline with your current migrations.

如果您不想丢失其他表中的数据，请打开数据库控制台并手动删除posts表：

If you have data in other tables you don't want to lose, open the database console and drop the posts table manually:

$ rails db

# drop table posts;

然后再次运行 db：migrate 。

这篇关于PG :: DuplicateTable：错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！