Skip to content

Instantly share code, notes, and snippets.

@grahamb
Created August 21, 2014 22:08
Show Gist options
  • Select an option

  • Save grahamb/25c50c7b08b9c2142a71 to your computer and use it in GitHub Desktop.

Select an option

Save grahamb/25c50c7b08b9c2142a71 to your computer and use it in GitHub Desktop.
[canvasuser@icat-graham-canvas 20140821210546]$ RAILS_ENV=production bundle exec rake db:migrate
default: production
== AddUniqueIndexOnNotifications: migrating ==================================
-- add_index(:notifications, [:name], {:unique=>true, :name=>"index_notifications_unique_on_name"})
-> 0.0250s
== AddUniqueIndexOnNotifications: migrated (0.1386s) =========================
== CreateSwitchmanShards: migrating ==========================================
-- table_exists?("switchman_shards")
-> 0.0006s
-- create_table(:switchman_shards)
NOTICE: CREATE TABLE will create implicit sequence "switchman_shards_id_seq" for serial column "switchman_shards.id"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "switchman_shards_pkey" for table "switchman_shards"
-> 0.4796s
-- column_exists?(:switchman_shards, :settings)
-> 0.0011s
-- add_column(:switchman_shards, :settings, :text)
-> 0.0005s
== CreateSwitchmanShards: migrated (0.4821s) =================================
== CreateDefaultShard: migrating =============================================
== CreateDefaultShard: migrated (0.1555s) ====================================
== AddContextToContentExports: migrating =====================================
-- add_column(:content_exports, :context_type, :string)
-> 0.0662s
-- add_column(:content_exports, :context_id, :integer, {:limit=>8})
-> 0.0233s
-- remove_foreign_key(:content_exports, :courses)
-> 0.0549s
-- create_trigger("content_export_after_insert_row_when_context_id_is_null__tr", {:generated=>true})
-> 0.0003s
NOTICE: trigger "content_export_after_insert_row_when_context_id_is_null__tr" for table "content_exports" does not exist, skipping
NOTICE: function content_export_after_insert_row_when_context_id_is_null__tr() does not exist, skipping
-- execute("ALTER TABLE content_exports ALTER context_type SET DEFAULT 'Course'")
-> 0.0003s
== AddContextToContentExports: migrated (0.6373s) ============================
== RemoveCourseIdFromContentExports: migrating ===============================
-- drop_trigger("content_export_after_insert_row_when_context_id_is_null__tr", "content_exports", {:generated=>true})
-> 0.0009s
-- execute("ALTER TABLE content_exports ALTER context_type DROP DEFAULT")
-> 0.0003s
-- remove_column(:content_exports, :course_id)
-> 0.0350s
== RemoveCourseIdFromContentExports: migrated (0.0364s) ======================
== AddOnlyVisibleToOverridesToQuizzes: migrating =============================
-- add_column(:quizzes, :only_visible_to_overrides, :boolean)
-> 0.0016s
== AddOnlyVisibleToOverridesToQuizzes: migrated (0.0017s) ====================
== AddLti2Tables: migrating ==================================================
-- create_table(:lti_product_families)
NOTICE: CREATE TABLE will create implicit sequence "lti_product_families_id_seq" for serial column "lti_product_families.id"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "lti_product_families_pkey" for table "lti_product_families"
-> 0.0379s
-- create_table(:lti_message_handlers)
NOTICE: CREATE TABLE will create implicit sequence "lti_message_handlers_id_seq" for serial column "lti_message_handlers.id"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "lti_message_handlers_pkey" for table "lti_message_handlers"
-> 0.0052s
-- create_table(:lti_resource_handlers)
NOTICE: CREATE TABLE will create implicit sequence "lti_resource_handlers_id_seq" for serial column "lti_resource_handlers.id"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "lti_resource_handlers_pkey" for table "lti_resource_handlers"
-> 0.0309s
-- create_table(:lti_resource_placements)
NOTICE: CREATE TABLE will create implicit sequence "lti_resource_placements_id_seq" for serial column "lti_resource_placements.id"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "lti_resource_placements_pkey" for table "lti_resource_placements"
-> 0.0026s
-- create_table(:lti_tool_proxies)
NOTICE: CREATE TABLE will create implicit sequence "lti_tool_proxies_id_seq" for serial column "lti_tool_proxies.id"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "lti_tool_proxies_pkey" for table "lti_tool_proxies"
-> 0.0043s
-- create_table(:lti_tool_proxy_bindings)
NOTICE: CREATE TABLE will create implicit sequence "lti_tool_proxy_bindings_id_seq" for serial column "lti_tool_proxy_bindings.id"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "lti_tool_proxy_bindings_pkey" for table "lti_tool_proxy_bindings"
-> 0.0028s
-- add_index(:lti_product_families, [:root_account_id, :vendor_code, :product_code], {:name=>"index_lti_product_families_on_root_account_vend_code_prod_code", :unique=>true})
-> 0.0024s
-- add_index(:lti_message_handlers, [:resource_handler_id, :message_type], {:name=>"index_lti_message_handlers_on_resource_handler_and_type", :unique=>true})
-> 0.0021s
-- add_index(:lti_resource_handlers, [:tool_proxy_id, :resource_type_code], {:name=>"index_lti_resource_handlers_on_tool_proxy_and_type_code", :unique=>true})
-> 0.0021s
-- add_index(:lti_resource_placements, [:placement, :resource_handler_id], {:name=>"index_lti_resource_placements_on_placement_and_handler", :unique=>true})
-> 0.0024s
-- add_index(:lti_tool_proxies, [:root_account_id, :product_family_id, :product_version], {:name=>"index_lti_tool_proxies_on_root_account_prod_fam_and_prod_ver", :unique=>true})
-> 0.0019s
-- add_index(:lti_tool_proxy_bindings, [:context_id, :context_type, :tool_proxy_id], {:name=>"index_lti_tool_proxy_bindings_on_context_and_tool_proxy", :unique=>true})
-> 0.0070s
-- add_index(:lti_tool_proxies, [:guid])
-> 0.0029s
-- add_foreign_key(:lti_product_families, :accounts, {:column=>:root_account_id})
-> 0.0644s
-- add_foreign_key(:lti_message_handlers, :lti_resource_handlers, {:column=>:resource_handler_id})
-> 0.0012s
-- add_foreign_key(:lti_resource_handlers, :lti_tool_proxies, {:column=>:tool_proxy_id})
-> 0.0008s
-- add_foreign_key(:lti_resource_placements, :lti_resource_handlers, {:column=>:resource_handler_id})
-> 0.0007s
-- add_foreign_key(:lti_tool_proxies, :lti_product_families, {:column=>:product_family_id})
-> 0.0007s
-- add_foreign_key(:lti_tool_proxies, :accounts, {:column=>:root_account_id})
-> 0.0009s
-- add_foreign_key(:lti_tool_proxy_bindings, :lti_tool_proxies, {:column=>:tool_proxy_id})
-> 0.0012s
== AddLti2Tables: migrated (0.1757s) =========================================
== AddAssignmentStudentVisibilityView: migrating =============================
== AddAssignmentStudentVisibilityView: migrated (0.1122s) ====================
== DropBeforeQuizSubmissionTypesColumn: migrating ============================
-- remove_column(:assignments, :before_quiz_submission_types)
-> 0.0177s
== DropBeforeQuizSubmissionTypesColumn: migrated (0.0178s) ===================
== AddForeignKeyIndexes3: migrating ==========================================
-- add_index(:account_reports, :attachment_id, {:algorithm=>:concurrently})
-> 0.0176s
-- add_index(:zip_file_imports, :attachment_id, {:algorithm=>:concurrently})
-> 0.0275s
== AddForeignKeyIndexes3: migrated (0.0453s) =================================
== AddOneTimeResultsToQuizzes: migrating =====================================
-- add_column(:quizzes, :one_time_results, :boolean)
-> 0.0007s
-- add_column(:quiz_submissions, :has_seen_results, :boolean)
-> 0.0010s
== AddOneTimeResultsToQuizzes: migrated (0.0018s) ============================
== PeerReviewInvitationNeedsNotification: migrating ==========================
== PeerReviewInvitationNeedsNotification: migrated (0.1150s) =================
== AddForeignKeyIndexes4: migrating ==========================================
-- add_index(:account_reports, :attachment_id, {:algorithm=>:concurrently})
-> 0.0012s
-- add_index(:attachments, :replacement_attachment_id, {:algorithm=>:concurrently, :where=>"replacement_attachment_id IS NOT NULL"})
-> 4.6313s
-- add_index(:discussion_topics, :old_assignment_id, {:algorithm=>:concurrently, :where=>"old_assignment_id IS NOT NULL"})
-> 1.2643s
-- add_index(:enrollment_terms, :sis_batch_id, {:algorithm=>:concurrently, :where=>"sis_batch_id IS NOT NULL"})
-> 0.0190s
-- add_index(:zip_file_imports, :attachment_id, {:algorithm=>:concurrently})
-> 0.0010s
-- add_index(:zip_file_imports, :folder_id, {:algorithm=>:concurrently})
-> 0.0055s
== AddForeignKeyIndexes4: migrated (5.9228s) =================================
[canvasuser@icat-graham-canvas 20140821210546]$ RAILS_ENV=production bundle exec rake db:migrate
rake aborted!
Gem::LoadError: sqlite3 is not part of the bundle. Add it to Gemfile.
/var/rails/canvas/releases/20140821210546/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.19/lib/active_record/connection_adapters/sqlite3_adapter.rb:3:in `<top (required)>'
/var/rails/canvas/releases/20140821210546/vendor/bundle/ruby/1.9.1/gems/polyglot-0.3.5/lib/polyglot.rb:65:in `require'
/var/rails/canvas/releases/20140821210546/vendor/bundle/ruby/1.9.1/gems/polyglot-0.3.5/lib/polyglot.rb:65:in `require'
/var/rails/canvas/releases/20140821210546/vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.19/lib/active_support/dependencies.rb:251:in `block in require'
/var/rails/canvas/releases/20140821210546/vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.19/lib/active_support/dependencies.rb:236:in `load_dependency'
/var/rails/canvas/releases/20140821210546/vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.19/lib/active_support/dependencies.rb:251:in `require'
/var/rails/canvas/releases/20140821210546/vendor/bundle/ruby/1.9.1/gems/switchman-1.2.12/lib/switchman/connection_pool_proxy.rb:107:in `create_pool'
/var/rails/canvas/releases/20140821210546/vendor/bundle/ruby/1.9.1/gems/switchman-1.2.12/lib/switchman/connection_pool_proxy.rb:36:in `current_pool'
/var/rails/canvas/releases/20140821210546/vendor/bundle/ruby/1.9.1/gems/switchman-1.2.12/lib/switchman/active_record/connection_handler.rb:112:in `block (2 levels) in establish_connection_with_sharding'
/var/rails/canvas/releases/20140821210546/vendor/bundle/ruby/1.9.1/gems/switchman-1.2.12/app/models/switchman/shard.rb:55:in `activate'
/var/rails/canvas/releases/20140821210546/vendor/bundle/ruby/1.9.1/gems/switchman-1.2.12/app/models/switchman/shard.rb:456:in `activate'
/var/rails/canvas/releases/20140821210546/vendor/bundle/ruby/1.9.1/gems/switchman-1.2.12/lib/switchman/active_record/connection_handler.rb:110:in `block in establish_connection_with_sharding'
/var/rails/canvas/releases/20140821210546/vendor/bundle/ruby/1.9.1/gems/switchman-1.2.12/lib/switchman/active_record/connection_handler.rb:106:in `each'
/var/rails/canvas/releases/20140821210546/vendor/bundle/ruby/1.9.1/gems/switchman-1.2.12/lib/switchman/active_record/connection_handler.rb:106:in `establish_connection_with_sharding'
/var/rails/canvas/releases/20140821210546/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.19/lib/active_record/connection_adapters/abstract/connection_specification.rb:137:in `establish_connection'
/var/rails/canvas/releases/20140821210546/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.19/lib/active_record/railtie.rb:88:in `block (2 levels) in <class:Railtie>'
/var/rails/canvas/releases/20140821210546/vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.19/lib/active_support/lazy_load_hooks.rb:36:in `instance_eval'
/var/rails/canvas/releases/20140821210546/vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.19/lib/active_support/lazy_load_hooks.rb:36:in `execute_hook'
/var/rails/canvas/releases/20140821210546/vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.19/lib/active_support/lazy_load_hooks.rb:26:in `block in on_load'
/var/rails/canvas/releases/20140821210546/vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.19/lib/active_support/lazy_load_hooks.rb:25:in `each'
/var/rails/canvas/releases/20140821210546/vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.19/lib/active_support/lazy_load_hooks.rb:25:in `on_load'
/var/rails/canvas/releases/20140821210546/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.19/lib/active_record/railtie.rb:80:in `block in <class:Railtie>'
/var/rails/canvas/releases/20140821210546/vendor/bundle/ruby/1.9.1/gems/railties-3.2.19/lib/rails/initializable.rb:30:in `instance_exec'
/var/rails/canvas/releases/20140821210546/vendor/bundle/ruby/1.9.1/gems/railties-3.2.19/lib/rails/initializable.rb:30:in `run'
/var/rails/canvas/releases/20140821210546/vendor/bundle/ruby/1.9.1/gems/railties-3.2.19/lib/rails/initializable.rb:55:in `block in run_initializers'
/var/rails/canvas/releases/20140821210546/vendor/bundle/ruby/1.9.1/gems/railties-3.2.19/lib/rails/initializable.rb:54:in `each'
/var/rails/canvas/releases/20140821210546/vendor/bundle/ruby/1.9.1/gems/railties-3.2.19/lib/rails/initializable.rb:54:in `run_initializers'
/var/rails/canvas/releases/20140821210546/vendor/bundle/ruby/1.9.1/gems/railties-3.2.19/lib/rails/application.rb:136:in `initialize!'
/var/rails/canvas/releases/20140821210546/vendor/bundle/ruby/1.9.1/gems/railties-3.2.19/lib/rails/railtie/configurable.rb:30:in `method_missing'
/var/rails/canvas/releases/20140821210546/config/environment.rb:58:in `<top (required)>'
/var/rails/canvas/releases/20140821210546/vendor/bundle/ruby/1.9.1/gems/polyglot-0.3.5/lib/polyglot.rb:65:in `require'
/var/rails/canvas/releases/20140821210546/vendor/bundle/ruby/1.9.1/gems/polyglot-0.3.5/lib/polyglot.rb:65:in `require'
/var/rails/canvas/releases/20140821210546/vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.19/lib/active_support/dependencies.rb:251:in `block in require'
/var/rails/canvas/releases/20140821210546/vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.19/lib/active_support/dependencies.rb:236:in `load_dependency'
/var/rails/canvas/releases/20140821210546/vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.19/lib/active_support/dependencies.rb:251:in `require'
/var/rails/canvas/releases/20140821210546/vendor/bundle/ruby/1.9.1/gems/railties-3.2.19/lib/rails/application.rb:103:in `require_environment!'
/var/rails/canvas/releases/20140821210546/vendor/bundle/ruby/1.9.1/gems/railties-3.2.19/lib/rails/application.rb:305:in `block (2 levels) in initialize_tasks'
Tasks: TOP => db:migrate => environment
(See full trace by running task with --trace)
[canvasuser@icat-graham-canvas 20140821210546]$
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment