mysql stuck on socket write/read with mysqlrouter 8.0.29 if packet is big

[nj lcheng]

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)