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 jer...@shopittome.com 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 <walterda...@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-sphi...@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/140f0a24-756d-4ad2-97fc-f6beb9b99954n%40googlegroups.com.
