急！！SYBASE宕机造成口令丢失！

jys1059

我的服务器早上不知道什么原因自己就停了，由于是双机热备，另一台机器自动接管了，但是其中一个SYBASE的帐号口令变了，下面是错误日志。
服务器版本：SCO UNIX 5.0.6
SYBASE版本：11.0.9。
请大虾们指教！
00:05/12/18 10:16:18.57 kernel  sddone: write error on virtual disk 0 block 308:
00:05/12/18 10:16:18.60 kernel  sddone: I/O error
00:05/12/18 10:16:18.61 server  Error: 823, Severity: 24, State: 2
00:05/12/18 10:16:18.61 server  I/O error detected during wait for BUF pointer = '0x5e18ce60', MASS pointer = '0x5e18ce60', (Buf#: '0'), page ptr = '0xbfde9000', dbid = '1', Mass virtpage = '308', Buffer page = '304', Mass status = '0x6891110', Buffer status = '0x1', size = '2048', cache (id: 0) = 'default data cache'.
00:05/12/18 10:16:18.61 kernel  curdb = 1 pstat = 0x0 lasterror = 823
00:05/12/18 10:16:18.61 kernel  preverror = 0 transtate = 1
00:05/12/18 10:16:18.62 kernel  curcmd = 0 program =                              
00:05/12/18 10:16:18.66 kernel  pc: 0x2e4b85 ucbacktrace+0x55(0x0,0x1,0x8005e540,0x2,0x17)
00:05/12/18 10:16:18.67 kernel  pc: 0x27bf terminate_process+0x33f(0x0,0xffffffff,0x8005e50c,0xf0c93,0x80d6a9d4)
00:05/12/18 10:16:18.67 kernel  pc: 0xf0d60 close_network+0x10(0x80d6a9d4,0x80d68260,0x8005e5bc,0xf0c2c,0x
00:05/12/18 10:16:18.67 kernel  pc: 0xf0c93 hdl_default+0x23(0x8,0x17,0x18,0x2,0x8005e540)
00:05/12/18 10:16:18.67 kernel  pc: 0xf0c2c ex_raise+0x21c(0x8,0x17,0x18,0x2,0x32d3)
00:05/12/18 10:16:18.67 kernel  pc: 0x2ebc4 buf__writewait___1+0x220(0x5e18ce60,0x81f11dfa,0x2,0xffffffff,0x80d68260)
00:05/12/18 10:16:18.67 kernel  pc: 0x436c9 hk__bufwritewait+0x179(0x81da7010,0x8000cf80,0x0,0x0,0x81da866c)
00:05/12/18 10:16:18.67 kernel  pc: 0x42500 hk__cycle_chores+0x120(0x80d68260,0x0,0x0,0x0,0x0)
00:05/12/18 10:16:18.67 kernel  pc: 0x420e5 hk__chores+0x2d5(0x0,0x0,0x8005e6d8,0x2f8e30,0x0)
00:05/12/18 10:16:18.67 kernel  pc: 0x41deb housekeeper+0x6b(0x0,0x8005e6e0,0x6a006a,0x0,0x0)
00:05/12/18 10:16:18.67 kernel  pc: 0x2f8e30 kpexit(0x0,0x0,0x5374616b,0x0,0x0)
00:05/12/18 10:16:18.67 kernel  pc: 0x6a006a frexp+0x346236(0x5374616b,0x0,0x0,0x0,0x0)
00:05/12/18 10:16:18.67 kernel  end of stack trace, spid 5, kpid 524296, suid 0
00:05/12/18 10:17:10.84 kernel  timeslice -501, current process infected
00:05/12/18 10:17:10.84 kernel  ************************************
00:05/12/18 10:17:10.84 kernel  SQL causing error :
00:05/12/18 10:17:10.84 kernel  curdb = 1 pstat = 0x10000 lasterror = 0
00:05/12/18 10:17:10.84 kernel  preverror = 0 transtate = 1
00:05/12/18 10:17:10.84 kernel  curcmd = 0 program =
00:05/12/18 10:17:10.84 kernel  pc: 0x2e4b85 ucbacktrace+0x55(0x0,0x1,0x0,0x8025bd3c,0x80d6832c)
00:05/12/18 10:17:10.84 kernel  pc: 0x27bf terminate_process+0x33f(0x0,0xffffffff,0x130,0x0,0x8025c02c)
00:05/12/18 10:17:10.84 kernel  pc: 0x2e012e kaclkintr+0x20e(0xe,0x0,0x8025bd34,0x0,0x0)
00:05/12/18 10:17:10.84 kernel  pc: 0x351a7c sigismember+0x64(0x80d6832c,0x80d6832c,0x80d6832c,0x0,0xbfded000)
00:05/12/18 10:17:10.84 kernel  pc: 0x1c8aa6 getpage___1+0x132(0x80d6832c,0x4bd,0x80d6832c,0x80d6832c,0xbfded000)
00:05/12/18 10:17:10.84 kernel  pc: 0x1caa4d getrow+0x1d(0x80d6832c,0x0,0x8025c344,0x1,0x8025c344)
00:05/12/18 10:17:10.84 kernel  pc: 0x1c6b5d getnext+0xdbd(0x80d6832c,0x13,0x10,0x15,0x2)
00:05/12/18 10:17:10.84 kernel  [Handler pc: 0xf0c50 hdl_backout(num=1204, sev=17) installed by the following function]
00:05/12/18 10:17:10.84 kernel  pc: 0x21826c login+0xb9c(0x0,0x0,0x0,0x0,0x80d68260)
00:05/12/18 10:17:10.84 kernel  [Handler pc: 0xf0c50 hdl_backout(num=3600, sev=25) installed by the following function]
00:05/12/18 10:17:10.84 kernel  [Handler pc: 0x173a30 ut_handle(num=700, sev=0) installed by the following function]
00:05/12/18 10:17:10.84 kernel  pc: 0x20a1fa conn_hdlr+0x50a(0x29,0x8025c6e0,0x6a006a,0x0,0x0)
00:05/12/18 10:17:10.84 kernel  pc: 0x2f8e30 kpexit(0x0,0x0,0x5374616b,0x0,0x0)
00:05/12/18 10:17:10.84 kernel  pc: 0x6a006a frexp+0x346236(0x5374616b,0x0,0x0,0x0,0x0)
00:05/12/18 10:17:10.84 kernel  end of stack trace, spid 5, kpid 200605755, suid 0
00:05/12/18 10:18:02.46 kernel  timeslice -501, current process infected
00:05/12/18 10:18:02.46 kernel  ************************************
00:05/12/18 10:18:02.46 kernel  pc: 0x2e4b85 ucbacktrace+0x55(0x0,0x1,0x0,0x8025b65c,0x80d684d
00:05/12/18 10:18:02.46 kernel  pc: 0x2bf2 terminate_process+0x772(0x0,0xffffffff,0x5e1bd400,0x8000cf80,0x8025b94c)
00:05/12/18 10:18:02.46 kernel  pc: 0x2e012e kaclkintr+0x20e(0xe,0x0,0x8025b654,0x0,0x0)
00:05/12/18 10:18:02.46 kernel  pc: 0x351a7c sigismember+0x64(0x5e18ce60,0x80d684d8,0x80d684d8,0x2,0x6)
00:05/12/18 10:18:02.46 kernel  pc: 0x1c8b2d getpage___1+0x1b9(0x80d684d8,0x80d68538,0x80d684d8,0x80d68260,0x8025bc1c)
00:05/12/18 10:18:02.46 kernel  pc: 0x1dacd4 startscan+0x564(0x80d684d8,0x0,0x2,0x3,0x80d68260)
00:05/12/18 10:18:02.46 kernel  pc: 0x2090cd acct_stats+0xed(0x80d68260,0x20da50,0x5,0x10000,0x80d68260)
00:05/12/18 10:18:02.46 kernel  [Handler pc: 0x20da50 cleanerr(num=0, sev=0) installed by the following function]
00:05/12/18 10:18:02.46 kernel  [Handler pc: 0xf0c50 hdl_backout(num=0, sev=0) installed by the following function]
00:05/12/18 10:18:02.46 kernel  pc: 0x20d279 kill_proc+0x279(0x80d68260,0x2a0e,0x0,0x8025bd3c,0x80d6832c)
00:05/12/18 10:18:02.46 kernel  pc: 0x2a63 terminate_process+0x5e3(0x0,0xffffffff,0x130,0x0,0x8025c02c)
00:05/12/18 10:18:02.46 kernel  pc: 0x2e012e kaclkintr+0x20e(0xe,0x0,0x8025bd34,0x0,0x0)
00:05/12/18 10:18:02.46 kernel  pc: 0x351a7c sigismember+0x64(0x80d6832c,0x80d6832c,0x80d6832c,0x0,0xbfded000)
00:05/12/18 10:18:02.46 kernel  pc: 0x1c8aa6 getpage___1+0x132(0x80d6832c,0x4bd,0x80d6832c,0x80d6832c,0xbfded000)
00:05/12/18 10:18:02.46 kernel  pc: 0x1caa4d getrow+0x1d(0x80d6832c,0x0,0x8025c344,0x1,0x8025c344)
00:05/12/18 10:18:02.46 kernel  pc: 0x1c6b5d getnext+0xdbd(0x80d6832c,0x13,0x10,0x15,0x2)
00:05/12/18 10:18:02.46 kernel  [Handler pc: 0xf0c50 hdl_backout(num=1204, sev=17) installed by the following function]
00:05/12/18 10:18:02.46 kernel  pc: 0x21826c login+0xb9c(0x0,0x0,0x0,0x0,0x80d68260)
00:05/12/18 10:18:02.46 kernel  [Handler pc: 0xf0c50 hdl_backout(num=3600, sev=25) installed by the following function]
00:05/12/18 10:18:02.46 kernel  [Handler pc: 0x173a30 ut_handle(num=700, sev=0) installed by the following function]
00:05/12/18 10:18:02.46 kernel  pc: 0x20a1fa conn_hdlr+0x50a(0x29,0x8025c6e0,0x6a006a,0x0,0x0)
00:05/12/18 10:18:02.46 kernel  pc: 0x2f8e30 kpexit(0x0,0x0,0x5374616b,0x0,0x0)
00:05/12/18 10:18:02.46 kernel  pc: 0x6a006a frexp+0x346236(0x5374616b,0x0,0x0,0x0,0x0)
00:05/12/18 10:18:02.46 kernel  end of stack trace, spid 5, kpid 200605755, suid 0
00:05/12/18 10:18:54.46 kernel  timeslice -501, current process infected
00:05/12/18 10:18:54.46 kernel  ************************************
00:05/12/18 10:18:54.46 kernel  SQL causing error :
00:05/12/18 10:18:54.46 kernel  curdb = 1 pstat = 0x10000 lasterror = 0
00:05/12/18 10:18:54.46 kernel  preverror = 0 transtate = 1
00:05/12/18 10:18:54.46 kernel  curcmd = 193 program =
00:05/12/18 10:18:54.46 kernel  Spinlocks held by  kpid 200671439

00:05/12/18 10:18:54.46 kernel  Spinlock Resource->rcaches[i]->cspin at address 8000cf80 owned by bf600cf
00:05/12/18 10:18:54.46 kernel  End of spinlock display.
00:05/12/18 10:18:54.46 kernel  pc: 0x2e4b85 ucbacktrace+0x55(0x0,0x1,0x0,0x80823cec,0x5e18ce60)
00:05/12/18 10:18:54.46 kernel  pc: 0x26d0 terminate_process+0x250(0x0,0xffffffff,0x1,0x0,0x80823f9c)
00:05/12/18 10:18:54.46 kernel  pc: 0x2e012e kaclkintr+0x20e(0xe,0x0,0x80823ce4,0x0,0x0)
00:05/12/18 10:18:54.46 kernel  pc: 0x351a7c sigismember+0x64(0x81da8e10,0x130,0x1,0x0,0x5e18ce60)
00:05/12/18 10:18:54.46 kernel  pc: 0x2f01a bufsearch___1+0x236(0x80df8610,0x80df8610,0x80df8610,0x0,0xbfded000)
00:05/12/18 10:18:54.46 kernel  pc: 0x1c8aa6 getpage___1+0x132(0x80df8610,0x4bd,0x80df8610,0x80df8610,0xbfded000)
00:05/12/18 10:18:54.46 kernel  pc: 0x1caa4d getrow+0x1d(0x80df8610,0x0,0x80824344,0x1,0x80824344)
00:05/12/18 10:18:54.46 kernel  pc: 0x1c6b5d getnext+0xdbd(0x80df8610,0x13,0x10,0x15,0x2)
00:05/12/18 10:18:54.46 kernel  [Handler pc: 0xf0c50 hdl_backout(num=1204, sev=17) installed by the following function]
00:05/12/18 10:18:54.46 kernel  pc: 0x21826c login+0xb9c(0x0,0x0,0x0,0x0,0x80df8544)
00:05/12/18 10:18:54.46 kernel  [Handler pc: 0xf0c50 hdl_backout(num=3600, sev=25) installed by the following function]
00:05/12/18 10:18:54.46 kernel  [Handler pc: 0x173a30 ut_handle(num=700, sev=0) installed by the following function]
00:05/12/18 10:18:54.46 kernel  pc: 0x20a1fa conn_hdlr+0x50a(0x45,0x808246e0,0x6a006a,0x0,0x0)
00:05/12/18 10:18:54.46 kernel  pc: 0x2f8e30 kpexit(0x0,0x0,0x5374616b,0x0,0x0)
00:05/12/18 10:18:54.46 kernel  pc: 0x6a006a frexp+0x346236(0x5374616b,0x0,0x0,0x0,0x0)
00:05/12/18 10:18:54.46 kernel  end of stack trace, spid 46, kpid 200671439, suid 0
00:05/12/18 10:18:54.46 kernel  ueshutdown: exiting

hobbylu

有一个磁盘可能有硬件问题

chuxu

master库也在双机共享的存储设备上吗？

jys1059

是的，master和生产数据库都在双机共享的磁盘阵列柜上。如果磁盘有硬件问题，是否可以看出是哪块有问题，阵列柜指示灯没有显示硬盘有问题。

RS9000

disk 0 block 308
磁盘应该有坏块了
timeslice -501
我记得好像是补丁的问题