Bug #71514 FTS: innodb spams error log with %""""""""%"%"%%"%"%""""%""""%""%%""%

• Submitted: 29 Jan 2014 16:26
• Modified: 29 Jan 2014 16:30
• Reporter: Shane Bester (Platinum Quality Contributor)
• Status: Verified
• Category: MySQL Server: InnoDB storage engine
• Severity: S3 (Non-critical)
• Version: 5.7.4
• OS: Any
• CPU Architecture: Any

[29 Jan 2014 16:26] Shane Bester

Description:
Here is a small excerpt of my error log from recent 5.7.4:

2014-01-29T16:21:05.234405Z 0 [Note] mysqld: ready for connections.
Version: '5.7.4-m14'  socket: ''  port: 3306  MySQL Community Server (GPL)
%%""%%""""""""""%""""""""%"%"%%"%"%""""%""""%""%%""%%"%"%"""%%"%%%"
""%"%"""""%""%%%%""%%%""%%"%"%""%"%""%"%""""%"%"%%"""%%"%%"""%""%%"
""%"%"%%""%""%%""%""%"""%%""""%"%""""%%%"""%%"%%%"%%"%""%"%%"%"%%"%
"""%%%%"%"%"%"""%"""""%%""""""%""%"%""%"%"""%%%%""%""%"""%%"%%"""""
"%%%%"%""""%"""%"""%%"""%%%%"""""""%%"%"%%%%"%%%""""%""%""""%%"""""
""""""%""%%%%%""%""%%""%"%""%"%%%%"""""%%"%"%%""""""%""""%%"%"%"%"%
"""""""%"""%%%"%%"""%""%""""%%""""%""%%""%%%"%"""%""""%%%"""%""%%"%
%%"%""""%""%"""%"%"%%%""""%"""%""%"""%%%""""%%"""""""%"%"%""%""%%""
"%%%""%"%""%%"%%%"""%"""%%%"%""%""%%"%"%%"""""%""""%""""""%"""%""""
"""%""%""%""""%%"%%""""%"%""""%%"%"""%"""%"%%"%%%"%%"%"""%""""""""%
""%%%""""""""%"%%"""%%%%"%%""%"""%%%""%"%"""%"%"%%""%"%%"""%"""%%%%
%%%"%""%"%"""""""%""%"%%%"%"%%%%"""""%""""""%"""""%"""%%""%%"""%""%
""""""%"%""""""%"""%""%%"""""%"%%"%""%""%"%""%""%"%"%%%""%%""%"""%"
"""""%""""%"%%%%""%"%%%"""%"""%%%"%"%"%"""%%"%%%%"%"%""""%"%"%"%""%
"%"%%""%"""%"%"%"%""%"%%%%%"%""%%"""""""""%%"%%%""""%""%%%%%%"%""""
%%""""%%""""""""""""""""%%%%%%"""%"%%%"%%"""""""""%%%%""%%"""%""%%"
"""%"""%%"%%"%"%%"%"%%""""%""%"%"%%%""""%%""%""%%"""""%"%%""""%""""
%%"%""""""""%"""%""%"%"""%""""""%"%"%""%%"""""%""""""""%"%""%""%"%"
%"%""%""%%%%"""""""""""%""""%%""%""%%%""""%%""%""%"%"""%""%"%""""""
"""%%""%%%%"%"%""""%"%"%%"""""""%%%%"%%"%"""""%"""%"%%%"%%""""%%"""
"""""%%""%%%"""""%%"""%%%%"%""""""""%%""""%""%"""%%%%"""%%%%%%%"%"%
"%%%"""%"%"%%%"%"%%""%%%%""""%""%%"%""%"""""%%"%"%"%""%%""""%"%%""%
"%%""%"""%"%%%"%""%%"%%"""""""%%""%%%"""""%%"%""%%"%""""%"%""%%"%""
""%"%""""%%"""%""%"%""""%"%%""""%"%"%""%%"%"%"""""%"%""%"%"%"%""""%

How to repeat:
I'll find an exact testcase later.  I'm just doing this, where ? is a random hex string.

select * from t1 where match(a) against(?)

Suggested fix:
please remove the printout from the code. I guess it's in the fts parser somewhere.

[29 Jan 2014 16:29] MySQL Verification Team

This is a followup to:

Bug 16765397 - FTS: STILL SPAMMING THE ERROR LOG BASED ON USER QUERIES 
Bug 16429688 - FTS: SYNTAX ERROR, UNEXPECTED '*', EXPECTING $END