database.sarang.net
UserID
Passwd
Database
DBMS
MySQL
PostgreSQL
Firebird
Oracle
Informix
ㆍSybase
MS-SQL
DB2
Cache
CUBRID
LDAP
ALTIBASE
Tibero
DB 문서들
스터디
Community
공지사항
자유게시판
구인|구직
DSN 갤러리
도움주신분들
Admin
운영게시판
최근게시물
Sybase Q&A 1005 게시물 읽기
No. 1005
자주 디비가 멈쳐요...원인과 대체 방법좀 가르켜 주세요...부탁합니다.~~
작성자
진성호
작성일
2004-11-03 20:42
조회수
5,542

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.

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

당연히 멈추겠네요...(실제 멈추는건 아니고 신규 연결만 안되는거죠)

 

 

Error messages를 보시면 1601이 나오죠

 

 

user수가 초과 되어서 그렇습니다

 

 

sp_configure 'number of user connections' 해보시면

 

user 수가 나옵니다....

 

이걸 늘려주심 됩니다.

 

sp_configure 'number of user connections',원하는 유저수

 

지연님이 2004-11-04 09:20에 작성한 댓글입니다. Edit
[Top]
No.
제목
작성자
작성일
조회
1008쿼리 좀 부탁 드립니다. [1]
오우석
2004-11-04
5097
1007로컬변수를 배열로 만드는 방법??? [3]
박명주
2004-11-04
4697
1006너무 자주 디비에 접근이 안되요.... [2]
성호
2004-11-04
7229
1005자주 디비가 멈쳐요...원인과 대체 방법좀 가르켜 주세요...부탁합니다.~~ [1]
진성호
2004-11-03
5542
1004(질문)text 칼럼에서의 검색시... [2]
궁금
2004-11-03
4823
1003쿼리좀 분석해주세요... [2]
김동수
2004-11-02
5542
1002sybase용 jdbc입니다.
캬캬
2004-10-29
5106
Valid XHTML 1.0!
All about the DATABASE... Copyleft 1999-2024 DSN, All rights reserved.
작업시간: 0.022초, 이곳 서비스는
	PostgreSQL v16.2로 자료를 관리합니다