Io 异常: Connection reset;Io 异常: Got minus one from a read call;IO 错误: Connection reset by peer, Authe
报错信息:
1.
IO 错误: Connection reset by peer, Authentication lapse 0 ms.
搜索网上有些回答说
是JVM随机数造成的延迟问题。
看下kettle控制台所属服务器的$JAVA_HOME/jre/lib/security/java.security文件中将命令securerandom.source=file:/dev/random
改为:securerandom.source=file:/dev/unrandom
但是我查看我服务器的这个文件中本来就是securerandom.source=file:/dev/unrandom。
2.
再运行一次发现报错有变化:
IO 错误: Got minus one from a read call
再跑一次的话报错还有变化:
Io 异常: Connection reset
第二个报错像是连接中断的报错,
然后去服务器长ping这个数据库服务器核实一下会不会丢包
命令:ping IP -c 50 | awk '{ print $0"\t" strftime("%H:%M:%S",systime()) } ’
发现会有百分之二的丢包概率
3.
调了一段时间的报错整理:(30秒重复一次)
2022/10/13 17:29:32 - 表输入.0 - Io 异常: Connection reset
2022/10/13 17:30:02 - 表输入.0 - Io 异常: Got minus one from a read call
2022/10/13 17:30:32 - 表输入.0 - Io 异常: Got minus one from a read call
2022/10/13 17:31:02 - 表输入.0 - Io 异常: Connection reset
2022/10/13 17:31:32 - 表输入.0 - Io 异常: Connection reset
2022/10/13 17:32:02 - 表输入.0 - Io 异常: Connection reset
2022/10/13 17:32:32 - 表输入.0 - Io 异常: Connection reset
2022/10/13 17:33:03 - 表输入.0 - Io 异常: Connection reset
2022/10/13 17:33:33 - 表输入.0 - Io 异常: Connection reset
2022/10/13 17:34:03 - 表输入.0 - Io 异常: Connection reset
2022/10/13 17:34:33 - 表输入.0 - Io 异常: Connection reset
2022/10/13 17:35:03 - 表输入.0 - Io 异常: Connection reset
2022/10/13 17:35:33 - 表输入.0 - Io 异常: Connection reset
2022/10/13 17:36:03 - 表输入.0 - Io 异常: Got minus one from a read call
2022/10/13 17:36:33 - 表输入.0 - Io 异常: Connection reset
2022/10/13 17:37:03 - 表输入.0 - Io 异常: Connection reset
首先将丢包问题解决丢包
在kitchen.sh文件的最后一行中的Java 命令行中增加参数:-Djava.security.egd=file:/dev/…/dev/urandom 试试
4.改动之后一段时间的报错整理:(30秒重复一次)
2022/10/13 17:58:12 - 表输入.0 - IO 错误: Got minus one from a read call
2022/10/13 17:58:42 - 表输入.0 - IO 错误: Got minus one from a read call
2022/10/13 17:59:13 - 表输入.0 - IO 错误: Got minus one from a read call
2022/10/13 17:59:43 - 表输入.0 - IO 错误: Got minus one from a read call
2022/10/13 18:00:13 - 表输入.0 - IO 错误: Got minus one from a read call
2022/10/13 18:00:43 - 表输入.0 - IO 错误: Got minus one from a read call
2022/10/13 18:01:13 - 表输入.0 - IO 错误: Got minus one from a read call
2022/10/13 18:01:43 - 表输入.0 - IO 错误: Got minus one from a read call
2022/10/13 18:02:13 - 表输入.0 - IO 错误: Got minus one from a read call
2022/10/13 18:02:43 - 表输入.0 - IO 错误: Got minus one from a read call
2022/10/13 18:03:13 - 表输入.0 - IO 错误: Got minus one from a read call
2022/10/13 18:03:43 - 表输入.0 - IO 错误: Got minus one from a read call
2022/10/13 18:04:13 - 表输入.0 - IO 错误: Got minus one from a read call
2022/10/13 18:04:43 - 表输入.0 - IO 错误: Got minus one from a read call
2022/10/13 18:05:14 - 表输入.0 - IO 错误: Got minus one from a read call
2022/10/13 18:05:44 - 表输入.0 - IO 错误: Connection reset by peer, Authentication lapse 0 ms.
2022/10/13 18:06:14 - 表输入.0 - IO 错误: Connection reset by peer, Authentication lapse 0 ms.
2022/10/13 18:06:44 - 表输入.0 - IO 错误: Got minus one from a read call
2022/10/13 18:07:14 - 表输入.0 - IO 错误: Got minus one from a read call
2022/10/13 18:07:44 - 表输入.0 - IO 错误: Got minus one from a read call
2022/10/13 18:08:14 - 表输入.0 - IO 错误: Got minus one from a read call
2022/10/13 18:08:44 - 表输入.0 - IO 错误: Got minus one from a read call
2022/10/13 18:09:14 - 表输入.0 - IO 错误: Got minus one from a read call
2022/10/13 18:10:44 - 表输入.0 - IO 错误: Got minus one from a read call
2022/10/13 18:11:14 - 表输入.0 - IO 错误: Got minus one from a read call
2022/10/13 18:11:44 - 表输入.0 - IO 错误: Got minus one from a read call
2022/10/13 18:12:14 - 表输入.0 - IO 错误: Got minus one from a read call
2022/10/13 18:12:45 - 表输入.0 - IO 错误: Got minus one from a read call
2022/10/13 18:13:15 - 表输入.0 - IO 错误: Got minus one from a read call
发现报错基本维持在一种报错,
此报错考虑为数据库连接数超了的问题,联系对方数据库dba核查,但是数据库连接数没有超,
最后发现为
此服务器ip不在数据库的白名单中,
dba将此服务器ip加到数据库的白名单中,发现正常,没有报错了。
完成。
Io 异常: Connection reset;Io 异常: Got minus one from a read call;IO 错误: Connection reset by peer, Authe
报错信息:
1.
IO 错误: Connection reset by peer, Authentication lapse 0 ms.
搜索网上有些回答说
是JVM随机数造成的延迟问题。
看下kettle控制台所属服务器的$JAVA_HOME/jre/lib/security/java.security文件中将命令securerandom.source=file:/dev/random
改为:securerandom.source=file:/dev/unrandom
但是我查看我服务器的这个文件中本来就是securerandom.source=file:/dev/unrandom。
2.
再运行一次发现报错有变化:
IO 错误: Got minus one from a read call
再跑一次的话报错还有变化:
Io 异常: Connection reset
第二个报错像是连接中断的报错,
然后去服务器长ping这个数据库服务器核实一下会不会丢包
命令:ping IP -c 50 | awk '{ print $0"\t" strftime("%H:%M:%S",systime()) } ’
发现会有百分之二的丢包概率
3.
调了一段时间的报错整理:(30秒重复一次)
2022/10/13 17:29:32 - 表输入.0 - Io 异常: Connection reset
2022/10/13 17:30:02 - 表输入.0 - Io 异常: Got minus one from a read call
2022/10/13 17:30:32 - 表输入.0 - Io 异常: Got minus one from a read call
2022/10/13 17:31:02 - 表输入.0 - Io 异常: Connection reset
2022/10/13 17:31:32 - 表输入.0 - Io 异常: Connection reset
2022/10/13 17:32:02 - 表输入.0 - Io 异常: Connection reset
2022/10/13 17:32:32 - 表输入.0 - Io 异常: Connection reset
2022/10/13 17:33:03 - 表输入.0 - Io 异常: Connection reset
2022/10/13 17:33:33 - 表输入.0 - Io 异常: Connection reset
2022/10/13 17:34:03 - 表输入.0 - Io 异常: Connection reset
2022/10/13 17:34:33 - 表输入.0 - Io 异常: Connection reset
2022/10/13 17:35:03 - 表输入.0 - Io 异常: Connection reset
2022/10/13 17:35:33 - 表输入.0 - Io 异常: Connection reset
2022/10/13 17:36:03 - 表输入.0 - Io 异常: Got minus one from a read call
2022/10/13 17:36:33 - 表输入.0 - Io 异常: Connection reset
2022/10/13 17:37:03 - 表输入.0 - Io 异常: Connection reset
首先将丢包问题解决丢包
在kitchen.sh文件的最后一行中的Java 命令行中增加参数:-Djava.security.egd=file:/dev/…/dev/urandom 试试
4.改动之后一段时间的报错整理:(30秒重复一次)
2022/10/13 17:58:12 - 表输入.0 - IO 错误: Got minus one from a read call
2022/10/13 17:58:42 - 表输入.0 - IO 错误: Got minus one from a read call
2022/10/13 17:59:13 - 表输入.0 - IO 错误: Got minus one from a read call
2022/10/13 17:59:43 - 表输入.0 - IO 错误: Got minus one from a read call
2022/10/13 18:00:13 - 表输入.0 - IO 错误: Got minus one from a read call
2022/10/13 18:00:43 - 表输入.0 - IO 错误: Got minus one from a read call
2022/10/13 18:01:13 - 表输入.0 - IO 错误: Got minus one from a read call
2022/10/13 18:01:43 - 表输入.0 - IO 错误: Got minus one from a read call
2022/10/13 18:02:13 - 表输入.0 - IO 错误: Got minus one from a read call
2022/10/13 18:02:43 - 表输入.0 - IO 错误: Got minus one from a read call
2022/10/13 18:03:13 - 表输入.0 - IO 错误: Got minus one from a read call
2022/10/13 18:03:43 - 表输入.0 - IO 错误: Got minus one from a read call
2022/10/13 18:04:13 - 表输入.0 - IO 错误: Got minus one from a read call
2022/10/13 18:04:43 - 表输入.0 - IO 错误: Got minus one from a read call
2022/10/13 18:05:14 - 表输入.0 - IO 错误: Got minus one from a read call
2022/10/13 18:05:44 - 表输入.0 - IO 错误: Connection reset by peer, Authentication lapse 0 ms.
2022/10/13 18:06:14 - 表输入.0 - IO 错误: Connection reset by peer, Authentication lapse 0 ms.
2022/10/13 18:06:44 - 表输入.0 - IO 错误: Got minus one from a read call
2022/10/13 18:07:14 - 表输入.0 - IO 错误: Got minus one from a read call
2022/10/13 18:07:44 - 表输入.0 - IO 错误: Got minus one from a read call
2022/10/13 18:08:14 - 表输入.0 - IO 错误: Got minus one from a read call
2022/10/13 18:08:44 - 表输入.0 - IO 错误: Got minus one from a read call
2022/10/13 18:09:14 - 表输入.0 - IO 错误: Got minus one from a read call
2022/10/13 18:10:44 - 表输入.0 - IO 错误: Got minus one from a read call
2022/10/13 18:11:14 - 表输入.0 - IO 错误: Got minus one from a read call
2022/10/13 18:11:44 - 表输入.0 - IO 错误: Got minus one from a read call
2022/10/13 18:12:14 - 表输入.0 - IO 错误: Got minus one from a read call
2022/10/13 18:12:45 - 表输入.0 - IO 错误: Got minus one from a read call
2022/10/13 18:13:15 - 表输入.0 - IO 错误: Got minus one from a read call
发现报错基本维持在一种报错,
此报错考虑为数据库连接数超了的问题,联系对方数据库dba核查,但是数据库连接数没有超,
最后发现为
此服务器ip不在数据库的白名单中,
dba将此服务器ip加到数据库的白名单中,发现正常,没有报错了。
完成。