is not an active process number 问题

romorial

在发现死锁后，想杀死这个锁的进程，结果出现：** is not an active process number ，没有办法只有重启服务了，请问各位老大这种现象是怎么造成的？总是重启服务也不是个办法啊。

WFCJZ

把你日志贴出来,应该有相关的报错,好像是6101错误!

SYBASE官方提出的解决办法:

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

romorial

00:00000:00000:2009/08/25 18:10:32.36 kernel  nrpacket: recv, Connection timed out
00:00000:00000:2009/08/25 18:24:51.55 kernel  nrpacket: recv, Connection timed out
00:00000:00049:2009/08/26 00:29:01.54 kernel  Cannot read, host process disconnected:  2988 spid: 49
00:00000:00099:2009/08/26 08:49:42.86 kernel  Cannot read, host process disconnected:  3736 spid: 99
00:00000:00016:2009/08/26 08:49:42.86 kernel  Cannot read, host process disconnected:  3736 spid: 16
00:00000:00263:2009/08/26 09:08:52.39 kernel  Cannot read, host process disconnected:  3388 spid: 263
00:00000:00250:2009/08/26 09:08:52.39 kernel  Cannot read, host process disconnected:  3388 spid: 250
00:00000:00117:2009/08/26 09:28:41.50 kernel  Cannot read, host process disconnected:  4064 spid: 117
00:00000:00321:2009/08/26 09:28:41.51 kernel  Cannot read, host process disconnected:  4064 spid: 321
00:00000:00208:2009/08/26 10:17:48.96 kernel  Cannot read, host process disconnected:  3164 spid: 208
00:00000:00289:2009/08/26 10:29:50.63 kernel  Cannot read, host process disconnected:  3540 spid: 289
00:00000:00081:2009/08/26 10:32:08.71 kernel  Cannot read, host process disconnected:  424 spid: 81
00:00000:00312:2009/08/26 10:35:03.73 kernel  Cannot read, host process disconnected:  1672 spid: 312
00:00000:00219:2009/08/26 10:35:03.73 kernel  Cannot read, host process disconnected:  1672 spid: 219
00:00000:00276:2009/08/26 10:35:25.60 kernel  Cannot read, host process disconnected:  3412 spid: 276
00:00000:00016:2009/08/26 10:35:37.09 kernel  Cannot read, host process disconnected:  2020 spid: 16
00:00000:00171:2009/08/26 10:36:14.88 kernel  Cannot read, host process disconnected:  2584 spid: 171
00:00000:00093:2009/08/26 10:36:16.21 kernel  Cannot read, host process disconnected:  3736 spid: 93
00:00000:00095:2009/08/26 10:36:18.86 kernel  Cannot read, host process disconnected:  3688 spid: 95
00:00000:00286:2009/08/26 10:37:00.94 kernel  Cannot read, host process disconnected:  1672 spid: 286
00:00000:00330:2009/08/26 10:37:57.99 kernel  Cannot read, host process disconnected:  1276 spid: 330
00:00000:00243:2009/08/26 10:38:24.29 kernel  Cannot read, host process disconnected:  788 spid: 243
00:00000:00089:2009/08/26 10:38:43.01 kernel  Cannot read, host process disconnected:  2056 spid: 89
00:00000:00211:2009/08/26 10:39:34.70 kernel  Cannot read, host process disconnected:  520 spid: 211
00:00000:00184:2009/08/26 10:39:37.68 kernel  Cannot read, host process disconnected:  3192 spid: 184
00:00000:00163:2009/08/26 10:39:38.79 kernel  Cannot read, host process disconnected:  2440 spid: 163
00:00000:00350:2009/08/26 10:39:55.91 kernel  Cannot read, host process disconnected:  3124 spid: 350
00:00000:00214:2009/08/26 10:41:00.72 kernel  Cannot read, host process disconnected:  2768 spid: 214
00:00000:00209:2009/08/26 10:41:23.64 kernel  Cannot read, host process disconnected:  3652 spid: 209
00:00000:00257:2009/08/26 10:42:30.32 kernel  Cannot read, host process disconnected:  2996 spid: 257
00:00000:00087:2009/08/26 10:42:56.82 kernel  Cannot read, host process disconnected:  760 spid: 87
00:00000:00094:2009/08/26 10:43:04.81 kernel  Cannot read, host process disconnected:  2716 spid: 94
00:00000:00048:2009/08/26 10:43:10.84 kernel  Cannot read, host process disconnected:  1684 spid: 48
00:00000:00118:2009/08/26 10:45:22.05 kernel  Cannot read, host process disconnected:  2784 spid: 118
00:00000:00113:2009/08/26 10:46:41.41 kernel  Cannot read, host process disconnected:  2584 spid: 113
00:00000:00200:2009/08/26 10:46:47.92 kernel  Cannot read, host process disconnected:  3156 spid: 200
00:00000:00251:2009/08/26 10:46:48.34 kernel  Cannot read, host process disconnected:  2376 spid: 251
00:00000:00014:2009/08/26 10:47:11.07 kernel  Cannot read, host process disconnected:  1092 spid: 14
00:00000:00301:2009/08/26 10:49:14.99 kernel  Cannot read, host process disconnected:  3152 spid: 301
00:00000:00337:2009/08/26 10:49:37.48 kernel  Cannot read, host process disconnected:  3788 spid: 337

romorial

我觉得与上面这些报错信息有关系，但是不知道是怎么回事？有明白的告诉我一声，是业务程序有问题，还是数据库或者操作系统的问题，老是重启机器也不是个办法啊，呵呵！

chuxu

一般的来说，杀了进程，系统会自动回滚进程涉及的事务，这个时候是必须等待的。

WFCJZ

你贴的是你的客户端连接库中的一些事务处理信息!不应该是你的程序问题吧!

romorial

我也觉得不应该是应用程序的问题，因为同样的程序在其它地方没有出现过类似的情况，需要说明的数据库的版本：12.5 操作系统：SOLARIS 10 不知道与这个有没有关系？

rosehu

注意看日志,这应该与网络有很大关系,频繁启库没用,就象头痒时抓脚一样.

romorial

顶起该贴！

romorial

该问题还没有得到满意的答复