MySQL Forums
Forum List  »  Router & Proxy

mysql stuck on socket write/read with mysqlrouter 8.0.29 if packet is big
Posted by: nj lcheng
Date: May 31, 2022 07:46PM

Hi, team
In setup one MySQL Innodb cluster as below
a. host-A
MySQL server 8.0.29 + MySQL rourter 8.0.29 + MySQL shell 8.0.29
b. host-B
MySQL server 8.0.29
c. host-C
MySQL server 8.0.29 + Application

Before running application, I connect to the MySQL Innodb cluster with mysqlrouter url (host-A :6446), everything looks ok. Create db/table and then insert one row, all mysql servers are sychonized.
However, everytime when inserting one big row, around 30M I guess, it always stuck on the socket write with the same thread stack as below, and it's reproducible.
Then I uninstalled mysqlrouter 8.0.29 and mysqlsh 8.0.29, and install both of them with 8.0.28, this issue gone. Reinstalled 8.0.29 back, this issue occurs again.



java.lang.Thread.State: RUNNABLE
at java.net.SocketOutputStream.socketWrite0(Native Method)
at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:111)
at java.net.SocketOutputStream.write(SocketOutputStream.java:155)
at java.io.BufferedOutputStream.write(BufferedOutputStream.java:122)
- locked <0x00000000a4315ac8> (a java.io.BufferedOutputStream)
at com.mysql.cj.protocol.a.SimplePacketSender.send(SimplePacketSender.java:53)
at com.mysql.cj.protocol.a.TimeTrackingPacketSender.send(TimeTrackingPacketSender.java:50)
at com.mysql.cj.protocol.a.NativeProtocol.send(NativeProtocol.java:558)
at com.mysql.cj.protocol.a.NativeProtocol.sendCommand(NativeProtocol.java:622)
at com.mysql.cj.protocol.a.NativeProtocol.sendQueryPacket(NativeProtocol.java:987)
at com.mysql.cj.NativeSession.execSQL(NativeSession.java:666)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:930)
- locked <0x00000000a4314a50> (a com.mysql.cj.jdbc.ConnectionImpl)
at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:371)
- locked <0x00000000a4314a50> (a com.mysql.cj.jdbc.ConnectionImpl)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:169)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:169)
at org.apache.jackrabbit.core.util.db.ConnectionHelper.execute(ConnectionHelper.java:441)
at org.apache.jackrabbit.core.util.db.ConnectionHelper.reallyUpdate(ConnectionHelper.java:320)
at org.apache.jackrabbit.core.util.db.ConnectionHelper.access$3(ConnectionHelper.java:314)
at org.apache.jackrabbit.core.util.db.ConnectionHelper$2.call(ConnectionHelper.java:308)
at org.apache.jackrabbit.core.util.db.ConnectionHelper$2.call(ConnectionHelper.java:1)
at org.apache.jackrabbit.core.util.db.ConnectionHelper$RetryManager.doTry(ConnectionHelper.java:454)
at org.apache.jackrabbit.core.util.db.ConnectionHelper.update(ConnectionHelper.java:311)
at org.apache.jackrabbit.core.util.db.MySqlConnectionHelper.update(MySqlConnectionHelper.java:165)
at org.apache.jackrabbit.core.persistence.pool.BundleDbPersistenceManager.storeBundle(BundleDbPersistenceManager.java:1087)
- locked <0x00000000a43d6950> (a org.apache.jackrabbit.core.persistence.pool.MySqlPersistenceManager)
at org.apache.jackrabbit.core.persistence.bundle.AbstractBundlePersistenceManager.putBundle(AbstractBundlePersistenceManager.java:684)
at org.apache.jackrabbit.core.persistence.bundle.AbstractBundlePersistenceManager.storeInternal(AbstractBundlePersistenceManager.java:626)
at org.apache.jackrabbit.core.persistence.bundle.AbstractBundlePersistenceManager.store(AbstractBundlePersistenceManager.java:503)
- locked <0x00000000a43d6950> (a org.apache.jackrabbit.core.persistence.pool.MySqlPersistenceManager)
at org.apache.jackrabbit.core.persistence.pool.BundleDbPersistenceManager.store(BundleDbPersistenceManager.java:480)
- locked <0x00000000a43d6950> (a org.apache.jackrabbit.core.persistence.pool.MySqlPersistenceManager)
at org.apache.jackrabbit.core.state.SharedItemStateManager$Update.end(SharedItemStateManager.java:757)
at org.apache.jackrabbit.core.state.XAItemStateManager.commit(XAItemStateManager.java:181)
at org.apache.jackrabbit.core.TransactionContext.commit(TransactionContext.java:209)
- locked <0x00000000fc6ac578> (a org.apache.jackrabbit.core.TransactionContext)
at org.apache.jackrabbit.core.XASessionImpl.commit(XASessionImpl.java:331)
at org.apache.jackrabbit.jca.JCASessionHandle.commit(JCASessionHandle.java:414)
at org.apache.jackrabbit.jca.JCALocalTransaction.commit(JCALocalTransaction.java:84)

Options: ReplyQuote


Subject
Views
Written By
Posted
mysql stuck on socket write/read with mysqlrouter 8.0.29 if packet is big
161
May 31, 2022 07:46PM


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.