sybase 1053错误

93815200

免费乐捐，感谢支持

启动sybase服务的时候出现1053错误,日志里面是这样的,请问各老师们,这是怎么会事.

Database 'sybsystemprocs' is now online.
00:00000:00011:2007/04/05 17:13:12.90 kernel  NT operating system error 10106 in module 'e:\ase1252\porttree\svr\sql\generic\ksource\strmio\n_winsock.c' at line 1377: 没有加载或初始化请求的服务提供程序。

.
00:00000:00011:2007/04/05 17:13:12.92 kernel  ninit: socket, Could not get socket
00:00000:00011:2007/04/05 17:13:12.95 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00011:2007/04/05 17:13:13.93 kernel  pc: 0x00BEC440 ws__ninit+ 0x227 (0x200655F0, 0xFFFFFFFF, 0x00BEBFFA, 0x00BD3785)
00:00000:00011:2007/04/05 17:13:13.93 kernel  pc: 0x00BEC440 ws__ninit+ 0x227 (0x20065070, 0x21FB23E0, 0x00BC0188, 0x21FB2570)
00:00000:00011:2007/04/05 17:13:13.93 kernel  pc: 0x00BEC213 wstcp_ninit+ 0x110 (0x20065070, 0x012CE852, 0x00000002, 0x00000007)
00:00000:00011:2007/04/05 17:13:13.93 kernel  pc: 0x00BDF985 ksopenendpoint+ 0x42 (0x0256F7F0, 0x00000000, 0x00730065, 0x00200073)
00:00000:00011:2007/04/05 17:13:13.93 kernel  pc: 0x0043DA71 dynl__start+ 0x184 (0x00730065, 0x00200073, 0x00000000, 0x00000000)
00:00000:00011:2007/04/05 17:13:13.95 kernel  pc: 0x0043BAEB dynl__startup+ 0x2e1 (0x00000000, 0x00730065, 0x00200073, 0x21FB23E0)
00:00000:00011:2007/04/05 17:13:13.95 kernel  pc: 0x0043B34B dynlistener+ 0x3c (0x21FB23E0, 0x00730065, 0x00200073, 0x21FB23E0)
00:00000:00011:2007/04/05 17:13:13.96 kernel  pc: 0x00BA6497 kpntwrapper+ 0x84 (0x00000000, 0x00000000, 0x00000000, 0x00000000)
00:00000:00011:2007/04/05 17:13:13.96 kernel  pc: 0x77E6438B KERNEL32.dll (0x00000000, 0x00000000, 0x00000000, 0x00000000)
00:00000:00011:2007/04/05 17:13:13.96 kernel  end of stack trace, spid 11, kpid 851981, suid 0
00:00000:00011:2007/04/05 17:13:13.98 kernel  ************************************
00:00000:00011:2007/04/05 17:13:13.98 kernel  curdb = 1 tempdb = 2 pstat = 0x200
00:00000:00011:2007/04/05 17:13:14.01 kernel  lasterror = 0 preverror = 0 transtate = 1
00:00000:00011:2007/04/05 17:13:14.01 kernel  curcmd = 0 program =                              
00:00000:00011:2007/04/05 17:13:14.01 kernel  pc: 0x00C2AD4D os_get_cur_stk_desc+ 0x13a (0x0256ED68, 0x77E6E597, 0x77E64E58, 0xFFFFFFFF)
00:00000:00011:2007/04/05 17:13:14.01 kernel  pc: 0x00C2AD4D os_get_cur_stk_desc+ 0x13a (0x0256ED68, 0x0256EB20, 0x0000270F, 0x00000002)
00:00000:00011:2007/04/05 17:13:14.01 kernel  pc: 0x00C0195A pcstkwalk+ 0x204 (0x000D000D, 0x00000002, 0x0000270F, 0x00000000)
00:00000:00011:2007/04/05 17:13:14.01 kernel  pc: 0x00C015E4 ucstkgentrace+ 0x224 (0x000D000D, 0x00000001, 0x00F3C340, 0x00000000)
00:00000:00011:2007/04/05 17:13:14.01 kernel  pc: 0x00BB10EB ucbacktrace+ 0xab (0x000D000D, 0xFFFFFFFF, 0xC0000005, 0x20B4292C)
00:00000:00011:2007/04/05 17:13:14.01 kernel  pc: 0x00407419 terminate_process+ 0xc6a (0xC0000005, 0x7800BDB5, 0x0256F2F4, 0x00000000)
00:00000:00011:2007/04/05 17:13:14.01 kernel  pc: 0x00BA5909 kiexception+ 0x29e (0x21FB23E0, 0x00730065, 0x00200073, 0x21FB23E0)
00:00000:00011:2007/04/05 17:13:14.01 kernel  pc: 0x00BA6517 kpntwrapper+ 0x104 (0x00000000, 0x00000000, 0x00000000, 0x00000000)
00:00000:00011:2007/04/05 17:13:14.01 kernel  pc: 0x77E6438B KERNEL32.dll (0x00000000, 0x00000000, 0x00000000, 0x00000000)
00:00000:00011:2007/04/05 17:13:14.01 kernel  end of stack trace, spid 11, kpid 851981, suid 0

cyj1827

可能是某个表有坏页，需要做全库DBCC。然后查到是哪个表坏，做修复。如果不能修复只能BCP OUT后重建表在BCP IN