postgreSQL migration error

406 views
Skip to first unread message

Cap Mission

unread,
Oct 5, 2015, 7:08:02 AM10/5/15
to Canvas LMS Users
Hi,

I update canvas and follow those explanations : wiki canvas.

Everything works well but there is an error with the database migration when i do this command : 

RAILS_ENV=production $GEM_HOME/bin/bundle exec rake db:migrate --trace


I got this following error : 

** Invoke db:migrate (first_time)

** Invoke environment (first_time)

** Execute environment

** Invoke db:load_config (first_time)

** Execute db:load_config

** Execute db:migrate

1: production:public

==  PopulateGroupCategoryOnDiscussionTopics: migrating ========================

rake aborted!

StandardError: An error has occurred, this and all later migrations canceled:


PG::UndefinedTable: ERROR:  relation "delayed_jobs" does not exist

LINE 5:              WHERE a.attrelid = '"delayed_jobs"'::regclass

                                        ^

:             SELECT a.attname, format_type(a.atttypid, a.atttypmod),

                     pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod

              FROM pg_attribute a LEFT JOIN pg_attrdef d

                ON a.attrelid = d.adrelid AND a.attnum = d.adnum

             WHERE a.attrelid = '"delayed_jobs"'::regclass

               AND a.attnum > 0 AND NOT a.attisdropped

             ORDER BY a.attnum

/home/capmission/.gem/ruby/2.1.0/gems/rack-mini-profiler-0.9.2/lib/patches/sql_patches.rb:160:in `exec'

/home/capmission/.gem/ruby/2.1.0/gems/rack-mini-profiler-0.9.2/lib/patches/sql_patches.rb:160:in `async_exec'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/connection_adapters/postgresql_adapter.rb:1163:in `exec_no_cache'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/connection_adapters/postgresql_adapter.rb:660:in `block in exec_query'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/connection_adapters/abstract_adapter.rb:280:in `block in log'

/home/capmission/.gem/ruby/2.1.0/gems/activesupport-3.2.22/lib/active_support/notifications/instrumenter.rb:20:in `instrument'

/home/capmission/.gem/ruby/2.1.0/gems/switchman-1.2.40/lib/switchman/sharded_instrumenter.rb:20:in `instrument'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/connection_adapters/abstract_adapter.rb:275:in `log'

/home/capmission/.gem/ruby/2.1.0/gems/switchman-1.2.40/lib/switchman/active_record/abstract_adapter.rb:20:in `log_with_timestamp'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/connection_adapters/postgresql_adapter.rb:659:in `exec_query'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/connection_adapters/postgresql_adapter.rb:1292:in `column_definitions'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/connection_adapters/postgresql_adapter.rb:855:in `columns'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/connection_adapters/schema_cache.rb:12:in `block in initialize'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/model_schema.rb:229:in `yield'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/model_schema.rb:229:in `columns'

/home/capmission/canvas/config/initializers/dropped_columns.rb:122:in `columns_with_remove_dropped_columns'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/model_schema.rb:244:in `column_defaults'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/base.rb:482:in `initialize'

/home/capmission/.gem/ruby/2.1.0/gems/aroi-0.0.3/lib/aroi/instrumentation/active_record.rb:34:in `block in initialize'

/home/capmission/.gem/ruby/2.1.0/gems/activesupport-3.2.22/lib/active_support/notifications.rb:123:in `block in instrument'

/home/capmission/.gem/ruby/2.1.0/gems/activesupport-3.2.22/lib/active_support/notifications/instrumenter.rb:20:in `instrument'

/home/capmission/.gem/ruby/2.1.0/gems/activesupport-3.2.22/lib/active_support/notifications.rb:123:in `instrument'

/home/capmission/.gem/ruby/2.1.0/gems/aroi-0.0.3/lib/aroi/instrumentation/active_record.rb:33:in `initialize'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/persistence.rb:44:in `new'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/persistence.rb:44:in `create'

/home/capmission/.gem/ruby/2.1.0/gems/canvas-jobs-0.9.15/lib/delayed/backend/base.rb:75:in `enqueue'

/home/capmission/.gem/ruby/2.1.0/gems/canvas-jobs-0.9.15/lib/delayed/message_sending.rb:32:in `send_later_enqueue_args'

/home/capmission/.gem/ruby/2.1.0/gems/canvas-jobs-0.9.15/lib/delayed/message_sending.rb:71:in `send_later_if_production_enqueue_args'

/home/capmission/canvas/db/migrate/20140523164418_populate_group_category_on_discussion_topics.rb:5:in `up'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/migration.rb:370:in `up'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/migration.rb:410:in `block (2 levels) in migrate'

/usr/local/lib/ruby/2.1.0/benchmark.rb:279:in `measure'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/migration.rb:410:in `block in migrate'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/connection_adapters/abstract/connection_pool.rb:129:in `with_connection'

/home/capmission/.gem/ruby/2.1.0/gems/switchman-1.2.40/lib/switchman/connection_pool_proxy.rb:13:in `with_connection'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/migration.rb:389:in `migrate'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/migration.rb:338:in `migrate'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/migration.rb:528:in `migrate'

/home/capmission/canvas/config/initializers/active_record.rb:1259:in `block (2 levels) in migrate'

/home/capmission/canvas/config/initializers/active_record.rb:1273:in `block in ddl_transaction'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/connection_adapters/abstract/database_statements.rb:192:in `transaction'

/home/capmission/canvas/config/initializers/active_record.rb:1273:in `ddl_transaction'

/home/capmission/canvas/config/initializers/active_record.rb:1257:in `block in migrate'

/home/capmission/canvas/config/initializers/active_record.rb:1233:in `each'

/home/capmission/canvas/config/initializers/active_record.rb:1233:in `migrate'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/migration.rb:570:in `up'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/migration.rb:551:in `migrate'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/railties/databases.rake:193:in `block (2 levels) in <top (required)>'

/home/capmission/.gem/ruby/2.1.0/gems/switchman-1.2.40/lib/tasks/switchman.rake:51:in `call'

/home/capmission/.gem/ruby/2.1.0/gems/switchman-1.2.40/lib/tasks/switchman.rake:51:in `each'

/home/capmission/.gem/ruby/2.1.0/gems/switchman-1.2.40/lib/tasks/switchman.rake:51:in `block (4 levels) in shardify_task'

/home/capmission/.gem/ruby/2.1.0/gems/switchman-1.2.40/lib/switchman/database_server.rb:93:in `unshackle'

/home/capmission/.gem/ruby/2.1.0/gems/switchman-1.2.40/lib/tasks/switchman.rake:50:in `block (3 levels) in shardify_task'

/home/capmission/.gem/ruby/2.1.0/gems/switchman-1.2.40/app/models/switchman/shard.rb:298:in `block (2 levels) in with_each_shard'

/home/capmission/.gem/ruby/2.1.0/gems/switchman-1.2.40/app/models/switchman/shard.rb:61:in `activate'

/home/capmission/.gem/ruby/2.1.0/gems/switchman-1.2.40/app/models/switchman/shard.rb:481:in `activate'

/home/capmission/.gem/ruby/2.1.0/gems/switchman-1.2.40/app/models/switchman/shard.rb:296:in `block in with_each_shard'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/relation/delegation.rb:6:in `each'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/relation/delegation.rb:6:in `each'

/home/capmission/.gem/ruby/2.1.0/gems/switchman-1.2.40/app/models/switchman/shard.rb:292:in `with_each_shard'

/home/capmission/.gem/ruby/2.1.0/gems/switchman-1.2.40/lib/tasks/switchman.rake:45:in `block (2 levels) in shardify_task'

/home/capmission/.gem/ruby/2.1.0/gems/switchman-1.2.40/lib/switchman/shackles.rb:22:in `activate'

/home/capmission/.gem/ruby/2.1.0/gems/switchman-1.2.40/lib/tasks/switchman.rake:19:in `block in shardify_task'

/home/capmission/.gem/ruby/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:240:in `call'

/home/capmission/.gem/ruby/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:240:in `block in execute'

/home/capmission/.gem/ruby/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:235:in `each'

/home/capmission/.gem/ruby/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:235:in `execute'

/home/capmission/.gem/ruby/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:179:in `block in invoke_with_call_chain'

/usr/local/lib/ruby/2.1.0/monitor.rb:211:in `mon_synchronize'

/home/capmission/.gem/ruby/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:172:in `invoke_with_call_chain'

/home/capmission/.gem/ruby/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:165:in `invoke'

