Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
2.0.4
-
None
-
JDBC Version 1.5.5
10.1.21-MariaDB-enterprise galera cluster on Linux Ubuntu 14.04.4 LTS
-
2017-29, 2017-30, 2017-31, 2017-32, 2017-33
Description
For an unknown reason, the statement aborts down suddenly with error message (attached in exception.txt)
On the node associated with the MaxScale there is following error entry:
Feb 23 12:04:32 mariadbcluster2 mysqld: 2017-02-23 12:04:32
140255419796224 [warning] aborted connection 11242 to db: 'E2_MC_XX'
user: 'E2_USER_MC_XX' host: '192.168.22.181' (got error reading
communication packets)
In MaxScale log no error messages are written.
The statements copy PDF documents and images (as a BLOBs) into the corresponding table in a database.
This PreparedStatement is used:
INSERT INTO DOCUMENTS
(DOCUMENT_ID,FILENAME,REMARKS,PARENT_FOLDER_ID,PREVIEW,DOCUMENT,IS_FOLDER,BUZZWORD1,BUZZWORD2,BUZZWORD3,BUZZWORD4,BUZZWORD5,BUZZWORD6,BUZZWORD7,BUZZWORD8,BUZZWORD9,BUZZWORD10,DOCUMENT_TYPE,WAS_EXPORTED,CLIENT_ID,DOCUMENT_BYTE_SIZE,PREVIEW_BYTE_SIZE,IS_SIGNED,DOCUMENTDATE)
VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
The problem occurs randomly, only when this statement is executed. Sometime after 100 inserts, other time after more than 4000 inserts.
Connects directly to one of the three nodes are running without problems.
So it seems to be MaxScale problem only.
Cannot setup MaxScale as readwritesplit since read and write operation would be one transaction (application side!)
Attachments
Issue Links
- is duplicated by
-
MXS-1214 Streaming Insert Filter gives errors
- Closed