- 论坛徽章:
- 0
|
本帖最后由 logit99 于 2010-08-01 21:16 编辑
用户库正常了几天,又有新问题了。dboption里已经设的是tran log on chkpoint,现在发现它没有自动清除日志,手工执行dump tran user_database with truncate_only,报错:
00:00000:00060:2010/08/01 20:26:07.84 server Error: 691, Severity: 20, State: 1
00:00000:00060:2010/08/01 20:26:07.84 server Encountered invalid logical page '
0' while accessing object '8' in database '4'. This is an internal system error.
Please contact Sybase Technical Support.
00:00000:00060:2010/08/01 20:26:07.84 kernel current process (0x2ef009c) infect
ed with 11
00:00000:00060:2010/08/01 20:26:07.84 kernel **********************************
**
00:00000:00060:2010/08/01 20:26:07.84 kernel SQL causing error : dump tran rspo
s with truncate_only
00:00000:00060:2010/08/01 20:26:07.84 kernel **********************************
**
00:00000:00060:2010/08/01 20:26:07.84 server SQL Text: dump tran rspos with tru
ncate_only
00:00000:00060:2010/08/01 20:26:07.84 kernel curdb = 1 pstat = 0x10000 lasterro
r = 691
00:00000:00060:2010/08/01 20:26:07.84 kernel preverror = 0 transtate = 3
00:00000:00060:2010/08/01 20:26:07.84 kernel curcmd = 235 program = ctisql
查下来object 8 是syslog,我rebuild—log也做过,无效,现在是tran log on chkpoint的勾打不上去,手工dump tran user_database with truncate_only又报错,请问会是什么原因?
现在系统能用,但日志天天增长,撑不了几天就会满。 |
|