/home/capmission/.gem/ruby/2.1.0/gems/rake-10.4.2/lib/rake/application.rb:150:in `invoke_task'

/home/capmission/.gem/ruby/2.1.0/gems/rake-10.4.2/lib/rake/application.rb:106:in `block (2 levels) in top_level'

/home/capmission/.gem/ruby/2.1.0/gems/rake-10.4.2/lib/rake/application.rb:106:in `each'

/home/capmission/.gem/ruby/2.1.0/gems/rake-10.4.2/lib/rake/application.rb:106:in `block in top_level'

/home/capmission/.gem/ruby/2.1.0/gems/rake-10.4.2/lib/rake/application.rb:115:in `run_with_threads'

/home/capmission/.gem/ruby/2.1.0/gems/rake-10.4.2/lib/rake/application.rb:100:in `top_level'

/home/capmission/.gem/ruby/2.1.0/gems/rake-10.4.2/lib/rake/application.rb:78:in `block in run'

/home/capmission/.gem/ruby/2.1.0/gems/rake-10.4.2/lib/rake/application.rb:176:in `standard_exception_handling'

/home/capmission/.gem/ruby/2.1.0/gems/rake-10.4.2/lib/rake/application.rb:75:in `run'

/home/capmission/.gem/ruby/2.1.0/gems/rake-10.4.2/bin/rake:33:in `<top (required)>'

/home/capmission/.gem/ruby/2.1.0/bin/rake:23:in `load'

/home/capmission/.gem/ruby/2.1.0/bin/rake:23:in `<main>'

ActiveRecord::StatementInvalid: PG::UndefinedTable: ERROR:  relation "delayed_jobs" does not exist

LINE 5:              WHERE a.attrelid = '"delayed_jobs"'::regclass

                                        ^

:             SELECT a.attname, format_type(a.atttypid, a.atttypmod),

                     pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod

              FROM pg_attribute a LEFT JOIN pg_attrdef d

                ON a.attrelid = d.adrelid AND a.attnum = d.adnum

             WHERE a.attrelid = '"delayed_jobs"'::regclass

               AND a.attnum > 0 AND NOT a.attisdropped

             ORDER BY a.attnum

/home/capmission/.gem/ruby/2.1.0/gems/rack-mini-profiler-0.9.2/lib/patches/sql_patches.rb:160:in `exec'

/home/capmission/.gem/ruby/2.1.0/gems/rack-mini-profiler-0.9.2/lib/patches/sql_patches.rb:160:in `async_exec'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/connection_adapters/postgresql_adapter.rb:1163:in `exec_no_cache'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/connection_adapters/postgresql_adapter.rb:660:in `block in exec_query'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/connection_adapters/abstract_adapter.rb:280:in `block in log'

/home/capmission/.gem/ruby/2.1.0/gems/activesupport-3.2.22/lib/active_support/notifications/instrumenter.rb:20:in `instrument'

/home/capmission/.gem/ruby/2.1.0/gems/switchman-1.2.40/lib/switchman/sharded_instrumenter.rb:20:in `instrument'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/connection_adapters/abstract_adapter.rb:275:in `log'

/home/capmission/.gem/ruby/2.1.0/gems/switchman-1.2.40/lib/switchman/active_record/abstract_adapter.rb:20:in `log_with_timestamp'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/connection_adapters/postgresql_adapter.rb:659:in `exec_query'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/connection_adapters/postgresql_adapter.rb:1292:in `column_definitions'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/connection_adapters/postgresql_adapter.rb:855:in `columns'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/connection_adapters/schema_cache.rb:12:in `block in initialize'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/model_schema.rb:229:in `yield'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/model_schema.rb:229:in `columns'

/home/capmission/canvas/config/initializers/dropped_columns.rb:122:in `columns_with_remove_dropped_columns'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/model_schema.rb:244:in `column_defaults'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/base.rb:482:in `initialize'

/home/capmission/.gem/ruby/2.1.0/gems/aroi-0.0.3/lib/aroi/instrumentation/active_record.rb:34:in `block in initialize'

/home/capmission/.gem/ruby/2.1.0/gems/activesupport-3.2.22/lib/active_support/notifications.rb:123:in `block in instrument'

/home/capmission/.gem/ruby/2.1.0/gems/activesupport-3.2.22/lib/active_support/notifications/instrumenter.rb:20:in `instrument'

/home/capmission/.gem/ruby/2.1.0/gems/activesupport-3.2.22/lib/active_support/notifications.rb:123:in `instrument'

/home/capmission/.gem/ruby/2.1.0/gems/aroi-0.0.3/lib/aroi/instrumentation/active_record.rb:33:in `initialize'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/persistence.rb:44:in `new'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/persistence.rb:44:in `create'

/home/capmission/.gem/ruby/2.1.0/gems/canvas-jobs-0.9.15/lib/delayed/backend/base.rb:75:in `enqueue'

/home/capmission/.gem/ruby/2.1.0/gems/canvas-jobs-0.9.15/lib/delayed/message_sending.rb:32:in `send_later_enqueue_args'

/home/capmission/.gem/ruby/2.1.0/gems/canvas-jobs-0.9.15/lib/delayed/message_sending.rb:71:in `send_later_if_production_enqueue_args'

/home/capmission/canvas/db/migrate/20140523164418_populate_group_category_on_discussion_topics.rb:5:in `up'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/migration.rb:370:in `up'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/migration.rb:410:in `block (2 levels) in migrate'

/usr/local/lib/ruby/2.1.0/benchmark.rb:279:in `measure'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/migration.rb:410:in `block in migrate'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/connection_adapters/abstract/connection_pool.rb:129:in `with_connection'

/home/capmission/.gem/ruby/2.1.0/gems/switchman-1.2.40/lib/switchman/connection_pool_proxy.rb:13:in `with_connection'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/migration.rb:389:in `migrate'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/migration.rb:338:in `migrate'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/migration.rb:528:in `migrate'

/home/capmission/canvas/config/initializers/active_record.rb:1259:in `block (2 levels) in migrate'

/home/capmission/canvas/config/initializers/active_record.rb:1273:in `block in ddl_transaction'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/connection_adapters/abstract/database_statements.rb:192:in `transaction'

/home/capmission/canvas/config/initializers/active_record.rb:1273:in `ddl_transaction'

/home/capmission/canvas/config/initializers/active_record.rb:1257:in `block in migrate'

/home/capmission/canvas/config/initializers/active_record.rb:1233:in `each'

/home/capmission/canvas/config/initializers/active_record.rb:1233:in `migrate'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/migration.rb:570:in `up'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/migration.rb:551:in `migrate'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/railties/databases.rake:193:in `block (2 levels) in <top (required)>'

/home/capmission/.gem/ruby/2.1.0/gems/switchman-1.2.40/lib/tasks/switchman.rake:51:in `call'

/home/capmission/.gem/ruby/2.1.0/gems/switchman-1.2.40/lib/tasks/switchman.rake:51:in `each'

/home/capmission/.gem/ruby/2.1.0/gems/switchman-1.2.40/lib/tasks/switchman.rake:51:in `block (4 levels) in shardify_task'

/home/capmission/.gem/ruby/2.1.0/gems/switchman-1.2.40/lib/switchman/database_server.rb:93:in `unshackle'

/home/capmission/.gem/ruby/2.1.0/gems/switchman-1.2.40/lib/tasks/switchman.rake:50:in `block (3 levels) in shardify_task'

/home/capmission/.gem/ruby/2.1.0/gems/switchman-1.2.40/app/models/switchman/shard.rb:298:in `block (2 levels) in with_each_shard'

/home/capmission/.gem/ruby/2.1.0/gems/switchman-1.2.40/app/models/switchman/shard.rb:61:in `activate'

/home/capmission/.gem/ruby/2.1.0/gems/switchman-1.2.40/app/models/switchman/shard.rb:481:in `activate'

/home/capmission/.gem/ruby/2.1.0/gems/switchman-1.2.40/app/models/switchman/shard.rb:296:in `block in with_each_shard'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/relation/delegation.rb:6:in `each'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/relation/delegation.rb:6:in `each'

/home/capmission/.gem/ruby/2.1.0/gems/switchman-1.2.40/app/models/switchman/shard.rb:292:in `with_each_shard'

/home/capmission/.gem/ruby/2.1.0/gems/switchman-1.2.40/lib/tasks/switchman.rake:45:in `block (2 levels) in shardify_task'

