- 论坛徽章:
- 0
|
本帖最后由 YeLLoW 于 2014-01-07 17:40 编辑
在sybase数据库上执行sql语句,然后就hung住了,在log里面看到如下的问题。个人觉得是有block损坏的情况,但是不能确定影响在哪个表上。
哪位同学可以帮忙定位一下问题,并且提供一些解决问题的方法,多谢。
00:00000:00000:2014/01/06 17:06:51.32 kernel sddone: read error on virtual disk 7 block 2794496:
00:00000:00000:2014/01/06 17:06:51.32 kernel sddone: 4096 bytes passed, 0 returned on read for virt disk 7 block 2794496
00:00000:00007:2014/01/06 17:06:51.33 server Error: 1251, Severity: 26, State: 1
00:00000:00007:2014/01/06 17:06:51.33 server An in-use preallocated semaphore cursor was encountered.
00:00000:00007:2014/01/06 17:06:51.33 server Error: 1251, Severity: 26, State: 1
00:00000:00007:2014/01/06 17:06:51.33 server An in-use preallocated semaphore cursor was encountered.
00:00000:00007:2014/01/06 17:06:51.33 server Error: 1251, Severity: 26, State: 1
00:00000:00007:2014/01/06 17:06:51.33 server An in-use preallocated semaphore cursor was encountered.
00:00000:00000:2014/01/06 17:07:51.32 kernel sddone: read error on virtual disk 7 block 2794496:
00:00000:00000:2014/01/06 17:07:51.32 kernel sddone: 4096 bytes passed, 0 returned on read for virt disk 7 block 2794496
00:00000:00007:2014/01/06 17:07:51.34 server Error: 823, Severity: 24, State: 1
00:00000:00007:2014/01/06 17:07:51.34 server I/O error detected during read for BUF=0xfffffd7df6575a18, MASS=0xfffffd7df6575a
18, Buf#=0, page=0xfffffd7bb2f6f000, dbid=4, Mass vdevno=7, vpage=2794496, Buf lpage=50037248, Mass stat=0x4000100, Buf stat=0
x1, size=4096, cid=0 ('default data cache'), Pinned xdes=0x0000000000000000, spid=0.
00:00000:00007:2014/01/06 17:07:51.34 server Error: 1251, Severity: 26, State: 1
00:00000:00007:2014/01/06 17:07:51.34 server An in-use preallocated semaphore cursor was encountered.
00:00000:00007:2014/01/06 17:07:51.34 server Error: 1251, Severity: 26, State: 1
00:00000:00007:2014/01/06 17:07:51.34 server An in-use preallocated semaphore cursor was encountered.
00:00000:00000:2014/01/06 17:08:51.32 kernel sddone: read error on virtual disk 7 block 2794496:
00:00000:00000:2014/01/06 17:08:51.32 kernel sddone: 4096 bytes passed, 0 returned on read for virt disk 7 block 2794496
00:00000:00007:2014/01/06 17:08:51.32 server Error: 823, Severity: 24, State: 1
00:00000:00007:2014/01/06 17:08:51.32 server I/O error detected during read for BUF=0xfffffd7df65755e0, MASS=0xfffffd7df65755
e0, Buf#=0, page=0xfffffd7bb2f6a000, dbid=4, Mass vdevno=7, vpage=2794496, Buf lpage=50037248, Mass stat=0x4000100, Buf stat=0
x1, size=4096, cid=0 ('default data cache'), Pinned xdes=0x0000000000000000, spid=0.
00:00000:00007:2014/01/06 17:08:51.32 server Error: 1251, Severity: 26, State: 1
00:00000:00007:2014/01/06 17:08:51.32 server An in-use preallocated semaphore cursor was encountered.
00:00000:00007:2014/01/06 17:08:51.32 server Error: 1251, Severity: 26, State: 1
00:00000:00007:2014/01/06 17:08:51.32 server An in-use preallocated semaphore cursor was encountered.
00:00000:00000:2014/01/06 17:09:51.31 kernel sddone: read error on virtual disk 7 block 2794496:
00:00000:00000:2014/01/06 17:09:51.31 kernel sddone: 4096 bytes passed, 0 returned on read for virt disk 7 block 2794496
00:00000:00007:2014/01/06 17:09:51.31 server Error: 823, Severity: 24, State: 1
00:00000:00007:2014/01/06 17:09:51.31 server I/O error detected during read for BUF=0xfffffd7df6575508, MASS=0xfffffd7df65755
08, Buf#=0, page=0xfffffd7bb2f69000, dbid=4, Mass vdevno=7, vpage=2794496, Buf lpage=50037248, Mass stat=0x4000100, Buf stat=0
x1, size=4096, cid=0 ('default data cache'), Pinned xdes=0x0000000000000000, spid=0. |
|