服务能ping通，但isql登入不上，sybase centrall也登入不进去！

laizemu

00:00000:00000:2006/03/09 07:54:11.92 kernel  Use license file c:\sybase\SYSAM-1_0\licenses\license.dat.
00:00000:00000:2006/03/09 07:54:12.68 kernel  Using config area from primary master device.
00:00000:00000:2006/03/09 07:54:12.82 kernel  Warning: Using default file 'c:\sybase\DBSERVER.cfg' since a configuration file was not specified. Specify a configuration file name in the RUNSERVER file to avoid this message.
00:00000:00000:2006/03/09 07:54:13.20 kernel  Kernel memory at 0x20000000, 380928 bytes
00:00000:00000:2006/03/09 07:54:13.20 kernel  Server part of first shared memory region at 0x2005D000, 60010496 bytes.
00:00000:00000:2006/03/09 07:54:13.20 kernel  Highest valid address is 0x2005D000
00:00000:00000:2006/03/09 07:54:13.20 kernel  Using 100000 file descriptors.
00:00000:00000:2006/03/09 07:54:13.31 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:2006/03/09 07:54:13.31 kernel  Confidential property of Sybase, Inc.
00:00000:00000:2006/03/09 07:54:13.31 kernel  Copyright 1987, 1999
00:00000:00000:2006/03/09 07:54:13.31 kernel  Sybase, Inc.  All rights reserved.
00:00000:00000:2006/03/09 07:54:13.31 kernel  Unpublished rights reserved under U.S. copyright laws.
00:00000:00000:2006/03/09 07:54:13.31 kernel  
00:00000:00000:2006/03/09 07:54:13.31 kernel  This software contains confidential and trade secret information of Sybase,
00:00000:00000:2006/03/09 07:54:13.31 kernel  Inc.   Use,  duplication or disclosure of the software and documentation by
00:00000:00000:2006/03/09 07:54:13.31 kernel  the  U.S.  Government  is  subject  to  restrictions set forth in a license
00:00000:00000:2006/03/09 07:54:13.31 kernel  agreement  between  the  Government  and  Sybase,  Inc.  or  other  written
00:00000:00000:2006/03/09 07:54:13.31 kernel  agreement  specifying  the  Government's rights to use the software and any
00:00000:00000:2006/03/09 07:54:13.31 kernel  applicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2006/03/09 07:54:13.31 kernel  Sybase, Inc. 6475 Christie Avenue, Emeryville, CA 94608, USA
00:00000:00000:2006/03/09 07:54:13.31 kernel  Using 'c:\sybase\DBSERVER.cfg' for configuration information.
00:00000:00000:2006/03/09 07:54:13.31 kernel  Logging ASE messages in file 'c:\sybase\ASE-12_0\install\errorlog'.
00:00000:00000:2006/03/09 07:54:13.37 kernel  Initializing MSDTC Connection
00:00000:00000:2006/03/09 07:54:16.50 kernel  MSDTC Initialization succeeded
00:00000:00000:2006/03/09 07:54:16.51 kernel  Directory Control Layer (DCL) using directory driver: InterfacesDriver
00:00000:00000:2006/03/09 07:54:16.51 kernel  *** WARNING ******************
00:00000:00000:2006/03/09 07:54:16.51 kernel  Operating system may favor the system cache when memory is at a premium.
To disable this warning, set the registry parameter 'LargeSystemCache' to 0 in HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\Memory Management.
00:00000:00000:2006/03/09 07:54:16.51 kernel  SQL Server NT process id is 0xc0.
00:00000:00000:2006/03/09 07:54:16.51 kernel  SQL Server was started as a Service.
00:00000:00000:2006/03/09 07:54:16.53 kernel  Network and device connection limit is 99992.
00:00000:00000:2006/03/09 07:54:16.64 server  Number of proc buffers allocated: 3786.
00:00000:00000:2006/03/09 07:54:16.81 server  Number of blocks left for proc headers: 3744.
00:00000:00000:2006/03/09 07:54:16.82 server  Proc header memory allocated 1872 pages for each per engine cache
00:00000:00000:2006/03/09 07:54:16.82 server   Memory allocated for the default data cache cachelet 1: 28486 Kb
00:00000:00000:2006/03/09 07:54:16.84 server  Size of the 2K memory pool: 28486 Kb
00:00000:00000:2006/03/09 07:54:16.84 kernel  Initializing virtual device 0, 'c:\sybase\data\master.dat' with dsync 'on'.
00:00000:00000:2006/03/09 07:54:16.84 kernel  Virtual device 0 started using asynchronous i/o.
00:00000:00000:2006/03/09 07:54:16.84 kernel  Worker Thread Manager is not enabled for use in SQL Server.
00:00000:00000:2006/03/09 07:54:16.84 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:2006/03/09 07:54:16.87 kernel  engine 0, os pid 204  online
00:00000:00000:2006/03/09 07:54:16.89 server  No active traceflags
00:00000:00001:2006/03/09 07:54:17.06 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:2006/03/09 07:54:17.06 kernel  Component Integration Services: using 'Sybase Client-Library/11.1.1/P2-EBF8060/PC Intel/1/OPT/Sun Aug 09 16:34:21 1998'
00:00000:00001:2006/03/09 07:54:17.09 server  Opening Master Database ...
00:00000:00001:2006/03/09 07:54:17.37 server  Loading SQL Server's default sort order and character set
00:00000:00001:2006/03/09 07:54:17.37 server  Loaded default Unilib conversion handle.
00:00000:00002:2006/03/09 07:54:17.39 kernel  network name dbserver, type ether, port 5000
00:00000:00001:2006/03/09 07:54:17.42 server  Recovering database 'master'
00:00000:00001:2006/03/09 07:54:17.54 server  Redo pass of recovery has processed 1 committed and 0 aborted transactions.
00:00000:00001:2006/03/09 07:54:17.67 server  Checking external objects.
00:00000:00001:2006/03/09 07:54:17.71 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:2006/03/09 07:54:17.89 server  Database 'master' is now online.
00:00000:00001:2006/03/09 07:54:17.89 server  The transaction log in the database 'master' will use I/O size of 2 Kb.



