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

最新推荐文章于 2023-03-15 13:45:05 发布

西城月老

最新推荐文章于 2023-03-15 13:45:05 发布

阅读量1.4k

点赞数

分类专栏： mysql 文章标签： mycat mysql jvm

本文链接：https://blog.csdn.net/basicworld/article/details/88042414

版权

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

摘要由CSDN通过智能技术生成

现象

执行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] (Buff