/home/capmission/.gem/ruby/2.1.0/gems/switchman-1.2.40/lib/switchman/shackles.rb:22:in `activate'

/home/capmission/.gem/ruby/2.1.0/gems/switchman-1.2.40/lib/tasks/switchman.rake:19:in `block in shardify_task'

/home/capmission/.gem/ruby/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:240:in `call'

/home/capmission/.gem/ruby/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:240:in `block in execute'

/home/capmission/.gem/ruby/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:235:in `each'

/home/capmission/.gem/ruby/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:235:in `execute'

/home/capmission/.gem/ruby/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:179:in `block in invoke_with_call_chain'

/usr/local/lib/ruby/2.1.0/monitor.rb:211:in `mon_synchronize'

/home/capmission/.gem/ruby/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:172:in `invoke_with_call_chain'

/home/capmission/.gem/ruby/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:165:in `invoke'

/home/capmission/.gem/ruby/2.1.0/gems/rake-10.4.2/lib/rake/application.rb:150:in `invoke_task'

/home/capmission/.gem/ruby/2.1.0/gems/rake-10.4.2/lib/rake/application.rb:106:in `block (2 levels) in top_level'

/home/capmission/.gem/ruby/2.1.0/gems/rake-10.4.2/lib/rake/application.rb:106:in `each'

/home/capmission/.gem/ruby/2.1.0/gems/rake-10.4.2/lib/rake/application.rb:106:in `block in top_level'

/home/capmission/.gem/ruby/2.1.0/gems/rake-10.4.2/lib/rake/application.rb:115:in `run_with_threads'

/home/capmission/.gem/ruby/2.1.0/gems/rake-10.4.2/lib/rake/application.rb:100:in `top_level'

/home/capmission/.gem/ruby/2.1.0/gems/rake-10.4.2/lib/rake/application.rb:78:in `block in run'

/home/capmission/.gem/ruby/2.1.0/gems/rake-10.4.2/lib/rake/application.rb:176:in `standard_exception_handling'

/home/capmission/.gem/ruby/2.1.0/gems/rake-10.4.2/lib/rake/application.rb:75:in `run'

/home/capmission/.gem/ruby/2.1.0/gems/rake-10.4.2/bin/rake:33:in `<top (required)>'

/home/capmission/.gem/ruby/2.1.0/bin/rake:23:in `load'

/home/capmission/.gem/ruby/2.1.0/bin/rake:23:in `<main>'

PG::UndefinedTable: ERROR:  relation "delayed_jobs" does not exist

LINE 5:              WHERE a.attrelid = '"delayed_jobs"'::regclass

                                        ^

/home/capmission/.gem/ruby/2.1.0/gems/rack-mini-profiler-0.9.2/lib/patches/sql_patches.rb:160:in `exec'

/home/capmission/.gem/ruby/2.1.0/gems/rack-mini-profiler-0.9.2/lib/patches/sql_patches.rb:160:in `async_exec'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/connection_adapters/postgresql_adapter.rb:1163:in `exec_no_cache'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/connection_adapters/postgresql_adapter.rb:660:in `block in exec_query'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/connection_adapters/abstract_adapter.rb:280:in `block in log'

/home/capmission/.gem/ruby/2.1.0/gems/activesupport-3.2.22/lib/active_support/notifications/instrumenter.rb:20:in `instrument'

/home/capmission/.gem/ruby/2.1.0/gems/switchman-1.2.40/lib/switchman/sharded_instrumenter.rb:20:in `instrument'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/connection_adapters/abstract_adapter.rb:275:in `log'

/home/capmission/.gem/ruby/2.1.0/gems/switchman-1.2.40/lib/switchman/active_record/abstract_adapter.rb:20:in `log_with_timestamp'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/connection_adapters/postgresql_adapter.rb:659:in `exec_query'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/connection_adapters/postgresql_adapter.rb:1292:in `column_definitions'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/connection_adapters/postgresql_adapter.rb:855:in `columns'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/connection_adapters/schema_cache.rb:12:in `block in initialize'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/model_schema.rb:229:in `yield'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/model_schema.rb:229:in `columns'

/home/capmission/canvas/config/initializers/dropped_columns.rb:122:in `columns_with_remove_dropped_columns'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/model_schema.rb:244:in `column_defaults'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/base.rb:482:in `initialize'

/home/capmission/.gem/ruby/2.1.0/gems/aroi-0.0.3/lib/aroi/instrumentation/active_record.rb:34:in `block in initialize'

