Skip to content

Instantly share code, notes, and snippets.

@pelargir
Created July 7, 2014 10:54
Show Gist options
  • Save pelargir/a635e419aa17a7ec646d to your computer and use it in GitHub Desktop.
Save pelargir/a635e419aa17a7ec646d to your computer and use it in GitHub Desktop.
migration error
== 20140614222207 MoveBlobsToS3: migrating ====================================
0 Printed Cases
PrintedCase#p: 100% |oooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooo| Time: 0:00:00
0 Documents
Document#cont: 100% |oooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooo| Time: 0:00:00
0 Batch Events
BatchEvent#ex: 100% |oooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooo| Time: 0:00:00
-- execute("alter table printed_cases drop pdf, lock=none, algorithm=inplace")
rake aborted!
An error has occurred, all later migrations canceled:
Mysql2::Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'lock=none, algorithm=inplace' at line 1: alter table printed_cases drop pdf, lock=none, algorithm=inplace/Users/pelargir/.rvm/gems/ruby-2.1.1@medaxion/gems/activerecord-4.0.5/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:287:in `query'
/Users/pelargir/.rvm/gems/ruby-2.1.1@medaxion/gems/activerecord-4.0.5/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:287:in `block in execute'
/Users/pelargir/.rvm/gems/ruby-2.1.1@medaxion/gems/activerecord-4.0.5/lib/active_record/connection_adapters/abstract_adapter.rb:442:in `block in log'
/Users/pelargir/.rvm/gems/ruby-2.1.1@medaxion/gems/activesupport-4.0.5/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
/Users/pelargir/.rvm/gems/ruby-2.1.1@medaxion/gems/activerecord-4.0.5/lib/active_record/connection_adapters/abstract_adapter.rb:437:in `log'
/Users/pelargir/.rvm/gems/ruby-2.1.1@medaxion/gems/activerecord-4.0.5/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:287:in `execute'
/Users/pelargir/.rvm/gems/ruby-2.1.1@medaxion/gems/activerecord-4.0.5/lib/active_record/connection_adapters/mysql2_adapter.rb:222:in `execute'
/Users/pelargir/.rvm/gems/ruby-2.1.1@medaxion/gems/activerecord-4.0.5/lib/active_record/migration.rb:629:in `block in method_missing'
/Users/pelargir/.rvm/gems/ruby-2.1.1@medaxion/gems/activerecord-4.0.5/lib/active_record/migration.rb:601:in `block in say_with_time'
/Users/pelargir/.rvm/gems/ruby-2.1.1@medaxion/gems/activerecord-4.0.5/lib/active_record/migration.rb:601:in `say_with_time'
/Users/pelargir/.rvm/gems/ruby-2.1.1@medaxion/gems/activerecord-4.0.5/lib/active_record/migration.rb:621:in `method_missing'
/Users/pelargir/Projects/medaxion/medaxion_site/db/migrate/20140614222207_move_blobs_to_s3.rb:4:in `up'
/Users/pelargir/.rvm/gems/ruby-2.1.1@medaxion/gems/activerecord-4.0.5/lib/active_record/migration.rb:578:in `exec_migration'
/Users/pelargir/.rvm/gems/ruby-2.1.1@medaxion/gems/activerecord-4.0.5/lib/active_record/migration.rb:559:in `block (2 levels) in migrate'
/Users/pelargir/.rvm/gems/ruby-2.1.1@medaxion/gems/activerecord-4.0.5/lib/active_record/migration.rb:558:in `block in migrate'
/Users/pelargir/.rvm/gems/ruby-2.1.1@medaxion/gems/activerecord-4.0.5/lib/active_record/connection_adapters/abstract/connection_pool.rb:294:in `with_connection'
/Users/pelargir/.rvm/gems/ruby-2.1.1@medaxion/gems/activerecord-4.0.5/lib/active_record/migration.rb:557:in `migrate'
/Users/pelargir/.rvm/gems/ruby-2.1.1@medaxion/gems/activerecord-4.0.5/lib/active_record/migration.rb:713:in `migrate'
/Users/pelargir/.rvm/gems/ruby-2.1.1@medaxion/gems/activerecord-4.0.5/lib/active_record/migration.rb:963:in `block in execute_migration_in_transaction'
/Users/pelargir/.rvm/gems/ruby-2.1.1@medaxion/gems/activerecord-4.0.5/lib/active_record/migration.rb:1011:in `ddl_transaction'
/Users/pelargir/.rvm/gems/ruby-2.1.1@medaxion/gems/activerecord-4.0.5/lib/active_record/migration.rb:962:in `execute_migration_in_transaction'
/Users/pelargir/.rvm/gems/ruby-2.1.1@medaxion/gems/activerecord-4.0.5/lib/active_record/migration.rb:924:in `block in migrate'
/Users/pelargir/.rvm/gems/ruby-2.1.1@medaxion/gems/activerecord-4.0.5/lib/active_record/migration.rb:920:in `each'
/Users/pelargir/.rvm/gems/ruby-2.1.1@medaxion/gems/activerecord-4.0.5/lib/active_record/migration.rb:920:in `migrate'
/Users/pelargir/.rvm/gems/ruby-2.1.1@medaxion/gems/activerecord-4.0.5/lib/active_record/migration.rb:768:in `up'
/Users/pelargir/.rvm/gems/ruby-2.1.1@medaxion/gems/activerecord-4.0.5/lib/active_record/migration.rb:746:in `migrate'
/Users/pelargir/.rvm/gems/ruby-2.1.1@medaxion/gems/activerecord-4.0.5/lib/active_record/railties/databases.rake:42:in `block (2 levels) in <top (required)>'
/Users/pelargir/.rvm/gems/ruby-2.1.1@medaxion/bin/ruby_executable_hooks:15:in `eval'
/Users/pelargir/.rvm/gems/ruby-2.1.1@medaxion/bin/ruby_executable_hooks:15: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