双机软件，无法启动Sybase服务，请帮帮忙！！！

zhixian111

运行了好几年的双机+阵列+Sybase12，前几天Sybase服务启不了了。下面是日志：

.00:00000:00000:2005/12/15 16:19:50.35 kernel  Use license file d:\sybase\SYSAM-1_0\licenses\license.dat.
00:00000:00000:2005/12/15 16:19:50.56 kernel  Using config area from primary master device.
00:00000:00000:2005/12/15 16:19:50.59 kernel  Warning: Using default file 'd:\sybase\DBSVR.cfg' since a configuration file was not specified. Specify a configuration file name in the RUNSERVER file to avoid this message.
00:00000:00000:2005/12/15 16:19:52.01 kernel  Kernel memory at 0x20000000, 333824 bytes
00:00000:00000:2005/12/15 16:19:52.03 kernel  Server part of first shared memory region at 0x20051800, 129689600 bytes.
00:00000:00000:2005/12/15 16:19:52.06 kernel  Highest valid address is 0x20051800
00:00000:00000:2005/12/15 16:19:52.12 kernel  Using 100000 file descriptors.
00:00000:00000:2005/12/15 16:19:52.70 kernel  Adaptive Server Enterprise/12.0/P/SWR 8776 ESD 1/NT (IX86)/OS 4.0/1580/32bit/OPT/Mon Dec 06 21:50:07 1999
00:00000:00000:2005/12/15 16:19:52.70 kernel  Confidential property of Sybase, Inc.
00:00000:00000:2005/12/15 16:19:52.70 kernel  Copyright 1987, 1999
00:00000:00000:2005/12/15 16:19:52.70 kernel  Sybase, Inc.  All rights reserved.
00:00000:00000:2005/12/15 16:19:52.70 kernel  Unpublished rights reserved under U.S. copyright laws.
00:00000:00000:2005/12/15 16:19:52.70 kernel  
00:00000:00000:2005/12/15 16:19:52.70 kernel  This software contains confidential and trade secret information of Sybase,
00:00000:00000:2005/12/15 16:19:52.70 kernel  Inc.   Use,  duplication or disclosure of the software and documentation by
00:00000:00000:2005/12/15 16:19:52.70 kernel  the  U.S.  Government  is  subject  to  restrictions set forth in a license
00:00000:00000:2005/12/15 16:19:52.70 kernel  agreement  between  the  Government  and  Sybase,  Inc.  or  other  written
00:00000:00000:2005/12/15 16:19:52.70 kernel  agreement  specifying  the  Government's rights to use the software and any
00:00000:00000:2005/12/15 16:19:52.70 kernel  applicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2005/12/15 16:19:52.70 kernel  Sybase, Inc. 6475 Christie Avenue, Emeryville, CA 94608, USA
00:00000:00000:2005/12/15 16:19:52.70 kernel  Using 'd:\sybase\DBSVR.cfg' for configuration information.
00:00000:00000:2005/12/15 16:19:52.70 kernel  Logging ASE messages in file 'e:\DnData\errorlog'.
00:00000:00000:2005/12/15 16:19:53.46 kernel  Initializing MSDTC Connection
00:00000:00000:2005/12/15 16:20:13.21 kernel  MSDTC Initialization succeeded
00:00000:00000:2005/12/15 16:20:13.21 kernel  Directory Control Layer (DCL) using directory driver: InterfacesDriver
00:00000:00000:2005/12/15 16:20:13.25 kernel  SQL Server NT process id is 0x8cc.
00:00000:00000:2005/12/15 16:20:13.25 kernel  SQL Server was started as a Service.
00:00000:00000:2005/12/15 16:20:13.28 kernel  Network and device connection limit is 99992.
00:00000:00000:2005/12/15 16:20:13.42 server  Number of proc buffers allocated: 16941.
00:00000:00000:2005/12/15 16:20:13.82 server  Number of blocks left for proc headers: 16904.
00:00000:00000:2005/12/15 16:20:13.89 server  Proc header memory allocated 8452 pages for each per engine cache
00:00000:00000:2005/12/15 16:20:13.89 server   Memory allocated for the default data cache cachelet 1: 74186 Kb
00:00000:00000:2005/12/15 16:20:13.89 server  Size of the 16K memory pool: 22528 Kb
00:00000:00000:2005/12/15 16:20:13.89 server  Size of the 4K memory pool: 14336 Kb
00:00000:00000:2005/12/15 16:20:13.90 server  Size of the 2K memory pool: 37322 Kb
00:00000:00000:2005/12/15 16:20:13.90 kernel  Initializing virtual device 0, 'E:\DnData\master.dat' with dsync 'on'.
00:00000:00000:2005/12/15 16:20:13.92 kernel  Virtual device 0 started using asynchronous i/o.
00:00000:00000:2005/12/15 16:20:13.92 kernel  Worker Thread Manager is not enabled for use in SQL Server.
00:00000:00000:2005/12/15 16:20:13.92 kernel  Either the config parameter 'use security services' is set to 0, or ASE does not support use of external security mechanisms on this platform. The Security Control Layer will not be initialized. No external security mechanisms will be supported.
00:00000:00000:2005/12/15 16:20:13.95 kernel  engine 0, os pid 420  online
00:00000:00000:2005/12/15 16:20:14.04 server  No active traceflags
00:00000:00001:2005/12/15 16:20:14.18 kernel  Component Integration Services loaded; version 'Component Integration Services/12.0/P/SWR 8776 ESD 1/NT (IX86)/OS 4.0/1580/32bit/OPT/Mon Dec 06 20:31:23 1999'.
00:00000:00001:2005/12/15 16:20:14.18 kernel  Component Integration Services: using 'Sybase Client-Library/12.0/P/PC Intel/1/OPT/Mon Oct 04 15:42:12 1999'
00:00000:00001:2005/12/15 16:20:14.20 server  Opening Master Database ...
00:00000:00001:2005/12/15 16:20:14.40 server  Loading SQL Server's default sort order and character set
00:00000:00001:2005/12/15 16:20:14.40 server  Loaded default Unilib conversion handle.
00:00000:00002:2005/12/15 16:20:14.42 kernel  network name dbsvr2, type ether, port 5000
00:00000:00003:2005/12/15 16:20:14.42 kernel  network name 192.168.1.63, type ether, port 5000
00:00000:00004:2005/12/15 16:20:14.43 kernel  network name 192.168.2.63, type ether, port 5000
00:00000:00001:2005/12/15 16:20:14.45 server  Recovering database 'master'
00:00000:00001:2005/12/15 16:20:14.60 server  Checking external objects.
00:00000:00001:2005/12/15 16:20:14.65 server  Space available in the log segment has fallen critically low in database 'master'.  All future modifications to this database will be suspended until the log is successfully dumped and space becomes available.
00:00000:00001:2005/12/15 16:20:14.92 server  Database 'master' is now online.
00:00000:00001:2005/12/15 16:20:14.92 server  The transaction log in the database 'master' will use I/O size of 4 Kb.
00:00000:00005:2005/12/15 16:20:14.92 kernel  udstartio: vdn 1 has not been set up
00:00000:00001:2005/12/15 16:20:14.93 server  Error: 834, Severity: 20, State: 4
00:00000:00001:2005/12/15 16:20:14.93 server  Illegal attempt to clean buffer: BUF pointer = '0x27A22820', MASS pointer = '0x27A22820', (Buf#: '0'), page ptr = '0x275D0800', dbid = '1', Mass virtpage = '292', Buffer page = '288', Mass status = '0x44001000', Buffer status = '0x1', size = '2048', cache (id: 0) = 'default data cache'.
00:00000:00001:2005/12/15 16:20:14.93 kernel  ************************************
00:00000:00001:2005/12/15 16:20:14.93 kernel  curdb = 1 pstat = 0x1000 lasterror = 834
00:00000:00001:2005/12/15 16:20:14.93 kernel  preverror = 0 transtate = 1
00:00000:00001:2005/12/15 16:20:14.93 kernel  curcmd = 0 program =                              
00:00000:00001:2005/12/15 16:20:17.54 kernel  pc: 0x009EF654 os_get_cur_stk_desc+ 0xf1 (0x01CEF954, 0x77E7F0B4, 0x77E717E8, 0xFFFFFFFF)
00:00000:00001:2005/12/15 16:20:17.54 kernel  pc: 0x009EF654 os_get_cur_stk_desc+ 0xf1 (0x01CEF954, 0x01CEF70C, 0x0000270F, 0x00000002)
00:00000:00001:2005/12/15 16:20:17.54 kernel  pc: 0x009C893F pcstkwalk+ 0x204 (0x000B000B, 0x00000002, 0x0000270F, 0x00000000)
00:00000:00001:2005/12/15 16:20:17.54 kernel  pc: 0x009C85C9 ucstkgentrace+ 0x1f9 (0x000B000B, 0x00000001, 0x00000000, 0x00000000)
00:00000:00001:2005/12/15 16:20:17.54 kernel  pc: 0x00998D18 ucbacktrace+ 0x88 (0x00000000, 0xFFFFFFFF, 0x01CEFC9C, 0x0045C74C)
00:00000:00001:2005/12/15 16:20:17.54 kernel  pc: 0x004060A7 terminate_process+ 0xb11 (0x01CEFD08, 0x0045C5C1, 0x00000008, 0x00000022)
00:00000:00001:2005/12/15 16:20:17.54 kernel  pc: 0x0045C769 close_network+ 0xc (0x00000008, 0x00000022, 0x00000014, 0x00000004)
00:00000:00001:2005/12/15 16:20:17.54 kernel  pc: 0x0045C74C hdl_default+ 0x38 (0x00000008, 0x00000022, 0x00000014, 0x00000004)
00:00000:00001:2005/12/15 16:20:17.54 kernel  pc: 0x0045C5C1 ex_raise+ 0x309 (0x00000000, 0x20899480, 0x00000000, 0x00000000)
00:00000:00001:2005/12/15 16:20:17.54 kernel  pc: 0x00543090 cm_dbclean+ 0x1be (0x20899480, 0x20396EF0, 0x20899480, 0x01CEFF7C)
00:00000:00001:2005/12/15 16:20:17.54 kernel  pc: 0x004D37BF buf_online_database+ 0xe8 (0x00000000, 0x00000000, 0x00000001, 0x00000000)
00:00000:00001:2005/12/15 16:20:17.54 kernel  pc: 0x00622181 masterrecover+ 0xd9 (0x00000000, 0x00000000, 0x00000000, 0x2001CAC4)
00:00000:00001:2005/12/15 16:20:17.54 kernel  pc: 0x00403FDC dsinit+ 0x92c (0x2001CAC4, 0x00000000, 0x00000000, 0x2001CAC4)
00:00000:00001:2005/12/15 16:20:17.79 kernel  pc: 0x009E7A87 kpntwrapper+ 0x84 (0x00000000, 0x00000000, 0x00000000, 0x00000000)
00:00000:00001:2005/12/15 16:20:17.79 kernel  pc: 0x77E6987C KERNEL32.dll (0x00000000, 0x00000000, 0x00000000, 0x00000000)
00:00000:00001:2005/12/15 16:20:17.79 kernel  end of stack trace, spid 1, kpid 720907, suid 0
00:00000:00005:2005/12/15 16:20:17.95 server  Error: 840, Severity: 17, State: 100:00000:00005:2005/12/15 16:20:17.95 server  Device 'sysprocsdev' (with physical name 'e:\DnData\sybprocs.dat', and virtual device number 1) has not been correctly activated at startup time.  Please contact a user with System Administrator (SA) role.
00:00000:00005:2005/12/15 16:20:17.98 server  Error: 2812, Severity: 16, State: 500:00000:00005:2005/12/15 16:20:17.98 server  Stored procedure 'sp_thresholdaction' not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).

zhixian111

现在数据库起不来，没法检查呀

冷月无声

你的设备有问题的了啊！　你不会移动或是改变了数据库的文件了吧！？

YtBenjamin

sqlsrvr -SDBName -T3607
>use master
>go
>dump tran master with truncate_only
>go
>checkpoint
>go
....................

and Check sysprocsdev Device

hobbylu

你的sysprocsdev有问题,可以重新建立这个设备,另外还不可以确定其他设备是否有问题,先处理sysprocsdev吧