socket_err_should_retry errno:11, adjust to 110

文章描述了数据库服务器在启动时遇到的问题,包括无法打开数据库、报错信息显示errno11(资源暂时不可用)和errno110(连接超时),同时系统日志中oswbbheartbeat警告IOSTAT和Top响应跨时间间隔。在解决这些问题后,数据库恢复正常运行。
摘要由CSDN通过智能技术生成

早上刚到公司,打开DEM发现打开失败,查看DEM数据库服务器,无数据库进程
查看实例日志,报错信息如下:
2023-03-29 07:40:41.610 [INFO] database P0002226002 T0000000000002226015 ckpt2_log_adjust: full_status: 160, ptx_reserved: 0
2023-03-29 07:40:42.193 [INFO] database P0002226002 T0000000000002226015 ckpt2_log_adjust: ckpt_lsn(730729202), ckpt_fil(0), ckpt_off(90926592), cur_lsn(730738292), l_next_seq(82142489), g_next_seq(82142489), cur_free(94491136), total_space(4294959104), used_space(3561984), free_space(4291397120), n_ep(1)
2023-03-29 07:40:43.165 [INFO] database P0002226002 T0000000000002226015 checkpoint end, 160 pages flushed, used_space[3567104], free_space[4291392000].
2023-03-29 07:41:48.702 [INFO] database P0002226002 T0000000000002623321 socket_err_should_retry errno:11, adjust to 110
2023-03-29 07:41:48.691 [INFO] database P0002226002 T0000000000002623320 socket_err_should_retry errno:11, adjust to 110
2023-03-29 07:41:49.719 [INFO] database P0002226002 T0000000000002623325 socket_err_should_retry errno:11, adjust to 110

socket_err_should_retry errno:11, adjust to 110
错误号11 ,调整为110.
errno:11 --Resource temporarily unavailable 资源暂时不可用
errno:110 – Connection timed out 连接超时
Linux errno 错误对照表参考链接
https://blog.csdn.net/dawudayudaxue/article/details/119643732

错误对照表:
errno0 : Success

errno1 : Operation not permitted

errno2 : No such file or directory

errno3 : No such process

errno4 : Interrupted system call

errno5 : Input/output error

errno6 : No such device or address

errno7 : Argument list too long

errno8 : Exec format error

errno9 : Bad file descriptor

errno10 : No child processes

errno11 : Resource temporarily unavailable

errno12 : Cannot allocate memory

errno13 : Permission denied

errno14 : Bad address

errno15 : Block device required

errno16 : Device or resource busy

errno17 : File exists

errno18 : Invalid cross-device link

errno19 : No such device

errno20 : Not a directory

errno21 : Is a directory

errno22 : Invalid argument

errno23 : Too many open files in system

errno24 : Too many open files

errno25 : Inappropriate ioctl for device

errno26 : Text file busy

errno27 : File too large

errno28 : No space left on device

errno29 : Illegal seek

errno30 : Read-only file system

errno31 : Too many links

errno32 : Broken pipe

errno33 : Numerical argument out of domain

errno34 : Numerical result out of range

errno35 : Resource deadlock avoided

errno36 : File name too long

errno37 : No locks available

errno38 : Function not implemented

errno39 : Directory not empty

errno40 : Too many levels of symbolic links

errno41 : Unknown error 41

errno42 : No message of desired type

errno43 : Identifier removed

errno44 : Channel number out of range

errno45 : Level 2 not synchronized

errno46 : Level 3 halted

errno47 : Level 3 reset

errno48 : Link number out of range

errno49 : Protocol driver not attached

errno50 : No CSI structure available

errno51 : Level 2 halted

errno52 : Invalid exchange

errno53 : Invalid request descriptor

errno54 : Exchange full

errno55 : No anode

errno56 : Invalid request code

errno57 : Invalid slot

errno58 : Unknown error 58

errno59 : Bad font file format

errno60 : Device not a stream

