为什么这样也能死锁？-CSDN博客

sqshdb1_lmd0_10905.trc

user session for deadlock lock 3e7248910
  pid=49 serial=13 audsid=170909594 user: 67/FORUM
  O/S info: user: trs, term: unknown, ospid: 1234, machine: xhsqlt1
         program: JDBC Thin Client
  application name: JDBC Thin Client, hash value=0
  Current SQL Statement:
  update BBSTHREAD set READCNT=READCNT+1 where ID=:1
user session for deadlock lock 42720b1c8
  pid=36 serial=4 audsid=170909580 user: 67/FORUM
  O/S info: user: trs, term: unknown, ospid: 1234, machine: xhsqlt1
         program: JDBC Thin Client
  application name: JDBC Thin Client, hash value=0
  Current SQL Statement:
  update BBSTHREAD set READCNT=READCNT+1 where ID=:1
ENQUEUE DUMP REQUEST: from 1.13068 on [0xe000c][0x90e6e],[TX] for reason 3 mtype 0
DUMP LOCAL BLOCKER/HOLDER: block level 5 res [0xe000c][0x90e6e],[TX]
----------resource 0x388d86688----------------------
resname    : [0xe000c][0x90e6e],[TX]
Local node : 0
dir_node    : 1
master_node : 1
hv idx       : 89
hv last r.inc : 18
current inc : 28
hv status    : 0
hv master    : 1
open options  : dd
Held mode    : KJUSERNL
Cvt mode    : KJUSEREX
Next Cvt mode : KJUSERNL
msg_seq    : 1
res_seq    : 2
grant_bits : KJUSERNL
grant mode : KJUSERNL  KJUSERCR  KJUSERCW  KJUSERPR  KJUSERPW  KJUSEREX
count       : 11       0       0       0       0       0
val_state    : KJUSERVS_NOVALUE
valblk       : 0x00000000000000000000000000000000 .
access_node : 1
vbreq_state : 0
state       : x8
resp       : 388d86688
On Scan_q? : N
Total accesses: 1235
Imm.  accesses: 1181
Granted_locks : 0
Cvting_locks  : 11
value_block:  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
GRANTED_Q :
CONVERT_Q:
lp 42720b1c8 gl KJUSERNL rl KJUSEREX rp 388d86688 [0xe000c][0x90e6e],[TX]
  master 1 gl owner 427107b90 possible pid 15072 xid 1002-0024-00000002 bast 0 rseq 2 mseq 0 history 0x1495149a
  convert opt KJUSERGETVALUE
lp 3e7248910 gl KJUSERNL rl KJUSEREX rp 388d86688 [0xe000c][0x90e6e],[TX]
  master 1 gl owner 3e70facb0 possible pid 15225 xid 1003-0031-00000005 bast 0 rseq 2 mseq 0 history 0x1495149a
  convert opt KJUSERGETVALUE
lp 3e72bafa0 gl KJUSERNL rl KJUSEREX rp 388d86688 [0xe000c][0x90e6e],[TX]
  master 1 gl owner 3e70f9800 possible pid 15188 xid 1003-0033-00000004 bast 0 rseq 2 mseq 0 history 0x1495149a
  convert opt KJUSERGETVALUE
lp 42720b468 gl KJUSERNL rl KJUSEREX rp 388d86688 [0xe000c][0x90e6e],[TX]
  master 1 gl owner 42710a4f0 possible pid 15268 xid 1001-001E-00000054 bast 0 rseq 2 mseq 0 history 0x1495149a
  convert opt KJUSERGETVALUE
lp 3e7336540 gl KJUSERNL rl KJUSEREX rp 388d86688 [0xe000c][0x90e6e],[TX]
  master 1 gl owner 3e70feac0 possible pid 15276 xid 1002-002F-0000000D bast 0 rseq 2 mseq 0 history 0x1495149a
  convert opt KJUSERGETVALUE
lp 3e72bb240 gl KJUSERNL rl KJUSEREX rp 388d86688 [0xe000c][0x90e6e],[TX]
  master 1 gl owner 3e70fc160 possible pid 15345 xid 1002-002D-00000026 bast 0 rseq 2 mseq 0 history 0x1495149a
  convert opt KJUSERGETVALUE
lp 3e73367e0 gl KJUSERNL rl KJUSEREX rp 388d86688 [0xe000c][0x90e6e],[TX]
  master 1 gl owner 3e70fd610 possible pid 15356 xid 1003-0035-00000008 bast 0 rseq 2 mseq 0 history 0x1495149a
  convert opt KJUSERGETVALUE
lp 3e7248bb0 gl KJUSERNL rl KJUSEREX rp 388d86688 [0xe000c][0x90e6e],[TX]
  master 1 gl owner 3e70f8350 possible pid 15395 xid 1003-0037-00000008 bast 0 rseq 2 mseq 0 history 0x1495149a
  convert opt KJUSERGETVALUE
lp 4272f88a0 gl KJUSERNL rl KJUSEREX rp 388d86688 [0xe000c][0x90e6e],[TX]
  master 1 gl owner 4271066e0 possible pid 15599 xid 1002-0022-0000001D bast 0 rseq 2 mseq 0 history 0x1495149a
  convert opt KJUSERGETVALUE
lp 42727f820 gl KJUSERNL rl KJUSEREX rp 388d86688 [0xe000c][0x90e6e],[TX]
  master 1 gl owner 42710b9a0 possible pid 16285 xid 1002-0020-00000017 bast 0 rseq 2 mseq 0 history 0x1495149a
  convert opt KJUSERGETVALUE
lp 3e7336a80 gl KJUSERNL rl KJUSEREX rp 388d86688 [0xe000c][0x90e6e],[TX]
  master 1 gl owner 3e70f59f0 possible pid 4025 xid 1003-003B-000000AC bast 0 rseq 2 mseq 0 history 0x1495149a
  convert opt KJUSERGETVALUE

谁见过类似的问题？

sqshdb1_lmd0_10905.rar
(2009-06-02 15:49:39, Size: 18 KB, Downloads: 2)