windows 2000에서요 php와 연동 하여 웹서비스를 odbc를 이용하여
사용 하고 잇는데요...
자주 디비가 멈쳐요.... errerlog의 내용을 보면 아래와
같습니다.
주로...로그인많이 하는 시간대에....멈추는것 같아요....뭐가 문제
일까요??
답변 부탁드릴께요~~~ 꼭 부탁해요~~ 꾸벅 꾸벅..
00:00000:00001:2004/11/03 18:03:51.40 server Activating disk
'intranet_dev'.
00:00000:00001:2004/11/03 18:03:51.40 kernel Initializing virtual
device 2, 'd:\db_device\intranet_dev.dat'
00:00000:00001:2004/11/03 18:03:51.42 kernel Virtual device 2
started using asynchronous i/o.
00:00000:00001:2004/11/03 18:03:51.42 server Activating disk
'intranet_log'.
00:00000:00001:2004/11/03 18:03:51.42 kernel Initializing virtual
device 3, 'd:\db_device\intranet_log.dat'
00:00000:00001:2004/11/03 18:03:51.43 kernel Virtual device 3
started using asynchronous i/o.
00:00000:00001:2004/11/03 18:03:51.43 server Activating disk
'sysprocsdev'.
00:00000:00001:2004/11/03 18:03:51.43 kernel Initializing virtual
device 1, 'd:\Sybase\DATA\SYBPROCS.DAT'
00:00000:00001:2004/11/03 18:03:51.45 kernel Virtual device 1
started using asynchronous i/o.
00:00000:00001:2004/11/03 18:03:52.10 server Recovering database
'model'.
00:00000:00001:2004/11/03 18:03:52.43 server The transaction log
in the database 'model' will use I/O size of 2 Kb.
00:00000:00001:2004/11/03 18:03:52.53 server Database 'model' is
now online.
00:00000:00001:2004/11/03 18:03:52.53 server Clearing temp
db
00:00000:00001:2004/11/03 18:03:53.92 server The transaction log
in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2004/11/03 18:03:54.00 server The transaction log
in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2004/11/03 18:03:54.01 server Database 'tempdb' is
now online.
00:00000:00001:2004/11/03 18:03:54.01 server The transaction log
in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2004/11/03 18:03:54.09 server Recovering database
'sybsystemprocs'.
00:00000:00001:2004/11/03 18:03:54.73 server The transaction log
in the database 'sybsystemprocs' will use I/O size of 2 Kb.
00:00000:00001:2004/11/03 18:03:54.75 server Database
'sybsystemprocs' is now online.
00:00000:00001:2004/11/03 18:03:54.82 server Recovering database
'sybsyntax'.
00:00000:00001:2004/11/03 18:03:55.25 server The transaction log
in the database 'sybsyntax' will use I/O size of 2 Kb.
00:00000:00001:2004/11/03 18:03:55.29 server Database 'sybsyntax'
is now online.
00:00000:00001:2004/11/03 18:03:55.32 server Recovering database
'pubs2'.
00:00000:00001:2004/11/03 18:03:55.40 server The transaction log
in the database 'pubs2' will use I/O size of 2 Kb.
00:00000:00001:2004/11/03 18:03:55.40 server Database 'pubs2' is
now online.
00:00000:00001:2004/11/03 18:03:55.43 server Recovering database
'pubs3'.
00:00000:00001:2004/11/03 18:03:55.51 server The transaction log
in the database 'pubs3' will use I/O size of 2 Kb.
00:00000:00001:2004/11/03 18:03:55.53 server Database 'pubs3' is
now online.
00:00000:00001:2004/11/03 18:03:55.54 server Recovering database
'intranet'.
00:00000:00001:2004/11/03 18:03:55.64 server Redo pass of recovery
has processed 5 committed and 0 aborted transactions.
00:00000:00001:2004/11/03 18:04:14.65 server The transaction log
in the database 'intranet' will use I/O size of 2 Kb.
00:00000:00001:2004/11/03 18:04:14.67 server Database 'intranet'
is now online.
00:00000:00001:2004/11/03 18:04:14.67 server Recovery
complete.
00:00000:00001:2004/11/03 18:04:14.67 server SQL Server's default
sort order is:
00:00000:00001:2004/11/03 18:04:14.67 server 'bin_iso_1' (ID =
50)
00:00000:00001:2004/11/03 18:04:14.67 server on top of default
character set:
00:00000:00001:2004/11/03 18:04:14.67 server 'iso_1' (ID =
1).
00:00000:00001:2004/11/03 18:04:14.67 server Loaded default Unilib
conversion handle.
<-----이부분에서 멈쳤음.
00:00000:00000:2004/11/03 18:38:38.10 kernel nast_readpost:
Invalid tdslength (-28528), socket 3, listener 0
00:00000:00002:2004/11/03 18:56:11.45 server Error: 1601,
Severity: 21, State: 3
00:00000:00002:2004/11/03 18:56:11.45 server There are not enough
'user connections' available to start a new process. Retry when
there are fewer active users, or ask your System Administrator to
reconfigure SQL Server with more user connections.
00:00000:00004:2004/11/03 18:56:11.46 server Error: 1601,
Severity: 21, State: 3
00:00000:00004:2004/11/03 18:56:11.46 server There are not enough
'user connections' available to start a new process. Retry when
there are fewer active users, or ask your System Administrator to
reconfigure SQL Server with more user connections.
00:00000:00002:2004/11/03 18:56:49.60 server Error: 1601,
Severity: 21, State: 3
00:00000:00002:2004/11/03 18:56:49.60 server There are not enough
'user connections' available to start a new process. Retry when
there are fewer active users, or ask your System Administrator to
reconfigure SQL Server with more user connections.
00:00000:00002:2004/11/03 18:56:53.07 server Error: 1601,
Severity: 21, State: 3
00:00000:00002:2004/11/03 18:56:53.07 server There are not enough
'user connections' available to start a new process. Retry when
there are fewer active users, or ask your System Administrator to
reconfigure SQL Server with more user connections.
00:00000:00002:2004/11/03 19:00:17.18 server Error: 1601,
Severity: 21, State: 3
00:00000:00002:2004/11/03 19:00:17.18 server There are not enough
'user connections' available to start a new process. Retry when
there are fewer active users, or ask your System Administrator to
reconfigure SQL Server with more user connections.
00:00000:00002:2004/11/03 19:00:27.10 server Error: 1601,
Severity: 21, State: 3
00:00000:00002:2004/11/03 19:00:27.10 server There are not enough
'user connections' available to start a new process. Retry when
there are fewer active users, or ask your System Administrator to
reconfigure SQL Server with more user connections.
00:00000:00002:2004/11/03 19:03:44.96 server Error: 1601,
Severity: 21, State: 3
00:00000:00002:2004/11/03 19:03:44.96 server There are not enough
'user connections' available to start a new process. Retry when
there are fewer active users, or ask your System Administrator to
reconfigure SQL Server with more user connections.
00:00000:00002:2004/11/03 19:03:48.04 server Error: 1601,
Severity: 21, State: 3
00:00000:00002:2004/11/03 19:03:48.04 server There are not enough
'user connections' available to start a new process. Retry when
there are fewer active users, or ask your System Administrator to
reconfigure SQL Server with more user connections.
00:00000:00002:2004/11/03 19:03:50.34 server Error: 1601,
Severity: 21, State: 3
00:00000:00002:2004/11/03 19:03:50.34 server There are not enough
'user connections' available to start a new process. Retry when
there are fewer active users, or ask your System Administrator to
reconfigure SQL Server with more user connections.
00:00000:00002:2004/11/03 19:04:20.32 server Error: 1601,
Severity: 21, State: 3
00:00000:00002:2004/11/03 19:04:20.32 server There are not enough
'user connections' available to start a new process. Retry when
there are fewer active users, or ask your System Administrator to
reconfigure SQL Server with more user connections.
00:00000:00002:2004/11/03 19:05:36.84 server Error: 1601,
Severity: 21, State: 3
00:00000:00002:2004/11/03 19:05:36.84 server There are not enough
'user connections' available to start a new process. Retry when
there are fewer active users, or ask your System Administrator to
reconfigure SQL Server with more user connections.
00:00000:00002:2004/11/03 19:06:13.60 server Error: 1601,
Severity: 21, State: 3
00:00000:00002:2004/11/03 19:06:13.60 server There are not enough
'user connections' available to start a new process. Retry when
there are fewer active users, or ask your System Administrator to
reconfigure SQL Server with more user connections.
00:00000:00002:2004/11/03 19:06:17.46 server Error: 1601,
Severity: 21, State: 3
00:00000:00002:2004/11/03 19:06:17.46 server There are not enough
'user connections' available to start a new process. Retry when
there are fewer active users, or ask your System Administrator to
reconfigure SQL Server with more user connections.
00:00000:00002:2004/11/03 19:17:21.15 server Error: 1601,
Severity: 21, State: 3
00:00000:00002:2004/11/03 19:17:21.15 server There are not enough
'user connections' available to start a new process. Retry when
there are fewer active users, or ask your System Administrator to
reconfigure SQL Server with more user connections.
00:00000:00002:2004/11/03 19:22:15.10 server Error: 1601,
Severity: 21, State: 3
00:00000:00002:2004/11/03 19:22:15.10 server There are not enough
'user connections' available to start a new process. Retry when
there are fewer active users, or ask your System Administrator to
reconfigure SQL Server with more user connections.
00:00000:00002:2004/11/03 19:22:22.78 server Error: 1601,
Severity: 21, State: 3
00:00000:00002:2004/11/03 19:22:22.78 server There are not enough
'user connections' available to start a new process. Retry when
there are fewer active users, or ask your System Administrator to
reconfigure SQL Server with more user connections.
00:00000:00002:2004/11/03 19:29:05.92 server Error: 1601,
Severity: 21, State: 3
00:00000:00002:2004/11/03 19:29:05.92 server There are not enough
'user connections' available to start a new process. Retry when
there are fewer active users, or ask your System Administrator to
reconfigure SQL Server with more user connections.
00:00000:00002:2004/11/03 19:30:14.39 server Error: 1601,
Severity: 21, State: 3
00:00000:00002:2004/11/03 19:30:14.39 server There are not enough
'user connections' available to start a new process. Retry when
there are fewer active users, or ask your System Administrator to
reconfigure SQL Server with more user connections.
00:00000:00002:2004/11/03 19:35:28.40 server Error: 1601,
Severity: 21, State: 3
00:00000:00002:2004/11/03 19:35:28.40 server There are not enough
'user connections' available to start a new process. Retry when
there are fewer active users, or ask your System Administrator to
reconfigure SQL Server with more user connections.
00:00000:00002:2004/11/03 19:35:46.14 server Error: 1601,
Severity: 21, State: 3
00:00000:00002:2004/11/03 19:35:46.14 server There are not enough
'user connections' available to start a new process. Retry when
there are fewer active users, or ask your System Administrator to
reconfigure SQL Server with more user connections.
00:00000:00002:2004/11/03 19:36:07.06 server Error: 1601,
Severity: 21, State: 3
00:00000:00002:2004/11/03 19:36:07.06 server There are not enough
'user connections' available to start a new process. Retry when
there are fewer active users, or ask your System Administrator to
reconfigure SQL Server with more user connections.
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.
|