免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
12下一页
最近访问板块 发新帖
查看: 8836 | 回复: 18

Error: 1605出错,如何处理? [复制链接]

论坛徽章:
0
发表于 2010-07-29 12:31 |显示全部楼层
系统环境:
WIN2000ADV SP4
ASE12.5.0.2/EBF 10752 ESD#1
2CPU 2GB内存

此前系统运行一直正常,最近开始连续报错如下:
01:00000:00002:2010/07/29 12:25:35.00 server  Error: 1605, Severity: 18, State: 1
01:00000:00002:2010/07/29 12:25:35.00 server  Failed to open virtual socket for new connections

该如何调整系统配置?

论坛徽章:
6
水瓶座
日期:2014-06-04 03:34:37水瓶座
日期:2014-06-17 13:20:31数据库技术版块每日发帖之星
日期:2016-07-09 06:20:00数据库技术版块每日发帖之星
日期:2016-07-17 06:20:00数据库技术版块每日发帖之星
日期:2016-08-01 06:20:00数据库技术版块每日发帖之星
日期:2016-08-04 06:20:00
发表于 2010-07-29 12:38 |显示全部楼层
请帖详细的信息。 这两句错误之前的信息是什么?


看看调整参数:number of open objects  number of user connections 试试

论坛徽章:
0
发表于 2010-07-29 12:47 |显示全部楼层
00:00000:00000:2010/07/29 12:12:43.67 kernel  Use license file c:\sybase\SYSAM-1_0\licenses\license.dat.
00:00000:00000:2010/07/29 12:12:43.73 kernel  Checked out license ASE_SERVER
00:00000:00000:2010/07/29 12:12:43.75 kernel  Adaptive Server Enterprise Edition
00:00000:00000:2010/07/29 12:12:44.15 kernel  Using config area from primary master device.
00:00000:00000:2010/07/29 12:12:44.20 kernel  Warning: Using default file 'c:\sybase\eahisxs.cfg' since a configuration file was not specified. Specify a configuration file name in the RUNSERVER file to avoid this message.
00:00000:00000:2010/07/29 12:12:45.92 kernel  NT operating system error 87 in module 'e:\rel1250x\porttree\svr\sql\nt386\ksource\blkmem\osmntmmap.c' at line 467: 参数错误。 .
00:00000:00000:2010/07/29 12:12:45.93 kernel  os_create_region: Failed to get virtual memory information.
00:00000:00000:2010/07/29 12:12:45.93 kernel  kbcreate: couldn't create server region 5.
00:00000:00000:2010/07/29 12:12:45.93 kernel  kistartup: could not create shared memory
00:00000:00000:2010/07/29 12:12:45.95 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:12:45.95 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:12:45.95 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:12:45.95 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:12:45.95 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:12:45.95 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:12:45.95 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:12:45.95 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:12:45.95 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:12:45.95 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:12:45.95 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:12:45.95 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:12:45.95 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:12:45.95 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:12:45.95 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:12:45.95 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:12:45.95 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:12:45.95 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:12:45.95 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:12:45.95 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:12:45.95 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:12:45.95 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:12:45.95 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:12:45.95 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:12:45.95 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:12:45.95 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:12:45.95 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:12:45.95 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:12:45.95 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:12:45.95 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:12:45.95 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:12:45.95 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:12:45.95 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:12:45.95 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:12:45.95 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:12:45.95 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:12:45.95 kernel  FATAL: NULL Pss on STACK_OVERFLOW
00:00000:00000:2010/07/29 12:13:23.43 kernel  Use license file c:\sybase\SYSAM-1_0\licenses\license.dat.

论坛徽章:
6
水瓶座
日期:2014-06-04 03:34:37水瓶座
日期:2014-06-17 13:20:31数据库技术版块每日发帖之星
日期:2016-07-09 06:20:00数据库技术版块每日发帖之星
日期:2016-07-17 06:20:00数据库技术版块每日发帖之星
日期:2016-08-01 06:20:00数据库技术版块每日发帖之星
日期:2016-08-04 06:20:00
发表于 2010-07-29 12:48 |显示全部楼层
00:00000:00000:2010/07/29 12:12:45.93 kernel  os_create_region: Failed to get virtual memory information.
00:00000:00000:2010/07/29 12:12:45.93 kernel  kbcreate: couldn't create server region 5.
00:00000:00000:2010/07/29 12:12:45.93 kernel  kistartup: could not create shared memory


系统启动起来了?

论坛徽章:
0
发表于 2010-07-29 12:48 |显示全部楼层
00:00000:00000:2010/07/29 12:13:23.43 kernel  Checked out license ASE_SERVER
00:00000:00000:2010/07/29 12:13:23.43 kernel  Adaptive Server Enterprise Edition
00:00000:00000:2010/07/29 12:13:23.45 kernel  Using config area from primary master device.
00:00000:00000:2010/07/29 12:13:23.45 kernel  Warning: Using default file 'c:\sybase\eahisxs.cfg' since a configuration file was not specified. Specify a configuration file name in the RUNSERVER file to avoid this message.
00:00000:00000:2010/07/29 12:13:25.14 kernel  NT operating system error 87 in module 'e:\rel1250x\porttree\svr\sql\nt386\ksource\blkmem\osmntmmap.c' at line 467: 参数错误。 .
00:00000:00000:2010/07/29 12:13:25.14 kernel  os_create_region: Failed to get virtual memory information.
00:00000:00000:2010/07/29 12:13:25.14 kernel  kbcreate: couldn't create server region 5.
00:00000:00000:2010/07/29 12:13:25.14 kernel  kistartup: could not create shared memory
00:00000:00000:2010/07/29 12:13:25.14 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:13:25.14 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:13:25.14 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:13:25.14 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:13:25.14 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:13:25.14 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:13:25.14 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:13:25.14 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:13:25.14 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:13:25.14 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:13:25.14 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:13:25.14 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:13:25.14 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:13:25.14 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:13:25.14 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:13:25.14 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:13:25.14 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:13:25.14 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:13:25.14 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:13:25.14 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:13:25.14 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:13:25.14 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:13:25.14 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:13:25.14 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:13:25.14 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:13:25.14 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:13:25.14 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:13:25.14 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:13:25.14 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:13:25.14 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:13:25.14 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:13:25.14 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:13:25.14 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:13:25.14 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:13:25.14 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:13:25.14 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2010/07/29 12:13:25.15 kernel  FATAL: NULL Pss on STACK_OVERFLOW
00:00000:00000:2010/07/29 12:17:04.07 kernel  Use license file c:\sybase\SYSAM-1_0\licenses\license.dat.
00:00000:00000:2010/07/29 12:17:04.07 kernel  Checked out license ASE_SERVER
00:00000:00000:2010/07/29 12:17:04.07 kernel  Adaptive Server Enterprise Edition
00:00000:00000:2010/07/29 12:17:04.07 kernel  Using config area from primary master device.
00:00000:00000:2010/07/29 12:17:04.09 kernel  Warning: Using default file 'c:\sybase\eahisxs.cfg' since a configuration file was not specified. Specify a configuration file name in the RUNSERVER file to avoid this message.
00:00000:00000:2010/07/29 12:17:05.79 kernel  Using 100000 file descriptors.
00:00000:00000:2010/07/29 12:17:05.92 kernel  Adaptive Server Enterprise/12.5.0.2/EBF 10752 ESD#1/P/NT (IX86)/OS 4.0/rel12502/1867/32-bit/OPT/Sun Dec 15 02:27:45 2002
00:00000:00000:2010/07/29 12:17:05.92 kernel  Confidential property of Sybase, Inc.
00:00000:00000:2010/07/29 12:17:05.92 kernel  Copyright 1987, 2002
00:00000:00000:2010/07/29 12:17:05.92 kernel  Sybase, Inc.  All rights reserved.
00:00000:00000:2010/07/29 12:17:05.92 kernel  Unpublished rights reserved under U.S. copyright laws.
00:00000:00000:2010/07/29 12:17:05.92 kernel  
00:00000:00000:2010/07/29 12:17:05.92 kernel  This software contains confidential and trade secret information of Sybase,
00:00000:00000:2010/07/29 12:17:05.92 kernel  Inc.   Use,  duplication or disclosure of the software and documentation by
00:00000:00000:2010/07/29 12:17:05.92 kernel  the  U.S.  Government  is  subject  to  restrictions set forth in a license
00:00000:00000:2010/07/29 12:17:05.92 kernel  agreement  between  the  Government  and  Sybase,  Inc.  or  other  written
00:00000:00000:2010/07/29 12:17:05.92 kernel  agreement  specifying  the  Government's rights to use the software and any
00:00000:00000:2010/07/29 12:17:05.92 kernel  applicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2010/07/29 12:17:05.92 kernel  Sybase, Inc. One Sybase Drive, Dublin, CA 94568, USA
00:00000:00000:2010/07/29 12:17:05.92 kernel  Using 'c:\sybase\eahisxs.cfg' for configuration information.
00:00000:00000:2010/07/29 12:17:05.92 kernel  Logging ASE messages in file 'c:\sybase\ASE-12_5\install\errorlog'.
00:00000:00000:2010/07/29 12:17:05.93 kernel  Initializing MSDTC Connection
00:00000:00000:2010/07/29 12:17:07.20 kernel  MSDTC Initialization succeeded
00:00000:00000:2010/07/29 12:17:07.20 kernel  kdcl_sess_open: connectivity library supports master/query syntax.
00:00000:00000:2010/07/29 12:17:07.21 kernel  Directory Control Layer (DCL) using directory driver: InterfacesDriver
00:00000:00000:2010/07/29 12:17:07.21 kernel  *** WARNING ******************
00:00000:00000:2010/07/29 12:17:07.21 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:2010/07/29 12:17:07.21 kernel  SQL Server NT process id is 0x8ac.
00:00000:00000:2010/07/29 12:17:07.21 kernel  SQL Server was started as a Service.
00:00000:00000:2010/07/29 12:17:07.21 kernel  SSL Plus v3.0.9 security modules loaded successfully.
00:00000:00000:2010/07/29 12:17:07.21 kernel  Network and device connection limit is 99992.
00:00000:00000:2010/07/29 12:17:07.84 server  Number of blocks left for proc headers: 102352.
00:00000:00000:2010/07/29 12:17:07.85 server  Proc header memory allocated 17058 pages for each per engine cache
00:00000:00000:2010/07/29 12:17:08.96 server  Memory allocated for the default data cache cachelet 1: 1024000 Kb
00:00000:00000:2010/07/29 12:17:09.04 server  Size of the 2K memory pool: 1023996 Kb
00:00000:00000:2010/07/29 12:17:09.04 kernel  Initializing virtual device 0, 'z:\data\master.dat' with dsync 'on'.
00:00000:00000:2010/07/29 12:17:09.06 kernel  Virtual device 0 started using asynchronous i/o.
00:00000:00000:2010/07/29 12:17:09.06 kernel  Worker Thread Manager is not enabled for use in SQL Server.
00:00000:00000:2010/07/29 12:17:09.06 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:2010/07/29 12:17:09.14 kernel  engine 0, os pid 256  online
00:00000:00000:2010/07/29 12:17:09.15 server  No active traceflags
00:00000:00001:2010/07/29 12:17:09.26 kernel  Component Integration Services loaded; version 'Component Integration Services/12.5.0.2/EBF 10752 ESD#1/P/NT (IX86)/OS 4.0/rel12502/1867/32-bit/OPT/Sun Dec 15 02:27:45 2002'.
00:00000:00001:2010/07/29 12:17:09.26 kernel  Component Integration Services: using 'Sybase Client-Library/12.5/P-EBF10419/PC Intel/BUILD125-015/OPT/Wed Jul 03 10:38:06 2002'
00:00000:00001:2010/07/29 12:17:09.26 server  Opening Master Database ...
00:00000:00001:2010/07/29 12:17:09.64 server  Loading SQL Server's default sort order and character set
00:00000:00001:2010/07/29 12:17:09.68 server  Loaded default Unilib conversion handle.
00:00000:00001:2010/07/29 12:17:09.76 server  Recovering database 'master'.
00:00000:00001:2010/07/29 12:17:10.00 server  Checking external objects.
00:00000:00001:2010/07/29 12:17:10.07 server  Database 'master' is now online.
00:00000:00001:2010/07/29 12:17:10.09 server  The transaction log in the database 'master' will use I/O size of 2 Kb.
00:00000:00001:2010/07/29 12:17:10.15 server  Warning: ASE_HA has no valid license and therefore is not initialized.
00:00000:00001:2010/07/29 12:17:10.17 server  server name is 'eahisxs'
00:00000:00001:2010/07/29 12:17:10.18 server  Activating disk 'rssd_data' of size 204800 bytes.
00:00000:00001:2010/07/29 12:17:10.18 kernel  Initializing virtual device 5, 'z:\data\rssd_data.dat' with dsync 'on'.
00:00000:00001:2010/07/29 12:17:10.23 kernel  Virtual device 5 started using asynchronous i/o.
00:00000:00001:2010/07/29 12:17:10.23 server  Activating disk 'rssd_log' of size 102400 bytes.
00:00000:00001:2010/07/29 12:17:10.23 kernel  Initializing virtual device 6, 'z:\data\rssd_log.dat' with dsync 'on'.
00:00000:00001:2010/07/29 12:17:10.25 kernel  Virtual device 6 started using asynchronous i/o.
00:00000:00001:2010/07/29 12:17:10.25 server  Activating disk 'study_data' of size 7987200 bytes.
00:00000:00001:2010/07/29 12:17:10.25 kernel  Initializing virtual device 7, 'z:\data\study_data.dat' with dsync 'on'.
00:00000:00001:2010/07/29 12:17:10.26 kernel  Virtual device 7 started using asynchronous i/o.
00:00000:00001:2010/07/29 12:17:10.26 server  Activating disk 'study_log' of size 6758400 bytes.
00:00000:00001:2010/07/29 12:17:10.26 kernel  Initializing virtual device 8, 'z:\data\study_log.dat' with dsync 'on'.
00:00000:00001:2010/07/29 12:17:10.26 kernel  Virtual device 8 started using asynchronous i/o.
00:00000:00001:2010/07/29 12:17:10.26 server  Activating disk 'sysprocsdev' of size 204800 bytes.
00:00000:00001:2010/07/29 12:17:10.26 kernel  Initializing virtual device 1, 'z:\data\sybprocs.dat' with dsync 'on'.
00:00000:00001:2010/07/29 12:17:10.31 kernel  Virtual device 1 started using asynchronous i/o.
00:00000:00001:2010/07/29 12:17:10.31 server  Activating disk 'szyy_data' of size 7987200 bytes.
00:00000:00001:2010/07/29 12:17:10.31 kernel  Initializing virtual device 3, 'z:\data\szyy_data.dat' with dsync 'on'.
00:00000:00001:2010/07/29 12:17:10.31 kernel  Virtual device 3 started using asynchronous i/o.
00:00000:00001:2010/07/29 12:17:10.31 server  Activating disk 'szyy_data2' of size 2048000 bytes.
00:00000:00001:2010/07/29 12:17:10.31 kernel  Initializing virtual device 9, 'z:\data\szyy_data2.dat' with dsync 'on'.
00:00000:00001:2010/07/29 12:17:10.35 kernel  Virtual device 9 started using asynchronous i/o.
00:00000:00001:2010/07/29 12:17:10.35 server  Activating disk 'szyy_data3' of size 2048000 bytes.
00:00000:00001:2010/07/29 12:17:10.35 kernel  Initializing virtual device 10, 'z:\data\szyy_data3.dat' with dsync 'on'.
00:00000:00001:2010/07/29 12:17:10.42 kernel  Virtual device 10 started using asynchronous i/o.
00:00000:00001:2010/07/29 12:17:10.42 server  Activating disk 'szyy_data4' of size 2048000 bytes.
00:00000:00001:2010/07/29 12:17:10.42 kernel  Initializing virtual device 11, 'z:\data\szyy_data4.dat' with dsync 'on'.
00:00000:00001:2010/07/29 12:17:10.46 kernel  Virtual device 11 started using asynchronous i/o.
00:00000:00001:2010/07/29 12:17:10.46 server  Activating disk 'szyy_data5' of size 4096000 bytes.
00:00000:00001:2010/07/29 12:17:10.46 kernel  Initializing virtual device 12, 'z:\data\szyy_data5.dat' with dsync 'on'.
00:00000:00001:2010/07/29 12:17:10.51 kernel  Virtual device 12 started using asynchronous i/o.
00:00000:00001:2010/07/29 12:17:10.51 server  Activating disk 'szyy_data6' of size 2048000 bytes.
00:00000:00001:2010/07/29 12:17:10.51 kernel  Initializing virtual device 13, 'z:\data\szyy_data6.dat' with dsync 'on'.
00:00000:00001:2010/07/29 12:17:10.56 kernel  Virtual device 13 started using asynchronous i/o.
00:00000:00001:2010/07/29 12:17:10.56 server  Activating disk 'szyy_data7' of size 8192000 bytes.
00:00000:00001:2010/07/29 12:17:10.56 kernel  Initializing virtual device 16, 'z:\data\szyy_data7.dat' with dsync 'on'.
00:00000:00001:2010/07/29 12:17:10.57 kernel  Virtual device 16 started using asynchronous i/o.
00:00000:00001:2010/07/29 12:17:10.57 server  Activating disk 'szyy_his_data1' of size 20275200 bytes.
00:00000:00001:2010/07/29 12:17:10.57 kernel  Initializing virtual device 14, 'z:\data\szyy_his_data1.dat' with dsync 'on'.
00:00000:00001:2010/07/29 12:17:10.57 kernel  Virtual device 14 started using asynchronous i/o.
00:00000:00001:2010/07/29 12:17:10.57 server  Activating disk 'szyy_his_log' of size 6860800 bytes.
00:00000:00001:2010/07/29 12:17:10.57 kernel  Initializing virtual device 15, 'z:\data\szyy_his_log.dat' with dsync 'on'.
00:00000:00001:2010/07/29 12:17:10.59 kernel  Virtual device 15 started using asynchronous i/o.
00:00000:00001:2010/07/29 12:17:10.59 server  Activating disk 'szyy_log' of size 6758400 bytes.
00:00000:00001:2010/07/29 12:17:10.59 kernel  Initializing virtual device 4, 'z:\data\szyy_log.dat' with dsync 'on'.
00:00000:00001:2010/07/29 12:17:10.59 kernel  Virtual device 4 started using asynchronous i/o.
00:00000:00001:2010/07/29 12:17:10.59 server  Activating disk 'szyy_log2' of size 524288 bytes.
00:00000:00001:2010/07/29 12:17:10.59 kernel  Initializing virtual device 17, 'z:\data\szyy_log2.dat' with dsync 'on'.
00:00000:00001:2010/07/29 12:17:10.64 kernel  Virtual device 17 started using asynchronous i/o.
00:00000:00001:2010/07/29 12:17:10.64 server  Activating disk 'szyy_log3' of size 524288 bytes.
00:00000:00001:2010/07/29 12:17:10.64 kernel  Initializing virtual device 18, 'Z:\data\szyy_log3.dat' with dsync 'on'.
00:00000:00001:2010/07/29 12:17:10.68 kernel  Virtual device 18 started using asynchronous i/o.
00:00000:00001:2010/07/29 12:17:10.68 server  Activating disk 'szyy_log4' of size 1048576 bytes.
00:00000:00001:2010/07/29 12:17:10.68 kernel  Initializing virtual device 19, 'z:\data\szyy_log4.dat' with dsync 'on'.
00:00000:00001:2010/07/29 12:17:10.71 kernel  Virtual device 19 started using asynchronous i/o.
00:00000:00001:2010/07/29 12:17:10.71 server  Activating disk 'szyy_log5' of size 1048576 bytes.
00:00000:00001:2010/07/29 12:17:10.71 kernel  Initializing virtual device 20, 'z:\data\szyy_log5.dat' with dsync 'on'.
00:00000:00001:2010/07/29 12:17:10.76 kernel  Virtual device 20 started using asynchronous i/o.
00:00000:00001:2010/07/29 12:17:10.76 server  Activating disk 'tempdev' of size 614400 bytes.
00:00000:00001:2010/07/29 12:17:10.76 kernel  Initializing virtual device 2, 'z:\data\tempdev.dat' with dsync 'on'.
00:00000:00001:2010/07/29 12:17:10.81 kernel  Virtual device 2 started using asynchronous i/o.
00:00000:00001:2010/07/29 12:17:11.06 server  Recovering database 'sybsystemdb'.
00:00000:00001:2010/07/29 12:17:11.18 server  Boot Count: 120

论坛徽章:
0
发表于 2010-07-29 12:50 |显示全部楼层
00:00000:00001:2010/07/29 12:17:11.21 server  Checking external objects.
00:00000:00001:2010/07/29 12:17:11.21 server  The transaction log in the database 'sybsystemdb' will use I/O size of 2 Kb.
00:00000:00001:2010/07/29 12:17:11.32 server  Database 'sybsystemdb' is now online.
00:00000:00001:2010/07/29 12:17:11.39 server  Recovering database 'model'.
00:00000:00001:2010/07/29 12:17:11.51 server  Checking external objects.
00:00000:00001:2010/07/29 12:17:11.53 server  The transaction log in the database 'model' will use I/O size of 2 Kb.
00:00000:00001:2010/07/29 12:17:11.62 server  Database 'model' is now online.
00:00000:00001:2010/07/29 12:17:11.62 server  The logical pagesize of the server is 2 Kb.
00:00000:00001:2010/07/29 12:17:11.62 server  0 dump conditions detected at boot time
00:00000:00001:2010/07/29 12:17:11.62 server  Resident Node id: 91bb6ebb7c46
00:00000:00001:2010/07/29 12:17:11.62 server  Transaction coordinator initialized.
00:00000:00001:2010/07/29 12:17:11.62 server  Clearing temp db
00:00000:00001:2010/07/29 12:17:26.53 server  The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2010/07/29 12:17:26.65 server  Database 'tempdb' is now online.
00:00000:00001:2010/07/29 12:17:26.71 server  Recovering database 'sybsystemprocs'.
00:00000:00001:2010/07/29 12:17:26.85 server  Checking external objects.
00:00000:00001:2010/07/29 12:17:26.87 server  The transaction log in the database 'sybsystemprocs' will use I/O size of 2 Kb.
00:00000:00001:2010/07/29 12:17:26.96 server  Database 'sybsystemprocs' is now online.
00:00000:00002:2010/07/29 12:17:26.96 kernel  network name 129.8.129.1, type ether, port 5000, filter NONE
00:00000:00001:2010/07/29 12:17:27.12 server  Recovering database 'szyy'.
00:00000:00001:2010/07/29 12:17:27.15 server  Redo pass of recovery has processed 0 committed and 1 aborted transactions.
00:00000:00001:2010/07/29 12:17:27.32 server  Checking external objects.
00:00000:00001:2010/07/29 12:17:27.37 server  The transaction log in the database 'szyy' will use I/O size of 2 Kb.
00:00000:00001:2010/07/29 12:17:27.81 server  Database 'szyy' is now online.
00:00000:00001:2010/07/29 12:17:28.04 server  Recovering database 'xsrep_RSSD'.
00:00000:00001:2010/07/29 12:17:28.20 server  Checking external objects.
00:00000:00001:2010/07/29 12:17:28.20 server  The transaction log in the database 'xsrep_RSSD' will use I/O size of 2 Kb.
00:00000:00001:2010/07/29 12:17:28.34 server  Database 'xsrep_RSSD' is now online.
00:00000:00001:2010/07/29 12:17:28.53 server  Recovering database 'study'.
00:00000:00001:2010/07/29 12:17:28.73 server  Checking external objects.
00:00000:00001:2010/07/29 12:17:28.75 server  The transaction log in the database 'study' will use I/O size of 2 Kb.
00:00000:00001:2010/07/29 12:17:28.87 server  Database 'study' is now online.
00:00000:00001:2010/07/29 12:17:29.04 server  Recovering database 'szyy_his'.
00:00000:00001:2010/07/29 12:17:29.20 server  Checking external objects.
00:00000:00001:2010/07/29 12:17:29.20 server  The transaction log in the database 'szyy_his' will use I/O size of 2 Kb.
00:00000:00001:2010/07/29 12:17:29.31 server  Database 'szyy_his' is now online.
00:00000:00001:2010/07/29 12:17:29.34 server  Recovery complete.
00:00000:00001:2010/07/29 12:17:29.34 server  SQL Server's default unicode sort order is 'binary'.
00:00000:00001:2010/07/29 12:17:29.34 server  SQL Server's default sort order is:
00:00000:00001:2010/07/29 12:17:29.34 server          'bin_cp850' (ID = 50)
00:00000:00001:2010/07/29 12:17:29.34 server  on top of default character set:
00:00000:00001:2010/07/29 12:17:29.34 server          'cp850' (ID = 2).
00:00000:00001:2010/07/29 12:17:29.34 server  Master device size: 100 megabytes, or 51200 virtual pages. (A virtual page is 2048 bytes.)
01:00000:00000:2010/07/29 12:17:29.34 kernel  Network and device connection limit is 99992.
01:00000:00000:2010/07/29 12:17:29.34 kernel  engine 1, os pid 2268  online
00:00000:00001:2010/07/29 12:17:29.34 kernel  Use sp_engine procedure to online 1 more new engines.
00:00000:00015:2010/07/29 12:17:29.37 server  Started Rep Agent on database, 'szyy' (dbid = 4).
00:00000:00002:2010/07/29 12:17:52.53 server  Error: 1605, Severity: 18, State: 1
00:00000:00002:2010/07/29 12:17:52.53 server  Failed to open virtual socket for new connections
01:00000:00002:2010/07/29 12:18:34.53 server  Error: 1605, Severity: 18, State: 1
01:00000:00002:2010/07/29 12:18:34.53 server  Failed to open virtual socket for new connections
01:00000:00002:2010/07/29 12:18:34.53 server  Error: 1605, Severity: 18, State: 1
01:00000:00002:2010/07/29 12:18:34.53 server  Failed to open virtual socket for new connections
01:00000:00002:2010/07/29 12:19:16.53 server  Error: 1605, Severity: 18, State: 1
01:00000:00002:2010/07/29 12:19:16.53 server  Failed to open virtual socket for new connections
01:00000:00002:2010/07/29 12:19:16.53 server  Error: 1605, Severity: 18, State: 1
01:00000:00002:2010/07/29 12:19:16.53 server  Failed to open virtual socket for new connections
00:00000:00002:2010/07/29 12:19:58.64 server  Error: 1605, Severity: 18, State: 1
00:00000:00002:2010/07/29 12:19:58.64 server  Failed to open virtual socket for new connections
00:00000:00002:2010/07/29 12:19:58.64 server  Error: 1605, Severity: 18, State: 1
00:00000:00002:2010/07/29 12:19:58.64 server  Failed to open virtual socket for new connections
01:00000:00002:2010/07/29 12:20:40.75 server  Error: 1605, Severity: 18, State: 1
01:00000:00002:2010/07/29 12:20:40.75 server  Failed to open virtual socket for new connections
00:00000:00002:2010/07/29 12:20:40.75 server  Error: 1605, Severity: 18, State: 1
00:00000:00002:2010/07/29 12:20:40.75 server  Failed to open virtual socket for new connections
00:00000:00002:2010/07/29 12:21:22.85 server  Error: 1605, Severity: 18, State: 1
00:00000:00002:2010/07/29 12:21:22.85 server  Failed to open virtual socket for new connections
00:00000:00002:2010/07/29 12:21:22.85 server  Error: 1605, Severity: 18, State: 1
00:00000:00002:2010/07/29 12:21:22.85 server  Failed to open virtual socket for new connections
01:00000:00002:2010/07/29 12:22:04.87 server  Error: 1605, Severity: 18, State: 1
01:00000:00002:2010/07/29 12:22:04.87 server  Failed to open virtual socket for new connections
01:00000:00002:2010/07/29 12:22:04.87 server  Error: 1605, Severity: 18, State: 1
01:00000:00002:2010/07/29 12:22:04.87 server  Failed to open virtual socket for new connections
00:00000:00002:2010/07/29 12:22:46.87 server  Error: 1605, Severity: 18, State: 1
00:00000:00002:2010/07/29 12:22:46.87 server  Failed to open virtual socket for new connections
00:00000:00002:2010/07/29 12:22:46.87 server  Error: 1605, Severity: 18, State: 1
00:00000:00002:2010/07/29 12:22:46.87 server  Failed to open virtual socket for new connections
00:00000:00002:2010/07/29 12:23:28.87 server  Error: 1605, Severity: 18, State: 1
00:00000:00002:2010/07/29 12:23:28.87 server  Failed to open virtual socket for new connections
00:00000:00002:2010/07/29 12:23:28.87 server  Error: 1605, Severity: 18, State: 1
00:00000:00002:2010/07/29 12:23:28.87 server  Failed to open virtual socket for new connections
00:00000:00002:2010/07/29 12:24:10.89 server  Error: 1605, Severity: 18, State: 1
00:00000:00002:2010/07/29 12:24:10.89 server  Failed to open virtual socket for new connections
00:00000:00002:2010/07/29 12:24:10.89 server  Error: 1605, Severity: 18, State: 1
00:00000:00002:2010/07/29 12:24:10.89 server  Failed to open virtual socket for new connections
00:00000:00002:2010/07/29 12:24:53.00 server  Error: 1605, Severity: 18, State: 1
00:00000:00002:2010/07/29 12:24:53.00 server  Failed to open virtual socket for new connections
00:00000:00002:2010/07/29 12:24:53.00 server  Error: 1605, Severity: 18, State: 1
00:00000:00002:2010/07/29 12:24:53.00 server  Failed to open virtual socket for new connections
01:00000:00002:2010/07/29 12:25:35.00 server  Error: 1605, Severity: 18, State: 1
01:00000:00002:2010/07/29 12:25:35.00 server  Failed to open virtual socket for new connections
01:00000:00002:2010/07/29 12:25:35.00 server  Error: 1605, Severity: 18, State: 1
01:00000:00002:2010/07/29 12:25:35.00 server  Failed to open virtual socket for new connections

论坛徽章:
0
发表于 2010-07-29 12:52 |显示全部楼层
后面三贴是完整的ERRORLOG,
number of open objects 从2000改为4000; number of user connections 从1000改为1200(怕内存不够,不敢多加);看看效果。

论坛徽章:
6
水瓶座
日期:2014-06-04 03:34:37水瓶座
日期:2014-06-17 13:20:31数据库技术版块每日发帖之星
日期:2016-07-09 06:20:00数据库技术版块每日发帖之星
日期:2016-07-17 06:20:00数据库技术版块每日发帖之星
日期:2016-08-01 06:20:00数据库技术版块每日发帖之星
日期:2016-08-04 06:20:00
发表于 2010-07-29 12:54 |显示全部楼层
增加 number of open objects 和 number of user connections 试试

论坛徽章:
0
发表于 2010-07-29 12:56 |显示全部楼层
参数调整后,系统还是有一样的出错:
01:00000:00002:2010/07/29 12:56:35.00 server  Error: 1605, Severity: 18, State: 1
01:00000:00002:2010/07/29 12:56:35.00 server  Failed to open virtual socket for new connections

论坛徽章:
0
发表于 2010-07-29 15:41 |显示全部楼层
参考下这里吧,也许会有帮助

http://manuals.sybase.com/online ... _BookTextView/26529
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

DTCC2020中国数据库技术大会

【架构革新 高效可控】2020年12月21日-23日第十一届中国数据库技术大会将在北京隆重召开。

大会设置2大主会场,20+技术专场,将邀请超百位行业专家,重点围绕数据架构、AI与大数据、传统企业数据库实践和国产开源数据库等内容展开分享和探讨,为广大数据领域从业人士提供一场年度盛会和交流平台。

http://dtcc.it168.com


大会官网>>
  

北京盛拓优讯信息技术有限公司. 版权所有 16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122
中国互联网协会会员  联系我们:huangweiwei@it168.com
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP