请教一个问题，在sybase日志中！！

njnu

00:00000:00000:2007/05/30 13:47:32.84 kernel  sddone: write error on virtual disk 3 block 3972:
00:00000:00000:2007/05/30 13:47:32.84 kernel  sddone: I/O error
00:00000:00000:2007/05/30 13:47:47.55 kernel  sddone: write error on virtual disk 3 block 3973:
00:00000:00000:2007/05/30 13:47:47.55 kernel  sddone: I/O error
00:00000:00007:2007/05/30 13:47:47.70 server  bufwritedes: write error detected - spid=7, ppage=5509, bvirtpg=50335621, dbid=2
00:00000:00007:2007/05/30 13:47:47.71 server  Checkpoint process detected hardware error writing logical page '5509', virtual page '50335621' for dbid '2', cache 'default data cache'. It will sleep until write completes successfully.
00:00000:00000:2007/05/30 13:48:01.83 kernel  sddone: write error on virtual disk 3 block 3975:
00:00000:00000:2007/05/30 13:48:01.83 kernel  sddone: I/O error
00:00000:00016:2007/05/30 13:48:01.91 server  bufwritedes: write error detected - spid=16, ppage=5511, bvirtpg=50335623, dbid=2
00:00000:00000:2007/05/30 13:48:16.63 kernel  sddone: write error on virtual disk 3 block 3980:
00:00000:00000:2007/05/30 13:48:16.63 kernel  sddone: I/O error
00:00000:00007:2007/05/30 13:48:16.76 server  bufwritedes: write error detected - spid=7, ppage=5516, bvirtpg=50335628, dbid=2
00:00000:00007:2007/05/30 13:48:16.76 server  Checkpoint process detected hardware error writing logical page '5516', virtual page '50335628' for dbid '2', cache 'default data cache'. It will sleep until write completes successfully.
00:00000:00000:2007/05/30 13:48:31.25 kernel  sddone: write error on virtual disk 3 block 3992:
00:00000:00000:2007/05/30 13:48:31.25 kernel  sddone: I/O error
00:00000:00000:2007/05/30 13:48:46.21 kernel  sddone: write error on virtual disk 3 block 3993:
00:00000:00000:2007/05/30 13:48:46.21 kernel  sddone: I/O error
00:00000:00000:2007/05/30 13:49:00.44 kernel  sddone: write error on virtual disk 3 block 3995:
00:00000:00000:2007/05/30 13:49:00.44 kernel  sddone: I/O error
00:00000:00016:2007/05/30 13:49:00.98 server  bufwritedes: write error detected - spid=16, ppage=5531, bvirtpg=50335643, dbid=2
00:00000:00000:2007/05/30 13:49:15.56 kernel  sddone: write error on virtual disk 3 block 4009:
00:00000:00000:2007/05/30 13:49:15.56 kernel  sddone: I/O error
00:00000:00007:2007/05/30 13:49:15.74 server  bufwritedes: write error detected - spid=7, ppage=5545, bvirtpg=50335657, dbid=2
00:00000:00007:2007/05/30 13:49:15.74 server  Checkpoint process detected hardware error writing logical page '5545', virtual page '50335657' for dbid '2', cache 'default data cache'. It will sleep until write completes successfully.
00:00000:00000:2007/05/30 13:49:30.21 kernel  sddone: write error on virtual disk 3 block 4009:
00:00000:00000:2007/05/30 13:49:30.21 kernel  sddone: I/O error
00:00000:00000:2007/05/30 13:49:45.20 kernel  sddone: write error on virtual disk 3 block 4011:
00:00000:00000:2007/05/30 13:49:45.20 kernel  sddone: I/O error
00:00000:00000:2007/05/30 13:50:00.20 kernel  sddone: write error on virtual disk 3 block 4016:
00:00000:00000:2007/05/30 13:50:00.20 kernel  sddone: I/O error
00:00000:00016:2007/05/30 13:50:00.44 server  bufwritedes: write error detected - spid=16, ppage=5552, bvirtpg=50335664, dbid=2
00:00000:00000:2007/05/30 13:50:15.24 kernel  sddone: write error on virtual disk 3 block 4025:
00:00000:00000:2007/05/30 13:50:15.24 kernel  sddone: I/O error
00:00000:00007:2007/05/30 13:50:15.62 server  bufwritedes: write error detected - spid=7, ppage=5561, bvirtpg=50335673, dbid=2
00:00000:00007:2007/05/30 13:50:15.62 server  Checkpoint process detected hardware error writing logical page '5561', virtual page '50335673' for dbid '2', cache 'default data cache'. It will sleep until write completes successfully.
00:00000:00000:2007/05/30 13:50:29.99 kernel  sddone: write error on virtual disk 3 block 4025:
00:00000:00000:2007/05/30 13:50:29.99 kernel  sddone: I/O error
00:00000:00000:2007/05/30 13:50:45.03 kernel  sddone: write error on virtual disk 3 block 4027:
00:00000:00000:2007/05/30 13:50:45.03 kernel  sddone: I/O error
00:00000:00016:2007/05/30 13:50:45.26 server  bufwritedes: write error detected - spid=16, ppage=5563, bvirtpg=50335675, dbid=2
00:00000:00000:2007/05/30 13:50:59.48 kernel  sddone: write error on virtual disk 3 block 4027:
00:00000:00000:2007/05/30 13:50:59.48 kernel  sddone: I/O error
00:00000:00000:2007/05/30 13:51:14.31 kernel  sddone: write error on virtual disk 3 block 4024:
00:00000:00000:2007/05/30 13:51:14.31 kernel  sddone: I/O error
00:00000:00000:2007/05/30 13:51:28.87 kernel  sddone: write error on virtual disk 3 block 4026:
00:00000:00000:2007/05/30 13:51:28.87 kernel  sddone: I/O error
00:00000:00021:2007/05/30 13:51:38.60 server  bufwritedes: write error detected - spid=21, ppage=5563, bvirtpg=50335675, dbid=2
00:00000:00000:2007/05/30 13:51:43.70 kernel  sddone: write error on virtual disk 3 block 4025:
00:00000:00000:2007/05/30 13:51:43.70 kernel  sddone: I/O error
00:00000:00000:2007/05/30 13:51:58.10 kernel  sddone: write error on virtual disk 3 block 4024:
00:00000:00000:2007/05/30 13:51:58.10 kernel  sddone: I/O error
00:00000:00000:2007/05/30 13:52:13.19 kernel  sddone: write error on virtual disk 3 block 4026:
00:00000:00000:2007/05/30 13:52:13.19 kernel  sddone: I/O error
00:00000:00000:2007/05/30 13:52:27.80 kernel  sddone: write error on virtual disk 3 block 4027:
00:00000:00000:2007/05/30 13:52:27.80 kernel  sddone: I/O error
00:00000:00008:2007/05/30 13:52:32.02 server  bufwritedes: write error detected - spid=8, ppage=5560, bvirtpg=50335672, dbid=2
00:00000:00008:2007/05/30 13:52:32.02 server  Checkpoint process detected hardware error writing logical page '5560', virtual page '50335672' for dbid '2', cache 'default data cache'. It will sleep until write completes successfully.
00:00000:00000:2007/05/30 13:52:46.75 kernel  sddone: write error on virtual disk 3 block 4024:
00:00000:00000:2007/05/30 13:52:46.75 kernel  sddone: I/O error
00:00000:00024:2007/05/30 14:07:57.28 server  bufwritedes: write error detected - spid=24, ppage=5563, bvirtpg=50335675, dbid=2
00:00000:00024:2007/05/30 14:07:57.28 server  Hardware error detected writing logical page '5563', virtual page '50335675' for dbid '2', cache 'default data cache'. The user process will sleep until write completes successfully.
00:00000:00024:2007/05/30 14:07:57.28 kernel  current process (0x1f001f) infected with 11
00:00000:00024:2007/05/30 14:07:58.17 kernel  Address 0x0000000080142038 (usseom+0x7c), siginfo (code, address) = (1, 0x000000000000004
00:00000:00024:2007/05/30 14:07:58.17 kernel  ************************************
00:00000:00024:2007/05/30 14:08:02.65 kernel  pc: 0x00000000806bebe8 pcstkwalk+0x28(0x0000000200734f18, 0x0000000200734690, 0x000000000000270f, 0x0000000000000002, 0xfffffffffffffff
00:00000:00024:2007/05/30 14:08:02.65 kernel  pc: 0x00000000806bead0 ucstkgentrace+0x1c8(0x000000000000270f, 0x00000000001f001f, 0x0000000000000000, 0x0000000202f0ba40, 0x0000000201d9b0d0)
00:00000:00024:2007/05/30 14:08:03.32 kernel  pc: 0x0000000080685518 ucbacktrace+0xac(0x0000000000000000, 0x0000000000000001, 0x000000000002e400, 0x0000000200735a60, 0x000000000000007c)
00:00000:00024:2007/05/30 14:08:03.32 kernel  pc: 0x00000000801c9d48 terminate_process+0x760(0x0000000201d9b0d0, 0xffffffffffffffff, 0x0000000000000000, 0x0000000000000000, 0x0000000000000001)
00:00000:00024:2007/05/30 14:08:03.32 kernel  pc: 0x000000008069c150 kisignal+0x140(0x000000000000000b, 0x0000000200735d30, 0x0000000200735a50, 0x0000000000000000, 0x0000000000000000)
00:00000:00024:2007/05/30 14:08:03.32 kernel  pc: 0xffffffff7f018394 _setitimer+0xb4(0x000000000000000b, 0x0000000200735d30, 0x0000000200735a50, 0x000000008069c010, 0x0000000000000000)
00:00000:00024:2007/05/30 14:08:03.32 kernel  pc: 0xffffffff7f011edc sema_post+0x530(0x000000000000000b, 0xffffffff7da00000, 0x0000000000000001, 0xffffffff7f11ca80, 0xffffffff7f11c920)
00:00000:00024:2007/05/30 14:08:03.95 kernel  [Handler pc: 0x00000000803e4f20 trunctaberr installed by the following function:-]
00:00000:00024:2007/05/30 14:08:03.95 kernel  pc: 0xffffffff7f0120c8 sema_post+0x71c(0xffffffff7da00000, 0x0000000200735a50, 0xffffffff7f11a000, 0x0000000200735d30, 0x0000000200735d30)
00:00000:00024:2007/05/30 14:08:03.95 kernel  pc: 0x00000000803e4150 trunctab+0x824(0x0000000201daeee0, 0x0000000201d9b0d0, 0x0000000000000003, 0x00000000000015bb, 0x0000000003000fbb)
00:00000:00024:2007/05/30 14:08:04.59 kernel  pc: 0x0000000080128518 cm_writedes+0xc2c(0x000000000000000a, 0x000000000000000a, 0x000000000000000a, 0x0000000201d9b0d0, 0x0000000000000000)
00:00000:00024:2007/05/30 14:08:04.59 kernel  pc: 0x0000000080155384 bufwritedes_log+0x44(0x00000002019aa8e0, 0x000000000002047d, 0x0000000000000001, 0x0000000000000000, 0x0000000201d9b0d0)
00:00000:00024:2007/05/30 14:08:04.59 kernel  pc: 0x0000000080147684 xls_flush+0x38(0x00000002031451b0, 0x0000000000020000, 0x0000000000000000, 0x0000000000030000, 0x00000000013f04b0)
00:00000:00024:2007/05/30 14:08:04.59 kernel  pc: 0x0000000080141c30 finishlog+0x170(0x0000000080b88000, 0x0000000000000002, 0x000000008108c800, 0x0000000000000004, 0x000000008108ec00)
00:00000:00024:2007/05/30 14:08:04.59 kernel  pc: 0x000000008013c6cc xact__endxact+0x80(0x00000002031451b0, 0x000000000000002b, 0x0000000000000000, 0x0000000000000004, 0x000000020073674c)
00:00000:00024:2007/05/30 14:08:04.59 kernel  end of stack trace, spid 24, kpid 2031647, suid 11
00:00000:00000:2007/05/30 14:08:11.92 kernel  sddone: write error on virtual disk 3 block 4024:
00:00000:00000:2007/05/30 14:08:11.92 kernel  sddone: I/O error
00:00000:00000:2007/05/30 14:08:27.44 kernel  sddone: write error on virtual disk 3 block 4025:
00:00000:00000:2007/05/30 14:08:27.44 kernel  sddone: I/O error
00:00000:00000:2007/05/30 14:08:42.44 kernel  sddone: write error on virtual disk 3 block 4026:
00:00000:00000:2007/05/30 14:08:42.44 kernel  sddone: I/O error
00:00000:00000:2007/05/30 14:08:56.41 kernel  sddone: write error on virtual disk 3 block 4027:
00:00000:00000:2007/05/30 14:08:56.41 kernel  sddone: I/O error
00:00000:00023:2007/05/30 14:08:56.95 server  bufwritedes: write error detected - spid=23, ppage=5563, bvirtpg=50335675, dbid=2
00:00000:00023:2007/05/30 14:08:56.95 server  Hardware error detected writing logical page '5563', virtual page '50335675' for dbid '2', cache 'default data cache'. The user process will sleep until write completes successfully.
00:00000:00023:2007/05/30 14:08:56.95 kernel  current process (0x1e001e) infected with 11
00:00000:00023:2007/05/30 14:08:56.95 kernel  Address 0x0000000080142038 (usseom+0x7c), siginfo (code, address) = (1, 0x000000000000004
00:00000:00023:2007/05/30 14:08:56.95 kernel  ************************************
00:00000:00023:2007/05/30 14:08:56.95 kernel  pc: 0x00000000806bebe8 pcstkwalk+0x28(0x000000020071eef8, 0x000000020071e670, 0x000000000000270f, 0x0000000000000002, 0xfffffffffffffff
00:00000:00023:2007/05/30 14:08:56.95 kernel  pc: 0x00000000806bead0 ucstkgentrace+0x1c8(0x000000000000270f, 0x00000000001e001e, 0x0000000000000000, 0x0000000202f0b4e8, 0x0000000201d86e1
00:00000:00023:2007/05/30 14:08:56.95 kernel  pc: 0x0000000080685518 ucbacktrace+0xac(0x0000000000000000, 0x0000000000000001, 0x000000000002e400, 0x000000020071fa40, 0x000000000000007c)
00:00000:00023:2007/05/30 14:08:56.95 kernel  pc: 0x00000000801c9d48 terminate_process+0x760(0x0000000201d86e18, 0xffffffffffffffff, 0x0000000000000000, 0x0000000000000000, 0x0000000000000001)
00:00000:00023:2007/05/30 14:08:56.95 kernel  pc: 0x000000008069c150 kisignal+0x140(0x000000000000000b, 0x000000020071fd10, 0x000000020071fa30, 0x0000000000000000, 0x0000000000000000)
00:00000:00023:2007/05/30 14:08:56.95 kernel  pc: 0xffffffff7f018394 _setitimer+0xb4(0x000000000000000b, 0x000000020071fd10, 0x000000020071fa30, 0x000000008069c010, 0x0000000000000000)
00:00000:00023:2007/05/30 14:08:56.95 kernel  pc: 0xffffffff7f011edc sema_post+0x530(0x000000000000000b, 0xffffffff7da00000, 0x0000000000000001, 0xffffffff7f11ca80, 0xffffffff7f11c920)
00:00000:00023:2007/05/30 14:08:56.95 kernel  [Handler pc: 0x00000000803e4f20 trunctaberr installed by the following function:-]
00:00000:00023:2007/05/30 14:08:56.95 kernel  pc: 0xffffffff7f0120c8 sema_post+0x71c(0xffffffff7da00000, 0x000000020071fa30, 0xffffffff7f11a000, 0x000000020071fd10, 0x000000020071fd10)
00:00000:00023:2007/05/30 14:08:56.95 kernel  pc: 0x00000000803e4150 trunctab+0x824(0x0000000201d9ac28, 0x0000000201d86e18, 0x0000000000000003, 0x00000000000015bb, 0x0000000003000fbb)
00:00000:00023:2007/05/30 14:08:56.95 kernel  pc: 0x0000000080128518 cm_writedes+0xc2c(0x000000000000000a, 0x000000000000000a, 0x000000000000000a, 0x0000000201d86e18, 0x0000000000000000)
00:00000:00023:2007/05/30 14:08:56.95 kernel  pc: 0x0000000080155384 bufwritedes_log+0x44(0x00000002019aa8e0, 0x0000000000020482, 0x0000000000000001, 0x0000000000000000, 0x0000000201d86e1
00:00000:00023:2007/05/30 14:08:56.95 kernel  pc: 0x0000000080147684 xls_flush+0x38(0x0000000203145530, 0x0000000000020000, 0x0000000000000000, 0x0000000000030000, 0x00000000013efca0)
00:00000:00023:2007/05/30 14:08:56.95 kernel  pc: 0x0000000080141c30 finishlog+0x170(0x0000000080b88000, 0x0000000000000002, 0x000000008108c800, 0x0000000000000004, 0x000000008108ec00)
00:00000:00023:2007/05/30 14:08:56.95 kernel  pc: 0x000000008013c6cc xact__endxact+0x80(0x0000000203145530, 0x000000000000002b, 0x0000000000000000, 0x0000000000000004, 0x000000020072072c)
00:00000:00023:2007/05/30 14:08:56.95 kernel  end of stack trace, spid 23, kpid 1966110, suid 11
00:00000:00000:2007/05/30 14:09:11.68 kernel  sddone: write error on virtual disk 3 block 4024:
00:00000:00000:2007/05/30 14:09:11.68 kernel  sddone: I/O error
00:00000:00000:2007/05/30 14:09:25.91 kernel  sddone: write error on virtual disk 3 block 4026:
00:00000:00000:2007/05/30 14:09:25.91 kernel  sddone: I/O error
00:00000:00000:2007/05/30 14:09:40.47 kernel  sddone: write error on virtual disk 3 block 4027:
00:00000:00000:2007/05/30 14:09:40.47 kernel  sddone: I/O error
00:00000:00000:2007/05/30 14:09:54.79 kernel  sddone: write error on virtual disk 3 block 4025:
00:00000:00000:2007/05/30 14:09:54.80 kernel  sddone: I/O error





在sybase日志有这些记录，是怎么回事呀？同时sybase进程会一直占用大量CPU资源；
重起sybase进程就没有了，但过段时间就又出现！
郁闷！
谢谢大家啦！！

njnu

有没有什么解决办法啊！！

谢谢了呀！！！

chenfeng825

似乎磁盘错误！看看OS！数据库应该遭遇完整性问题了！尝试把table bcp出来比较保险

njnu

能否说清楚点，我是一菜鸟，谢谢了啊！

是不是硬件错误啊！？？？

hobbylu

先检查磁盘有没有问题

njnu

怎么检查？
我fsck -F ufs -y过了，

njnu

造成这个问题最初原因可能是机器非法掉过电，而且不只一次！！！

有可能吗？？？

谢谢大家了！！！

[ 本帖最后由 njnu 于 2007-6-8 16:57 编辑 ]

njnu

希望大家能抽出点宝贵时间给予帮助啦，，谢谢了呀！！！

hobbylu

那些设备是否是裸设备？

njnu

呵呵，什么叫裸设备？

应该不是！