liangang24 发表于 2019-02-21 12:04

救急,sybase数据库宕机

sybase数据库宕机,应用系统无法使用,central、isql等无法连接,ping server正常,重启服务后正常,日志如下:
0:0048:00000:00000:2019/02/21 09:33:45.98 kernelnrpacket: recv, Connection timed out, spid: 1136, suid: 1
00:0048:00000:00000:2019/02/21 09:33:45.98 kernelextended error information: hostname:login: sa
00:0048:00000:00000:2019/02/21 09:33:45.98 kernelnrpacket: recv, Connection timed out, spid: 219, suid: 1
00:0028:00000:00742:2019/02/21 09:33:45.98 kernelCannot send, host process disconnected:3632 suid: 1
00:0048:00000:00000:2019/02/21 09:33:45.98 kernelextended error information: hostname:login: sa
00:0040:00000:00219:2019/02/21 09:33:45.98 kernelCannot send, host process disconnected:4024 suid: 1
00:0048:00000:00000:2019/02/21 09:33:45.98 kernelCurrent process (0x0) infected with signal 11 (SIGSEGV)
00:0048:00000:00000:2019/02/21 09:33:46.12 kernelAddress 0x0x000000000160682a (kstcpnetctlrCancelRequests+0x97), siginfo (code, address) = (1, 0x(nil))
00:0048:00000:00000:2019/02/21 09:33:46.13 kernel**** Saved signal context (0x0x00007fbac3ffe6c0): ****
00:0048:00000:00000:2019/02/21 09:33:46.13 kerneluc_flags: 0x1, uc_link: 0x(nil)
00:0048:00000:00000:2019/02/21 09:33:46.13 kerneluc_sigmask: 0x7bfbf037 0xb 0x1 0x0
00:0048:00000:00000:2019/02/21 09:33:46.13 kerneluc_stack: ss_sp: 0x(nil), ss_size: 0x0, ss_flags: 0x2
00:0048:00000:00000:2019/02/21 09:33:46.13 kernelGeneral Registers (uc_mcontext.gregs):
00:0048:00000:00000:2019/02/21 09:33:46.13 kernel        PC : 0x000000000160682a (kstcpnetctlrCancelRequests+0x97)
00:0048:00000:00000:2019/02/21 09:33:46.13 kernel          RAX : 0x000000016726c0d8RBX : 0x0000000000000001
00:0048:00000:00000:2019/02/21 09:33:46.13 kernel          RCX : 0x0000000167292000RDX : 0x000000016726c0d8
00:0048:00000:00000:2019/02/21 09:33:46.13 kernel        RBP : 0x00007fbac3ffec80RSP : 0x00007fbac3ffec50
00:0048:00000:00000:2019/02/21 09:33:46.13 kernel        R8: 0x000000016700e958R9: 0x00000000000000ab
00:0048:00000:00000:2019/02/21 09:33:46.13 kernel        R10 : 0x0000000000000001R11 : 0x00007fbae25f78b0
00:0048:00000:00000:2019/02/21 09:33:46.13 kernel        R12 : (nil)R13 : 0x000000000000059c
00:0048:00000:00000:2019/02/21 09:33:46.13 kernel        R14 : 0x0000000144912f40R15 : 0x000000016726c040
00:0048:00000:00000:2019/02/21 09:33:46.13 kernel        RDI : 0x000000016700e800RSI : 0x0000000000000005
00:0048:00000:00000:2019/02/21 09:33:46.13 kernel        RIP : 0x000000000160682aCSGSFS : 0x0000000000000033
00:0048:00000:00000:2019/02/21 09:33:46.13 kernel        TRAPNO : 0x000000000000000eERR : 0x0000000000000006
00:0048:00000:00000:2019/02/21 09:33:46.13 kernel        EFL : 0x0000000000010246
00:0048:00000:00000:2019/02/21 09:33:46.13 kernel**** end of signal context ****
00:0048:00000:00000:2019/02/21 09:33:46.16 kernelRun to completion task iocRunController(45170bf0) exception 11
00:0048:00000:00000:2019/02/21 09:33:46.17 kernelpc: 0x00000000015911e0 nthrd_backtrace+0x3b()
00:0048:00000:00000:2019/02/21 09:33:46.17 kernelpc: 0x00000000015ca426 krtctskException+0x7f()
00:0048:00000:00000:2019/02/21 09:33:46.17 kernelpc: 0x00000000015e07cb kisignal+0x4d2()
00:0048:00000:00000:2019/02/21 09:33:46.17 kernelpc: 0x000000000160682a kstcpnetctlrCancelRequests+0x97()
00:0048:00000:00000:2019/02/21 09:33:46.21 kernelpc: 0x000000000160e188 ksepollnetctlrWaitForCompletion+0x2d3()
00:0048:00000:00000:2019/02/21 09:33:46.21 kernelpc: 0x000000000158b164 iocRunController+0xb1()
00:0048:00000:00000:2019/02/21 09:33:46.21 kernelpc: 0x00000000015ca2eb krtctskRun+0x6b()
00:0048:00000:00000:2019/02/21 09:33:46.21 kernelpc: 0x00000000015ccfa9 ktskRun+0x79()
00:0048:00000:00000:2019/02/21 09:33:46.21 kernelpc: 0x000000000161231f kt__RTCMain+0xd4()
00:0026:00000:00052:2019/02/21 09:50:39.29 serverAdaptive Server Enterprise User Connection Report.
00:0026:00000:00052:2019/02/21 09:50:39.29 serverMaximum number of User Accounts during current sample period: 5.
00:0026:00000:00052:2019/02/21 09:50:39.29 serverMaximum number of User Accounts since startup: 5.
00:0026:00000:00052:2019/02/21 09:50:39.29 serverMaximum Configured Number of User Connections during current sample period: 1500.
00:0026:00000:00052:2019/02/21 09:50:39.29 serverMaximum Configured Number of User Connections since startup: 1500.
00:0026:00000:00052:2019/02/21 09:50:39.29 serverMaximum Number of User Connections during current sample period: 294.
00:0026:00000:00052:2019/02/21 09:50:39.29 serverMaximum Number of User Connections since startup: 308.
00:0026:00000:00052:2019/02/21 09:50:39.29 serverMaximum number of user seat licenses used during current sample period: 11.
00:0026:00000:00052:2019/02/21 09:50:39.29 serverMaximum number of user seat licenses used since startup: 12.
00:0047:00000:00011:2019/02/21 09:51:36.06 kernelBegin processing to generate RSA keypair.
00:0047:00000:00011:2019/02/21 09:51:36.17 kernelCompleted processing to generate RSA keypair.
00:0047:00000:00011:2019/02/21 09:51:36.17 kernelBegin processing to generate RSA keypair.
00:0047:00000:00011:2019/02/21 09:51:36.23 kernelCompleted processing to generate RSA keypair.


数据库版本:
Adaptive Server Enterprise/15.7/EBF 21776 SMP SP103 /P/x86_64/Enterprise Linux/ase157sp101/3449/64-bit/FBO/Thu Sep 19 06:21:33 2013

跪求大神指点

Eisen 发表于 2019-02-25 17:22

嗯。Linux或hpux上使用threaded mode的话,有可能碰上这个bug--CR743055
升级到 ASE16.0可以修复这个bug
页: [1]
查看完整版本: 救急,sybase数据库宕机