1608错误问题

agui1226

（1）我的sybase是12.0+12445patch，好像不支持这个存储过程，如下：
     Procedure 'sp_monitorconfig', Line 93:
       在本系统存储过程中不支持配置参数 'number of user connections'。
     (return status = 1)
（2）备份日志中只有这样的信息：
Jul 17 21:06:40 2006: 备份服务器: 4.41.1.1: 创建新的磁盘文件/opt/n2000/backup/N2000ServerDB_all/20060717205955/BMSDB.dat。
Jul 17 21:06:40 2006: 备份服务器: 6.28.1.1: 转储文件名'BMSDB061981274C  ', 区域号1安装在磁盘文件 '/opt/n2000/backup/N2000ServerDB_all/20060717205955/BMSDB.dat'上。
Jul 17 21:06:47 2006: 备份服务器: 4.58.1.1: 数据库BMSDB: 15460千字节转储ed
Jul 17 21:06:48 2006: 备份服务器: 4.58.1.1: 数据库BMSDB: 29982千字节转储ed
Jul 17 21:06:50 2006: 备份服务器: 4.58.1.1: 数据库BMSDB: 44504千字节转储ed
Jul 17 21:06:52 2006: 备份服务器: 4.58.1.1: 数据库BMSDB: 58900千字节转储ed
Jul 17 21:06:53 2006: 备份服务器: 4.58.1.1: 数据库BMSDB: 73294千字节转储ed
Jul 17 21:06:55 2006: 备份服务器: 4.58.1.1: 数据库BMSDB: 87816千字节转储ed

好像看不出什么。

jtyhyl

操作系统 win2000  sybase 11.9.2
死时进程只有30个左右
长期以来被困扰，只能通过重启服务器来解决问题

echoaix

把数据库日志贴出来。

jtyhyl

