Hi Walter, I believe MySQL 8 is the issue. Downgrading to 5.7 should fix this? For what it's worth I always use Percona's builds and tools which are fabulous. https://www.percona.com/
Long thread here I found: https://github.com/pat/thinking-sphinx/issues/1101 Jeremy On Tue, Dec 22, 2020 at 1: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 > <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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/thinking-sphinx/CACdDm_fTn8AtXtPv2OCsJ5X4Ews%2BuhNtQmAhSQrNfQVESOq5ew%40mail.gmail.com.
