Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
1.4.1
-
None
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
|
Attachments
Issue Links
- duplicates
-
-
- Closed
-