01:00000:00029:2006/07/15 06:23:42.48 kernel  Cannot send, host process disconnected:  1824 spid: 29
00:00000:00019:2006/07/15 06:41:54.68 kernel  Cannot send, host process disconnected:  2132 spid: 19
01:00000:00029:2006/07/15 06:43:12.45 kernel  Cannot send, host process disconnected:  1820 spid: 29
00:00000:00019:2006/07/15 06:55:12.34 kernel  Cannot send, host process disconnected:  2728 spid: 19
01:00000:00019:2006/07/15 07:55:05.23 kernel  Cannot send, host process disconnected:  1088 spid: 19
00:00000:00029:2006/07/15 07:55:05.28 kernel  Cannot send, host process disconnected:  1536 spid: 29
01:00000:00044:2006/07/15 08:06:14.48 kernel  Cannot send, host process disconnected:  272 spid: 44
01:00000:00003:2006/07/15 09:16:46.43 server  Error: 1605, Severity: 18, State: 1
01:00000:00003:2006/07/15 09:16:46.43 server  Failed to open virtual socket for new connections
01:00000:00044:2006/07/15 10:24:31.39 kernel  Cannot send, host process disconnected:  1312 spid: 44
00:00000:00044:2006/07/15 11:28:26.78 kernel  Cannot send, host process disconnected:  1884 spid: 44
00:00000:00027:2006/07/15 11:49:41.65 kernel  Cannot send, host process disconnected:  1640 spid: 27
00:00000:00056:2006/07/15 12:27:38.71 kernel  Cannot send, host process disconnected:  332 spid: 56
00:00000:00056:2006/07/15 12:27:38.73 server  Error: 1608, Severity: 18, State: 4
00:00000:00056:2006/07/15 12:27:38.73 server  A client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
01:00000:00025:2006/07/15 19:06:59.82 kernel  Cannot send, host process disconnected:  9052 spid: 25
01:00000:00052:2006/07/15 20:52:39.54 kernel  Cannot send, host process disconnected:  2068 spid: 52
00:00000:00013:2006/07/16 05:51:10.04 kernel  Cannot send, host process disconnected:  1436 spid: 13
01:00000:00013:2006/07/16 06:41:24.89 kernel  Cannot send, host process disconnected:  1840 spid: 13
01:00000:00013:2006/07/16 06:41:24.89 server  Error: 1608, Severity: 18, State: 4
01:00000:00013:2006/07/16 06:41:24.89 server  A client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
00:00000:00013:2006/07/16 07:08:19.60 kernel  Cannot send, host process disconnected:  500 spid: 13
00:00000:00013:2006/07/16 07:08:19.60 server  Error: 1608, Severity: 18, State: 4
00:00000:00013:2006/07/16 07:08:19.60 server  A client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
00:00000:00028:2006/07/16 08:13:42.76 kernel  Cannot send, host process disconnected:  1800 spid: 28
01:00000:00029:2006/07/16 08:16:35.04 kernel  Cannot send, host process disconnected:  1772 spid: 29
01:00000:00029:2006/07/16 08:16:35.04 server  Error: 1608, Severity: 18, State: 4
01:00000:00029:2006/07/16 08:16:35.04 server  A client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
01:00000:00056:2006/07/16 08:34:21.09 kernel  Cannot send, host process disconnected:  892 spid: 56
00:00000:00056:2006/07/16 08:36:51.07 kernel  Cannot send, host process disconnected:  1032 spid: 56
01:00000:00056:2006/07/16 08:49:52.03 kernel  Cannot send, host process disconnected:  1908 spid: 56
01:00000:00056:2006/07/16 08:49:52.03 server  Error: 1608, Severity: 18, State: 4
01:00000:00056:2006/07/16 08:49:52.03 server  A client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
00:00000:00028:2006/07/16 08:54:56.32 kernel  Cannot send, host process disconnected:  568 spid: 28
01:00000:00028:2006/07/16 08:56:49.93 kernel  Cannot send, host process disconnected:  596 spid: 28
00:00000:00056:2006/07/16 09:08:44.85 kernel  Cannot send, host process disconnected:  1256 spid: 56
00:00000:00056:2006/07/16 09:08:44.85 server  Error: 1608, Severity: 18, State: 4
00:00000:00056:2006/07/16 09:08:44.85 server  A client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
01:00000:00056:2006/07/16 09:11:18.82 kernel  Cannot send, host process disconnected:  1772 spid: 56
01:00000:00056:2006/07/16 09:11:18.82 server  Error: 1608, Severity: 18, State: 4
01:00000:00056:2006/07/16 09:11:18.82 server  A client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
00:00000:00052:2006/07/16 09:18:01.17 kernel  Cannot send, host process disconnected:  568 spid: 52
00:00000:00058:2006/07/16 09:19:35.76 kernel  Cannot send, host process disconnected:  1104 spid: 58
00:00000:00058:2006/07/16 09:19:35.76 server  Error: 1608, Severity: 18, State: 4
00:00000:00058:2006/07/16 09:19:35.76 server  A client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
00:00000:00056:2006/07/16 09:24:27.31 kernel  Cannot send, host process disconnected:  1764 spid: 56
00:00000:00056:2006/07/16 09:24:27.31 server  Error: 1608, Severity: 18, State: 4
00:00000:00056:2006/07/16 09:24:27.31 server  A client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
00:00000:00029:2006/07/16 09:27:05.12 kernel  Cannot send, host process disconnected:  1940 spid: 29
00:00000:00029:2006/07/16 09:27:05.12 server  Error: 1608, Severity: 18, State: 4
00:00000:00029:2006/07/16 09:27:05.12 server  A client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
01:00000:00013:2006/07/16 09:35:28.96 kernel  Cannot send, host process disconnected:  2064 spid: 13
01:00000:00013:2006/07/16 09:35:28.96 server  Error: 1608, Severity: 18, State: 4
01:00000:00013:2006/07/16 09:35:28.96 server  A client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
01:00000:00003:2006/07/16 09:37:46.31 server  Error: 1605, Severity: 18, State: 1
01:00000:00003:2006/07/16 09:37:46.31 server  Failed to open virtual socket for new connections
00:00000:00013:2006/07/16 09:58:53.75 kernel  Cannot send, host process disconnected:  1892 spid: 13
00:00000:00013:2006/07/16 09:58:53.75 server  Error: 1608, Severity: 18, State: 4
00:00000:00013:2006/07/16 09:58:53.75 server  A client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
00:00000:00029:2006/07/16 10:05:17.21 kernel  Cannot send, host process disconnected:  1772 spid: 29
00:00000:00029:2006/07/16 10:05:17.21 server  Error: 1608, Severity: 18, State: 4
00:00000:00029:2006/07/16 10:05:17.21 server  A client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
01:00000:00019:2006/07/16 10:10:23.85 kernel  Cannot send, host process disconnected:  2128 spid: 19
01:00000:00019:2006/07/16 10:10:23.85 server  Error: 1608, Severity: 18, State: 4
01:00000:00019:2006/07/16 10:10:23.85 server  A client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
00:00000:00058:2006/07/16 10:13:27.00 kernel  Cannot send, host process disconnected:  320 spid: 58
01:00000:00054:2006/07/16 10:28:25.89 kernel  Cannot send, host process disconnected:  2332 spid: 54
01:00000:00054:2006/07/16 10:28:25.90 server  Error: 1608, Severity: 18, State: 4
01:00000:00054:2006/07/16 10:28:25.90 server  A client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
01:00000:00029:2006/07/16 10:28:39.29 kernel  Cannot send, host process disconnected:  996 spid: 29
00:00000:00019:2006/07/16 10:31:04.78 kernel  Cannot send, host process disconnected:  2024 spid: 19
00:00000:00019:2006/07/16 10:31:04.78 server  Error: 1608, Severity: 18, State: 4
00:00000:00019:2006/07/16 10:31:04.78 server  A client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
00:00000:00054:2006/07/16 10:46:06.23 kernel  Cannot send, host process disconnected:  1904 spid: 54
01:00000:00025:2006/07/16 10:57:38.59 kernel  Cannot send, host process disconnected:  1864 spid: 25
01:00000:00025:2006/07/16 10:57:38.59 server  Error: 1608, Severity: 18, State: 4
01:00000:00025:2006/07/16 10:57:38.59 server  A client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
01:00000:00057:2006/07/16 11:00:47.31 kernel  Cannot send, host process disconnected:  1420 spid: 57
01:00000:00057:2006/07/16 11:00:47.32 server  Error: 1608, Severity: 18, State: 4
01:00000:00057:2006/07/16 11:00:47.32 server  A client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
00:00000:00013:2006/07/16 11:04:05.09 kernel  Cannot send, host process disconnected:  1648 spid: 13
00:00000:00013:2006/07/16 11:04:05.09 server  Error: 1608, Severity: 18, State: 4
00:00000:00013:2006/07/16 11:04:05.09 server  A client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
00:00000:00013:2006/07/16 11:07:34.85 kernel  Cannot send, host process disconnected:  512 spid: 13
00:00000:00013:2006/07/16 11:07:34.85 server  Error: 1608, Severity: 18, State: 4
00:00000:00013:2006/07/16 11:07:34.85 server  A client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
00:00000:00054:2006/07/16 11:21:28.71 kernel  Cannot send, host process disconnected:  1312 spid: 54
01:00000:00034:2006/07/16 11:29:47.79 kernel  Cannot send, host process disconnected:  1636 spid: 34
01:00000:00034:2006/07/16 11:29:47.79 server  Error: 1608, Severity: 18, State: 4
01:00000:00034:2006/07/16 11:29:47.79 server  A client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
01:00000:00013:2006/07/16 11:30:31.15 kernel  Cannot send, host process disconnected:  1308 spid: 13
00:00000:00013:2006/07/16 11:34:24.81 kernel  Cannot send, host process disconnected:  1504 spid: 13
00:00000:00013:2006/07/16 11:34:24.82 server  Error: 1608, Severity: 18, State: 4
00:00000:00013:2006/07/16 11:34:24.82 server  A client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
01:00000:00014:2006/07/16 11:45:51.57 kernel  Cannot send, host process disconnected:  1476 spid: 14
00:00000:00027:2006/07/16 11:49:12.82 kernel  Cannot send, host process disconnected:  1476 spid: 27
00:00000:00027:2006/07/16 11:49:12.82 server  Error: 1608, Severity: 18, State: 4
00:00000:00027:2006/07/16 11:49:12.82 server  A client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
00:00000:00014:2006/07/16 11:58:46.81 kernel  Cannot send, host process disconnected:  1756 spid: 14
00:00000:00014:2006/07/16 12:22:27.42 kernel  Cannot send, host process disconnected:  1896 spid: 14
00:00000:00014:2006/07/16 12:22:27.42 server  Error: 1608, Severity: 18, State: 4
00:00000:00014:2006/07/16 12:22:27.42 server  A client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
00:00000:00014:2006/07/16 12:24:24.59 kernel  Cannot send, host process disconnected:  1752 spid: 14
00:00000:00014:2006/07/16 12:24:24.59 server  Error: 1608, Severity: 18, State: 4
00:00000:00014:2006/07/16 12:24:24.59 server  A client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
00:00000:00028:2006/07/16 12:43:18.73 kernel  Cannot send, host process disconnected:  1756 spid: 28
00:00000:00028:2006/07/16 12:43:18.73 server  Error: 1608, Severity: 18, State: 4
00:00000:00028:2006/07/16 12:43:18.73 server  A client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
01:00000:00013:2006/07/16 12:54:17.73 kernel  Cannot send, host process disconnected:  1476 spid: 13
01:00000:00013:2006/07/16 12:54:17.73 server  Error: 1608, Severity: 18, State: 4
01:00000:00013:2006/07/16 12:54:17.73 server  A client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
01:00000:00017:2006/07/16 13:13:05.40 kernel  Cannot send, host process disconnected:  2132 spid: 17
01:00000:00034:2006/07/16 13:20:12.64 kernel  Cannot send, host process disconnected:  1240 spid: 34
00:00000:00028:2006/07/16 13:56:01.85 kernel  Cannot send, host process disconnected:  844 spid: 28
01:00000:00034:2006/07/16 13:56:20.23 kernel  Cannot send, host process disconnected:  1780 spid: 34
01:00000:00034:2006/07/16 13:56:20.23 server  Error: 1608, Severity: 18, State: 4
01:00000:00034:2006/07/16 13:56:20.23 server  A client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
00:00000:00029:2006/07/16 13:56:38.12 kernel  Cannot send, host process disconnected:  1876 spid: 29
00:00000:00052:2006/07/16 14:07:10.98 kernel  Cannot send, host process disconnected:  1836 spid: 52
00:00000:00052:2006/07/16 14:07:10.98 server  Error: 1608, Severity: 18, State: 4
00:00000:00052:2006/07/16 14:07:10.98 server  A client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
00:00000:00029:2006/07/16 14:12:47.21 kernel  Cannot send, host process disconnected:  1504 spid: 29
00:00000:00029:2006/07/16 14:12:47.21 server  Error: 1608, Severity: 18, State: 4
00:00000:00029:2006/07/16 14:12:47.21 server  A client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
01:00000:00025:2006/07/16 14:17:53.31 kernel  Cannot send, host process disconnected:  2112 spid: 25
00:00000:00052:2006/07/16 14:19:13.15 kernel  Cannot send, host process disconnected:  1736 spid: 52
00:00000:00052:2006/07/16 14:19:13.15 server  Error: 1608, Severity: 18, State: 4
00:00000:00052:2006/07/16 14:19:13.15 server  A client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
00:00000:00052:2006/07/16 14:21:19.09 kernel  Cannot send, host process disconnected:  2136 spid: 52
00:00000:00052:2006/07/16 14:21:19.09 server  Error: 1608, Severity: 18, State: 4
00:00000:00052:2006/07/16 14:21:19.09 server  A client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
00:00000:00017:2006/07/16 14:21:19.09 kernel  Cannot send, host process disconnected:  356 spid: 17
00:00000:00017:2006/07/16 14:21:19.09 server  Error: 1608, Severity: 18, State: 4
00:00000:00017:2006/07/16 14:21:19.09 server  A client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
00:00000:00057:2006/07/16 14:29:14.93 kernel  Cannot send, host process disconnected:  976 spid: 57
00:00000:00057:2006/07/16 14:29:14.93 server  Error: 1608, Severity: 18, State: 4
00:00000:00057:2006/07/16 14:29:14.93 server  A client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
01:00000:00025:2006/07/16 14:29:44.54 kernel  Cannot send, host process disconnected:  300 spid: 25
01:00000:00025:2006/07/16 14:29:44.54 server  Error: 1608, Severity: 18, State: 4
01:00000:00025:2006/07/16 14:29:44.54 server  A client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
00:00000:00034:2006/07/16 14:55:10.53 kernel  Cannot send, host process disconnected:  1636 spid: 34
00:00000:00034:2006/07/16 14:55:10.53 server  Error: 1608, Severity: 18, State: 4
00:00000:00034:2006/07/16 14:55:10.53 server  A client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
00:00000:00014:2006/07/16 15:13:23.25 kernel  Cannot send, host process disconnected:  1692 spid: 14
00:00000:00014:2006/07/16 15:13:23.25 server  Error: 1608, Severity: 18, State: 4
00:00000:00014:2006/07/16 15:13:23.25 server  A client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
00:00000:00052:2006/07/16 15:26:25.50 kernel  Cannot send, host process disconnected:  1584 spid: 52

