online.log中的錯誤信息

wantfly

今天在看online.log時發現以下信息,不知道是為什麼.請大家幫忙會診一下.
目前數據庫運行正常,昨天備份也正常.

03:55:51  Checkpoint loguniq 280608, logpos 0x32018, timestamp: 1692764495

03:55:51  Maximum server connections 527
04:02:25  listener-thread: err = -25587: oserr = 0: errstr = : 網絡接收失敗.

04:12:06  listener-thread: err = -25587: oserr = 0: errstr = : 網絡接收失敗.

04:12:16  listener-thread: err = -25587: oserr = 0: errstr = : 網絡接收失敗.

04:12:24  listener-thread: err = -25587: oserr = 0: errstr = : 網絡接收失敗.

04:13:06  檢查點完成:  期間為 424 秒.
04:13:06  Checkpoint loguniq 280608, logpos 0x45018, timestamp: 1692766267

04:13:06  Maximum server connections 527
04:13:07  listener-thread: err = -25587: oserr = 0: errstr = : 網絡接收失敗.

04:13:09  listener-thread: err = -25587: oserr = 0: errstr = : 網絡接收失敗.

04:13:13  listener-thread: err = -25587: oserr = 0: errstr = : 網絡接收失敗.

04:13:17  listener-thread: err = -25587: oserr = 0: errstr = : 網絡接收失敗.

04:13:21  listener-thread: err = -25587: oserr = 0: errstr = : 網絡接收失敗.

04:13:25  listener-thread: err = -25587: oserr = 0: errstr = : 網絡接收失敗.

04:23:28  檢查點完成:  期間為 17 秒.
04:23:28  Checkpoint loguniq 280608, logpos 0x580c8, timestamp: 1692770041

mwao

我也碰到过这个问题,经判断是连接用户数太多,CPU反映不过来,不够用原因.如果CPU<=2个,没什么办法,如>2个,配置更改一下,绑定CPU就行.

wantfly

TO mwao:
    這個情況我認為應該是不可能的,因為時間段是在半夜.不是在白天.
白天用戶多時也沒有這種錯誤呀,我們半夜基本上沒有用戶在用的.

mydb

可能是客户端设置的问题.
客户断和服务器的连接参数不匹配(可能是客户端,也可能是数据库的通讯参数被修改),数据库再收到这些来自客户端的连接请求后,被丢掉,并记录错误信息

IFMXDBA

another possibility, there was a long check point around 8 minutes.  During the checkpoint, the engine is in critical seciton which is flushing logical/phyiscal log buffers to the physical files.  Check if your system have a big job is progressing at that time.  You can also try to adjust the LRU_MIN_DIRTY, LRU_MAX_DIRTY and CKPTINTRVL for checkpoint duration.  Also, you might need check your SAN or disk array log to verify if there is any potential problems.