Issue with migration of Percona DB Cluster
DB Migration produces the follow error:
Caused by: Mysql2::Error: Percona-XtraDB-Cluster prohibits use of GET_LOCK with pxc_strict_mode = ENFORCING /usr/local/bundle/gems/mysql2-0.4.9/lib/mysql2/client.rb:120:in
_query' /usr/local/bundle/gems/mysql2-0.4.9/lib/mysql2/client.rb:120:inblock in query' /usr/local/bundle/gems/mysql2-0.4.9/lib/mysql2/client.rb:119:inhandle_interrupt' /usr/local/bundle/gems/mysql2-0.4.9/lib/mysql2/client.rb:119:inquery' /usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:214:inblock (2 levels) in execute' /usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/dependencies/interlock.rb:46:inblock in permit_concurrent_loads' /usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/concurrency/share_lock.rb:185:inyield_shares' /usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/dependencies/interlock.rb:45:inpermit_concurrent_loads' /usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:213:inblock in execute' /usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/abstract_adapter.rb:613:inblock (2 levels) in log' /usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/abstract_adapter.rb:612:inblock in log' /usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/notifications/instrumenter.rb:21:ininstrument' /usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/abstract_adapter.rb:604:inlog' /usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:212:inexecute' /usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/mysql/database_statements.rb:26:inexecute' /usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/mysql/database_statements.rb:17:inquery' /usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/abstract/database_statements.rb:70:inquery_value' /usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:143:inget_advisory_lock' /usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/migration.rb:1314:inwith_advisory_lock' /usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/migration.rb:1148:inmigrate' /usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/migration.rb:1007:inup' /usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/migration.rb:985:inmigrate' /usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/tasks/database_tasks.rb:171:inmigrate' /usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/railties/databases.rake:58:inblock (2 levels) in <top (required)>' /opt/rails_app/lib/tasks/ecmc.rake:227:inblock (2 levels) in <top (required)>' /usr/local/bundle/gems/rake-12.3.0/exe/rake:27:in<top (required)>' /usr/local/bin/bundle:23:inload' /usr/local/bin/bundle:23:in' Tasks: TOP => db:migrate (See full trace by running task with --trace)