ThinkingSphinx::SphinxError: Unknown MySQL error

82 views
Skip to first unread message

simhm...@gmail.com

unread,
Jan 3, 2019, 11:19:30 AM1/3/19
to Thinking Sphinx
Hi Pat

Happy New Year. Am a little stuck with re-installing sphinx - if you had a moment to help, that would be much appreciated.

We've been using thinking sphinx with rails. I've just re-installed mysql and sphinx using brew, but am getting this error when seeding the database. We've tried manually installing mysql and sphinx but not having much luck. Do you have an idea of what it might be?

Thank you
Simone

-- create_table("versions", {:force=>:cascade})
   -> 0.0127s
-- add_foreign_key("activities", "snapshots")
   -> 0.0021s
rake aborted!
ThinkingSphinx::SphinxError: Unknown MySQL error
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/mysql2-0.5.2/lib/mysql2/client.rb:90:in `connect'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/mysql2-0.5.2/lib/mysql2/client.rb:90:in `initialize'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/connection/mri.rb:13:in `new'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/connection/mri.rb:13:in `client'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/connection/client.rb:28:in `close!'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/connection.rb:28:in `block in pool'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/innertube-1.1.0/lib/innertube.rb:88:in `delete_element'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/innertube-1.1.0/lib/innertube.rb:140:in `rescue in take'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/innertube-1.1.0/lib/innertube.rb:148:in `take'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/connection.rb:36:in `take'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/real_time/transcriber.rb:29:in `block in copy'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/notifications.rb:168:in `block in instrument'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/notifications/instrumenter.rb:23:in `instrument'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/notifications.rb:168:in `instrument'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/logger.rb:5:in `log'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/real_time/transcriber.rb:28:in `copy'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/real_time/callbacks/real_time_callbacks.rb:48:in `block (2 levels) in persist_changes'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/real_time/callbacks/real_time_callbacks.rb:47:in `each'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/real_time/callbacks/real_time_callbacks.rb:47:in `block in persist_changes'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/real_time/callbacks/real_time_callbacks.rb:46:in `each'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/real_time/callbacks/real_time_callbacks.rb:46:in `persist_changes'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/real_time/callbacks/real_time_callbacks.rb:13:in `after_save'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/callbacks.rb:426:in `block in make_lambda'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/callbacks.rb:236:in `block in halting_and_conditional'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/callbacks.rb:517:in `block in invoke_after'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/callbacks.rb:517:in `each'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/callbacks.rb:517:in `invoke_after'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/callbacks.rb:133:in `run_callbacks'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/callbacks.rb:816:in `_run_save_callbacks'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/callbacks.rb:342:in `create_or_update'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/persistence.rb:308:in `save!'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/validations.rb:52:in `save!'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/transactions.rb:315:in `block in save!'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/transactions.rb:387:in `block in with_transaction_returning_status'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/connection_adapters/abstract/database_statements.rb:254:in `block in transaction'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/connection_adapters/abstract/transaction.rb:239:in `block in within_new_transaction'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/connection_adapters/abstract/transaction.rb:236:in `within_new_transaction'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/connection_adapters/abstract/database_statements.rb:254:in `transaction'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/transactions.rb:212:in `transaction'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/transactions.rb:385:in `with_transaction_returning_status'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/transactions.rb:315:in `save!'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/suppressor.rb:48:in `save!'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/persistence.rb:53:in `create!'
/Users/simone/projects/handshq/db/seeds.rb:11:in `<main>'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/bootsnap-1.3.2/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:50:in `load'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/bootsnap-1.3.2/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:50:in `load'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/dependencies.rb:281:in `block in load'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/dependencies.rb:253:in `load_dependency'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/dependencies.rb:281:in `load'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/railties-5.2.1/lib/rails/engine.rb:551:in `load_seed'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/tasks/database_tasks.rb:281:in `load_seed'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/railties/databases.rake:194:in `block (2 levels) in <main>'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/rake-12.3.1/exe/rake:27:in `<top (required)>'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/bin/ruby_executable_hooks:24:in `eval'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/bin/ruby_executable_hooks:24:in `<main>'

Caused by:
Mysql2::Error: Unknown MySQL error
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/mysql2-0.5.2/lib/mysql2/client.rb:90:in `connect'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/mysql2-0.5.2/lib/mysql2/client.rb:90:in `initialize'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/connection/mri.rb:13:in `new'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/connection/mri.rb:13:in `client'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/connection/client.rb:28:in `close!'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/connection.rb:28:in `block in pool'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/innertube-1.1.0/lib/innertube.rb:88:in `delete_element'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/innertube-1.1.0/lib/innertube.rb:140:in `rescue in take'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/innertube-1.1.0/lib/innertube.rb:148:in `take'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/connection.rb:36:in `take'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/real_time/transcriber.rb:29:in `block in copy'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/notifications.rb:168:in `block in instrument'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/notifications/instrumenter.rb:23:in `instrument'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/notifications.rb:168:in `instrument'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/logger.rb:5:in `log'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/real_time/transcriber.rb:28:in `copy'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/real_time/callbacks/real_time_callbacks.rb:48:in `block (2 levels) in persist_changes'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/real_time/callbacks/real_time_callbacks.rb:47:in `each'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/real_time/callbacks/real_time_callbacks.rb:47:in `block in persist_changes'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/real_time/callbacks/real_time_callbacks.rb:46:in `each'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/real_time/callbacks/real_time_callbacks.rb:46:in `persist_changes'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/real_time/callbacks/real_time_callbacks.rb:13:in `after_save'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/callbacks.rb:426:in `block in make_lambda'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/callbacks.rb:236:in `block in halting_and_conditional'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/callbacks.rb:517:in `block in invoke_after'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/callbacks.rb:517:in `each'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/callbacks.rb:517:in `invoke_after'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/callbacks.rb:133:in `run_callbacks'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/callbacks.rb:816:in `_run_save_callbacks'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/callbacks.rb:342:in `create_or_update'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/persistence.rb:308:in `save!'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/validations.rb:52:in `save!'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/transactions.rb:315:in `block in save!'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/transactions.rb:387:in `block in with_transaction_returning_status'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/connection_adapters/abstract/database_statements.rb:254:in `block in transaction'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/connection_adapters/abstract/transaction.rb:239:in `block in within_new_transaction'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/connection_adapters/abstract/transaction.rb:236:in `within_new_transaction'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/connection_adapters/abstract/database_statements.rb:254:in `transaction'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/transactions.rb:212:in `transaction'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/transactions.rb:385:in `with_transaction_returning_status'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/transactions.rb:315:in `save!'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/suppressor.rb:48:in `save!'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/persistence.rb:53:in `create!'
/Users/simone/projects/handshq/db/seeds.rb:11:in `<main>'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/bootsnap-1.3.2/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:50:in `load'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/bootsnap-1.3.2/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:50:in `load'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/dependencies.rb:281:in `block in load'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/dependencies.rb:253:in `load_dependency'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/dependencies.rb:281:in `load'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/railties-5.2.1/lib/rails/engine.rb:551:in `load_seed'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/tasks/database_tasks.rb:281:in `load_seed'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/railties/databases.rake:194:in `block (2 levels) in <main>'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/rake-12.3.1/exe/rake:27:in `<top (required)>'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/bin/ruby_executable_hooks:24:in `eval'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/bin/ruby_executable_hooks:24:in `<main>'

