[MXS-2227] optimize table: Query could not be tokenized/Parsing the query failed, cannot report query type Created: 2018-12-20  Updated: 2020-03-07  Resolved: 2020-03-04

Status: Closed
Project: MariaDB MaxScale
Component/s: dbfwfilter, qc_sqlite
Affects Version/s: 2.2.17
Fix Version/s: 2.4.8

Type: Bug Priority: Major
Reporter: Thies Meincke Assignee: Johan Wikman
Resolution: Fixed Votes: 0
Labels: None
Environment:

SLES12.3


Sprint: MXS-SPRINT-101

 Description   

optimize table <tab> throws error (client):
MariaDB [****]> optimize table ****;
ERROR 1141 (HY000): Access denied for user '****'@'::ffff:****': Query could not be tokenized and will hence be rejected. Please ensure that the SQL syntax is correct.

maxscale-log:
2018-12-20 15:48:23 info : (5) [qc_sqlite] Parsing the query failed, cannot report query type: optimize table ****
2018-12-20 15:48:23 warning: (5) [dbfwfilter] Query could not be tokenized and will hence be rejected. Please ensure that the SQL syntax is correct: optimize table ****

when using dbfwfilter and rules containing regex
no regex-rules: optimize table works.


Generated at Thu Feb 08 04:12:36 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.