search

posty / posty_api

Utility to administrate mailserver based on postfix and dovecot
www.posty-soft.org
Other
85 stars 19 forks source link

postgresql db:migrate issue #4

Closed ronnyf closed 10 years ago

ronnyf commented 10 years ago

* Invoke db:migrate (first_time) * Invoke environment (first_time) * Execute environment * Execute db:migrate == CreateVirtualDomains: migrating =========================================== -- create_table(:virtual_domains) -> 0.0139s == CreateVirtualDomains: migrated (0.0142s) ==================================

== CreateVirtualUsers: migrating ============================================= -- create_table(:virtual_users) -> 0.0121s == CreateVirtualUsers: migrated (0.0124s) ====================================

== CreateVirtualAliases: migrating =========================================== -- create_table(:virtual_aliases) -> 0.0135s == CreateVirtualAliases: migrated (0.0137s) ==================================

== AddViews: migrating ======================================================= -- create_view(:users_view, "select Concat(virtual_users.name, '@', virtual_domains.name) as email, password from virtual_users, virtual_domains where virtual_users.virtual_domain_id = virtual_domains.id") -> 0.0023s -- create_view(:aliases_view, "select Concat(virtual_aliases.source, '@', virtual_domains.name) as source, Concat(virtual_aliases.destination, '@', virtual_domains.name) as destination from virtual_aliases, virtual_domains where virtual_aliases.virtual_domain_id = virtual_domains.id") -> 0.0017s == AddViews: migrated (0.0044s) ==============================================

== CreateVirtualDomainAliases: migrating ===================================== -- create_table(:virtual_domain_aliases) -> 0.0092s == CreateVirtualDomainAliases: migrated (0.0094s) ============================

== AddDomainAliasesViews: migrating ========================================== -- create_view(:domain_aliases_view, "select Concat('@', virtual_domain_aliases.name) as source, Concat('@', virtual_domains.name) as destination from virtual_domain_aliases, virtual_domains where virtual_domain_aliases.virtual_domain_id = virtual_domains.id") -> 0.0020s == AddDomainAliasesViews: migrated (0.0022s) =================================

== CreateUserAliases: migrating ============================================== -- create_table(:virtual_user_aliases) -> 0.0090s -- drop_table(:virtual_aliases) rake aborted! An error has occurred, this and all later migrations canceled:

PG::DependentObjectsStillExist: ERROR: cannot drop table virtual_aliases because other objects depend on it DETAIL: view aliases_view depends on table virtual_aliases HINT: Use DROP ... CASCADE to drop the dependent objects too. : DROP TABLE "virtual_aliases"/usr/local/lib/ruby/gems/2.0.0/gems/activerecord-3.2.15/lib/active_record/connection_adapters/postgresql_adapter.rb:650:in exec' /usr/local/lib/ruby/gems/2.0.0/gems/activerecord-3.2.15/lib/active_record/connection_adapters/postgresql_adapter.rb:650:inblock in execute' /usr/local/lib/ruby/gems/2.0.0/gems/activerecord-3.2.15/lib/active_record/connection_adapters/abstract_adapter.rb:280:in block in log' /usr/local/lib/ruby/gems/2.0.0/gems/activesupport-3.2.15/lib/active_support/notifications/instrumenter.rb:20:ininstrument' /usr/local/lib/ruby/gems/2.0.0/gems/activerecord-3.2.15/lib/active_record/connection_adapters/abstract_adapter.rb:275:in log' /usr/local/lib/ruby/gems/2.0.0/gems/activerecord-3.2.15/lib/active_record/connection_adapters/postgresql_adapter.rb:649:inexecute' /usr/local/lib/ruby/gems/2.0.0/gems/activerecord-3.2.15/lib/active_record/connection_adapters/abstract/schema_statements.rb:256:in drop_table' /usr/local/lib/ruby/gems/2.0.0/gems/schema_plus-0.4.1/lib/schema_plus/active_record/connection_adapters/abstract_adapter.rb:117:indrop_table_with_schema_plus' /usr/local/lib/ruby/gems/2.0.0/gems/activerecord-3.2.15/lib/active_record/migration.rb:466:in block in method_missing' /usr/local/lib/ruby/gems/2.0.0/gems/activerecord-3.2.15/lib/active_record/migration.rb:438:inblock in say_with_time' /usr/local/lib/ruby/2.0.0/benchmark.rb:281:in measure' /usr/local/lib/ruby/gems/2.0.0/gems/activerecord-3.2.15/lib/active_record/migration.rb:438:insay_with_time' /usr/local/lib/ruby/gems/2.0.0/gems/activerecord-3.2.15/lib/active_record/migration.rb:458:in method_missing' /usr/local/lib/ruby/gems/2.0.0/gems/activerecord-3.2.15/lib/active_record/migration.rb:334:inmethod_missing' /var/www/posty_api/db/migrate/20130812172949_create_user_aliases.rb:9:in up' /usr/local/lib/ruby/gems/2.0.0/gems/activerecord-3.2.15/lib/active_record/migration.rb:370:inup' /usr/local/lib/ruby/gems/2.0.0/gems/activerecord-3.2.15/lib/active_record/migration.rb:410:in block (2 levels) in migrate' /usr/local/lib/ruby/2.0.0/benchmark.rb:281:inmeasure' /usr/local/lib/ruby/gems/2.0.0/gems/activerecord-3.2.15/lib/active_record/migration.rb:410:in block in migrate' /usr/local/lib/ruby/gems/2.0.0/gems/activerecord-3.2.15/lib/active_record/connection_adapters/abstract/connection_pool.rb:129:inwith_connection' /usr/local/lib/ruby/gems/2.0.0/gems/activerecord-3.2.15/lib/active_record/migration.rb:389:in migrate' /usr/local/lib/ruby/gems/2.0.0/gems/activerecord-3.2.15/lib/active_record/migration.rb:528:inmigrate' /usr/local/lib/ruby/gems/2.0.0/gems/activerecord-3.2.15/lib/active_record/migration.rb:720:in block (2 levels) in migrate' /usr/local/lib/ruby/gems/2.0.0/gems/activerecord-3.2.15/lib/active_record/migration.rb:775:incall' /usr/local/lib/ruby/gems/2.0.0/gems/activerecord-3.2.15/lib/active_record/migration.rb:775:in block in ddl_transaction' /usr/local/lib/ruby/gems/2.0.0/gems/activerecord-3.2.15/lib/active_record/connection_adapters/abstract/database_statements.rb:192:intransaction' /usr/local/lib/ruby/gems/2.0.0/gems/activerecord-3.2.15/lib/active_record/transactions.rb:208:in transaction' /usr/local/lib/ruby/gems/2.0.0/gems/activerecord-3.2.15/lib/active_record/migration.rb:775:inddl_transaction' /usr/local/lib/ruby/gems/2.0.0/gems/activerecord-3.2.15/lib/active_record/migration.rb:719:in block in migrate' /usr/local/lib/ruby/gems/2.0.0/gems/activerecord-3.2.15/lib/active_record/migration.rb:700:ineach' /usr/local/lib/ruby/gems/2.0.0/gems/activerecord-3.2.15/lib/active_record/migration.rb:700:in migrate' /usr/local/lib/ruby/gems/2.0.0/gems/activerecord-3.2.15/lib/active_record/migration.rb:570:inup' /usr/local/lib/ruby/gems/2.0.0/gems/activerecord-3.2.15/lib/active_record/migration.rb:551:in migrate' /var/www/posty_api/Rakefile:17:inblock (2 levels) in <top (required)>' /usr/local/lib/ruby/gems/2.0.0/gems/rake-10.0.4/lib/rake/task.rb:246:in call' /usr/local/lib/ruby/gems/2.0.0/gems/rake-10.0.4/lib/rake/task.rb:246:inblock in execute' /usr/local/lib/ruby/gems/2.0.0/gems/rake-10.0.4/lib/rake/task.rb:241:in each' /usr/local/lib/ruby/gems/2.0.0/gems/rake-10.0.4/lib/rake/task.rb:241:inexecute' /usr/local/lib/ruby/gems/2.0.0/gems/rake-10.0.4/lib/rake/task.rb:184:in block in invoke_with_call_chain' /usr/local/lib/ruby/2.0.0/monitor.rb:211:inmon_synchronize' /usr/local/lib/ruby/gems/2.0.0/gems/rake-10.0.4/lib/rake/task.rb:177:in invoke_with_call_chain' /usr/local/lib/ruby/gems/2.0.0/gems/rake-10.0.4/lib/rake/task.rb:170:ininvoke' /usr/local/lib/ruby/gems/2.0.0/gems/rake-10.0.4/lib/rake/application.rb:143:in invoke_task' /usr/local/lib/ruby/gems/2.0.0/gems/rake-10.0.4/lib/rake/application.rb:101:inblock (2 levels) in top_level' /usr/local/lib/ruby/gems/2.0.0/gems/rake-10.0.4/lib/rake/application.rb:101:in each' /usr/local/lib/ruby/gems/2.0.0/gems/rake-10.0.4/lib/rake/application.rb:101:inblock in top_level' /usr/local/lib/ruby/gems/2.0.0/gems/rake-10.0.4/lib/rake/application.rb:110:in run_with_threads' /usr/local/lib/ruby/gems/2.0.0/gems/rake-10.0.4/lib/rake/application.rb:95:intop_level' /usr/local/lib/ruby/gems/2.0.0/gems/rake-10.0.4/lib/rake/application.rb:73:in block in run' /usr/local/lib/ruby/gems/2.0.0/gems/rake-10.0.4/lib/rake/application.rb:160:instandard_exception_handling' /usr/local/lib/ruby/gems/2.0.0/gems/rake-10.0.4/lib/rake/application.rb:70:in run' /usr/local/lib/ruby/gems/2.0.0/gems/rake-10.0.4/bin/rake:33:in<top (required)>' /usr/local/bin/rake:23:in load' /usr/local/bin/rake:23:in

' Tasks: TOP => db:migrate

fixed by switching updating db/migrate/20130812172949_create_user_aliases.rb

class CreateUserAliases < ActiveRecord::Migration def self.up create_table :virtual_user_aliases do |t| t.integer :virtual_user_id t.string :name t.timestamps end

drop_view :aliases_view
drop_table :virtual_aliases

end

def self.down drop_table :virtual_user_aliases end end

chicobico commented 10 years ago

Thx ronnyf for your issue report. I fix it in the next version.