jtyhyl

真见鬼，现在只让贴2W字

小无赖

把max number network listeners设大点试试.

把sql.ini文件贴出来看看

agui1226

有个方法可以试一下：
以文本编辑器方式打开/opt/sybase/ASE-12_0/install/RUN_<servername>文件，
在文件的开头加上如下命令：
LD_LIBRARY_PATH=/usr/lib/lwpLD_LIBRARY_PATH
LD_LIBRARY_PATH_64=/usr/lib/lwp/64LD_LIBRARY_PATH_64
export LD_LIBRARY_PATH LD_LIBRARY_PATH_64
在文件的末尾添加一行：
-T1631 -T1633\
增加完后，保存退出。

aliking

看样子很可能是进程死锁引起的，出现这个问题时，用sp_lock看看锁定了哪些数据库对象（此时可能执行比较慢，要等会儿）。

tdhlu

没有死锁，我们这也是这种情况，特别多

tdhlu

有个方法可以试一下：
以文本编辑器方式打开/opt/sybase/ASE-12_0/install/RUN_<servername>文件，
在文件的开头加上如下命令：
LD_LIBRARY_PATH=/usr/lib/lwpLD_LIBRARY_PATH
LD_LIBRARY_PATH_64=/usr/lib/lwp/64LD_LIBRARY_PATH_64
export LD_LIBRARY_PATH LD_LIBRARY_PATH_64
在文件的末尾添加一行：
-T1631 -T1633\
增加完后，保存退出。


-T1631 -T1633\ 是什么意思啊