- 论坛徽章:
- 0
|
IBM 360 双CPU服务器, 2G内存, WIN2000 AD SERVER , SYBASE12.0 配置1.4G内存
以前使用1个引擎,工作正常, 现设置为2个引擎, 就出现了宕机现象
请教各位如何解决此问题?
SYBASE 错误日志如下:
01:00000:00025:2007/01/12 08:28:02.18 kernel Cannot send, host process disconnected: 1212 spid: 25
01:00000:00000:2007/01/12 10:10:07.79 kernel SQL Server system exception (0xc0000005) generated by a storage access violation.
01:00000:00000:2007/01/12 10:10:07.82 kernel pc: 0x020CFD2D (can't find module)(0x00000000, 0x00000000, 0x00000000, 0x00000000)
01:00000:00000:2007/01/12 10:10:07.82 kernel end of stack trace, kernel service process: kpid 2031647
01:00000:00000:2007/01/12 10:10:07.82 kernel engine 1, os pid 1136 exited
01:00000:00000:2007/01/12 10:10:07.82 kernel Could not replace infected engine.
01:00000:00000:2007/01/12 10:10:07.82 kernel ueshutdown: exiting
01:00000:00000:2007/01/12 10:10:07.84 kernel Abnormal exit detected - SQL Server process level execution bindings will be cleared on startup.
00:00000:00000:2007/01/12 10:10:15.26 kernel Warning: There is no valid license for ASE server product. Server is booting with all the option features disabled.
00:00000:00000:2007/01/12 10:10:15.31 kernel Using config area from primary master device.
00:00000:00000:2007/01/12 10:10:15.34 kernel Warning: Using default file 'd:\sybase\HDYB.cfg' since a configuration file was not specified. Specify a configuration file name in the RUNSERVER file to avoid this message.
00:00000:00000:2007/01/12 10:10:18.70 kernel Kernel memory at 0x20000000, 489472 bytes
00:00000:00000:2007/01/12 10:10:18.70 kernel Server part of first shared memory region at 0x20077800, 1073252352 bytes.
00:00000:00000:2007/01/12 10:10:18.70 kernel Server region 0 at 0x60010000, 311754752 bytes
00:00000:00000:2007/01/12 10:10:18.70 kernel Server region 1 at 0x72CE0000, 36110336 bytes
00:00000:00000:2007/01/12 10:10:18.70 kernel Server region 2 at 0x75160000, 10944512 bytes
00:00000:00000:2007/01/12 10:10:18.70 kernel Highest valid address is 0x75BD0000
00:00000:00000:2007/01/12 10:10:18.70 kernel Using 100000 file descriptors.
00:00000:00000:2007/01/12 10:10:18.70 kernel Cannot find current default character set id 171 in internal cross reference table for unicode conversion for event logging
00:00000:00000:2007/01/12 10:10:18.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:2007/01/12 10:10:18.70 kernel Confidential property of Sybase, Inc.
00:00000:00000:2007/01/12 10:10:18.70 kernel Copyright 1987, 1999
00:00000:00000:2007/01/12 10:10:18.70 kernel Sybase, Inc. All rights reserved.
00:00000:00000:2007/01/12 10:10:18.70 kernel Unpublished rights reserved under U.S. copyright laws.
00:00000:00000:2007/01/12 10:10:18.70 kernel
00:00000:00000:2007/01/12 10:10:18.70 kernel This software contains confidential and trade secret information of Sybase,
00:00000:00000:2007/01/12 10:10:18.70 kernel Inc. Use, duplication or disclosure of the software and documentation by
00:00000:00000:2007/01/12 10:10:18.70 kernel the U.S. Government is subject to restrictions set forth in a license
00:00000:00000:2007/01/12 10:10:18.70 kernel agreement between the Government and Sybase, Inc. or other written
00:00000:00000:2007/01/12 10:10:18.70 kernel agreement specifying the Government's rights to use the software and any
00:00000:00000:2007/01/12 10:10:18.70 kernel applicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2007/01/12 10:10:18.70 kernel Sybase, Inc. 6475 Christie Avenue, Emeryville, CA 94608, USA
00:00000:00000:2007/01/12 10:10:18.70 kernel Using 'd:\sybase\HDYB.cfg' for configuration information.
00:00000:00000:2007/01/12 10:10:18.70 kernel Logging ASE messages in file 'd:\sybase\ASE-12_0\install\errorlog'.
00:00000:00000:2007/01/12 10:10:18.78 kernel Initializing MSDTC Connection
00:00000:00000:2007/01/12 10:10:19.90 kernel MSDTC Initialization succeeded
00:00000:00000:2007/01/12 10:10:19.92 kernel Directory Control Layer (DCL) using directory driver: InterfacesDriver
00:00000:00000:2007/01/12 10:10:19.92 kernel *** WARNING ******************
00:00000:00000:2007/01/12 10:10:19.92 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:2007/01/12 10:10:19.92 kernel SQL Server NT process id is 0x844.
00:00000:00000:2007/01/12 10:10:19.92 kernel SQL Server was started as a Service.
00:00000:00000:2007/01/12 10:10:19.92 kernel Network and device connection limit is 99992.
00:00000:00000:2007/01/12 10:10:20.04 server Number of proc buffers allocated: 132629.
00:00000:00000:2007/01/12 10:10:22.84 server Number of blocks left for proc headers: 132584.
00:00000:00000:2007/01/12 10:10:22.95 server Proc header memory allocated 33146 pages for each per engine cache
00:00000:00000:2007/01/12 10:10:22.95 server Memory allocated for the default data cache cachelet 1: 998418 Kb
00:00000:00000:2007/01/12 10:10:23.00 server Size of the 4K memory pool: 204800 Kb
00:00000:00000:2007/01/12 10:10:23.15 server Size of the 2K memory pool: 793612 Kb
00:00000:00000:2007/01/12 10:10:23.15 kernel Initializing virtual device 0, 'E:\hdyb\master.dat' with dsync 'on'.
00:00000:00000:2007/01/12 10:10:23.15 kernel Virtual device 0 started using asynchronous i/o.
00:00000:00000:2007/01/12 10:10:23.15 kernel Worker Thread Manager is not enabled for use in SQL Server.
00:00000:00000:2007/01/12 10:10:23.15 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:2007/01/12 10:10:23.15 kernel engine 0, os pid 564 online
00:00000:00000:2007/01/12 10:10:23.15 server No active traceflags
00:00000:00001:2007/01/12 10:10:23.17 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:2007/01/12 10:10:23.17 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:2007/01/12 10:10:23.18 server Opening Master Database ...
00:00000:00001:2007/01/12 10:10:23.23 server Loading SQL Server's default sort order and character set
00:00000:00001:2007/01/12 10:10:23.25 server Loaded default Unilib conversion handle.
00:00000:00002:2007/01/12 10:10:23.25 kernel network name 200.100.100.3, type ether, port 5000
00:00000:00003:2007/01/12 10:10:23.26 kernel network name 192.168.0.1, type ether, port 5000
00:00000:00003:2007/01/12 10:10:23.26 kernel NT operating system error 10049 in module 'e:\rel120\porttree\svr\sql\generic\ksource\strmio\n_winsock.c' at line 1377: 协议家族尚未配置到系统中或没有它的存在迹象。
.
00:00000:00003:2007/01/12 10:10:23.26 kernel ninit: bind, Could not bind socket address.
00:00000:00003:2007/01/12 10:10:23.26 server Unable to initialize network 1
00:00000:00004:2007/01/12 10:10:23.26 kernel network name cluster, type ether, port 5000
00:00000:00005:2007/01/12 10:10:23.28 kernel network name 200.100.100.1, type ether, port 5000
00:00000:00006:2007/01/12 10:10:23.28 kernel network name hdyb1, type ether, port 5000
00:00000:00001:2007/01/12 10:10:23.29 server Recovering database 'master'
00:00000:00001:2007/01/12 10:10:23.32 server Redo pass of recovery has processed 7 committed and 0 aborted transactions.
00:00000:00001:2007/01/12 10:10:23.67 server Checking external objects.
00:00000:00001:2007/01/12 10:10:23.70 server Database 'master' is now online.
00:00000:00001:2007/01/12 10:10:23.70 server The transaction log in the database 'master' will use I/O size of 4 Kb.
00:00000:00001:2007/01/12 10:10:23.84 server This installation was created using a 12.0 or later version of bldmastr.
00:00000:00001:2007/01/12 10:10:23.84 server 0 dump conditions detected at boot time
00:00000:00001:2007/01/12 10:10:23.85 server server is unnamed
00:00000:00001:2007/01/12 10:10:23.87 server Activating disk 'gsmis'.
00:00000:00001:2007/01/12 10:10:23.87 kernel Initializing virtual device 15, 'e:\hdyb\gsmis.dat' with dsync 'on'.
00:00000:00001:2007/01/12 10:10:23.87 kernel Virtual device 15 started using asynchronous i/o.
00:00000:00001:2007/01/12 10:10:23.87 server Activating disk 'gsmis_log'.
00:00000:00001:2007/01/12 10:10:23.87 kernel Initializing virtual device 16, 'e:\hdyb\gsmis_log.dat' with dsync 'on'.
00:00000:00001:2007/01/12 10:10:23.87 kernel Virtual device 16 started using asynchronous i/o.
00:00000:00001:2007/01/12 10:10:23.87 server Activating disk 'himisnew'.
00:00000:00001:2007/01/12 10:10:23.87 kernel Initializing virtual device 9, 'E:\hdyb\himisnew.dat' with dsync 'on'.
00:00000:00001:2007/01/12 10:10:23.87 kernel Virtual device 9 started using asynchronous i/o.
00:00000:00001:2007/01/12 10:10:23.87 server Activating disk 'himisnew_log'.
00:00000:00001:2007/01/12 10:10:23.87 kernel Initializing virtual device 10, 'E:\hdyb\himisnew_log.dat' with dsync 'on'.
00:00000:00001:2007/01/12 10:10:23.87 kernel Virtual device 10 started using asynchronous i/o.
00:00000:00001:2007/01/12 10:10:23.87 server Activating disk 'simis_l01'.
00:00000:00001:2007/01/12 10:10:23.87 kernel Initializing virtual device 11, 'E:\hdyb\simis_l01.dat' with dsync 'on'.
00:00000:00001:2007/01/12 10:10:23.87 kernel Virtual device 11 started using asynchronous i/o.
00:00000:00001:2007/01/12 10:10:23.87 server Activating disk 'simisnew'.
00:00000:00001:2007/01/12 10:10:23.87 kernel Initializing virtual device 7, 'E:\hdyb\simisnew.dat' with dsync 'on'.
00:00000:00001:2007/01/12 10:10:23.87 kernel Virtual device 7 started using asynchronous i/o.
00:00000:00001:2007/01/12 10:10:23.87 server Activating disk 'simisnew1'.
00:00000:00001:2007/01/12 10:10:23.87 kernel Initializing virtual device 12, 'E:\hdyb\simisnew1.dat' with dsync 'on'.
00:00000:00001:2007/01/12 10:10:23.87 kernel Virtual device 12 started using asynchronous i/o.
00:00000:00001:2007/01/12 10:10:23.87 server Activating disk 'simisnew2'.
00:00000:00001:2007/01/12 10:10:23.87 kernel Initializing virtual device 17, 'E:\hdyb\simisnew2.dat' with dsync 'on'.
00:00000:00001:2007/01/12 10:10:23.87 kernel Virtual device 17 started using asynchronous i/o.
00:00000:00001:2007/01/12 10:10:23.87 server Activating disk 'simisnew_log'.
00:00000:00001:2007/01/12 10:10:23.87 kernel Initializing virtual device 8, 'E:\hdyb\simisnew_log.dat' with dsync 'on'.
00:00000:00001:2007/01/12 10:10:23.87 kernel Virtual device 8 started using asynchronous i/o.
00:00000:00001:2007/01/12 10:10:23.87 server Activating disk 'sysprocsdev'.
00:00000:00001:2007/01/12 10:10:23.87 kernel Initializing virtual device 1, 'E:\hdyb\sybprocs.dat' with dsync 'on'.
00:00000:00001:2007/01/12 10:10:23.87 kernel Virtual device 1 started using asynchronous i/o.
00:00000:00001:2007/01/12 10:10:23.87 server Activating disk 'tempdata'.
00:00000:00001:2007/01/12 10:10:23.87 kernel Initializing virtual device 6, 'E:\hdyb\tempdata.dat' with dsync 'on'.
00:00000:00001:2007/01/12 10:10:23.87 kernel Virtual device 6 started using asynchronous i/o.
00:00000:00001:2007/01/12 10:10:23.87 server Activating disk 'zqcy_himis_dat'.
00:00000:00001:2007/01/12 10:10:23.87 kernel Initializing virtual device 2, 'e:\hdyb\zqcy_himis_dat.dat' with dsync 'on'.
00:00000:00001:2007/01/12 10:10:23.87 kernel Virtual device 2 started using asynchronous i/o.
00:00000:00001:2007/01/12 10:10:23.87 server Activating disk 'zqcy_himis_idx'.
00:00000:00001:2007/01/12 10:10:23.87 kernel Initializing virtual device 3, 'e:\hdyb\zqcy_himis_idx.dat' with dsync 'on'.
00:00000:00001:2007/01/12 10:10:23.87 kernel Virtual device 3 started using asynchronous i/o.
00:00000:00001:2007/01/12 10:10:23.87 server Activating disk 'zqcy_himis_log'.
00:00000:00001:2007/01/12 10:10:23.87 kernel Initializing virtual device 4, 'e:\hdyb\zqcy_himis_log.dat' with dsync 'on'.
00:00000:00001:2007/01/12 10:10:23.87 kernel Virtual device 4 started using asynchronous i/o.
00:00000:00001:2007/01/12 10:10:23.87 server Activating disk 'zqcy_simis_dat1'.
00:00000:00001:2007/01/12 10:10:23.87 kernel Initializing virtual device 18, 'E:\hdyb\zqcy_simis_dat1.dat' with dsync 'on'.
00:00000:00001:2007/01/12 10:10:23.87 kernel Virtual device 18 started using asynchronous i/o.
00:00000:00001:2007/01/12 10:10:23.87 server Activating disk 'zqcy_simis_idx1'.
00:00000:00001:2007/01/12 10:10:23.87 kernel Initializing virtual device 19, 'E:\hdyb\zqcy_simis_idx1.dat' with dsync 'on'.
00:00000:00001:2007/01/12 10:10:23.87 kernel Virtual device 19 started using asynchronous i/o.
00:00000:00001:2007/01/12 10:10:23.87 server Activating disk 'zqcy_simis_log1'.
00:00000:00001:2007/01/12 10:10:23.87 kernel Initializing virtual device 20, 'E:\hdyb\zqcy_simis_log1.dat' with dsync 'on'.
00:00000:00001:2007/01/12 10:10:23.87 kernel Virtual device 20 started using asynchronous i/o.
00:00000:00001:2007/01/12 10:10:24.01 server Recovering database 'sybsystemdb'.
00:00000:00001:2007/01/12 10:10:24.01 server Redo pass of recovery has processed 0 committed and 1 aborted transactions.
00:00000:00001:2007/01/12 10:10:24.28 server Boot Count: 77
00:00000:00001:2007/01/12 10:10:24.29 server Checking external objects.
00:00000:00001:2007/01/12 10:10:24.31 server The transaction log in the database 'sybsystemdb' will use I/O size of 4 Kb.
00:00000:00001:2007/01/12 10:10:24.46 server Database 'sybsystemdb' is now online.
00:00000:00001:2007/01/12 10:10:24.50 server Recovering database 'model'.
00:00000:00001:2007/01/12 10:10:24.71 server Checking external objects.
00:00000:00001:2007/01/12 10:10:24.75 server The transaction log in the database 'model' will use I/O size of 4 Kb.
00:00000:00001:2007/01/12 10:10:24.90 server Database 'model' is now online.
00:00000:00001:2007/01/12 10:10:24.90 server Resident Node id: f6cc59661f57
00:00000:00001:2007/01/12 10:10:24.90 server Transaction coordinator initialized.
00:00000:00001:2007/01/12 10:10:24.92 server Clearing temp db
00:00000:00001:2007/01/12 10:10:46.90 server The transaction log in the database 'tempdb' will use I/O size of 4 Kb.
00:00000:00001:2007/01/12 10:10:49.67 server The transaction log in the database 'tempdb' will use I/O size of 4 Kb.
00:00000:00001:2007/01/12 10:10:49.84 server Database 'tempdb' is now online.
00:00000:00001:2007/01/12 10:10:49.84 server The transaction log in the database 'tempdb' will use I/O size of 4 Kb.
00:00000:00001:2007/01/12 10:10:50.03 server Recovering database 'sybsystemprocs'.
00:00000:00001:2007/01/12 10:10:50.46 server Checking external objects.
00:00000:00001:2007/01/12 10:10:50.50 server The transaction log in the database 'sybsystemprocs' will use I/O size of 4 Kb.
00:00000:00001:2007/01/12 10:10:50.68 server Database 'sybsystemprocs' is now online.
00:00000:00001:2007/01/12 10:10:50.78 server Recovering database 'zqcy_himis'.
00:00000:00001:2007/01/12 10:10:50.79 server Redo pass of recovery has processed 1 committed and 2 aborted transactions.
00:00000:00001:2007/01/12 10:10:51.82 server Checking external objects.
00:00000:00001:2007/01/12 10:10:51.84 server The transaction log in the database 'zqcy_himis' will use I/O size of 4 Kb.
00:00000:00001:2007/01/12 10:10:52.00 server Database 'zqcy_himis' is now online.
00:00000:00001:2007/01/12 10:10:52.03 server Recovering database 'simisnew'.
00:00000:00001:2007/01/12 10:10:54.50 server Checking external objects.
00:00000:00001:2007/01/12 10:10:54.51 server The transaction log in the database 'simisnew' will use I/O size of 4 Kb.
00:00000:00001:2007/01/12 10:10:54.67 server Database 'simisnew' is now online.
00:00000:00001:2007/01/12 10:10:54.71 server Recovering database 'himisnew'.
00:00000:00001:2007/01/12 10:10:55.31 server Checking external objects.
00:00000:00001:2007/01/12 10:10:55.32 server The transaction log in the database 'himisnew' will use I/O size of 4 Kb.
00:00000:00001:2007/01/12 10:10:55.48 server Database 'himisnew' is now online.
00:00000:00001:2007/01/12 10:10:55.53 server Recovering database 'gsmis'.
00:00000:00001:2007/01/12 10:10:57.64 server Checking external objects.
00:00000:00001:2007/01/12 10:10:57.65 server The transaction log in the database 'gsmis' will use I/O size of 4 Kb.
00:00000:00001:2007/01/12 10:10:57.79 server Database 'gsmis' is now online.
00:00000:00001:2007/01/12 10:10:57.79 server Recovering database 'zqcy_simis'.
00:00000:00001:2007/01/12 10:10:57.85 server Redo pass of recovery has processed 6 committed and 2 aborted transactions.
00:00000:00001:2007/01/12 10:10:58.84 server Checking external objects.
00:00000:00001:2007/01/12 10:10:58.85 server The transaction log in the database 'zqcy_simis' will use I/O size of 4 Kb.
00:00000:00001:2007/01/12 10:10:59.01 server Database 'zqcy_simis' is now online.
00:00000:00001:2007/01/12 10:10:59.04 server Recovery complete.
00:00000:00001:2007/01/12 10:10:59.04 server SQL Server's default sort order is:
00:00000:00001:2007/01/12 10:10:59.04 server 'bin_cp936' (ID = 50)
00:00000:00001:2007/01/12 10:10:59.04 server on top of default character set:
00:00000:00001:2007/01/12 10:10:59.04 server 'cp936' (ID = 171).
01:00000:00000:2007/01/12 10:10:59.04 kernel Network and device connection limit is 99992.
01:00000:00000:2007/01/12 10:10:59.04 kernel engine 1, os pid 1140 online
01:00000:00017:2007/01/12 10:33:12.20 kernel Cannot send, host process disconnected: HDYB36 768 spid: 17 |
|