Getting Unable to write message error with mysql-connector-java
Posted by: Arul�* velan
Date: November 28, 2021 04:30AM

Server version : 8.0.26 .We are using MySQL Document store with below timeout configs.

Server params
-------------
connect_timeout 30
delayed_insert_timeout 300
have_statement_timeout YES
innodb_flush_log_at_timeout 1
innodb_lock_wait_timeout 50
innodb_rollback_on_timeout OFF
interactive_timeout 28800
lock_wait_timeout 31536000
mysqlx_connect_timeout 30
mysqlx_idle_worker_thread_timeout 60
mysqlx_interactive_timeout 28800
mysqlx_port_open_timeout 0
mysqlx_read_timeout 30
mysqlx_wait_timeout 28800


We are getting below error while inserting data in MySQL xDB. We are able to read the data from collections at the same time. Pls suggest.

com.mysql.cj.exceptions.CJCommunicationsException: Unable to write message
at com.mysql.cj.protocol.x.SyncMessageSender.send(SyncMessageSender.java:86) ~[mysql-connector-java-8.0.21.jar:8.0.21]
at com.mysql.cj.protocol.x.SyncMessageSender.send(SyncMessageSender.java:49) ~[mysql-connector-java-8.0.21.jar:8.0.21]
at com.mysql.cj.protocol.x.XProtocol.send(XProtocol.java:944) ~[mysql-connector-java-8.0.21.jar:8.0.21]
at com.mysql.cj.protocol.x.XProtocol.query(XProtocol.java:880) ~[mysql-connector-java-8.0.21.jar:8.0.21]
at com.mysql.cj.MysqlxSession.query(MysqlxSession.java:170) ~[mysql-connector-java-8.0.21.jar:8.0.21]
at com.mysql.cj.xdevapi.AddStatementImpl.execute(AddStatementImpl.java:93) ~[mysql-connector-java-8.0.21.jar:8.0.21]
at com.mysql.cj.xdevapi.AddStatementImpl.execute(AddStatementImpl.java:47) ~[mysql-connector-java-8.0.21.jar:8.0.21]


Caused by: java.net.SocketException: Socket closed
at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:118) ~[?:1.8.0_271]
at java.net.SocketOutputStream.write(SocketOutputStream.java:155) ~[?:1.8.0_271]
at sun.security.ssl.SSLSocketOutputRecord.deliver(SSLSocketOutputRecord.java:341) ~[?:1.8.0_271]
at sun.security.ssl.SSLSocketImpl$AppOutputStream.write(SSLSocketImpl.java:1106) ~[?:1.8.0_271]
at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82) ~[?:1.8.0_271]
at java.io.BufferedOutputStream.write(BufferedOutputStream.java:126) ~[?:1.8.0_271]
at com.google.protobuf.CodedOutputStream$OutputStreamEncoder.doFlush(CodedOutputStream.java:3062) ~[protobuf-java-3.11.4.jar:?]
at com.google.protobuf.CodedOutputStream$OutputStreamEncoder.flush(CodedOutputStream.java:2974) ~[protobuf-java-3.11.4.jar:?]
at com.google.protobuf.AbstractMessageLite.writeTo(AbstractMessageLite.java:84) ~[protobuf-java-3.11.4.jar:?]
at com.mysql.cj.protocol.x.SyncMessageSender.send(SyncMessageSender.java:81) ~[mysql-connector-java-8.0.21.jar:8.0.21]

Options: ReplyQuote


Subject
Written By
Posted
Getting Unable to write message error with mysql-connector-java
November 28, 2021 04:30AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.