SYBASE服务不能启动,急,在线等

REDMOB

SYBASE服务不能启动,急,在线等,SYBASE ASE version 12.5.2,EBF 12060,OS Server 2003,以下是errorlog:
00:00000:00016:2006/01/13 21:35:48.51 server  Completed estimating recovery log boundaries for database 'ShenBao'.
00:00000:00016:2006/01/13 21:35:48.51 server  Started ANALYSIS pass for database 'ShenBao'.
00:00000:00016:2006/01/13 21:35:48.62 server  Completed ANALYSIS pass for database 'ShenBao'.
00:00000:00016:2006/01/13 21:35:48.64 server  Started REDO pass for database 'ShenBao'. The total number of log records to process is 232216.
00:00000:00016:2006/01/13 21:35:48.67 server  Redo pass for database 'ShenBao': 11610 records done (4%); 220606 records left.
00:00000:00016:2006/01/13 21:35:48.70 server  Redo pass for database 'ShenBao': 23220 records done (9%); 208996 records left.
00:00000:00016:2006/01/13 21:35:48.73 server  Redo pass for database 'ShenBao': 34830 records done (14%); 197386 records left.
00:00000:00016:2006/01/13 21:35:48.76 server  Redo pass for database 'ShenBao': 46440 records done (19%); 185776 records left.
00:00000:00016:2006/01/13 21:35:48.78 server  Redo pass for database 'ShenBao': 58050 records done (24%); 174166 records left.
00:00000:00016:2006/01/13 21:35:48.81 server  Redo pass for database 'ShenBao': 69660 records done (29%); 162556 records left.
00:00000:00016:2006/01/13 21:35:48.84 server  Redo pass for database 'ShenBao': 81270 records done (34%); 150946 records left.
00:00000:00016:2006/01/13 21:35:48.87 server  Redo pass for database 'ShenBao': 92880 records done (39%); 139336 records left.
03:00000:00016:2006/01/13 21:35:49.00 server  Redo pass for database 'ShenBao': 104494 records done (44%); 127722 records left.
03:00000:00016:2006/01/13 21:35:49.14 server  Redo pass for database 'ShenBao': 116104 records done (49%); 116112 records left.
03:00000:00016:2006/01/13 21:35:49.28 server  Redo pass for database 'ShenBao': 127714 records done (54%); 104502 records left.
03:00000:00016:2006/01/13 21:35:49.40 server  Redo pass for database 'ShenBao': 139324 records done (59%); 92892 records left.
03:00000:00016:2006/01/13 21:35:49.56 server  Redo pass for database 'ShenBao': 150934 records done (64%); 81282 records left.
03:00000:00016:2006/01/13 21:35:49.75 server  Redo pass for database 'ShenBao': 162544 records done (69%); 69672 records left.
03:00000:00016:2006/01/13 21:35:49.90 server  Redo pass for database 'ShenBao': 174154 records done (74%); 58062 records left.
03:00000:00016:2006/01/13 21:35:50.00 server  Redo pass for database 'ShenBao': 185764 records done (79%); 46452 records left.
03:00000:00016:2006/01/13 21:35:50.12 server  Redo pass for database 'ShenBao': 197374 records done (84%); 34842 records left.
03:00000:00016:2006/01/13 21:35:50.25 server  Redo pass for database 'ShenBao': 208984 records done (89%); 23232 records left.
03:00000:00016:2006/01/13 21:35:50.34 server  Redo pass for database 'ShenBao': 220594 records done (94%); 11622 records left.
00:00000:00001:2006/01/13 21:35:50.40 server  The optimal number of recovery processes is 2.
03:00000:00016:2006/01/13 21:35:50.46 server  Redo pass of recovery has processed 2234 committed and 287 aborted transactions.
03:00000:00016:2006/01/13 21:35:50.46 server  Completed REDO pass for database 'ShenBao'.
03:00000:00016:2006/01/13 21:35:50.46 server  Recovery of database 'ShenBao' will undo incomplete nested top actions.
00:00000:00000:2006/01/13 21:37:30.56 kernel  timeslice -500, current process infected
03:00000:00016:2006/01/13 21:37:30.56 kernel  SQL Server system exception (0xe0000001) generated by a process exceeding its time slice allotment.
03:00000:00016:2006/01/13 21:37:30.67 kernel  pc: 0x7C815DEA kernel32.dll (0xE0000001, 0x00000001, 0x00000000, 0x00000000)
03:00000:00016:2006/01/13 21:37:30.68 kernel  pc: 0x7C815DEA kernel32.dll (0x7C936B24, 0xFFFFFFFF, 0x004011B0, 0x00000000)
03:00000:00016:2006/01/13 21:37:30.68 kernel  pc: 0x00BA8995 AseHTTPURLInputStream::readBytes+ 0x7cd7d (0x004011B0, 0x7439FB70, 0x7439F720, 0x00000000)
03:00000:00016:2006/01/13 21:37:30.68 kernel  pc: 0x7C95ED54 ntdll.dll (0x74391000, 0x7439F734, 0x7439F720, 0x7439F734)
03:00000:00016:2006/01/13 21:37:30.68 kernel  pc: 0x7C9440B3 ntdll.dll (0x0AB56E8C, 0x100386A0, 0x100386A8, 0x100386B0)
03:00000:00016:2006/01/13 21:37:30.68 kernel  [Handler pc: 0x00647672 (Symbol not found) installed by the following function:-]
03:00000:00016:2006/01/13 21:37:30.70 kernel  pc: 0x7C95ECC6 ntdll.dll (0x0AB56E8C, 0x00000001, 0x100386A0, 0x100386A
03:00000:00016:2006/01/13 21:37:30.70 kernel  pc: 0x0063D2C1 (Symbol not found)(0x00000001, 0x047591A0, 0x10038000, 0x1005B834)
03:00000:00016:2006/01/13 21:37:30.70 kernel  [Handler pc: 0x006B7C0A (Symbol not found) installed by the following function:-]
03:00000:00016:2006/01/13 21:37:30.70 kernel  pc: 0x006B6B2E (Symbol not found)(0x00000001, 0x00000000, 0x00000000, 0x00000000)
03:00000:00016:2006/01/13 21:37:30.70 kernel  [Handler pc: 0x006B7C0A (Symbol not found) installed by the following function:-]
03:00000:00016:2006/01/13 21:37:30.70 kernel  pc: 0x006B3679 (Symbol not found)(0x1005B800, 0x004C19C5, 0x00000000, 0x7C951B34)
03:00000:00016:2006/01/13 21:37:30.70 kernel  pc: 0x006B047F (Symbol not found)(0x1005B800, 0x740FFCA0, 0x00000003, 0x00000000)
03:00000:00016:2006/01/13 21:37:30.70 kernel  [Handler pc: 0x006BBB48 (Symbol not found) installed by the following function:-]
03:00000:00016:2006/01/13 21:37:30.70 kernel  pc: 0x006B24AF (Symbol not found)(0x740FFCA0, 0x00000000, 0x00000000, 0x09718CC0)
03:00000:00016:2006/01/13 21:37:30.70 kernel  [Handler pc: 0x006BBB48 (Symbol not found) installed by the following function:-]
03:00000:00016:2006/01/13 21:37:30.70 kernel  pc: 0x006B021A (Symbol not found)(0x09718CC0, 0x00000000, 0x00000000, 0x09718CC0)
03:00000:00016:2006/01/13 21:37:30.70 kernel  pc: 0x00BA88D7 AseHTTPURLInputStream::readBytes+ 0x7ccbf (0x00BA8853, 0x09718CC0, 0x00000008, 0x01000100)
03:00000:00016:2006/01/13 21:37:30.71 kernel  pc: 0x7C826063 kernel32.dll (0x00000000, 0x00000000, 0x00000000, 0x00000000)
03:00000:00016:2006/01/13 21:37:30.71 kernel  end of stack trace, spid 16, kpid 1376277, suid 0
03:00000:00016:2006/01/13 21:37:30.71 kernel  ************************************
03:00000:00016:2006/01/13 21:37:30.71 kernel  curdb = 1 tempdb = 2 pstat = 0x1200
03:00000:00016:2006/01/13 21:37:30.71 kernel  lasterror = 0 preverror = 0 transtate = 1
01:00000:00001:2006/01/13 21:37:30.73 server  Recovery has restored the value of 'local async prefetch limit' for '16K' pool in 'default data cache' from '80' to 'DEFAULT'.
03:00000:00016:2006/01/13 21:37:30.73 kernel  curcmd = 0 program =
01:00000:00001:2006/01/13 21:37:30.73 server  Recovery has restored the value of 'local async prefetch limit' for '2K' pool in 'default data cache' from '80' to 'DEFAULT'.
03:00000:00016:2006/01/13 21:37:30.73 kernel  pc: 0x00C2DBED AseHTTPURLInputStream::readBytes+ 0x101fd5 (0x7439EC6C, 0x7C82B798, 0x7C82BEB8, 0xFFFFFFFF)
03:00000:00016:2006/01/13 21:37:30.73 kernel  pc: 0x00C2DBED AseHTTPURLInputStream::readBytes+ 0x101fd5 (0x7439EC6C, 0x7439EA24, 0x0000270F, 0x00000002)
03:00000:00016:2006/01/13 21:37:30.73 kernel  pc: 0x00C0463A AseHTTPURLInputStream::readBytes+ 0xd8a22 (0x00150015, 0x00000002, 0x0000270F, 0x00000000)
03:00000:00016:2006/01/13 21:37:30.73 kernel  pc: 0x00C042C4 AseHTTPURLInputStream::readBytes+ 0xd86ac (0x00150015, 0x00000001, 0x00000000, 0x00000000)
03:00000:00016:2006/01/13 21:37:30.73 kernel  pc: 0x00BB384B AseHTTPURLInputStream::readBytes+ 0x87c33 (0x00150015, 0xFFFFFFFF, 0x7439F1D4, 0xE0000001)
03:00000:00016:2006/01/13 21:37:30.73 kernel  pc: 0x00407419 (Symbol not found)(0xE0000001, 0x77B96CD5, 0x7439F208, 0x00000000)
03:00000:00016:2006/01/13 21:37:30.73 kernel  pc: 0x00BA7D54 AseHTTPURLInputStream::readBytes+ 0x7c13c (0x09718CC0, 0x00000000, 0x00000000, 0x09718CC0)
03:00000:00016:2006/01/13 21:37:30.73 kernel  pc: 0x00BA8957 AseHTTPURLInputStream::readBytes+ 0x7cd3f (0x00BA8853, 0x09718CC0, 0x00000008, 0x01000100)
03:00000:00016:2006/01/13 21:37:30.75 kernel  pc: 0x7C826063 kernel32.dll (0x00000000, 0x00000000, 0x00000000, 0x00000000)
03:00000:00016:2006/01/13 21:37:30.75 kernel  end of stack trace, spid 16, kpid 1376277, suid 0
03:00000:00001:2006/01/13 21:37:31.37 server  Recovery has restored the original size for '16K' pool and '2K' pool in 'default data cache'.
03:00000:00001:2006/01/13 21:37:31.37 server  Recovery complete.
03:00000:00001:2006/01/13 21:37:31.37 server  SQL Server's default unicode sort order is 'binary'.
03:00000:00001:2006/01/13 21:37:31.37 server  SQL Server's default sort order is:
03:00000:00001:2006/01/13 21:37:31.37 server    'bin_cp850' (ID = 50)
03:00000:00001:2006/01/13 21:37:31.37 server  on top of default character set:
03:00000:00001:2006/01/13 21:37:31.37 server    'cp850' (ID = 2).
03:00000:00001:2006/01/13 21:37:31.37 server  Master device size: 256 megabytes, or 131072 virtual pages. (A virtual page is 2048 bytes.)
03:00000:00001:2006/01/13 21:37:31.59 server  Error: 921, Severity: 14, State: 1
03:00000:00001:2006/01/13 21:37:31.59 server  Database 'ShenBao' has not been recovered yet - please wait and try again.

chenfeng825

这种时间片错误先看看是否由于磁盘或者之类的硬件问题引起的。还有数据库怎么回需要做recovery，是否是异常当机之类的。还有可能是bug，这样说实在很空泛的！检查os还有硬件一个个排出吧

wwwlzyou

select * from sysprocesses where spid=1查一下进程

wwwlzyou

这个错误一般是数据库正在回退,而关机导致的

wwwlzyou

用isql可以进入master吗

trytodoit

要不数据量是否大,如果不大,可以等等,看回退完之后是否能够正常