Thanks! I de-installed sphinx and installed manticoresearch, and it works great here on my local dev Mac.
Walter On Tuesday, December 22, 2020 at 4:40:50 PM UTC-5 [email protected] wrote: > 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/140f0a24-756d-4ad2-97fc-f6beb9b99954n%40googlegroups.com.
