Dear Walter, Have you tried
rake ts:configure rake ts:rebuild ? That works for me. Importantly, I needed MySQL 5.7 installed with Homebrew to get this to work. Then I needed to gem install mysql2 with a lot of flags and paths. I can send you the code for this if you need it. It is a long piece of code. Also I added an export PATH command to .bash_profile which allows me to run mysql -u root. I am no expert at programming and I was fortunate to get help with this myself. Yours, Justin Underwood On Tue, Dec 22, 2020 at 9:20 PM Walter Davis <walterdavisstu...@gmail.com> wrote: > I've been upgrading an app from 5.1 to 5.2 (on its way to 6.1), and moved > from ts 4.2.0 to 5.0.0. I am using MySQL 8.0.21 (home-brew) and Sphinx > 2.2.11 on my development box. > > I've updated my models to use the new syntax for real-time indexing. My > indexes look just like the ones in the quick-start guide. > > I have been trying to reindex an existing database, using > > ``` > tardis:lf-smith waltd$ rake ts:clear > tardis:lf-smith waltd$ rake ts:rebuild > Sphinx 2.2.11-id64-release (95ae9a6) > Copyright (c) 2001-2016, Andrew Aksyonoff > Copyright (c) 2008-2016, Sphinx Technologies Inc (http://sphinxsearch.com) > > > using config file > '/Users/waltd/Documents/sandbox/lf-smith/config/development.sphinx.conf'... > > stop: successfully sent SIGTERM to pid 95642 > > [nothing more happens here, no matter how long I leave it running] > ``` > > If I kill that and try to start TS with rake ts:rt:start, it starts right > up (with empty indexes) and my Rails app seems to work fine until I try to > save a new document. Then I get a huge stack trace with the only readable > bits being `ThinkingSphinx::SphinxError: Unknown MySQL error` and > `Innertube::Pool::BadResource: Innertube::Pool::BadResource`. > > Does this remind you of anything? What else can I show here to help you > help me diagnose this? > > Thanks in advance, > > Walter > > > -- > 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-sphinx+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/thinking-sphinx/2c03894c-323f-46f3-870d-313e217422c9n%40googlegroups.com > <https://groups.google.com/d/msgid/thinking-sphinx/2c03894c-323f-46f3-870d-313e217422c9n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- 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-sphinx+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/thinking-sphinx/CAOWp43g76NFAOte8h1%2BE%2BPU3ThEzne2r48Hho26X4LZVWu4S6g%40mail.gmail.com.
