syntax error, unexpected $end, expecting FTS_TEXT or FTS_TERM or FTS_NUMB or '('

Question

I have many messages like the following in /var/log/mysqld.log What does it mean?

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%$
    syntax error, unexpected $end, expecting FTS_TEXT or FTS_TERM or FTS_NUMB or '('
    syntax error, unexpected $end, expecting FTS_TEXT or FTS_TERM or FTS_NUMB or '('
    syntax error, unexpected $end, expecting FTS_TEXT or FTS_TERM or FTS_NUMB or '('
    syntax error, unexpected $end, expecting FTS_TEXT or FTS_TERM or FTS_NUMB or '('
    %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%$

centos 6.4 Server version: 5.6.12-56 Percona Server (GPL), Release rc60.4, Revision 393

score 1 · Answer 1 · answered Aug 25 '13 at 18:19

1

You probably have a syntax error in a query involving Full-Text Search.

answered Aug 25 '13 at 18:19

200_success

4,771
1
25
42

score 0 · Answer 2 · answered Jul 03 '17 at 09:38

0

If you're using innoDB, your FT query to match/against probably includes this special character: *. See this bug report: https://bugs.mysql.com/bug.php?id=78485

answered Jul 03 '17 at 09:38

SuN

101
1

syntax error, unexpected $end, expecting FTS_TEXT or FTS_TERM or FTS_NUMB or '('

2 Answers2