Caused by:
Innertube::Pool::BadResource: Innertube::Pool::BadResource
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/connection.rb:42:in `rescue in block in take'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/connection.rb:37:in `block in take'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/innertube-1.1.0/lib/innertube.rb:138:in `take'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/connection.rb:36:in `take'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/real_time/transcriber.rb:29:in `block in copy'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/notifications.rb:168:in `block in instrument'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/notifications/instrumenter.rb:23:in `instrument'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/notifications.rb:168:in `instrument'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/logger.rb:5:in `log'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/real_time/transcriber.rb:28:in `copy'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/real_time/callbacks/real_time_callbacks.rb:48:in `block (2 levels) in persist_changes'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/real_time/callbacks/real_time_callbacks.rb:47:in `each'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/real_time/callbacks/real_time_callbacks.rb:47:in `block in persist_changes'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/real_time/callbacks/real_time_callbacks.rb:46:in `each'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/real_time/callbacks/real_time_callbacks.rb:46:in `persist_changes'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/real_time/callbacks/real_time_callbacks.rb:13:in `after_save'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/callbacks.rb:426:in `block in make_lambda'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/callbacks.rb:236:in `block in halting_and_conditional'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/callbacks.rb:517:in `block in invoke_after'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/callbacks.rb:517:in `each'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/callbacks.rb:517:in `invoke_after'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/callbacks.rb:133:in `run_callbacks'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/callbacks.rb:816:in `_run_save_callbacks'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/callbacks.rb:342:in `create_or_update'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/persistence.rb:308:in `save!'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/validations.rb:52:in `save!'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/transactions.rb:315:in `block in save!'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/transactions.rb:387:in `block in with_transaction_returning_status'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/connection_adapters/abstract/database_statements.rb:254:in `block in transaction'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/connection_adapters/abstract/transaction.rb:239:in `block in within_new_transaction'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/connection_adapters/abstract/transaction.rb:236:in `within_new_transaction'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/connection_adapters/abstract/database_statements.rb:254:in `transaction'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/transactions.rb:212:in `transaction'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/transactions.rb:385:in `with_transaction_returning_status'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/transactions.rb:315:in `save!'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/suppressor.rb:48:in `save!'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/persistence.rb:53:in `create!'
/Users/simone/projects/handshq/db/seeds.rb:11:in `<main>'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/bootsnap-1.3.2/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:50:in `load'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/bootsnap-1.3.2/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:50:in `load'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/dependencies.rb:281:in `block in load'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/dependencies.rb:253:in `load_dependency'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/dependencies.rb:281:in `load'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/railties-5.2.1/lib/rails/engine.rb:551:in `load_seed'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/tasks/database_tasks.rb:281:in `load_seed'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/railties/databases.rake:194:in `block (2 levels) in <main>'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/rake-12.3.1/exe/rake:27:in `<top (required)>'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/bin/ruby_executable_hooks:24:in `eval'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/bin/ruby_executable_hooks:24:in `<main>'

Caused by:
ThinkingSphinx::QueryExecutionError: Unknown MySQL error - REPLACE INTO user_core (id, `sphinx_internal_class_name`, `first_name`, `last_name`, `email`, `sphinx_internal_id`, `sphinx_internal_class`, `sphinx_deleted`, `user_id`, `company_id`, `created_at`, `updated_at`) VALUES (11, 'Owner', 'Joe', 'Bloggs', 'ba...@handshq.com', 1, 'Owner', 0, 1, 0, 1546530823, 1546530823)
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/connection/client.rb:65:in `rescue in perform'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/connection/client.rb:68:in `perform'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/connection/client.rb:51:in `check_and_perform'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/connection/client.rb:32:in `execute'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/real_time/transcriber.rb:30:in `block (2 levels) in copy'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/connection.rb:38:in `block in take'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/innertube-1.1.0/lib/innertube.rb:138:in `take'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/connection.rb:36:in `take'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/real_time/transcriber.rb:29:in `block in copy'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/notifications.rb:168:in `block in instrument'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/notifications/instrumenter.rb:23:in `instrument'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/notifications.rb:168:in `instrument'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/logger.rb:5:in `log'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/real_time/transcriber.rb:28:in `copy'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/real_time/callbacks/real_time_callbacks.rb:48:in `block (2 levels) in persist_changes'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/real_time/callbacks/real_time_callbacks.rb:47:in `each'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/real_time/callbacks/real_time_callbacks.rb:47:in `block in persist_changes'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/real_time/callbacks/real_time_callbacks.rb:46:in `each'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/real_time/callbacks/real_time_callbacks.rb:46:in `persist_changes'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/real_time/callbacks/real_time_callbacks.rb:13:in `after_save'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/callbacks.rb:426:in `block in make_lambda'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/callbacks.rb:236:in `block in halting_and_conditional'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/callbacks.rb:517:in `block in invoke_after'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/callbacks.rb:517:in `each'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/callbacks.rb:517:in `invoke_after'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/callbacks.rb:133:in `run_callbacks'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/callbacks.rb:816:in `_run_save_callbacks'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/callbacks.rb:342:in `create_or_update'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/persistence.rb:308:in `save!'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/validations.rb:52:in `save!'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/transactions.rb:315:in `block in save!'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/transactions.rb:387:in `block in with_transaction_returning_status'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/connection_adapters/abstract/database_statements.rb:254:in `block in transaction'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/connection_adapters/abstract/transaction.rb:239:in `block in within_new_transaction'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/connection_adapters/abstract/transaction.rb:236:in `within_new_transaction'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/connection_adapters/abstract/database_statements.rb:254:in `transaction'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/transactions.rb:212:in `transaction'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/transactions.rb:385:in `with_transaction_returning_status'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/transactions.rb:315:in `save!'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/suppressor.rb:48:in `save!'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/persistence.rb:53:in `create!'
/Users/simone/projects/handshq/db/seeds.rb:11:in `<main>'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/bootsnap-1.3.2/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:50:in `load'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/bootsnap-1.3.2/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:50:in `load'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/dependencies.rb:281:in `block in load'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/dependencies.rb:253:in `load_dependency'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/dependencies.rb:281:in `load'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/railties-5.2.1/lib/rails/engine.rb:551:in `load_seed'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/tasks/database_tasks.rb:281:in `load_seed'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/railties/databases.rake:194:in `block (2 levels) in <main>'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/rake-12.3.1/exe/rake:27:in `<top (required)>'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/bin/ruby_executable_hooks:24:in `eval'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/bin/ruby_executable_hooks:24:in `<main>'

Caused by:
ThinkingSphinx::SphinxError: Unknown MySQL error
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/mysql2-0.5.2/lib/mysql2/client.rb:90:in `connect'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/mysql2-0.5.2/lib/mysql2/client.rb:90:in `initialize'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/connection/mri.rb:13:in `new'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/connection/mri.rb:13:in `client'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/connection/mri.rb:22:in `results_for'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/connection/client.rb:60:in `perform'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/connection/client.rb:51:in `check_and_perform'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/connection/client.rb:32:in `execute'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/real_time/transcriber.rb:30:in `block (2 levels) in copy'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/connection.rb:38:in `block in take'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/innertube-1.1.0/lib/innertube.rb:138:in `take'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/connection.rb:36:in `take'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/real_time/transcriber.rb:29:in `block in copy'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/notifications.rb:168:in `block in instrument'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/notifications/instrumenter.rb:23:in `instrument'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/notifications.rb:168:in `instrument'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/logger.rb:5:in `log'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/real_time/transcriber.rb:28:in `copy'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/real_time/callbacks/real_time_callbacks.rb:48:in `block (2 levels) in persist_changes'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/real_time/callbacks/real_time_callbacks.rb:47:in `each'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/real_time/callbacks/real_time_callbacks.rb:47:in `block in persist_changes'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/real_time/callbacks/real_time_callbacks.rb:46:in `each'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/real_time/callbacks/real_time_callbacks.rb:46:in `persist_changes'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/real_time/callbacks/real_time_callbacks.rb:13:in `after_save'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/callbacks.rb:426:in `block in make_lambda'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/callbacks.rb:236:in `block in halting_and_conditional'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/callbacks.rb:517:in `block in invoke_after'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/callbacks.rb:517:in `each'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/callbacks.rb:517:in `invoke_after'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/callbacks.rb:133:in `run_callbacks'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/callbacks.rb:816:in `_run_save_callbacks'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/callbacks.rb:342:in `create_or_update'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/persistence.rb:308:in `save!'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/validations.rb:52:in `save!'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/transactions.rb:315:in `block in save!'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/transactions.rb:387:in `block in with_transaction_returning_status'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/connection_adapters/abstract/database_statements.rb:254:in `block in transaction'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/connection_adapters/abstract/transaction.rb:239:in `block in within_new_transaction'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/connection_adapters/abstract/transaction.rb:236:in `within_new_transaction'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/connection_adapters/abstract/database_statements.rb:254:in `transaction'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/transactions.rb:212:in `transaction'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/transactions.rb:385:in `with_transaction_returning_status'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/transactions.rb:315:in `save!'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/suppressor.rb:48:in `save!'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/persistence.rb:53:in `create!'
/Users/simone/projects/handshq/db/seeds.rb:11:in `<main>'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/bootsnap-1.3.2/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:50:in `load'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/bootsnap-1.3.2/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:50:in `load'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/dependencies.rb:281:in `block in load'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/dependencies.rb:253:in `load_dependency'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/dependencies.rb:281:in `load'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/railties-5.2.1/lib/rails/engine.rb:551:in `load_seed'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/tasks/database_tasks.rb:281:in `load_seed'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/railties/databases.rake:194:in `block (2 levels) in <main>'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/rake-12.3.1/exe/rake:27:in `<top (required)>'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/bin/ruby_executable_hooks:24:in `eval'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/bin/ruby_executable_hooks:24:in `<main>'

Caused by:
Mysql2::Error: Unknown MySQL error
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/mysql2-0.5.2/lib/mysql2/client.rb:90:in `connect'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/mysql2-0.5.2/lib/mysql2/client.rb:90:in `initialize'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/connection/mri.rb:13:in `new'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/connection/mri.rb:13:in `client'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/connection/mri.rb:22:in `results_for'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/connection/client.rb:60:in `perform'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/connection/client.rb:51:in `check_and_perform'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/connection/client.rb:32:in `execute'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/real_time/transcriber.rb:30:in `block (2 levels) in copy'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/connection.rb:38:in `block in take'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/innertube-1.1.0/lib/innertube.rb:138:in `take'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/connection.rb:36:in `take'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/real_time/transcriber.rb:29:in `block in copy'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/notifications.rb:168:in `block in instrument'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/notifications/instrumenter.rb:23:in `instrument'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/notifications.rb:168:in `instrument'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/logger.rb:5:in `log'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/real_time/transcriber.rb:28:in `copy'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/real_time/callbacks/real_time_callbacks.rb:48:in `block (2 levels) in persist_changes'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/real_time/callbacks/real_time_callbacks.rb:47:in `each'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/real_time/callbacks/real_time_callbacks.rb:47:in `block in persist_changes'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/real_time/callbacks/real_time_callbacks.rb:46:in `each'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/real_time/callbacks/real_time_callbacks.rb:46:in `persist_changes'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/thinking-sphinx-4.0.0/lib/thinking_sphinx/real_time/callbacks/real_time_callbacks.rb:13:in `after_save'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/callbacks.rb:426:in `block in make_lambda'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/callbacks.rb:236:in `block in halting_and_conditional'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/callbacks.rb:517:in `block in invoke_after'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/callbacks.rb:517:in `each'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/callbacks.rb:517:in `invoke_after'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/callbacks.rb:133:in `run_callbacks'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/callbacks.rb:816:in `_run_save_callbacks'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/callbacks.rb:342:in `create_or_update'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/persistence.rb:308:in `save!'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/validations.rb:52:in `save!'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/transactions.rb:315:in `block in save!'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/transactions.rb:387:in `block in with_transaction_returning_status'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/connection_adapters/abstract/database_statements.rb:254:in `block in transaction'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/connection_adapters/abstract/transaction.rb:239:in `block in within_new_transaction'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/connection_adapters/abstract/transaction.rb:236:in `within_new_transaction'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/connection_adapters/abstract/database_statements.rb:254:in `transaction'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/transactions.rb:212:in `transaction'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/transactions.rb:385:in `with_transaction_returning_status'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/transactions.rb:315:in `save!'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/suppressor.rb:48:in `save!'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/persistence.rb:53:in `create!'
/Users/simone/projects/handshq/db/seeds.rb:11:in `<main>'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/bootsnap-1.3.2/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:50:in `load'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/bootsnap-1.3.2/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:50:in `load'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/dependencies.rb:281:in `block in load'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/dependencies.rb:253:in `load_dependency'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activesupport-5.2.1/lib/active_support/dependencies.rb:281:in `load'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/railties-5.2.1/lib/rails/engine.rb:551:in `load_seed'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/tasks/database_tasks.rb:281:in `load_seed'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/activerecord-5.2.1/lib/active_record/railties/databases.rake:194:in `block (2 levels) in <main>'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/gems/rake-12.3.1/exe/rake:27:in `<top (required)>'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/bin/ruby_executable_hooks:24:in `eval'
/Users/simone/.rvm/gems/ruby-2.3.1@hands/bin/ruby_executable_hooks:24:in `<main>'
Tasks: TOP => db:setup => db:seed

Pat Allan

unread,
Jan 3, 2019, 11:28:02 AM1/3/19
to thinkin...@googlegroups.com
Hi Simone,

I’m pretty sure that the issue is an incompatibility between Sphinx 2.2.x releases (which is what Homebrew still uses) and MySQL 8 (which is also what Homebrew supplies). You’ll either need to downgrade MySQL to 5.7 (and then re-install Sphinx), or upgrade Sphinx to 3.1.1:

In case anyone who comes across this post is interested, here’s the GitHub issue where the problem was identified (at least, from the perspective of Thinking Sphinx):

TS v4 should work fine with Sphinx 3.1.1, though there may be some deprecation messages.

If this doesn’t fix things, do let me know!

Cheers,

— 
Pat

--
You received this message because you are subscribed to the Google Groups "Thinking Sphinx" group.
To unsubscribe from this group and stop receiving emails from it, send an email to thinking-sphi...@googlegroups.com.
To post to this group, send email to thinkin...@googlegroups.com.
Visit this group at https://groups.google.com/group/thinking-sphinx.
For more options, visit https://groups.google.com/d/optout.

Reply all
Reply to author
Forward
0 new messages