데이터베이스를 사랑하는 사람들의 모임 데이터베이스 사랑넷

00:00000:00007:2004/11/03 19:37:02.95 kernel shutdownproc: shutting down SQL Server!
00:00000:00007:2004/11/03 19:37:03.20 kernel ueshutdown: exiting
00:00000:00007:2004/11/03 19:37:03.20 kernel XP Server is not running.
00:00000:00000:2004/11/03 19:37:10.20 kernel Using config area from primary master device.
00:00000:00000:2004/11/03 19:37:10.21 kernel Warning: Using default file 'd:\Sybase\CALL.cfg' since a configuration file was not specified. Specify a configuration file name in the RUNSERVER file to avoid this message.
00:00000:00000:2004/11/03 19:37:10.29 kernel Kernel memory at 0x20000000, 223232 bytes
00:00000:00000:2004/11/03 19:37:10.29 kernel Server part of first shared memory region at 0x20036800, 28101444 bytes
00:00000:00000:2004/11/03 19:37:10.29 kernel Highest valid address is 0x20036800
00:00000:00000:2004/11/03 19:37:10.29 kernel Using 100000 file descriptors.
00:00000:00000:2004/11/03 19:37:10.31 kernel Adaptive Server Enterprise/11.9.2/1031/P/NT (IX86)/OS 3.51,4.0/FBU/Fri Aug 14 01:42:41 1998
00:00000:00000:2004/11/03 19:37:10.31 kernel Confidential property of Sybase, Inc.
00:00000:00000:2004/11/03 19:37:10.31 kernel Copyright 1987, 1998
00:00000:00000:2004/11/03 19:37:10.31 kernel Sybase, Inc. All rights reserved.
00:00000:00000:2004/11/03 19:37:10.31 kernel Unpublished rights reserved under U.S. copyright laws.
00:00000:00000:2004/11/03 19:37:10.31 kernel
00:00000:00000:2004/11/03 19:37:10.31 kernel This software contains confidential and trade secret information of Sybase,
00:00000:00000:2004/11/03 19:37:10.31 kernel Inc. Use, duplication or disclosure of the software and documentation by
00:00000:00000:2004/11/03 19:37:10.31 kernel the U.S. Government is subject to restrictions set forth in a license
00:00000:00000:2004/11/03 19:37:10.31 kernel agreement between the Government and Sybase, Inc. or other written
00:00000:00000:2004/11/03 19:37:10.31 kernel agreement specifying the Government's rights to use the software and any
00:00000:00000:2004/11/03 19:37:10.31 kernel applicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2004/11/03 19:37:10.31 kernel Sybase, Inc. 6475 Christie Avenue, Emeryville, CA 94608, USA
00:00000:00000:2004/11/03 19:37:10.31 kernel Using 'd:\Sybase\CALL.cfg' for configuration information.
00:00000:00000:2004/11/03 19:37:10.31 kernel Logging SQL Server messages in file 'd:\Sybase\install\errorlog'.
00:00000:00000:2004/11/03 19:37:10.42 kernel Directory Control Layer (DCL) using directory driver: InterfacesDriver
00:00000:00000:2004/11/03 19:37:10.42 kernel SQL Server NT process id is 0x35c.
00:00000:00000:2004/11/03 19:37:10.42 kernel SQL Server was started as a Service.
00:00000:00000:2004/11/03 19:37:10.43 kernel Network and device connection limit is 99992.
00:00000:00000:2004/11/03 19:37:10.43 server Number of proc buffers allocated: 1664.
00:00000:00000:2004/11/03 19:37:10.43 server Proc header memory allocated 832 pages for each per engine cache
00:00000:00000:2004/11/03 19:37:10.43 server Number of blocks left for proc headers: 1711.
00:00000:00000:2004/11/03 19:37:10.43 server Memory allocated for the default data cache cache: 12528 Kb
00:00000:00000:2004/11/03 19:37:10.45 server Size of the 2K memory pool: 12528 Kb
00:00000:00000:2004/11/03 19:37:10.45 kernel Initializing virtual device 0, 'd:\Sybase\DATA\MASTER.DAT'
00:00000:00000:2004/11/03 19:37:10.45 kernel Virtual device 0 started using asynchronous i/o.
00:00000:00000:2004/11/03 19:37:10.45 kernel Worker Thread Manager is not enabled for use in SQL Server.
00:00000:00000:2004/11/03 19:37:10.45 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:2004/11/03 19:37:10.45 kernel engine 0, os pid 176 online
00:00000:00000:2004/11/03 19:37:10.45 server No active traceflags
00:00000:00001:2004/11/03 19:37:10.45 server Opening Master Database ...
00:00000:00001:2004/11/03 19:37:10.46 server Loading SQL Server's default sort order and character set
00:00000:00003:2004/11/03 19:37:10.56 kernel network name developsvr, type ether, port 5000
00:00000:00004:2004/11/03 19:37:10.56 kernel network name 221.148.249.196, type ether, port 5000
00:00000:00001:2004/11/03 19:37:10.59 server Recovering database 'master'
00:00000:00001:2004/11/03 19:37:10.84 server Database 'master' is now online.
00:00000:00001:2004/11/03 19:37:10.84 server The transaction log in the database 'master' will use I/O size of 2 Kb.
00:00000:00001:2004/11/03 19:37:10.84 server 0 dump conditions detected at boot time
00:00000:00001:2004/11/03 19:37:10.87 server server is unnamed
00:00000:00001:2004/11/03 19:37:10.87 server Activating disk 'intranet_dev'.
00:00000:00001:2004/11/03 19:37:10.87 kernel Initializing virtual device 2, 'd:\db_device\intranet_dev.dat'
00:00000:00001:2004/11/03 19:37:10.87 kernel Virtual device 2 started using asynchronous i/o.
00:00000:00001:2004/11/03 19:37:10.87 server Activating disk 'intranet_log'.
00:00000:00001:2004/11/03 19:37:10.87 kernel Initializing virtual device 3, 'd:\db_device\intranet_log.dat'
00:00000:00001:2004/11/03 19:37:10.87 kernel Virtual device 3 started using asynchronous i/o.
00:00000:00001:2004/11/03 19:37:10.87 server Activating disk 'sysprocsdev'.
00:00000:00001:2004/11/03 19:37:10.87 kernel Initializing virtual device 1, 'd:\Sybase\DATA\SYBPROCS.DAT'
00:00000:00001:2004/11/03 19:37:10.87 kernel Virtual device 1 started using asynchronous i/o.
00:00000:00001:2004/11/03 19:37:10.98 server Recovering database 'model'.
00:00000:00001:2004/11/03 19:37:11.06 server The transaction log in the database 'model' will use I/O size of 2 Kb.
00:00000:00001:2004/11/03 19:37:11.07 server Database 'model' is now online.
00:00000:00001:2004/11/03 19:37:11.07 server Clearing temp db
00:00000:00001:2004/11/03 19:37:12.06 server The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2004/11/03 19:37:12.14 server The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2004/11/03 19:37:12.15 server Database 'tempdb' is now online.
00:00000:00001:2004/11/03 19:37:12.15 server The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2004/11/03 19:37:12.18 server Recovering database 'sybsystemprocs'.
00:00000:00001:2004/11/03 19:37:12.85 server The transaction log in the database 'sybsystemprocs' will use I/O size of 2 Kb.
00:00000:00001:2004/11/03 19:37:12.87 server Database 'sybsystemprocs' is now online.
00:00000:00001:2004/11/03 19:37:12.92 server Recovering database 'sybsyntax'.
00:00000:00001:2004/11/03 19:37:13.01 server The transaction log in the database 'sybsyntax' will use I/O size of 2 Kb.
00:00000:00001:2004/11/03 19:37:13.03 server Database 'sybsyntax' is now online.
00:00000:00001:2004/11/03 19:37:13.04 server Recovering database 'pubs2'.
00:00000:00001:2004/11/03 19:37:13.12 server The transaction log in the database 'pubs2' will use I/O size of 2 Kb.
00:00000:00001:2004/11/03 19:37:13.12 server Database 'pubs2' is now online.
00:00000:00001:2004/11/03 19:37:13.14 server Recovering database 'pubs3'.
00:00000:00001:2004/11/03 19:37:13.21 server The transaction log in the database 'pubs3' will use I/O size of 2 Kb.
00:00000:00001:2004/11/03 19:37:13.23 server Database 'pubs3' is now online.
00:00000:00001:2004/11/03 19:37:13.25 server Recovering database 'intranet'.
00:00000:00001:2004/11/03 19:37:28.51 server The transaction log in the database 'intranet' will use I/O size of 2 Kb.
00:00000:00001:2004/11/03 19:37:28.53 server Database 'intranet' is now online.
00:00000:00001:2004/11/03 19:37:28.53 server Recovery complete.
00:00000:00001:2004/11/03 19:37:28.53 server SQL Server's default sort order is:
00:00000:00001:2004/11/03 19:37:28.53 server 'bin_iso_1' (ID = 50)
00:00000:00001:2004/11/03 19:37:28.53 server on top of default character set:
00:00000:00001:2004/11/03 19:37:28.53 server 'iso_1' (ID = 1).
00:00000:00001:2004/11/03 19:37:28.53 server Loaded default Unilib conversion handle.
00:00000:00000:2004/11/04 08:36:05.25 kernel kisignal: SQL Server terminated by system shutdown.

