[MXS-1329] Using filters with SSL and keep alive can cause errors Created: 2017-07-26  Updated: 2020-08-25  Resolved: 2017-07-27

Status: Closed
Project: MariaDB MaxScale
Component/s: Core
Affects Version/s: 2.1.4
Fix Version/s: 2.1.5

Type: Bug Priority: Major
Reporter: Kyle Joiner (Inactive) Assignee: markus makela
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MXS-1677 "Query could not be parsed" errors Closed

 Description   

Receive the following error:

2017-07-26 15:21:00 error : [qc_sqlite] The query could not be parsed. Response not valid.
2017-07-26 15:21:00 error : [qc_sqlite] The provided buffer does not contain a COM_QUERY, but a MYSQL_COM_STMT_EXECUTE.
2017-07-26 15:21:00 error : [qc_sqlite] The query could not be parsed. Response not valid.
2017-07-26 15:21:00 error : [qc_sqlite] The provided buffer does not contain a COM_QUERY, but a MYSQL_COM_STMT_EXECUTE.
2017-07-26 15:21:00 error : [qc_sqlite] The query could not be parsed. Response not valid.
2017-07-26 15:21:00 error : [qc_sqlite] The provided buffer does not contain a COM_QUERY, but a MYSQL_COM_STMT_EXECUTE.
2017-07-26 15:21:00 error : [qc_sqlite] The query could not be parsed. Response not valid.
2017-07-26 15:21:00 error : [qc_sqlite] The provided buffer does not contain a COM_QUERY, but a MYSQL_COM_STMT_EXECUTE.
2017-07-26 15:21:00 error : [qc_sqlite] The query could not be parsed. Response not valid.
2017-07-26 15:21:00 error : [qc_sqlite] The provided buffer does not contain a COM_QUERY, but a MYSQL_COM_STMT_EXECUTE.
2017-07-26 15:21:00 error : [qc_sqlite] The query could not be parsed. Response not valid.
2017-07-26 15:21:00 error : [qc_sqlite] The provided buffer does not contain a COM_QUERY, but a MYSQL_COM_STMT_EXECUTE.
2017-07-26 15:21:00 error : [qc_sqlite] The query could not be parsed. Response not valid.
2017-07-26 15:21:00 error : [qc_sqlite] The provided buffer does not contain a COM_QUERY, but a MYSQL_COM_STMT_EXECUTE.
2017-07-26 15:21:00 error : [qc_sqlite] The query could not be parsed. Response not valid.
2017-07-26 15:21:00 error : [qc_sqlite] The provided buffer does not contain a COM_QUERY, but a MYSQL_COM_STMT_EXECUTE.
2017-07-26 15:21:00 error : [qc_sqlite] The query could not be parsed. Response not valid.
2017-07-26 15:21:00 error : [qc_sqlite] The provided buffer does not contain a COM_QUERY, but a MYSQL_COM_STMT_EXECUTE. (subsequent similar messages suppressed for 10000 milliseconds)

 Comments   
Comment by markus makela [ 2017-07-26 ]

The insertstream filter will attempt to parse all incoming queries as if they were COM_QUERY statements. This will cause errors to be logged for non-COM_QUERY statements. The correct procedure for parsing is to first check if the buffer contains a text protocol or a binary protocol statement and only then parse it.

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