Skip to content

Instantly share code, notes, and snippets.

@cmrd-senya
Created March 4, 2016 12:17
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save cmrd-senya/9ed26b8430233b1d14c0 to your computer and use it in GitHub Desktop.
Save cmrd-senya/9ed26b8430233b1d14c0 to your computer and use it in GitHub Desktop.
user@debian:~/diaspora$ bin/rake db:migrate
Running via Spring preloader in process 2954
[2016-03-04T15:17:03] DEBUG PID-2954 TID-19257700 ActiveRecord::Base: ActiveRecord::SchemaMigration Load (0.5ms) SELECT "schema_migrations".* FROM "schema_migrations"
[2016-03-04T15:17:03] INFO PID-2954 TID-19257700 ActiveRecord::Base: Migrating to LinkShareVisibilitiesWithUser (20160225232049)
[2016-03-04T15:17:03] DEBUG PID-2954 TID-19257700 ActiveRecord::Base: (0.2ms) BEGIN
== 20160225232049 LinkShareVisibilitiesWithUser: migrating ====================
[2016-03-04T15:17:03] DEBUG PID-2954 TID-19257700 ActiveRecord::Base: SQL (1.4ms) DELETE FROM "share_visibilities" WHERE "share_visibilities"."id" IN (SELECT "share_visibilities"."id" FROM "share_visibilities" LEFT OUTER JOIN posts ON posts.id = share_visibilities.shareable_id WHERE "share_visibilities"."shareable_type" = $1 AND (posts.id is NULL)) [["shareable_type", "Post"]]
[2016-03-04T15:17:03] DEBUG PID-2954 TID-19257700 ActiveRecord::Base: SQL (0.7ms) DELETE FROM "share_visibilities" WHERE "share_visibilities"."id" IN (SELECT "share_visibilities"."id" FROM "share_visibilities" LEFT OUTER JOIN photos ON photos.id = share_visibilities.shareable_id WHERE "share_visibilities"."shareable_type" = $1 AND (photos.id is NULL)) [["shareable_type", "Photo"]]
-- remove_columns(:share_visibilities, :created_at, :updated_at)
[2016-03-04T15:17:03] DEBUG PID-2954 TID-19257700 ActiveRecord::Base: (0.6ms) ALTER TABLE "share_visibilities" DROP "created_at"
[2016-03-04T15:17:03] DEBUG PID-2954 TID-19257700 ActiveRecord::Base: (0.2ms) ALTER TABLE "share_visibilities" DROP "updated_at"
-> 0.0022s
-- add_column(:share_visibilities, :user_id, :integer)
[2016-03-04T15:17:03] DEBUG PID-2954 TID-19257700 ActiveRecord::Base: (0.3ms) ALTER TABLE "share_visibilities" ADD "user_id" integer
-> 0.0012s
[2016-03-04T15:17:03] DEBUG PID-2954 TID-19257700 ActiveRecord::Base: SQL (1.0ms) UPDATE "share_visibilities" SET share_visibilities.user_id = contacts.user_id WHERE "share_visibilities"."id" IN (SELECT "share_visibilities"."id" FROM "share_visibilities" INNER JOIN contacts ON share_visibilities.contact_id = contacts.id)
[2016-03-04T15:17:03] DEBUG PID-2954 TID-19257700 ActiveRecord::Base: (0.2ms) ROLLBACK
rake aborted!
StandardError: An error has occurred, this and all later migrations canceled:
PG::UndefinedTable: ОШИБКА: таблица "contacts" отсутствует в предложении FROM
LINE 1: ...re_visibilities" SET share_visibilities.user_id = contacts.u...
^
: UPDATE "share_visibilities" SET share_visibilities.user_id = contacts.user_id WHERE "share_visibilities"."id" IN (SELECT "share_visibilities"."id" FROM "share_visibilities" INNER JOIN contacts ON share_visibilities.contact_id = contacts.id)/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/connection_adapters/postgresql_adapter.rb:592:in `async_exec'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/connection_adapters/postgresql_adapter.rb:592:in `block in exec_no_cache'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/connection_adapters/abstract_adapter.rb:472:in `block in log'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activesupport-4.2.5.1/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/connection_adapters/abstract_adapter.rb:466:in `log'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/connection_adapters/postgresql_adapter.rb:592:in `exec_no_cache'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/connection_adapters/postgresql_adapter.rb:584:in `execute_and_clear'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/connection_adapters/postgresql/database_statements.rb:173:in `exec_delete'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/connection_adapters/abstract/database_statements.rb:114:in `update'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/connection_adapters/abstract/query_cache.rb:14:in `update'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/relation.rb:345:in `update_all'
/home/user/diaspora/db/migrate/20160225232049_link_share_visibilities_with_user.rb:9:in `up'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/migration.rb:611:in `exec_migration'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/migration.rb:592:in `block (2 levels) in migrate'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/migration.rb:591:in `block in migrate'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:292:in `with_connection'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/migration.rb:590:in `migrate'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/migration.rb:768:in `migrate'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/migration.rb:998:in `block in execute_migration_in_transaction'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/migration.rb:1044:in `block in ddl_transaction'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/connection_adapters/abstract/database_statements.rb:213:in `block in transaction'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/connection_adapters/abstract/transaction.rb:184:in `within_new_transaction'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/connection_adapters/abstract/database_statements.rb:213:in `transaction'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/transactions.rb:220:in `transaction'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/migration.rb:1044:in `ddl_transaction'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/migration.rb:997:in `execute_migration_in_transaction'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/migration.rb:959:in `block in migrate'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/migration.rb:955:in `each'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/migration.rb:955:in `migrate'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/migration.rb:823:in `up'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/migration.rb:801:in `migrate'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/tasks/database_tasks.rb:137:in `migrate'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/railties/databases.rake:44:in `block (2 levels) in <top (required)>'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activesupport-4.2.5.1/lib/active_support/dependencies.rb:268:in `load'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activesupport-4.2.5.1/lib/active_support/dependencies.rb:268:in `block in load'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activesupport-4.2.5.1/lib/active_support/dependencies.rb:240:in `load_dependency'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activesupport-4.2.5.1/lib/active_support/dependencies.rb:268:in `load'
-e:1:in `<main>'
ActiveRecord::StatementInvalid: PG::UndefinedTable: ОШИБКА: таблица "contacts" отсутствует в предложении FROM
LINE 1: ...re_visibilities" SET share_visibilities.user_id = contacts.u...
^
: UPDATE "share_visibilities" SET share_visibilities.user_id = contacts.user_id WHERE "share_visibilities"."id" IN (SELECT "share_visibilities"."id" FROM "share_visibilities" INNER JOIN contacts ON share_visibilities.contact_id = contacts.id)
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/connection_adapters/postgresql_adapter.rb:592:in `async_exec'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/connection_adapters/postgresql_adapter.rb:592:in `block in exec_no_cache'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/connection_adapters/abstract_adapter.rb:472:in `block in log'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activesupport-4.2.5.1/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/connection_adapters/abstract_adapter.rb:466:in `log'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/connection_adapters/postgresql_adapter.rb:592:in `exec_no_cache'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/connection_adapters/postgresql_adapter.rb:584:in `execute_and_clear'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/connection_adapters/postgresql/database_statements.rb:173:in `exec_delete'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/connection_adapters/abstract/database_statements.rb:114:in `update'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/connection_adapters/abstract/query_cache.rb:14:in `update'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/relation.rb:345:in `update_all'
/home/user/diaspora/db/migrate/20160225232049_link_share_visibilities_with_user.rb:9:in `up'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/migration.rb:611:in `exec_migration'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/migration.rb:592:in `block (2 levels) in migrate'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/migration.rb:591:in `block in migrate'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:292:in `with_connection'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/migration.rb:590:in `migrate'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/migration.rb:768:in `migrate'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/migration.rb:998:in `block in execute_migration_in_transaction'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/migration.rb:1044:in `block in ddl_transaction'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/connection_adapters/abstract/database_statements.rb:213:in `block in transaction'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/connection_adapters/abstract/transaction.rb:184:in `within_new_transaction'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/connection_adapters/abstract/database_statements.rb:213:in `transaction'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/transactions.rb:220:in `transaction'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/migration.rb:1044:in `ddl_transaction'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/migration.rb:997:in `execute_migration_in_transaction'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/migration.rb:959:in `block in migrate'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/migration.rb:955:in `each'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/migration.rb:955:in `migrate'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/migration.rb:823:in `up'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/migration.rb:801:in `migrate'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/tasks/database_tasks.rb:137:in `migrate'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/railties/databases.rake:44:in `block (2 levels) in <top (required)>'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activesupport-4.2.5.1/lib/active_support/dependencies.rb:268:in `load'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activesupport-4.2.5.1/lib/active_support/dependencies.rb:268:in `block in load'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activesupport-4.2.5.1/lib/active_support/dependencies.rb:240:in `load_dependency'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activesupport-4.2.5.1/lib/active_support/dependencies.rb:268:in `load'
-e:1:in `<main>'
PG::UndefinedTable: ОШИБКА: таблица "contacts" отсутствует в предложении FROM
LINE 1: ...re_visibilities" SET share_visibilities.user_id = contacts.u...
^
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/connection_adapters/postgresql_adapter.rb:592:in `async_exec'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/connection_adapters/postgresql_adapter.rb:592:in `block in exec_no_cache'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/connection_adapters/abstract_adapter.rb:472:in `block in log'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activesupport-4.2.5.1/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/connection_adapters/abstract_adapter.rb:466:in `log'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/connection_adapters/postgresql_adapter.rb:592:in `exec_no_cache'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/connection_adapters/postgresql_adapter.rb:584:in `execute_and_clear'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/connection_adapters/postgresql/database_statements.rb:173:in `exec_delete'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/connection_adapters/abstract/database_statements.rb:114:in `update'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/connection_adapters/abstract/query_cache.rb:14:in `update'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/relation.rb:345:in `update_all'
/home/user/diaspora/db/migrate/20160225232049_link_share_visibilities_with_user.rb:9:in `up'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/migration.rb:611:in `exec_migration'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/migration.rb:592:in `block (2 levels) in migrate'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/migration.rb:591:in `block in migrate'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:292:in `with_connection'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/migration.rb:590:in `migrate'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/migration.rb:768:in `migrate'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/migration.rb:998:in `block in execute_migration_in_transaction'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/migration.rb:1044:in `block in ddl_transaction'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/connection_adapters/abstract/database_statements.rb:213:in `block in transaction'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/connection_adapters/abstract/transaction.rb:184:in `within_new_transaction'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/connection_adapters/abstract/database_statements.rb:213:in `transaction'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/transactions.rb:220:in `transaction'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/migration.rb:1044:in `ddl_transaction'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/migration.rb:997:in `execute_migration_in_transaction'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/migration.rb:959:in `block in migrate'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/migration.rb:955:in `each'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/migration.rb:955:in `migrate'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/migration.rb:823:in `up'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/migration.rb:801:in `migrate'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/tasks/database_tasks.rb:137:in `migrate'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activerecord-4.2.5.1/lib/active_record/railties/databases.rake:44:in `block (2 levels) in <top (required)>'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activesupport-4.2.5.1/lib/active_support/dependencies.rb:268:in `load'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activesupport-4.2.5.1/lib/active_support/dependencies.rb:268:in `block in load'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activesupport-4.2.5.1/lib/active_support/dependencies.rb:240:in `load_dependency'
/home/user/.rvm/gems/ruby-2.2.1@diaspora/gems/activesupport-4.2.5.1/lib/active_support/dependencies.rb:268:in `load'
-e:1:in `<main>'
Tasks: TOP => db:migrate
(See full trace by running task with --trace)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment