Thanks. Installing Manticore (with Homebrew) in place of Sphinx on my Mac made this all work, without needing to downgrade MySQL or jump through any hoops.
Walter > On Dec 23, 2020, at 4:44 AM, 'Justin Underwood' via Thinking Sphinx > <[email protected]> wrote: > > > 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 <[email protected]> >> 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 [email protected]. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/thinking-sphinx/2c03894c-323f-46f3-870d-313e217422c9n%40googlegroups.com. > > -- > 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 [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/thinking-sphinx/CAOWp43g76NFAOte8h1%2BE%2BPU3ThEzne2r48Hho26X4LZVWu4S6g%40mail.gmail.com. -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/thinking-sphinx/8C531A5E-5CDB-4F21-9A5C-D8417D022C25%40wdstudio.com.