/home/capmission/.gem/ruby/2.1.0/gems/activesupport-3.2.22/lib/active_support/notifications.rb:123:in `block in instrument'

/home/capmission/.gem/ruby/2.1.0/gems/activesupport-3.2.22/lib/active_support/notifications/instrumenter.rb:20:in `instrument'

/home/capmission/.gem/ruby/2.1.0/gems/activesupport-3.2.22/lib/active_support/notifications.rb:123:in `instrument'

/home/capmission/.gem/ruby/2.1.0/gems/aroi-0.0.3/lib/aroi/instrumentation/active_record.rb:33:in `initialize'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/persistence.rb:44:in `new'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/persistence.rb:44:in `create'

/home/capmission/.gem/ruby/2.1.0/gems/canvas-jobs-0.9.15/lib/delayed/backend/base.rb:75:in `enqueue'

/home/capmission/.gem/ruby/2.1.0/gems/canvas-jobs-0.9.15/lib/delayed/message_sending.rb:32:in `send_later_enqueue_args'

/home/capmission/.gem/ruby/2.1.0/gems/canvas-jobs-0.9.15/lib/delayed/message_sending.rb:71:in `send_later_if_production_enqueue_args'

/home/capmission/canvas/db/migrate/20140523164418_populate_group_category_on_discussion_topics.rb:5:in `up'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/migration.rb:370:in `up'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/migration.rb:410:in `block (2 levels) in migrate'

/usr/local/lib/ruby/2.1.0/benchmark.rb:279:in `measure'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/migration.rb:410:in `block in migrate'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/connection_adapters/abstract/connection_pool.rb:129:in `with_connection'

/home/capmission/.gem/ruby/2.1.0/gems/switchman-1.2.40/lib/switchman/connection_pool_proxy.rb:13:in `with_connection'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/migration.rb:389:in `migrate'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/migration.rb:338:in `migrate'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/migration.rb:528:in `migrate'

/home/capmission/canvas/config/initializers/active_record.rb:1259:in `block (2 levels) in migrate'

/home/capmission/canvas/config/initializers/active_record.rb:1273:in `block in ddl_transaction'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/connection_adapters/abstract/database_statements.rb:192:in `transaction'

/home/capmission/canvas/config/initializers/active_record.rb:1273:in `ddl_transaction'

/home/capmission/canvas/config/initializers/active_record.rb:1257:in `block in migrate'

/home/capmission/canvas/config/initializers/active_record.rb:1233:in `each'

/home/capmission/canvas/config/initializers/active_record.rb:1233:in `migrate'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/migration.rb:570:in `up'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/migration.rb:551:in `migrate'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/railties/databases.rake:193:in `block (2 levels) in <top (required)>'

/home/capmission/.gem/ruby/2.1.0/gems/switchman-1.2.40/lib/tasks/switchman.rake:51:in `call'

/home/capmission/.gem/ruby/2.1.0/gems/switchman-1.2.40/lib/tasks/switchman.rake:51:in `each'

/home/capmission/.gem/ruby/2.1.0/gems/switchman-1.2.40/lib/tasks/switchman.rake:51:in `block (4 levels) in shardify_task'

/home/capmission/.gem/ruby/2.1.0/gems/switchman-1.2.40/lib/switchman/database_server.rb:93:in `unshackle'

/home/capmission/.gem/ruby/2.1.0/gems/switchman-1.2.40/lib/tasks/switchman.rake:50:in `block (3 levels) in shardify_task'

/home/capmission/.gem/ruby/2.1.0/gems/switchman-1.2.40/app/models/switchman/shard.rb:298:in `block (2 levels) in with_each_shard'

/home/capmission/.gem/ruby/2.1.0/gems/switchman-1.2.40/app/models/switchman/shard.rb:61:in `activate'

/home/capmission/.gem/ruby/2.1.0/gems/switchman-1.2.40/app/models/switchman/shard.rb:481:in `activate'

/home/capmission/.gem/ruby/2.1.0/gems/switchman-1.2.40/app/models/switchman/shard.rb:296:in `block in with_each_shard'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/relation/delegation.rb:6:in `each'