<----이부분에서 디비에 접근이 안되어서 재부팅 했습니다.
00:00000:00000:2004/11/04 08:36:05.26 kernel ueshutdown: exiting
00:00000:00000:2004/11/04 08:36:05.26 kernel Abnormal exit detected - SQL Server process level execution bindings will be cleared on startup.
00:00000:00000:2004/11/04 08:37:46.28 kernel Using config area from primary master device.
00:00000:00000:2004/11/04 08:37:46.42 kernel Warning: Using default file 'd:\Sybase\CALL.cfg' since a configuration file was not specified. Specify a configuration file name in the RUNSERVER file to avoid this message.
00:00000:00000:2004/11/04 08:37:46.71 kernel Kernel memory at 0x20000000, 223232 bytes
00:00000:00000:2004/11/04 08:37:46.71 kernel Server part of first shared memory region at 0x20036800, 28101444 bytes
00:00000:00000:2004/11/04 08:37:46.71 kernel Highest valid address is 0x20036800
00:00000:00000:2004/11/04 08:37:46.71 kernel Using 100000 file descriptors.
00:00000:00000:2004/11/04 08:37:47.00 kernel Adaptive Server Enterprise/11.9.2/1031/P/NT (IX86)/OS 3.51,4.0/FBU/Fri Aug 14 01:42:41 1998
00:00000:00000:2004/11/04 08:37:47.00 kernel Confidential property of Sybase, Inc.
00:00000:00000:2004/11/04 08:37:47.00 kernel Copyright 1987, 1998
00:00000:00000:2004/11/04 08:37:47.00 kernel Sybase, Inc. All rights reserved.
00:00000:00000:2004/11/04 08:37:47.00 kernel Unpublished rights reserved under U.S. copyright laws.
00:00000:00000:2004/11/04 08:37:47.00 kernel
00:00000:00000:2004/11/04 08:37:47.00 kernel This software contains confidential and trade secret information of Sybase,
00:00000:00000:2004/11/04 08:37:47.00 kernel Inc. Use, duplication or disclosure of the software and documentation by
00:00000:00000:2004/11/04 08:37:47.00 kernel the U.S. Government is subject to restrictions set forth in a license
00:00000:00000:2004/11/04 08:37:47.00 kernel agreement between the Government and Sybase, Inc. or other written
00:00000:00000:2004/11/04 08:37:47.00 kernel agreement specifying the Government's rights to use the software and any
00:00000:00000:2004/11/04 08:37:47.00 kernel applicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2004/11/04 08:37:47.00 kernel Sybase, Inc. 6475 Christie Avenue, Emeryville, CA 94608, USA
00:00000:00000:2004/11/04 08:37:47.00 kernel Using 'd:\Sybase\CALL.cfg' for configuration information.
00:00000:00000:2004/11/04 08:37:47.00 kernel Logging SQL Server messages in file 'd:\Sybase\install\errorlog'.
00:00000:00000:2004/11/04 08:37:47.23 kernel Directory Control Layer (DCL) using directory driver: InterfacesDriver
00:00000:00000:2004/11/04 08:37:47.28 kernel SQL Server NT process id is 0x38c.
00:00000:00000:2004/11/04 08:37:47.28 kernel SQL Server was started as a Service.
00:00000:00000:2004/11/04 08:37:47.28 kernel Network and device connection limit is 99992.
00:00000:00000:2004/11/04 08:37:47.40 server Number of proc buffers allocated: 1664.
00:00000:00000:2004/11/04 08:37:47.65 server Proc header memory allocated 832 pages for each per engine cache
00:00000:00000:2004/11/04 08:37:48.31 server Number of blocks left for proc headers: 1711.
00:00000:00000:2004/11/04 08:37:48.31 server Memory allocated for the default data cache cache: 12528 Kb
00:00000:00000:2004/11/04 08:37:48.31 server Size of the 2K memory pool: 12528 Kb
00:00000:00000:2004/11/04 08:37:48.35 kernel Initializing virtual device 0, 'd:\Sybase\DATA\MASTER.DAT'
00:00000:00000:2004/11/04 08:37:48.35 kernel Virtual device 0 started using asynchronous i/o.
00:00000:00000:2004/11/04 08:37:48.35 kernel Worker Thread Manager is not enabled for use in SQL Server.
00:00000:00000:2004/11/04 08:37:48.35 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:2004/11/04 08:37:48.40 kernel engine 0, os pid 172 online
00:00000:00000:2004/11/04 08:37:48.42 server No active traceflags
00:00000:00001:2004/11/04 08:37:48.56 server Opening Master Database ...
00:00000:00001:2004/11/04 08:37:53.39 server Loading SQL Server's default sort order and character set
00:00000:00003:2004/11/04 08:37:53.42 kernel network name developsvr, type ether, port 00:00000:00004:2004/11/04 08:37:53.42 kernel network name , type ether, port 00:00000:00001:2004/11/04 08:37:53.46 server Recovering database 'master'
00:00000:00001:2004/11/04 08:37:53.64 server Redo pass of recovery has processed 1 committed and 0 aborted transactions.
00:00000:00001:2004/11/04 08:37:53.96 server Database 'master' is now online.
00:00000:00001:2004/11/04 08:37:53.96 server The transaction log in the database 'master' will use I/O size of 2 Kb.
00:00000:00001:2004/11/04 08:37:53.96 server 0 dump conditions detected at boot time
00:00000:00001:2004/11/04 08:37:54.03 server server is unnamed
00:00000:00001:2004/11/04 08:37:54.03 server Activating disk 'intranet_dev'.
00:00000:00001:2004/11/04 08:37:54.03 kernel Initializing virtual device 2, 'd:\db_device\intranet_dev.dat'
00:00000:00001:2004/11/04 08:37:54.04 kernel Virtual device 2 started using asynchronous i/o.
00:00000:00001:2004/11/04 08:37:54.04 server Activating disk 'intranet_log'.
00:00000:00001:2004/11/04 08:37:54.04 kernel Initializing virtual device 3, 'd:\db_device\intranet_log.dat'
00:00000:00001:2004/11/04 08:37:54.06 kernel Virtual device 3 started using asynchronous i/o.
00:00000:00001:2004/11/04 08:37:54.06 server Activating disk 'sysprocsdev'.
00:00000:00001:2004/11/04 08:37:54.06 kernel Initializing virtual device 1, 'd:\Sybase\DATA\SYBPROCS.DAT'
00:00000:00001:2004/11/04 08:37:54.07 kernel Virtual device 1 started using asynchronous i/o.
00:00000:00001:2004/11/04 08:37:54.39 server Recovering database 'model'.
00:00000:00001:2004/11/04 08:37:54.46 server The transaction log in the database 'model' will use I/O size of 2 Kb.
00:00000:00001:2004/11/04 08:37:54.48 server Database 'model' is now online.
00:00000:00001:2004/11/04 08:37:54.48 server Clearing temp db
00:00000:00001:2004/11/04 08:37:55.95 server The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2004/11/04 08:37:56.03 server The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2004/11/04 08:37:56.03 server Database 'tempdb' is now online.
00:00000:00001:2004/11/04 08:37:56.04 server The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2004/11/04 08:37:56.09 server Recovering database 'sybsystemprocs'.
00:00000:00001:2004/11/04 08:37:57.00 server The transaction log in the database 'sybsystemprocs' will use I/O size of 2 Kb.
00:00000:00001:2004/11/04 08:37:57.01 server Database 'sybsystemprocs' is now online.
00:00000:00001:2004/11/04 08:37:57.07 server Recovering database 'sybsyntax'.
00:00000:00001:2004/11/04 08:37:57.28 server The transaction log in the database 'sybsyntax' will use I/O size of 2 Kb.
00:00000:00001:2004/11/04 08:37:57.29 server Database 'sybsyntax' is now online.
00:00000:00001:2004/11/04 08:37:57.31 server Recovering database 'pubs2'.
00:00000:00001:2004/11/04 08:37:57.39 server The transaction log in the database 'pubs2' will use I/O size of 2 Kb.
00:00000:00001:2004/11/04 08:37:57.39 server Database 'pubs2' is now online.
00:00000:00001:2004/11/04 08:37:57.40 server Recovering database 'pubs3'.
00:00000:00001:2004/11/04 08:37:57.50 server The transaction log in the database 'pubs3' will use I/O size of 2 Kb.
00:00000:00001:2004/11/04 08:37:57.51 server Database 'pubs3' is now online.
00:00000:00001:2004/11/04 08:37:57.53 server Recovering database 'intranet'.
00:00000:00001:2004/11/04 08:38:15.90 server The transaction log in the database 'intranet' will use I/O size of 2 Kb.
00:00000:00001:2004/11/04 08:38:15.93 server Database 'intranet' is now online.
00:00000:00001:2004/11/04 08:38:15.93 server Recovery complete.
00:00000:00001:2004/11/04 08:38:15.93 server SQL Server's default sort order is:
00:00000:00001:2004/11/04 08:38:15.93 server 'bin_iso_1' (ID = 50)
00:00000:00001:2004/11/04 08:38:15.93 server on top of default character set:
00:00000:00001:2004/11/04 08:38:15.93 server 'iso_1' (ID = 1).
00:00000:00001:2004/11/04 08:38:15.93 server Loaded default Unilib conversion handle.
00:00000:00000:2004/11/04 09:02:34.89 kernel nast_readpost: Invalid tdslength (-28528), socket 5, listener 0
00:00000:00000:2004/11/04 09:24:43.84 kernel nast_readpost: Invalid tdslength (-28528), socket 6, listener 0
00:00000:00001:2004/11/04 09:41:24.32 server Configuration file 'd:\Sybase\CALL.cfg' has been written and the previous version has been renamed to 'd:\Sybase/CALL.019'.
00:00000:00001:2004/11/04 09:41:24.34 server The configuration option 'number of user connections' has been changed by 'sa' from '60' to '120'.
00:00000:00000:2004/11/04 09:42:11.03 kernel kisignal: SQL Server terminated by system shutdown.
00:00000:00000:2004/11/04 09:42:11.03 kernel ueshutdown: exiting
00:00000:00000:2004/11/04 09:42:11.03 kernel Abnormal exit detected - SQL Server process level execution bindings will be cleared on startup.
00:00000:00000:2004/11/04 09:43:52.34 kernel Using config area from primary master device.
00:00000:00000:2004/11/04 09:43:52.54 kernel Warning: Using default file 'd:\Sybase\CALL.cfg' since a configuration file was not specified. Specify a configuration file name in the RUNSERVER file to avoid this message.
00:00000:00000:2004/11/04 09:43:52.89 kernel Kernel memory at 0x20000000, 260096 bytes
00:00000:00000:2004/11/04 09:43:52.89 kernel Server part of first shared memory region at 0x2003f800, 28070964 bytes
00:00000:00000:2004/11/04 09:43:52.89 kernel Highest valid address is 0x2003f800
00:00000:00000:2004/11/04 09:43:52.89 kernel Using 100000 file descriptors.
00:00000:00000:2004/11/04 09:43:53.10 kernel Adaptive Server Enterprise/11.9.2/1031/P/NT (IX86)/OS 3.51,4.0/FBU/Fri Aug 14 01:42:41 1998
00:00000:00000:2004/11/04 09:43:53.10 kernel Confidential property of Sybase, Inc.
00:00000:00000:2004/11/04 09:43:53.10 kernel Copyright 1987, 1998
00:00000:00000:2004/11/04 09:43:53.10 kernel Sybase, Inc. All rights reserved.
00:00000:00000:2004/11/04 09:43:53.10 kernel Unpublished rights reserved under U.S. copyright laws.
00:00000:00000:2004/11/04 09:43:53.10 kernel
00:00000:00000:2004/11/04 09:43:53.10 kernel This software contains confidential and trade secret information of Sybase,
00:00000:00000:2004/11/04 09:43:53.10 kernel Inc. Use, duplication or disclosure of the software and documentation by
00:00000:00000:2004/11/04 09:43:53.10 kernel the U.S. Government is subject to restrictions set forth in a license
00:00000:00000:2004/11/04 09:43:53.10 kernel agreement between the Government and Sybase, Inc. or other written
00:00000:00000:2004/11/04 09:43:53.10 kernel agreement specifying the Government's rights to use the software and any
00:00000:00000:2004/11/04 09:43:53.10 kernel applicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2004/11/04 09:43:54.39 kernel Sybase, Inc. 6475 Christie Avenue, Emeryville, CA 94608, USA
00:00000:00000:2004/11/04 09:43:54.39 kernel Using 'd:\Sybase\CALL.cfg' for configuration information.
00:00000:00000:2004/11/04 09:43:54.40 kernel Logging SQL Server messages in file 'd:\Sybase\install\errorlog'.
00:00000:00000:2004/11/04 09:43:54.53 kernel Directory Control Layer (DCL) using directory driver: InterfacesDriver
00:00000:00000:2004/11/04 09:43:54.54 kernel SQL Server NT process id is 0x380.
00:00000:00000:2004/11/04 09:43:54.54 kernel SQL Server was started as a Service.
00:00000:00000:2004/11/04 09:43:54.54 kernel Network and device connection limit is 99992.
00:00000:00000:2004/11/04 09:43:54.59 server Number of proc buffers allocated: 1181.
00:00000:00000:2004/11/04 09:43:54.67 server Proc header memory allocated 590 pages for each per engine cache
00:00000:00000:2004/11/04 09:43:54.67 server Number of blocks left for proc headers: 1226.
00:00000:00000:2004/11/04 09:43:54.67 server Memory allocated for the default data cache cache: 8876 Kb
00:00000:00000:2004/11/04 09:43:54.67 server Size of the 2K memory pool: 8876 Kb
00:00000:00000:2004/11/04 09:43:54.68 kernel Initializing virtual device 0, 'd:\Sybase\DATA\MASTER.DAT'
00:00000:00000:2004/11/04 09:43:54.68 kernel Virtual device 0 started using asynchronous i/o.
00:00000:00000:2004/11/04 09:43:54.68 kernel Worker Thread Manager is not enabled for use in SQL Server.
00:00000:00000:2004/11/04 09:43:54.68 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:2004/11/04 09:43:59.00 kernel engine 0, os pid 172 online
00:00000:00000:2004/11/04 09:43:59.03 server No active traceflags
00:00000:00001:2004/11/04 09:43:59.51 server Opening Master Database ...
00:00000:00001:2004/11/04 09:44:00.31 server Loading SQL Server's default sort order and character set
00:00000:00003:2004/11/04 09:44:00.81 kernel network name developsvr, type ether, port 5000
00:00000:00004:2004/11/04 09:44:00.82 kernel network name 221.148.249.196, type ether, port 5000
00:00000:00001:2004/11/04 09:44:00.89 server Recovering database 'master'
00:00000:00001:2004/11/04 09:44:01.03 server Redo pass of recovery has processed 2 committed and 0 aborted transactions.
00:00000:00001:2004/11/04 09:44:01.71 server Database 'master' is now online.
00:00000:00001:2004/11/04 09:44:01.76 server The transaction log in the database 'master' will use I/O size of 2 Kb.
00:00000:00001:2004/11/04 09:44:01.79 server 0 dump conditions detected at boot time
00:00000:00001:2004/11/04 09:44:01.85 server server is unnamed
00:00000:00001:2004/11/04 09:44:01.87 server Activating disk 'intranet_dev'.
00:00000:00001:2004/11/04 09:44:01.87 kernel Initializing virtual device 2, 'd:\db_device\intranet_dev.dat'
00:00000:00001:2004/11/04 09:44:01.92 kernel Virtual device 2 started using asynchronous i/o.
00:00000:00001:2004/11/04 09:44:01.92 server Activating disk 'intranet_log'.
00:00000:00001:2004/11/04 09:44:01.92 kernel Initializing virtual device 3, 'd:\db_device\intranet_log.dat'
00:00000:00001:2004/11/04 09:44:01.93 kernel Virtual device 3 started using asynchronous i/o.
00:00000:00001:2004/11/04 09:44:01.93 server Activating disk 'sysprocsdev'.
00:00000:00001:2004/11/04 09:44:01.93 kernel Initializing virtual device 1, 'd:\Sybase\DATA\SYBPROCS.DAT'
00:00000:00001:2004/11/04 09:44:01.95 kernel Virtual device 1 started using asynchronous i/o.
00:00000:00001:2004/11/04 09:44:02.14 server Recovering database 'model'.
00:00000:00001:2004/11/04 09:44:02.21 server The transaction log in the database 'model' will use I/O size of 2 Kb.
00:00000:00001:2004/11/04 09:44:02.23 server Database 'model' is now online.
00:00000:00001:2004/11/04 09:44:02.23 server Clearing temp db
00:00000:00001:2004/11/04 09:44:03.42 server The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2004/11/04 09:44:03.50 server The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2004/11/04 09:44:03.51 server Database 'tempdb' is now online.
00:00000:00001:2004/11/04 09:44:03.51 server The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2004/11/04 09:44:03.60 server Recovering database 'sybsystemprocs'.
00:00000:00001:2004/11/04 09:44:04.37 server The transaction log in the database 'sybsystemprocs' will use I/O size of 2 Kb.
00:00000:00001:2004/11/04 09:44:04.39 server Database 'sybsystemprocs' is now online.
00:00000:00001:2004/11/04 09:44:04.46 server Recovering database 'sybsyntax'.
00:00000:00001:2004/11/04 09:44:04.56 server The transaction log in the database 'sybsyntax' will use I/O size of 2 Kb.
00:00000:00001:2004/11/04 09:44:04.57 server Database 'sybsyntax' is now online.
00:00000:00001:2004/11/04 09:44:04.59 server Recovering database 'pubs2'.
00:00000:00001:2004/11/04 09:44:04.67 server The transaction log in the database 'pubs2' will use I/O size of 2 Kb.
00:00000:00001:2004/11/04 09:44:04.68 server Database 'pubs2' is now online.
00:00000:00001:2004/11/04 09:44:04.70 server Recovering database 'pubs3'.
00:00000:00001:2004/11/04 09:44:04.93 server The transaction log in the database 'pubs3' will use I/O size of 2 Kb.
00:00000:00001:2004/11/04 09:44:04.96 server Database 'pubs3' is now online.
00:00000:00001:2004/11/04 09:44:05.00 server Recovering database 'intranet'.
00:00000:00001:2004/11/04 09:44:23.34 server The transaction log in the database 'intranet' will use I/O size of 2 Kb.
00:00000:00001:2004/11/04 09:44:23.35 server Database 'intranet' is now online.
00:00000:00001:2004/11/04 09:44:23.35 server Recovery complete.
00:00000:00001:2004/11/04 09:44:23.35 server SQL Server's default sort order is:
00:00000:00001:2004/11/04 09:44:23.35 server 'bin_iso_1' (ID = 50)
00:00000:00001:2004/11/04 09:44:23.35 server on top of default character set:
00:00000:00001:2004/11/04 09:44:23.35 server 'iso_1' (ID = 1).
00:00000:00001:2004/11/04 09:44:23.35 server Loaded default Unilib conversion handle.

00:00000:00000:2004/11/04 10:11:50.25 kernel nast_readpost: Invalid tdslength (-28528), socket 5, listener 0

<----이부분에서 디비에 접근이 안되어서 재부팅 했습니다.
00:00000:00000:2004/11/04 11:17:10.65 kernel kisignal: SQL Server terminated by system shutdown.
00:00000:00000:2004/11/04 11:17:10.65 kernel ueshutdown: exiting
00:00000:00000:2004/11/04 11:17:10.65 kernel Abnormal exit detected - SQL Server process level execution bindings will be cleared on startup.
00:00000:00000:2004/11/04 11:18:50.79 kernel Using config area from primary master device.
00:00000:00000:2004/11/04 11:18:50.89 kernel Warning: Using default file 'd:\Sybase\CALL.cfg' since a configuration file was not specified. Specify a configuration file name in the RUNSERVER file to avoid this message.
00:00000:00000:2004/11/04 11:18:51.21 kernel Kernel memory at 0x20000000, 260096 bytes
00:00000:00000:2004/11/04 11:18:51.21 kernel Server part of first shared memory region at 0x2003f800, 28070964 bytes
00:00000:00000:2004/11/04 11:18:51.21 kernel Highest valid address is 0x2003f800
00:00000:00000:2004/11/04 11:18:51.21 kernel Using 100000 file descriptors.
00:00000:00000:2004/11/04 11:18:51.76 kernel Adaptive Server Enterprise/11.9.2/1031/P/NT (IX86)/OS 3.51,4.0/FBU/Fri Aug 14 01:42:41 1998
00:00000:00000:2004/11/04 11:18:51.76 kernel Confidential property of Sybase, Inc.
00:00000:00000:2004/11/04 11:18:51.76 kernel Copyright 1987, 1998
00:00000:00000:2004/11/04 11:18:51.76 kernel Sybase, Inc. All rights reserved.
00:00000:00000:2004/11/04 11:18:51.76 kernel Unpublished rights reserved under U.S. copyright laws.
00:00000:00000:2004/11/04 11:18:51.76 kernel
00:00000:00000:2004/11/04 11:18:51.76 kernel This software contains confidential and trade secret information of Sybase,
00:00000:00000:2004/11/04 11:18:51.76 kernel Inc. Use, duplication or disclosure of the software and documentation by
00:00000:00000:2004/11/04 11:18:52.87 kernel the U.S. Government is subject to restrictions set forth in a license
00:00000:00000:2004/11/04 11:18:52.87 kernel agreement between the Government and Sybase, Inc. or other written
00:00000:00000:2004/11/04 11:18:52.87 kernel agreement specifying the Government's rights to use the software and any
00:00000:00000:2004/11/04 11:18:52.87 kernel applicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2004/11/04 11:18:52.87 kernel Sybase, Inc. 6475 Christie Avenue, Emeryville, CA 94608, USA
00:00000:00000:2004/11/04 11:18:52.87 kernel Using 'd:\Sybase\CALL.cfg' for configuration information.
00:00000:00000:2004/11/04 11:18:52.87 kernel Logging SQL Server messages in file 'd:\Sybase\install\errorlog'.
00:00000:00000:2004/11/04 11:18:53.00 kernel Directory Control Layer (DCL) using directory driver: InterfacesDriver
00:00000:00000:2004/11/04 11:18:53.01 kernel SQL Server NT process id is 0x380.
00:00000:00000:2004/11/04 11:18:53.01 kernel SQL Server was started as a Service.
00:00000:00000:2004/11/04 11:18:53.01 kernel Network and device connection limit is 99992.
00:00000:00000:2004/11/04 11:18:53.06 server Number of proc buffers allocated: 1181.
00:00000:00000:2004/11/04 11:18:53.14 server Proc header memory allocated 590 pages for each per engine cache
00:00000:00000:2004/11/04 11:18:53.14 server Number of blocks left for proc headers: 1226.
00:00000:00000:2004/11/04 11:18:53.14 server Memory allocated for the default data cache cache: 8876 Kb
00:00000:00000:2004/11/04 11:18:53.14 server Size of the 2K memory pool: 8876 Kb
00:00000:00000:2004/11/04 11:18:53.17 kernel Initializing virtual device 0, 'd:\Sybase\DATA\MASTER.DAT'
00:00000:00000:2004/11/04 11:18:53.17 kernel Virtual device 0 started using asynchronous i/o.
00:00000:00000:2004/11/04 11:18:53.17 kernel Worker Thread Manager is not enabled for use in SQL Server.
00:00000:00000:2004/11/04 11:18:53.17 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:2004/11/04 11:18:53.20 kernel engine 0, os pid 172 online
00:00000:00000:2004/11/04 11:18:53.20 server No active traceflags
00:00000:00001:2004/11/04 11:18:53.35 server Opening Master Database ...
00:00000:00001:2004/11/04 11:18:58.39 server Loading SQL Server's default sort order and character set
00:00000:00003:2004/11/04 11:18:58.42 kernel network name developsvr, type ether, port 5000
00:00000:00004:2004/11/04 11:18:58.42 kernel network name 221.148.249.196, type ether, port 5000
00:00000:00001:2004/11/04 11:18:58.46 server Recovering database 'master'
00:00000:00001:2004/11/04 11:18:58.64 server Redo pass of recovery has processed 1 committed and 0 aborted transactions.
00:00000:00001:2004/11/04 11:18:58.90 server Database 'master' is now online.
00:00000:00001:2004/11/04 11:18:58.90 server The transaction log in the database 'master' will use I/O size of 2 Kb.
00:00000:00001:2004/11/04 11:18:58.92 server 0 dump conditions detected at boot time
00:00000:00001:2004/11/04 11:18:58.93 server server is unnamed
00:00000:00001:2004/11/04 11:18:58.93 server Activating disk 'intranet_dev'.
00:00000:00001:2004/11/04 11:18:58.93 kernel Initializing virtual device 2, 'd:\db_device\intranet_dev.dat'
00:00000:00001:2004/11/04 11:18:58.95 kernel Virtual device 2 started using asynchronous i/o.
00:00000:00001:2004/11/04 11:18:58.95 server Activating disk 'intranet_log'.
00:00000:00001:2004/11/04 11:18:58.95 kernel Initializing virtual device 3, 'd:\db_device\intranet_log.dat'
00:00000:00001:2004/11/04 11:18:58.95 kernel Virtual device 3 started using asynchronous i/o.
00:00000:00001:2004/11/04 11:18:58.95 server Activating disk 'sysprocsdev'.
00:00000:00001:2004/11/04 11:18:58.95 kernel Initializing virtual device 1, 'd:\Sybase\DATA\SYBPROCS.DAT'
00:00000:00001:2004/11/04 11:18:58.96 kernel Virtual device 1 started using asynchronous i/o.
00:00000:00001:2004/11/04 11:18:59.12 server Recovering database 'model'.
00:00000:00001:2004/11/04 11:18:59.20 server The transaction log in the database 'model' will use I/O size of 2 Kb.
00:00000:00001:2004/11/04 11:18:59.21 server Database 'model' is now online.
00:00000:00001:2004/11/04 11:18:59.21 server Clearing temp db
00:00000:00001:2004/11/04 11:19:00.31 server The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2004/11/04 11:19:00.39 server The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2004/11/04 11:19:00.40 server Database 'tempdb' is now online.
00:00000:00001:2004/11/04 11:19:00.40 server The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2004/11/04 11:19:00.43 server Recovering database 'sybsystemprocs'.
00:00000:00001:2004/11/04 11:19:01.14 server The transaction log in the database 'sybsystemprocs' will use I/O size of 2 Kb.
00:00000:00001:2004/11/04 11:19:01.15 server Database 'sybsystemprocs' is now online.
00:00000:00001:2004/11/04 11:19:01.21 server Recovering database 'sybsyntax'.
00:00000:00001:2004/11/04 11:19:01.29 server The transaction log in the database 'sybsyntax' will use I/O size of 2 Kb.
00:00000:00001:2004/11/04 11:19:01.31 server Database 'sybsyntax' is now online.
00:00000:00001:2004/11/04 11:19:01.32 server Recovering database 'pubs2'.
00:00000:00001:2004/11/04 11:19:01.40 server The transaction log in the database 'pubs2' will use I/O size of 2 Kb.
00:00000:00001:2004/11/04 11:19:01.40 server Database 'pubs2' is now online.
00:00000:00001:2004/11/04 11:19:01.42 server Recovering database 'pubs3'.
00:00000:00001:2004/11/04 11:19:01.50 server The transaction log in the database 'pubs3' will use I/O size of 2 Kb.
00:00000:00001:2004/11/04 11:19:01.51 server Database 'pubs3' is now online.
00:00000:00001:2004/11/04 11:19:01.53 server Recovering database 'intranet'.
00:00000:00001:2004/11/04 11:19:01.60 server Redo pass of recovery has processed 4 committed and 0 aborted transactions.
00:00000:00001:2004/11/04 11:19:21.12 server The transaction log in the database 'intranet' will use I/O size of 2 Kb.
00:00000:00001:2004/11/04 11:19:21.15 server Database 'intranet' is now online.
00:00000:00001:2004/11/04 11:19:21.15 server Recovery complete.
00:00000:00001:2004/11/04 11:19:21.15 server SQL Server's default sort order is:
00:00000:00001:2004/11/04 11:19:21.15 server 'bin_iso_1' (ID = 50)
00:00000:00001:2004/11/04 11:19:21.15 server on top of default character set:
00:00000:00001:2004/11/04 11:19:21.15 server 'iso_1' (ID = 1).
00:00000:00001:2004/11/04 11:19:21.15 server Loaded default Unilib conversion handle.

os win 2000 이고요 php4.3 와 연동 odbc로 사용중인데요...하루 10정도는 디비가 멈쳐요...sybase 버젼은 11.9.2입니다.

사내 사원이 100명이 인데 컨넥션 수도 120 으로 늘려주고...다 해봐도 안되네요....

도대체 뭐가 문제 일까요..... 답변좀...혹시 디비에 접속해 있는 사용자 라던지..컨넥션 수 같은거 알수

있을까요??

명괘한 답변 부탁 드릴께요.....

이 글에 대한 댓글이 총 2건 있습니다.

혹시 web서버 쪽에 설치된 jdbc버젼이 5.5이상이 아닌가요?

버젼 5이상이면 TDS버젼이 틀려서 그럴수 있으니까..4.x대로 낮춰주시고요...

file descripter가 10000이나 하신거 보니 반복적으로 끊고 연결하는 부분이 많으신것

같군요

연결 안될때 netstat -a해서 5000번 port를 물고 있는 애들(특히 time_wait나 close_wait) 갯수가 몇개인지 확인해보세요..

그리고 혹시 CIS사용하시는지요, 또 keepalivetime은 얼마로 설정이 되어 있는지요?

그리고 log file올리실떄 IP하고 port정보는 지우고 올리세요...

수고하세요..

지연님이 2004-11-04 16:03에 작성한 댓글입니다. Edit Ｘ

사이베이스 에러로그 상태로보아 DB에는 전혀 이상이 없어 보입니다.

isql 로 DB login후 sp_who로 연결되어 있는 사용자를 조회 하시고 sp_lock으로

현재 작업중이 spid 가 lock을 물고 있지는 않나 주의 깊게 보세요.

반복적으로 sp_lock을 수행시 계속적으로 나타나는 spid가 있으면 의심해 보아야 겠지요..

사이베이스는 lock sleep이라고 하는데 오라클에서는 blocking이라고 하지요.

하나의 session(spid)이 특정 테이블, 특정 page(row)에 lock을 hold(exclusive lock)

하는 경우 다른 session에서 이를 읽으려면 select등 어떤 Query에서 대기가 발생되지요.

lock을 유발한 session을 kill하면 되지만 그 트랜잭션은 rollback 되겠지요..

이 현상이라면 프로그램 잘못.

long transaction의 프로그램이나 트랜잭션에서 즉시 commit/rollback이 되지 않은 탓

입니다.

물론 index를 타지 못해 full scan하는 경우도 이와 같은 현상이 나타 납니다.

이외 원인은 많이 있지요...

현재 사용 중인 사용자 검색 : sp_who

락상태 파악 : sp_lock

많은사랑(haha1010)님이 2004-11-05 18:02에 작성한 댓글입니다.
이 댓글은 2004-11-06 09:42에 마지막으로 수정되었습니다.

[Top]

No.	제목	작성자	작성일	조회
1009	sybase의 기본도 없습니다... 뭘 여쭤바야할지도 [3]	왕초보	2004-11-04	7164
1008	쿼리 좀 부탁 드립니다. [1]	오우석	2004-11-04	5097
1007	로컬변수를 배열로 만드는 방법??? [3]	박명주	2004-11-04	4697
1006	너무 자주 디비에 접근이 안되요.... [2]	성호	2004-11-04	7230
1005	자주 디비가 멈쳐요...원인과 대체 방법좀 가르켜 주세요...부탁합니다.~~ [1]	진성호	2004-11-03	5542
1004	(질문)text 칼럼에서의 검색시... [2]	궁금	2004-11-03	4823
1003	쿼리좀 분석해주세요... [2]	김동수	2004-11-02	5542

작업시간: 0.022초, 이곳 서비스는
PostgreSQL v16.2로 자료를 관리합니다