JDBC连接mycat执行load infile 出现Communications link failure

最新推荐文章于 2023-11-08 15:21:58 发布

原创

最新推荐文章于 2023-11-08 15:21:58 发布 · 1.5k 阅读

2 ·

CC 4.0 BY-SA版权

文章标签：

#mycat #mysql #jvm

在使用JDBC连接Mycat执行`LOAD DATA INFILE`命令时遇到Communications link failure错误。首先尝试通过增大JVM参数解决，但仍有警告。接着调整Mycat的server.xml配置，将processorBufferChunk参数加大，成功消除警告，问题得到解决。

现象

执行load命令时，java程序异常退出，mycat日志报错：

02/28 18:59:20.494   WARN [$_NIOREACTOR-7-RW] (BufferPool.java:187) -allocate buffer size large than default chunksize:4096 he want 8192
02/28 18:59:20.494   WARN [$_NIOREACTOR-7-RW] (BufferPool.java:187) -allocate buffer size large than default chunksize:4096 he want 16384
02/28 18:59:20.494   WARN [$_NIOREACTOR-7-RW] (BufferPool.java:187) -allocate buffer size large than default chunksize:4096 he want 32768
02/28 18:59:20.494   WARN [$_NIOREACTOR-7-RW] (BufferPool.java:187) -allocate buffer size large than default chunksize:4096 he want 65536
02/28 18:59:20.494   WARN [$_NIOREACTOR-7-RW] (BufferPool.java:187) -allocate buffer size large than default chunksize:4096 he want 131072
02/28 18:59:20.495   WARN [$_NIOREACTOR-7-RW] (BufferPool.java:187) -allocate buffer size large than default chunksize:4096 he want 262144
02/28 18:59:20.495   WARN [$_NIOREACTOR-7-RW] (BufferPool.java:187) -allocate buf