00:00000:00001:2006/03/09 07:54:18.00 server  Error: 834, Severity: 20, State: 4
00:00000:00001:2006/03/09 07:54:18.00 server  Illegal attempt to clean buffer: BUF pointer = '0x23643C78', MASS pointer = '0x23643C78', (Buf#: '0'), page ptr = '0x23492800', dbid = '1', Mass virtpage = '725', Buffer page = '721', Mass status = '0x44001000', Buffer status = '0x1', size = '2048', cache (id: 0) = 'default data cache'.
00:00000:00001:2006/03/09 07:54:18.00 kernel  ************************************
00:00000:00001:2006/03/09 07:54:18.00 kernel  curdb = 1 pstat = 0x1000 lasterror = 834
00:00000:00001:2006/03/09 07:54:18.00 kernel  preverror = 0 transtate = 1
00:00000:00001:2006/03/09 07:54:18.00 kernel  curcmd = 0 program =                              
00:00000:00001:2006/03/09 07:54:19.23 kernel  pc: 0x009EF654 os_get_cur_stk_desc+ 0xf1 (0x01BEF958, 0x77F0C710, 0x77F0DC20, 0xFFFFFFFF)
00:00000:00001:2006/03/09 07:54:19.23 kernel  pc: 0x009EF654 os_get_cur_stk_desc+ 0xf1 (0x01BEF958, 0x01BEF710, 0x0000270F, 0x00000002)
00:00000:00001:2006/03/09 07:54:19.23 kernel  pc: 0x009C893F pcstkwalk+ 0x204 (0x000B000B, 0x00000002, 0x0000270F, 0x00000000)
00:00000:00001:2006/03/09 07:54:19.23 kernel  pc: 0x009C85C9 ucstkgentrace+ 0x1f9 (0x000B000B, 0x00000001, 0x00000000, 0x00000000)
00:00000:00001:2006/03/09 07:54:19.23 kernel  pc: 0x00998D18 ucbacktrace+ 0x88 (0x00000000, 0xFFFFFFFF, 0x01BEFCA0, 0x0045C74C)
00:00000:00001:2006/03/09 07:54:19.23 kernel  pc: 0x004060A7 terminate_process+ 0xb11 (0x01BEFD0C, 0x0045C5C1, 0x00000008, 0x00000022)
00:00000:00001:2006/03/09 07:54:19.23 kernel  pc: 0x0045C769 close_network+ 0xc (0x00000008, 0x00000022, 0x00000014, 0x00000004)
00:00000:00001:2006/03/09 07:54:19.23 kernel  pc: 0x0045C74C hdl_default+ 0x38 (0x00000008, 0x00000022, 0x00000014, 0x00000004)
00:00000:00001:2006/03/09 07:54:19.23 kernel  pc: 0x0045C5C1 ex_raise+ 0x309 (0x00000000, 0x20C9F060, 0x00000000, 0x00000000)
00:00000:00001:2006/03/09 07:54:19.23 kernel  pc: 0x00543090 cm_dbclean+ 0x1be (0x20C9F060, 0x20633490, 0x20C9F060, 0x01BEFF80)
00:00000:00001:2006/03/09 07:54:19.23 kernel  pc: 0x004D37BF buf_online_database+ 0xe8 (0x00000000, 0x00000000, 0x00000001, 0x00000000)
00:00000:00001:2006/03/09 07:54:19.23 kernel  pc: 0x00622181 masterrecover+ 0xd9 (0x00000000, 0x00000000, 0x00000000, 0x2001D87C)
00:00000:00001:2006/03/09 07:54:19.23 kernel  pc: 0x00403FDC dsinit+ 0x92c (0x2001D87C, 0x00000000, 0x00000000, 0x2001D87C)
00:00000:00001:2006/03/09 07:54:19.25 kernel  pc: 0x009E7A87 kpntwrapper+ 0x84 (0x00000000, 0x00000000, 0x00000000, 0x00000000)
00:00000:00001:2006/03/09 07:54:19.25 kernel  pc: 0x77ED4F05 KERNEL32.dll (0x00000000, 0x00000000, 0x00000000, 0x00000000)
00:00000:00001:2006/03/09 07:54:19.25 kernel  end of stack trace, spid 1, kpid 720907, suid 0
00:00000:00003:2006/03/09 07:54:19.26 kernel  udstartio: vdn 1 has not been set up
00:00000:00003:2006/03/09 07:54:19.28 server  Error: 840, Severity: 17, State: 1
00:00000:00003:2006/03/09 07:54:19.28 server  Device 'sysprocsdev' (with physical name 'c:\sybase\data\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:00003:2006/03/09 07:54:19.31 server  Error: 2812, Severity: 16, State: 5
00:00000:00003:2006/03/09 07:54:19.31 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).
00:00000:00000:2006/03/09 09:12:19.50 kernel  kisignal: SQL Server terminated by system shutdown.
00:00000:00000:2006/03/09 09:12:19.51 kernel  ueshutdown: exiting
00:00000:00000:2006/03/09 09:12:19.51 kernel  Abnormal exit detected - SQL Server process level execution bindings will be cleared on startup.
00:00000:00000:2006/03/09 09:16:37.17 kernel  Use license file c:\sybase\SYSAM-1_0\licenses\license.dat.
00:00000:00000:2006/03/09 09:16:37.81 kernel  Using config area from primary master device.
00:00000:00000:2006/03/09 09:16:37.93 kernel  Warning: Using default file 'c:\sybase\DBSERVER.cfg' since a configuration file was not specified. Specify a configuration file name in the RUNSERVER file to avoid this message.
00:00000:00000:2006/03/09 09:16:38.25 kernel  Kernel memory at 0x20000000, 380928 bytes
00:00000:00000:2006/03/09 09:16:38.25 kernel  Server part of first shared memory region at 0x2005D000, 60010496 bytes.
00:00000:00000:2006/03/09 09:16:38.25 kernel  Highest valid address is 0x2005D000
00:00000:00000:2006/03/09 09:16:38.25 kernel  Using 100000 file descriptors.
00:00000:00000:2006/03/09 09:16:38.31 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:2006/03/09 09:16:38.31 kernel  Confidential property of Sybase, Inc.
00:00000:00000:2006/03/09 09:16:38.31 kernel  Copyright 1987, 1999
00:00000:00000:2006/03/09 09:16:38.31 kernel  Sybase, Inc.  All rights reserved.
00:00000:00000:2006/03/09 09:16:38.31 kernel  Unpublished rights reserved under U.S. copyright laws.
00:00000:00000:2006/03/09 09:16:38.31 kernel  
00:00000:00000:2006/03/09 09:16:38.31 kernel  This software contains confidential and trade secret information of Sybase,
00:00000:00000:2006/03/09 09:16:38.31 kernel  Inc.   Use,  duplication or disclosure of the software and documentation by
00:00000:00000:2006/03/09 09:16:38.31 kernel  the  U.S.  Government  is  subject  to  restrictions set forth in a license
00:00000:00000:2006/03/09 09:16:38.31 kernel  agreement  between  the  Government  and  Sybase,  Inc.  or  other  written
00:00000:00000:2006/03/09 09:16:38.31 kernel  agreement  specifying  the  Government's rights to use the software and any
00:00000:00000:2006/03/09 09:16:38.31 kernel  applicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2006/03/09 09:16:38.31 kernel  Sybase, Inc. 6475 Christie Avenue, Emeryville, CA 94608, USA
00:00000:00000:2006/03/09 09:16:38.31 kernel  Using 'c:\sybase\DBSERVER.cfg' for configuration information.
00:00000:00000:2006/03/09 09:16:38.31 kernel  Logging ASE messages in file 'c:\sybase\ASE-12_0\install\errorlog'.
00:00000:00000:2006/03/09 09:16:38.35 kernel  Initializing MSDTC Connection
00:00000:00000:2006/03/09 09:16:41.48 kernel  MSDTC Initialization succeeded
00:00000:00000:2006/03/09 09:16:41.50 kernel  Directory Control Layer (DCL) using directory driver: InterfacesDriver
00:00000:00000:2006/03/09 09:16:41.50 kernel  *** WARNING ******************
00:00000:00000:2006/03/09 09:16:41.50 kernel  Operating system may favor the system cache when memory is at a premium.
To disable this warning, set the registry parameter 'LargeSystemCache' to 0 in HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\Memory Management.
00:00000:00000:2006/03/09 09:16:41.50 kernel  SQL Server NT process id is 0x72.
00:00000:00000:2006/03/09 09:16:41.50 kernel  SQL Server was started as a Service.
00:00000:00000:2006/03/09 09:16:41.51 kernel  Network and device connection limit is 99992.
00:00000:00000:2006/03/09 09:16:41.64 server  Number of proc buffers allocated: 3786.
00:00000:00000:2006/03/09 09:16:41.79 server  Number of blocks left for proc headers: 3744.
00:00000:00000:2006/03/09 09:16:41.82 server  Proc header memory allocated 1872 pages for each per engine cache
00:00000:00000:2006/03/09 09:16:41.82 server   Memory allocated for the default data cache cachelet 1: 28486 Kb
00:00000:00000:2006/03/09 09:16:41.84 server  Size of the 2K memory pool: 28486 Kb
00:00000:00000:2006/03/09 09:16:41.84 kernel  Initializing virtual device 0, 'c:\sybase\data\master.dat' with dsync 'on'.
00:00000:00000:2006/03/09 09:16:41.84 kernel  Virtual device 0 started using asynchronous i/o.
00:00000:00000:2006/03/09 09:16:41.84 kernel  Worker Thread Manager is not enabled for use in SQL Server.
00:00000:00000:2006/03/09 09:16:41.85 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:2006/03/09 09:16:41.89 kernel  engine 0, os pid 204  online
00:00000:00000:2006/03/09 09:16:41.90 server  No active traceflags
00:00000:00001:2006/03/09 09:16:42.09 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:2006/03/09 09:16:42.09 kernel  Component Integration Services: using 'Sybase Client-Library/11.1.1/P2-EBF8060/PC Intel/1/OPT/Sun Aug 09 16:34:21 1998'
00:00000:00001:2006/03/09 09:16:42.10 server  Opening Master Database ...
00:00000:00001:2006/03/09 09:16:42.35 server  Loading SQL Server's default sort order and character set
00:00000:00001:2006/03/09 09:16:42.35 server  Loaded default Unilib conversion handle.
00:00000:00002:2006/03/09 09:16:42.37 kernel  network name dbserver, type ether, port 5000
00:00000:00001:2006/03/09 09:16:42.40 server  Recovering database 'master'
00:00000:00001:2006/03/09 09:16:42.64 server  Checking external objects.
00:00000:00001:2006/03/09 09:16:42.67 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:2006/03/09 09:16:42.82 server  Database 'master' is now online.
00:00000:00001:2006/03/09 09:16:42.84 server  The transaction log in the database 'master' will use I/O size of 2 Kb.
00:00000:00001:2006/03/09 09:16:42.93 server  Error: 834, Severity: 20, State: 4
00:00000:00001:2006/03/09 09:16:42.93 server  Illegal attempt to clean buffer: BUF pointer = '0x23643C78', MASS pointer = '0x23643C78', (Buf#: '0'), page ptr = '0x23492800', dbid = '1', Mass virtpage = '725', Buffer page = '721', Mass status = '0x44001000', Buffer status = '0x1', size = '2048', cache (id: 0) = 'default data cache'.
00:00000:00001:2006/03/09 09:16:42.93 kernel  ************************************
00:00000:00001:2006/03/09 09:16:42.93 kernel  curdb = 1 pstat = 0x1000 lasterror = 834
00:00000:00001:2006/03/09 09:16:42.93 kernel  preverror = 0 transtate = 1
00:00000:00001:2006/03/09 09:16:42.93 kernel  curcmd = 0 program =                              
00:00000:00001:2006/03/09 09:16:44.14 kernel  pc: 0x009EF654 os_get_cur_stk_desc+ 0xf1 (0x01BEF958, 0x77F0C710, 0x77F0DC20, 0xFFFFFFFF)
00:00000:00001:2006/03/09 09:16:44.14 kernel  pc: 0x009EF654 os_get_cur_stk_desc+ 0xf1 (0x01BEF958, 0x01BEF710, 0x0000270F, 0x00000002)
00:00000:00001:2006/03/09 09:16:44.14 kernel  pc: 0x009C893F pcstkwalk+ 0x204 (0x000B000B, 0x00000002, 0x0000270F, 0x00000000)
00:00000:00001:2006/03/09 09:16:44.14 kernel  pc: 0x009C85C9 ucstkgentrace+ 0x1f9 (0x000B000B, 0x00000001, 0x00000000, 0x00000000)
00:00000:00001:2006/03/09 09:16:44.14 kernel  pc: 0x00998D18 ucbacktrace+ 0x88 (0x00000000, 0xFFFFFFFF, 0x01BEFCA0, 0x0045C74C)
00:00000:00001:2006/03/09 09:16:44.14 kernel  pc: 0x004060A7 terminate_process+ 0xb11 (0x01BEFD0C, 0x0045C5C1, 0x00000008, 0x00000022)
00:00000:00001:2006/03/09 09:16:44.14 kernel  pc: 0x0045C769 close_network+ 0xc (0x00000008, 0x00000022, 0x00000014, 0x00000004)
00:00000:00001:2006/03/09 09:16:44.14 kernel  pc: 0x0045C74C hdl_default+ 0x38 (0x00000008, 0x00000022, 0x00000014, 0x00000004)
00:00000:00001:2006/03/09 09:16:44.14 kernel  pc: 0x0045C5C1 ex_raise+ 0x309 (0x00000000, 0x20C9F060, 0x00000000, 0x00000000)
00:00000:00001:2006/03/09 09:16:44.14 kernel  pc: 0x00543090 cm_dbclean+ 0x1be (0x20C9F060, 0x20633490, 0x20C9F060, 0x01BEFF80)
00:00000:00001:2006/03/09 09:16:44.14 kernel  pc: 0x004D37BF buf_online_database+ 0xe8 (0x00000000, 0x00000000, 0x00000001, 0x00000000)
00:00000:00001:2006/03/09 09:16:44.14 kernel  pc: 0x00622181 masterrecover+ 0xd9 (0x00000000, 0x00000000, 0x00000000, 0x2001D87C)
00:00000:00001:2006/03/09 09:16:44.14 kernel  pc: 0x00403FDC dsinit+ 0x92c (0x2001D87C, 0x00000000, 0x00000000, 0x2001D87C)
00:00000:00001:2006/03/09 09:16:44.15 kernel  pc: 0x009E7A87 kpntwrapper+ 0x84 (0x00000000, 0x00000000, 0x00000000, 0x00000000)
00:00000:00001:2006/03/09 09:16:44.15 kernel  pc: 0x77ED4F05 KERNEL32.dll (0x00000000, 0x00000000, 0x00000000, 0x00000000)
00:00000:00001:2006/03/09 09:16:44.15 kernel  end of stack trace, spid 1, kpid 720907, suid 0

小无赖

在run_servername.bat中加-T 3607看看能不能启动数据库,如果能启动的话就清除master的日志dump tran master with truncate_only.

laizemu

用dump tran master with truncate_only执行后
出现如下错误：
Msg 4237, Level 16, State 1:
Line 1:
Cannot dump master database's log as distributed transaction resolution is not
complete yet. Please retry later.

Eisen

那么dump tran master with nolog呢?

laizemu

也没有用！

laizemu

有popo吗，用popo聊快！我的popo号是：laizemuzj

小无赖

dump tran master with no_log后提示什么信息?