Upgrading and re-indexing

[Walter Davis]

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

[Jeremy Meigs]

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

--
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.

[Walter Davis]

Thanks! I de-installed sphinx and installed manticoresearch, and it works great here on my local dev Mac. 

Walter

[Justin Underwood]

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

[Walter Lee Davis]

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 <thinkin...@googlegroups.com> wrote:



To view this discussion on the web visit https://groups.google.com/d/msgid/thinking-sphinx/CAOWp43g76NFAOte8h1%2BE%2BPU3ThEzne2r48Hho26X4LZVWu4S6g%40mail.gmail.com.