[MXS-668] Error when parsing query Created: 2016-04-13  Updated: 2016-04-18  Resolved: 2016-04-18

Status: Closed
Project: MariaDB MaxScale
Component/s: schemarouter
Affects Version/s: 1.4.1
Fix Version/s: 1.4.2

Type: Bug Priority: Major
Reporter: Anton Assignee: markus makela
Resolution: Duplicate Votes: 0
Labels: None

Issue Links:
Duplicate
duplicates MXS-661 Log fills with 'Length (0) is 0 or qu... Closed

 Description   

We are trying upload file to database:

When:

info   : > Cmd: COM_QUERY, type: QUERY_TYPE_WRITE, stmt: INSERT INTO files_att (file_name, file_type, file_body, file_size) VALUES ('BZhD.rar', 'application/x-rar', 'Rar!\Z\0ϐs\0\0\r\0\0\0\0\0\0\0�~t��M\0�\0\0\0\0\0�F=�+��E3-\0&\0\0\0���

Maxscale log have this:

info   : > Cmd: COM_INIT_DB, type: QUERY_TYPE_SESSION_WRITE, stmt: ���RwyP�O8������˂ҝ�ɷ{�v��qr��_�
 
2016-04-13 11:32:49   error  : change_current_db: failed to change database: Query buffer too large
2016-04-13 11:32:49   [105]  info   : change_current_db: failed to change database: Query buffer too large [2096293 bytes]
2016-04-13 11:32:49   error  : Fatal: MaxScale 1.4.1 received fatal signal 11. Attempting backtrace.

Link to uploaded file: https://yadi.sk/d/SFD9IFrhqxUB7 (17.53 MB)

MySql execute this query without errors.

mysql --version
mysql  Ver 15.1 Distrib 10.0.23-MariaDB, for Linux (x86_64) using readline 5.1

Maxscale conf:

[maxscale]
threads=2
 
[Sharded Service]
type=service
router=schemarouter
servers=max1,max2
user=sharduser
passwd=...
 
[Sharded Service Listener]
type=listener
service=Sharded Service
protocol=MySQLClient
port=4000
 
[CLI]
type=service
router=cli
 
[CLI Listener]
type=listener
service=CLI
protocol=maxscaled
port=6603
 
[MySQL Monitor]
type=monitor
module=mysqlmon
servers=max1,max2
user=monitoruser
passwd=...
monitor_interval=1000
 
[max1]
type=server
address=...
port=3306
protocol=MySQLBackend
 
[max2]
type=server
address=...
port=3306
protocol=MySQLBackend



 Comments   
Comment by markus makela [ 2016-04-15 ]

This is most likely related to MXS-661.

Comment by markus makela [ 2016-04-18 ]

Closing this as a duplicate of MXS-661.

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