/home/capmission/.gem/ruby/2.1.0/gems/activerecord-3.2.22/lib/active_record/relation/delegation.rb:6:in `each'

/home/capmission/.gem/ruby/2.1.0/gems/switchman-1.2.40/app/models/switchman/shard.rb:292:in `with_each_shard'

/home/capmission/.gem/ruby/2.1.0/gems/switchman-1.2.40/lib/tasks/switchman.rake:45:in `block (2 levels) in shardify_task'

/home/capmission/.gem/ruby/2.1.0/gems/switchman-1.2.40/lib/switchman/shackles.rb:22:in `activate'

/home/capmission/.gem/ruby/2.1.0/gems/switchman-1.2.40/lib/tasks/switchman.rake:19:in `block in shardify_task'

/home/capmission/.gem/ruby/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:240:in `call'

/home/capmission/.gem/ruby/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:240:in `block in execute'

/home/capmission/.gem/ruby/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:235:in `each'

/home/capmission/.gem/ruby/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:235:in `execute'

/home/capmission/.gem/ruby/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:179:in `block in invoke_with_call_chain'

/usr/local/lib/ruby/2.1.0/monitor.rb:211:in `mon_synchronize'

/home/capmission/.gem/ruby/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:172:in `invoke_with_call_chain'

/home/capmission/.gem/ruby/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:165:in `invoke'

/home/capmission/.gem/ruby/2.1.0/gems/rake-10.4.2/lib/rake/application.rb:150:in `invoke_task'

/home/capmission/.gem/ruby/2.1.0/gems/rake-10.4.2/lib/rake/application.rb:106:in `block (2 levels) in top_level'

/home/capmission/.gem/ruby/2.1.0/gems/rake-10.4.2/lib/rake/application.rb:106:in `each'

/home/capmission/.gem/ruby/2.1.0/gems/rake-10.4.2/lib/rake/application.rb:106:in `block in top_level'

/home/capmission/.gem/ruby/2.1.0/gems/rake-10.4.2/lib/rake/application.rb:115:in `run_with_threads'

/home/capmission/.gem/ruby/2.1.0/gems/rake-10.4.2/lib/rake/application.rb:100:in `top_level'

/home/capmission/.gem/ruby/2.1.0/gems/rake-10.4.2/lib/rake/application.rb:78:in `block in run'

/home/capmission/.gem/ruby/2.1.0/gems/rake-10.4.2/lib/rake/application.rb:176:in `standard_exception_handling'

/home/capmission/.gem/ruby/2.1.0/gems/rake-10.4.2/lib/rake/application.rb:75:in `run'

/home/capmission/.gem/ruby/2.1.0/gems/rake-10.4.2/bin/rake:33:in `<top (required)>'

/home/capmission/.gem/ruby/2.1.0/bin/rake:23:in `load'