errno61 : No data available

errno62 : Timer expired

errno63 : Out of streams resources

errno64 : Machine is not on the network

errno65 : Package not installed

errno66 : Object is remote

errno67 : Link has been severed

errno68 : Advertise error

errno69 : Srmount error

errno70 : Communication error on send

errno71 : Protocol error

errno72 : Multihop attempted

errno73 : RFS specific error

errno74 : Bad message

errno75 : Value too large for defined datatype

errno76 : Name not unique on network

errno77 : File descriptor in bad state

errno78 : Remote address changed

errno79 : Can not access a needed sharedlibrary

errno80 : Accessing a corrupted sharedlibrary

errno81 : .lib section in a.out corrupted

errno82 : Attempting to link in too manyshared libraries

errno83 : Cannot exec a shared librarydirectly

errno84 : Invalid or incomplete multibyte orwide character

errno85 : Interrupted system call should berestarted

errno86 : Streams pipe error

errno87 : Too many users

errno88 : Socket operation on non-socket

errno89 : Destinationaddress required

errno90 : Message too long

errno91 : Protocol wrong type for socket

errno92 : Protocol not available

errno93 : Protocol not supported

errno94 : Socket type not supported

errno95 : Operation not supported

errno96 : Protocol family not supported

errno97 : Address family not supported byprotocol

errno98 : Address already in use

errno99 : Cannot assign requested address

errno100 : Network is down

errno101 : Network is unreachable

errno102 : Network dropped connection onreset

errno103 : Software caused connection abort

errno104 : Connection reset by peer

errno105 : No buffer space available

errno106 : Transport endpoint is alreadyconnected

errno107 : Transport endpoint is notconnected

errno108 : Cannot send after transportendpoint shutdown

errno109 : Too many references: cannot splice

errno110 : Connection timed out

errno111 : Connection refused

errno112 : Host is down

errno113 : No route to host

errno114 : Operation already in progress

errno115 : Operation now in progress

errno116 : Stale NFS file handle

errno117 : Structure needs cleaning

errno118 : Not a XENIX named type file

errno119 : No XENIX semaphores available

errno120 : Is a named type file

errno121 : Remote I/O error

errno122 : Disk quota exceeded

errno123 : No medium found

errno124 : Wrong medium type

errno125 : Operation canceled

errno126 : Required key not available

errno127 : Key has expired

errno128 : Key has been revoked

errno129 : Key was rejected by service

errno130 : Owner died

errno131 : State not recoverable

errno132 : Operation not possible due toRF-kill

errno133 : Unknown error 133

errno134 : Unknown error 134

errno135 : Unknown error 135

errno136 : Unknown error 136

errno137 : Unknown error 137

errno138 : Unknown error 138

errno139 : Unknown error 139

查看系统日志,无信息
查看系统watcherlog日志,在该时刻告警信息
oswbb heartbeat:wed Mar 29 07:40:58 CST 2023Warning. IOSTAT response is spanning snapshot intervalsWarning. Top response is spanning snapshot intervals.oswbb heartbeat:Wed Mar 29 07:42:09 CST 2023oswbb heartbeat:Wed Mar 29 07:43:24 CST 2023oswbb heartbeat:Wed Mar 29 07:44:30 CST 2023Warning. TOp response is spanning snapshot intervals.oswbb heartbeat:Wed Mar 29 07:45:30 CST 2023Warning.IOSTAT response is spanning snapshot intervalsoswbb heartbeat:Wed Mar 29 07:46:38 CST 2023Warning. Top response is spanning snapshot intervals.oswbb heartbeat:Wed Mar 29 07:47:44 CST 2023oswbb heartbeat:Wed Mar 29 07:48:34 CST 2023Warning.IOSTAT response is spanning snapshot intervals***Warning. Top response is spanning snapshot intervals.
不知是不是系统层在该时段是否进行了某些操作,待查!

正常启动数据库恢复正常。

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值