[MDEV-27019] SphinxSE Errors Since 10.6 Install Created: 2021-11-10  Updated: 2022-01-05  Resolved: 2022-01-05

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - SphinxSE
Affects Version/s: 10.6
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Dave Minogue Assignee: Unassigned
Resolution: Cannot Reproduce Votes: 0
Labels: None
Environment:

Ubuntu Focal


 Description   

https://githubmemory.com/repo/manticoresoftware/manticoresearch/issues/603

Certain queries end up giving weird sometimes mispelt errors.

Doesn't happen on 10.5 and before.

Data source error: searchd error: index realtime_media_123: syntax error, unexpecte
Data source error: search query already specified; ' ' is redundant
Data source error: search query already specified; 'H' is redundant
Data source error: search query already specified; '\001F' is redundant



 Comments   
Comment by Sergei Golubchik [ 2021-11-11 ]

I presume you installed mariadb deb packages? Can you install mariadb-test and and mariadb-test-data and do

$ cd /usr/share/mysql/mysql-test/
 
$ ./mtr --vardir=/tmp/mtr-var sphinx.sphinx

you can use any other value for --vardir that's writable for you. By default it's the current directory, so likely, not writable.

This test passed for me, on 10.6 and sphinx-2.2.11.

What do I need to do to repeat the error?

Comment by Dave Minogue [ 2021-11-11 ]

I think the problem might be the switch from utf8mb4 to utf8mb3.
doing some tests...

Comment by Dave Minogue [ 2021-11-12 ]

so far so good.
old_mode with the sphinx table charset to utf8 seems to have eliminated all the issues.

Dave

Generated at Thu Feb 08 09:49:43 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.