- 论坛徽章:
- 0
|
系统日志中发现错误，请问如何解决
我的前台应用程序是用ＶＢ写的，处理方法如下：
1. 先建立ａｄｏ ｃｏｎｎｅｃｔ
2. 再根据收到的ＳＱＬ语句建立Ａｄｏ Recordset
3. 循环Ｆｉｅｌｄｓ 读出各个字端的值，写入文本文件
现在发生的问题是这样的
1. 程序运行时间不正常，本来应该15秒结束的，会运行5个小时还没有结束
2. 程序结束后（长时间运行），没有写入任何数据，自要我定义分割变量的值 例如 ，，，，这样的格式，正常的是1，2，3，4，5
3. 因为我同时运行这样的多个程序，如果一个程序发生前面描述的错误的话，后面的程序也会同样的不正常
我可以提供的资料
1. 部分源程序（ＶＢ）
AdoConn.Open ConnectString
On Error GoTo OdbcRstErr
'建立记录值
AdoRst.Open Sql, AdoConn, adOpenForwardOnly, adLockReadOnly, adCmdText
If AdoRst.EOF Then
'记录不存在 产生空文件
Open RunInput(7) For Append As #1
Close #1
OdbcCode = -308
Else
'循环读取记录,并写入文件中
Open RunInput(7) For Output As #1
LineNum = 0
Do Until AdoRst.EOF
WriteLine = ""
FieldsNum = 0
For FieldsNum = 0 To AdoRst.Fields.Count - 1
If VarType(AdoRst.Fields(FieldsNum).Value) = vbString Then
FieldContent = Trim(AdoRst.Fields(FieldsNum).Value)
Else
FieldContent = AdoRst.Fields(FieldsNum).Value
End If
If FieldsNum < AdoRst.Fields.Count - 1 Then
If RunInput( = "" Or Trim(RunInput() = 0 Then
WriteLine = WriteLine & FieldContent
Else
WriteLine = WriteLine & FieldContent & ","
End If
Else
WriteLine = WriteLine & FieldContent
End If
Next FieldsNum
Print #1, WriteLine
AdoRst.MoveNext
Loop
Close #1
End If
AdoRst.Close
Set AdoRst = Nothing
AdoConn.Close
Set AdoConn = Nothing
2.服务器端的系统日志
00:00070:00099:2003/06/10 18:10:27.51 kernel Cannot send, host process disconnected: JHPT1 3072 spid: 99
03:00891:00505:2003/06/10 18:21:00.34 kernel Cannot send, host process disconnected: 1160 spid: 505
03:00000:01051:2003/06/11 01:52:19.24 kernel Cannot read, host process disconnected: 1244 spid: 1051
07:00000:00371:2003/06/11 11:25:19.95 kernel Cannot read, host process disconnected: 768 spid: 371
01:00000:00695:2003/06/11 12:33:56.63 kernel Cannot read, host process disconnected: 424 spid: 695
07:00000:01158:2003/06/12 01:36:56.80 kernel Cannot read, host process disconnected: 1440 spid: 1158
02:00000:00772:2003/06/12 01:37:16.89 kernel Cannot read, host process disconnected: 1244 spid: 772
00:00000:00849:2003/06/13 02:02:05.13 kernel Cannot read, host process disconnected: 1244 spid: 849
07:00000:00965:2003/06/13 02:06:14.93 kernel Cannot read, host process disconnected: 1256 spid: 965
3.数据库的配置：
[Configuration Options]
[General Information]
[Backup/Recovery]
recovery interval in minutes = 10
print recovery information = DEFAULT
tape retention in days = DEFAULT
[Cache Manager]
number of oam trips = DEFAULT
number of index trips = DEFAULT
memory alignment boundary = DEFAULT
global async prefetch limit = DEFAULT
global cache partition number = DEFAULT
[Named Cache:default data cache]
cache size = 6000M
cache status = default data cache
cache replacement policy = relaxed LRU replacement
local cache partition number = 8
[4K I/O Buffer Pool]
pool size = 800.0000M
wash size = DEFAULT
local async prefetch limit = DEFAULT
[8K I/O Buffer Pool]
pool size = 200.0000M
wash size = DEFAULT
local async prefetch limit = DEFAULT
[16K I/O Buffer Pool]
pool size = 200.0000M
wash size = DEFAULT
local async prefetch limit = DEFAULT
[Named Cache:infocar_cache]
cache size = 300M
cache status = mixed cache
cache replacement policy = relaxed LRU replacement
local cache partition number = DEFAULT
[4K I/O Buffer Pool]
pool size = 100.0000M
wash size = DEFAULT
local async prefetch limit = DEFAULT
[Named Cache:jjkxxb_cache]
cache size = 500M
cache status = mixed cache
cache replacement policy = relaxed LRU replacement
local cache partition number = 8
[4K I/O Buffer Pool]
pool size = 100.0000M
wash size = DEFAULT
local async prefetch limit = DEFAULT
[Named Cache:rie_cache]
cache size = 500M
cache status = mixed cache
cache replacement policy = relaxed LRU replacement
local cache partition number = 8
[4K I/O Buffer Pool]
pool size = 100.0000M
wash size = DEFAULT
local async prefetch limit = DEFAULT
[Named Cache ykxxb_cache]
cache size = 500M
cache status = mixed cache
cache replacement policy = relaxed LRU replacement
local cache partition number = 8
[4K I/O Buffer Pool]
pool size = 100.0000M
wash size = DEFAULT
local async prefetch limit = DEFAULT
[Meta-Data Caches]
number of open databases = DEFAULT
number of open objects = 1000
open object spinlock ratio = DEFAULT
number of open indexes = 1000
open index hash spinlock ratio = DEFAULT
open index spinlock ratio = DEFAULT
partition groups = DEFAULT
partition spinlock ratio = DEFAULT
[Disk I/O]
disk i/o structures = 2048
number of large i/o buffers = 16
page utilization percent = DEFAULT
number of devices = 30
disable disk mirroring = DEFAULT
allow sql server async i/o = DEFAULT
[Languages]
disable character set conversions = DEFAULT
[Unicode]
enable unicode normalization = DEFAULT
enable surrogate processing = DEFAULT
enable unicode conversions = DEFAULT
size of unilib cache = DEFAULT
[Network Communication]
default network packet size = DEFAULT
max network packet size = 8192
remote server pre-read packets = DEFAULT
number of remote connections = 60
number of remote logins = 50
number of remote sites = 50
max number network listeners = 80
tcp no delay = 1
allow sendmsg = DEFAULT
syb_sendmsg port number = DEFAULT
allow remote access = DEFAULT
[O/S Resources]
max async i/os per engine = DEFAULT
max async i/os per server = DEFAULT
[Parallel Query]
number of worker processes = 200
memory per worker process = 4096
max parallel degree = 3
max scan parallel degree = 3
[Physical Resources]
[Physical Memory]
max memory = 6291456
additional network memory = 2457600
shared memory starting address = DEFAULT
allocate max shared memory = DEFAULT
dynamic allocation on demand = DEFAULT
lock shared memory = DEFAULT
heap memory per user = DEFAULT
[Processors]
max online engines = 8
number of engines at startup = 8
[SQL Server Administration]
procedure cache size = 500000
default database size = DEFAULT
identity burning set factor = DEFAULT
allow nested triggers = DEFAULT
allow updates to system tables = DEFAULT
default fill factor percent = DEFAULT
default exp_row_size percent = DEFAULT
number of mailboxes = DEFAULT
number of messages = DEFAULT
number of alarms = DEFAULT
number of pre-allocated extents = 16
event buffers per engine = DEFAULT
cpu accounting flush interval = DEFAULT
i/o accounting flush interval = DEFAULT
sql server clock tick length = DEFAULT
runnable process search count = 4000
i/o polling process count = 30
time slice = 500
cpu grace time = DEFAULT
number of sort buffers = DEFAULT
size of auto identity column = DEFAULT
identity grab size = DEFAULT
housekeeper free write percent = 4
enable housekeeper GC = DEFAULT
allow resource limits = DEFAULT
number of aux scan descriptors = DEFAULT
SQL Perfmon Integration = DEFAULT
allow backward scans = DEFAULT
license information = DEFAULT
enable sort-merge join and JTC = DEFAULT
abstract plan load = DEFAULT
abstract plan dump = DEFAULT
abstract plan replace = DEFAULT
abstract plan cache = DEFAULT
text prefetch size = DEFAULT
enable HA = DEFAULT
number of histogram steps = DEFAULT
[User Environment]
number of user connections = 200
stack size = 147456
stack guard size = 8192
permission cache entries = DEFAULT
user log cache size = 4096
user log cache spinlock ratio = DEFAULT
[Lock Manager]
number of locks = 500000
deadlock checking period = 700
lock spinlock ratio = DEFAULT
lock address spinlock ratio = DEFAULT
lock table spinlock ratio = DEFAULT
lock hashtable size = DEFAULT
lock scheme = datarows
lock wait period = DEFAULT
read committed with lock = DEFAULT
print deadlock information = DEFAULT
deadlock retries = DEFAULT
page lock promotion HWM = 2000
page lock promotion LWM = DEFAULT
page lock promotion PCT = DEFAULT
row lock promotion HWM = 5000
row lock promotion LWM = DEFAULT
row lock promotion PCT = DEFAULT
[Security Related]
systemwide password expiration = DEFAULT
audit queue size = DEFAULT
curread change w/ open cursors = DEFAULT
allow procedure grouping = DEFAULT
select on syscomments.text = DEFAULT
auditing = DEFAULT
current audit table = DEFAULT
suspend audit when device full = DEFAULT
enable row level access = DEFAULT
check password for digit = DEFAULT
minimum password length = DEFAULT
maximum failed logins = DEFAULT
enable ssl = DEFAULT
unified login required = DEFAULT
use security services = DEFAULT
msg confidentiality reqd = DEFAULT
msg integrity reqd = DEFAULT
secure default login = DEFAULT
[Extended Stored Procedure]
esp unload dll = DEFAULT
esp execution priority = DEFAULT
esp execution stacksize = DEFAULT
xp_cmdshell context = DEFAULT
start mail session = DEFAULT
[Error Log]
event logging = DEFAULT
log audit logon success = DEFAULT
log audit logon failure = DEFAULT
event log computer name = DEFAULT
[Rep Agent Thread Administration]
enable rep agent threads = DEFAULT
[Component Integration Services]
enable cis = DEFAULT
cis connect timeout = DEFAULT
cis bulk insert batch size = DEFAULT
max cis remote connections = DEFAULT
cis packet size = DEFAULT
cis cursor rows = DEFAULT
enable snmp = DEFAULT
enable file access = DEFAULT
cis bulk insert array size = DEFAULT
enable full-text search = DEFAULT
cis rpc handling = DEFAULT
[Java Services]
enable java = DEFAULT
size of process object heap = DEFAULT
size of shared class heap = DEFAULT
size of global fixed heap = DEFAULT
number of java sockets = DEFAULT
enable enterprise java beans = DEFAULT
[DTM Administration]
enable DTM = DEFAULT
enable xact coordination = DEFAULT
xact coordination interval = DEFAULT
number of dtx participants = DEFAULT
strict dtm enforcement = DEFAULT
txn to pss ratio = DEFAULT
dtm lock timeout period = DEFAULT
dtm detach timeout period = DEFAULT
[Diagnostics]
dump on conditions = DEFAULT
maximum dump conditions = DEFAULT
number of ccbs = DEFAULT
caps per ccb = DEFAULT
average cap size = DEFAULT
[Monitoring]
enable monitoring = DEFAULT
sql text pipe active = DEFAULT
sql text pipe max messages = DEFAULT
plan text pipe active = DEFAULT
plan text pipe max messages = DEFAULT
statement pipe active = DEFAULT
statement pipe max messages = DEFAULT
errorlog pipe active = DEFAULT
errorlog pipe max messages = DEFAULT
deadlock pipe active = DEFAULT
deadlock pipe max messages = DEFAULT
wait event timing = DEFAULT
process wait events = DEFAULT
object lockwait timing = DEFAULT
SQL batch capture = DEFAULT
statement statistics active = DEFAULT
per object statistics active = DEFAULT
max SQL text monitored = DEFAULT
请问各位高手，是什么原因产生这中错误的，以及如何解决这个错误 谢谢了 |
|
免费注册
发表于 2003-06-13 11:15
发表于 2003-06-13 11:39