/home/capmission/.gem/ruby/2.1.0/bin/rake:23:in `<main>'

Tasks: TOP => db:migrate


Need some help !!!

Cody Cutrer

unread,
Oct 8, 2015, 1:03:31 PM10/8/15
to canvas-l...@googlegroups.com
Did you previously have a `queue` section under `production` in database.yml, and now you don't?

Cody Cutrer
Software Engineer
Instructure

--

---
You received this message because you are subscribed to the Google Groups "Canvas LMS Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to canvas-lms-use...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Cap Mission

unread,
Oct 14, 2015, 7:07:38 AM10/14/15
to Canvas LMS Users
Thanks I "resolved" my problem with a new fresh install.
But yes `queue` section was in `database.yml`

James Swash

unread,
Jun 20, 2016, 3:23:11 AM6/20/16
to Canvas LMS Users
Hi Cody,

I'm having the same problem, a fresh install works fine but I cannot upgrade the existing Canvas database. The last time it was upgraded was in February 2015. Do you have any advice or solutions I may try?

Regards,
James.

Cody Cutrer

unread,
Jun 20, 2016, 12:13:17 PM6/20/16
to canvas-l...@googlegroups.com
James,

Which release are you updating to? I'd recommend going to the 2016-04-23 release, and then running db:migrate:predeploy first, and then db:migrate. If it still fails, I'd like to see the stack trace of which migration it is.

Cody Cutrer
Software Engineer
Instructure

James Swash

unread,
Jun 22, 2016, 8:11:49 AM6/22/16
to Canvas LMS Users
Hi Cody, thanks for the reply.
I'll give the pre deploy a try and see if that helps. I believe I am trying to upgrade to the latest stable.
Previously my database.yml contained a queue entry, I've tried upgrading with and without the entry but I still get the issue with the delayed jobs tables being missing.
Can you suggest if I can leave the database.yml with the queue entry or remove it?

Cody Cutrer

unread,
Jun 22, 2016, 3:35:55 PM6/22/16
to canvas-l...@googlegroups.com
If you previously had a queue entry in database.yml, you should leave it in until migrations have run. One of the migrations is to copy that table from the other database into the main database, and it can't do that if it doesn't know where it is. Once the migration has run, it will ignore the queue section in database.yml, and you can safely remove it.

Cody Cutrer
Software Engineer
Instructure

James Swash

unread,
Jun 27, 2016, 8:45:04 AM6/27/16
to Canvas LMS Users
Thanks for the suggestions Cody, I'm getting an error on the pre deploy, the start of the stack trace looks like this.
RAILS_ENV=production bundle exec rake db:migrate:predeploy --trace
** Invoke db:migrate:predeploy (first_time)

** Invoke environment (first_time)
** Execute environment
** Invoke db:load_config (first_time)
** Execute db:load_config
** Execute db:migrate:predeploy
default: production
==  AddMaxConcurrentToJobs: migrating =========================================
-- add_column(:delayed_jobs, :max_concurrent, :integer, {:default=>1, :null=>false})

rake aborted!
StandardError: An error has occurred, this and all later migrations canceled:

PG::UndefinedTable: ERROR:  relation "delayed_jobs" does not exist
: ALTER TABLE "delayed_jobs" ADD COLUMN "max_concurrent" integer DEFAULT 1 NOT NULL/var/canvas/vendor/bundle/ruby/2.1.0/gems/rack-mini-profiler-0.9.2/lib/patches/sql_patches.rb:160:in `exec'

Cody Cutrer

unread,
Jun 28, 2016, 3:51:49 AM6/28/16
to canvas-l...@googlegroups.com
And you're sure the file db/migrate/20120101163452_migrate_queue_to_default_shard.rb exists? http://github.com/instructure/canvas-lms/commit/4adf1524b5946adfe8ee15be7a91c6edf0f038fa moved that migration earlier in the process, so that it would run before AddMaxConcurrentToJobs, even though it was written afterwards. 2016-03-12 is the earliest release that move happened on. If you're trying to upgrade to an older release than that, you can manually force it to run first by executing `bundle exec rake db:migrate:up VERSION=20160223163452`, and then doing your regular migration process afterwards.

Cody Cutrer
Software Engineer
Instructure

James Swash

unread,
Jul 4, 2016, 4:09:03 AM7/4/16
to Canvas LMS Users
Hi Cody, the file didn't exist when I pulled from GIT, I found it in a ZIP download of the GIT repository strangely enough. It still wouldn't upgrade the database, and even running the command you suggested said it didn't exist.
Is there any way for us to have someone from Instructure provide us paid support to assist us with upgrading our test installation and then our live installation?

Regards,
James
...

Ralph

unread,
Jun 2, 2017, 4:46:42 PM6/2/17
to Canvas LMS Users
Hi James Swash, 

I'm also having trouble upgrading a 2 year old canvas installation. How did you resolve this, assuming you did?

bkc1...@gmail.com

unread,
Jun 2, 2017, 4:58:13 PM6/2/17
to canvas-l...@googlegroups.com
Hi Ralph,

Unfortunately we haven't resolved it yet. We did manage to create a brand new installation and restore a course backup into that. But it's not ideal.
You received this message because you are subscribed to a topic in the Google Groups "Canvas LMS Users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/canvas-lms-users/UN1OcqQJExA/unsubscribe.
To unsubscribe from this group and all its topics, send an email to canvas-lms-use...@googlegroups.com.

Ralph

unread,
Jun 2, 2017, 6:42:06 PM6/2/17
to Canvas LMS Users
Thanks for responding. That might be my last resort. Why isn't it ideal if you don't mind?
I've managed to successfully run the migrations but the page is missing all images and stylesheets. I'm currently at 2016-04-23 and will move to the latest if I'm able to resolve the layout issue.
Reply all
Reply to author
Forward
0 new messages