免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 3362 | 回复: 1

sybase报错求助 [复制链接]

论坛徽章:
0
发表于 2015-04-29 17:25 |显示全部楼层
数据库经常报下面这个错误,是什么原因?
每次都是把表DROP掉之后,重新建表,风险实在太大。
求高人解答!!!

00:00000:00040:2015/04/27 20:25:03.43 server  WARNING: ***************************
00:00000:00069:2015/04/28 15:48:35.45 server  Starting diagnostics for read failure:
00:00000:00069:2015/04/28 15:48:35.45 server  Device Information:
                                 Device number = 7
                                 Phyname = /home/sybase/data/opdbdev1.dat
00:00000:00069:2015/04/28 15:48:35.45 server  Buffer Information:
                                 Buf addr = 0x0xb6eb6b50, Mass addr = 0x0xb6eb6b50
                                 Buf pageno = 185358, Mass pageno = 185358, dbid = 6
00:00000:00069:2015/04/28 15:48:35.47 server  
                                 Buf virtpg = 118181944, Mass virtpg = 118181944
                                 Buf stat = 0x1, Mass stat = 0x1008
                                 Mass keep = 1, Mass awaited = 0
00:00000:00069:2015/04/28 15:48:35.47 server  Page Information from first read attempt: Page read from cache ppageno = 960648, pobjid = 219144795, pindid = 2 pnextpg = 960696, pprevpg = 957326 plevel = 0, pstat = 0x82 pts_hi = 0, pts_lo = 129649782
00:00000:00069:2015/04/28 15:48:35.47 server  Page Information from second read attempt: Page read from disk ppageno = 960648, pobjid = 219144795, pindid = 2 pnextpg = 960696, pprevpg = 957326 plevel = 0, pstat = 0x82 pts_hi = 0, pts_lo = 129649782
00:00000:00069:2015/04/28 15:48:35.47 server  SDES Information:
                                 dbid = 6, objid = 2091151464, scur.pageid = 185358
                                 sstat = 0x2002040, sstat2 = 0x20020
                                 suid = 3, cacheid = 0
00:00000:00069:2015/04/28 15:48:35.47 server  PSS Information:
                                 pstat = 0x10000, pcurdb = 6, pspid = 69
                                 p2stat = 0x1000, p3stat = 0x81a
                                 plasterror = 0, preverror = 0, pattention = 0
00:00000:00069:2015/04/28 15:48:35.49 server  End diagnostics for read failure:
00:00000:00069:2015/04/28 15:48:35.49 server  Error: 697, Severity: 21, State: 7
00:00000:00069:2015/04/28 15:48:35.49 server  An attempt was made to fetch logical page '185358' for object '2091151464' in database '6' from cache 'default data cache'. Wrong logical page '960648' was found in cache.

论坛徽章:
6
水瓶座
日期:2014-06-04 03:34:37水瓶座
日期:2014-06-17 13:20:31数据库技术版块每日发帖之星
日期:2016-07-09 06:20:00数据库技术版块每日发帖之星
日期:2016-07-17 06:20:00数据库技术版块每日发帖之星
日期:2016-08-01 06:20:00数据库技术版块每日发帖之星
日期:2016-08-04 06:20:00
发表于 2015-04-30 15:14 |显示全部楼层
检查存储方面的,换个磁盘呢。
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP